Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2890

5.5.5 prefix is always added even with version_string=8.0.16

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4.6
    • Fix Version/s: 2.5.14
    • Component/s: Core
    • Labels:
      None
    • Environment:
      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

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            yuyuyu1618 Judy Yu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration