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

本文主要是介绍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

这篇关于ERROR 1840 (HY000) at line 24: GTID_PURGED can only be set when GTID_EXECUTED is empty.的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---