# QAN agent stops working after MySQL server restart

**URL:** <https://forums.percona.com/t/qan-agent-stops-working-after-mysql-server-restart/5325>\
**Category:** PMM 1.x\
**Created:** [December 28, 2016, 8:06am UTC](https://forums.percona.com/t/qan-agent-stops-working-after-mysql-server-restart/5325 "2016-12-28T08:06:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gleb\_Lesnikov](https://avatars.discourse-cdn.com/v4/letter/g/b38774/32.png) [@Gleb\_Lesnikov](https://forums.percona.com/u/Gleb_Lesnikov)\
**Post date:** [December 28, 2016, 8:06am UTC](https://forums.percona.com/t/qan-agent-stops-working-after-mysql-server-restart/5325/1 "2016-12-28T08:06:44Z")

</div>

Hi percona!  
It seems that after mysql server restart qan-agent struggles with reconnecting back to mysql.

In docker container: WARN 2016/12/28 13:14:49 ws.go:90: [Agent.Cmd] agent\_id=8 0.0.9 [http://](http://fr-db-3/)hostname Failed to start: Version: recv timeout  
In agent log:  
016/12/24 20:51:39.259539 WARNING agent Lost connection to API  
2016/12/24 20:51:49.394491 WARNING mrms-monitor Cannot connect to MySQL _ **:** _@unix(/var/lib/mysql/mysql.sock): connect: no such file or directory: /var/lib/mysql/mysql.sock  
2016/12/24 20:52:00.000747 WARNING qan-interval Cannot connect to MySQL _ **:** _@unix(/var/lib/mysql/mysql.sock): connect: no such file or directory: /var/lib/mysql/mysql.sock  
2016/12/24 20:52:00.267222 WARNING agent ws error: EOF  
2016/12/24 20:52:00.267296 WARNING agent Lost connection to API  
2016/12/24 20:52:23.274767 WARNING agent ws error: EOF  
2016/12/24 20:52:23.274827 WARNING agent Lost connection to API

at 20:51 there was a mysql server restart.  
The queries still show up in qan web interface after restart, but EXPLAIN and show create table etc don’t work as qan-api can’t connect back to the pmm-client.  
1.0.7 both client and server.

Thanks!

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [December 28, 2016, 9:12am UTC](https://forums.percona.com/t/qan-agent-stops-working-after-mysql-server-restart/5325/2 "2016-12-28T09:12:48Z")

</div>

Hi Gleb,

Does restarting the client helps ?

pmm-admin restart mysql:queries

If it is repeatable issue for you can you help us by reporting the Bug: [url][https://jira.percona.com/projects/PMM/issues/?filter=allopenissues[/url]](https://jira.percona.com/projects/PMM/issues/?filter=allopenissues%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [December 29, 2016, 8:59am UTC](https://forums.percona.com/t/qan-agent-stops-working-after-mysql-server-restart/5325/3 "2016-12-29T08:59:38Z")

</div>

Hi Gleb,

can you wait for 5 minutes after server boot and check if service still down?  
command for check - “pmm-admin list” or “pmm-admin check-network”

---

<div class="post-metadata">

**Author:** ![Gleb\_Lesnikov](https://avatars.discourse-cdn.com/v4/letter/g/b38774/32.png) [@Gleb\_Lesnikov](https://forums.percona.com/u/Gleb_Lesnikov)\
**Post date:** [January 17, 2017, 9:01am UTC](https://forums.percona.com/t/qan-agent-stops-working-after-mysql-server-restart/5325/4 "2017-01-17T09:01:09Z")

</div>

Hello! Yes, restarting pmm-client helps.  
Yeah, it is a repeatable issue, I will open the Bug.

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [January 17, 2017, 9:29am UTC](https://forums.percona.com/t/qan-agent-stops-working-after-mysql-server-restart/5325/5 "2017-01-17T09:29:05Z")

</div>

Hi Gleb,

can you wait for 5 minutes after server boot and check if service still down?