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

Assertion `transaction_.active() == false' failed in virtual wsrep::client_state::~client_state()

    XMLWordPrintable

    Details

      Description

      SET GLOBAL wsrep_on=OFF;
      SET max_session_mem_used = 50000;
      XA START 'a';
      CREATE TEMPORARY TABLE t1(a INT) engine=innodb;
      SET @@session.query_prealloc_size = 30;
      LOAD INDEX INTO CACHE t1;
      SET GLOBAL wsrep_on = TRUE;
      INSERT INTO t1 VALUES(1);
      SHUTDOWN;
      

      Leads to:

      10.6.12 c4ce012e4b3dac44e76598a5d1f2fe92f836eb30 (Optimized)

      mysqld: /test/10.6_opt/wsrep-lib/include/wsrep/client_state.hpp:169: virtual wsrep::client_state::~client_state(): Assertion `transaction_.active() == false' failed.
      

      10.6.12 c4ce012e4b3dac44e76598a5d1f2fe92f836eb30 (Optimized)

      Core was generated by `/test/GAL_MD081122-mariadb-10.6.12-linux-x86_64-opt/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 0x14bf4cebe700 (LWP 898177))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x0000561aa705138f in my_write_core (sig=sig@entry=6) at /test/10.6_opt/mysys/stacktrace.c:424
      #2  0x0000561aa6b87780 in handle_fatal_signal (sig=6) at /test/10.6_opt/sql/signal_handler.cc:355
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000014bf82eb6859 in __GI_abort () at abort.c:79
      #6  0x000014bf82eb6729 in __assert_fail_base (fmt=0x14bf8304c588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x561aa71f1bf0 "transaction_.active() == false", file=0x561aa71f1bb8 "/test/10.6_opt/wsrep-lib/include/wsrep/client_state.hpp", line=169, function=<optimized out>) at assert.c:92
      #7  0x000014bf82ec7fd6 in __GI___assert_fail (assertion=assertion@entry=0x561aa71f1bf0 "transaction_.active() == false", file=file@entry=0x561aa71f1bb8 "/test/10.6_opt/wsrep-lib/include/wsrep/client_state.hpp", line=line@entry=169, function=function@entry=0x561aa71f1b88 "virtual wsrep::client_state::~client_state()") at assert.c:101
      #8  0x0000561aa69166ba in wsrep::client_state::~client_state (this=0x14bf0c006f18, __in_chrg=<optimized out>) at /test/10.6_opt/sql/sql_string.h:231
      #9  Wsrep_client_state::~Wsrep_client_state (this=0x14bf0c006f18, __in_chrg=<optimized out>) at /test/10.6_opt/sql/wsrep_client_state.h:25
      #10 THD::~THD (this=0x14bf0c000c58, __in_chrg=<optimized out>) at /test/10.6_opt/sql/sql_class.cc:1668
      #11 0x0000561aa69166f6 in THD::~THD (this=0x14bf0c000c58, __in_chrg=<optimized out>) at /test/10.6_opt/sql/sql_class.cc:1668
      #12 0x0000561aa6a6cecd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x561aa88d73f8, put_in_cache=put_in_cache@entry=true) at /test/10.6_opt/sql/sql_connect.cc:1457
      #13 0x0000561aa6a6d03d in handle_one_connection (arg=0x561aa88d73f8) at /test/10.6_opt/sql/sql_connect.cc:1318
      #14 0x000014bf833c7609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #15 0x000014bf82fb3133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.5.19 fe330b63fe4ee51a26ac6e222d8eb4ee44a73d50 (Optimized)

      mysqld: /test/10.5_opt/wsrep-lib/include/wsrep/client_state.hpp:169: virtual wsrep::client_state::~client_state(): Assertion `transaction_.active() == false' failed.
      

      10.5.19 fe330b63fe4ee51a26ac6e222d8eb4ee44a73d50 (Optimized)

      Core was generated by `/test/GAL_MD081122-mariadb-10.5.19-linux-x86_64-opt/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 0x14cd5a390700 (LWP 4137690))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x0000562676118b4f in my_write_core (sig=sig@entry=6) at /test/10.5_opt/mysys/stacktrace.c:424
      #2  0x0000562675bee0e0 in handle_fatal_signal (sig=6) at /test/10.5_opt/sql/signal_handler.cc:354
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000014cd9079d859 in __GI_abort () at abort.c:79
      #6  0x000014cd9079d729 in __assert_fail_base (fmt=0x14cd90933588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5626762b85d8 "transaction_.active() == false", file=0x5626762b7fe0 "/test/10.5_opt/wsrep-lib/include/wsrep/client_state.hpp", line=169, function=<optimized out>) at assert.c:92
      #7  0x000014cd907aefd6 in __GI___assert_fail (assertion=assertion@entry=0x5626762b85d8 "transaction_.active() == false", file=file@entry=0x5626762b7fe0 "/test/10.5_opt/wsrep-lib/include/wsrep/client_state.hpp", line=line@entry=169, function=function@entry=0x5626762b85a8 "virtual wsrep::client_state::~client_state()") at assert.c:101
      #8  0x00005626759a1b9a in wsrep::client_state::~client_state (this=0x14cd10006cd8, __in_chrg=<optimized out>) at /test/10.5_opt/sql/sql_string.h:641
      #9  Wsrep_client_state::~Wsrep_client_state (this=0x14cd10006cd8, __in_chrg=<optimized out>) at /test/10.5_opt/sql/wsrep_client_state.h:25
      #10 THD::~THD (this=0x14cd10000c58, __in_chrg=<optimized out>) at /test/10.5_opt/sql/sql_class.cc:1663
      #11 0x00005626759a1bd6 in THD::~THD (this=0x14cd10000c58, __in_chrg=<optimized out>) at /test/10.5_opt/sql/sql_class.cc:1663
      #12 0x0000562675aec2cd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5626782d8b98, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1457
      #13 0x0000562675aec43d in handle_one_connection (arg=0x5626782d8b98) at /test/10.5_opt/sql/sql_connect.cc:1318
      #14 0x000014cd90cae609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #15 0x000014cd9089a133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.4.28 (dbg), 10.4.28 (opt), 10.5.19 (dbg), 10.5.19 (opt), 10.6.12 (dbg), 10.6.12 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.7.8 (dbg), 10.7.8 (opt), 10.8.7 (dbg), 10.8.7 (opt), 10.9.5 (dbg), 10.9.5 (opt), 10.10.3 (dbg), 10.10.3 (opt), 10.11.1 (dbg), 10.11.1 (opt)

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström (Inactive)
            Reporter:
            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.