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

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

    XMLWordPrintable

    Details

      Description

      Note: Run with --mysqld=--plugin-load-add=ha_rocksdb. Parallel replication and optimistic mode don't make any difference, reproducible with and without them.

      --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
       
      # Cleanup
      --connection master
      DROP TABLE t2, t1;
      --source include/rpl_end.inc
      

      10.2 8b0d4cff076

      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
      

      Also reproducible on bb-10.2-mdev16428 af1568668.
      Not reproducible with InnoDB.

        Attachments

          Activity

            People

            Assignee:
            psergey Sergei Petrunia
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: