Bug #41466 online add partition with replication looses data
Submitted: 15 Dec 2008 11:14 Modified: 20 Dec 2008 20:08
Reporter: Tomas Ulin Email Updates:
Status: Closed Impact on me:
Category:MySQL Cluster: Replication Severity:S3 (Non-critical)
Version:cluster 6.4 OS:Any
Assigned to: Jonas Oreland CPU Architecture:Any

[15 Dec 2008 11:14] Tomas Ulin
./mtr --start-and-exit rpl_ndb_basic

slave> change master to master_host='',master_port=9306,master_user='root';
slave> start slave;

master> create table t1 (a int key auto_increment) engine ndb;
while true; do master -e "update t1 set b=b+1 where a=1"; sleep 1; done

master1> set sql_log_bin=0;
master1> alter online table t1 add partition partitions 1;

ctrl-C the insert loop...

master1> select count(*) from t1;
slave> select count(*) from t1;

check if same...

if not start insert loop... repeat a few times and at some point there will be a diff between master and slave...

How to repeat:
[20 Dec 2008 20:08] Jonas Oreland
no release, no docs