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

Assertion `!binlog || exist_hton_without_prepare' failed in MYSQL_BIN_LOG::unlog_xa_prepare

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
      --source include/have_log_bin.inc
       
      CREATE TABLE t1 (a INT) ENGINE=MyISAM;
      INSERT INTO t1 VALUES (1),(2);
       
      CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
      INSERT INTO t2 VALUES (1),(2);
       
      XA BEGIN 'x';
      REPLACE INTO t1 SELECT * FROM t1;
      REPLACE INTO t2 SELECT * FROM t2;
      XA END 'x';
      XA PREPARE 'x';
       
      # Cleanup
      XA COMMIT 'x';
      DROP TABLE t1, t2;
      

      10.5 043828bd

      mariadbd: /data/src/10.5/sql/log.cc:10149: virtual int MYSQL_BIN_LOG::unlog_xa_prepare(THD*, bool): Assertion `!binlog || exist_hton_without_prepare' failed.
      200530 22:26:14 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f2f370dff12 in __GI___assert_fail (assertion=0x556040115270 "!binlog || exist_hton_without_prepare", file=0x556040111394 "/data/src/10.5/sql/log.cc", line=10149, function=0x556040117aa0 <MYSQL_BIN_LOG::unlog_xa_prepare(THD*, bool)::__PRETTY_FUNCTION__> "virtual int MYSQL_BIN_LOG::unlog_xa_prepare(THD*, bool)") at assert.c:101
      #8  0x000055603f5f2974 in MYSQL_BIN_LOG::unlog_xa_prepare (this=0x556040d00120 <mysql_bin_log>, thd=0x7f2f00000b18, all=true) at /data/src/10.5/sql/log.cc:10149
      #9  0x000055603f4af35b in ha_prepare (thd=0x7f2f00000b18) at /data/src/10.5/sql/handler.cc:1361
      #10 0x000055603f3e4886 in trans_xa_prepare (thd=0x7f2f00000b18) at /data/src/10.5/sql/xa.cc:531
      #11 0x000055603f1603f0 in mysql_execute_command (thd=0x7f2f00000b18) at /data/src/10.5/sql/sql_parse.cc:5802
      #12 0x000055603f166fb9 in mysql_parse (thd=0x7f2f00000b18, rawbuf=0x7f2f00013a70 "XA PREPARE 'x'", length=14, parser_state=0x7f2f3061b520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7991
      #13 0x000055603f153365 in dispatch_command (command=COM_QUERY, thd=0x7f2f00000b18, packet=0x7f2f000087c9 "XA PREPARE 'x'", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1875
      #14 0x000055603f151a9d in do_command (thd=0x7f2f00000b18) at /data/src/10.5/sql/sql_parse.cc:1356
      #15 0x000055603f2f55fb in do_handle_one_connection (connect=0x556043972d58, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1411
      #16 0x000055603f2f5363 in handle_one_connection (arg=0x556043972d58) at /data/src/10.5/sql/sql_connect.cc:1313
      #17 0x000055603f82c2de in pfs_spawn_thread (arg=0x556043912ed8) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #18 0x00007f2f390684a4 in start_thread (arg=0x7f2f3061c700) at pthread_create.c:456
      #19 0x00007f2f3719cd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Not reproducible on 10.4.
      No obvious effect on a non-debug build.

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: