QAN fails on explain

Percona Monitoring and Management (PMM) PMM 2.x
1

Hi, we have a situation where some queries fail when requesting and explain of them in QAN.

The errors can be categorized in two groups:

Error 1046: No database selected

Example of failing query:

select
  *
from
  table
where
  arbitrary_no = '11111111'

And

Error 1064: 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 '‘1111111 …’ at line 1

For some queries like this: (with a very long in clause)

SELECT
  id
FROM
  table
WHERE id in(
    '5522555',
    '2224452',
    '3444434',
    '5544223',
    '5653343',
    '111 ...

We are currently running PMM 2.15.1.

How can we get those queries having their explain working on QAN?

2

Hi @dopessoa!

Can you check if these reports help you with these questions?

https://jira.percona.com/browse/PMM-4832
https://jira.percona.com/browse/PMM-1899

Best,
Agustín.

1 Like