HomeMySQLMySQL Error 1885 – ER_SLAVE_HAS_MORE_GTIDS_THAN_MASTER

MySQL Error 1885 – ER_SLAVE_HAS_MORE_GTIDS_THAN_MASTER

MySQL Error Message

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

Reason for the Error

ER_SLAVE_HAS_MORE_GTIDS_THAN_MASTER
was removed after 8.0.32.

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