Wayne, please send me the whole MySQL error log.
Looks like some thread, which had reserved the InnoDB 'kernel' mutex to access the InnoDB lock table, got stuck. This is interesting: " 5 queries inside InnoDB, 0 queries in queue; main thread: doing background drop tables " If you drop a table where there still are queries running, then InnoDB delays the drop table until the queries have ended, and only after that drops the table. When dropping the table, InnoDB has to remove also any locks there are on the table. The code is not that well tested. The bug might be there. What DROP TABLE and what queries could have been involved? Do you have very many tables? Does SHOW TABLE STATUS take long? Are you sure you ran innodb_monitor and not innodb_lock_monitor? Can you repeat the bug? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Copied message: .............. Subject: InnoDB hard lockup From: Wayne Lewis Date: Thu, 3 Oct 2002 08:48:26 -0700 ---------------------------------------------------------------------------- ---- Hi All, First thanks to all who worked on InnoDB, it is truely exciting to get its features in an open-source DB. We've had an excellent experience thus far with a few exceptions. Any help on solving the problem below is greatly appreciated ... We experienced a hard lockup a few days ago with mysql-max-3.23.52 for Solaris 2.7. The DB had been running very well for over a month until the innodb_monitor was turned on. After turning it on, all InnoDB threads blocked within a few minutes, and we saw the messages below in the error log. The only other info that may seem relevent is that we have a monitor that executes "show table status" every 15 minutes to check for remaining space in the InnoDB tablespace. That monitor does not run in our test environment and we never had a problem with the innodb monitor in our test environment while executing a similar workload. So this problem may be correlated or caused by the "show table status" command in conjunction with the innodb monitor. Any thoughts? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
