List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 23 1999 9:39pm
Subject:BUG: Strange lock up
View as plain text  
>>>>> "Brian" == Brian Moon <brianm@stripped> writes:

>> Description:
Brian>     MySQL "locks up", that is it stops responding for undertimnable reasons.
Brian> This is the process list:
Brian> +-----+-------+-----------+----------+-----------+------+----------------+--
Brian> ----------------------------------------------------------------------------
Brian> ------------------------+
Brian> | Id  | User  | Host      | db       | Command   | Time | State          |
Brian> Info
Brian> |
Brian> +-----+-------+-----------+----------+-----------+------+----------------+--
Brian> ----------------------------------------------------------------------------
Brian> ------------------------+
Brian> | 1   | deals | localhost | dealchat | Query     | 1805 | Opening tables |
Brian> Select max(thread) as thread from general
Brian> |
Brian> | 2   | deals | localhost | dealchat | Query     | 1820 | Opening tables |
<cut>

Hi!

Did you issue a 'flush tables' when this happened?
(A (unknown) bug in flush-tables could cause the above to happen)

One option is to compile mysqld with --with-debug;  This will add some 
mutex checking and will find if there is some bug in the mutex
handling if this happens again.

Regards,
Monty
Thread
BUG: Strange lock upBrian Moon23 Sep
  • BUG: Strange lock upJani Tolonen23 Sep
  • Re: Strange lock upBrian Moon23 Sep
    • Re: Strange lock upJani Tolonen24 Sep
  • BUG: Strange lock upMichael Widenius24 Sep
  • Re: Strange lock upBrian Moon25 Sep
  • Re: Strange lock upBrian Moon29 Sep
    • Re: Strange lock upMichael Widenius29 Sep
  • Re: Strange lock upBrian Moon30 Sep
    • Re: Strange lock upMichael Widenius30 Sep
  • Re: Strange lock upBrian Moon30 Sep
    • Re: Strange lock upsinisa30 Sep
    • Re: Strange lock upMichael Widenius30 Sep
  • Re: Strange lock upBrian Moon4 Oct
  • Re: Strange lock upBrian Moon12 Oct
    • Re: Strange lock upMichael Widenius12 Oct
  • Re: Strange lock upshane12 Oct
  • Re: Strange lock upBrian Moon12 Oct
    • Re: Strange lock upMichael Widenius12 Oct
RE: Strange lock upTimothy Chi5 Oct