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

Replication aborts with ER_KEY_NOT_FOUND on table with key on BLOB and without PK

    XMLWordPrintable

    Details

      Description

      Run with --mysqld=--plugin-load-add=ha_rocksdb

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      CREATE TABLE t1 (b BLOB, i INT, KEY(b(8))) ENGINE=RocksDB;
      INSERT INTO t1 VALUES (REPEAT('a',9),1);
       
      UPDATE t1 SET i = 2;
       
      --sync_slave_with_master
       
      # Cleanup
      --connection master
      DROP TABLE t1;
      --source include/rpl_end.inc
      

      10.2 1cc1d0429da

      2018-07-16 19:11:54 140503152559872 [ERROR] mysqld: Can't find record in 't1'
      2018-07-16 19:11:54 140503152559872 [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 923, Gtid 0-1-3, Internal MariaDB error code: 1032
      2018-07-16 19:11:54 140503152559872 [Warning] Slave: Can't find record in 't1' Error_code: 1032
      2018-07-16 19:11:54 140503152559872 [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 726
      

      Reproducible regardless of parallel replication or parallel replication mode.
      Also reproducible on bb-10.2-mdev16428 b528b069a16.

      Not reproducible with InnoDB.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated: