This works
/tmp/pt-kill --config /home/kolita/pt-kill.conf h=127.0.0.1,P=5532
This does not:
/tmp/pt-kill --config /home/kolita/pt-kill.conf
DBI connect(';mysql_read_default_file=/home/kolita/.my.cnf;host=localhost;mysql_read_default_group=client','',...) failed: Access denied for user 'msandbox'@'localhost' (using password: YES) at /tmp/pt-kill line 2049
This is using patched version Daniel provided for customer (see attachments in 33351). Customer in that issue reported that this worked:
But when he moved the log-dsn line to the .conf file, then it would stop working. For me log-dsn worked from the .conf file. Attaching output of PTDEBUG for failed run.
lilith:~$ cat pt-kill.conf
defaults- file=/home/ kolita/ .my.cnf info=(? i-smx:^ insert| ^update| ^delete| ^load) (?i-xsm: select) user=(? i-xsm:root) pt-kill. log F=/home/ kolita/ pt-kill. cnf,h=127. 0.0.1,P= 25532,D= percona, t=kill_ log
interval=1
busy-time=5
wait-after-kill=5
ignore-
match-info=
ignore-
daemonize
nostrip-comments
kill-query
log=/tmp/
log-dsn=
lilith:~$ cat /home/kolita/ pt-kill. cnf
[client]
user=msandbox
password=msandbox
host=127.0.0.1
port=25532
lilith:~$ cat /home/kolita/ .my.cnf
[client]
user=msandbox
password=msandbox
host=127.0.0.1
port=5532
This works pt-kill. conf h=127.0.0.1,P=5532
/tmp/pt-kill --config /home/kolita/
This does not: pt-kill. conf
/tmp/pt-kill --config /home/kolita/
DBI connect( ';mysql_ read_default_ file=/home/ kolita/ .my.cnf; host=localhost; mysql_read_ default_ group=client' ,'',... ) failed: Access denied for user 'msandbox' @'localhost' (using password: YES) at /tmp/pt-kill line 2049
This is using patched version Daniel provided for customer (see attachments in 33351). Customer in that issue reported that this worked:
/tmp/pt-kill --version
pt-kill 2.2.3
md5sum /tmp/pt-kill 28d62fd19f94aea ad /tmp/pt-kill
53f5508840ab971
/tmp/pt-kill --config /home/kolita/ pt-kill. conf --log-dsn= F=/home/ kolita/ pt-kill. cnf,h=127. 0.0.1,P= 25532,D= percona, t=kill_ log
But when he moved the log-dsn line to the .conf file, then it would stop working. For me log-dsn worked from the .conf file. Attaching output of PTDEBUG for failed run.