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

Assertion `thd_killed(thd) || !m_active_tranxs || !m_active_tranxs->is_tranx_end_pos(trx_wait_binlog_name, trx_wait_binlog_pos)' failed in Repl_semi_sync_master::commit_trx

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.7
    • 10.5, 10.6
    • None
    • None

    Description

       
      --source include/have_innodb.inc
      --source include/master-slave.inc
       
      --connection master
      RESET MASTER;
      SET @@GLOBAL.rpl_semi_sync_master_enabled = 1;
       
      --connection slave
      source include/stop_slave.inc;
      SET @@GLOBAL.rpl_semi_sync_slave_enabled = 1;
      source include/start_slave.inc;
       
      connection master;
       
      CREATE TABLE t1 (a INT, b INT);
      CREATE TABLE t2 LIKE t1;
      CREATE TABLE t3 LIKE t1;
      DROP TABLE t1,t2,t3;
      sync_slave_with_master;
       
      STOP SLAVE;
      --source include/wait_for_slave_to_stop.inc
      START SLAVE;
      --source include/wait_for_slave_to_start.inc
       
      --source include/rpl_reset.inc
       
      connection master;
       
      CREATE TABLE t1 (a INT);
      INSERT INTO t1 VALUES (1),(2),(3);
      CREATE TABLE t2 SELECT * FROM t1;
      

      10.5 52b32c60c26b512ccf9b

      mariadbd: 10.5/src/sql/semisync_master.cc:929: int Repl_semi_sync_master::commit_trx(const char*, my_off_t): Assertion `thd_killed(thd) || !m_active_tranxs || !m_active_tranxs->is_tranx_end_pos(trx_wait_binlog_name, trx_wait_binlog_pos)' failed.
      220214 17:58:36 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.5.16-MariaDB-debug-log
       
      sql/signal_handler.cc:225(handle_fatal_signal)[0x55bf05fa8f83]
      sigaction.c:0(__restore_rt)[0x7f873862f3c0]
      ??:0(gsignal)[0x7f873811a18b]
      ??:0(abort)[0x7f87380f9859]
      /lib/x86_64-linux-gnu/libc.so.6(+0x25729)[0x7f87380f9729]
      ??:0(__assert_fail)[0x7f873810af36]
      sql/semisync_master.cc:807(Repl_semi_sync_master::commit_trx(char const*, unsigned long long))[0x55bf05d35554]
      sql/semisync_master.cc:699(Repl_semi_sync_master::wait_after_commit(THD*, bool))[0x55bf05d343db]
      sql/handler.cc:1834(ha_commit_trans(THD*, bool))[0x55bf05fb8076]
      sql/transaction.cc:472(trans_commit_stmt(THD*))[0x55bf05c15db1]
      sql/sql_parse.cc:6117(mysql_execute_command(THD*))[0x55bf057a71aa]
      sql/sql_parse.cc:8100(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55bf057b41c0]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55bf0578a07b]
      sql/sql_parse.cc:1370(do_command(THD*))[0x55bf057869ba]
      sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x55bf05bd2a8f]
      sql/sql_connect.cc:1314(handle_one_connection)[0x55bf05bd22a8]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55bf068f573e]
      nptl/pthread_create.c:478(start_thread)[0x7f8738623609]
      ??:0(clone)[0x7f87381f6293]
       
      Query (0x62b0000f52a8): INSERT INTO t1 VALUES (1),(2),(3)
      

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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