とみたです。

InnoDB のテーブルを READ LOCAL で LOCK してから、SHOW CREATE TABLE す ると mysqld が落ちます。

これのせいで、mysqldump -l が動きません。

% mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.21-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show create table foo; +-------+---------------------------------------------------------------+ | Table | Create Table | +-------+---------------------------------------------------------------+ | foo | CREATE TABLE `foo` ( `i` int(11) default NULL ) TYPE=InnoDB | +-------+---------------------------------------------------------------+ 1 row in set (0.00 sec)

mysql> flush table; Query OK, 0 rows affected (0.00 sec)

mysql> lock table foo read; Query OK, 0 rows affected (0.00 sec)

mysql> show create table foo; +-------+---------------------------------------------------------------+ | Table | Create Table | +-------+---------------------------------------------------------------+ | foo | CREATE TABLE `foo` ( `i` int(11) default NULL ) TYPE=InnoDB | +-------+---------------------------------------------------------------+ 1 row in set (0.00 sec)

mysql> flush table; Query OK, 0 rows affected (0.00 sec)

mysql> lock table foo read local; Query OK, 0 rows affected (0.00 sec)

mysql> show create table foo;

Number of processes running now: 0 041022 16:22:05 mysqld restarted ERROR 2013: Lost connection to MySQL server during query mysql>