Proxysql2 seems to truncate query

[DavidD]

Hello,

I upgraded from proxysql 1.4.14 to 2.0.7 without problem at start.

But Now I see MySQL errors in my java application (using com.mysql.jdbc.Driver (v. 5.1))

Sometimes queries are truncated to 80 characters, especially on DELETE and UPDATE queries.
ex

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near
'UPDATE RB_OBJ_DATA SET INTG3=NULL WHERE OBJ_ID=111005248;UPDATE RB_OBJ_DATA SET ' at line 1

Have you any idea ?

I attached my global variables.

Thanks

David

global.txt (14.7 KB)

[DavidD]

Hi all,
I confirm: I restore my VM with proxysql 1.4.14 and I have no errors.
So it seems there is a bug with version 2.
David

[lorraine.pocklington]

I’ll share with the team, thanks for the report.
Is this ProxySQL you downloaded from the Percona repo?

[DavidD]

yes, from the repository, then

$ sudo apt install proxysql2

I still have one server with this configuration, I can put it alive if you want more informations.
David