Hi again,
This is our MySQL version: maple:~$ mysql --version mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) / Jacob >From: "Jacob Nordgren" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Something is blocking a table in our db >Date: Sat, 11 May 2002 08:40:18 +0000 > > >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 > _________________________________________________________________ MSN Foto är det enklaste sättet att dela eller skaffa papperskopior av dina foton: http://photos.msn.com/support/worldwide.aspx --------------------------------------------------------------------- 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
