QAN slowlog agent is not visible on Inventory page
Description
How to test
How to document
Attachments
Smart Checklist
Activity

Andrii Skomorokhov April 27, 2019 at 9:15 AMEdited
Setup
{{ [root@b6fe1318afaf /]# pmm-admin add mysql --username=root --password=secret --use-slowlog ps:3306 MySQLSlowLog }}
{{ MySQL Service added.}}
{{ Service ID : /service_id/77981ba9-be67-4b06-8f96-fd1b3ef1cdcb}}
{{ Service name: MySQLSlowLog}}
{{ [root@b6fe1318afaf /]# pmm-admin add mysql --username=root --password=secret --use-perfschema ps:3306 MySQLPerfSchema }}
{{ MySQL Service added.}}
{{ Service ID : /service_id/39686c83-2cbe-4b71-b3c5-067e4c15f289}}
{{ Service name: MySQLPerfSchema}}
Before (no qan-mysql-slowlog-agent)
{{ [root@b6fe1318afaf /]# pmm-admin list}}
{{ Service type Service name Address and port Service ID}}
{{ MySQL MySQLPerfSchema ps:3306 /service_id/39686c83-2cbe-4b71-b3c5-067e4c15f289 }}
{{ MySQL MySQLSlowLog ps:3306 /service_id/77981ba9-be67-4b06-8f96-fd1b3ef1cdcb}}Agent type Status Agent ID Service ID
{{ pmm-agent connected /agent_id/f7fff33a-f0f5-4c19-bae3-7c2ca4065abc}}
{{ node_exporter running /agent_id/a919b532-ee7a-4657-bbc4-32d95ba06c76}}
{{ mysqld_exporter running /agent_id/247436c0-9d4c-470e-ae5f-9878e0a5b5ae /service_id/77981ba9-be67-4b06-8f96-fd1b3ef1cdcb }}
{{ mysqld_exporter running /agent_id/81e2681b-9dba-4e71-be92-5da5e682b16c /service_id/39686c83-2cbe-4b71-b3c5-067e4c15f289 }}
{{ qan-mysql-perfschema-agent waiting /agent_id/12ec576b-b19f-4853-aab4-e4bf5b9eeccc /service_id/39686c83-2cbe-4b71-b3c5-067e4c15f289 }}
Fixed version (shows qan-mysql-slowlog-agent)
[root@b6fe1318afaf /]# pmm-admin list
{{ Service type Service name Address and port Service ID}}
{{ MySQL MySQLPerfSchema ps:3306 /service_id/39686c83-2cbe-4b71-b3c5-067e4c15f289}}
{{ MySQL MySQLSlowLog ps:3306 /service_id/77981ba9-be67-4b06-8f96-fd1b3ef1cdcb}}Agent type Status Agent ID Service ID
{{ pmm-agent connected /agent_id/f7fff33a-f0f5-4c19-bae3-7c2ca4065abc }}
{{ node_exporter running /agent_id/a919b532-ee7a-4657-bbc4-32d95ba06c76 }}
{{ mysqld_exporter running /agent_id/247436c0-9d4c-470e-ae5f-9878e0a5b5ae /service_id/77981ba9-be67-4b06-8f96-fd1b3ef1cdcb}}
{{ mysqld_exporter running /agent_id/81e2681b-9dba-4e71-be92-5da5e682b16c /service_id/39686c83-2cbe-4b71-b3c5-067e4c15f289}}
{{ qan-mysql-perfschema-agent waiting /agent_id/12ec576b-b19f-4853-aab4-e4bf5b9eeccc /service_id/39686c83-2cbe-4b71-b3c5-067e4c15f289}}
{{ qan-mysql-slowlog-agent starting /agent_id/ded6f81c-a0d7-4907-a932-5163803ae989 /service_id/77981ba9-be67-4b06-8f96-fd1b3ef1cdcb}}

Roma Novikov April 26, 2019 at 1:06 PM
Inventory UI page will be fixed in
Details
Assignee
UnassignedUnassignedReporter
Nailya KutlubaevaNailya KutlubaevaPriority
MediumComponents
Labels
Fix versions
Affects versions
Details
Details
Assignee
Reporter

Priority
Components
Labels
Fix versions
Affects versions
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist

STR:
Run PMM2 server
Install pmm2-client from testing repository
Setup pmm-agent and add MySQL to monitpring
Open Inventory Agents page
Given result: QAN slowlog agent is not displayed (see screenshot)
Expected result QAN slowlog agent is displayed