ERROR 1840 (HY000) at line 24: GTID_PURGED can only be set when GTID_EXECUTED is empty.
来源:互联网 发布:手机传软件 编辑:程序博客网 时间:2024/05/20 11:25
执行:
[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 0
- ERROR 1840 (HY000) at line 24: GTID_PURGED can only be set when GTID_EXECUTED is empty.
- ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is e
- An error occurred at line: 7 in the generated java file Only a type can be imported. java.util.list
- ERROR 23 (HY000) at line 1: Out of resources when opening file '/tmp/tbs.log' (Errcode: 24 "Too many
- 关于MYSQL Error:ERROR 1005 (HY000) at line 3: Can't create table '.\xx.frm'错误
- ERROR 1005 (HY000) at line 372: Can't create table './xxx.frm' (errno: 150)
- ERROR 1005 (HY000) at line 1679: Can't create table 'db_name.table_name' (errno: 708)
- ERROR 1005 (HY000) at line 3706: Can't create table 'db_name.table_name' (errno: 136)
- 解决MongoDB读数据报异常readEndDocument can only be called when State is END_OF_DOCUMENT
- 服务器返回错误error on line 1 at column 1: Document is empty
- php操作xml:error on line 1 at column 1: Document is empty
- 服务器返回错误error on line 1 at column 1: Document is empty
- Xcode 6.2 error::can only be used when targeting iOS 4.2 or later
- Xcode 6.2 error::can only be used when targeting iOS 4.2 or later错误处理
- Syntax error, type annotations are available only when source level is at least 1.8
- SELECT ... INTO OUTFILE报错ERROR 1 (HY000) at line 1: Can't create/write to file...
- ERROR 1010 (HY000) at line 1: Error dropping database
- This page contains the following errors: error on line 1 at column 1: Document is empty Below is a
- java 中的printStackTrace()方法
- maven构建项目若干问题整理
- 问题 H: 2.4.5 Fractions to Decimals 分数化小数
- OC中Foundation框架字符串NSString和NSMutableString的使用
- android studio gradle 空项目
- ERROR 1840 (HY000) at line 24: GTID_PURGED can only be set when GTID_EXECUTED is empty.
- 第三周项目(4):百鸡问题
- JavaScript 事件模型
- 第二章:HTML常用标签
- 二叉树:后序,递归和非递归,应用(求祖先问题)
- andorid与ros互操作的关键点
- Xcode git的使用
- mysql不支持中文字符的解决办法
- Editable和string区别