MySQL Error number: MY-013754; Symbol: ER_WARN_REPLICA_ANONYMOUS_TO_GTID_UUID_SAME_AS_VIEW_CHANGE

文档解释

Error number: MY-013754; Symbol: ER_WARN_REPLICA_ANONYMOUS_TO_GTID_UUID_SAME_AS_VIEW_CHANGE_UUID; SQLSTATE: HY000

Message: Replication channel ‘%s’ is configured with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS=’%s’ which is equal to group_replication_view_change_uuid. To fix this issue, either change the group_replication_view_change_uuid or use a different value for ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS.

MY-013754（ER_WARN_REPLICA_ANONYMOUS_TO_GTID_UUID_SAME_AS_VIEW_CHANGE_UUID）错误是MySQL中一个可能出现的错误，它表示GTID的UUID与显示改变的UUID相同。这通常意味着，在当前的同步线程会话中，GTID UUID与改变时间戳UUID相同。这通常是因为运行时选项 binary_log_uuid 与 server_uuid不同，后者在改变时戳中使用。

该错误通常发生在MySQL中，当用户尝试同步一个具有相同UUID的复制服务器时。如果历史上存在更改，则会出现这种情况。这使复制服务器无法传输日志文件，并且在同步失败的情况下可能会出现此错误。

常见案例

要解决MY-013754（ER_WARN_REPLICA_ANONYMOUS_TO_GTID_UUID_SAME_AS_VIEW_CHANGE_UUID）错误，最佳的解决方法是更新MySQL客户端。同样，如果用户在MySQL服务器上使用旧版本，则应更新到最新版本。同时，可以检查 binary_log_uuid 和 server_uuid变量的值，确保它们的值是有效的。此外，还可以在当前的同步进程会议中重置复制器，以便其UUID被正确更新，从而解决错误。

文章详情

MySQL Error number: MY-013754; Symbol: ER_WARN_REPLICA_ANONYMOUS_TO_GTID_UUID_SAME_AS_VIEW_CHANGE_UU

文档解释

常见案例

软考中级精品资料免费领

相关文章

猜你喜欢

MySQL Error number: MY-013754; Symbol: ER_WARN_REPLICA_ANONYMOUS_TO_GTID_UUID_SAME_AS_VIEW_CHANGE_UU

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;

MySQL Error number: MY-013363; Symbol: ER_SERVER_BINLOG_MASTER_KEY_ROTATION_FAIL_TO_CLEANUP_AUX_KEY;

MySQL Error number: MY-011413; Symbol: ER_KEYRING_ENCRYPTED_FILE_INIT_FAILED_DUE_TO_INTERNAL_ERROR;

MySQL Error number: MY-013429; Symbol: ER_AUDIT_LOG_FILE_NAME_TIMESTAMP_VALUE_IS_MISSING_OR_INVALID;

MySQL Error number: MY-013876; Symbol: ER_IB_MSG_LOG_UPGRADE_NON_PERSISTED_DD_METADATA__UNEXPECTED;

MySQL Error number: MY-010598; Symbol: ER_RPL_SLAVE_NEW_MASTER_INFO_NEEDS_REPOS_TYPE_OTHER_THAN_FILE

MySQL Error number: MY-010955; Symbol: ER_TX_EXTRACTION_ALGORITHM_FOR_BINLOG_TX_DEPEDENCY_TRACKING;

MySQL Error number: MY-011414; Symbol: ER_KEYRING_ENCRYPTED_FILE_GEN_KEY_FAILED_DUE_TO_INTERNAL_ERRO

MySQL Error number: MY-010417; Symbol: ER_RPL_CHANGING_RELAY_LOG_INFO_REPO_TYPE_FAILED_DUE_TO_GAPS;

MySQL Error number: MY-011689; Symbol: ER_GRP_RPL_FLOW_CTRL_MIN_RECOVERY_QUOTA_GREATER_THAN_MAX_QUOT

MySQL Error number: MY-013316; Symbol: ER_GRP_RPL_RELEASE_BEGIN_TRX_AFTER_WAIT_FOR_SYNC_BEFORE_EXEC;

MySQL Error number: MY-013289; Symbol: ER_SERVER_RPL_ENCRYPTION_UNABLE_TO_ROTATE_MASTER_KEY_AT_START

MySQL Error number: MY-011770; Symbol: ER_LDAP_AUTH_FAILED_TO_DEINITIALIZE_POOL_IN_RECONSTRUCT_STATE

MySQL Error number: MY-013306; Symbol: ER_GRP_RPL_FAILED_TO_INSERT_TRX_ON_TCM_ON_AFTER_CERTIFICATION

MySQL Error number: MY-013690; Symbol: ER_SLAVE_ANONYMOUS_TO_GTID_IS_LOCAL_OR_UUID_AND_GTID_MODE_NOT

MySQL Error number: MY-011431; Symbol: ER_KEYRING_AWS_FAILED_TO_GENERATE_KEY_DUE_TO_INTERNAL_ERROR;

MySQL Error number: MY-011638; Symbol: ER_GRP_RPL_FAILED_TO_START_ON_SECONDARY_WITH_ASYNC_CHANNELS;

MySQL Error number: MY-013726; Symbol: ER_NOTE_KEYRING_COMPONENT_KEYS_METADATA_ITERATOR_FETCH_FAILED