mysql-proxy-discuss team mailing list archive

[Erwan Ben Souiden <erwan@xxxxxxxxxxxx>]

Hi there,

I got a little problem with mysql-proxy.
Basically, when I try to create several connections via my
mysql-proxy, I have no problem until the connection where I have the
following error :
$ mysql -ulabynocle -p --host=127.0.0.1 --port=3318
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading final
connect information', system error: 0

When I check the mysql-proxy log, I have the following line :
2009-06-11 09:52:27: (debug) [network-mysqld.c:784]: error on a
connection (fd: -1 event: 0). closing client connection.

Then I try another new connection and I have no problem.
But the problem comes back then ! I guess when I have the bug, a
connection is closed then I can create a new one. This is why I
believe it works when I retry...
Besides I have no error in my /var/log/message.


My configuration :
mysql-proxy v 0.7.1 (from
http://code.launchpad.net/mysql-proxy/0.7/0.7.1/+download/mysql-proxy-0.7.1.tar.gz)
compiled with no particular option
rw-splitting.lua script has been patched thanks to the following patch
: https://code.launchpad.net/~diego-fmpwizard/mysql-proxy/bug-43424/+merge/4259

How I run mysql-proxy :
export LUA_PATH="/usr/local/mysql-proxy-0.7.1/lib/mysql-proxy/lua/?.lua"
/usr/local/mysql-proxy-0.7.1/sbin/mysql-proxy --proxy-address=:3318
--proxy-lua-script=/usr/local/mysql-proxy-0.7.1/lib/mysql-proxy/lua/rw-splitting.lua
--proxy-backend-addresses=10.0.0.42:3306
--proxy-read-only-backend-addresses=127.0.0.1:3308
--admin-address=127.0.0.1:4041 --log-file=/var/log/mysql-proxy.log
--log-level=debug --max-open-files=1024
--pid-file=/var/run/mysql-proxy.pid >> $LUALOG &


content of /usr/local/mysql-proxy-0.7.1/lib/mysql-proxy/lua/ :
$ ls /usr/local/mysql-proxy-0.7.1/lib/mysql-proxy/lua/ -al
total 480
drwxr-sr-x 3 root staff   4096 2009-06-04 16:01 .
drwxr-sr-x 4 root staff   4096 2009-06-04 12:07 ..
-rw-r--r-- 1 root staff   3763 2009-06-04 11:58 active-queries.lua
-rw-r--r-- 1 root staff   2414 2009-06-04 11:58 active-transactions.lua
-rw-r--r-- 1 root staff   8842 2009-06-04 11:58 admin-sql.lua
-rw-r--r-- 1 root staff  10799 2009-06-04 11:58 analyze-query.lua
-rw-r--r-- 1 root staff   1607 2009-06-04 11:58 auditing.lua
-rwxr-xr-x 1 root staff   1079 2009-06-04 12:07 chassis.la
-rwxr-xr-x 1 root staff  29839 2009-06-04 12:07 chassis.so
-rw-r--r-- 1 root staff   1661 2009-06-04 11:58 commit-obfuscator.lua
-rwxr-xr-x 1 root staff    948 2009-06-04 12:07 glib2.la
-rwxr-xr-x 1 root staff  13556 2009-06-04 12:07 glib2.so
-rw-r--r-- 1 root staff   5148 2009-06-04 11:58 histogram.lua
-rwxr-xr-x 1 root staff    912 2009-06-04 12:07 lfs.la
-rwxr-xr-x 1 root staff  33294 2009-06-04 12:07 lfs.so
-rw-r--r-- 1 root staff  13265 2009-06-04 11:58 load-multi.lua
-rwxr-xr-x 1 root staff    918 2009-06-04 12:07 lpeg.la
-rwxr-xr-x 1 root staff 110935 2009-06-04 12:07 lpeg.so
-rwxr-xr-x 1 root staff   1118 2009-06-04 12:07 mysql.la
-rwxr-xr-x 1 root staff 117993 2009-06-04 12:07 mysql.so
-rwxr-xr-x 1 root staff    924 2009-06-04 12:07 posix.la
-rwxr-xr-x 1 root staff  14792 2009-06-04 12:07 posix.so
drwxr-sr-x 2 root staff   4096 2009-06-04 12:37 proxy
-rw-r--r-- 1 root staff   6645 2009-06-04 11:58 ro-balance.lua
-rw-r--r-- 1 root staff   7064 2009-06-04 11:58 ro-pooling.lua
-rw-r--r-- 1 root staff  11026 2009-06-04 16:01 rw-splitting.lua
-rw-r--r-- 1 root staff  13574 2009-06-04 11:58 xtab.lua


I have no clue so any will be greatly appreciated :)
If you need more info/log or something else let me know.
And please forgive my poor english level :)

Erwan