root@neodymium:~# for i in  db2010 db2012 db2030; do echo $i; mysql -h$i.codfw.wmnet -e "show global variables like 'gtid_domain_id'"; done
db2010
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180355085 |
+----------------+-----------+
db2012
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180355087 |
+----------------+-----------+
db2030
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180359186 |
+----------------+-----------+

root@neodymium:/home/marostegui/git/software/dbtools# for i in db1009 db1046 db1016 db1001; do echo $i; mysql -h$i -e "select @@gtid_domain_id;";done
db1009
+------------------+
| @@gtid_domain_id |
+------------------+
|        171966477 |
+------------------+
db1046
+------------------+
| @@gtid_domain_id |
+------------------+
|        171970595 |
+------------------+
db1016
+------------------+
| @@gtid_domain_id |
+------------------+
|        171966484 |
+------------------+
db1001
+------------------+
| @@gtid_domain_id |
+------------------+
|        171966469 |
+------------------+

root@neodymium:/home/marostegui/git/software/dbtools# for i in db1043 db1048 dbstore1001 db2012.codfw.wmnet dbstore1002; do echo $i; mysql -h$i -e "select @@gtid_domain_id;";done
db1043
+------------------+
| @@gtid_domain_id |
+------------------+
|                0 |
+------------------+
db1048
+------------------+
| @@gtid_domain_id |
+------------------+
|                0 |
+------------------+
dbstore1001
+------------------+
| @@gtid_domain_id |
+------------------+
|                0 |
+------------------+
db2012.codfw.wmnet
+------------------+
| @@gtid_domain_id |
+------------------+
|        180355087 |
+------------------+
dbstore1002
+------------------+
| @@gtid_domain_id |
+------------------+
|                0 |
+------------------+

root@neodymium:~# for i in db1095 labsdb1009 labsdb1010 labsdb1011; do echo $i; mysql -h$i -e "select @@gtid_domain_id;";done
db1095
+------------------+
| @@gtid_domain_id |
+------------------+
|        171974784 |
+------------------+
labsdb1009
+------------------+
| @@gtid_domain_id |
+------------------+
|        171967502 |
+------------------+
labsdb1010
+------------------+
| @@gtid_domain_id |
+------------------+
|        171975959 |
+------------------+
labsdb1011
+------------------+
| @@gtid_domain_id |
+------------------+
|        171975960 |
+------------------+

root@db2030:~# cat /etc/my.cnf | grep "^gtid"
gtid_domain_id  = 180359186

root@db2030:~# sudo puppet agent -t
Info: Retrieving pluginfacts
<snip>
Info: Applying configuration version '1481556364'
Notice: Finished catalog run in 16.33 seconds

root@db2030:~# cat /etc/my.cnf | grep "^gtid"
gtid_domain_id  = 180359186

At the beginning, since both masters are running with domain_id 0, the slave considers it a single replication stream. 
We can see how the slave only has 0-2-x, although master1 has 0-1-x and master2 has 0-2-x.
When the slave is switched to using GTID replication, it sends the position to each master. Although domain IDs on masters are now set to unique values, they of course stay aware of the old 0 domain they used to use, so they are trying to find the position 0-2-x which corresponds to this domain. But only one of the servers has it, the other one returns an error.
I think one way to overcome the problem is to adjust the slave position manually before switching to using GTID-based replication.
That is, assuming that you've ensured that all old-zero-domain events from both servers have been replicated by this time, after you stopped slaves and before you changed them to using GTID, you delete zero domain from mysql.gtid_slave_pos and from @@global.gtid_slave_pos:
stop all slaves;
 
delete from mysql.gtid_slave_pos where domain_id=0;
 
select @@global.gtid_slave_pos;
# Let's say it's 0-2-10,1-1-4,2-2-1 as in the data above
set global gtid_slave_pos= '1-1-4,2-2-1';
 
change master '1' to master_use_gtid=slave_pos;
change master '2' to master_use_gtid=slave_pos;
start all slaves;
It might produce a warning about missing domain "3", but it will be adjusted automatically.
I think it should help to get it up and running, although it's a bit cumbersome.
I'm not sure whether it's a bug. 
Kristian Nielsen, what do you think?
Also, maybe you can suggest a more elegant way to perform this transition?

I agree with Elena. When replicating with GTID, the master must have either all of the domain in the binlog, or none of the domain. Changing gtid_domain_id on a master at some point does not change the binlog of the past.
RESET MASTER on the masters will remove the old events with wrong domain id, though that may be inconvenient to do on a production setup as it loses all binlogs on the masters.

To be honest, I do consider this a bug, or at least a serious limitation as it doesn't work as expected (specially keeping in mind that the documentation doesn't talk about existing multisource slaves breaking when trying to set up gtid_domain_id+GTID). If this is the expected behaviour it should be stated there as a big warning:
I consider this (if it is the expected behaviour) a serious limitation because it forces you to either:
* not use GTID with multisource slaves
or
* Making sure that you set up all the stuff from the start (gtid_domain_id) before setting up any sort of multisource replication, otherwise it will break. Which again, is a massive stop for existing environments where you'd like to take advantage of multisource (ie: reduce hardware) and then the safety of GTID on top of it.

Even if the suggested workaround would work (maybe we are doing something wrong and it really works?) it requires to stop the slave, which might be a no-go for some production environments. And it should be specified on the documentation.
But doing a RESET MASTER is probably a no-go for the 95% of the production environments I would say.
Whatever the fix is, if it cannot be done live (the documentation suggests that gtid_domain_id can be changed on the fly, which is true, but swiching to GTID will break anyways so the whole point of gtid_domain_id is gone), it needs to be specified on the documentation.
I am happy to keep debugging this issue to see if we can reach a workaround can work 
Thanks again!
Manuel.

root@MISC m3[(none)]> select * from mysql.gtid_slave_pos;
+-----------+----------+-----------+-----------+
| domain_id | sub_id   | server_id | seq_no    |
+-----------+----------+-----------+-----------+
|         0 | 35332094 | 171970592 | 200818911 |
|         0 | 35332179 | 171970592 | 200818911 |
| 171970592 | 49703957 | 171970592 |  56150120 |
| 171970592 | 49703958 | 171970592 |  56150121 |
+-----------+----------+-----------+-----------+
4 rows in set (0.00 sec)

master1----
|         |
master2  slave1

master2-----
|          |
master1  slave1

Gtid_IO_Pos: 0-2-29

Gtid_IO_Pos: 0-2-29,2-2-3

stop slave; change master to master_host='192.168.56.21'; start slave;

master1----
|         |
master2  slave1

Gtid_IO_Pos: 1-1-1,2-2-4,0-2-29

slave1
|          
master2
|
master1

master1----
|         |
master2  slave1

Gtid_IO_Pos: 1-1-7,0-2-29,3-3-1,2-2-5

root@neodymium:/home/marostegui/git/software/dbtools# for i in `cat s6.hosts | cut -f1 -d " " | egrep -v "dbstore*|labs*|db1069|db1095" `;do echo $i; mysql -h$i -e "show global variables like 'gtid_domain_id'; show global variables like 'server_id';";done
db2039.codfw.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180363274 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 180363274 |
+---------------+-----------+
db2046.codfw.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180363370 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 180363370 |
+---------------+-----------+
db2053.codfw.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180367365 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 180367365 |
+---------------+-----------+
db2060.codfw.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180367372 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 180367372 |
+---------------+-----------+
db2067.codfw.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180367379 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 180367379 |
+---------------+-----------+
db2028.codfw.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 180359184 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 180359184 |
+---------------+-----------+
db1022.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171970571 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171970571 |
+---------------+-----------+
db1023.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171970572 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171970572 |
+---------------+-----------+
db1030.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171970579 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171970579 |
+---------------+-----------+
db1037.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171970586 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171970586 |
+---------------+-----------+
db1061.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171978766 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171978766 |
+---------------+-----------+
db1085.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171970663 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171970663 |
+---------------+-----------+
db1088.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171974770 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171974770 |
+---------------+-----------+
db1093.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171978904 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171978904 |
+---------------+-----------+
db1050.eqiad.wmnet
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| gtid_domain_id | 171970705 |
+----------------+-----------+
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| server_id     | 171970705 |
+---------------+-----------+

root@neodymium:/home/marostegui/git/software/dbtools# for i in `cat s6.hosts | cut -f1 -d " " | egrep -v "dbstore*|labs*|db1069|db1095" `;do echo $i; mysql -h$i -e "show slave status\G" | grep Gtid_IO_Pos;done
db2039.codfw.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55119,0-171970705-3042619293
db2046.codfw.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55130,0-171970705-3042619293
db2053.codfw.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55134,0-171970705-3042619293
db2060.codfw.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55138,0-171970705-3042619294
db2067.codfw.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55145,0-171970705-3042619294
db2028.codfw.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55154,0-180359184-3042619294
db1022.eqiad.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55154,0-180359184-3042619295
db1023.eqiad.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55158,0-180359184-3042619295
db1030.eqiad.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55161,0-180359184-3042619295
db1037.eqiad.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55162,0-180359184-3042619295
db1061.eqiad.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55163,0-180359184-3042619295
db1085.eqiad.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55164,0-180359184-3042619295
db1088.eqiad.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55168,0-180359184-3042619295
db1093.eqiad.wmnet
                  Gtid_IO_Pos: 171970705-171970705-55172,0-180359184-3042619295
db1050.eqiad.wmnet
                  Gtid_IO_Pos:

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show slave status\G
+------------+
| @@hostname |
+------------+
| master1    |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        |       |
| gtid_binlog_state      |       |
| gtid_current_pos       |       |
| gtid_domain_id         | 0     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
+------------------------+-------+
7 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)




MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show slave status\G
+------------+
| @@hostname |
+------------+
| master2    |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        |       |
| gtid_binlog_state      |       |
| gtid_current_pos       |       |
| gtid_domain_id         | 0     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
+------------------------+-------+
7 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)



MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show slave status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        |       |
| gtid_binlog_state      |       |
| gtid_current_pos       |       |
| gtid_domain_id         | 0     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
| wsrep_gtid_domain_id   | 0     |
| wsrep_gtid_mode        | OFF   |
+------------------------+-------+
9 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)

MariaDB [(none)]> change master '1' to master_host='192.168.56.21', master_user='replication', master_password='password', master_log_pos=314, master_log_file='mariadb-bin.000001';
Query OK, 0 rows affected (0.03 sec)

MariaDB [(none)]> change master '2' to master_host='192.168.56.22', master_user='replication', master_password='password', master_log_pos=314, master_log_file='mariadb-bin.000001';
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> start all slaves;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

