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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.4.6
    • 2.5.14
    • Core
    • 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

        1. mysql-direct.pcap
          4 kB
          Judy Yu
        2. maxscale-client.pcap
          2 kB
          Judy Yu
        3. jmeter-client.pcap
          2 kB
          Judy Yu

        Issue Links

          Activity

            People

              Unassigned Unassigned
              yuyuyu1618 Judy Yu
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.