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
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