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

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

    XMLWordPrintable

    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

       

        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:

                Smart Checklist