wsrep_gtid not reflect correctly

22 views
Skip to first unread message

Yoong Kin Meng

unread,
Jan 11, 2022, 5:03:47 AM1/11/22
to codership
Hi All,
Need your help in below.

refer to below, my server_id=30

so my GTID = gtid_domain_id + server_id + seqno
                      = 33-30-1 (which reflect correct)

however my WSREP GTID= wsrep_gtid_domain_id + server_id + wsrep_seqno
                                              = 66-5-1

wsrep gtid suppose is 66-30-1, why it become 66-5-1 ?

MariaDB [km]> show global variables like '%gtid%';
+-------------------------+----------------+
| Variable_name           | Value          |
+-------------------------+----------------+
| gtid_binlog_pos         | 33-30-1,66-5-1 |
| gtid_binlog_state       | 33-30-1,66-5-1 |
| gtid_cleanup_batch_size | 64             |
| gtid_current_pos        | 33-30-1        |
| gtid_domain_id          | 33             |
| gtid_ignore_duplicates  | OFF            |
| gtid_pos_auto_engines   |                |
| gtid_slave_pos          |                |
| gtid_strict_mode        | OFF            |
| wsrep_gtid_domain_id    | 66             |
| wsrep_gtid_mode         | ON             |
+-------------------------+----------------+
11 rows in set (0.002 sec)

MariaDB [km]>
MariaDB [km]>
MariaDB [km]> show global variables like '%server_id%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 30    |
+---------------+-------+
1 row in set (0.002 sec)

MariaDB [km]>
Reply all
Reply to author
Forward
0 new messages