OffOn
    Register
    HomeMySQL

    MySQL Error 1885 – ER_REPLICA_HAS_MORE_GTIDS_THAN_SOURCE

    admin November 29, 2024 No Comments

    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.

    Tag:

    Share:

    Leave A Reply

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

    You May Also Like

    See more

    MySQL Error MY-010296 – ER_X509_CANT_READ_CA_KEY

    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.
    Read more

    MySQL Error MY-010588 – ER_RPL_SLAVE_READ_INVALID_EVENT_FROM_MASTER

    MySQL Error Message Read invalid event from master: ‘%s’, master could be corrupt but a more likely cause of this...
    Read more

    MySQL Error MY-012140 – ER_IB_MSG_315

    MySQL Error Message %s Reason for the Error ER_IB_MSG_315 was added in 8.0.11.
    Read more