[#MDEV-4067] MariaDB client library not compatible with mysql-proxy

[MDEV-4067] MariaDB client library not compatible with mysql-proxy Created: 2013-01-18 Updated: 2013-01-28 Resolved: 2013-01-28
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	5.5.28a
Fix Version/s:	None

Type:

Bug

Priority:

Critical

Reporter:

VAROQUI Stephane

Assignee:

Elena Stepanova

Resolution:

Not a Bug

Votes:

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: ||

Comments

Comment by Elena Stepanova [ 2013-01-20 ]

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.

Comment by Elena Stepanova [ 2013-01-28 ]

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 . "

Generated at Thu Feb 08 06:53:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-4067] MariaDB client library not compatible with mysql-proxy Created: 2013-01-18 Updated: 2013-01-28 Resolved: 2013-01-28