Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
2.4.6
-
None
-
mysql 8.0.16
maxscale 2.4.6
mysql-connector-java 8.0.16
Description
The mysql-connector-java doesn't know to remove the 5.5.5- prefix sent by MariaDB and it thinks it's using an older MySQL version. To support connectors which do not understand the 5.5.5- prefix, an option to not automatically generate it would be needed.
Original title: cannot connect db through maxscale using mysql-connector-java
I could connect DB using mysql-connector-java, and could connect DB through maxscale using mysql cli.
But when using mysql-connector-java connect DB through maxscale it says "java.sql.SQLException: Unknown system variable 'query_cache_size'". This variables is abandoned by mysql 8.0.*. And all the answer about this question is said set the right version to mysql-connector-java could solve this problem. But to me it not works, I think it may could resoved by maxscale.
I catch the packet between client mysql-connector-java and maxscale shows as attachment. 10.197.0.34 is client and 10.197.49.34 is maxscale. The packet no 8 shows it use 8.0.16 mysql-connector-java but also ask query_cache_size info.
Attachments
Issue Links
- relates to
-
MXS-4865 5.5.5- prefix should not be added if all backends are MariaDB 11
- Closed