MariaDB [(none)]> show warnings;
+-------+------+-------------------+
| Level | Code | Message           |
+-------+------+-------------------+
| Note  | 1937 | SLAVE '1' started |
| Note  | 1937 | SLAVE '2' started |
+-------+------+-------------------+
2 rows in set (0.00 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000001
          Read_Master_Log_Pos: 314
               Relay_Log_File: mysqld-relay-bin-1.000002
                Relay_Log_Pos: 538
        Relay_Master_Log_File: mariadb-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 314
              Relay_Log_Space: 839
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 5
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos:
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000001
          Read_Master_Log_Pos: 314
               Relay_Log_File: mysqld-relay-bin-2.000002
                Relay_Log_Pos: 538
        Relay_Master_Log_File: mariadb-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 314
              Relay_Log_Space: 839
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 5
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos:
2 rows in set (0.00 sec)

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| gtid_binlog_pos        |        |
| gtid_binlog_state      |        |
| gtid_current_pos       | 0-2-35 |
| gtid_domain_id         | 0      |
| gtid_ignore_duplicates | OFF    |
| gtid_slave_pos         | 0-2-35 |
| gtid_strict_mode       | OFF    |
| wsrep_gtid_domain_id   | 0      |
| wsrep_gtid_mode        | OFF    |
+------------------------+--------+
9 rows in set (0.00 sec)

+-----------+--------+-----------+--------+
| domain_id | sub_id | server_id | seq_no |
+-----------+--------+-----------+--------+
|         0 |     63 |         2 |     34 |
|         0 |     64 |         2 |     35 |
+-----------+--------+-----------+--------+
2 rows in set (0.00 sec)

*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000003
          Read_Master_Log_Pos: 3649
               Relay_Log_File: mysqld-relay-bin-1.000006
                Relay_Log_Pos: 3939
        Relay_Master_Log_File: mariadb-bin.000003
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 3649
              Relay_Log_Space: 5111
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 83
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-35
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000006
          Read_Master_Log_Pos: 3310
               Relay_Log_File: mysqld-relay-bin-2.000012
                Relay_Log_Pos: 3600
        Relay_Master_Log_File: mariadb-bin.000006
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 3310
              Relay_Log_Space: 5238
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 125
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-35
2 rows in set (0.00 sec)

MariaDB [(none)]> select @@hostname;  show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show slave status\G
+------------+
| @@hostname |
+------------+
| master1    |
+------------+
1 row in set (0.00 sec)

+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| gtid_binlog_pos        | 0-1-29 |
| gtid_binlog_state      | 0-1-29 |
| gtid_current_pos       | 0-1-29 |
| gtid_domain_id         | 0      |
| gtid_ignore_duplicates | OFF    |
| gtid_slave_pos         |        |
| gtid_strict_mode       | OFF    |
+------------------------+--------+
7 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)



MariaDB [(none)]> select @@hostname;  show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show slave status\G
+------------+
| @@hostname |
+------------+
| master2    |
+------------+
1 row in set (0.00 sec)

+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| gtid_binlog_pos        | 0-2-35 |
| gtid_binlog_state      | 0-2-35 |
| gtid_current_pos       | 0-2-35 |
| gtid_domain_id         | 0      |
| gtid_ignore_duplicates | OFF    |
| gtid_slave_pos         |        |
| gtid_strict_mode       | OFF    |
+------------------------+--------+
7 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)

MariaDB [(none)]> select @@hostname;
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

MariaDB [(none)]> show global variables like 'server_id';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 3     |
+---------------+-------+
1 row in set (0.00 sec)

MariaDB [(none)]> set global gtid_domain_id=3;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show global variables like 'gtid_domain_id';
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| gtid_domain_id | 3     |
+----------------+-------+
1 row in set (0.00 sec)


MariaDB [(none)]>  select @@hostname;
+------------+
| @@hostname |
+------------+
| master1    |
+------------+
1 row in set (0.00 sec)

MariaDB [(none)]> show global variables like 'server_id';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 1     |
+---------------+-------+
1 row in set (0.00 sec)

MariaDB [(none)]> set global gtid_domain_id=1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show global variables like 'gtid_domain_id';
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| gtid_domain_id | 1     |
+----------------+-------+
1 row in set (0.00 sec)



MariaDB [(none)]>  select @@hostname;
+------------+
| @@hostname |
+------------+
| master2    |
+------------+
1 row in set (0.00 sec)

MariaDB [(none)]> show global variables like 'server_id';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 2     |
+---------------+-------+
1 row in set (0.00 sec)

MariaDB [(none)]> set global gtid_domain_id=2;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show global variables like 'gtid_domain_id';
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| gtid_domain_id | 2     |
+----------------+-------+
1 row in set (0.00 sec)
`

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+----------------------+
| Variable_name          | Value                |
+------------------------+----------------------+
| gtid_binlog_pos        |                      |
| gtid_binlog_state      |                      |
| gtid_current_pos       | 0-2-20,1-1-18,2-2-16 |
| gtid_domain_id         | 3                    |
| gtid_ignore_duplicates | OFF                  |
| gtid_slave_pos         | 0-2-20,1-1-18,2-2-16 |
| gtid_strict_mode       | OFF                  |
| wsrep_gtid_domain_id   | 0                    |
| wsrep_gtid_mode        | OFF                  |
+------------------------+----------------------+
9 rows in set (0.00 sec)

+-----------+--------+-----------+--------+
| domain_id | sub_id | server_id | seq_no |
+-----------+--------+-----------+--------+
|         0 |     43 |         2 |     19 |
|         0 |     44 |         2 |     20 |
|         1 |     77 |         1 |     17 |
|         1 |     78 |         1 |     18 |
|         2 |     71 |         2 |     15 |
|         2 |     72 |         2 |     16 |
+-----------+--------+-----------+--------+
6 rows in set (0.00 sec)

*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000019
          Read_Master_Log_Pos: 887
               Relay_Log_File: mysqld-relay-bin-1.000038
                Relay_Log_Pos: 1177
        Relay_Master_Log_File: mariadb-bin.000019
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 887
              Relay_Log_Space: 2375
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 337
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-20,1-1-18,2-2-16
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000012
          Read_Master_Log_Pos: 1014
               Relay_Log_File: mysqld-relay-bin-2.000024
                Relay_Log_Pos: 1304
        Relay_Master_Log_File: mariadb-bin.000012
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1014
              Relay_Log_Space: 2502
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 231
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-20,1-1-18,2-2-16
2 rows in set (0.00 sec)

MariaDB [(none)]> stop all slaves;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

MariaDB [(none)]> change master '1' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> change master '2' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> start all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State:
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000019
          Read_Master_Log_Pos: 887
               Relay_Log_File: mysqld-relay-bin-1.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mariadb-bin.000019
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 887
              Relay_Log_Space: 249
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 1236
                Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 0-2-20, which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged due to executing extra erroneous transactions'
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-18,0-2-20,2-2-16
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 338
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-20,1-1-18,2-2-16
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000012
          Read_Master_Log_Pos: 1014
               Relay_Log_File: mysqld-relay-bin-2.000002
                Relay_Log_Pos: 714
        Relay_Master_Log_File: mariadb-bin.000012
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1014
              Relay_Log_Space: 1015
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-18,0-2-20,2-2-16
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 240
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-20,1-1-18,2-2-16

Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 0-2-20, which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged due to executing extra erroneous transactions'

+-----------+--------+-----------+--------+
| domain_id | sub_id | server_id | seq_no |
+-----------+--------+-----------+--------+
|         0 |     43 |         2 |     19 |
|         0 |     44 |         2 |     20 |
|         1 |     77 |         1 |     17 |
|         1 |     78 |         1 |     18 |
|         2 |     71 |         2 |     15 |
|         2 |     72 |         2 |     16 |
+-----------+--------+-----------+--------+

MariaDB [mysql]> reset master;
Query OK, 0 rows affected (0.01 sec)

MariaDB [mysql]> show master status\G
*************************** 1. row ***************************
            File: mariadb-bin.000001
        Position: 314
    Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)

MariaDB [mysql]> show global variables like '%gtid%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        |       |
| gtid_binlog_state      |       |
| gtid_current_pos       |       |
| gtid_domain_id         | 1     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
+------------------------+-------+
7 rows in set (0.00 sec)


MariaDB [(none)]>  reset master;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show global variables like '%gtid%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        |       |
| gtid_binlog_state      |       |
| gtid_current_pos       |       |
| gtid_domain_id         | 2     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
+------------------------+-------+
7 rows in set (0.00 sec)

`
MariaDB [(none)]> reset slave '1' all;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> reset slave '2' all;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show all slaves status\G
Empty set (0.00 sec)

