Error
Error Code:
1381
MariaDB Error 1381: Binary Logging Not Enabled
Description
This error indicates that the MariaDB server is configured or attempting an operation that requires binary logging, but binary logging is currently disabled. Binary logging is crucial for replication, point-in-time recovery, and auditing. It typically occurs when trying to start a replica, perform a PITR, or execute specific commands requiring a binary log.
Error Message
You are not using binary logging
Known Causes
3 known causesBinary Logging Disabled
The `log_bin` system variable is explicitly set to `OFF` or commented out in the server configuration file (`my.cnf` or `my.ini`).
Missing Startup Option
The MariaDB server was started without the necessary `--log-bin` option, preventing the creation or use of binary logs.
Insufficient Permissions
The MariaDB server process lacks write permissions to the directory designated for storing binary log files.
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