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:	None
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

Description:
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

Patch pushed and will appear in 5.1.6

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 
http://www.mysql.com/downloads/

Additional info:

Documented bugfix in 5.1.6 changelog. Closed.

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.