Bug #16825 Reproduceable crash
Submitted: 27 Jan 2006 0:49 Modified: 1 Feb 2006 9:04
Reporter: Vedad KAJTAZ Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.11, 4.1.16 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[27 Jan 2006 0:49] Vedad KAJTAZ
Description:
Hello,

I have a reproduceable crash on 4.1.11 and 4.1.16 versions.
It is triggered by:

mdev2> create table crashtest (x int);
Query OK, 0 rows affected (0.01 sec)

mdev2> lock tables crashtest write;
Query OK, 0 rows affected (0.00 sec)

mdev2> create table crashtest2 like crashtest;
ERROR 2013 (HY000): Lost connection to MySQL server during query

After running resolve_stack_dump on 4.1.11, i got:

0x811f39e handle_segfault + 370
0x4003b532 _end + 935004710
0x8153c19 table_cache_key + 9
0x834bb18 hash_delete + 72
0x811bcf4 unlock_table_name__FP3THDP13st_table_list + 24
0x81ab620 mysql_create_like_table__FP3THDP13st_table_listP24st_ha_create_informationP11Table_ident + 1184
0x81326e9 mysql_execute_command__FP3THD + 4521
0x8138774 mysql_parse__FP3THDPcUi + 196
0x81307c3 dispatch_command__F19enum_server_commandP3THDPcUi + 1415
0x8138cf3 do_command__FP3THD + 187
0x812faca handle_one_connection + 646
0x40038b85 _end + 934994041
0x4019c14a _end + 936449598

After running resolve_stack_dump on 4.1.16, i got:

0x8122f8e handle_segfault + 370
0x4003b532 _end + 934970950
0x8158469 table_cache_key + 9
0x8352618 hash_delete + 72
0x811f874 unlock_table_name__FP3THDP13st_table_list + 24
0x81b1410 mysql_create_like_table__FP3THDP13st_table_listP24st_ha_create_informationP11Table_ident + 1256
0x81367f7 mysql_execute_command__FP3THD + 4647
0x813a327 mysql_parse__FP3THDPcUi + 387
0x8134843 dispatch_command__F19enum_server_commandP3THDPcUi + 1415
0x813d1c3 do_command__FP3THD + 187
0x8133aea handle_one_connection + 642
0x40038b85 _end + 934960281
0x4019c14a _end + 936415838

Thanks!

How to repeat:
mdev2> create table crashtest (x int);
Query OK, 0 rows affected (0.01 sec)

mdev2> lock tables crashtest write;
Query OK, 0 rows affected (0.00 sec)

mdev2> create table crashtest2 like crashtest;
ERROR 2013 (HY000): Lost connection to MySQL server during query

Suggested fix:
None :(
[27 Jan 2006 16:10] Hartmut Holzgraefe
verified with 4.1.16, latest 4.1 source works fine though
[1 Feb 2006 9:04] Brian Aker
Fixed, but from unknown patch according to support.