Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL)
-
None
Description
--source include/have_binlog_format_row.inc
|
--source include/master-slave.inc
|
--connection slave
|
STOP SLAVE;
|
SET GLOBAL slave_run_triggers_for_rbr=LOGGING; |
START SLAVE;
|
--connection master
|
CREATE TABLE t1 (c INT); |
CREATE TABLE t2 (c INT); |
INSERT INTO t1 VALUES(1); |
INSERT INTO t2 VALUES(0); |
CREATE TRIGGER tr1 BEFORE DELETE ON t1 FOR EACH ROW DELETE FROM t2; |
DELETE FROM t1; |
--sync_slave_with_master
|
DROP TABLE t1,t2; |
--source include/rpl_end.inc |
Leads to:
11.5.0 eeba940311ed17d160023280783fd2bbb64abef3 (Debug) |
Slave_SQL_Running No
|
...
|
Last_Errno 1442
|
Last_Error Could not execute Delete_rows_v1 event on table test.t1; Can't update table 't2' in stored function/trigger because it is already used by statement which invoked this stored function/trigger, Error_code: 1442; At line 1 in test.tr1, Error_code: 4094; handler error HA_ERR_GENERIC; the event's master log master-bin.000001, end_log_pos 0
|
The error is not correct as t2 is not being used by the DELETE statement as mentioned in the error.
Note also that the master has no issue with executing the statements, only the slave fails.
Attachments
Issue Links
- relates to
-
MDEV-34927 Error_code: 4094; handler error HA_ERR_GENERIC and Internal MariaDB error code: 1366/1442 on tigger related binlog attempt
- Open