Error starting query-history-all-5.1/ Unknown system variable 'log_slow_admin_statements'

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error starting query-history-all-5.1/ Unknown system variable 'log_slow_admin_statements'

    I can't seem to get any queries sent from my server. Here are error entries from my log:
    2014-02-10 11:39:11 2014-02-10 11:52:53 Warning 2390 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
    2014-02-10 11:39:11 2014-02-10 11:52:50 Info 7000 start-query-history-all-5.1 Exit: 1
    2014-02-10 11:39:11 2014-02-10 11:52:50 Error 7000 start-query-history-all-5.1 Error executing SET GLOBAL log_slow_admin_statements=OFF: DBD::mysql::db do failed: Unknown system variable 'log_slow_admin_statements' at /usr/bin/pt-agent line 7340.
    Also neither /var/lib/pt-agent/logs/start-stop.log nor /var/lib/pt-agent/logs/query-history-all-5.1.run have any information on this error.

  • #2
    Are you still getting this issue? And if so can you show the result for pt-agent --status? Please make sure to remove your API key before posting here. Thanks!


    • #3
      This seems to be particular to the 5.1 version. I have this error on 5.1.55, it is eliminated in 5.1.68. I can't find in the release notes where log_slow_admin_statements was introduced.