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

Assertion `binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES' failed in THD::reset_for_next_command

    XMLWordPrintable

Details

    Description

      Update: See the test case and further information in the comments


      origin/10.5 718f18599a9bcf1e7c2d3f18416fca4f7124d00d 2020-03-26T16:05:25+02:00
      debug build with ASAN
      Assert hit during RQG testing
      mysqld: sql/sql_parse.cc:7444: void THD::reset_for_next_command(bool): Assertion `binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES' failed.
      200326 14:50:05 [ERROR] mysqld got signal 6 ;
      ...
      Query (0x62b0000a1238): SELECT * FROM `table0_innodb_int_autoinc` AS X WHERE X.`col_char_12_key` IN ( 127, 'y', 's', 230, 'n' ) LIMIT 6  /* E_R Thread1 QNO 35521 CON_ID 12 */
      ...
      Status: NOT_KILLED
       
      Thread 1 (Thread 0x7fa5b53d0300 (LWP 69908)):
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000055a8b419f774 in my_write_core (sig=6) at mysys/stacktrace.c:518
      #2  0x000055a8b2c2f7b8 in handle_fatal_signal (sig=6) at sql/signal_handler.cc:325
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
      #5  0x00007fa5d2865801 in __GI_abort () at abort.c:79
      #6  0x00007fa5d285539a in __assert_fail_base (fmt=0x7fa5d29dc7d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55a8b46346a0 "binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES", file=file@entry=0x55a8b46309e0 "sql/sql_parse.cc", line=line@entry=7444, function=function@entry=0x55a8b4637f00 <THD::reset_for_next_command(bool)::__PRETTY_FUNCTION__> "void THD::reset_for_next_command(bool)") at assert.c:92
      #7  0x00007fa5d2855412 in __GI___assert_fail (assertion=0x55a8b46346a0 "binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES", file=0x55a8b46309e0 "sql/sql_parse.cc", line=7444, function=0x55a8b4637f00 <THD::reset_for_next_command(bool)::__PRETTY_FUNCTION__> "void THD::reset_for_next_command(bool)") at assert.c:101
      #8  0x000055a8b2492d74 in THD::reset_for_next_command (this=0x62b00009a218, do_clear_error=true) at sql/sql_parse.cc:7443
      #9  0x000055a8b2495de0 in mysql_parse (thd=0x62b00009a218, rawbuf=0x62b0000a1238 "SELECT * FROM `table0_innodb_int_autoinc` AS X WHERE X.`col_char_12_key` IN ( 127, 'y', 's', 230, 'n' ) LIMIT 6  /* E_R Thread1 QNO 35521 CON_ID 12 */", length=150, parser_state=0x7fa5b53ce8f0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:7894
      #10 0x000055a8b246bce7 in dispatch_command (command=COM_QUERY, thd=0x62b00009a218, packet=0x629000b59219 "SELECT * FROM `table0_innodb_int_autoinc` AS X WHERE X.`col_char_12_key` IN ( 127, 'y', 's', 230, 'n' ) LIMIT 6  /* E_R Thread1 QNO 35521 CON_ID 12 */ ", packet_length=151, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1839
      #11 0x000055a8b2468682 in do_command (thd=0x62b00009a218) at sql/sql_parse.cc:1358
      #12 0x000055a8b288db4d in do_handle_one_connection (connect=0x608000003a38, put_in_cache=true) at sql/sql_connect.cc:1422
      #13 0x000055a8b288d3e9 in handle_one_connection (arg=0x6080000036b8) at sql/sql_connect.cc:1319
      #14 0x000055a8b3537f8b in pfs_spawn_thread (arg=0x615000004918) at storage/perfschema/pfs.cc:2201
      #15 0x00007fa5d37606db in start_thread (arg=0x7fa5b53d0300) at pthread_create.c:463
      #16 0x00007fa5d294688f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Hitting this assert seems to be rare.
      
      

      Attachments

        1. 000099.log
          605 kB
          Matthias Leich

        Issue Links

          Activity

            People

              monty Michael Widenius
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.