[MDEV-18776] Assertion `0' failed in mysql_execute_command with SET STATEMENT Created: 2019-02-28  Updated: 2022-07-30  Resolved: 2022-07-30

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Server
Affects Version/s: 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.3.36, 10.4.26, 10.5.17, 10.6.9, 10.7.5, 10.8.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-29074 GET_BIT variables crash in SET STATEMENT Closed

 Description    

--source include/have_innodb.inc
 
 
 
CREATE TABLE tx (pk INT PRIMARY KEY) ENGINE=InnoDB;
 
CREATE TABLE t1 (pk INT, a INT, PRIMARY KEY (pk), KEY (a), FOREIGN KEY (a) REFERENCES tx (pk)) ENGINE=InnoDB;
 
 
 
--error ER_FK_COLUMN_CANNOT_DROP
 
SET STATEMENT FOREIGN_KEY_CHECKS=OFF FOR ALTER TABLE t1 DROP a;
 
 
 
# Cleanup
 
DROP TABLE t1, tx;

10.3 debug 82da9855

 
mysqld: /data/src/10.3/sql/sql_parse.cc:3546: int mysql_execute_command(THD*): Assertion `0' failed.
 
190228 21:50:42 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007f7180be8ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
 
#8  0x000055d30ed3bd74 in mysql_execute_command (thd=0x7f7130000b00) at /data/src/10.3/sql/sql_parse.cc:3546
 
#9  0x000055d30ed4a145 in mysql_parse (thd=0x7f7130000b00, rawbuf=0x7f7130014cf8 "SET STATEMENT FOREIGN_KEY_CHECKS=OFF FOR ALTER TABLE t1 DROP a", length=62, parser_state=0x7f7175efb5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8095
 
#10 0x000055d30ed372f9 in dispatch_command (command=COM_QUERY, thd=0x7f7130000b00, packet=0x7f71301622a1 "SET STATEMENT FOREIGN_KEY_CHECKS=OFF FOR ALTER TABLE t1 DROP a", packet_length=62, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1854
 
#11 0x000055d30ed35cd1 in do_command (thd=0x7f7130000b00) at /data/src/10.3/sql/sql_parse.cc:1396
 
#12 0x000055d30ee9e41f in do_handle_one_connection (connect=0x55d311aa1c30) at /data/src/10.3/sql/sql_connect.cc:1403
 
#13 0x000055d30ee9e1a3 in handle_one_connection (arg=0x55d311aa1c30) at /data/src/10.3/sql/sql_connect.cc:1309
 
#14 0x000055d30f33a8b3 in pfs_spawn_thread (arg=0x55d311ae34f0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
 
#15 0x00007f71828bf494 in start_thread (arg=0x7f7175efc700) at pthread_create.c:333
 
#16 0x00007f7180ca593f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Not reproducible on 10.2.
No obvious effect on a non-debug build.

 Comments   
Comment by Elena Stepanova [ 2021-03-11 ]

Still reproducible on 10.3-10.6, and it features a new frame in the stack trace now:

10.3 cc9c303a

 
mysqld: /data/src/10.3/sql/sql_parse.cc:3354: bool run_set_statement_if_requested(THD*, LEX*): Assertion `0' failed.
 
210311 16:24:39 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007fc6b18fbf36 in __GI___assert_fail (assertion=0x55b232745038 "0", file=0x55b232745ef8 "/data/src/10.3/sql/sql_parse.cc", line=3354, function=0x55b232746a98 "bool run_set_statement_if_requested(THD*, LEX*)") at assert.c:101
 
#8  0x000055b231aeabeb in run_set_statement_if_requested (thd=0x7fc65c000d90, lex=0x7fc65c004b98) at /data/src/10.3/sql/sql_parse.cc:3354
 
#9  0x000055b231aebba7 in mysql_execute_command (thd=0x7fc65c000d90) at /data/src/10.3/sql/sql_parse.cc:3688
 
#10 0x000055b231af9d48 in mysql_parse (thd=0x7fc65c000d90, rawbuf=0x7fc65c012ad8 "SET STATEMENT FOREIGN_KEY_CHECKS= OFF FOR ALTER TABLE t2 ADD CONSTRAINT FOREIGN KEY (id) REFERENCES t1 (a)", length=106, parser_state=0x7fc6a6aa45c0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7867
 
#11 0x000055b231ae63f0 in dispatch_command (command=COM_QUERY, thd=0x7fc65c000d90, packet=0x7fc65c008f31 "SET STATEMENT FOREIGN_KEY_CHECKS= OFF FOR ALTER TABLE t2 ADD CONSTRAINT FOREIGN KEY (id) REFERENCES t1 (a)", packet_length=106, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1852
 
#12 0x000055b231ae4d90 in do_command (thd=0x7fc65c000d90) at /data/src/10.3/sql/sql_parse.cc:1398
 
#13 0x000055b231c63d57 in do_handle_one_connection (connect=0x55b235cb0100) at /data/src/10.3/sql/sql_connect.cc:1403
 
#14 0x000055b231c63ab3 in handle_one_connection (arg=0x55b235cb0100) at /data/src/10.3/sql/sql_connect.cc:1308
 
#15 0x000055b232632083 in pfs_spawn_thread (arg=0x55b235c93020) at /data/src/10.3/storage/perfschema/pfs.cc:1869
 
#16 0x00007fc6b1e0d609 in start_thread (arg=<optimized out>) at pthread_create.c:477
 
#17 0x00007fc6b19e7293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Comment by Elena Stepanova [ 2022-07-30 ]

Fixed by MDEV-29074

Generated at Thu Feb 08 08:46:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.