I was wondering if someone could tell me what "Waiting on cond" meant in a process state. We have a build system that is continuously running our unit test suite over new checkins. Earlier today I got an alert that steps were beginning to timeout. I looked into it and in each case it (the build step) was hanging while trying to drop our database.
I did a mysqladmin process and got the following: +----+------+----------------------------------+----+---------+------+------ -----------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+----------------------------------+----+---------+------+------ -----------+-----------------------+ | 3 | ODBC | localhost | | Query | 2397 | Waiting on cond | drop database `ebxml` | | 11 | root | ltbhuddleston.betweenmarkets.com | | Query | 443 | | drop database `ebxml` | | 12 | root | 10.66.77.105 | | Query | 0 | | show processlist | +----+------+----------------------------------+----+---------+------+------ -----------+-----------------------+ This "Waiting on cond" is a new one on me. It will stay in this state for about an hour (at which point our build software kills everything and goes on to the next module). -Brian --------------------------------------------------------------------- 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
