Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5219

Slave SQL: Could not execute Update_rows_v1 event with RocksDB and triggers

    Details

      Description

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=RocksDB;
      INSERT INTO t1 VALUES (1);
       
      CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=RocksDB;
       
      CREATE TRIGGER tr AFTER INSERT ON t2 FOR EACH ROW INSERT INTO non_existing_table VALUES (NULL);
       
      BEGIN;
      DELETE FROM t1;
      --error 0,ER_NO_SUCH_TABLE
      INSERT INTO t2 VALUES (1);
      --error 0,ER_NO_SUCH_TABLE
      INSERT INTO t2 VALUES (2);
      REPLACE INTO t1 SELECT * FROM t1;
      COMMIT;
       
      --sync_slave_with_master
      

      Slave

      2018-07-08 21:04:28 140091034605312 [ERROR] mysqld: Can't find record in 't1'
      2018-07-08 21:04:28 140091034605312 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 1407, Gtid 0-1-5, Internal MariaDB error code: 1032
      2018-07-08 21:04:28 140091034605312 [Warning] Slave: Can't find record in 't1' Error_code: 1032
      2018-07-08 21:04:28 140091034605312 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 1101
      

      Originally reported to MariaDB but confirmed upstream

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                george.lorch George Lorch
                Reporter:
                george.lorch George Lorch
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: