Deadlock on simultaneous TRUNCATE and SELECT FROM information_schema

[wojtek]

Hello,

We are having trouble with servers suspending (sometimes crashing) when a TRUNCATE TABLE is done together
with selecting data over same table from information_schema.
When suspended no query is executed, it is not possible to shutdown the server. The only solution is kill -9.

We are also experiencing it in production.

To reproduce:
 CREATE DATABASE IF NOT EXISTS testdb;
 use testdb;
 DROP TABLE IF EXISTS test;
 CREATE TABLE test (
         id INTEGER,
         text VARCHAR(60)
 )ENGINE InnoDB;

 --------
 #!/bin/bash

 for i in $(seq 1 100); do
        mysql testdb -e 'TRUNCATE TABLE test' & # <---- note the &
        mysql information_schema -e 'SELECT * FROM tables WHERE table_schema="testdb" AND table_name="test"';
 done

Server version: 5.1.59-rel13.0-log from Percona downloads
OS: Debian Squeeze amd64

[yinfeng (yinfeng-zwx)]

cant't repeat in Percona-Server-5.5.18-rel23.0

[wojtek (vojtekb)]

5.1.60-rel13.1 is affected
Would it be possible to fix this in 5.1 series?
It is actually quite serious as it causes db crashes on standard actions in certain webapplications (all sorts of 'Clean X' buttons which launch TRUNCATE TABLE).

[Sergei Glushchenko (sergei.glushchenko)]

Thank you for reporting this bug. Fix will be released in next PS 5.1release (Percona Server 5.1.62-13.3).

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-524