MariaDB [(none)]> delete from mysql.gtid_slave_pos;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> select * from mysql.gtid_slave_pos;
Empty set (0.00 sec)

MariaDB [(none)]> change master '2' to master_host='192.168.56.22', master_user='replication', master_password='password', master_log_pos=314, master_log_file='mariadb-bin.000001';
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> change master '1' to master_host='192.168.56.21', master_user='replication', master_password='password', master_log_pos=314, master_log_file='mariadb-bin.000001';
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> change master '2' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> change master '1' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> start all slaves;
Query OK, 0 rows affected, 2 warnings (0.02 sec)

MariaDB [(none)]> select * from mysql.gtid_slave_pos;
Empty set (0.00 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000001
          Read_Master_Log_Pos: 314
               Relay_Log_File: mysqld-relay-bin-1.000002
                Relay_Log_Pos: 604
        Relay_Master_Log_File: mariadb-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 314
              Relay_Log_Space: 905
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-18,0-2-20,2-2-16
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 7
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-20,1-1-18,2-2-16,3-3-2
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000001
          Read_Master_Log_Pos: 314
               Relay_Log_File: mysqld-relay-bin-2.000002
                Relay_Log_Pos: 604
        Relay_Master_Log_File: mariadb-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 314
              Relay_Log_Space: 905
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-18,0-2-20,2-2-16
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 7
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-20,1-1-18,2-2-16,3-3-2
2 rows in set (0.00 sec)

MariaDB [mysql]> 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         | 1     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
+------------------------+-------+
7 rows in set (0.00 sec)




MariaDB [(none)]> show global variables like '%gtid%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        | 2-2-1 |
| gtid_binlog_state      | 2-2-1 |
| gtid_current_pos       | 2-2-1 |
| gtid_domain_id         | 2     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
+------------------------+-------+
7 rows in set (0.00 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State:
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000001
          Read_Master_Log_Pos: 314
               Relay_Log_File: mysqld-relay-bin-1.000002
                Relay_Log_Pos: 604
        Relay_Master_Log_File: mariadb-bin.000001
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 314
              Relay_Log_Space: 905
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 1236
                Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 1-1-18, which is not in the master's binlog'
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-18,0-2-20,2-2-16
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 7
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-20,1-1-18,2-2-16,3-3-2
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State:
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000001
          Read_Master_Log_Pos: 314
               Relay_Log_File: mysqld-relay-bin-2.000002
                Relay_Log_Pos: 604
        Relay_Master_Log_File: mariadb-bin.000001
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 314
              Relay_Log_Space: 905
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 1236
                Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 2-2-16, which is not in the master's binlog'
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-18,0-2-20,2-2-16
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 7
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-2-20,1-1-18,2-2-16,3-3-2

root@slave1:/var/log/mysql# /etc/init.d/mysql  stop
[ ok ] Stopping mysql (via systemctl): mysql.service.
root@slave1:/var/log/mysql# ls
mariadb-bin.000001  mariadb-bin.000002	mariadb-bin.index  mariadb-bin.state
root@slave1:/var/log/mysql# rm mariadb-bin.00000* mariadb-bin.index
root@slave1:/var/log/mysql# /etc/init.d/mysql  start
[ ok ] Starting mysql (via systemctl): mysql.service.
root@slave1:/var/log/mysql# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.21-MariaDB-1~jessie mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        | 3-3-1 |
| gtid_binlog_state      | 3-3-1 |
| gtid_current_pos       | 3-3-1 |
| gtid_domain_id         | 3     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
| wsrep_gtid_domain_id   | 0     |
| wsrep_gtid_mode        | OFF   |
+------------------------+-------+
9 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)

MariaDB [(none)]> Ctrl-C -- exit!
Aborted
root@slave1:/var/log/mysql# mysql
MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        | 3-3-1 |
| gtid_binlog_state      | 3-3-1 |
| gtid_current_pos       | 3-3-1 |
| gtid_domain_id         | 3     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
| wsrep_gtid_domain_id   | 0     |
| wsrep_gtid_mode        | OFF   |
+------------------------+-------+

root@slave1:/var/log/mysql# /etc/init.d/mysql  stop
[ ok ] Stopping mysql (via systemctl): mysql.service.
root@slave1:/var/log/mysql# ls
mariadb-bin.000001  mariadb-bin.index  mariadb-bin.state
root@slave1:/var/log/mysql# rm mariadb-bin.state
root@slave1:/var/log/mysql# /etc/init.d/mysql  start
[ ok ] Starting mysql (via systemctl): mysql.service.
root@slave1:/var/log/mysql# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.21-MariaDB-1~jessie mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        | 3-3-1 |
| gtid_binlog_state      | 3-3-1 |
| gtid_current_pos       | 3-3-1 |
| gtid_domain_id         | 3     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
| wsrep_gtid_domain_id   | 0     |
| wsrep_gtid_mode        | OFF   |
+------------------------+-------+

MariaDB [(none)]> stop all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)


MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State:
               Slave_IO_State:
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000014
          Read_Master_Log_Pos: 4639
               Relay_Log_File: mysqld-relay-bin-1.000028
                Relay_Log_Pos: 4929
        Relay_Master_Log_File: mariadb-bin.000014
             Slave_IO_Running: No
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4639
              Relay_Log_Space: 6002
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 335
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-1-9,1-1-42,2-2-66
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State:
               Slave_IO_State:
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000006
          Read_Master_Log_Pos: 4887
               Relay_Log_File: mysqld-relay-bin-2.000012
                Relay_Log_Pos: 5177
        Relay_Master_Log_File: mariadb-bin.000006
             Slave_IO_Running: No
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4887
              Relay_Log_Space: 10752
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 339
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-1-9,1-1-42,2-2-66
2 rows in set (0.00 sec)

MariaDB [(none)]> reset slave '1' all;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> reset slave '2' all;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> show all slaves status\G
Empty set (0.00 sec)

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+---------------------+
| Variable_name          | Value               |
+------------------------+---------------------+
| gtid_binlog_pos        |                     |
| gtid_binlog_state      |                     |
| gtid_current_pos       | 0-1-9,1-1-42,2-2-66 |
| gtid_domain_id         | 3                   |
| gtid_ignore_duplicates | OFF                 |
| gtid_slave_pos         | 0-1-9,1-1-42,2-2-66 |
| gtid_strict_mode       | OFF                 |
| wsrep_gtid_domain_id   | 0                   |
| wsrep_gtid_mode        | OFF                 |
+------------------------+---------------------+
9 rows in set (0.00 sec)

+-----------+--------+-----------+--------+
| domain_id | sub_id | server_id | seq_no |
+-----------+--------+-----------+--------+
|         0 |     14 |         1 |      8 |
|         0 |     15 |         1 |      9 |
|         1 |    122 |         1 |     41 |
|         1 |    123 |         1 |     42 |
|         2 |    101 |         2 |     65 |
|         2 |    102 |         2 |     66 |
+-----------+--------+-----------+--------+
6 rows in set (0.00 sec)

Empty set (0.00 sec)

MariaDB [(none)]> delete from mysql.gtid_slave_pos;
Query OK, 6 rows affected (0.00 sec)

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+---------------------------+
| Variable_name          | Value                     |
+------------------------+---------------------------+
| gtid_binlog_pos        | 3-3-1                     |
| gtid_binlog_state      | 3-3-1                     |
| gtid_current_pos       | 0-1-9,1-1-42,2-2-66,3-3-1 |
| gtid_domain_id         | 3                         |
| gtid_ignore_duplicates | OFF                       |
| gtid_slave_pos         | 0-1-9,1-1-42,2-2-66       |
| gtid_strict_mode       | OFF                       |
| wsrep_gtid_domain_id   | 0                         |
| wsrep_gtid_mode        | OFF                       |
+------------------------+---------------------------+
9 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)

MariaDB [(none)]> Ctrl-C -- exit!
Aborted

root@slave1:/var/lib/mysql# /etc/init.d/mysql  stop
[ ok ] Stopping mysql (via systemctl): mysql.service.
root@slave1:/var/lib/mysql# rm multi-master.info
root@slave1:/var/lib/mysql# cd /var/log/mysql/
root@slave1:/var/log/mysql# ls
mariadb-bin.000001  mariadb-bin.index  mariadb-bin.state
root@slave1:/var/log/mysql# rm -fr *
root@slave1:/var/log/mysql# /etc/init.d/mysql  restart
[ ok ] Restarting mysql (via systemctl): mysql.service.
root@slave1:/var/log/mysql# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.21-MariaDB-1~jessie mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        |       |
| gtid_binlog_state      |       |
| gtid_current_pos       |       |
| gtid_domain_id         | 3     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
| wsrep_gtid_domain_id   | 0     |
| wsrep_gtid_mode        | OFF   |
+------------------------+-------+
9 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)

MariaDB [(none)]> change master '1' to master_host='192.168.56.21', master_user='replication', master_password='password', master_log_pos=4639, master_log_file='mariadb-bin.000014';
Query OK, 0 rows affected (0.02 sec)

MariaDB [(none)]> change master '2' to master_host='192.168.56.22', master_user='replication', master_password='password', master_log_pos=4887, master_log_file='mariadb-bin.000006';
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> change master '1' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> change master '2' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State:
               Slave_IO_State:
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000014
          Read_Master_Log_Pos: 4639
               Relay_Log_File: mysqld-relay-bin-1.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mariadb-bin.000014
             Slave_IO_Running: No
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4639
              Relay_Log_Space: 249
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 0
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 0
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos:
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State:
               Slave_IO_State:
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000006
          Read_Master_Log_Pos: 4887
               Relay_Log_File: mysqld-relay-bin-2.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mariadb-bin.000006
             Slave_IO_Running: No
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4887
              Relay_Log_Space: 249
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 0
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 0
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos:
2 rows in set (0.00 sec)

