|
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)
|
|
Bug
Major
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)