Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

QAN explain and tables tabs not working after removing MySQL metrics agent

Description

If we use only query analytics, by disabling MySQL metrics agent, the Explain and Tables tabs stop working, with the following message:

Couldn't resolve dsn, as there should be only one exporter

See screenshots attached, for before and after.

 

Steps to reproduce:

  1. Add all services

    1. pmm-admin add mysql ...

  2. give it some time for it to collect queries correctly

  3. test that Explain and Tables tabs are working correctly in QAN dashboard

  4. Remove MySQL metrics exporter/agent

    1. pmm-admin list

    2. get agent ID for mysql metrics

    3. pmm-admin inventory remove agent /agent_id/68dd87c1-4246-43ef-bb6b-5f524c1089d5

  5. test Explain and Tables tabs again, to find errors as shown in attached screenshots

 

Suggested fix:

Now we use mysqld_exporter agent as single source of credentials, I suggest to use qan agent as primary source and then if it doesn't exist check other agent types related to current service type.

How to test

None

How to document

None

AFFECTED CS IDs

275129

Attachments

4

Smart Checklist

Activity

Show:

Jira Bot July 9, 2020 at 7:55 PM

To:
CC:

Hi, I'm jira-bot, Percona's Jira automation tool. I've detected that someone from
Percona has made an edit to the Summary field of an issue that you reported.

I'm not sentient (yet) so I'm not sure whether the person fixed a typo, changed
a few words, or completely rewrote the text. In any case, it is Percona Engineering's
intention to make the Summary and Description of an issue as accurate as possible
so that we're fixing the actual problem you're encountering, and to avoid
misunderstandings about symptoms and causes.

If the current Summary does not accurately reflect the problem you are reporting,
or if you feel the change was otherwise inappropriate in some way, please add a
new comment explaining things and we'll address it as soon as we can.

This message will be added only once per issue, regardless of how many times
the Summary is edited.

message-code:summary-edited

Jiří Čtvrtka June 30, 2020 at 7:25 AM

Done

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Fix versions

Story Points

Sprint

Smart Checklist

Created April 20, 2020 at 10:58 PM
Updated November 13, 2024 at 8:43 AM
Resolved July 1, 2020 at 8:35 AM