MySQL Error 3993: Replication Auto-Position Conflict

📋

Description

This error indicates a conflict during MySQL replication source configuration. It occurs when you attempt to disable `SOURCE_AUTO_POSITION` (by setting it to 0) while the `SOURCE_CONNECTION_AUTO_FAILOVER` option is still enabled (set to 1). MySQL requires `SOURCE_CONNECTION_AUTO_FAILOVER` to be disabled before `SOURCE_AUTO_POSITION` can be successfully turned off.

💬

Error Message

CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0 cannot be executed because Asynchronous Replication Connection Failover is enabled i.e. CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER = 1.

🔍

Known Causes

3 known causes

⚠️

Conflicting Replication Parameters

You are attempting to set `SOURCE_AUTO_POSITION = 0`, but MySQL's asynchronous replication connection failover (via `SOURCE_CONNECTION_AUTO_FAILOVER = 1`) is active, creating a disallowed state.

⚠️

Incorrect Configuration Order

The command to disable `SOURCE_AUTO_POSITION` was executed without first disabling `SOURCE_CONNECTION_AUTO_FAILOVER`, which is a prerequisite for this operation.

⚠️

Unaware Scripted Changes

An automated script or configuration management tool applied replication settings without checking or adjusting dependent parameters like `SOURCE_CONNECTION_AUTO_FAILOVER`.

🛠️

Solutions

Coming Soon

Detailed 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

Find Help

Stack Overflow Google Search Official Docs

🔗

Related Errors

5 related errors