--On Saturday, February 02, 2002 2:16 AM -0600 Ed Carp <[EMAIL PROTECTED]> wrote:
>> >> I have not completely figured out what the problem is and I never got a
>> >> response from any one else on the list. I can tell you it looks like a
>> >> mutex problem between two threads. We have followed it down into
>> >> pthreads
>> >> where it seems to be stuck. The external symptom we see is that
>> >> the MySQL
>> >> server does not open any of the databases.
>> >>
>> >> The really bad news is that it is not a MySQL problem so
>> >> reinstalling MySQL
>> >> does nothing to fix it. The worse news is that the MySQL
>> server does not
>> >> give you a clue what the problem is.
>
>> We had a Linux guru look at the version of mysql on this system that we
>> compiled with debug. I got information about the debugging session third
>> hand and really don't have any details other than the problem appeared to
>> be in pthreads. I am not so sure pthreads is at fault other than a
>> dead-lock condition exists and it is not detecting it and blowing one of
>> the stuck processes away.
>
> What version of Linux are you running? After a lot of reearch and gdb'ing,
> I found a bug report in bugzilla on redhat.com that seems to illustrate the
> bug that we're having:
> http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=13785
>
> In short, it seems it's a contention problem in pthread_lock. the fix is to
> upgrade to libc 2.1.92 (or better). RedHat 6.2 is running libpthreads 0.8,
> and I think this problem is fixed in 0.9. Unfortuantely, 0.9 needs libc
> 2.2, so you're probably better off upgrading to RedHat 7.2.
>
> I know, this bug report applies to SMP kernels, but ieven if you're not
> running an SMP kernel, it's probably a good idea to upgrade anyway.
>
> Why it started suddenly and won't go away, I have no idea.
>
Thanks for keeping me informed. Two systems here exhibited the problem, both
RedHat 6.1 systems, one a uniprocessor system, and one an SMP system. The
kernel on the SMP system is 2.12.12-20smp. The other system has been rebuilt.
The SMP system is soon to be rebuilt with RedHat 7.2 and a kernel that we build
to make sure we are greater than 2.4.10.
Bill
+-----------------------------------------------
| Bill MacAllister
| Senior Programmer, Pride Industries
| 10030 Foothills Blvd., Roseville CA 95747
| Phone: +1 916.788.2402 Fax: +1 916.788-2540
---------------------------------------------------------------------
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