-
Notifications
You must be signed in to change notification settings - Fork 974
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Icinga2 -> ProxySQL -> MariaDB/Galera: MySQL_Session.cpp:3689 [ERROR] Unable to parse query #1279
Comments
Hi @xenuser . a) ProxySQL doesn't recognize b) Please wait 1.4.4 : I will develop a workaround for this issue: disable multiplexing for c) if |
@renecannao Thanks for the fast reply and also for your awesome work on ProxySQL! a) Thanks for the explanation. |
@xenuser : you are welcome! ProxySQL in branch 1.4.4 is now able to correctly handle |
Wow, great!! Thanks a lot. |
Short issue description
ProxySQL throws an error on some of the connections coming from a specific DB client. As a consequence, some DB connections are not established.
Setup description
I configured the following setup:
Host A: Icinga 2.7.2, ProxySQL 1.4.4 (SLES 12 SP2)
Hosts B, C, D: MariaDB 10.2.9 + Galera (RHEL 7.3)
Icinga2 is connecting to localhost:6033 (ProxySQL) which then balances/forwards queries to Hosts B, C D.
Long issue description
When switching from "Icinga2 goes directly to MariaDB on Host B" to "Icinga2 connects to ProxySQL on localhost instead", some of the connections seem to be not established.
Looking at journalctl -f, I see many entries with the following error:
When running Icinga2 against ProxySQL, only some of the DB connections reach the three MariaDB/Galera nodes. As a consequence, Icinga2 starts spooling actions which should be runned against a DB. And, in addition, Icinga2 is not working as expected.
Workaround I tried
A co-worker of mine discovered the config variable "mysql-query_digests" which could affect the observed behavior. Our hope was that ProxySQL would stop parsing queries and act as a stupid proxy only until a solution could be found. After activating this setting with...
... the errors were gone. However, still only few SQL queries went through.
Expected behavior
ProxySQL does not throw an error and makes sure all connections/queries will be handled successfully.
Questions
(a)
In your eyes, is the query I posted above incorrect or is this behavior related to an existing GitHub issue regarding that ProxySQL appends a ";" or something like that?
(b) Is there something I can do to workaround on this problem so I can continue using ProxySQL?
(c) Can you please explain what mysql-query_digests does and how deactivating this setting changes the behavior of ProxySQL?
The text was updated successfully, but these errors were encountered: