Bug #61474 MySQL Proxy is not correctly passing the function CALL when used with MySQL 5.5

• Submitted: 10 Jun 2011 8:48
• Modified: 16 Nov 2011 13:50
• Reporter: Marco Tusa
• Status: Closed
• Category: MySQL Proxy: Core
• Severity: S3 (Non-critical)
• Version: 0.8.0
• OS: Linux (RH 5)
• CPU Architecture: Any
• Tags: functions, proxy

[10 Jun 2011 8:48] Marco Tusa

Description:
After an upgrade from 5.1. to 5.5. we have seen issues to correctly execute functions CALL through the MySQL Proxy.

The problem is probably due to the MySQL protocol changes in 5.5 for functions call.

Configuration.
[mysql-proxy]
log-file = /var/log/mysql-proxy/mysql-proxy.log
log-level = debug
proxy-backend-addresses = 172.20.30.50:3306,172.20.30.51:3306
proxy-lau-script = /usr/local/mysql-proxy/cpool3.lua
[root@dbpr1 ~]#

How to repeat:
Use mysql proxy 0.8.0
use MySQL 5.5.12
create a function in  5.5 and execute the CALL using Proxy.

[16 Jul 2011 13:20] Valeriy Kravchuk

Please, check if the same problem happens with a newer version of proxy, 0.9.0.

[16 Jul 2011 14:35] Peter Laursen

@Valeriy .. as far as I can see the latst (publicly available) release is 0.8.1 .. and it is an ALPHA. 

http://dev.mysql.com/downloads/mysql-proxy/
(and why does not the page link to lastest stable (I think 0.71) ?)

(Peter)

[16 Jul 2011 14:57] Peter Laursen

And why does this page http://www.mysql.com/downloads/ not list MySQL Proxy at all any more?

Are you discontinuing it?

[17 Jul 2011 9:39] Valeriy Kravchuk

I am not in a proper position to comment on why something is not present somewhere at mysql.com, or, even more, what Oracle plans are in regards to mysql-proxy.

I just noted the bug report, got the latest code from Launchpad:

bzr branch lp:mysql-proxy

built it on Mac and tested according to my understanding of this bug report. Got no problems. Hence my request to bug reporter to do the same. Maybe I've got something wrong...

[17 Aug 2011 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".

[18 Aug 2011 20:41] Chris Calender

Proxy 0.8.2 was just released, and a majority of the fixes were focused on adding the protocol changes of MySQL 5.5, so this would be worth re-testing now.

[24 Aug 2011 11:06] Valeriy Kravchuk

Please, check with 0.8.2.

[24 Sep 2011 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".

[25 Sep 2011 22:45] Marco Tusa

do you have any update on the fix?

[15 Oct 2011 17:18] Valeriy Kravchuk

Do you still have the same problem with version 0.8.2?

[16 Nov 2011 7: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".

[16 Nov 2011 13:50] Marco Tusa

I did test and fix in 0.8.2 seems fine 
we can close the bug as resolve