Bug #32829 Crash during conversion of InnoDB table to Falcon (case-insensitivity)

• Submitted: 28 Nov 2007 22:50
• Modified: 3 Dec 2007 14:24
• Reporter: Jeffrey Pugh
• Status: Closed
• Category: MySQL Server: Falcon storage engine
• Severity: S2 (Serious)
• Version: 6.0.3
• OS: Linux
• Assigned to: Kevin Lewis
• CPU Architecture: Any

[28 Nov 2007 22:50] Jeffrey Pugh

Description:
(Split out from 22166 because of behavior)
Crash during conversion of InnoDB table to Falcon (case-insensitivity)

How to repeat:
mysql> create table t (s1 int) engine=falcon;
Query OK, 0 rows affected (0.03 sec)

mysql> create table T (s1 int) engine=innodb;
Query OK, 0 rows affected (0.00 sec)

mysql> alter table T engine=falcon;
ERROR 1025 (HY000): Error on rename of './d7/#sql-4f7c_1' to './d7/T' (errno: -2)
mysql> alter table t engine=innodb;
ERROR 2013 (HY000): Lost connection to MySQL server during query

[29 Nov 2007 0:45] MySQL Verification Team

Thank you for the bug report.

create table t (s1 int) engine=falcon;
create table T (s1 int) engine=innodb;
alter table T engine=falcon;
alter table t engine=innodb;

[miguel@skybr 6.0]$ bin/mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.4-alpha-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table t (s1 int) engine=falcon;
Query OK, 0 rows affected (0.75 sec)

mysql> create table T (s1 int) engine=innodb;
Query OK, 0 rows affected (0.00 sec)

mysql> alter table T engine=falcon;
ERROR 1025 (HY000): Error on rename of './test/#sql-986_1' to './test/T' (errno: -2)
mysql> alter table t engine=innodb;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>

[29 Nov 2007 15:05] Jim Starkey

Works fine on current code base.

[29 Nov 2007 19:20] Jeffrey Pugh

Reverified with latest 6.0-bk, and no longer crashes. Instead get:
ERROR 1025 (HY000): Error on rename of './test/#sql-4d25_2' to './test/t' (errno: 121)

for whichever alter you try to do that would clash with Falcon name. Closing.

[30 Nov 2007 4:49] Kevin Lewis

This bug really did exist in the mysql-6.0 tree.  It has been fixed in mysql-6.0-falcon.  So let's mark this patch pending and let it go through the normal bug life cycle

[3 Dec 2007 14:24] MC Brown

A note has been added to the 6.0.4 changelog: 

Converting a table from InnoDB to Falcon, where the Falcon table with the same name (but different case) would cause a server crash.