Bug #49456 replication out of sync
Submitted: 4 Dec 2009 12:04 Modified: 4 Dec 2009 12:04
Reporter: Matthias Leich Email Updates:
Status: Analyzing Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:mysql-5.1-rep+3 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[4 Dec 2009 12:04] Matthias Leich
Description:
When running a RQG test I get a difference between
master and slave.

My command line
---------------
runall.pl \
--basedir=/work2/5.1/mysql-5.1-rep+3 \
--vardir=/dev/shm/var_290 \
--debug \
--duration=600 \
--rpl_mode=default \
--mysqld=--table-lock-wait-timeout=1 \
--mysqld=--loose-innodb-lock-wait-timeout=5 \
--mysqld=--innodb_log_file_size=16M \
--mysqld=--log-output=table \
--mysqld=--skip-safemalloc \
--mysqld=--plugin-dir=/work2/5.1/mysql-5.1-rep+3/plugin/semisync/.libs \
--mysqld=--plugin-load=rpl_semi_sync_master=libsemisync_master.so:rpl_semi_sync_slave=libsemisync_slave.so \
--mysqld=--rpl_semi_sync_master_enabled=1 \
--mysqld=--rpl_semi_sync_slave_enabled=1 \
--gendata=conf/replication-dml_data.zz \
--grammar=conf/replication-dml_sql.yy \
--reporter=Deadlock,Backtrace,ErrorLog \
--validator= \
--threads=1 \
--queries=100000 \
--seed=1

The result (heavy edited) on
mysql-5.1-rep+3 revno: 3124 2009-12-02
--------------------------------------
...
# 12:41:54 Test completed successfully.
# 12:41:54 gentest.pl exited with exit status 0
# 12:41:54 Waiting for slave to catch up..., file master-bin.005506, pos 107 .
# 12:41:54 Dumping server on port 12900...
# 12:42:03 Dumping server on port 12902...
# 12:42:12 Comparing SQL dumps...
--- /tmp//server_25834_0.dump ...
+++ /tmp//server_25834_1.dump ...
@@ -593,8 +593,8 @@
    The column is defined as col_mediumtext_latin1 mediumtext
-INSERT INTO `table1_innodb_int_autoinc` VALUES (....,'2009-12-04 14:41:51',....
+INSERT INTO `table1_innodb_int_autoinc` VALUES (....,'2009-12-04 14:41:52',....
-INSERT INTO `table1_innodb_int_autoinc` VALUES (....,'2009-12-04 14:41:51',....
+INSERT INTO `table1_innodb_int_autoinc` VALUES (....,'2009-12-04 14:41:52',....
...
... runall.pl will exit with exit status 1

I will try to generate a testcase for mysqltest.

How to repeat:
See above
[4 Dec 2009 12:05] Matthias Leich
Grammar for creation of objects

Attachment: replication-dml_data.zz (application/octet-stream, text), 2.27 KiB.

[4 Dec 2009 12:06] Matthias Leich
Grammar for testing

Attachment: replication-dml_sql.yy (application/octet-stream, text), 29.49 KiB.

[21 Dec 2009 18:35] Matthias Leich
It is rather likely that this bug is a duplicate of
some bugs I reported later.