MariaDB [(none)]> start all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000014
          Read_Master_Log_Pos: 8893
               Relay_Log_File: mysqld-relay-bin-1.000020
                Relay_Log_Pos: 9183
        Relay_Master_Log_File: mariadb-bin.000014
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 8893
              Relay_Log_Space: 10256
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-63,0-1-9
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 382
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-1-9,1-1-63,2-2-88
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000006
          Read_Master_Log_Pos: 9389
               Relay_Log_File: mysqld-relay-bin-2.000012
                Relay_Log_Pos: 9679
        Relay_Master_Log_File: mariadb-bin.000006
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 9389
              Relay_Log_Space: 15254
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 0-2-6,2-2-88
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 429
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-1-9,1-1-63,2-2-88
2 rows in set (0.00 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000014
          Read_Master_Log_Pos: 13147
               Relay_Log_File: mysqld-relay-bin-1.000020
                Relay_Log_Pos: 13437
        Relay_Master_Log_File: mariadb-bin.000014
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 13147
              Relay_Log_Space: 14510
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-84,0-1-9
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 466
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-1-9,1-1-84,2-2-110
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000006
          Read_Master_Log_Pos: 13891
               Relay_Log_File: mysqld-relay-bin-2.000012
                Relay_Log_Pos: 14181
        Relay_Master_Log_File: mariadb-bin.000006
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 13891
              Relay_Log_Space: 19756
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 0-2-6,2-2-110
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 517
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-1-9,1-1-84,2-2-110
2 rows in set (0.00 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000014
          Read_Master_Log_Pos: 13147
               Relay_Log_File: mysqld-relay-bin-1.000020
                Relay_Log_Pos: 13437
        Relay_Master_Log_File: mariadb-bin.000014
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 13147
              Relay_Log_Space: 14510
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-84,0-1-9
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 466
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-1-9,1-1-84,2-2-110
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000006
          Read_Master_Log_Pos: 13891
               Relay_Log_File: mysqld-relay-bin-2.000012
                Relay_Log_Pos: 14181
        Relay_Master_Log_File: mariadb-bin.000006
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 13891
              Relay_Log_Space: 19756
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 0-2-6,2-2-110
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 517
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-1-9,1-1-84,2-2-110

              Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 0-1-22, which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged due to executing extra erroneous transactions'
             Last_SQL_Errno: 0
             Last_SQL_Error:
Replicate_Ignore_Server_Ids:
           Master_Server_Id: 2
             Master_SSL_Crl:
         Master_SSL_Crlpath:
                 Using_Gtid: Slave_Pos
                Gtid_IO_Pos: 1-1-189,0-1-22,2-2-199
    Replicate_Do_Domain_Ids:
Replicate_Ignore_Domain_Ids:
              Parallel_Mode: conservative
       Retried_transactions: 0
         Max_relay_log_size: 104857600
       Executed_log_entries: 1
  Slave_received_heartbeats: 0
     Slave_heartbeat_period: 1800.000
             Gtid_Slave_Pos: 0-1-22,1-1-189,2-2-199

+------------------------+---------------+
| Variable_name          | Value         |
+------------------------+---------------+
| gtid_binlog_pos        | 0-2-44,2-2-88 |
| gtid_binlog_state      | 0-2-44,2-2-88 |
| gtid_current_pos       | 0-2-44,2-2-88 |
| gtid_domain_id         | 2             |
| gtid_ignore_duplicates | OFF           |
| gtid_slave_pos         |               |
| gtid_strict_mode       | OFF           |
+------------------------+---------------+
7 rows in set (0.00 sec)

+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| gtid_binlog_pos        | 2-2-22 |
| gtid_binlog_state      | 2-2-22 |
| gtid_current_pos       | 2-2-22 |
| gtid_domain_id         | 2      |
| gtid_ignore_duplicates | OFF    |
| gtid_slave_pos         |        |
| gtid_strict_mode       | OFF    |
+------------------------+--------+
7 rows in set (0.00 sec)

MariaDB [(none)]> stop all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

MariaDB [(none)]> reset slave all ;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> reset slave '2' all;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> reset slave '1' all;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> delete from mysql.gtid_slave_pos;
Query OK, 2 rows affected (0.01 sec)

MariaDB [(none)]> Ctrl-C -- exit!
Aborted
root@slave1:/var/log/mysql# /etc/init.d/mysql  stop
[ ok ] Stopping mysql (via systemctl): mysql.service.
root@slave1:/var/log/mysql# ls
mariadb-bin.000001  mariadb-bin.index  mariadb-bin.state
root@slave1:/var/log/mysql# rm -fr *
root@slave1:/var/log/mysql# cd /var/lib/mysql/
root@slave1:/var/lib/mysql# rm -fr multi-master.info

root@slave1:/var/lib/mysql# /etc/init.d/mysql  restart
[ ok ] Restarting mysql (via systemctl): mysql.service.
root@slave1:/var/lib/mysql# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.21-MariaDB-1~jessie mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| gtid_binlog_pos        |       |
| gtid_binlog_state      |       |
| gtid_current_pos       |       |
| gtid_domain_id         | 3     |
| gtid_ignore_duplicates | OFF   |
| gtid_slave_pos         |       |
| gtid_strict_mode       | OFF   |
| wsrep_gtid_domain_id   | 0     |
| wsrep_gtid_mode        | OFF   |
+------------------------+-------+
9 rows in set (0.00 sec)

Empty set (0.00 sec)

Empty set (0.00 sec)

MariaDB [(none)]> change master '1' to master_host='192.168.56.21', master_user='replication', master_password='password', master_log_pos=314, master_log_file='mariadb-bin.000001';

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> change master '2' to master_host='192.168.56.22', master_user='replication', master_password='password', master_log_pos=314, master_log_file='mariadb-bin.000001';

Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> change master '2' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> change master '1' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> start all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

MariaDB [(none)]> select @@hostname; show slave hosts\G show global variables like '%gtid%'; select * from mysql.gtid_slave_pos; show all slaves status\G
+------------+
| @@hostname |
+------------+
| slave1     |
+------------+
1 row in set (0.00 sec)

Empty set (0.00 sec)

+------------------------+---------------+
| Variable_name          | Value         |
+------------------------+---------------+
| gtid_binlog_pos        |               |
| gtid_binlog_state      |               |
| gtid_current_pos       | 1-1-21,2-2-22 |
| gtid_domain_id         | 3             |
| gtid_ignore_duplicates | OFF           |
| gtid_slave_pos         | 1-1-21,2-2-22 |
| gtid_strict_mode       | OFF           |
| wsrep_gtid_domain_id   | 0             |
| wsrep_gtid_mode        | OFF           |
+------------------------+---------------+
9 rows in set (0.00 sec)

+-----------+--------+-----------+--------+
| domain_id | sub_id | server_id | seq_no |
+-----------+--------+-----------+--------+
|         1 |     16 |         1 |     16 |
|         1 |     17 |         1 |     17 |
|         1 |     18 |         1 |     18 |
|         1 |     19 |         1 |     19 |
|         1 |     20 |         1 |     20 |
|         1 |     21 |         1 |     21 |
|         2 |     41 |         2 |     20 |
|         2 |     42 |         2 |     21 |
|         2 |     43 |         2 |     22 |
+-----------+--------+-----------+--------+
9 rows in set (0.00 sec)

*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000001
          Read_Master_Log_Pos: 4568
               Relay_Log_File: mysqld-relay-bin-1.000002
                Relay_Log_Pos: 4858
        Relay_Master_Log_File: mariadb-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4568
              Relay_Log_Space: 5159
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-21
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 91
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 1-1-21,2-2-22
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000003
          Read_Master_Log_Pos: 4816
               Relay_Log_File: mysqld-relay-bin-2.000002
                Relay_Log_Pos: 5106
        Relay_Master_Log_File: mariadb-bin.000003
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4816
              Relay_Log_Space: 5407
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 2-2-22
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 95
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 1-1-21,2-2-22

root@localhost[(none)]> stop all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

root@localhost[(none)]> reset slave '1' all;
Query OK, 0 rows affected (0.00 sec)

root@localhost[(none)]> reset slave '2' all;
Query OK, 0 rows affected (0.00 sec)

root@localhost[(none)]> delete from mysql.gtid_slave_pos;
Query OK, 4 rows affected (0.00 sec)
root@master3:/var/log/mysql# rm -fr *
root@master3:/var/log/mysql# cd /var/lib/mysql/
root@master3:/var/lib/mysql# rm multi-master.info

MariaDB [(none)]> stop slave;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> reset slave all;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> change master to master_host='192.168.56.10', master_user='replication', master_password='password', master_log_pos=315, master_log_file='mariadb-bin.000001';
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> change master to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> start slave;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.10
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000001
          Read_Master_Log_Pos: 315
               Relay_Log_File: mysqld-relay-bin.000002
                Relay_Log_Pos: 605
        Relay_Master_Log_File: mariadb-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 315
              Relay_Log_Space: 904
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 10
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 0-10-201,2-2-88
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative

Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 2-2-88, which is not in the master's binlog'

root@localhost[(none)]> stop slave;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

root@localhost[(none)]> reset slave all;
Query OK, 0 rows affected (0.00 sec)

root@localhost[(none)]> delete from mysql.gtid_slave_pos;
Query OK, 4 rows affected (0.00 sec)
root@slave1:/var/log/mysql# rm -fr *
root@slave1:/var/log/mysql# cd /var/lib/mysql/
root@slave1:/var/lib/mysql# rm multi-master.info

*************************** 1. row ***************************
              Connection_name: 1
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.21
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000002
          Read_Master_Log_Pos: 9040
               Relay_Log_File: mysqld-relay-bin-1.000004
                Relay_Log_Pos: 9330
        Relay_Master_Log_File: mariadb-bin.000002
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 9040
              Relay_Log_Space: 9676
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-85,2-2-22
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 272
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 1-1-85,2-2-111
*************************** 2. row ***************************
              Connection_name: 2
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.22
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000003
          Read_Master_Log_Pos: 13930
               Relay_Log_File: mysqld-relay-bin-2.000006
                Relay_Log_Pos: 14220
        Relay_Master_Log_File: mariadb-bin.000003
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 13930
              Relay_Log_Space: 14566
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 2
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-21,2-2-111
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 382
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 1-1-85,2-2-111

MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.10
                  Master_User: replication
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000002
          Read_Master_Log_Pos: 40087
               Relay_Log_File: mysqld-relay-bin.000002
                Relay_Log_Pos: 9500
        Relay_Master_Log_File: mariadb-bin.000002
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 40087
              Relay_Log_Space: 9799
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 10
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 1-1-106,2-2-133
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative

Andrei Elkin closed MDEV-12012.
-------------------------------
    Fix Version/s: 10.1.30
                   10.2.11
                       (was: 10.1)
       Resolution: Fixed

Pushed aae4932775d.

MariaDB [(none)]>  change master '33' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]>  change master '34' to master_use_gtid=slave_pos;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> start all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

MariaDB [(none)]> select count(*) from test_34.t34;select count(*) from test_33.t33;
+----------+
| count(*) |
+----------+
|       20 |
+----------+
1 row in set (0.00 sec)

+----------+
| count(*) |
+----------+
|       20 |
+----------+
1 row in set (0.00 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 33
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.33
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000002
          Read_Master_Log_Pos: 3111
               Relay_Log_File: mysqld-relay-bin-33.000002
                Relay_Log_Pos: 2515
        Relay_Master_Log_File: mariadb-bin.000002
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 3111
              Relay_Log_Space: 2817
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 33
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 33-33-15,0-33-6,34-34-10
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 81
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-32-20,32-32-3,33-33-15,34-34-10
*************************** 2. row ***************************
              Connection_name: 34
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State:
                  Master_Host: 192.168.56.34
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000002
          Read_Master_Log_Pos: 2179
               Relay_Log_File: mysqld-relay-bin-34.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mariadb-bin.000002
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 2179
              Relay_Log_Space: 249
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 1236
                Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 0-33-6, which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged due to executing extra erroneous transactions'
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 34
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 33-33-5,0-33-6,34-34-10
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 54
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-32-20,32-32-3,33-33-15,34-34-10
2 rows in set (0.00 sec)

MariaDB [(none)]> select count(*) from test_34.t34;select count(*) from test_33.t33;
+----------+
| count(*) |
+----------+
|       20 |
+----------+
1 row in set (0.00 sec)

+----------+
| count(*) |
+----------+
|       30 |
+----------+
1 row in set (0.00 sec)

MariaDB [(none)]> stop all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

MariaDB [test_34]> SET SESSION gtid_domain_id=0;
Query OK, 0 rows affected (0.00 sec)

MariaDB [test_34]> SET SESSION server_id=33;
Query OK, 0 rows affected (0.00 sec)

MariaDB [test_34]> SET SESSION gtid_seq_no=6;
Query OK, 0 rows affected (0.00 sec)

MariaDB [test_34]> DROP TABLE IF EXISTS non_existing_table;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [(none)]> SET GLOBAL gtid_slave_pos='0-33-6,32-32-3,33-33-25,34-34-10';
Query OK, 0 rows affected, 1 warning (0.02 sec)

MariaDB [(none)]> start all slaves;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
              Connection_name: 33
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.33
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000002
          Read_Master_Log_Pos: 6951
               Relay_Log_File: mysqld-relay-bin-33.000002
                Relay_Log_Pos: 2578
        Relay_Master_Log_File: mariadb-bin.000002
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 6951
              Relay_Log_Space: 2880
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 33
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 33-33-35,0-33-6,32-32-3,34-34-10
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 169
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-32-20,32-32-3,33-33-35,34-34-40
*************************** 2. row ***************************
              Connection_name: 34
              Slave_SQL_State: Slave has read all relay log; waiting for the slave I/O thread to update it
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.34
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mariadb-bin.000002
          Read_Master_Log_Pos: 8047
               Relay_Log_File: mysqld-relay-bin-34.000002
                Relay_Log_Pos: 6410
        Relay_Master_Log_File: mariadb-bin.000002
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 8047
              Relay_Log_Space: 6712
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 34
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: Slave_Pos
                  Gtid_IO_Pos: 33-33-25,0-33-6,32-32-3,34-34-40
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
         Retried_transactions: 0
           Max_relay_log_size: 104857600
         Executed_log_entries: 183
    Slave_received_heartbeats: 0
       Slave_heartbeat_period: 1800.000
               Gtid_Slave_Pos: 0-32-20,32-32-3,33-33-35,34-34-40
2 rows in set (0.00 sec)

MariaDB [(none)]> select count(*) from test_34.t34;select count(*) from test_33.t33;
+----------+
| count(*) |
+----------+
|       50 |
+----------+
1 row in set (0.00 sec)

+----------+
| count(*) |
+----------+
|       40 |
+----------+
1 row in set (0.00 sec)

MariaDB [(none)]> select count(*) from test_34.t34;select count(*) from test_33.t33;
+----------+
| count(*) |
+----------+
|       53 |
+----------+
1 row in set (0.00 sec)

+----------+
| count(*) |
+----------+
|       40 |
+----------+
1 row in set (0.00 sec)

MariaDB [(none)]> select count(*) from test_34.t34;select count(*) from test_33.t33;
+----------+
| count(*) |
+----------+
|       53 |
+----------+
1 row in set (0.00 sec)

+----------+
| count(*) |
+----------+
|       41 |
+----------+
1 row in set (0.00 sec)

Assuming no new transactions will be made in domain 0 anywhere, this should
make the servers all think that they are up-to-date in domain 0. So the
slave should be able to connect to either master without complaints about
domain 0.

root@labsdb1010.eqiad.wmnet[mysql]> select * from mysql.gtid_slave_pos where domain_id=0;
+-----------+-------------+-----------+------------+
| domain_id | sub_id      | server_id | seq_no     |
+-----------+-------------+-----------+------------+
|         0 | 15718468932 | 171966669 | 4067321066 |
|         0 | 15718468938 | 171970637 | 5481803966 |
+-----------+-------------+-----------+------------+
2 rows in set (0.00 sec)

root@labsdb1010.eqiad.wmnet[mysql]> select * from mysql.gtid_slave_pos where domain_id=0;
+-----------+-------------+-----------+------------+
| domain_id | sub_id      | server_id | seq_no     |
+-----------+-------------+-----------+------------+
|         0 | 15718471510 | 171966669 | 4067321072 |
|         0 | 15718471515 | 171970637 | 5481803972 |
+-----------+-------------+-----------+------------+
2 rows in set (0.01 sec)

root@db1075[(none)]> select @@gtid_domain_id;
+------------------+
| @@gtid_domain_id |
+------------------+
|        171966669 |
+------------------+
1 row in set (0.00 sec)

root@db1052[(none)]> select @@gtid_domain_id;
+------------------+
| @@gtid_domain_id |
+------------------+
|        171970637 |
+------------------+
1 row in set (0.00 sec)

Gtid_Slave_Pos: 0-171970637-5481822048,171966555-171966555-590,171966558-171966558-63,171966574-171966574-47630128,171966669-171966669-2609597550,171966670-171966670-2410812544,171970577-171970577-597926,171970589-171970589-201132050,171970593-171970593-3479,171970599-171970599-24483,171970637-171970637-1930265453,171970663-171970663-133,171970751-171970751-21842,171974668-171974668-34,171974686-171974686-867,171974769-171974769-52,171974784-171974784-44193860,171974883-171974883-105456337,171974884-171974884-1473084269,171978764-171978764-57,171978765-171978765-33,171978766-171978766-10301,171978767-171978767-2269180357,171978771-171978771-30,171978772-171978772-1562,171978775-171978775-2709368791,171978777-171978777-851322886,171978778-171978778-628571707,180359172-180359172-49702202,180359174-180359174-94123432,180359175-180359175-43143522

root@db1077.eqiad.wmnet[labswiki]> select @@gtid_domain_id;
+------------------+
| @@gtid_domain_id |
+------------------+
|        171970751 |
+------------------+
1 row in set (0.01 sec)

['db1077.eqiad.wmnet']

['db1077.eqiad.wmnet']

FLUSH BINARY LOGS DELETE_DOMAIN_ID=(0);

MariaDB [test_m1]> FLUSH BINARY LOGS DELETE_DOMAIN_ID=(0);
ERROR 1076 (HY000): Could not delete gtid domain. Reason: binlog files may contain gtids from the domain ('0') being deleted. Make sure to first purge those files.
MariaDB [test_m1]> purge binary logs to 'mariadb-bin.000011';
Query OK, 0 rows affected (0.01 sec)

MariaDB [test_m1]> FLUSH BINARY LOGS DELETE_DOMAIN_ID=(0);
Query OK, 0 rows affected (0.02 sec)