Hi,
Something is blocking our table (BOOKS) in a database that we don't have administrative rights to. (we rent from Hurricane Electric, www.he.net). Everytime we query the table it gets in the processlist with the state "Waiting for table". We've killed every process in the processlist but we still aren't able to query the table. Even if we just do a "SHOW COLUMNS FROM BOOKS" it gets in the processlist. mysql> show processlist; +--------+----------+----------------------------------+----------+---------+------+-------------------+-------------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+----------+----------------------------------+----------+---------+------+-------------------+-------------------------+ | 188428 | triplese | localhost | triplese | Query | 0 | NULL | show processlist | | 192458 | triplese | c213-200-186-83.cm-upc.chello.se | triplese | Query | 6 | Waiting for table | show columns from BOOKS | +--------+----------+----------------------------------+----------+---------+------+-------------------+-------------------------+ 2 rows in set (0.00 sec) We have other tables in the database. And they work fine. The characteristics of the BOOKS table is that it's larger than the other ones (however that's not a reason to lock, is it?). We need help to locate what's causing this problem. Our website is down since it's depending on the BOOKS-table. / Jacob _________________________________________________________________ Skicka och ta emot Hotmail-meddelanden på din mobilenhet: http://mobile.msn.com --------------------------------------------------------------------- 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
