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

Assertion `state_ == s_exec' failed in int wsrep::client_state::after_row()

    XMLWordPrintable

Details

    Description

      SET @@global.slow_query_log = TRUE;
      SET GLOBAL log_output = 'TABLE';
      SET log_queries_not_using_indexes= TRUE;
      SET @@local.slow_query_log = ON;
      SET SESSION wsrep_trx_fragment_size = 64;
      SELECT name, mtype, prtype, len FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS WHERE name = 'p';
      SELECT 1;
      

      Leads to:

      10.4.20 b2bb747f8cf56cf01dc571ffd8be195b95f0c0e8 (Debug)

      mysqld: /test/10.4_dbg/wsrep-lib/include/wsrep/client_state.hpp:398: int wsrep::client_state::after_row(): Assertion `state_ == s_exec' failed.
      

      10.4.20 b2bb747f8cf56cf01dc571ffd8be195b95f0c0e8 (Debug)

      Core was generated by `/test/GAL_MD120521-mariadb-10.4.20-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 0x148bf80b4700 (LWP 3633880))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x00005584d6d764bd in my_write_core (sig=sig@entry=6) at /test/10.4_dbg/mysys/stacktrace.c:386
      #2  0x00005584d647e360 in handle_fatal_signal (sig=6) at /test/10.4_dbg/sql/signal_handler.cc:356
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x0000148bfc130859 in __GI_abort () at abort.c:79
      #6  0x0000148bfc130729 in __assert_fail_base (fmt=0x148bfc2c6588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5584d6e4c55d "state_ == s_exec", file=0x5584d6e43330 "/test/10.4_dbg/wsrep-lib/include/wsrep/client_state.hpp", line=398, function=<optimized out>) at assert.c:92
      #7  0x0000148bfc141f36 in __GI___assert_fail (assertion=assertion@entry=0x5584d6e4c55d "state_ == s_exec", file=file@entry=0x5584d6e43330 "/test/10.4_dbg/wsrep-lib/include/wsrep/client_state.hpp", line=line@entry=398, function=function@entry=0x5584d6fc9128 "int wsrep::client_state::after_row()") at assert.c:101
      #8  0x00005584d6481338 in wsrep::client_state::after_row (this=0x148b70006f68) at /test/10.4_dbg/sql/wsrep_thd.h:200
      #9  wsrep_after_row (thd=0x148b70000d90) at /test/10.4_dbg/sql/wsrep_trans_observer.h:172
      #10 wsrep_after_row (thd=0x148b70000d90) at /test/10.4_dbg/sql/handler.cc:6568
      #11 0x00005584d649106d in handler::ha_write_row (this=0x148b7039c3c8, buf=0x148b703a0a88 "`\233\257\325\a\224\361\031") at /test/10.4_dbg/sql/handler.cc:6766
      #12 0x00005584d65d6b39 in Log_to_csv_event_handler::log_slow (this=<optimized out>, thd=0x148b70000d90, current_time=<optimized out>, user_host=0x148bf80b30c0 "root[root] @ localhost []", user_host_len=25, query_utime=<optimized out>, lock_utime=294, is_command=false, sql_text=0x148b70013238 "SELECT name, mtype, prtype, len FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS WHERE name = 'p'", sql_text_len=91) at /test/10.4_dbg/sql/log.cc:998
      #13 0x00005584d65ce76e in LOGGER::slow_log_print (this=this@entry=0x5584d7757e00 <logger>, thd=thd@entry=0x148b70000d90, query=0x148b70013238 "SELECT name, mtype, prtype, len FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS WHERE name = 'p'", query_length=91, current_utime=<optimized out>) at /test/10.4_dbg/sql/log.cc:1365
      #14 0x00005584d65d81bb in slow_log_print (thd=thd@entry=0x148b70000d90, query=<optimized out>, query_length=<optimized out>, current_utime=<optimized out>) at /test/10.4_dbg/sql/log.cc:6625
      #15 0x00005584d619b2a8 in log_slow_statement (thd=thd@entry=0x148b70000d90) at /test/10.4_dbg/sql/sql_class.h:1184
      #16 0x00005584d61b5dcd in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148b70000d90, packet=<optimized out>, packet@entry=0x148b7001b671 "", packet_length=<optimized out>, packet_length@entry=91, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:2460
      #17 0x00005584d61b6e46 in do_command (thd=0x148b70000d90) at /test/10.4_dbg/sql/sql_parse.cc:1373
      #18 0x00005584d62f20bd in do_handle_one_connection (connect=connect@entry=0x5584da9870e0) at /test/10.4_dbg/sql/sql_connect.cc:1412
      #19 0x00005584d62f21dc in handle_one_connection (arg=0x5584da9870e0) at /test/10.4_dbg/sql/sql_connect.cc:1316
      #20 0x0000148bfc63e609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #21 0x0000148bfc22d293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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