On Xenial, various tools fail because of warnings from sprintf that are generated on the new Perl version in Xenial.
These warnings are fatal because all of the tools set "use strict" and "use warnings FATAL => 'all';"
This can be tested simply by parsing any MySQL log with pt-query-digest
* Test Case *
apt-get install mysql-server percona-toolkit # set any root password you like, we'll just use the debian.cnf credentials
mysql --defaults-file=/etc/mysql/debian.cnf -e "set GLOBAL slow_query_log = on,
long_query_time=0.0; select * from mysql.user;"
pt-query-digest /var/lib/mysql/$(hostname)-slow.log
Result:
The pipeline caused an error: Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/pt-query-digest line 2556.
Terminating pipeline because process 4 (iteration) caused too many errors.
On Xenial, various tools fail because of warnings from sprintf that are generated on the new Perl version in Xenial.
These warnings are fatal because all of the tools set "use strict" and "use warnings FATAL => 'all';"
This can be tested simply by parsing any MySQL log with pt-query-digest
* Test Case *
apt-get install mysql-server percona-toolkit # set any root password you like, we'll just use the debian.cnf credentials file=/etc/ mysql/debian. cnf -e "set GLOBAL slow_query_log = on, time=0. 0; select * from mysql.user;" mysql/$ (hostname) -slow.log
mysql --defaults-
long_query_
pt-query-digest /var/lib/
Result: pt-query- digest line 2556.
The pipeline caused an error: Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/
Terminating pipeline because process 4 (iteration) caused too many errors.
This issue was fixed upstream: /github. com/percona/ percona- toolkit/ pull/73/
https:/