[MDEV-26945] GTID gets out of sync between Galera cluster nodes by executing 2 transactions under the same GTID on the restarted node! Created: 2021-10-30 Updated: 2023-02-01 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Galera |
| Affects Version/s: | 10.6.4 |
| Fix Version/s: | 10.6 |
| Type: | Bug | Priority: | Major |
| Reporter: | Normunds Puzo | Assignee: | Seppo Jaakola |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | GTID, galera | ||
| Environment: |
Ubuntu 20.04 |
||
| Attachments: |
|
| Description |
|
I have 3 galera cluster nodes setup configured as required: https://mariadb.com/kb/en/using-mariadb-gtids-with-mariadb-galera-cluster/ I am also attaching the config file and the error log files from node1 and node2. Hope this helps to find out the cause. This situation leads also to the problem of replica server. My replica server (slave) now is attached to node2. All the nodes - node1, node2 and node3 have enabled binary logs. Before problem with GTID arrived I was able to switch the replica server to any cluster node and it was syncing fine. Now as GTIDs differs - this is not possible. No data loss is detected as it is just mess up with GTID numbers which causes also problem with replica server - no option to attach it to other cluster node except the node2 right now. |
| Comments |
| Comment by Mario Karuza (Inactive) [ 2021-11-02 ] |
|
Hi, What is your `gtid_domain_id` on servers ? Are all tables use InnoDB SE ? |
| Comment by Normunds Puzo [ 2021-11-02 ] |
|
gtid_domain_id on each server is different 1 on node1, 2 on node2 and 3 on node 3. |
| Comment by Normunds Puzo [ 2021-11-06 ] |
|
Is there a way to update GTID on node manually so it matches the other nodes GTID? |
| Comment by Normunds Puzo [ 2021-11-09 ] |
|
Additional info: Mariadb on node2 was self restarted, because the node run out of RAM for short period of time. No swap was enabled on the server. Total 8GB of RAM. |
| Comment by Normunds Puzo [ 2021-11-11 ] |
|
|