Error
Error Code:
1387
MariaDB Error 1387: Global Variable Change Restricted
Description
This error indicates an attempt to modify a global server variable using `SET GLOBAL` when binary logging and/or replication are active on the MariaDB server. MariaDB intentionally restricts these changes to prevent potential data inconsistencies on replica servers and maintain the integrity of the binary log for recovery purposes.
Error Message
Binary logging and replication forbid changing the global server %s
Known Causes
3 known causesBinary Logging Active
The MariaDB server has binary logging enabled, which records all data-modifying statements for replication and point-in-time recovery.
Replication in Progress
The server is configured as a primary (master) in a replication setup, actively sending binary log events to one or more replica servers.
Attempting Global Variable Change
An SQL statement like `SET GLOBAL variable_name = value;` was executed, attempting to alter a server parameter at the global scope.
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