Bug #18250 Truncate table replicates both as statement and as row for SE using injector
Submitted: 15 Mar 2006 10:19 Modified: 18 Mar 2006 18:04
Reporter: Mats Kindahl Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.1.8 OS:Any (ALL)
Assigned to: Mats Kindahl CPU Architecture:Any

[15 Mar 2006 10:19] Mats Kindahl
Description:
Truncate table is replicated both using as a statement and as individual row deletions when the storage engine is using the injector.

How to repeat:
master> create table t1 (a int, b int) engine=ndb;
master> insert into t1 values (1,1);
master> delete from t1;
master> show binlog events;
(Notice that the binlog contain both the delete statement and individual row deletions.)

slave> show slave status;
(Notice that the slave has stopped.)

Suggested fix:
Do not replicate the truncate/delete as a statement when the storage engine is using the injector.
[18 Mar 2006 18:04] Paul DuBois
No changelog entry needed.