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 Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Proxy Severity:S1 (Critical)
Version:0.8.1 OS:Linux (Linux version 2.6.18-164.el5)
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.