error message with keepalive script
Posted by:
Amr Hamdy
Date: August 27, 2007 05:39PM
Hello,
I start mysql-proxy as follows;
mysql-proxy --proxy-address=:3306 --proxy-backend-addresses=192.168.99.244:3306 --proxy-read-only-backend-addresses=192.168.99.243:3306 --proxy-lua-script=examples/tutorial-keepalive.lua
Then I establish a connection to the proxy froma remote host;
mysql -h 192.168.99.222 -P3306 -uroot -ppassword
the connection got established successfully;
then I run a simple query "show databases;"
I get errors and the proxy says the following;
network-mysqld-proxy.c.3420: (connect_server) examples/tutorial-keepalive.lua:65: attempt to get length of field 'servers' (a nil value)
(read_query) examples/tutorial-keepalive.lua:166: attempt to get length of field 'servers' (a nil value)
network-mysqld-proxy.c.2815: I have no server backend, closing connection
network-mysqld.c.1161: plugin_call(CON_STATE_READ_QUERY) failed
network-mysqld-proxy.c.3722: (disconnect_client) examples/tutorial-keepalive.lua:257: attempt to get length of field 'servers' (a nil value)
I don't get such errors when I use the examples/tutorial-basic.lua script and queries could be run nicely .. but all queries go to the main backend not to the read-only backend at all ..
with the keepalive script when I establish the connection I could see that it established a connection to the main backend only and not to the read-only backend too ...
Subject
Views
Written By
Posted
error message with keepalive script
6830
August 27, 2007 05:39PM
2771
August 28, 2007 03:53AM
2677
August 28, 2007 04:37AM
2645
August 28, 2007 07:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.