Getting empty resultset with Proxysql

[harun küçük]

Hello,

I have no idea how it can be possible but if I use haproxy there is not any problem but when I switch to proxysql application can not find existing record in database.  it is occuring every config (like fast_forward = 0 or 1  or global multiplexing true or false, and also transaction_persistent true or false). But if I set fast_forward=1 in mysql_users table , it is occuring rarely.   There are 3 node xtradb cluster behind and all requests redirected to single node .

I set mysql long_query_time=0 and activated slow query log.  and the output is like as attached file. last query getting empty result but 1 row is exists

Best Regards,

[René Cannaò]

Hi Harun,

Do you have a reproducible test case?

What I note interesting in the screenshot you attached is that rows_examined is off by one.

Thanks,

René

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[harun küçük]

Hi René,

Yes, I have been facing this problem in my staging environment.  I am using Hibernate ORM and Hicari connection pool on app side . I have a web page , when I send 20 select request to proxysql via my webpage avg 1 or 2 request getting error because of empty resultset. Maybe it is related my database configuration but if I switch to haproxy , same app can not get any error.  if you need something to check like tcpdump , log etc,  I can provide it

Thanks,

24 Mayıs 2017 Çarşamba 20:38:02 UTC+3 tarihinde René Cannaò yazdı:

To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.

[harun küçük]

Hello,

I am upgrading XtraDb Cluster to latest version , after then I will check this issue again. Also if you have any idea about root cause I can try it.

Thanks

25 Mayıs 2017 Perşembe 09:36:32 UTC+3 tarihinde harun küçük yazdı: