Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4, 11.5
-
None
-
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 t (c INT); |
INSERT INTO t VALUES (0); |
CREATE TRIGGER tr BEFORE INSERT ON t FOR EACH ROW CALL p2(); |
SET SESSION sql_log_bin=0; |
DROP TABLE t; |
CREATE TABLE t (a INT); |
SET SESSION sql_log_bin=1; |
INSERT INTO t VALUES (1); |
--sync_slave_with_master
|
DROP TABLE t; |
--source include/rpl_end.inc |
Leads to:
11.5.0 eeba940311ed17d160023280783fd2bbb64abef3 (Debug) |
Slave_SQL_Running No
|
...
|
Last_Errno 1305
|
Last_Error Could not execute Write_rows_v1 event on table test.t; PROCEDURE test.p2 does not exist, Error_code: 1305; At line 1 in test.tr, Error_code: 4094; handler error HA_ERR_GENERIC; the event's master log master-bin.000001, end_log_pos 0
|
While the error may be correct by itself, note that the master has no issue with executing the statements; only the slave fails.