| 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: | |
| 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:33]
Giuseppe Maxia
script ans strace for bug 31735
Attachment: bug31735.zip (application/zip, text), 14.90 KiB.
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.