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 Could not read CA key file: %s Reason for the Error ER_X509_CANT_READ_CA_KEY was added in 8.0.2.
MySQL Error Message Read invalid event from master: ‘%s’, master could be corrupt but a more likely cause of this...
MySQL Error Message %s Reason for the Error ER_IB_MSG_315 was added in 8.0.11.