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...
Any ideas are appreciated!!! Please help! / Jacob >From: "Jacob Nordgren" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Something is blocking a table in our db >Date: Sat, 11 May 2002 12:08:19 +0000 > > >How can I check if there are any other query that locks my table? > >/ 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 >> > > > > >_________________________________________________________________ >Kom med i världens största e-posttjänst med MSN Hotmail. >http://www.hotmail.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
