Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL)
Description
Replay using CLI. The issue could not be reproduced by MTR
DROP TABLE mysql.gtid_slave_pos; |
CREATE TABLE t (a INT KEY,b INT) ENGINE=INNODB; |
UPDATE t SET a=b; |
CREATE EVENT t_p_event ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 SECOND ON COMPLETION PRESERVE DO INSERT INTO t SELECT 1,1; |
Leads to
11.5.0 e0b6db2de779320855d90a82bf56da0414de2154 (Debug) |
Core was generated by `/test/MD110424-mariadb-11.5.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --sla'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x1536e914d700 (LWP 947444))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000015370d210859 in __GI_abort () at abort.c:79
|
#2 0x000015370d210729 in __assert_fail_base (fmt=0x15370d3a6588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x56518a44f650 "thd->transaction->stmt.ha_list == __null || trans == &thd->transaction->stmt", file=0x56518a44ed68 "/test/server_dbg/sql/handler.cc", line=1721, function=<optimized out>) at assert.c:92
|
#3 0x000015370d221fd6 in __GI___assert_fail (assertion=assertion@entry=0x56518a44f650 "thd->transaction->stmt.ha_list == __null || trans == &thd->transaction->stmt", file=file@entry=0x56518a44ed68 "/test/server_dbg/sql/handler.cc", line=line@entry=1721, function=function@entry=0x56518a44f888 "int ha_commit_trans(THD*, bool)") at assert.c:101
|
#4 0x0000565189913f1b in ha_commit_trans (thd=thd@entry=0x15368c000f88, all=all@entry=true) at /test/server_dbg/sql/handler.cc:1721
|
#5 0x000056518957c5dc in THD::commit_whole_transaction_and_close_tables (this=this@entry=0x15368c000f88) at /test/server_dbg/sql/sql_class.cc:6321
|
#6 0x0000565189af7e59 in Event_db_repository::create_event (this=<optimized out>, thd=thd@entry=0x15368c000f88, parse_data=parse_data@entry=0x15368c00b130, event_already_exists=event_already_exists@entry=0x1536e914bc9f) at /test/server_dbg/sql/event_db_repository.cc:751
|
#7 0x000056518973ff47 in Events::create_event (thd=thd@entry=0x15368c000f88, parse_data=0x15368c00b130) at /test/server_dbg/sql/events.cc:371
|
#8 0x00005651895ed5d6 in mysql_execute_command (thd=thd@entry=0x15368c000f88, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/server_dbg/sql/sql_parse.cc:5066
|
#9 0x00005651895d6f66 in mysql_parse (thd=0x15368c000f88, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1536e914c7a0) at /test/server_dbg/sql/sql_parse.cc:7815
|
#10 0x0000565189aae1b7 in Query_log_event::do_apply_event (this=<optimized out>, rgi=0x1536c00271a0, query_arg=0x1536c002df67 "CREATE DEFINER=`root`@`localhost` EVENT t_p_event ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY DO INSERT INTO t SELECT 1,1", q_len_arg=127) at /test/server_dbg/sql/sql_class.h:1604
|
#11 0x0000565189aaeac7 in Query_log_event::do_apply_event (this=<optimized out>, rgi=<optimized out>) at /test/server_dbg/sql/log_event_server.cc:1504
|
#12 0x0000565189a9ebb1 in Log_event::apply_event (this=this@entry=0x1536c002ddf8, rgi=rgi@entry=0x1536c00271a0) at /test/server_dbg/sql/log_event.cc:3917
|
#13 0x00005651894ff960 in apply_event_and_update_pos_apply (ev=ev@entry=0x1536c002ddf8, thd=thd@entry=0x15368c000f88, rgi=rgi@entry=0x1536c00271a0, reason=reason@entry=0) at /test/server_dbg/sql/slave.cc:3918
|
#14 0x000056518950a0bf in apply_event_and_update_pos_for_parallel (ev=ev@entry=0x1536c002ddf8, thd=thd@entry=0x15368c000f88, rgi=rgi@entry=0x1536c00271a0) at /test/server_dbg/sql/slave.cc:4125
|
#15 0x0000565189804938 in rpt_handle_event (qev=qev@entry=0x1536c0027e08, rpt=rpt@entry=0x1536c00101a8) at /test/server_dbg/sql/rpl_parallel.cc:64
|
#16 0x0000565189809774 in handle_rpl_parallel_thread (arg=arg@entry=0x1536c00101a8) at /test/server_dbg/sql/rpl_parallel.cc:1541
|
#17 0x0000565189bdd626 in pfs_spawn_thread (arg=0x1536c0012f58) at /test/server_dbg/storage/perfschema/pfs.cc:2201
|
#18 0x000015370d721609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#19 0x000015370d30d133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.5.25 (dbg), 10.6.18 (dbg), 10.11.8 (dbg), 11.0.6 (dbg), 11.1.4 (dbg), 11.2.4 (dbg), 11.3.2 (dbg), 11.4.2 (dbg), 11.5.0 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.34 (dbg), 10.4.34 (opt), 10.5.25 (opt), 10.6.18 (opt), 10.11.8 (opt), 11.0.6 (opt), 11.1.4 (opt), 11.2.4 (opt), 11.3.2 (opt), 11.4.2 (opt), 11.5.0 (opt)