Test rpl.rpl_concurrency_error is unstable
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Fix Released
|
Low
|
Laurynas Biveinis | |||
5.6 |
Fix Released
|
Low
|
Laurynas Biveinis | |||
5.7 |
Fix Released
|
Low
|
Laurynas Biveinis |
Bug Description
On 5.5:
rpl.rpl_
Test ended at 2016-07-29 03:11:32
CURRENT_TEST: rpl.rpl_
mysqltest: In included file "./include/
included from ./include/
At line 113: command "diff_files" failed with error 1. my_errno=175
The result from queries just before the failure was:
< snip >
master-bin.000001 # Query # # use `test`; UPDATE t SET f = 'gray 1' WHERE i = 3
master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Query # # BEGIN
master-bin.000001 # Query # # use `test`; UPDATE t SET f = 'dark blue 1' WHERE f = 'red'
master-bin.000001 # Query # # use `test`; INSERT INTO t VALUES (6 + (1 * 10),"brown")
master-bin.000001 # Xid # # COMMIT /* XID */
include/
include/
--- /mnt/workspace/
+++ /mnt/workspace/
@@ -2,8 +2,8 @@
2016-07-29 10:11:23 updated t: red -> magenta
2016-07-29 10:11:23 updated t: yelow -> yellow 2
2016-07-29 10:11:25 brown
-2016-07-29 10:11:25 updated t: red -> dark blu
2016-07-29 10:11:25 updated t: yellow 2 -> gray 2
+2016-07-29 10:11:26 updated t: red -> dark blu
2016-07-29 10:11:27 brown
2016-07-29 10:11:27 updated t: gray 2 -> yellow 1
2016-07-29 10:11:27 updated t: red -> magenta
More results from queries before failure can be found in /mnt/workspace/
It appears that this is caused by diffing the result of the trigger log tables, where triggers run on the master and slave independently, and so may happen to get different timestamps for the same event. The timestamps should be replaced by logical ones, i.e. autoincrement id
tags: | added: ci upstream |
https:/ /github. com/percona/ percona- server/ pull/732 /github. com/percona/ percona- server/ pull/733 /github. com/percona/ percona- server/ pull/734
https:/
https:/