Error
Error Code:
4094
MySQL Error 4094: Queries Blocked During Primary Change
Description
This error indicates that all database queries are temporarily blocked because the `group_replication_set_as_primary()` function is actively executing. This operation is essential for promoting a new primary member within a MySQL Group Replication cluster, ensuring data consistency during the role transition.
Error Message
All queries have been blocked while function 'group_replication_set_as_primary()' is executing. Please refer timeout parameter of function 'group_replication_set_as_primary()'.
Known Causes
3 known causesPrimary Member Role Transition
The `group_replication_set_as_primary()` function is deliberately invoked to switch the primary role among members in a Group Replication cluster.
Manual Primary Promotion
An administrator explicitly initiated the primary change using the `group_replication_set_as_primary()` function.
Extended Operation Duration
The primary change operation is taking longer than usual, potentially due to network latency, heavy workload, or cluster member responsiveness.
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