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

#3 Assertion `binlog_table_maps == 0 || locked_tables_mode == LTM _LOCK_TABLES' failed

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      # Run with
      #  --mysqld=--binlog_format=row --mysqld=--wsrep-cluster-address=gcomm:// --mysqld=--wsrep-on --mysqld=--wsrep-provider=/lib/libgalera_smm.so
      # (use any valid path to Galera library)
      # The sleep is for WSREP to start up, it should disappear
      # when the test case is added to the galera suite
      --sleep 3
       
      --source include/have_innodb.inc
       
      CREATE TABLE t (a INT) ENGINE=InnoDB;
      --delimiter $
      CREATE FUNCTION f() RETURNS INT
      BEGIN
        INSERT INTO t VALUES (1);
        RETURN 0;
      END $
      --delimiter ;
       
      START TRANSACTION;
      SELECT f();
      ROLLBACK;
       
      DROP TABLE t;
      DROP FUNCTION f;
      

      main 8cb64d1c900469b30273dd2bc5998a72f5851919

      mariadbd: /data/bld/main-asan-ubsan/sql/sql_parse.cc:7446: void THD::reset_for_next_command(bool): Assertion `binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES' failed.
      260125 21:26:27 [ERROR] /share8t/bld/main-asan-ubsan/sql/mariadbd got signal 6 ;
       
      #10 0x00007fe9ae853eb2 in __GI___assert_fail (assertion=0x55ae3873daa0 "binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES", file=0x55ae38737b00 "/data/bld/main-asan-ubsan/sql/sql_parse.cc", line=7446, function=0x55ae3873da00 "void THD::reset_for_next_command(bool)") at ./assert/assert.c:101
      #11 0x000055ae3493d5a3 in THD::reset_for_next_command (this=this@entry=0x62c000230218, do_clear_error=do_clear_error@entry=true) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:7446
      #12 0x000055ae34983d4c in mysql_parse (thd=thd@entry=0x62c000230218, rawbuf=rawbuf@entry=0x62d0001f4438 "ROLLBACK", length=length@entry=8, parser_state=parser_state@entry=0x7fe990312a10) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:7891
      #13 0x000055ae34988790 in wsrep_mysql_parse (thd=thd@entry=0x62c000230218, rawbuf=0x62d0001f4438 "ROLLBACK", length=8, parser_state=parser_state@entry=0x7fe990312a10) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:7755
      #14 0x000055ae3498e025 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c000230218, packet=packet@entry=0x6290002fd219 "ROLLBACK", packet_length=packet_length@entry=8, blocking=blocking@entry=true) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:1883
      #15 0x000055ae3499af07 in do_command (thd=thd@entry=0x62c000230218, blocking=blocking@entry=true) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:1432
      #16 0x000055ae351faa48 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x60800002abb8, put_in_cache=put_in_cache@entry=true) at /data/bld/main-asan-ubsan/sql/sql_connect.cc:1503
      #17 0x000055ae351fbbb1 in handle_one_connection (arg=0x60800002abb8) at /data/bld/main-asan-ubsan/sql/sql_connect.cc:1415
      #18 0x000055ae36e4ece3 in pfs_spawn_thread (arg=0x61700002df98) at /data/bld/main-asan-ubsan/storage/perfschema/pfs.cc:2198
      #19 0x00007fe9ae8a81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #20 0x00007fe9ae92885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      The failure started happening after the main commit of MDEV-34705:

      commit 7081f2a58ec459c55296dcf700e2f4cc1c85b4e7
      Author: Kristian Nielsen
      Date:   Sun Feb 25 17:41:50 2024 +0100
       
          Binlog-in-engine: New binlog implementation integrated in InnoDB
      

      Attachments

        Issue Links

          Activity

            People

              knielsen Kristian Nielsen
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.