Re: Mysql proxy 0.70 issues
Hi,
thanks for the answer.
So, the problem about the "rlimit" is gone. Thanks.
In the meantime, I tried a lot other solutions.
1) I reinstalled all on a Debian 5 standard solution, with distributed binaries (mysql 5.0.99, mysql proxy 0.6.1 etc) by standard repository.
Everything works fine, but not the r/w splitting (elsewere mentioned here in the forum as known bug. So, I must work with 0.7.x.
2) I reinstalled again on a Debian 5 with mysql-proxy 0.7.2 and standard mysql server. This time was harder, but at last works. But... If I try a lua script here you are...
-----------------------------------------------
2009-05-18 16:05:27: (critical) proxy-plugin.c:1389: (connect_server) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:76: attempt to get length of field 'backends' (a nil value)
2009-05-18 16:05:27: (critical) (read_query) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:218: bad argument #1 to 'ipairs' (table expected, got userdata)
2009-05-18 16:05:27: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2009-05-18 16:05:27: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2009-05-18 16:05:27: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
2009-05-18 16:05:27: (critical) proxy-plugin.c:1389: (connect_server) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:76: attempt to get length of field 'backends' (a nil value)
2009-05-18 16:05:27: (critical) (read_query) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:218: bad argument #1 to 'ipairs' (table expected, got userdata)
2009-05-18 16:05:27: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2009-05-18 16:05:27: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2009-05-18 16:05:27: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
2009-05-18 16:05:27: (critical) proxy-plugin.c:1389: (connect_server) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:76: attempt to get length of field 'backends' (a nil value)
2009-05-18 16:05:28: (critical) (read_query) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:218: bad argument #1 to 'ipairs' (table expected, got userdata)
2009-05-18 16:05:28: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2009-05-18 16:05:28: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2009-05-18 16:05:28: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
2009-05-18 16:05:28: (critical) proxy-plugin.c:1389: (connect_server) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:76: attempt to get length of field 'backends' (a nil value)
2009-05-18 16:05:28: (critical) (read_query) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:218: bad argument #1 to 'ipairs' (table expected, got userdata)
2009-05-18 16:05:28: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2009-05-18 16:05:28: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2009-05-18 16:05:28: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
--------------------------------------------
This happend on all .lua scipts. The installed version is 1.5.4.
So I'm again confused.
Regards,
JS