[MXS-1375] Reused connections get multiple replies to COM_CHANGE_USER Created: 2017-08-24  Updated: 2017-09-01  Resolved: 2017-09-01

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: 2.1.6
Fix Version/s: 2.1.7

Type: Bug Priority: Major
Reporter: markus makela Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

When the COM_CHANGE_USER command is sent to the backend server, the response returned by the server sometimes contains two replies.

This behavior is caused by the closing of a persistent connection while it is waiting for the COM_CHANGE_USER response. When the connection that was waiting for the reply is taken back into use before the reply arrives, another COM_CHANGE_USER is sent. This causes two replies to be sent to what appears to be a single COM_CHANGE_USER command.

The fix to this is to extend the qualification checks for the connection pool to also check whether the connection is waiting for the response to the COM_CHANGE_USER.


Generated at Thu Feb 08 04:06:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.