unable to start mysql55 service

Posted on 2014-08-12
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: 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
Question by:AxISQS
    LVL 19

    Accepted Solution

    Did you consider restoring MySQL on another guest?

    Author Comment

    I dont really have the resources to bring up another guest.
    LVL 19

    Expert Comment

    Do you run regular (scheduled) snapshots (or backups) of the guest?

    Author Comment

    negative.  its backed up using symantec system restore.  I think thats due to esxi being the free version.

    Author Comment

    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.

    Author Comment

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now