Not the answer you need?
Register and ask your own question!

Proxysql2 seems to truncate query

DavidDDavidD ContributorCurrent User Role Participant
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

Comments

  • DavidDDavidD Contributor Current User Role Participant
    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.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Mentor
    I'll share with the team, thanks for the report.
    Is this ProxySQL you downloaded from the Percona repo?
  • DavidDDavidD Contributor Current User Role Participant
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.