| Bug #74022 | PARTITION BY with COMMENT leads to mysql server reboot in MySQL Cluster | ||
|---|---|---|---|
| Submitted: | 22 Sep 2014 21:16 | Modified: | 27 Jan 2015 10:35 |
| Reporter: | Odis Yuck | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
| Version: | 5.6.19-ndb-7.3.6-cluster-gpl, 7.3.5 , 7.4.1 | OS: | Linux (didn't check other systems) |
| Assigned to: | Lakshmi Narayanan Sreethar | CPU Architecture: | Any |
| Tags: | MySQL Cluster, MYSQL SERVER | ||
[22 Sep 2014 21:16]
Odis Yuck
[23 Sep 2014 8:48]
MySQL Verification Team
Hello Odis Yuck, Thank you for the bug report and test case. Verified as described. Thanks, Umesh
[23 Sep 2014 8:49]
MySQL Verification Team
// release build
mysql> show variables like '%version%';
+-------------------------+------------------------------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------------------------------+
| innodb_version | 5.6.19 |
| ndb_version | 459526 |
| ndb_version_string | ndb-7.3.6 |
| ndbinfo_version | 459526 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.19-ndb-7.3.6-cluster-commercial-advanced-log |
| version_comment | MySQL Cluster Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64 |
| version_compile_os | linux-glibc2.5 |
+-------------------------+------------------------------------------------------+
10 rows in set (0.00 sec)
mysql> create table test_bug(id int, PRIMARY KEY(id))engine=ndb;
Query OK, 0 rows affected (0.92 sec)
mysql> ALTER TABLE `test_bug` ADD `test1` int NULL PARTITION BY KEY(id);
Query OK, 0 rows affected (2.38 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE `test_bug` ADD `test1` int NULL, COMMENT='test' PARTITION BY KEY(id);
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> bin/mysqld_safe: line 166: 11851 Segmentation fault (core dumped) nohup /data/ushastry/cluster/mysql-cluster-7.3.6/bin/mysqld --defaults-file=./my.cnf --basedir=/data/ushastry/cluster/mysql-cluster-7.3.6 --datadir=/tmp/mycluster --plugin-dir=/data/ushastry/cluster/mysql-cluster-7.3.6/lib/plugin --user=root --log-error=/tmp/mycluster/hostname.err --pid-file=/tmp/mycluster/hostname.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null >> /tmp/mycluster/hostname.err 2>&1
140925 05:03:14 mysqld_safe Number of processes running now: 0
140925 05:03:14 mysqld_safe mysqld restarted
//
(gdb) bt
#0 0x0000003b3ba0c8ac in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000071646a in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/signal_handler.cc:248
#2 <signal handler called>
#3 0x0000000000b955f0 in ha_ndbcluster::can_switch_engines (this=0x7f80a802fdf0) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/ha_ndb_ddl_fk.cc:1592
#4 0x00000000007e7339 in mysql_alter_table (thd=0x3965e60, new_db=0x7f80a80065d8 "test", new_name=0x0, create_info=0x7f80d5429430, table_list=0x7f80a8006078, alter_info=0x7f80d5429510,
order_num=0, order=0x0, ignore=false) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/sql_table.cc:7963
#5 0x00000000008e82c9 in Sql_cmd_alter_table::execute (this=<value optimized out>, thd=0x3965e60)
at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/sql_alter.cc:313
#6 0x0000000000798665 in mysql_execute_command (thd=0x3965e60) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/sql_parse.cc:4954
#7 0x000000000079c0c8 in mysql_parse (thd=0x3965e60, rawbuf=0x7f80a8005f10 "ALTER TABLE `test_bug` ADD `test1` int NULL, COMMENT='test' PARTITION BY KEY(id)", length=<value optimized out>,
parser_state=<value optimized out>) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/sql_parse.cc:6254
#8 0x000000000079d4ab in dispatch_command (command=COM_QUERY, thd=0x3965e60, packet=<value optimized out>, packet_length=81)
at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/sql_parse.cc:1334
#9 0x000000000079f2a7 in do_command (thd=0x3965e60) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/sql_parse.cc:1036
#10 0x00000000007670f6 in do_handle_one_connection (thd_arg=0x3965e60) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/sql_connect.cc:982
#11 0x00000000007671d5 in handle_one_connection (arg=0x3965e60) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/sql/sql_connect.cc:898
#12 0x0000000000cffc76 in pfs_spawn_thread (arg=<value optimized out>) at /export/home/pb2/build/sb_0-12598553-1404293478.57/mysql-cluster-com-7.3.6/storage/perfschema/pfs.cc:1860
#13 0x0000003b3ba079d1 in start_thread () from /lib64/libpthread.so.0
#14 0x0000003b3b6e8b5d in clone () from /lib64/libc.so.6
[23 Sep 2014 8:50]
MySQL Verification Team
// Innodb table - Duplicate column name 'test1' instead of crash
mysql> create table test_bug(id int, PRIMARY KEY(id))engine=innodb;
Query OK, 0 rows affected (0.03 sec)
mysql> ALTER TABLE `test_bug` ADD `test1` int NULL PARTITION BY KEY(id);
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE `test_bug` ADD `test1` int NULL, COMMENT='test' PARTITION BY KEY(id);
ERROR 1060 (42S21): Duplicate column name 'test1'
mysql>
mysql> show create table test_bug\G
*************************** 1. row ***************************
Table: test_bug
Create Table: CREATE TABLE `test_bug` (
`id` int(11) NOT NULL DEFAULT '0',
`test1` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY KEY (id) */
1 row in set (0.00 sec)
[23 Sep 2014 10:14]
MySQL Verification Team
// Thought to confirm if it is regression but seems 7.3.5 also affected mysql> show variables like '%version%'; +-------------------------+------------------------------------------------------+ | Variable_name | Value | +-------------------------+------------------------------------------------------+ | innodb_version | 5.6.17 | | ndb_version | 459525 | | ndb_version_string | ndb-7.3.5 | | ndbinfo_version | 459525 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.6.17-ndb-7.3.5-cluster-commercial-advanced-log | | version_comment | MySQL Cluster Server - Advanced Edition (Commercial) | | version_compile_machine | x86_64 | | version_compile_os | linux-glibc2.5 | +-------------------------+------------------------------------------------------+ 10 rows in set (0.00 sec) mysql> create table test_bug(id int, PRIMARY KEY(id))engine=ndb; ERROR 1046 (3D000): No database selected mysql> use test Database changed mysql> create table test_bug(id int, PRIMARY KEY(id))engine=ndb; Query OK, 0 rows affected (0.72 sec) mysql> ALTER TABLE `test_bug` ADD `test1` int NULL PARTITION BY KEY(id); Query OK, 0 rows affected (1.45 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE `test_bug` ADD `test1` int NULL, COMMENT='test' PARTITION BY KEY(id); ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> 140925 06:42:06 mysqld_safe Number of processes running now: 0 140925 06:42:06 mysqld_safe mysqld restarted
[23 Sep 2014 13:33]
MySQL Verification Team
// 7.4.1
mysql> show variables like '%version%';
+-------------------------+--------------------------------------+
| Variable_name | Value |
+-------------------------+--------------------------------------+
| innodb_version | 5.6.20 |
| ndb_version | 459777 |
| ndb_version_string | ndb-7.4.1 |
| ndbinfo_version | 459777 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.20-ndb-7.4.1-cluster-gpl-log |
| version_comment | MySQL Cluster Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | linux-glibc2.5 |
+-------------------------+--------------------------------------+
10 rows in set (0.00 sec)
mysql> create table test_bug(id int, PRIMARY KEY(id))engine=ndb;
ERROR 1046 (3D000): No database selected
mysql> use test
Database changed
mysql> create table test_bug(id int, PRIMARY KEY(id))engine=ndb;
Query OK, 0 rows affected (0.76 sec)
mysql> ALTER TABLE `test_bug` ADD `test1` int NULL PARTITION BY KEY(id);
Query OK, 0 rows affected (1.57 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE `test_bug` ADD `test1` int NULL, COMMENT='test' PARTITION BY KEY(id);
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> bin/mysqld_safe: line 166: 14225 Segmentation fault (core dumped) nohup /data/ushastry/cluster/mysql-cluster-gpl-7.4.1/bin/mysqld --defaults-file=./my.cnf --basedir=/data/ushastry/cluster/mysql-cluster-gpl-7.4.1 --datadir=/tmp/mycluster --plugin-dir=/data/ushastry/cluster/mysql-cluster-gpl-7.4.1/lib/plugin --user=root --log-error=/tmp/mycluster/hostname.err --pid-file=/tmp/mycluster/hostname.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null >> /tmp/mycluster/hostname.err 2>&1
140925 10:01:04 mysqld_safe Number of processes running now: 0
140925 10:01:04 mysqld_safe mysqld restarted
//
(gdb) bt
#0 0x0000003b3ba0c8ac in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006e7aca in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/signal_handler.cc:230
#2 <signal handler called>
#3 0x0000000000bda1d0 in ha_ndbcluster::can_switch_engines (this=0x7f3e8802ccf0) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/ha_ndb_ddl_fk.cc:1592
#4 0x00000000007b6ff8 in mysql_alter_table (thd=0x258d0b0, new_db=0x7f3e88006608 "test", new_name=0x0, create_info=0x7f3e93ffd430, table_list=0x7f3e880060a8, alter_info=0x7f3e93ffd510,
order_num=0, order=0x0, ignore=false) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/sql_table.cc:8039
#5 0x00000000008b9f89 in Sql_cmd_alter_table::execute (this=<value optimized out>, thd=0x258d0b0)
at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/sql_alter.cc:313
#6 0x0000000000769b85 in mysql_execute_command (thd=0x258d0b0) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/sql_parse.cc:4954
#7 0x000000000076d5e8 in mysql_parse (thd=0x258d0b0, rawbuf=0x7f3e88005f40 "ALTER TABLE `test_bug` ADD `test1` int NULL, COMMENT='test' PARTITION BY KEY(id)", length=<value optimized out>,
parser_state=<value optimized out>) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/sql_parse.cc:6254
#8 0x000000000076e9cb in dispatch_command (command=COM_QUERY, thd=0x258d0b0, packet=<value optimized out>, packet_length=81)
at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/sql_parse.cc:1334
#9 0x00000000007707c7 in do_command (thd=0x258d0b0) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/sql_parse.cc:1036
#10 0x0000000000738566 in do_handle_one_connection (thd_arg=0x258d0b0) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/sql_connect.cc:982
#11 0x0000000000738645 in handle_one_connection (arg=0x258d0b0) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/sql/sql_connect.cc:898
#12 0x00000000009f64e6 in pfs_spawn_thread (arg=<value optimized out>) at /export/home/pb2/build/sb_0-13239046-1410989929.25/mysql-cluster-gpl-7.4.1/storage/perfschema/pfs.cc:1860
#13 0x0000003b3ba079d1 in start_thread () from /lib64/libpthread.so.0
#14 0x0000003b3b6e8b5d in clone () from /lib64/libc.so.6
[27 Jan 2015 10:35]
Jon Stephens
Documented fix in the NDB 7.3.9 and 7.4.4 changelogs, as follows:
An ALTER TABLE statement containing comments and a partitioning
option against an NDB table caused the SQL node on which it was
executed to fail.
Closed.
