Slave plugin showing difference from master in concurrent scenarios
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
High
|
David Shrewsbury | ||
7.0 |
Fix Released
|
High
|
David Shrewsbury |
Bug Description
The slave plugin is showing differences from the master in certain concurrent scenarios
As noted below, the innodb trx log *is* correct - I validated it by creating a SQL dump from the table/log, populating a validation server, and comparing master-slave dumpfiles) This issue appears to be slave-side in either reading or interpreting the log.
perl ./gentest.pl --dsn=dbi:
master:
./dbqp.py --start-and-exit --drizzled=
slave:
./dbqp.py --drizzled=
slave.cnf:
master-
master-port=9306
master-user=root
master-pass=''
max-reconnects=10
seconds-
Shows this master-slave diff:
# 2011-02-17T13:35:39 Executing diff --unified /tmp//translog_
--- /tmp//translog_
+++ /tmp//translog_
@@ -993,7 +993,7 @@
INSERT INTO `D` VALUES (6,'EYIFF'
INSERT INTO `D` VALUES (NULL,'
INSERT INTO `D` VALUES (-4177933079316
-INSERT INTO `D` VALUES (0,'MRRNJ'
+INSERT INTO `D` VALUES (-3555591905809
INSERT INTO `D` VALUES (-2716515000234
INSERT INTO `D` VALUES (-2430536423896
INSERT INTO `D` VALUES (0,'k',
@@ -1051,12 +1051,12 @@
INSERT INTO `D` VALUES (70152008445596
INSERT INTO `D` VALUES (80946573802450
INSERT INTO `D` VALUES (NULL,'
-INSERT INTO `D` VALUES (0,'BVWXT'
+INSERT INTO `D` VALUES (NULL,'
INSERT INTO `D` VALUES (NULL,'
-INSERT INTO `D` VALUES (0,'m',
+INSERT INTO `D` VALUES (-2647272155963
INSERT INTO `D` VALUES (-7318349394477
INSERT INTO `D` VALUES (0,'s',
-INSERT INTO `D` VALUES (0,'p',
+INSERT INTO `D` VALUES (1,'p',
INSERT INTO `D` VALUES (2,'OTGID'
INSERT INTO `D` VALUES (2,'GJXLN'
INSERT INTO `D` VALUES (3,'t',
Related branches
- Lee Bieber: Pending requested
-
Diff: 3028 lines (+2817/-3)27 files modifieddocs/include.am (+1/-0)
drizzled/catalog/local.h (+3/-2)
drizzled/execute.cc (+62/-0)
drizzled/execute.h (+9/-1)
drizzled/include.am (+6/-0)
drizzled/plugin/client/cached.h (+179/-0)
drizzled/sql/exception.cc (+49/-0)
drizzled/sql/exception.h (+124/-0)
drizzled/sql/result_set.cc (+174/-0)
drizzled/sql/result_set.h (+146/-0)
drizzled/sql/result_set_meta_data.h (+70/-0)
plugin/slave/docs/index.rst (+89/-0)
plugin/slave/module.cc (+73/-0)
plugin/slave/plugin.ini (+8/-0)
plugin/slave/queue_consumer.cc (+374/-0)
plugin/slave/queue_consumer.h (+130/-0)
plugin/slave/queue_producer.cc (+475/-0)
plugin/slave/queue_producer.h (+156/-0)
plugin/slave/queue_thread.cc (+67/-0)
plugin/slave/queue_thread.h (+79/-0)
plugin/slave/replication_schema.cc (+133/-0)
plugin/slave/replication_schema.h (+40/-0)
plugin/slave/replication_slave.cc (+100/-0)
plugin/slave/replication_slave.h (+90/-0)
plugin/slave/sql_executor.cc (+103/-0)
plugin/slave/sql_executor.h (+73/-0)
po/POTFILES.in (+4/-0)
Changed in drizzle: | |
milestone: | none → 2011-02-28 |
tags: | added: replication slave-plugin |
Will investigate further and report my findings.