Confirmed on 5.1.68 using the testcase.txt attached:
[openxs@centos Percona-Server-5.1.68-rel14.5-513.Linux.x86_64]$ tail data/centos.err InnoDB: Compressed tables use zlib 1.2.3 130522 16:46:27 InnoDB: Initializing buffer pool, size = 128.0M 130522 16:46:27 InnoDB: Completed initialization of buffer pool 130522 16:46:27 InnoDB: highest supported file format is Barracuda. 130522 16:46:27 Percona XtraDB (http://www.percona.com) 5.1.68-14.5 started; log sequence number 45356 130522 16:46:27 [Note] Event Scheduler: Loaded 0 events 130522 16:46:27 [Note] /home/openxs/Percona-Server-5.1.68-rel14.5-513.Linux.x86_64/libexec/mysqld: ready for connections. Version: '5.1.68rel14.5' socket: '/tmp/mysql.sock' port: 3306 Percona Server with XtraDB (GPL), Release rel14.5, Revision 513 InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_tablespace(). index: "PRIMARY" table: "test/currentTable"
5.5 and 5.6 do not use Percona's lazy drop table feature any more, so this bug applies only to PS 5.1.x.
Confirmed on 5.1.68 using the testcase.txt attached:
[openxs@centos Percona- Server- 5.1.68- rel14.5- 513.Linux. x86_64] $ tail data/centos.err www.percona. com) 5.1.68-14.5 started; log sequence number 45356 Percona- Server- 5.1.68- rel14.5- 513.Linux. x86_64/ libexec/ mysqld: ready for connections. tablespace( ).
InnoDB: Compressed tables use zlib 1.2.3
130522 16:46:27 InnoDB: Initializing buffer pool, size = 128.0M
130522 16:46:27 InnoDB: Completed initialization of buffer pool
130522 16:46:27 InnoDB: highest supported file format is Barracuda.
130522 16:46:27 Percona XtraDB (http://
130522 16:46:27 [Note] Event Scheduler: Loaded 0 events
130522 16:46:27 [Note] /home/openxs/
Version: '5.1.68rel14.5' socket: '/tmp/mysql.sock' port: 3306 Percona Server with XtraDB (GPL), Release rel14.5, Revision 513
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_
index: "PRIMARY" table: "test/currentTable"
5.5 and 5.6 do not use Percona's lazy drop table feature any more, so this bug applies only to PS 5.1.x.