OffOn
    Register
    HomeMySQL

    MySQL Error MY-013100 – ER_RPL_GTID_UNSAFE_STMT_ON_TEMPORARY_TABLE

    admin November 13, 2024 No Comments

    MySQL Error Message

    Statement violates GTID consistency: CREATE TEMPORARY
    TABLE and DROP TEMPORARY TABLE can only be executed outside
    transactional context. These statements are also not allowed in a
    function or trigger because functions and triggers are also
    considered to be multi-statement transactions.

    Reason for the Error

    ER_RPL_GTID_UNSAFE_STMT_ON_TEMPORARY_TABLE
    was added in 8.0.11, removed after 8.0.12.

    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