Comment 8 for bug 326768

Revision history for this message
barney_1 (szczys) wrote : Re: mysql thinks it has crashed when it hasn't

I believe I am also encountering this bug. Running Mythbuntu 9.04 Beta I find my recording schedule on mythtv is empty after reboot. Running mythtv-setup, removing all encoder cards and adding them again fixes this.

Output of "cat syslog | grep mysqld":

Apr 19 11:54:05 barney mysqld[3497]: 090419 11:54:05 [Note] /usr/sbin/mysqld: Normal shutdown
Apr 19 11:54:05 barney mysqld[3497]:
Apr 19 11:54:07 barney mysqld[3497]: 090419 11:54:07 InnoDB: Starting shutdown...
Apr 19 11:54:08 barney mysqld[3497]: 090419 11:54:08 InnoDB: Shutdown completed; log sequence number 0 150426
Apr 19 11:54:08 barney mysqld[3497]: 090419 11:54:08 [Note] /usr/sbin/mysqld: Shutdown complete
Apr 19 11:54:08 barney mysqld[3497]:
Apr 19 11:54:08 barney mysqld_safe[5352]: ended
Apr 19 11:54:48 barney kernel: [ 11.333672] type=1505 audit(1240160086.411:8): operation="profile_load" name="/usr/sbin/mysqld" name2="default" pid=1969
Apr 19 11:54:49 barney mysqld_safe[2496]: started
Apr 19 11:54:49 barney mysqld[2500]: 090419 11:54:49 InnoDB: Started; log sequence number 0 150426
Apr 19 11:54:50 barney mysqld[2500]: 090419 11:54:50 [Note] /usr/sbin/mysqld: ready for connections.
Apr 19 11:54:50 barney mysqld[2500]: Version: '5.0.75-0ubuntu10' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Apr 19 11:55:03 barney mysqld_safe[3605]: Number of processes running now: 1
Apr 19 11:55:03 barney mysqld_safe[3613]: mysqld process hanging, pid 2498 - killed
Apr 19 11:55:03 barney mysqld_safe[3616]: restarted
Apr 19 11:55:03 barney mysqld[3620]: InnoDB: The log sequence number in ibdata files does not match
Apr 19 11:55:03 barney mysqld[3620]: InnoDB: the log sequence number in the ib_logfiles!
Apr 19 11:55:03 barney mysqld[3620]: 090419 11:55:03 InnoDB: Database was not shut down normally!
Apr 19 11:55:03 barney mysqld[3620]: InnoDB: Starting crash recovery.
Apr 19 11:55:03 barney mysqld[3620]: InnoDB: Reading tablespace information from the .ibd files...
Apr 19 11:55:03 barney mysqld[3620]: InnoDB: Restoring possible half-written data pages from the doublewrite
Apr 19 11:55:03 barney mysqld[3620]: InnoDB: buffer...
Apr 19 11:55:03 barney mysqld[3620]: 090419 11:55:03 InnoDB: Started; log sequence number 0 150436
Apr 19 11:55:03 barney mysqld[3620]: 090419 11:55:03 [Note] /usr/sbin/mysqld: ready for connections.
Apr 19 11:55:03 barney mysqld[3620]: Version: '5.0.75-0ubuntu10' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)