mysqlhotcopy (but possible any other software) can cause delayed handlers to terminate with "Delayed insert thread couldn't get requested lock for "
I havent worked out the exact conditions under wich mysqlhotcopy fails, but it seems that if mysqlhotcopy tries to get a lock (waiting for a query to finish) and you start another delayed insert (maybe involving several tables?), then it will fail the server
The description below, extracts the fault without mysqlhotcopy and failed always on my system
>How-To-Repeat:
you need two mysql client connection: (assuming a table tb with a column a int)
1> LOCK TABLES tb READ;
2> insert delayed into tb values(1);
1> flush tables;
# the delayed handler dies here, the insert is not in the table
1> unlock tables
>Fix:
>Submitter-Id: [EMAIL PROTECTED]
>Originator:
>Organization:
>MySQL support: none
>Synopsis: data loss with delayed insert
>Severity: serious
>Priority: low
>Category: mysql
>Class:
>Release: mysql-4.0.15 (FreeBSD port: mysql-server-4.0.15)
>Server: /usr/local/bin/mysqladmin Ver 8.40 Distrib 4.0.13, for portbld-freebsd4.8 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.15 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 8 days 23 hours 34 min 32 sec
Threads: 6 Questions: 138727 Slow queries: 1 Opens: 209 Flush tables: 4 Open tables: 15 Queries per second avg: 0.179
>C compiler: 2.95.4
>C++ compiler: 2.95.4
>Environment:
System: FreeBSD dionysus.london.hybyte.com 4.8-STABLE FreeBSD 4.8-STABLE #0: Tue Aug 12 12:52:01 BST 2003 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/DIONYSUS i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O1 -pipe -mcpu=i686 -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer' CXX='cc' CXXFLAGS='-O1 -pipe -mcpu=i686 -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' ASFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1224554 Aug 12 12:52 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Aug 12 12:52 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 578880 Aug 12 12:52 /usr/lib/libc.so.4
Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-vio' '--with-low-memory' '--with-comment=FreeBSD port: mysql-server-4.0.15' '--enable-thread-safe-client' '--enable-assembler' '--with-berkeley-db' '--with-openssl' '--with-named-thread-libs=-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread -llgcc_r' '--prefix=/usr/local' '--build=i386-portbld-freebsd4.8' 'CFLAGS=-O1 -pipe -mcpu=i686 -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer' 'CXX=cc' 'build_alias=i386-portbld-freebsd4.8' 'CC=cc' 'CXXFLAGS=-O1 -pipe -mcpu=i686 -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions'
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
