OffOn
    Register
    HomeMySQL

    MySQL Error 4017 – ER_USING_ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_AS_LOCAL_OR_UUID

    admin November 29, 2024 No Comments

    MySQL Error Message

    Using ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS creates
    limitations on the replication topology – you cannot fail over
    between downstream and upstream servers. Only use this option if
    it is not possible to enable GTIDs on the source, for instance,
    because of lack of permissions. If possible, use the procedure for
    enabling GTID transactions online instead, as described in the
    documentation.

    Reason for the Error

    ER_USING_ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_AS_LOCAL_OR_UUID
    was added in 8.0.23.

    Tag:

    Share:

    Leave A Reply

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

    You May Also Like

    See more
    code coder coding computer

    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
    code coder coding computer

    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
    code coder coding computer

    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