OK,
the problem doesn't occur with --skip-locking. Still, I don't believe this to
be a lockd problem as the partition mysqld is working on is a local ext2 fs.
lockd isn't even running on the test system (no nfs). So, this leaves either
(in no particular sequence):
1. a mysql problem
2. a glibc 2.2 problem
3. a kernel (2.2.18) problem
I understand that you can't investigate further as --skip-locking is an easy
workaround. I will, however, try to investigate, if I do find some spare time.
If I do find out what's going on in case of --enable-locking I'll let you know.
On 14-Feb-2001 Sinisa Milivojevic wrote:
> Andreas Steinmetz writes:
> > Hi,
> > just FYI: the deadlock problem is still in MySQL 3.23.33, the test I did
> send
> > you behaves as in 3.23.32.
> >
> >
> > Andreas Steinmetz
> > D.O.M. Datenverarbeitung GmbH
> >
>
> Thank you for contacting me, as I was just now starting to search for
> your e-mail address !!
>
> Your test case did cause a deadlock, but this is not MySQL fault !!
>
> As our manual clearly says, lockd is broken on Linux and some other
> systems, so --enable-locking will quite often result in a deadlock.
>
> If you start mysqld with --skip-locking , there are no problems.
>
> Simply never use --enable-locking on OS's with broken lock daemon.
>
> We do not have time to fix it !!
>
>
> Regards,
>
> Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
>
Andreas Steinmetz
D.O.M. Datenverarbeitung GmbH
---------------------------------------------------------------------
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
