[MDEV-32072] Instances in Galera Cluster did not have the same GTID even if wsrep_gtid_mode = ON Created: 2023-09-01 Updated: 2023-09-29 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Galera |
| Affects Version/s: | 10.5.19, 10.6.12, 10.6.13, 10.6.14, 10.6.15 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Critical |
| Reporter: | Min-Jen Chang | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Hi, Recently, I tried to migrate and upgrade MariaDB in Galera Cluster.
Firstlly, I initialized datadir on Node1, and startup with --wsrep-new-cluster to start database with new Galera Cluster, Then I startup Node2 and Node3, both of them join cluster by SST method, From here, GTID were different between each nodes. Then I committed another transaction on Node2, each nodes' gtid_binlog_pos and gtid_current_pos were: Finally, I committed a transaction on Node3, each nodes' gtid_binlog_pos and gtid_current_pos were: Obviously, only Node1 use wsrep_gtid_domain_id as DOMAIN ID in GTID, other nodes did not use wsrep_gtid_domain_id I set, they used default value of wsrep_gtid_domain_id (0). If GTID were different between instance, I think this cause GTID useless, it was not "GLOBAL". For another checking, I shutdown Node1, then startup Node1 to join cluster, Yap, Node1 did not use wsrep_gtid_domain_id I set, too, and this time, I used SHOW GLOVAL VARIABLES LIKE '%GTID%';, I tried other version: 10.6.13、10.6.14、10.6.15, all of them had the same issue, I thought it was plug-in's issue, so I replaced Galera Cluster's library files in MariaDB 10.6.12 (MariaDB 10.6.12 + Galera 4 26.4.13), Based on testing descirbe above, I think it was MariaDB's bug. Please help to confirm, thank you. |
| Comments |
| Comment by s [ 2023-09-14 ] |
|
same question. I'm confused |
| Comment by Jukka Pihl [ 2023-09-29 ] |
|
https://jira.mariadb.org/browse/MDEV-31905 Same/related problem ? |