Bug #38938 pbxt makes mysql crazy

• Submitted: 21 Aug 2008 14:06
• Modified: 24 Aug 2008 14:32
• Reporter: Aleksey Kishkin
• Status: Duplicate
• Category: MySQL Server: General
• Severity: S2 (Serious)
• Version: 5.1.26-rc
• OS: Linux
• 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