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

Slave halts upon INSERT trigger leading to errors 1305 and 4094

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4, 11.5
    • N/A
    • None
    • None

    Description

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
      --connection slave
      STOP SLAVE;
      SET GLOBAL slave_run_triggers_for_rbr=LOGGING;
      START SLAVE;
      --connection master
      CREATE TABLE t (c INT);
      INSERT INTO t VALUES (0);
      CREATE TRIGGER tr BEFORE INSERT ON t FOR EACH ROW CALL p2();
      SET SESSION sql_log_bin=0;
      DROP TABLE t;
      CREATE TABLE t (a INT);
      SET SESSION sql_log_bin=1;
      INSERT INTO t VALUES (1);
      --sync_slave_with_master
      DROP TABLE t;
      --source include/rpl_end.inc
      

      Leads to:

      11.5.0 eeba940311ed17d160023280783fd2bbb64abef3 (Debug)

      Slave_SQL_Running	No
      ...
      Last_Errno	1305
      Last_Error	Could not execute Write_rows_v1 event on table test.t; PROCEDURE test.p2 does not exist, Error_code: 1305; At line 1 in test.tr, Error_code: 4094; handler error HA_ERR_GENERIC; the event's master log master-bin.000001, end_log_pos 0
      

      While the error may be correct by itself, note that the master has no issue with executing the statements; only the slave fails.

      Attachments

        Activity

          People

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