# Unable to show Mysql Summary at PMM Query Analytic

**URL:** <https://forums.percona.com/t/unable-to-show-mysql-summary-at-pmm-query-analytic/5983>\
**Category:** PMM 1.x\
**Created:** [November 7, 2017, 5:38am UTC](https://forums.percona.com/t/unable-to-show-mysql-summary-at-pmm-query-analytic/5983 "2017-11-07T05:38:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![adaam](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/adaam/32/1191_2.png) [@adaam](https://forums.percona.com/u/adaam)\
**Post date:** [November 7, 2017, 5:38am UTC](https://forums.percona.com/t/unable-to-show-mysql-summary-at-pmm-query-analytic/5983/1 "2017-11-07T05:38:21Z")

</div>

PMM-Client version: 1.4.1  
PMM-Server version: 1.4.1  
Percona-Toolkit version: 3.0.4

The System Summary can show correct information, but at MySQL Summary section, it only show “exit status 1”

Agent log as below

[root@db8888 ~]# tail /var/log/pmm-mysql-queries-0.log

# PID: 30598

# API: 8.8.8.8/qan-api

# UUID: 77e9fb0008fd405e5050058484e73ead

2017/11/07 18:29:48.750261 main.go:163: Starting agent…

2017/11/07 18:29:48.755488 main.go:331: Agent is ready

2017/11/07 18:29:48.757690 main.go:204: API is ready

2017/11/07 18:30:23.439962 ERROR agent exit status 1

2017/11/07 18:30:23.440079 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘exit status 1’ Id:efdad214-59cd-4282-6708-901fdae0e045]

2017/11/07 18:53:59.509491 ERROR agent exit status 1

2017/11/07 18:53:59.509626 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘exit status 1’ Id:a0c97888-a983-4024-7b17-ec878ff838ed]

But direct execute pt-mysql-summary at target machine with user, password, host, port, it can show information correctly.

I try to trace code, not sure i’m in correct path, but it seem not pass user, password, host, port to pt-mysql-summary  
[https://github.com/percona/qan-agent/blob/a0904c565ace33460923698b1cc39c5b33cc8128/agent/agent.go#L694](https://github.com/percona/qan-agent/blob/a0904c565ace33460923698b1cc39c5b33cc8128/agent/agent.go#L694)

---

<div class="post-metadata">

**Author:** ![Cogitate](https://avatars.discourse-cdn.com/v4/letter/c/94ad74/32.png) [@Cogitate](https://forums.percona.com/u/Cogitate)\
**Post date:** [November 7, 2017, 11:41pm UTC](https://forums.percona.com/t/unable-to-show-mysql-summary-at-pmm-query-analytic/5983/2 "2017-11-07T23:41:22Z")

</div>

I’m using the same versions on a fresh install and having the same issue (exit status 1). The client is running Ubuntu 16.04.3 LTS.

pmm-admin check-network looks good and the MySQL dashboards in grafana are working, but /qan/sys-summary?var-host=myhost throws exit status 1 for the MySQL summary section. The system summary works.

---

<div class="post-metadata">

**Author:** ![Edward\_Zeng](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/edward_zeng/32/1197_2.png) [@Edward\_Zeng](https://forums.percona.com/u/Edward_Zeng)\
**Post date:** [November 15, 2017, 1:56am UTC](https://forums.percona.com/t/unable-to-show-mysql-summary-at-pmm-query-analytic/5983/3 "2017-11-15T01:56:48Z")

</div>

Same situation here in Ubuntu 14.04.5.