Unable to reproduce with pt-kill-2.2.9, can you please install latest version and check?
nilnandan@nilnandan-Dell-XPS:~$ pt-kill --version
pt-kill 2.2.9
nilnandan@nilnandan-Dell-XPS:~$
nilnandan@nilnandan-Dell-XPS:~$ sudo -H -u mysql /usr/bin/pt-kill --config /etc/percona-toolkit/pt-kill.conf --kill-query --daemonize --pid /var/run/percona-toolkit/pt-kill.pid --sentinel /var/run/percona-toolkit/pt-kill.sentinel
DBI connect(';host=localhost;mysql_read_default_group=client','',...) failed: Access denied for user 'nilnandan'@'localhost' (using password: NO) at /usr/bin/pt-kill line 2059.
nilnandan@nilnandan-Dell-XPS:~$ echo $?
255
nilnandan@nilnandan-Dell-XPS:~$
nilnandan@nilnandan-Dell-XPS:~$ pt-kill --user=root --match-command Sleep --kill --victims all --interval 10
DBI connect(';host=localhost;mysql_read_default_group=client','root',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/pt-kill line 2059.
nilnandan@nilnandan-Dell-XPS:~$
nilnandan@nilnandan-Dell-XPS:~$ echo $?
255
nilnandan@nilnandan-Dell-XPS:~$
nilnandan@nilnandan-Dell-XPS:~$ pt-kill --user=root --match-command Sleep --kill --victims all --interval 10 --config /etc/percona-toolkit/pt-kill
Unknown option: config
Usage: pt-kill [OPTIONS] [DSN]
Errors in command-line arguments:
* Error parsing options
pt-kill kills MySQL connections. pt-kill connects to MySQL and gets queries from
SHOW PROCESSLIST if no FILE is given. Else, it reads queries from one or more
FILE which contains the output of SHOW PROCESSLIST. If FILE is -, pt-kill reads
from STDIN. For more details, please use the --help option, or try 'perldoc
/usr/bin/pt-kill' for complete documentation.
nilnandan@nilnandan-Dell-XPS:~$
nilnandan@nilnandan-Dell-XPS:~$ echo $?
1
nilnandan@nilnandan-Dell-XPS:~$
Unable to reproduce with pt-kill-2.2.9, can you please install latest version and check?
nilnandan@ nilnandan- Dell-XPS: ~$ pt-kill --version nilnandan- Dell-XPS: ~$ nilnandan- Dell-XPS: ~$ sudo -H -u mysql /usr/bin/pt-kill --config /etc/percona- toolkit/ pt-kill. conf --kill-query --daemonize --pid /var/run/ percona- toolkit/ pt-kill. pid --sentinel /var/run/ percona- toolkit/ pt-kill. sentinel ';host= localhost; mysql_read_ default_ group=client' ,'',... ) failed: Access denied for user 'nilnandan' @'localhost' (using password: NO) at /usr/bin/pt-kill line 2059. nilnandan- Dell-XPS: ~$ echo $? nilnandan- Dell-XPS: ~$
pt-kill 2.2.9
nilnandan@
nilnandan@
DBI connect(
nilnandan@
255
nilnandan@
nilnandan@ nilnandan- Dell-XPS: ~$ pt-kill --user=root --match-command Sleep --kill --victims all --interval 10 ';host= localhost; mysql_read_ default_ group=client' ,'root' ,...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/pt-kill line 2059. nilnandan- Dell-XPS: ~$ nilnandan- Dell-XPS: ~$ echo $? nilnandan- Dell-XPS: ~$ nilnandan- Dell-XPS: ~$ pt-kill --user=root --match-command Sleep --kill --victims all --interval 10 --config /etc/percona- toolkit/ pt-kill
DBI connect(
nilnandan@
nilnandan@
255
nilnandan@
nilnandan@
Unknown option: config
Usage: pt-kill [OPTIONS] [DSN]
Errors in command-line arguments:
* Error parsing options
pt-kill kills MySQL connections. pt-kill connects to MySQL and gets queries from nilnandan- Dell-XPS: ~$ nilnandan- Dell-XPS: ~$ echo $? nilnandan- Dell-XPS: ~$
SHOW PROCESSLIST if no FILE is given. Else, it reads queries from one or more
FILE which contains the output of SHOW PROCESSLIST. If FILE is -, pt-kill reads
from STDIN. For more details, please use the --help option, or try 'perldoc
/usr/bin/pt-kill' for complete documentation.
nilnandan@
nilnandan@
1
nilnandan@