[MDEV-27027] Assertion `!param->got_error' failed in Table_triggers_list::change_table_name, Assertion `*str != ''' failed in Table_triggers_list::check_for_broken_triggers - Jira

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.5, 10.6, 10.7(EOL), 10.11, 11.4, 11.8, 12.0
Fix Version/s: 10.5, 10.6, 10.11, 11.4, 11.8
Component/s: Triggers
Labels:
None

Description

CREATE TABLE t1 ( pk int);

CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO db.t SELECT SLEEP(0.05)  ;

RENAME TABLE t1 TO t2, tx TO db.tx;

10.6 3480c3f95b27c8f3e6f4ecbe6

mariadbd: /10.6/src/sql/sql_trigger.cc:2349: static bool Table_triggers_list::change_table_name(THD, TRIGGER_RENAME_PARAM, const LEX_CSTRING, const LEX_CSTRING, const LEX_CSTRING, const LEX_CSTRING, const LEX_CSTRING*): Assertion `!param->got_error' failed.
211111 14:02:41 [ERROR] mysqld got signal 6 ;

Server version: 10.6.6-MariaDB-debug-log

??:0(__assert_fail)[0x7f0b9ba39f36]
sql/sql_trigger.cc:2354(Table_triggers_list::change_table_name(THD, TRIGGER_RENAME_PARAM, st_mysql_const_lex_string const, st_mysql_const_lex_string const, st_mysql_const_lex_string const, st_mysql_const_lex_string const, st_mysql_const_lex_string const*))[0x556d496bc84c]
sql/ddl_log.cc:1214(rename_triggers(THD, st_ddl_log_entry, bool))[0x556d496ee386]
sql/ddl_log.cc:1442(ddl_log_execute_action(THD, st_mem_root, st_ddl_log_entry*))[0x556d496f0131]
sql/ddl_log.cc:2411(ddl_log_execute_entry_no_lock(THD*, unsigned int))[0x556d496f637f]
sql/ddl_log.cc:2922(ddl_log_revert(THD, st_ddl_log_state))[0x556d496f9583]
sql/sql_rename.cc:202(mysql_rename_tables(THD, TABLE_LIST, bool, bool))[0x556d4945d651]
sql/sql_parse.cc:4328(mysql_execute_command(THD*, bool))[0x556d493e2dbe]
sql/sql_parse.cc:8030(mysql_parse(THD, char, unsigned int, Parser_state*))[0x556d493fd5b0]
sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD, char, unsigned int, bool))[0x556d493d3671]
sql/sql_parse.cc:1404(do_command(THD*, bool))[0x556d493d0395]
sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x556d49836e43]
sql/sql_connect.cc:1314(handle_one_connection)[0x556d498366cf]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556d4a5562a9]
nptl/pthread_create.c:478(start_thread)[0x7f0b9bf52609]
??:0(clone)[0x7f0b9bb25293]

Query (0x62b0000c42a8): RENAME TABLE t1 TO t2, tx TO db.tx

Attachments

Issue Links

relates to

MDEV-22883 Assertion `!parse_error || lex.sphead == 0' failed in Table_triggers_list::check_n_load | SIGSEGV in strxmov

Stalled

MDEV-36484 Atomic DDL: Assertion `!param->got_error' failed upon unsuccessful multi-RENAME TABLE

In Review

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar added a comment - 2025-04-04 08:32

Version & stacks update

CREATE TABLE t1 ( pk int);

CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO db.t SELECT SLEEP(0.05)  ;

RENAME TABLE t1 TO t2, tx TO db.tx;

Leads to:

CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Debug) Build 15/02/2025
mariadbd: /test/12.0_dbg/sql/mysqld.cc:3355: void my_message_sql(uint, const char , myf): Assertion `str != ''' failed.

CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Debug) Build 15/02/2025
Core was generated by `/test/MD150225-mariadb-12.0.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
Program terminated with signal SIGABRT, Aborted.
Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c.
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 4042144)]
(gdb) bt
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
#3 0x0000763ce604526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
#4 0x0000763ce60288ff in __GI_abort () at ./stdlib/abort.c:79
#5 0x0000763ce602881b in __assert_fail_base (fmt=0x763ce61d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5ee427e918b2 "str != '\\0'", file=file@entry=0x5ee427e9156b "/test/12.0_dbg/sql/mysqld.cc", line=line@entry=3355, function=function@entry=0x5ee427e91885 "void my_message_sql(uint, const char , myf)") at ./assert/assert.c:94
#6 0x0000763ce603b507 in __assert_fail (assertion=0x5ee427e918b2 "str != '\\0'", file=0x5ee427e9156b "/test/12.0_dbg/sql/mysqld.cc", line=3355, function=0x5ee427e91885 "void my_message_sql(uint, const char , myf)")at ./assert/assert.c:103
#7 0x00005ee426ce0e04 in my_message_sql (error=1064, str=0x761df4036a91 "", MyFlags=0) at /test/12.0_dbg/sql/mysqld.cc:3355
#8 0x00005ee427baff9a in my_message (error=1064, str=0x761df4036a91 "", MyFlags=0) at /test/12.0_dbg/mysys/my_error.c:195
#9 0x00005ee426fdc9d4 in Table_triggers_list::check_for_broken_triggers (this=0x761df4036a28) at /test/12.0_dbg/sql/sql_trigger.h:357
#10 0x00005ee426fdaeb8 in Table_triggers_list::prepare_for_rename (thd=0x761df4000d58, param=0x763cdbf2eaf8, db=@0x763cdbf2ea90: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e7b "test", length = 4}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, old_alias=@0x763cdbf2eac0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e82 "t2", length = 2}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, old_table=@0x763cdbf2eab0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e82 "t2", length = 2}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, new_db=@0x763cdbf2eaa0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e8a "test", length = 4}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, new_table=@0x763cdbf2ead0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e91 "t1", length = 2}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}) at /test/12.0_dbg/sql/sql_trigger.cc:2457
#11 0x00005ee426ff26eb in rename_triggers (thd=0x761df4000d58, ddl_log_entry=0x763cdbf300f0, swap_tables=false)at /test/12.0_dbg/sql/ddl_log.cc:1265
#12 0x00005ee426fef714 in ddl_log_execute_action (thd=0x761df4000d58, mem_root=0x763cdbf300a0, ddl_log_entry=0x763cdbf300f0)at /test/12.0_dbg/sql/ddl_log.cc:1501
#13 0x00005ee426febd82 in ddl_log_execute_entry_no_lock (thd=0x761df4000d58, first_entry=1) at /test/12.0_dbg/sql/ddl_log.cc:2456
#14 0x00005ee426feca91 in ddl_log_revert (thd=0x761df4000d58, state=0x763cdbf30220) at /test/12.0_dbg/sql/ddl_log.cc:2989
#15 0x00005ee426edebed in mysql_rename_tables (thd=0x761df4000d58, table_list=0x761df4019e48, silent=false, if_exists=false)at /test/12.0_dbg/sql/sql_rename.cc:203
#16 0x00005ee426e91e76 in mysql_execute_command (thd=0x761df4000d58, is_called_from_prepared_stmt=false) at /test/12.0_dbg/sql/sql_parse.cc:4362
#17 0x00005ee426e887d4 in mysql_parse (thd=0x761df4000d58, rawbuf=0x761df4019d20 "RENAME TABLE t1 TO t2, tx TO db.tx", length=34, parser_state=0x763cdbf31a20) at /test/12.0_dbg/sql/sql_parse.cc:7915
#18 0x00005ee426e85ba4 in dispatch_command (command=COM_QUERY, thd=0x761df4000d58, packet=0x761df400b099 "RENAME TABLE t1 TO t2, tx TO db.tx", packet_length=34, blocking=true) at /test/12.0_dbg/sql/sql_parse.cc:1902
#19 0x00005ee426e89383 in do_command (thd=0x761df4000d58, blocking=true)at /test/12.0_dbg/sql/sql_parse.cc:1415
#20 0x00005ee4270729d9 in do_handle_one_connection (connect=0x5ee42bbdbfb8, put_in_cache=true) at /test/12.0_dbg/sql/sql_connect.cc:1415
#21 0x00005ee42707277e in handle_one_connection (arg=0x5ee42bbf51c8)at /test/12.0_dbg/sql/sql_connect.cc:1327
#22 0x0000763ce609ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
#23 0x0000763ce6129c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

Bug Detection Matrix
Rel o/d Build Commit UniqueID observed
CS 10.5 dbg 150225 c43d0a015f974c5a0142e6779332089a7a979853 *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::change_table_name
CS 10.5 opt 150225 c43d0a015f974c5a0142e6779332089a7a979853 No bug found
CS 10.6 dbg 150225 f1d7e0c17e33f77278e6226dd94aeb30fc856bf0 *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 10.6 opt 150225 f1d7e0c17e33f77278e6226dd94aeb30fc856bf0 GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
CS 10.11 dbg 150225 43c5d1303f5c7c726db276815c459436110f342f !param->got_error\|SIGABRT\|Table_triggers_list::change_table_name\|rename_triggers\|ddl_log_execute_action\|ddl_log_execute_entry_no_lock
CS 10.11 opt 150225 43c5d1303f5c7c726db276815c459436110f342f GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
CS 11.4 dbg 150225 ef966af801afc2a07222b5df65dddd52c77431dd *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 11.4 opt 150225 ef966af801afc2a07222b5df65dddd52c77431dd GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
CS 11.8 dbg 150225 33e0796e7a154e02a5e53c55cefc5d6feb4f5e6d *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 11.8 opt 150225 33e0796e7a154e02a5e53c55cefc5d6feb4f5e6d GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
CS 12.0 dbg 150225 c92add291e636c797e6d6ddca605905541b2a441 *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 12.0 opt 150225 c92add291e636c797e6d6ddca605905541b2a441 GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
ES 10.5 dbg 130325 52e0fd3f76eaa4b1e88fd2028f5640c48b6cbb06 No bug found
ES 10.5 opt 130325 52e0fd3f76eaa4b1e88fd2028f5640c48b6cbb06 No bug found
ES 10.6 dbg 130325 66c9276fa67d1aacf5cf47b31254e79a9d0e4a5d !param->got_error\|SIGABRT\|Table_triggers_list::change_table_name\|rename_triggers\|ddl_log_execute_action\|ddl_log_execute_entry_no_lock
ES 10.6 opt 130325 66c9276fa67d1aacf5cf47b31254e79a9d0e4a5d GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
ES 11.4 dbg 130325 ca7a2a835c4c982ffa35d3f0b5748b30c4c22763 !param->got_error\|SIGABRT\|Table_triggers_list::change_table_name\|rename_triggers\|ddl_log_execute_action\|ddl_log_execute_entry_no_lock
ES 11.4 opt 130325 ca7a2a835c4c982ffa35d3f0b5748b30c4c22763 GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
MS 5.5 dbg 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
MS 5.5 opt 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
MS 5.6 dbg 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
MS 5.6 opt 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
MS 5.7 dbg 060224 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
MS 5.7 opt 060224 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
MS 8.0 dbg 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
MS 8.0 opt 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
MS 9.1 dbg 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
MS 9.1 opt 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found

Roel Van de Paar added a comment - 2025-04-04 08:32 Version & stacks update CREATE TABLE t1 ( pk int ); CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO db.t SELECT SLEEP(0.05) ; RENAME TABLE t1 TO t2, tx TO db.tx; Leads to: CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Debug) Build 15/02/2025 mariadbd: /test/12.0_dbg/sql/mysqld.cc:3355: void my_message_sql(uint, const char *, myf): Assertion `*str != ''' failed. CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Debug) Build 15/02/2025 Core was generated by `/test/MD150225-mariadb-12.0.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'. Program terminated with signal SIGABRT, Aborted. Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c. #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44 [Current thread is 1 (LWP 4042144)] (gdb) bt #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44 #1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78 #2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89 #3 0x0000763ce604526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26 #4 0x0000763ce60288ff in __GI_abort () at ./stdlib/abort.c:79 #5 0x0000763ce602881b in __assert_fail_base (fmt=0x763ce61d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5ee427e918b2 "*str != '\\0'", file=file@entry=0x5ee427e9156b "/test/12.0_dbg/sql/mysqld.cc", line=line@entry=3355, function=function@entry=0x5ee427e91885 "void my_message_sql(uint, const char *, myf)") at ./assert/assert.c:94 #6 0x0000763ce603b507 in __assert_fail (assertion=0x5ee427e918b2 "*str != '\\0'", file=0x5ee427e9156b "/test/12.0_dbg/sql/mysqld.cc", line=3355, function=0x5ee427e91885 "void my_message_sql(uint, const char *, myf)")at ./assert/assert.c:103 #7 0x00005ee426ce0e04 in my_message_sql (error=1064, str=0x761df4036a91 "", MyFlags=0) at /test/12.0_dbg/sql/mysqld.cc:3355 #8 0x00005ee427baff9a in my_message (error=1064, str=0x761df4036a91 "", MyFlags=0) at /test/12.0_dbg/mysys/my_error.c:195 #9 0x00005ee426fdc9d4 in Table_triggers_list::check_for_broken_triggers (this=0x761df4036a28) at /test/12.0_dbg/sql/sql_trigger.h:357 #10 0x00005ee426fdaeb8 in Table_triggers_list::prepare_for_rename (thd=0x761df4000d58, param=0x763cdbf2eaf8, db=@0x763cdbf2ea90: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e7b "test", length = 4}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, old_alias=@0x763cdbf2eac0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e82 "t2", length = 2}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, old_table=@0x763cdbf2eab0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e82 "t2", length = 2}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, new_db=@0x763cdbf2eaa0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e8a "test", length = 4}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, new_table=@0x763cdbf2ead0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5ee42b790e91 "t1", length = 2}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}) at /test/12.0_dbg/sql/sql_trigger.cc:2457 #11 0x00005ee426ff26eb in rename_triggers (thd=0x761df4000d58, ddl_log_entry=0x763cdbf300f0, swap_tables=false)at /test/12.0_dbg/sql/ddl_log.cc:1265 #12 0x00005ee426fef714 in ddl_log_execute_action (thd=0x761df4000d58, mem_root=0x763cdbf300a0, ddl_log_entry=0x763cdbf300f0)at /test/12.0_dbg/sql/ddl_log.cc:1501 #13 0x00005ee426febd82 in ddl_log_execute_entry_no_lock (thd=0x761df4000d58, first_entry=1) at /test/12.0_dbg/sql/ddl_log.cc:2456 #14 0x00005ee426feca91 in ddl_log_revert (thd=0x761df4000d58, state=0x763cdbf30220) at /test/12.0_dbg/sql/ddl_log.cc:2989 #15 0x00005ee426edebed in mysql_rename_tables (thd=0x761df4000d58, table_list=0x761df4019e48, silent=false, if_exists=false)at /test/12.0_dbg/sql/sql_rename.cc:203 #16 0x00005ee426e91e76 in mysql_execute_command (thd=0x761df4000d58, is_called_from_prepared_stmt=false) at /test/12.0_dbg/sql/sql_parse.cc:4362 #17 0x00005ee426e887d4 in mysql_parse (thd=0x761df4000d58, rawbuf=0x761df4019d20 "RENAME TABLE t1 TO t2, tx TO db.tx", length=34, parser_state=0x763cdbf31a20) at /test/12.0_dbg/sql/sql_parse.cc:7915 #18 0x00005ee426e85ba4 in dispatch_command (command=COM_QUERY, thd=0x761df4000d58, packet=0x761df400b099 "RENAME TABLE t1 TO t2, tx TO db.tx", packet_length=34, blocking=true) at /test/12.0_dbg/sql/sql_parse.cc:1902 #19 0x00005ee426e89383 in do_command (thd=0x761df4000d58, blocking=true)at /test/12.0_dbg/sql/sql_parse.cc:1415 #20 0x00005ee4270729d9 in do_handle_one_connection (connect=0x5ee42bbdbfb8, put_in_cache=true) at /test/12.0_dbg/sql/sql_connect.cc:1415 #21 0x00005ee42707277e in handle_one_connection (arg=0x5ee42bbf51c8)at /test/12.0_dbg/sql/sql_connect.cc:1327 #22 0x0000763ce609ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447 #23 0x0000763ce6129c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78 Bug Detection Matrix Rel o/d Build Commit UniqueID observed CS 10.5 dbg 150225 c43d0a015f974c5a0142e6779332089a7a979853 *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::change_table_name CS 10.5 opt 150225 c43d0a015f974c5a0142e6779332089a7a979853 No bug found CS 10.6 dbg 150225 f1d7e0c17e33f77278e6226dd94aeb30fc856bf0 *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 10.6 opt 150225 f1d7e0c17e33f77278e6226dd94aeb30fc856bf0 GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' CS 10.11 dbg 150225 43c5d1303f5c7c726db276815c459436110f342f !param->got_error|SIGABRT|Table_triggers_list::change_table_name|rename_triggers|ddl_log_execute_action|ddl_log_execute_entry_no_lock CS 10.11 opt 150225 43c5d1303f5c7c726db276815c459436110f342f GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' CS 11.4 dbg 150225 ef966af801afc2a07222b5df65dddd52c77431dd *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 11.4 opt 150225 ef966af801afc2a07222b5df65dddd52c77431dd GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' CS 11.8 dbg 150225 33e0796e7a154e02a5e53c55cefc5d6feb4f5e6d *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 11.8 opt 150225 33e0796e7a154e02a5e53c55cefc5d6feb4f5e6d GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' CS 12.0 dbg 150225 c92add291e636c797e6d6ddca605905541b2a441 *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 12.0 opt 150225 c92add291e636c797e6d6ddca605905541b2a441 GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' ES 10.5 dbg 130325 52e0fd3f76eaa4b1e88fd2028f5640c48b6cbb06 No bug found ES 10.5 opt 130325 52e0fd3f76eaa4b1e88fd2028f5640c48b6cbb06 No bug found ES 10.6 dbg 130325 66c9276fa67d1aacf5cf47b31254e79a9d0e4a5d !param->got_error|SIGABRT|Table_triggers_list::change_table_name|rename_triggers|ddl_log_execute_action|ddl_log_execute_entry_no_lock ES 10.6 opt 130325 66c9276fa67d1aacf5cf47b31254e79a9d0e4a5d GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' ES 11.4 dbg 130325 ca7a2a835c4c982ffa35d3f0b5748b30c4c22763 !param->got_error|SIGABRT|Table_triggers_list::change_table_name|rename_triggers|ddl_log_execute_action|ddl_log_execute_entry_no_lock ES 11.4 opt 130325 ca7a2a835c4c982ffa35d3f0b5748b30c4c22763 GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' MS 5.5 dbg 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found MS 5.5 opt 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found MS 5.6 dbg 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found MS 5.6 opt 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found MS 5.7 dbg 060224 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found MS 5.7 opt 060224 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found MS 8.0 dbg 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found MS 8.0 opt 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found MS 9.1 dbg 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found MS 9.1 opt 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found

Roel Van de Paar added a comment - 2025-04-15 08:50

Please note a test with updated revisions changed the CS 10.11 dbg and ES 10.5/10.6 dbg outcomes.

Bug Detection Matrix
Rel o/d Build Commit UniqueID observed
CS 10.5 dbg 120425 e6ea5d568c0fb972a391a8c64716846ddb7c57ef *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::change_table_name
CS 10.5 opt 120425 e6ea5d568c0fb972a391a8c64716846ddb7c57ef No bug found
CS 10.6 dbg 120425 690b2cf776faa2e1a6832077cec2246c86cd00bf *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 10.6 opt 120425 690b2cf776faa2e1a6832077cec2246c86cd00bf GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
CS 10.11 dbg 120425 acd071f599f416ddb4821dec485c4d912844213f *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 10.11 opt 120425 acd071f599f416ddb4821dec485c4d912844213f GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
CS 11.4 dbg 120425 4a701e8ce4a178faf955641caf59fc13fcc718e9 *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 11.4 opt 120425 4a701e8ce4a178faf955641caf59fc13fcc718e9 GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
CS 11.8 dbg 120425 db5bb6f3339be5a49c0f397eb80a0f259f73f447 *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 11.8 opt 120425 db5bb6f3339be5a49c0f397eb80a0f259f73f447 GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
CS 12.0 dbg 120425 22efc2c784e1b7199fb5804e6330168277ea7dce *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
CS 12.0 opt 120425 22efc2c784e1b7199fb5804e6330168277ea7dce GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
ES 10.5 dbg 120425 0d368ec0042a81d9549fc939fb742f82350b20ab *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::change_table_name
ES 10.5 opt 120425 0d368ec0042a81d9549fc939fb742f82350b20ab No bug found
ES 10.6 dbg 120425 74602d1b054ba6c9ee20af79d6e7807440a7a98e *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
ES 10.6 opt 120425 74602d1b054ba6c9ee20af79d6e7807440a7a98e GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
ES 11.4 dbg 120425 9cd12544ebfd0d52d2158af66b5aced58121cf1f *str != '\0'\|SIGABRT\|my_message_sql\|my_message\|Table_triggers_list::check_for_broken_triggers\|Table_triggers_list::prepare_for_rename
ES 11.4 opt 120425 9cd12544ebfd0d52d2158af66b5aced58121cf1f GOT_ERROR\|Got error 1064\|when trying to execute action for entry 1 of type 'rename table'
MS 5.5 dbg 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
MS 5.5 opt 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
MS 5.6 dbg 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
MS 5.6 opt 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
MS 5.7 dbg 060224 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
MS 5.7 opt 060224 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
MS 8.0 dbg 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
MS 8.0 opt 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
MS 9.1 dbg 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
MS 9.1 opt 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found

A re-test did not change the outcome.

Roel Van de Paar added a comment - 2025-04-15 08:50 Please note a test with updated revisions changed the CS 10.11 dbg and ES 10.5/10.6 dbg outcomes. Bug Detection Matrix Rel o/d Build Commit UniqueID observed CS 10.5 dbg 120425 e6ea5d568c0fb972a391a8c64716846ddb7c57ef *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::change_table_name CS 10.5 opt 120425 e6ea5d568c0fb972a391a8c64716846ddb7c57ef No bug found CS 10.6 dbg 120425 690b2cf776faa2e1a6832077cec2246c86cd00bf *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 10.6 opt 120425 690b2cf776faa2e1a6832077cec2246c86cd00bf GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' CS 10.11 dbg 120425 acd071f599f416ddb4821dec485c4d912844213f *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 10.11 opt 120425 acd071f599f416ddb4821dec485c4d912844213f GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' CS 11.4 dbg 120425 4a701e8ce4a178faf955641caf59fc13fcc718e9 *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 11.4 opt 120425 4a701e8ce4a178faf955641caf59fc13fcc718e9 GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' CS 11.8 dbg 120425 db5bb6f3339be5a49c0f397eb80a0f259f73f447 *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 11.8 opt 120425 db5bb6f3339be5a49c0f397eb80a0f259f73f447 GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' CS 12.0 dbg 120425 22efc2c784e1b7199fb5804e6330168277ea7dce *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename CS 12.0 opt 120425 22efc2c784e1b7199fb5804e6330168277ea7dce GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' ES 10.5 dbg 120425 0d368ec0042a81d9549fc939fb742f82350b20ab *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::change_table_name ES 10.5 opt 120425 0d368ec0042a81d9549fc939fb742f82350b20ab No bug found ES 10.6 dbg 120425 74602d1b054ba6c9ee20af79d6e7807440a7a98e *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename ES 10.6 opt 120425 74602d1b054ba6c9ee20af79d6e7807440a7a98e GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' ES 11.4 dbg 120425 9cd12544ebfd0d52d2158af66b5aced58121cf1f *str != '\0'|SIGABRT|my_message_sql|my_message|Table_triggers_list::check_for_broken_triggers|Table_triggers_list::prepare_for_rename ES 11.4 opt 120425 9cd12544ebfd0d52d2158af66b5aced58121cf1f GOT_ERROR|Got error 1064|when trying to execute action for entry 1 of type 'rename table' MS 5.5 dbg 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found MS 5.5 opt 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found MS 5.6 dbg 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found MS 5.6 opt 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found MS 5.7 dbg 060224 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found MS 5.7 opt 060224 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found MS 8.0 dbg 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found MS 8.0 opt 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found MS 9.1 dbg 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found MS 9.1 opt 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found A re-test did not change the outcome.

Oleg Smirnov added a comment - 3 days ago

This one seems to be fixed by the solution proposed at MDEV-36484

Oleg Smirnov added a comment - 3 days ago This one seems to be fixed by the solution proposed at MDEV-36484

MariaDB Server

Assertion `!param->got_error' failed in Table_triggers_list::change_table_name, Assertion `*str != ''' failed in Table_triggers_list::check_for_broken_triggers

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration