Not the answer you need?
Register and ask your own question!

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

MattMatt EntrantInactive User Role Beginner
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.

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    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!
  • esolomonesolomon Entrant Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.