Bug #38938 pbxt makes mysql crazy
Submitted: 21 Aug 2008 14:06 Modified: 24 Aug 2008 14:32
Reporter: Aleksey Kishkin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.1.26-rc OS:Linux
Assigned to: CPU Architecture:Any
Tags: pbxt plugin

[21 Aug 2008 14:06] Aleksey Kishkin
Description:
I tried to launch mysql benchmark against pbxt, and found out mysql server became unresponsible the after test-create . When I digg it I found that in case of big number of tables pbxt informs  "Out of resources" and after that moment a cannot even drop all that tables;

mysql> drop table pbxt_hangtest_1;
ERROR 1051 (42S02): Unknown table 'pbxt_hangtest_1'
mysql> create table pbxt_hangtest_1(i int);
ERROR 1005 (HY000): Can't create table 'pbxt_hangtest_1' (errno: 24)

nor even drop the whole database;

mysql> drop database test;
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
mysql> create database test;
ERROR 1007 (HY000): Can't create database 'test'; database exists
mysql> 

How to repeat:
1) install mysql server 5.1.26
2) install pbxt plugin (1.0.04-alfa)
3) generate tables. I used script
#!/bin/sh -
for I in `seq 1 1000`
do
 echo "create table pbxt_hangtest_$I (uq int, s char(10)) engine=pbxt;" >>test.sql
done

4) mysql test <test.sql
5) when it warns "out of resources" (after about 350 tables), go to mysql console client and try to drop and recreate  database test
[21 Aug 2008 15:50] MySQL Verification Team
similar to bug #32476
[24 Aug 2008 14:32] Sveta Smirnova
Thank you for the report.

Shane is right: this is duplicate of bug #32476. Workaround:  FLUSH TABLES