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

Filed under:

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

Related posts about mysql