Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4067

MariaDB client library not compatible with mysql-proxy

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Not a Bug
        • Affects Version/s: 5.5.28a
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None
        • Environment:
          CentOS Linux release 6.0 (Final) MariaDB server release 5.5.28a-MariaDB-log
          Tested MySQL client lib from source MySQL mysql-5.5.25a and mariadb-5.5.25a. Tested with mysql-proxy 8.2 and 9.0

          Description

          export LD_LIBRARY_PATH=/usr/local/skysql/mariadb-client/lib/
          [root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.10 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 3306 -o /var/lib/skysql/bench1/clientUser skysql Pass skyvodka
          opening 10 conenction(s) to dbt2...
          listening to port 30000
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          cannot connect to database(see details in error.log file, exiting...
          [root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.10 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 3306 -o /var/lib/skysql/bench1/clientUser skysql Pass skyvodka
          opening 10 conenction(s) to dbt2...
          listening to port 30000
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          cannot connect to database(see details in error.log file, exiting...
          [root@ip-10-0-0-47 ~]# export LD_LIBRARY_PATH=/usr/local/skysql/mysql-client/lib/ [root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.10 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 3306 -o /var/lib/skysql/bench1/clientUser skysql Pass skyvodka
          opening 10 conenction(s) to dbt2...
          listening to port 30000
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          client has started
          ^C
          [root@ip-10-0-0-47 ~]# export LD_LIBRARY_PATH=/usr/local/skysql/mariadb-client/lib/[root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.10 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 3306 -o /var/lib/skysql/bench1/clientUser skysql Pass skyvodka
          opening 10 conenction(s) to dbt2...
          listening to port 30000
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
          cannot connect to database(see details in error.log file, exiting...
          [root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.102 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 5010 -o /var/lib/skysql/bench1/client
          User skysql Pass skyvodka
          opening 10 conenction(s) to dbt2...
          listening to port 30000
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
          connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment - - edited

                Hi Stephane,

                What does the client's error.log say when DBT2 client cannot connect?

                Also, please specify which version of DBT2 client you are using. I've downloaded dbt2-0.37.50.3 which is currently available at http://dev.mysql.com/downloads/benchmarks.html, and it's apparently different from yours.

                And btw, i'm not quite sure from the output above – 5010 is your server port, and 3306 your proxy port? Then, how did the last attempt to connect (to 5010) end, was it successful, or failed too?

                Thanks.

                Show
                elenst Elena Stepanova added a comment - - edited Hi Stephane, What does the client's error.log say when DBT2 client cannot connect? Also, please specify which version of DBT2 client you are using. I've downloaded dbt2-0.37.50.3 which is currently available at http://dev.mysql.com/downloads/benchmarks.html , and it's apparently different from yours. And btw, i'm not quite sure from the output above – 5010 is your server port, and 3306 your proxy port? Then, how did the last attempt to connect (to 5010) end, was it successful, or failed too? Thanks.
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Closing it based on a comment from Stephane (via email) that it's not a bug in the library:

                "MDEV-4067
                Can be clause this is really a mysql-proxy issue with read write splitting script . "

                Show
                elenst Elena Stepanova added a comment - Closing it based on a comment from Stephane (via email) that it's not a bug in the library: " MDEV-4067 Can be clause this is really a mysql-proxy issue with read write splitting script . "

                  People

                  • Assignee:
                    elenst Elena Stepanova
                    Reporter:
                    stephane@skysql.com VAROQUI Stephane
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: