Details
Description
CREATE PROCEDURE proc_1() LOAD INDEX INTO CACHE new_t7 IGNORE LEAVES; |
DROP TABLE IF EXISTS t; |
SET max_session_mem_used=8192; |
CREATE TABLE t (id INT KEY); |
SELECT * FROM t; |
SET GLOBAL wsrep_on=OFF; |
BEGIN; |
CALL proc_1();
|
SET GLOBAL wsrep_on=ON; |
SELECT * FROM t; |
CALL proc_1();
|
Leads to:
CS 10.11.10 649e08f8b3c62414b31b23c64d960b9e3269c415 (Debug) |
mysqld: /test/10.11_dbg/storage/innobase/trx/trx0trx.cc:1501: void trx_t::commit_in_memory(const mtr_t*): Assertion `is_wsrep() == wsrep_on(mysql_thd)' failed.
|
CS 10.11.10 649e08f8b3c62414b31b23c64d960b9e3269c415 (Debug) |
Core was generated by `/test/GAL_MD181024-mariadb-10.11.10-linux-x86_64-dbg/bin/mysqld --defaults-file'.
|
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 0x1477dc979700 (LWP 872517))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x000055c0bceaa869 in my_write_core (sig=sig@entry=6) at /test/10.11_dbg/mysys/stacktrace.c:424
|
#2 0x000055c0bc761db3 in handle_fatal_signal (sig=6) at /test/10.11_dbg/sql/signal_handler.cc:366
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x00001478165c5859 in __GI_abort () at abort.c:79
|
#6 0x00001478165c5729 in __assert_fail_base (fmt=0x14781675b588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55c0bd33f058 "is_wsrep() == wsrep_on(mysql_thd)", file=0x55c0bd33e488 "/test/10.11_dbg/storage/innobase/trx/trx0trx.cc", line=1501, function=<optimized out>) at assert.c:92
|
#7 0x00001478165d6fd6 in __GI___assert_fail (assertion=assertion@entry=0x55c0bd33f058 "is_wsrep() == wsrep_on(mysql_thd)", file=file@entry=0x55c0bd33e488 "/test/10.11_dbg/storage/innobase/trx/trx0trx.cc", line=line@entry=1501, function=function@entry=0x55c0bd33ef50 "void trx_t::commit_in_memory(const mtr_t*)") at assert.c:101
|
#8 0x000055c0bccb5c0f in trx_t::commit_in_memory (mtr=<optimized out>, this=0x147814815680) at /test/10.11_dbg/storage/innobase/include/trx0trx.h:758
|
#9 trx_t::commit_low (this=this@entry=0x147814815680, mtr=<optimized out>) at /test/10.11_dbg/storage/innobase/trx/trx0trx.cc:1596
|
#10 0x000055c0bccb5f37 in trx_t::commit_persist (this=this@entry=0x147814815680) at /test/10.11_dbg/storage/innobase/trx/trx0trx.cc:1610
|
#11 0x000055c0bccb5fb9 in trx_t::commit (this=this@entry=0x147814815680) at /test/10.11_dbg/storage/innobase/trx/trx0trx.cc:1619
|
#12 0x000055c0bcca6f0d in trx_t::rollback_finish (this=0x147814815680) at /test/10.11_dbg/storage/innobase/trx/trx0roll.cc:65
|
#13 trx_t::rollback_low (this=this@entry=0x147814815680, savept=savept@entry=0x0) at /test/10.11_dbg/storage/innobase/trx/trx0roll.cc:132
|
#14 0x000055c0bcca3a08 in trx_rollback_for_mysql_low (trx=0x147814815680) at /test/10.11_dbg/storage/innobase/trx/trx0roll.cc:198
|
#15 trx_rollback_for_mysql (trx=trx@entry=0x147814815680) at /test/10.11_dbg/storage/innobase/trx/trx0roll.cc:233
|
#16 0x000055c0bca66e33 in innobase_rollback (hton=<optimized out>, thd=0x1477b0000d48, rollback_trx=<optimized out>) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:4648
|
#17 0x000055c0bc767566 in ha_rollback_trans (thd=thd@entry=0x1477b0000d48, all=all@entry=true) at /test/10.11_dbg/sql/handler.cc:2281
|
#18 0x000055c0bc5f6382 in trans_rollback_implicit (thd=thd@entry=0x1477b0000d48) at /test/10.11_dbg/sql/transaction.cc:441
|
#19 0x000055c0bc5f466b in mysql_admin_table (thd=thd@entry=0x1477b0000d48, tables=tables@entry=0x1477b009cf88, check_opt=check_opt@entry=0x0, operator_name=operator_name@entry=0x55c0bd88cc30 <msg_preload_keys>, lock_type=lock_type@entry=TL_READ_NO_INSERT, org_open_for_modify=org_open_for_modify@entry=false, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=&virtual table offset 752, view_operator_func=0x0, is_cmd_replicated=false) at /test/10.11_dbg/sql/sql_admin.cc:1390
|
#20 0x000055c0bc5f4d28 in mysql_preload_keys (thd=thd@entry=0x1477b0000d48, tables=tables@entry=0x1477b009cf88) at /test/10.11_dbg/sql/sql_admin.cc:1544
|
#21 0x000055c0bc479554 in mysql_execute_command (thd=0x1477b0000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.11_dbg/sql/sql_parse.cc:4130
|
#22 0x000055c0bc3a5b6a in sp_instr_stmt::exec_core (this=0x1477b009d6a0, thd=<optimized out>, nextp=0x1477dc9771f4) at /test/10.11_dbg/sql/sp_head.cc:3924
|
#23 0x000055c0bc3b3288 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x1477b009d6e8, thd=thd@entry=0x1477b0000d48, nextp=nextp@entry=0x1477dc9771f4, open_tables=open_tables@entry=false, instr=instr@entry=0x1477b009d6a0) at /test/10.11_dbg/sql/sp_head.cc:3646
|
#24 0x000055c0bc3b39d4 in sp_instr_stmt::execute (this=0x1477b009d6a0, thd=0x1477b0000d48, nextp=0x1477dc9771f4) at /test/10.11_dbg/sql/sp_head.cc:3827
|
#25 0x000055c0bc3af878 in sp_head::execute (this=this@entry=0x1477b009bfb0, thd=thd@entry=0x1477b0000d48, merge_da_on_success=merge_da_on_success@entry=true) at /test/10.11_dbg/sql/sp_head.cc:1463
|
#26 0x000055c0bc3b1416 in sp_head::execute_procedure (this=0x1477b009bfb0, thd=thd@entry=0x1477b0000d48, args=0x1477b0005f58) at /test/10.11_dbg/sql/sp_head.cc:2479
|
#27 0x000055c0bc46bf88 in do_execute_sp (thd=thd@entry=0x1477b0000d48, sp=sp@entry=0x1477b009bfb0) at /test/10.11_dbg/sql/sql_parse.cc:3065
|
#28 0x000055c0bc471572 in Sql_cmd_call::execute (this=0x1477b0013350, thd=0x1477b0000d48) at /test/10.11_dbg/sql/sql_parse.cc:3310
|
#29 0x000055c0bc47eb3f in mysql_execute_command (thd=thd@entry=0x1477b0000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.11_dbg/sql/sql_parse.cc:6142
|
#30 0x000055c0bc46613f in mysql_parse (thd=thd@entry=0x1477b0000d48, rawbuf=rawbuf@entry=0x1477b0013290 "CALL proc_1()", length=length@entry=13, parser_state=parser_state@entry=0x1477dc978300) at /test/10.11_dbg/sql/sql_parse.cc:8161
|
#31 0x000055c0bc465a45 in wsrep_mysql_parse (thd=thd@entry=0x1477b0000d48, rawbuf=0x1477b0013290 "CALL proc_1()", length=13, parser_state=parser_state@entry=0x1477dc978300) at /test/10.11_dbg/sql/sql_parse.cc:7971
|
#32 0x000055c0bc4743c8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1477b0000d48, packet=packet@entry=0x1477b000af59 "", packet_length=packet_length@entry=13, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_class.h:1400
|
#33 0x000055c0bc476a80 in do_command (thd=0x1477b0000d48, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_parse.cc:1408
|
#34 0x000055c0bc5e12a3 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55c0c0855918, put_in_cache=put_in_cache@entry=true) at /test/10.11_dbg/sql/sql_connect.cc:1417
|
#35 0x000055c0bc5e177d in handle_one_connection (arg=0x55c0c0855918) at /test/10.11_dbg/sql/sql_connect.cc:1319
|
#36 0x0000147816ad6609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#37 0x00001478166c2133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.5.27 (dbg), 10.6.20 (dbg), 10.11.10 (dbg), 11.2.6 (dbg), 11.4.4 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.5.27 (opt), 10.6.20 (opt), 10.11.10 (opt), 11.2.6 (opt), 11.4.4 (opt)