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

  1. 云栖社区>
  2. 博客>
  3. 正文

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

白及88 2016-03-19 12:49:00 浏览1160
展开阅读全文


执行:

[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



网友评论

登录后评论
0/500
评论
白及88
+ 关注