MySQL Error number: 4019; Symbol: ER_CANT_SET_SQL_AFTER_OR_BEFORE_GTIDS_WITH_ANONYMOUS_TO

文档解释

Error number: 4019; Symbol: ER_CANT_SET_SQL_AFTER_OR_BEFORE_GTIDS_WITH_ANONYMOUS_TO_GTID; SQLSTATE: HY000

Message: The SQL_AFTER_GTIDS or SQL_BEFORE_GTIDS clauses for START REPLICA cannot be used when the replication channel is configured with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS = LOCAL|.

错误说明：

ER_CANT_SET_SQL_AFTER_OR_BEFORE_GTIDS_WITH_ANONYMOUS_TO_GTID错误表示，在指定的global transaction ID(GTID)前后设置SQL语句时，在设置开始已定义ANONYMOUSGTID到GTID模式时发生错误。

常见案例

这个错误是在同步MySQL时可能会出现的。此错误发生时，尝试在当前使用SQL语句进行同步操作前设置ANONYMOUS_GTID到GTID模式，但未指定任何全局事务ID，导致发生此错误。

解决方法：

要解决此错误，只需正确指定全局事务ID，然后再同步MySQL服务。要确定全局事务ID，请在复制源上使用show global transaction ID命令。另外，可以使用change master语句指定GTID模式，以确保拥有正确的total global transaction ID。

文章详情

MySQL Error number: 4019; Symbol: ER_CANT_SET_SQL_AFTER_OR_BEFORE_GTIDS_WITH_ANONYMOUS_TO_GTID; SQLS

文档解释

常见案例

软考中级精品资料免费领

相关文章

猜你喜欢

MySQL Error number: 4019; Symbol: ER_CANT_SET_SQL_AFTER_OR_BEFORE_GTIDS_WITH_ANONYMOUS_TO_GTID; SQLS

MySQL Error number: 4069; Symbol: ER_CHANGE_REP_SOURCE_CANT_DISABLE_AUTO_POS_WITHOUT_POSITIONS; SQLS

MySQL Error number: 4072; Symbol: ER_WARN_C_DISABLE_GTID_ONLY_WITH_SOURCE_AUTO_POS_INVALID_POS; SQLS

MySQL Error number: MY-013863; Symbol: ER_IB_MSG_LOG_FILES_CREATED_BY_CLONE_AND_READ_ONLY_MODE; SQLS

MySQL Error number: MY-013780; Symbol: ER_GRP_RPL_MYSQL_NETWORK_PROVIDER_CLIENT_ERROR_CONN_ERR; SQLS

MySQL Error number: MY-010460; Symbol: ER_INIT_DATADIR_EXISTS_AND_NOT_WRITABLE_WONT_INITIALIZE; SQLS

MySQL Error number: MY-013956; Symbol: ER_THREAD_POOL_QUERY_THRS_PER_GRP_EXCEEDS_TXN_THR_LIMIT; SQLS

MySQL Error number: MY-011260; Symbol: ER_SYS_VAR_COMPONENT_FAILED_TO_MAKE_VARIABLE_PERSISTENT; SQLS

MySQL Error number: MY-013362; Symbol: ER_SERVER_BINLOG_MASTER_KEY_RECOVERY_OUT_OF_COMBINATION; SQLS

MySQL Error number: MY-010438; Symbol: ER_ENGINE_COST_INVALID_CONST_CONSTANT_FOR_SE_AND_DEVICE; SQLS

MySQL Error number: MY-013482; Symbol: ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_TYPE; SQLS

MySQL Error number: MY-011612; Symbol: ER_GRP_RPL_FAILED_TO_REGISTER_TRANS_OUTCOME_NOTIFICTION; SQLS

MySQL Error number: MY-013741; Symbol: ER_GRP_RPL_MEMBER_ACTION_INVALID_ACTIONS_ON_MEMBER_JOIN; SQLS

MySQL Error number: MY-011225; Symbol: ER_AUDIT_LOG_FILTER_FAILED_TO_CLOSE_TABLE_AFTER_READING; SQLS

MySQL Error number: MY-011327; Symbol: ER_XPLUGIN_EXISTING_USER_ACCOUNT_WITH_INCOMPLETE_GRANTS; SQLS

MySQL Error number: MY-011466; Symbol: ER_GRP_RPL_ADD_RETRIEVED_SET_TO_GRP_GTID_EXECUTED_ERROR; SQLS

MySQL Error number: MY-010486; Symbol: ER_NDB_SLAVE_BINLOG_MISSING_INFO_FOR_CONFLICT_DETECTION; SQLS

MySQL Error number: MY-011280; Symbol: ER_CONN_CONTROL_STAT_CONN_DELAY_TRIGGERED_UPDATE_FAILED; SQLS

MySQL Error number: MY-013922; Symbol: ER_COMPONENT_EE_FUNCTION_PRIVATE_KEY_GENERATION_FAILURE; SQLS

MySQL Error number: MY-013311; Symbol: ER_GRP_RPL_REGISTER_TRX_TO_WAIT_FOR_DEPENDENCIES_FAILED; SQLS