[CONJ-714] Error reading SessionVariables is thrown when falling back to 'requestSessionDataWithShow' Created: 2019-06-11  Updated: 2019-06-17  Resolved: 2019-06-17

Status: Closed
Project: MariaDB Connector/J
Component/s: authentication, Failover
Affects Version/s: 1.7.0, 2.2.6
Fix Version/s: 2.4.2

Type: Bug Priority: Major
Reporter: Michal Podsiadlowski Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: galera
Environment:

Maria 10.2.14
Maxscale 2.0.3


 Description   

Following exception is thrown when trying to establish connection to galera slave node.
It seems to be a regression in AbstractConnectProtocol#readPipelineAdditionalData done in https://github.com/MariaDB/mariadb-connector-j/commit/ff91ae0bb4f5c49beaba7475b76883b426a51cd4#diff-95fade1a4cd0eeae0ad1c7ccf3096a9f
Previously when requestSessionDataWithShow(serverData); succeed exception was not thrown. Now this retry doesn't have any point - exception always will be thrown.

Caused by: java.sql.SQLNonTransientConnectionException: could not load system variables
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:175)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1113)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:503)
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:155)
at org.mariadb.jdbc.Driver.connect(Driver.java:86)
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:322)
... 37 more
Caused by: java.sql.SQLNonTransientConnectionException: could not load system variables
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:175)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.connException(ExceptionMapper.java:83)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.readPipelineAdditionalData(AbstractConnectProtocol.java:603)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:474)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1109)
... 41 more
Caused by: java.sql.SQLException: Error reading SessionVariables results. Socket is connected ? true
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.readRequestSessionVariables(AbstractConnectProtocol.java:569)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.readPipelineAdditionalData(AbstractConnectProtocol.java:600)
... 43 more
Generated at Thu Feb 08 03:17:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.