[Bug 326768] Re: mysql thinks it has crashed when it hasn't
Barney - could you clarify your comment for me? You say Running mythtv-setup, removing all encoder cards and adding them again fixes this. Is this a permanent fix, or does the problem recur if you reboot? If this is only a fix for that boot, there are easier ones. Anything that causes mythbackend to force a reschedule is a temporary fix (this includes restarting mythbackend, or just marking a new show to be recorded). -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 326768] 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) -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 326768] Re: mysql thinks it has crashed when it hasn't
Since I upgraded to Jaunty RC, my mythtv database gets corrupted after almost every new boot. This results into a confused mythtv-backend which fails to record the scheduled recordings. After a repair table command everything returns back as normal. I'm trying the wait fix mentioned above, hope to get some good results. -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 326768] Re: mysql thinks it has crashed when it hasn't
** Also affects: mythbuntu Importance: Undecided Status: New -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 326768] Re: mysql thinks it has crashed when it hasn't
Adding mythbuntu. It seems to me that the wait should make things more reliable and predictable rather than less, so I must be missing something. Any danger in removing the wait? ** Changed in: mythbuntu Importance: Undecided = Critical ** Changed in: mythbuntu Status: New = Confirmed ** Changed in: mythbuntu Milestone: None = jaunty-rc -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 326768] Re: mysql thinks it has crashed when it hasn't
Yeah - it looks to me like Bug 358173 is the same bug. I find it very strange that this bug only affects mythbackend (all the possible duplicates seem to reference mythtv). I suspect that it is doing something strange. I reported a mysql bug because I figured that the mysql server shouldn't behave strangely even if the client program does weird things. -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 326768] Re: mysql thinks it has crashed when it hasn't
Bug 358173 may be a duplicate of this. Thanks to the original reporter for proposing a solution. ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Incomplete = Confirmed -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 326768] Re: mysql thinks it has crashed when it hasn't
Thank you for taking the time to report this bug and helping to make Ubuntu better. When you're running into the issue, does mysqld_safe takes up 100% of the cpu? ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: New = Incomplete -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 326768] Re: mysql thinks it has crashed when it hasn't
I can confirm this behavior. -- mysql thinks it has crashed when it hasn't https://bugs.launchpad.net/bugs/326768 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs