Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL)
-
None
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
Issue Links
- relates to
-
MDEV-33291 Slave SQL: Could not execute Delete_rows_v1/Update_rows_v1 event; Can't find record, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND or HA_ERR_NO_PARTITION_FOUND
- Open