My Oracle Support Banner

Error Persisting GTIDs To Table with no other symptoms (Doc ID 3023469.1)

Last updated on JUNE 11, 2024

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

 The error log contains the isolated message:

 There are no other messages indicating a problem with the gtid_executed table or a lock wait timeout. There are no symptoms of problems with replication.

The result set from SELECT * FROM mysql.gtid_executed; shows a list of GTIDs which does not contain any gaps within the sequence, but might show ranges of GTIDs which could be condensed into a single range.

If the binary log is enabled, the timestamp of the error is close to the time that a binary log rotation occurred.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.