[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

unable to start mysql55 service

Posted on 2014-08-12
6
Medium Priority
?
747 Views
Last Modified: 2014-08-13
When I browse to my website, I'm seeing "Database connection error (2): Could not connect to MySQL."  I notice the MySQL55 service is not running, and will not start "error 1053: the service did not respond to the start or control request in a timely fashion."  I dig down into the MySQL directory and bring up the .err file.  it shows the following:

140812 16:08:40 [Note] Plugin 'FEDERATED' is disabled.
140812 16:08:40 InnoDB: The InnoDB memory heap is disabled
140812 16:08:40 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140812 16:08:40 InnoDB: Compressed tables use zlib 1.2.3
140812 16:08:40 InnoDB: Initializing buffer pool, size = 114.0M
140812 16:08:40 InnoDB: Completed initialization of buffer pool
140812 16:08:40 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 7527695018
140812 16:08:40  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140812 16:12:42  InnoDB: Operating system error number 1117 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.


This is a VMware esxi guest.  MySQL has worked until just recently.  What do I need to do?  Thanks
0
Comment
Question by:AxISQS
  • 4
  • 2
6 Comments
 
LVL 20

Accepted Solution

by:
strivoli earned 2000 total points
ID: 40257874
Did you consider restoring MySQL on another guest?
0
 

Author Comment

by:AxISQS
ID: 40258076
I dont really have the resources to bring up another guest.
0
 
LVL 20

Expert Comment

by:strivoli
ID: 40258082
Do you run regular (scheduled) snapshots (or backups) of the guest?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:AxISQS
ID: 40258164
negative.  its backed up using symantec system restore.  I think thats due to esxi being the free version.
0
 

Author Comment

by:AxISQS
ID: 40259252
I've resolved my problem.  all indication is that MySQL 1117 error points to hardware failure.  basically, I cleared out resources on a different vm host, and used VMware converter to move my vm from the bad host to the new host.
0
 

Author Comment

by:AxISQS
ID: 40259259
I've requested that this question be closed as follows:

Accepted answer: 0 points for AxISQS's comment #a40259252
Assisted answer: 500 points for strivoli's comment #a40257874

for the following reason:

found solution myself
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month18 days, 11 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question