I see its busy today, lots of new threads.
Hopefully this one will be easy
Got this error this morning. We did upgrade to 5.0.8 on 24/7/08 without any problems or errors
Ahh!! now I remember the server shutdown after power outage and ups ran out ( happened over weekend and I am looking into graceful shutdowns in future)
How can I recover from this?
Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=password_removed
warning : 1 client is using or hasn't closed the table properly
The mysql_error. log reads
[root@mail log]$ more mysql_error.log
080810 23:13:22 mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
080810 23:13:23 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
080810 23:13:56 InnoDB: Started; log sequence number 1 2682440946
080810 23:13:56 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '5.0.51a-log' socket: '/opt/zimbra/db/mysql.sock' port: 7306 Source distribution