Bug #26434 Unable to drop table after creating/droping some number of tables

• Submitted: 16 Feb 2007 0:09
• Modified: 7 Mar 2007 23:14
• Reporter: Alexey Stroganov
• Status: Can't repeat
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• Version: 5.2.3
• OS: Linux (Linux)
• CPU Architecture: Any

[16 Feb 2007 0:09] Alexey Stroganov

Description:
Testing of Falcon engine with 'mysql-bench' suite I've got the error in test-create test during 'create+drop' operation. Further investigation showed that such error happens only under following circumstances:

 - the 'max_number' of tables should be > 2000
 - test scenario should look as following:
   - at first we should create 'max_number' tables
   - then drop them one by one 
   - on next step just try to create table and drop it right away. Here we will get following error:

Create 2500 tables
Drop 2500 tables
Create and drop 2500 tables
DBD::mysql::db do failed: Unknown table 'bench_2' at t.pl line 41.
Unknown table 'bench_2' at t.pl line 41.

Above means that bench_2 table was created but can't be dropped as server returned 'Unknown table 'bench_2''

[qa-bench-emt64:/data] ls -1
mysql
qa-bench-emt64.err
qa-bench-emt64.pid
test
test.fl1
test.fl2
test.fts
[qa-bench-emt64:/data] ls -1 test/
bench_2.frm

cat qa-bench-emt64.err
070215 21:30:51 [Note] ./bin/mysqld: ready for connections.
Version: '5.2.3-falcon-alpha'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)
070215 21:30:51 [Note] SCHEDULER: Loaded 0 events

How to repeat:
Run attached perl script

[16 Feb 2007 0:11] Alexey Stroganov

test case for reported bug

Attachment: bug26434.pl (application/x-perl, text), 1.01 KiB.

[7 Mar 2007 23:14] Jim Starkey

I regret to report that I can't reproduce it.  I didn't mean to fix it -- I guess it just happened.

Thanks for the perl script.  It made rerunning the bug completely painless.