Bug #57655 error on a connection (fd: -1 event: 0). closing client connection.

• Submitted: 22 Oct 2010 10:43
• Modified: 1 Dec 2010 18:57
• Reporter: lynn chai
• Status: Duplicate
• Category: MySQL Proxy
• Severity: S1 (Critical)
• Version: 0.8.1
• OS: Linux (Linux version 2.6.18-164.el5)
• CPU Architecture: Any
• Tags: close, Connection, no backend

[22 Oct 2010 10:43] lynn chai

Description:
I use sysbench tool to test my rw-split.lua. 
My sysbench command is :
sysbench  --test=oltp --oltp-test-mode=simple --oltp-table-name=testib50m --oltp-table-size=50000000 --db-driver=mysql --mysql-host=10.10.85.17 --mysql-port=4040 --mysql-user=sbtest --mysql-password=sbtest --mysql-db=testdb  --num-threads=1 --max-requests=10 --debug=on run
When the --num-threads more than 1, I will always see mysql-proxy will output:
2010-10-22 16:17:58: (debug) [network-mysqld.c:937]: error on a connection (fd: -1 event: 0). closing client connection.
2010-10-22 16:17:58: (critical) proxy-plugin.c.1122: I have no server backend, closing connection
2010-10-22 16:17:58: (critical) network-mysqld.c.1413: plugin_call(CON_STATE_READ_QUERY) failed
I don't know how to deal with it.  Can somebody tell me why?  Thanx !

How to repeat:
rw-split.lua
I will attach it later.

sysbench command
sysbench  --test=oltp --oltp-test-mode=simple --oltp-table-name=testib50m --oltp-table-size=50000000 --db-driver=mysql --mysql-host=10.10.85.17 --mysql-port=4040 --mysql-user=sbtest --mysql-password=sbtest --mysql-db=testdb  --num-threads=1 --max-requests=10 --debug=on run

you can change the --num-threads for test.

[22 Oct 2010 10:48] lynn chai

the rw-split.lua is used for my read and write split.

Attachment: rw-split.lua (application/octet-stream, text), 7.55 KiB.

[24 Nov 2010 14:02] Sveta Smirnova

Thank you for the report.

I can not repeat described behavior. Please send us command line you use to start MySQL Proxy.

[30 Nov 2010 16:02] david nick

similer as mine

I find that the error occured after n*2 querys.

local min_idle_connections = n 

in lua script

[30 Nov 2010 16:55] Sveta Smirnova

David,

thank you for the feedback. How do you start MySQL Proxy? Please send us command line you use.

[1 Dec 2010 2:40] david nick

I submit a bug here:

http://bugs.mysql.com/bug.php?id=58591

there is all my config

[1 Dec 2010 18:57] Sveta Smirnova

Thank you for the feedback.

Instruction for how to repeat in bug #58591 is complete and leads to error described, so I verified that bug and closing this one as duplicate.