Bug #13442 Partitions: crash after truncate
Submitted: 23 Sep 2005 17:41 Modified: 20 Jan 2006 9:56
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.2-alpha-debug OS:Linux (SUSE 9.2)
Assigned to: Mikael Ronström CPU Architecture:Any

[23 Sep 2005 17:41] Peter Gulutzan
If I say "truncate partitioned_table" twice, I get a crash.

How to repeat:
mysql> create table tu (s1 int, unique (s1)) engine=innodb partition by list (s1) (partition x1 VALUES in (10), partition x2 values in (20));
Query OK, 0 rows affected (0.01 sec)

mysql> truncate table tu;
ERROR 1005 (HY000): Can't create table './db4/tu' (errno: 1)
mysql> truncate table tu;
ERROR 1037 (HY001): Out of memory; restart server and try again (needed 129 bytes)
mysql> drop table tu;
ERROR 2013 (HY000): Lost connection to MySQL server during query
[19 Jan 2006 9:03] Mikael Ronström
Patch pushed and will appear in 5.1.6
[20 Jan 2006 9:56] Jon Stephens
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 

Additional info:

Documented bugfix in 5.1.6 changelog. Closed.