HomeMySQLMySQL Error MY-013690 – ER_REPLICA_ANON_TO_GTID_IS_LOCAL_OR_UUID_AND_GTID_MODE_NOT_ON

MySQL Error MY-013690 – ER_REPLICA_ANON_TO_GTID_IS_LOCAL_OR_UUID_AND_GTID_MODE_NOT_ON

MySQL Error Message

Replication channel ‘%s’ is configured with
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS=’%s’, which is invalid when
GTID_MODE <> ON. If you intend to use GTID_MODE = ON
everywhere, change to ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS = OFF
and use the procedure for enabling GTIDs online (see the
documentation). If you intend to use GTIDs on this replica and
cannot enable GTIDs on the source, enable GTID_MODE = ON and leave
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS = LOCAL|<UUID>. If
you intend to not use GTIDs at all in the replication topology,
change to ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS=OFF and leave
GTID_MODE = ‘%s’.

Reason for the Error

ER_REPLICA_ANON_TO_GTID_IS_LOCAL_OR_UUID_AND_GTID_MODE_NOT_ON
was added in 8.0.33.

Share:

Leave a Reply

You May Also Like

MySQL Error Message Ignored the innodb-redo-log-capacity option in the Innodb read-only mode. Server is using active redo log files. Reason...
  • MySQL
  • November 17, 2022
MySQL Error Message This member is configured with a group_replication_paxos_single_leader option value of 1 and it is trying to join...
  • MySQL
  • November 17, 2022
MySQL Error Message Record has both instant and version bit set. Reason for the Error ER_CHECK_TABLE_INSTANT_VERSION_BIT_SET was added in 8.0.32.
  • MySQL
  • November 17, 2022