Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Administrators

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-17-2009, 07:04 AM
Active Member
 
Posts: 31
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
Reply With Quote
  #2 (permalink)  
Old 11-17-2009, 09:37 AM
Partner (VAR/HSP)
 
Posts: 421
Default

You might try the MySQL repair guide in the Wiki.
Reply With Quote
  #3 (permalink)  
Old 11-17-2009, 09:38 AM
Partner (VAR/HSP)
 
Posts: 421
Default

Mysql Crash Recovery - Zimbra :: Wiki
Reply With Quote
  #4 (permalink)  
Old 11-17-2009, 10:54 AM
Active Member
 
Posts: 31
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com




 

SEO by vBSEO ©2011, Crawlability, Inc.