Error
Error Code:
1783
MariaDB Error 1783: GTID_NEXT_LIST with GTID_MODE OFF
Description
This error indicates an attempt to assign a specific Global Transaction ID (GTID) using `@@SESSION.GTID_NEXT_LIST` while GTID functionality is globally disabled. It typically occurs when a session tries to manage GTIDs for transactions, but the server's `@@GLOBAL.GTID_MODE` is set to `OFF`. This conflict prevents the session from explicitly setting a GTID.
Error Message
@@SESSION.GTID_NEXT_LIST cannot be set to a non-NULL value when @@GLOBAL.GTID_MODE = OFF.
Known Causes
3 known causesGlobal GTID Mode Disabled
The server's `@@GLOBAL.GTID_MODE` is explicitly set to `OFF`, but a session or application attempts to assign a GTID via `@@SESSION.GTID_NEXT_LIST`.
Incorrect Application GTID Handling
An application or script is designed to set `GTID_NEXT_LIST` without first checking or correctly configuring the global `GTID_MODE` setting.
Replication Setup Mismatch
During a replication setup or migration, a session tries to manually control GTIDs, but the global GTID mode is not enabled on the specific server instance.
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