Bug #19513 create table t2 like t1 causes MySQLD to core
Submitted: 3 May 2006 12:03 Modified: 8 May 2006 8:48
Reporter: Jonathan Miller Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S1 (Critical)
Version:5.1.10 OS:Linux (Linux 32 Bit OS)
Assigned to: CPU Architecture:Any

[3 May 2006 12:03] Jonathan Miller
Description:
Hi,

This issue some times cores on slave and most of the time on master now with the test case that I have created for it. Both master and slave core at the same location.

./slave.trace
0x82389ce handle_segfault + 438
0xab4420 (?)
0xcbf9c8 (?)
0x8d42f5 (?)
0x8282e1e _Z19assign_new_table_idP14st_table_share + 142
0x83fe9dc _Z28ndbcluster_binlog_open_tableP3THDP19st_ndbcluster_shareP14st_table_shareP8st_table + 530
0x83fee42 _Z28ndbcluster_binlog_init_shareP19st_ndbcluster_shareP8st_table + 768
0x83ebf2b _Z20ndbcluster_get_sharePKcP8st_tablebb + 909
0x83fdefb _Z9get_sharePKcP8st_tablebb + 39
0x83f9b14 _ZN13ha_ndbcluster6createEPKcP8st_tableP24st_ha_create_information + 2702
0x832a0b6 _Z15ha_create_tableP3THDPKcS2_S2_P24st_ha_create_informationb + 452

./master.trace
0x82389ce handle_segfault + 438
0x4f8420 (?)
0x4c59c8 (?)
0x1332f5 (?)
0x8282e1e _Z19assign_new_table_idP14st_table_share + 142
0x83fe9dc _Z28ndbcluster_binlog_open_tableP3THDP19st_ndbcluster_shareP14st_table_shareP8st_table + 530
0x83fee42 _Z28ndbcluster_binlog_init_shareP19st_ndbcluster_shareP8st_table + 768
0x83ebf2b _Z20ndbcluster_get_sharePKcP8st_tablebb + 909
0x83fdefb _Z9get_sharePKcP8st_tablebb + 39
0x83f9b14 _ZN13ha_ndbcluster6createEPKcP8st_tableP24st_ha_create_information + 2702
0x832a0b6 _Z15ha_create_tableP3THDPKcS2_S2_P24st_ha_create_informationb + 452
0x8340ea0 _Z23mysql_create_like_tableP3THDP13st_table_listP24st_ha_create_informationP11Table_ident + 1324
0x8256d3b _Z21mysql_execute_commandP3THD + 5869
0x825e074 _Z11mysql_parseP3THDPcj + 584
0x825ea6e _Z16dispatch_command19enum_server_commandP3THDPcj + 2148
0x825fdcd _Z10do_commandP3THD + 535
0x82601c7 handle_one_connection + 787
0xa25b80 (?)
0x1dc9ce (?)

How to repeat:
Very easy to repeat:

1) Create a file called ./t/rpl_ndb_1.test and add the following:
-- source include/master-slave.inc
connection master;

--disable_warnings
DROP TABLE if exists t1;
--enable_warnings

create table t1(id int, i int, r1 int, r2 int, p varchar(100));
create table t2 like t1;

DROP TABLE t1;
sync_slave_with_master;
stop slave;

2) touch ./r/rpl_ndb_1.result

3)
./mysql-test-run.pl --do-test=rpl_ndb_1 --force --mysqld=--default-storage-engine=ndb --with-ndbcluster-all
[6 May 2006 0:30] Tomas Ulin
I believe this to be a generic cluster bug, but it is it not the same as:

ps_7ndb                  : BUG#18950 2006-02-16 jmiller create table like does not obtain LOCK_open

... are you compiling debug?
[8 May 2006 8:48] Martin Skold
Duplicate of Bug #18950 create table like does not obtain LOCK_open