Hello. Posting in 2 hour intervals is a perfect way of getting ignored on the list. This is a list of volunteers. If you require a quick answer, consider buying support.
That said, "waiting for table" does not indicate normal table locks. That would be "locked". So something different is going on. And this is explained, as is to be expected, in the manual under "show processlist": http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html The same page explains that you need to have the 'process' privilege to be able to see all processes. Maybe the used login doesn't have it and therefore you are not seeing all queries? Bye, Benjamin. On Sat, May 11, 2002 at 02:01:08PM +0000, [EMAIL PROTECTED] wrote: > > One of our table is locked and there is not a process in the processlist. > How can I find out why? I want to start use the table again. Our website is > down! I've tried to flush the table but I don't have enough priveliges to > execute that command... [...] > >How can I check if there are any other query that locks my table? [...] > >>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) [...] -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
