Bug #51951 mysql-proxy exit with logs "I have no server backend, closing connection"
Submitted: 11 Mar 2010 13:16 Modified: 17 Mar 2010 6:45
Reporter: L mx Email Updates:
Status: Verified Impact on me:
Category:MySQL Proxy Severity:S1 (Critical)
Version:6.0, 0.8.0 OS:Linux
Assigned to: Assigned Account CPU Architecture:Any

[11 Mar 2010 13:16] L mx
Hi,I'm testing Mysql proxy.6.0 with rw-splitting.lua script.The process ended when I did a big amount of inserts and selects, especially when the load of  database is heavy.I got some debug log as follow from time to time:

network-mysqld-proxy.c.2927: I have no server backend, closing connection
network-mysqld.c.1122: plugin_call(CON_STATE_READ_QUERY) failed

eventually,It puts:
network-mysqld.c.564: write() failed: Broken pipe
network-mysqld.c.1200: network_mysqld_write(CON_STATE_SEND_QUERY) returned an error

and the process is ended.

Does anyone meet the problem like this ?
How should I do to solve it?


How to repeat:
It does'n come out in certain case.But It come out most probably when the load of the database is heavy(when i increase the amount of inserts and selects) or the network condition is poor.I'm not sure but I think it may get some something to do with the connection pool of the mysql-proxy.
[15 Mar 2010 7:17] Sveta Smirnova
Thank you for the report.

Verified as described. To repeat start Proxy with 2 backends, then run sysbench oltp test.
[15 Mar 2010 7:19] Sveta Smirnova
In my case Proxy doesn't die, just prints errors "I have no server backend, closing connection ..."
[17 Mar 2010 6:45] L mx
But how can I fix the problem?
[5 Jul 2010 4:59] yang ouyang
we met this bug too, so anybody can help us to solve this problem?