# mysqld options required for replay: --log-bin 

SET GLOBAL autocommit=0;

SET GLOBAL event_scheduler= ON;

SET timestamp=12345;

CREATE TABLE t1 (c1 INT ZEROFILL NULL);

CREATE EVENT e1 ON SCHEDULE AT current_timestamp + INTERVAL 1 DAY DO INSERT INTO t1 VALUES (1);

SELECT SLEEP (3);

mysqld: /test/10.6_dbg/sql/sql_class.h:4360: void THD::restore_stmt_binlog_format(enum_binlog_format): Assertion `!is_current_stmt_binlog_format_row()' failed.

Core was generated by `/test/MD010121-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

[Current thread is 1 (Thread 0x152c90664700 (LWP 1680884))]

(gdb) bt

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

#1  0x0000557e964840d7 in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424

#2  0x0000557e95c18ab1 in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:330

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#5  0x0000152c93303859 in __GI_abort () at abort.c:79

#6  0x0000152c93303729 in __assert_fail_base (fmt=0x152c93499588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x557e965d8130 "!is_current_stmt_binlog_format_row()", file=0x557e965c21e0 "/test/10.6_dbg/sql/sql_class.h", line=4360, function=<optimized out>) at assert.c:92

#7  0x0000152c93314f36 in __GI___assert_fail (assertion=assertion@entry=0x557e965d8130 "!is_current_stmt_binlog_format_row()", file=file@entry=0x557e965c21e0 "/test/10.6_dbg/sql/sql_class.h", line=line@entry=4360, function=function@entry=0x557e965d8158 "void THD::restore_stmt_binlog_format(enum_binlog_format)") at assert.c:101

#8  0x0000557e95a86486 in THD::restore_stmt_binlog_format (format=BINLOG_FORMAT_STMT, this=0x152c30004008) at /test/10.6_dbg/sql/sql_class.h:4360

#9  Events::drop_event (thd=thd@entry=0x152c30004008, dbname=dbname@entry=0x152c90663b88, name=name@entry=0x152c90663b98, if_exists=if_exists@entry=false) at /test/10.6_dbg/sql/events.cc:629

#10 0x0000557e95a843ea in Event_job_data::execute (this=this@entry=0x152c90663b40, thd=thd@entry=0x152c30004008, drop=<optimized out>) at /test/10.6_dbg/sql/event_data_objects.cc:1543

#11 0x0000557e95e4011d in Event_worker_thread::run (this=this@entry=0x152c90663ddf, thd=thd@entry=0x152c30004008, event=event@entry=0x152c30002230) at /test/10.6_dbg/sql/event_scheduler.cc:323

#12 0x0000557e95e40309 in event_worker_thread (arg=arg@entry=0x152c30002230) at /test/10.6_dbg/sql/event_scheduler.cc:268

#13 0x0000557e95f6388f in pfs_spawn_thread (arg=0x152c2c01b918) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201

#14 0x0000152c93811609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#15 0x0000152c93400293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

mysqld: /test/10.4_dbg/sql/sql_base.cc:897: void close_thread_tables(THD*): Assertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)' failed.

Core was generated by `/test/MD010121-mariadb-10.4.18-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

[Current thread is 1 (Thread 0x151838085700 (LWP 1751357))]

(gdb) bt

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

#1  0x000055674b19eebd in my_write_core (sig=sig@entry=6) at /test/10.4_dbg/mysys/stacktrace.c:386

#2  0x000055674a8b5abf in handle_fatal_signal (sig=6) at /test/10.4_dbg/sql/signal_handler.cc:343

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#5  0x000015184d5f7859 in __GI_abort () at abort.c:79

#6  0x000015184d5f7729 in __assert_fail_base (fmt=0x15184d78d588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55674b268ec0 "thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)", file=0x55674b268770 "/test/10.4_dbg/sql/sql_base.cc", line=897, function=<optimized out>) at assert.c:92

#7  0x000015184d608f36 in __GI___assert_fail (assertion=assertion@entry=0x55674b268ec0 "thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)", file=file@entry=0x55674b268770 "/test/10.4_dbg/sql/sql_base.cc", line=line@entry=897, function=function@entry=0x55674b268ea0 "void close_thread_tables(THD*)") at assert.c:101

#8  0x000055674a555d67 in close_thread_tables (thd=thd@entry=0x1517d0003b10) at /test/10.4_dbg/sql/handler.h:1771

#9  0x000055674aacfe6c in Event_db_repository::drop_event (this=0x55674d0f1830, thd=thd@entry=0x1517d0003b10, db=db@entry=0x151838084d90, name=name@entry=0x151838084da0, drop_if_exists=drop_if_exists@entry=false) at /test/10.4_dbg/sql/event_db_repository.cc:923

#10 0x000055674a70865e in Events::drop_event (thd=thd@entry=0x1517d0003b10, dbname=dbname@entry=0x151838084d90, name=name@entry=0x151838084da0, if_exists=if_exists@entry=false) at /test/10.4_dbg/sql/events.cc:616

#11 0x000055674a7067cd in Event_job_data::execute (this=this@entry=0x151838084d40, thd=thd@entry=0x1517d0003b10, drop=<optimized out>) at /test/10.4_dbg/sql/event_data_objects.cc:1520

#12 0x000055674aaca5e1 in Event_worker_thread::run (this=this@entry=0x151838084e4f, thd=thd@entry=0x1517d0003b10, event=event@entry=0x1517d0001f70) at /test/10.4_dbg/sql/event_scheduler.cc:313

#13 0x000055674aaca7d8 in event_worker_thread (arg=0x1517d0001f70) at /test/10.4_dbg/sql/event_scheduler.cc:267

#14 0x000015184dbb4609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#15 0x000015184d6f4293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95