sql-bench test fails

[Niels de Carpentier]

Hi,

I'm doing some testing with mysql proxy to see if we can use it for database loadbalancing.

I'm trying to run sql-bench against mysql-proxy, with 1 master backend en 1 slave backend. (Using the tutorial-keepalive script) Most of the tests seem to fail however:

[root@opteron sql-bench]# ./test-alter-table --host=172.16.60.153 --user=niels --password=xxxx
Testing server 'MySQL 5.0.22 log/' at 2007-08-24 9:55:15

Testing of ALTER TABLE
Testing with 1000 columns and 1000 rows in 100 steps
Got error: 'Lost connection to MySQL server during query' when connecting to DBI:mysql:database=test;host=172.16.60.153 with user: 'niels' password: 'xxxx'

From the network dumps I can see 2 possible issues:

- The client might get confused by getting an error on the QUIT command. (I think a quit should just return an OK, even though the connection is kept open between the proxy and the server. As far as the client is concerned, the connection is closed)

- A connect from the client is converted to a change user to the server. Something might be wrong here, as the next query after this fails with error 1047.

Is there any way I can debug this further ?

Thanks,

Niels