Results 1 to 4 of 4

Thread: Mysql.server do not start later power failure

  1. #1
    Join Date
    Aug 2009
    Posts
    31
    Rep Power
    6

    Default Mysql.server do not start later power failure

    Hi all, yesterday i've a power failure and wuhen the system start the mysql server do not start but when a try to start it manually i seen the following erros:

    mysql.server start && tail -f ~/log/mysql_error.log
    091117 09:05:41 mysqld started
    InnoDB: Log scan progressed past the checkpoint lsn 0 3127641580
    091117 9:05:42 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...
    InnoDB: Error: tried to read 16384 bytes at offset 0 901120.
    InnoDB: Was only able to read -1.
    091117 9:05:58 InnoDB: Operating system error number 5 in a file operation.
    InnoDB: Error number 5 means 'Input/output error'.
    InnoDB: Some operating system error numbers are described at
    InnoDB: MySQL :: MySQL 5.0 Reference Manual :: 13.2.12.2 Operating System Error Codes
    InnoDB: File operation call: 'read'.
    InnoDB: Cannot continue operation.
    091117 09:05:58 mysqld ended


    Do you have any solution?

    Thanks in advance

    Hermidio

  2. #2
    Join Date
    May 2008
    Posts
    432
    Rep Power
    7

    Default

    You might try the MySQL repair guide in the Wiki.

  3. #3
    Join Date
    May 2008
    Posts
    432
    Rep Power
    7

  4. #4
    Join Date
    Aug 2009
    Posts
    31
    Rep Power
    6

    Default there's no way to start mysql

    i try the six levels and no way to start it.

    i've a backup from 24 hours ago, it's posible to restore from mysql tables to the actuall scenario?

    Thanks in advance

    Hermidio

Similar Threads

  1. Errors installing Outlook Connector
    By Tim G in forum Zimbra Connector for Outlook
    Replies: 57
    Last Post: 05-05-2011, 03:27 PM
  2. Replies: 7
    Last Post: 02-03-2011, 07:01 AM
  3. ZCS: mysql.server will NOT start
    By jstlouis in forum Administrators
    Replies: 4
    Last Post: 04-06-2009, 01:50 PM
  4. Error Installing Outlook Connector
    By DanO in forum Zimbra Connector for Outlook
    Replies: 17
    Last Post: 08-28-2007, 10:35 AM
  5. Is it started or not
    By kwelipatton in forum Installation
    Replies: 10
    Last Post: 03-28-2006, 11:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •