mysql proxy - every other query

[Nathan Stratton]

I tried to use the latest SVN mysql proxy and as soon as I sent a query to it it seg fulted, so I went to an older release (0.6.1) and now have something that sorta works.

The first 10 queries work fine, but then started with 11 every other query works (see below).

mysql-proxy --proxy-address=10.11.0.101:3306 --proxy-read-only-backend-addresses=10.11.0.101:4040 --proxy-backend-addresses=10.10.0.101:3306 --proxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua

[root@netmon libexec]# mysql -pbenzOate -h 10.11.0.101 -D LERG -e "select count(*) from LERGDATE;" -P 4040
+----------+
| count(*) |
+----------+
|        1 | 
+----------+
[root@netmon libexec]# mysql -pbenzOate -h 10.11.0.101 -D LERG -e "select count(*) from LERGDATE;" -P 4040
+----------+
| count(*) |
+----------+
|        1 | 
+----------+

....

[root@netmon libexec]# mysql -pbenzOate -h 10.11.0.101 -D LERG -e "select count(*) from LERGDATE;"
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading final connect information', system error: 0
[root@netmon libexec]#

-Nathan



Edited 1 time(s). Last edit at 03/28/2008 12:53AM by Jan Kneschke.