Error
Error Code:
3112
MySQL Error 3112: Replication AUTO_POSITION GTID_MODE OFF Conflict
Description
This error indicates that a MySQL replication receiver thread cannot start because it's configured for `AUTO_POSITION` (automatic GTID-based positioning), but the server's global `GTID_MODE` is currently set to `OFF`. It typically occurs when attempting to establish or restart replication using `MASTER_AUTO_POSITION = 1` on a replica server where GTIDs are disabled.
Error Message
The replication receiver thread%s cannot start in AUTO_POSITION mode: this server uses @@GLOBAL.GTID_MODE = OFF.
Known Causes
4 known causesAuto-Positioning Enabled on Replica
The replica server is configured to use `MASTER_AUTO_POSITION = 1` in its `CHANGE MASTER TO` statement, which explicitly requires GTID-based replication.
GTID_MODE Disabled on Server
The `@@GLOBAL.GTID_MODE` system variable on the current MySQL server is set to `OFF`, preventing the use of Global Transaction Identifiers (GTIDs).
GTID Configuration Mismatch
There is an inconsistency in GTID configuration, where the master server may be operating with GTIDs, but the replica is not prepared to handle them with `AUTO_POSITION` enabled.
Improper Replication Setup
Replication was initiated or restarted with `MASTER_AUTO_POSITION = 1` without ensuring that GTIDs are properly enabled and configured on the replica server.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service