[CONJ-928] mariadb connector J 2.7.5 can't connect MySQL 5.6.16 or older Created: 2022-02-15  Updated: 2022-02-16  Resolved: 2022-02-15

Status: Closed
Project: MariaDB Connector/J
Component/s: MySQL compatibility
Affects Version/s: 2.7.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: fanzhang Assignee: Diego Dupin
Resolution: Won't Do Votes: 0
Labels: replication
Environment:

OS:centos7.2
Mysql :Ali RDS mysql 5.6.16-log

Issue Links:
Relates

 Description   

mariadb connector J 2.7.5 can't connect to mysql version 5.6.16-log
but change mysql version into 5.7 ,it's OK.
Could you help me to solve ?
"java.sql.SQLException: Unknown system variable 'session_track_system_variables'", because i want to connect different mysql version, one is 5.6.16, one is 5.7. i will use rewriteBatchedStatements this parameter. when i connect mysql version 5.6.16-log，it will produce this problem

 Comments   
Comment by Diego Dupin [ 2022-02-15 ]

Then, there is a bug in this Mysql :Ali 5.6: it would seem server indicate that it support session tracking feature without really supporting it ( send CLIENT_SESSION_TRACK capability in initial Handshake packet).
Since mysql ali is not supported there isn't something i can do.

As a workaround, you can remove rewriteBatchedStatements option with 5.6. Batches will be a little bit slower, but there won't be other problems.

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