[MDEV-28609] refine gtid-strict-mode to ignore same server-id gtid from the past on semisync slave Created: 2022-05-18 Updated: 2023-11-27 Resolved: 2022-07-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Affects Version/s: | None |
| Fix Version/s: | 10.6.9, 10.7.5, 10.8.4, 10.9.2 |
| Type: | Bug | Priority: | Blocker |
| Reporter: | Andrei Elkin | Assignee: | Andrei Elkin |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | gtid-strict-mode, semisync | ||
| Issue Links: |
|
||||||||||||
| Description |
|
To provide semisync master crash-recovery ( This gets fixed to ignore on the gtid strict mode semisync |
| Comments |
| Comment by Faisal Saeed (Inactive) [ 2022-05-20 ] | ||||||
|
Elkin i have updated this with the respective CS number. | ||||||
| Comment by Andrei Elkin [ 2022-06-30 ] | ||||||
|
Howdy, Brandon! Could you please assess a solution you can find in bb-10.6-andrei. Cheers, Andrei | ||||||
| Comment by Brandon Nesterenko [ 2022-06-30 ] | ||||||
|
Hi Andrei! The patch looks good, and I agree that extending the strict_mode | ||||||
| Comment by Andrei Elkin [ 2022-07-05 ] | ||||||
| Comment by Andrei Elkin [ 2022-07-06 ] | ||||||
|
The test plan for PREAMBLE
The SUGGESTED TESTING takes rpl.rpl_circular_semi_sync as a template. L1. /* practical */ each server originates gtid with its own There must be no clashes between different domain-id transactions L2. /* lesser practical */ fake server_id as the template does in the L3. /* "not so practical" */ one common domain and server generates
Having the servers under load perform PERTURBATIONs P1. randomly stop and restart in a random time interval the slave services while keeping up to observe eventual consistent server states (gtid slave, binlog and the data). | ||||||
| Comment by Andrei Elkin [ 2022-07-18 ] | ||||||
|
Faisal,
Informally, the user only needs `gtid_strict_mode = ON` at least on slave and the semisync slave knows now what its server-id transaction it needs to ignore and what to accept (that's to the | ||||||
| Comment by Angelique Sklavounos (Inactive) [ 2022-07-22 ] | ||||||
|
Testing of L1, L2, L3 with P1, P2 looked good. Okay to push. |