[MDEV-26237] Actual GTID value missing with Mariabackup when "wsrep_gtid_mode=ON" Created: 2021-07-26  Updated: 2021-09-01  Resolved: 2021-08-18

Status: Closed
Project: MariaDB Server
Component/s: Galera, mariabackup
Affects Version/s: 10.5.11, 10.6.3
Fix Version/s: 10.5.13, 10.6.5

Type: Bug Priority: Major
Reporter: Pramod Mahto Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Attachments: Text File vmc11_cnf_file.txt    
Issue Links:
Relates
relates to MDEV-26223 Galera cluster node consider old serv... Closed
relates to MDEV-26250 Attached Slave to Galera cluster Node... Closed

 Description   

Taking backup of such node (Bootstrap node) : Backup log GTID value missing

[00] 2021-07-26 20:57:51 MySQL binlog position: filename 'mysql-bin.000005', position '616', GTID of the last change ''

After prepare backup : (No GTID Value)

[root@vmc11 mariabackup_slavebuild]# cat xtrabackup_binlog_info
mysql-bin.000005        616



 Comments   
Comment by Pramod Mahto [ 2021-07-26 ]

Tested with 10.3.27 and 10.4.20 Version. No such issue reported.

 
MariaDB [(none)]> select @@gtid_domain_id, @@server_id, @@wsrep_gtid_domain_id,@@wsrep_gtid_mode;
+------------------+-------------+------------------------+-------------------+
| @@gtid_domain_id | @@server_id | @@wsrep_gtid_domain_id | @@wsrep_gtid_mode |
+------------------+-------------+------------------------+-------------------+
|               11 |           1 |                      1 |                 1 |
+------------------+-------------+------------------------+-------------------+
1 row in set (0.000 sec)
 
 
MariaDB [(none)]> create database sbtest2;
Query OK, 1 row affected (0.006 sec)
 
MariaDB [(none)]> show binlog events in 'mysql-bin.000004';
+------------------+-----+-------------------+-----------+-------------+------------------------------------------------+
| Log_name         | Pos | Event_type        | Server_id | End_log_pos | Info                                           |
+------------------+-----+-------------------+-----------+-------------+------------------------------------------------+
| mysql-bin.000004 |   4 | Format_desc       |         1 |         256 | Server ver: 10.3.27-MariaDB-log, Binlog ver: 4 |
| mysql-bin.000004 | 256 | Gtid_list         |         1 |         285 | []                                             |
| mysql-bin.000004 | 285 | Binlog_checkpoint |         1 |         328 | mysql-bin.000004                               |
| mysql-bin.000004 | 328 | Gtid              |         1 |         370 | GTID 1-1-1                                     |
| mysql-bin.000004 | 370 | Query             |         1 |         468 | create database sbtest2                        |
+------------------+-----+-------------------+-----------+-------------+------------------------------------------------+
5 rows in set (0.000 sec)
 
MariaDB [(none)]> show global variables  like '%gtid%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        | 1-1-1 |
| gtid_binlog_state      | 1-1-1 |
| gtid_current_pos       | 1-1-1 |
| gtid_domain_id         | 11    |
| gtid_ignore_duplicates | OFF   |
| gtid_pos_auto_engines  |       |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
| wsrep_gtid_domain_id   | 1     |
| wsrep_gtid_mode        | ON    |
+------------------------+-------+
10 rows in set (0.001 sec)

Comment by Mario Karuza (Inactive) [ 2021-07-26 ]

Hi,

Please logs from all nodes and configuration files so i can look into it.

Generated at Thu Feb 08 09:43:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.