Warning
Error Code:
1870
MariaDB Error 1870: Row Events Not Logged for BLACKHOLE
Description
This warning indicates that MariaDB will not log row-based events for statements that modify `BLACKHOLE` storage engine tables when the binary log format is set to `ROW`. This means changes to these specific tables will not be recorded in the binary log, potentially leading to replication inconsistencies if a replica expects these changes to be applied.
Error Message
Row events are not logged for %s statements that modify BLACKHOLE tables in row format. Table(s): '%s'
Known Causes
3 known causesUsing BLACKHOLE with RBR
The `BLACKHOLE` storage engine is designed to discard all data written to it. When `binlog_format` is `ROW`, MariaDB intentionally skips logging row events for these tables to prevent unnecessary binary log growth.
Binlog Format Set to ROW
The server's `binlog_format` system variable is configured to `ROW`, which enforces row-based logging and triggers this specific warning when modifications are made to `BLACKHOLE` tables.
Attempted BLACKHOLE Replication
An attempt was made to modify a `BLACKHOLE` table on a primary server, with the expectation that these changes would be replicated to secondary servers using row-based replication, which is not supported for `BLACKHOLE` tables in RBR.
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