[Bug 621509] Re: mysqld randomly causes system to not respond to commands
Clint, I appreciate your assistance with this but I am sorry to say that I believe I've wasted your time. I did some intensive digging on this and discovered that all signs point to a hardware issue on one of the SCSI buses. MySQL appeared to be the trigger; with the most disk writes/reads. It looks as if a hard drive might be going south. I receive a fatal error message when attempting to run OpenBoot tests on the SCSI bus. Which, in retrospect, makes sense as to why occasionally I would experience a hardware hang on reboots every now and again as well as why a hard boot seems to be the only way to recover. Either way, my new system will be resolving these errors. Again, I appreciate your prompt responses and I apologize for wasting your time. This ticket is null and void as pertaining to mysql-5.1. -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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 621509] Re: mysqld randomly causes system to not respond to commands
Luke, thanks for keeping us up to date! While your configuration is a little bit weird, it still sounds like there may be a legitimate bug in mysql, as it should not be able to cause such a huge problem for the system. That said, I would suspect that cacti needs to *not* run two of its collectors at a time, and you may be running into some kind of deadlock where one cacti thread is waiting for a lock that the other one has while waiting for a lock that another has that is waiting for the first. Beacause of the introduction of spine, and the lack of ability to reproduce it reliably, I'm going to go ahead and close this as Invalid. Please do open a new bug if you continue to have issues on 10.04, and good luck with your migration! ** Changed in: mysql-5.1 (Ubuntu) Status: Incomplete = Invalid -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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 621509] Re: mysqld randomly causes system to not respond to commands
Clint, the last time this happened, I watched the system attempt to reboot when issued from command line via console. It appears the reboot sequence hangs on attempting to halt mysqld. As far as I can tell, I belive something in conjuction with Cacti and MySQL is causing this problem. It seems to happen when Cacti is still waiting for a response from a busy client it is monitoring and then the poller fires up another check while the one prior is still waiting. Once enough of these get backed up, it does something to cause mysqld to go rogue and that's when my problems start. I might also add that I have spine running with Cacti which was not a default package for 8.04. Thus, I pulled down spine from the 8.10 respositories as well as all the necessary dependencies. I fear this might be the root cause. Either way, I am planning on replacing this system all together with a new one, at which time it will run 10.04. So in short, I believe something I did might be causing this. Once I port my configs over to the new system, I shall see if the problem follows. -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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 621509] Re: mysqld randomly causes system to not respond to commands
Clint, please see the attached file ps-auxwww.txt. -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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 621509] Re: mysqld randomly causes system to not respond to commands
** Attachment added: ps-auxwww.txt https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/621509/+attachment/1579438/+files/ps-auxwww.txt ** Changed in: mysql-5.1 (Ubuntu) Status: Incomplete = New -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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 621509] Re: mysqld randomly causes system to not respond to commands
Also, when I renice the process, I get back enough response that someitmes I do not need to hard boot it. -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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 621509] Re: mysqld randomly causes system to not respond to commands
Luke, thanks for the response. Looking at your process listing, it looks pretty normal. There's really nothing to indicate there that the system is unstable in any way. Is there anything else you can give us to help build a repeatable test case? Kernel logs, syslogs, etc? I'm marking this Incomplete again, as I don't see how users can ascertain that they are experiencing the same problem. If you can come up with something that causes it to happen (even just before/after log entries showing something that happened to cause it) then we can take another look. ** Changed in: mysql-5.1 (Ubuntu) Status: New = Incomplete -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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 621509] Re: mysqld randomly causes system to not respond to commands
Hi Luke, Have you tried renicing mysqld? renice 5 4589 This may give your other commands some priority over mysqld so they can continue to log and help you diagnose the problem. Please try that, and then on the next system lockup/slowdown, run 'ps auxwww' and paste or upload the output here. Marking incomplete pending response from Luke. Luke, once you've posted the output of 'ps auxwww', please mark this bug 'New' again so it does not get removed automatically. ** Changed in: mysql-5.1 (Ubuntu) Status: New = Incomplete -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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 621509] Re: mysqld randomly causes system to not respond to commands
Thanks, Clint. Will do. -- mysqld randomly causes system to not respond to commands https://bugs.launchpad.net/bugs/621509 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 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