# Proxysql2 seems to truncate query

**URL:** <https://forums.percona.com/t/proxysql2-seems-to-truncate-query/7326>\
**Category:** ProxySQL\
**Created:** [December 3, 2019, 3:08am UTC](https://forums.percona.com/t/proxysql2-seems-to-truncate-query/7326 "2019-12-03T03:08:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DavidD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/davidd/32/1244_2.png) [@DavidD](https://forums.percona.com/u/DavidD)\
**Post date:** [December 3, 2019, 3:08am UTC](https://forums.percona.com/t/proxysql2-seems-to-truncate-query/7326/1 "2019-12-03T03:08:35Z")

</div>

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

```auto
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](https://forums.percona.com/uploads/short-url/e3ru353HVXvgZiUcYFUhTWhJkwC.txt) (14.7 KB)

---

<div class="post-metadata">

**Author:** ![DavidD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/davidd/32/1244_2.png) [@DavidD](https://forums.percona.com/u/DavidD)\
**Post date:** [December 3, 2019, 4:55am UTC](https://forums.percona.com/t/proxysql2-seems-to-truncate-query/7326/2 "2019-12-03T04:55:02Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [December 3, 2019, 5:06am UTC](https://forums.percona.com/t/proxysql2-seems-to-truncate-query/7326/3 "2019-12-03T05:06:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![DavidD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/davidd/32/1244_2.png) [@DavidD](https://forums.percona.com/u/DavidD)\
**Post date:** [December 3, 2019, 9:16am UTC](https://forums.percona.com/t/proxysql2-seems-to-truncate-query/7326/4 "2019-12-03T09:16:33Z")

</div>

yes, from the repository, then

```auto
$ sudo apt install proxysql2

```

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