Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-35218

Assertion `is_wsrep() == wsrep_on(mysql_thd)' failed in void trx_t::commit_in_memory(const mtr_t*)

    XMLWordPrintable

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)

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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