[MXS-1902] COM_CHANGE_USER lost connection Created: 2018-06-05  Updated: 2018-06-21  Resolved: 2018-06-21

Status: Closed
Project: MariaDB MaxScale
Component/s: mariadbclient
Affects Version/s: 2.2.7
Fix Version/s: 2.2.10

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


 Description   

When execute mysql_change_user(), client api return error below '2013 Lost connection to MySQL server at 'reading final connect information', system error: 0'

 Comments   
Comment by dapeng huang [ 2018-06-07 ]

The reason maybe 

if (!proto->changing_user && proto->current_command == MXS_COM_CHANGE_USER)
 
            {
 
                changed_user = true;
 
                send_auth_switch_request_packet(session->client_dcb);
 
 
 
                // Store the original COM_CHANGE_USER for later
 
                proto->stored_query = packetbuf;
 
                packetbuf = NULL;
 
            }

this branch did not set rc; so the return value of route_by_statement is uncertain, if return_code is not 0, the connection will be close;

Comment by markus makela [ 2018-06-21 ]

Should be fixed by commit e99d9826ad1cb7cb293de1c3929a0dd1db28d779.

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