Error
Error Code:
1864
MariaDB Error 1864: MTS Event Exceeds Size Limit
Description
This error occurs in MariaDB multi-threaded replication (MTS) when a specific event from the relay log is too large to be processed by a worker thread. It indicates that the event's size exceeds the configured `slave_pending_jobs_size_max` value, preventing it from being scheduled and potentially halting replication.
Error Message
Cannot schedule event %s, relay-log name %s, position %s to Worker thread because its size %lu exceeds %lu of slave_pending_jobs_size_max.
Known Causes
3 known causesLow `slave_pending_jobs_size_max`
The configured `slave_pending_jobs_size_max` value is insufficient to accommodate large events, leading to their rejection by worker threads.
Excessively Large Events
The master is generating very large transactions or events that exceed the slave's capacity for pending jobs in its multi-threaded setup.
Unoptimized Database Operations
Inefficient queries, bulk operations, or schema designs on the master can result in individual replication events becoming unusually large.
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