Bug #31735 Proxy with R/W splitting fails on a pool of writes
Submitted: 21 Oct 2007 11:31
Reporter: Giuseppe Maxia Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Proxy: Scripts Severity:S2 (Serious)
Version:0.6.1 OS:Any (rev 265)
Assigned to: Assigned Account CPU Architecture:Any
Tags: proxy, replication, rw-splitting

[21 Oct 2007 11:31] Giuseppe Maxia
Description:
Running MySQL Proxy with the r/w splitting lua script, the Proxy loses connection to the backend if at least 6 connections are used in sequence to write a record.

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

How to repeat:
1) Start the Proxy as follows (change host and port as needed)

  /usr/local/sbin/mysql-proxy 
    --proxy-lua-script=rw-splitting.lua \
    --proxy-backend-addresses=127.0.0.1:16045 \  
    --proxy-read-only-backend-addresses=127.0.0.1:16046

2) Use the attached Perl script, which opens 10 connections, and then 
   uses each of them in sequence to write a record.
[21 Oct 2007 11:33] Giuseppe Maxia
script ans strace for bug 31735

Attachment: bug31735.zip (application/zip, text), 14.90 KiB.