Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
24.02.4
-
None
Description
If readwritesplit is configured with lazy_connect=true and it uses another service as one of its targets, if the sub-service fails to create a new session when a read is being routed, the read will not be retried and instead an error about failing to find a valid target is logged:
2025-01-31 12:51:04 error : (1) [readwritesplit] (RW-Split-Router); Could not find valid server for target type TARGET_SLAVE (COM_QUERY: SELECT 1), closing connection. { Name: write-service Open: No Status: Master, Running },{ Name: bad-service Open: Broken Status: Slave, Running },{ Name: read-service Open: No Status: Slave, Running }
|
This error is not correct as there is a valid server to which a connection could be created.