# Error starting query-history-all-5.1

**URL:** <https://forums.percona.com/t/error-starting-query-history-all-5-1/3203>\
**Category:** Percona Cloud Tools\
**Created:** [January 14, 2014, 7:49pm UTC](https://forums.percona.com/t/error-starting-query-history-all-5-1/3203 "2014-01-14T19:49:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ResHippie](https://avatars.discourse-cdn.com/v4/letter/r/ecd19e/32.png) [@ResHippie](https://forums.percona.com/u/ResHippie)\
**Post date:** [January 14, 2014, 7:49pm UTC](https://forums.percona.com/t/error-starting-query-history-all-5-1/3203/1 "2014-01-14T19:49:22Z")

</div>

Error starting query-history-all-5.1, check /var/lib/pt-agent/logs/start-stop.log and /var/lib/pt-agent/logs/query-history-all-5.1.run

I’m getting this as my status on both of the servers that I have set up.

There is nothing in the .log file and the .run file just has a timestamp from it first tried to run, which was over an hour ago. I’ve confirmed that the user the agent/my.cnf file has permission to access mysql. The only command from /var/lib/pt-agent/services/start-query-history-all-5.1 that couldn’t be run was SET GLOBAL slow\_query\_log\_use\_global\_control=‘all’  
ERROR 1193 (HY000): Unknown system variable ‘slow\_query\_log\_use\_global\_control’

I’m running Server version: 5.1.61-rel13.2-log (Percona Server (GPL), 13.2, Revision 431) on both servers.

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [January 16, 2014, 8:32am UTC](https://forums.percona.com/t/error-starting-query-history-all-5-1/3203/2 "2014-01-16T08:32:00Z")

</div>

Yes, we are already aware of a bug that brakes Query Analytics service for Percona Server 5.1. The bug is being worked on. I will try to update here once it’s fixed.

---

<div class="post-metadata">

**Author:** ![ResHippie](https://avatars.discourse-cdn.com/v4/letter/r/ecd19e/32.png) [@ResHippie](https://forums.percona.com/u/ResHippie)\
**Post date:** [January 17, 2014, 5:17pm UTC](https://forums.percona.com/t/error-starting-query-history-all-5-1/3203/3 "2014-01-17T17:17:07Z")

</div>

The bug that prevented the service from starting has been fixed. [url][Log in - Percona JIRA](https://jira.percona.com/browse/PCT-320%5B/url%5D)

I still don’t have any data on my graphs, though.

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [January 18, 2014, 12:13pm UTC](https://forums.percona.com/t/error-starting-query-history-all-5-1/3203/4 "2014-01-18T12:13:11Z")

</div>

You probably need to restart the agent to re-initialize the Query Analytics service. This worked for me:

```auto
pt-agent --stop
pt-agent --daemonize

```

After a while, pt-agent --status shows “INFO query-history-all-5.1 is running” and also crontab -l shows two pt-agent entries.

---

<div class="post-metadata">

**Author:** ![reallyimran](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/reallyimran/32/990_2.png) [@reallyimran](https://forums.percona.com/u/reallyimran)\
**Post date:** [January 20, 2014, 9:22pm UTC](https://forums.percona.com/t/error-starting-query-history-all-5-1/3203/5 "2014-01-20T21:22:51Z")

</div>

I tried this several times, but it didn’t help . I’ve been trying a day + leaving it running, and alternatively trying to run it manually a few times. No go ☹