Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21605 Clean up and speed up interfaces for binary row logging
  3. MDEV-21617

Assertion `binlog_table_maps == 0' failed in THD::reset_for_next_command

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • N/A
    • Replication

    Description

      --source include/have_innodb.inc
      --source include/have_binlog_format_row.inc
       
      CREATE TABLE t1 (
          id INT,
          k INT,
          c CHAR(8),
          KEY (k),
          PRIMARY KEY (id),
          FOREIGN KEY (id) REFERENCES t1 (k)
      ) ENGINE=InnoDB;
      LOCK TABLES t1 WRITE;
      SET SESSION FOREIGN_KEY_CHECKS= OFF;
      SET AUTOCOMMIT=OFF;
      INSERT INTO t1 VALUES (1,1,'foo');
      DROP TABLE t1;
      

      bb-10.5-monty cd129db8

      mysqld: /data/src/bb-10.5-monty/sql/sql_parse.cc:7481: void THD::reset_for_next_command(bool): Assertion `binlog_table_maps == 0' failed.
      200131 15:11:30 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fbfedc62f12 in __GI___assert_fail (assertion=0x55c1bc00c8cd "binlog_table_maps == 0", file=0x55c1bc00b200 "/data/src/bb-10.5-monty/sql/sql_parse.cc", line=7481, function=0x55c1bc00e660 <THD::reset_for_next_command(bool)::__PRETTY_FUNCTION__> "void THD::reset_for_next_command(bool)") at assert.c:101
      #8  0x000055c1bb2b9e8c in THD::reset_for_next_command (this=0x7fbfb0000b00, do_clear_error=true) at /data/src/bb-10.5-monty/sql/sql_parse.cc:7481
      #9  0x000055c1bb2bb36d in mysql_parse (thd=0x7fbfb0000b00, rawbuf=0x7fbfb00135c8 "DROP TABLE t1", length=13, parser_state=0x7fbfe2f67570, is_com_multi=false, is_next_command=false) at /data/src/bb-10.5-monty/sql/sql_parse.cc:7931
      #10 0x000055c1bb2a65a9 in dispatch_command (command=COM_QUERY, thd=0x7fbfb0000b00, packet=0x7fbfb01380a1 "DROP TABLE t1", packet_length=13, is_com_multi=false, is_next_command=false) at /data/src/bb-10.5-monty/sql/sql_parse.cc:1846
      #11 0x000055c1bb2a4d03 in do_command (thd=0x7fbfb0000b00) at /data/src/bb-10.5-monty/sql/sql_parse.cc:1364
      #12 0x000055c1bb446b85 in do_handle_one_connection (connect=0x55c1bf743810, put_in_cache=true) at /data/src/bb-10.5-monty/sql/sql_connect.cc:1422
      #13 0x000055c1bb4468b4 in handle_one_connection (arg=0x55c1bf743810) at /data/src/bb-10.5-monty/sql/sql_connect.cc:1319
      #14 0x000055c1bb9a312b in pfs_spawn_thread (arg=0x55c1bf666d30) at /data/src/bb-10.5-monty/storage/perfschema/pfs.cc:1869
      #15 0x00007fbfefbeb4a4 in start_thread (arg=0x7fbfe2f68700) at pthread_create.c:456
      #16 0x00007fbfedd1fd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Not reproducible on 10.5 main tree 74f76206.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              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.