HomeMySQLMySQL Error 1885 – ER_REPLICA_HAS_MORE_GTIDS_THAN_SOURCE

MySQL Error 1885 – ER_REPLICA_HAS_MORE_GTIDS_THAN_SOURCE

MySQL Error Message

Replica has more GTIDs than the source has, using the
source’s SERVER_UUID. This may indicate that the the last binary
log file was truncated or lost, e.g., after a power failure when
sync_binlog != 1. The source may have rolled back transactions
that were already replicated to the replica. Replicate any
transactions that source has rolled back from replica to source,
and/or commit empty transactions on source to account for
transactions that have been committed on source but are not
included in GTID_EXECUTED.

Reason for the Error

ER_REPLICA_HAS_MORE_GTIDS_THAN_SOURCE
was added in 8.0.33.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

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