Bug #53688 | Data of resultset some times is error when many client access simultaneity | ||
---|---|---|---|
Submitted: | 17 May 2010 4:16 | Modified: | 22 Jul 2010 9:38 |
Reporter: | wang zone | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Proxy | Severity: | S1 (Critical) |
Version: | 0.6.1 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[17 May 2010 4:16]
wang zone
[27 May 2010 9:16]
Sveta Smirnova
Thank you for the report. Please provided full lua script including reconnect part.
[4 Jun 2010 2:15]
wang zone
I have fixed this bug. Some times, the following lua script will failed. proxy.connection.backend_ndx = 2 I check it in the source code of proxy0.6.1, I get it. In function static int proxy_connection_set(lua_State *L) { ... (NULL != (send_sock = proxy_connection_pool_swap(con, backend_ndx))) { con->server = send_sock; } else { st->backend_ndx = backend_ndx; } When too many client accessing the proxy simultaneity, proxy_connection_pool_swap some times return NULL. The statement , st->backend_ndx = backend_ndx; isn't perfect result, especially in the condition 4 " 4. In proxy lua, if I can't get the data in backend A, I will send the same sql to backend B by returning a proxy.PROXY_SEND_QUERY to mysql-proxy to wait the bakend B result. some rand key value neither in backend A nor in backend B."
[22 Jun 2010 9:38]
Sveta Smirnova
Thank you for the feedback. When you say "I have fixed this bug." does this mean you fixed lua script which you wrote and use?
[22 Jul 2010 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".