MySQL Error number: 4067; Symbol: ER_CHANGE_REP_SOURCE_CANT_DISABLE_AUTO_POSITION_WITH_GTID

文档解释

Error number: 4067; Symbol: ER_CHANGE_REP_SOURCE_CANT_DISABLE_AUTO_POSITION_WITH_GTID_ONLY; SQLSTATE: HY000

Message: SOURCE_AUTO_POSITION cannot be disabled for replication channel ‘%s’ when GTID_ONLY=1.

错误说明

ER_CHANGE_REP_SOURCE_CANT_DISABLE_AUTO_POSITION_WITH_GTID_ONLY错误编号 occurrs,当一个试图禁用复制自动位置仅通过GTID机制所指定的更改时，会发生这种情况。它发生当 “AUTO_POSITION”参数被设置为也“0”，在CHANGE MASTER TO语句的集合条件中指定了GTID，并且没有日志文件名或坐标指定。

常见案例

最常见的情况是，启用GTID replication时，会发生ER_CHANGE_RECD_SOURCE_CANT_DISABLE_AUTO_POSITION_WITH_GTID_ONLY错误，尤其是在CHANGE MASTER TO命令中，GTID参数被指定了，但在参数中没有指定日志文件名或坐标。

解决方法

解决 ER_CHANGE_RECD_SOURCE_CANT_DISABLE_AUTO_POSITION_WITH_GTID_ONLY错误，只需要在CHANGE MASTER TO命令中指定文件名和位置参数，且LOG_FILE和LOG_POS参数不能被设定为0。这将确保你的同步过程正确的运行，避免出现此类问题。

文章详情

MySQL Error number: 4067; Symbol: ER_CHANGE_REP_SOURCE_CANT_DISABLE_AUTO_POSITION_WITH_GTID_ONLY; SQ

文档解释

软考中级精品资料免费领

相关文章

猜你喜欢

MySQL Error number: 4067; Symbol: ER_CHANGE_REP_SOURCE_CANT_DISABLE_AUTO_POSITION_WITH_GTID_ONLY; SQ

MySQL Error number: MY-011772; Symbol: ER_LDAP_AUTH_FAILED_TO_GET_CONNECTION_AS_PLUGIN_NOT_READY; SQ

MySQL Error number: MY-011592; Symbol: ER_GRP_RPL_FAILED_TO_BROADCAST_MEMBER_STATUS_NOTIFICATION; SQ

MySQL Error number: MY-013302; Symbol: ER_CACHING_SHA2_PASSWORD_SECOND_PASSWORD_USED_INFORMATION; SQ

MySQL Error number: MY-010590; Symbol: ER_RPL_SLAVE_IO_THREAD_DETECTED_UNEXPECTED_EVENT_SEQUENCE; SQ

MySQL Error number: MY-013772; Symbol: ER_IB_MSG_RECOVERY_NO_SPACE_IN_REDO_LOG__SKIP_IBUF_MERGES; SQ

MySQL Error number: MY-014001; Symbol: ER_RPL_REPLICA_CONNECTED_TO_SOURCE_RPL_STARTED_FILE_BASED; SQ

MySQL Error number: MY-013799; Symbol: ER_AUTHENTICATION_PLUGIN_REGISTRATION_INSUFFICIENT_BUFFER; SQ

MySQL Error number: MY-010647; Symbol: ER_NDB_BINLOG_SKIPPING_DROP_OF_DB_CONTAINING_LOCAL_TABLES; SQ

MySQL Error number: MY-010664; Symbol: ER_NDB_BINLOG_NDB_LOG_APPLY_STATUS_FORCING_FULL_USE_WRITE; SQ

MySQL Error number: MY-013758; Symbol: ER_GRP_RPL_UPDATE_GRPGTID_VIEW_CHANGE_UUID_EXECUTED_ERROR; SQ

MySQL Error number: MY-010660; Symbol: ER_NDB_BINLOG_WRITE_TO_NDB_BINLOG_INDEX_FAILED_AFTER_KILL; SQ

MySQL Error number: MY-013300; Symbol: ER_MYSQL_NATIVE_PASSWORD_SECOND_PASSWORD_USED_INFORMATION; SQ

MySQL Error number: MY-014002; Symbol: ER_RPL_REPLICA_CONNECTED_TO_SOURCE_RPL_STARTED_GTID_BASED; SQ

MySQL Error number: MY-010522; Symbol: ER_TC_CANT_AUTO_RECOVER_WITH_TC_HEURISTIC_RECOVER; SQ

MySQL Error number: 4018; Symbol: ER_CANT_SET_ANONYMOUS_TO_GTID_AND_WAIT_UNTIL_SQL_THD_AFTER_GTIDS;

MySQL Error number: 4017; Symbol: ER_USING_ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_AS_LOCAL_OR_UUID;

MySQL Error number: 4142; Symbol: ER_BULK_LOADER_FILE_CONTAINS_LESS_LINES_THAN_IGNORE_CLAUSE; SQLSTA

MySQL Error number: MY-010790; Symbol: ER_NDB_NODEID_NOT_FIRST_IN_NDB_CLUSTER_CONNECTION_POOL_NODEID

MySQL Error number: MY-011653; Symbol: ER_GRP_RPL_RECOVERY_MODULE_TERMINATION_TIMED_OUT_ON_SHUTDOWN;