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

RBR aborts with ER_NO_SUCH_TABLE, Internal MariaDB error code: 1146 upon INSERT DELAYED inside trx

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
    • 10.5, 10.6, 10.11
    • Replication
    • None

    Description

      Few similarities with MDEV-16909, but different versions affected and different testcase and scenario.

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      SET autocommit=0;
       
      --error ER_UNKNOWN_STORAGE_ENGINE
      CREATE TABLE t1 (c1 INT) ENGINE=foo;
       
      --error ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SQL_LOG_BIN
      CALL sys.statement_performance_analyzer('OVERALL', NULL, 'with_full_table_scans');
       
      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (c1 VARCHAR(64), PRIMARY KEY(c1)) ENGINE=MyISAM;
      INSERT DELAYED t1 VALUES (4);
       
      --sync_slave_with_master
      --source include/rpl_end.inc
      

      Leads to:

      10.11.7 09049fe496eea1c19cd3ce80a788fa4b75d9609e (Debug)

      2024-02-03 13:10:27 5 [Note] Slave I/O thread: connected to master 'repl_user@127.0.0.1:12555',replication starts at GTID position ''
      2024-02-03 13:10:29 6 [ERROR] Slave SQL: Error executing row event: 'Table 'test.t1' doesn't exist', Gtid 0-1-4, Internal MariaDB error code: 1146
      2024-02-03 13:10:29 6 [Warning] Slave: Table 'test.t1' doesn't exist Error_code: 1146
      2024-02-03 13:10:29 6 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.000001' position 959; GTID position '0-1-3'
      

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.