3 messages in com.mysql.lists.mysqlBug in Mysqldump
FromSent OnAttachments
webm...@jazzmonkey.com13 Jul 2000 19:02 
sin...@mysql.com14 Jul 2000 05:19 
sas...@mysql.com14 Jul 2000 10:46 
Subject:Bug in Mysqldump
From:webm...@jazzmonkey.com (webm@jazzmonkey.com)
Date:07/13/2000 07:02:14 PM
List:com.mysql.lists.mysql

Description:

If mysqldump is used on a table that currently has a READ lock on it by another
thread, mysqldump will wait until the lock is released before proceeding. This seems abnormal
since READ should allow all threads to still read from the table without interruption.

How-To-Repeat:

MySQL client: LOCK TABLES tablename READ; Shell: mysqldump db_containing_locked_table > backup.dat

Fix:

None

Submitter-Id: webm@jazzmonkey.com Originator: Organization: MySQL support: none Synopsis: Irregular behaviour with mysqldump and table locks Severity: serious Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.20-beta (Source distribution) Server: /usr/bin/mysqladmin Ver 8.5 Distrib 3.23.20-beta, for pc-linux-gnu on
i686

TCX Datakonsult AB, by Monty

Server version 3.23.20-beta-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 4 min 37 sec

Threads: 88 Questions: 666 Slow queries: 28 Opens: 91 Flush tables: 1 Open
tables: 87 Queries per second avg: 2.404

Environment:

System: Linux ebp2.bestnet.net 2.2.5-15 #1 Mon Apr 19 23:00:46 EDT 1999 i686
unknown Architecture: i686

Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Feb 22 13:19 /lib/libc.so.6 ->
libc-2.1.1.so -rwxr-xr-x 1 root root 4016683 Apr 16 1999 /lib/libc-2.1.1.so -rw-r--r-- 1 root root 19533408 Apr 16 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Apr 16 1999 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --without-docs
--without-bench Perl: This is perl, version 5.005_03 built for i386-linux