ERROR 1840 (HY000) at line 24: GTID_PURGED can only be set when GTID_EXECUTED is empty.

執行：

[root@t1 ~]# mysql -uroot -pjsb  ailanni < /root/ailanni.sql

warning: using a password on the command line interface can be insecure.

error 1840 (hy000) at line 24: gtid_purged can only be set when gtid_executed is empty.

[root@t1 ~]# mysql -uroot -pjsb  ailanni 

解決：

reset master

再次執行，ok

參考：

<a target="_blank" href="http://www.linuxidc.com/linux/2013-04/82713p2.htm">http://www.linuxidc.com/linux/2013-04/82713p2.htm</a>