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 

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

解决：

reset master

再次执行，OK

参考：

http://www.linuxidc.com/Linux/2013-04/82713p2.htm