[MDEV-18776] Assertion `0' failed in mysql_execute_command with SET STATEMENT - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 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
Component/s: Data Definition - Alter Table, Server
Labels:
None

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.

Attachments

Issue Links

is duplicated by

MDEV-29074 GET_BIT variables crash in SET STATEMENT

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2021-03-11 14:25

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

Elena Stepanova added a comment - 2021-03-11 14:25 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

Elena Stepanova added a comment - 2022-07-30 18:14

Fixed by ~~MDEV-29074~~

Elena Stepanova added a comment - 2022-07-30 18:14 Fixed by MDEV-29074

People

Assignee:: Unassigned

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2019-02-28 19:52

Updated:: 2022-07-30 18:14

Resolved:: 2022-07-30 18:14

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server