Error starting query-history-all-5.1

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error starting query-history-all-5.1

    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.

  • #2
    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.


    • #3
      The bug that prevented the service from starting has been fixed. https://jira.percona.com/browse/PCT-320

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


      • #4
        You probably need to restart the agent to re-initialize the Query Analytics service. This worked for me:
        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.


        • #5
          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