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
• Status: Closed
• 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.