cause for mysql crash
Posted
by
user1322092
on Server Fault
See other posts from Server Fault
or by user1322092
Published on 2012-12-15T17:28:05Z
Indexed on
2012/12/15
23:06 UTC
Read the original article
Hit count: 185
mysql
A cron job automatically restarted my mysql database. What's the cause for the crash, or can you suggest how to resolve or monitor.
I would REALLY appreciate your input.
120715 14:38:58 mysqld started
120715 14:38:58 InnoDB: Started; log sequence number 0 411137570
120715 14:38:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.95' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
120715 15:14:21 [Note] /usr/libexec/mysqld: Normal shutdown
120715 15:14:23 InnoDB: Starting shutdown...
120715 15:14:25 InnoDB: Shutdown completed; log sequence number 0 411166467
120715 15:14:25 [Note] /usr/libexec/mysqld: Shutdown complete
120715 08:14:25 mysqld ended
120715 08:14:26 mysqld started
120715 8:14:26 InnoDB: Started; log sequence number 0 411166467
120715 8:14:26 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.95' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
121212 09:15:32 mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
121212 9:15:58 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...
121212 9:17:28 InnoDB: Started; log sequence number 0 554145193
121212 9:17:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.95' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
© Server Fault or respective owner