[MXS-1876] Connection via Connector Java 2.2.4 randomly fails with 'could not load system variables' Created: 2018-05-18  Updated: 2020-08-25  Resolved: 2018-07-06

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: None
Fix Version/s: 2.2.0

Type: Bug Priority: Major
Reporter: Claudio Nanni Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None


 Description   

Simple connection to MaxScale 2.1 via JDBC 2.2.4 fails with:

could not load system variables

Using JDBC 2.1 succeeds, as well as using MaxScale 2.2 with any JDBC version.

                  MaxScale 2.1    MaxScale 2.2
JDBC 2.1                OK              OK
JDBC 2.2                ERR             OK

If I add `usePipelineAuth=false` parameter to Java the problem disappears.



 Comments   
Comment by markus makela [ 2018-05-21 ]

If I remember correctly, this might have been a problem with how extra data was discarded after the authentication packet was read.

Comment by Johan Wikman [ 2018-07-06 ]

In 2.1 this can be worked around by setting

usePipelineAuth=false&useBatchMultiSend=false

in the JDBC connection.

This will solve the problem and has no consequences apart from disabling batch statements, which could have a slight impact on the performance.

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