Comment 2 for bug 1707811

Revision history for this message
supersujj (supersujj) wrote :

can you test when master/slave Switching occurs,and i found when SELECT @@global.gtid_executed; have not only one record like :
SELECT @@global.gtid_executed;
+---------------------------------------------------------------------------------------------------+
| @@global.gtid_executed |
+---------------------------------------------------------------------------------------------------+
| 12361081-90f4-11e6-8413-0050569293fc:1-286495163,
59eaee0c-9289-11e5-8911-005056923a57:1-40235250 |
+---------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

when i use --history ,it can not insert record,but when table no exist,it will create. and i see the binlog have not some insert record.

if i reset the gtid_executed when i have only one records like:
SELECT @@global.gtid_executed;
+---------------------------------------------------------------------------------------------------+
| @@global.gtid_executed |
+---------------------------------------------------------------------------------------------------+
| 12361081-90f4-11e6-8413-0050569293fc:1-234 |
+---------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

it can insert the records.

i try to use 2.3.7,2.3.8 version and the results is the same.

 xtrabackup have not --history, is it have any other way can insert the backup record into database?