[MDEV-10810] GTID out-of-order on ¿concurrent? duplicate transactions Created: 2016-09-14 Updated: 2022-11-10 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Affects Version/s: | 10.0.25, 10.0.27 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Minor |
| Reporter: | Pablo Guzman | Assignee: | Angelique Sklavounos (Inactive) |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Ubuntu 14.04.4 LTS (GNU/Linux 3.13.0-86-generic x86_64) |
||
| Attachments: |
|
| Description |
|
Setup: Issue: So on this setup B handles transactions, replicates them to A and C, which them replicate it to the other server again. (A to C and C to A). Sometimes both get locked in the same GTID, sometimes different GTIDs. (This happens to the replication between A and C, the replication with and from B always works fine and never gets interrupted) In every case the GTID says it's trying to binlog the same GTID that already has in the binlog. We aren't sure what's going on but my gut tells me this seems to be some kind of race condition when the same transaction arrives from both servers at roughly the same time and the option gtid_ignore_duplicates seems to be unable to stop this from happening. The latency between the servers are |
| Comments |
| Comment by Pablo Guzman [ 2016-09-16 ] |
|
We have now eliminated one of the links to test it out (C no longer replicates from A) and the issue doesn't happen in C anymore. However A (which replicates from B and C) still has this issue randomly and often. All the slaves are set to master_gtid_pos=current_pos |