2013-08-08 01:00:43 |
markus_albe |
bug |
|
|
added bug |
2013-08-08 01:00:43 |
markus_albe |
attachment added |
|
PTDEBUG=1 /tmp/pt-kill --config /home/kolita/pt-kill.conf &> /tmp/pt-kill.debug https://bugs.launchpad.net/bugs/1209436/+attachment/3764229/+files/pt-kill.debug |
|
2013-08-08 01:00:58 |
markus_albe |
summary |
pt-kill won't honor connection parameters provided in config files |
ipt-kill won't honor connection parameters provided in config files |
|
2013-08-08 01:00:58 |
markus_albe |
description |
lilith:~$ cat pt-kill.conf
defaults-file=/home/kolita/.my.cnf
interval=1
busy-time=5
wait-after-kill=5
ignore-info=(?i-smx:^insert|^update|^delete|^load)
match-info=(?i-xsm:select)
ignore-user=(?i-xsm:root)
daemonize
nostrip-comments
kill-query
log=/tmp/pt-kill.log
log-dsn=F=/home/kolita/pt-kill.cnf,h=127.0.0.1,P=25532,D=percona,t=kill_log
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
/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:
/tmp/pt-kill --version
pt-kill 2.2.3
md5sum /tmp/pt-kill
53f5508840ab97128d62fd19f94aeaad /tmp/pt-kill
/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. |
lilith:~$ cat pt-kill.conf
defaults-file=/home/kolita/.my.cnf
interval=1
busy-time=5
wait-after-kill=5
ignore-info=(?i-smx:^insert|^update|^delete|^load)
match-info=(?i-xsm:select)
ignore-user=(?i-xsm:root)
daemonize
nostrip-comments
kill-query
log=/tmp/pt-kill.log
log-dsn=F=/home/kolita/pt-kill.cnf,h=127.0.0.1,P=25532,D=percona,t=kill_log
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
/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:
/tmp/pt-kill --version
pt-kill 2.2.3
md5sum /tmp/pt-kill
53f5508840ab97128d62fd19f94aeaad /tmp/pt-kill
/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. |
|
2013-08-08 01:00:58 |
markus_albe |
tags |
|
i33351 |
|
2013-08-08 01:01:39 |
Daniel Nichter |
percona-toolkit: milestone |
|
2.2.5 |
|
2013-08-08 01:01:42 |
Daniel Nichter |
percona-toolkit: importance |
Undecided |
Medium |
|
2013-08-08 01:01:56 |
Daniel Nichter |
tags |
i33351 |
config-file percona-33351 pt-kill |
|
2013-08-08 01:02:14 |
Daniel Nichter |
summary |
ipt-kill won't honor connection parameters provided in config files |
pt-kill doesn't honor connection parameters in config files |
|
2013-08-08 01:02:47 |
Daniel Nichter |
percona-toolkit: status |
New |
Confirmed |
|
2013-08-12 16:12:26 |
Launchpad Janitor |
branch linked |
|
lp:~percona-toolkit-dev/percona-toolkit/fix-pt-kill-daemon-bug |
|
2013-08-12 16:14:40 |
Daniel Nichter |
percona-toolkit: status |
Confirmed |
In Progress |
|
2013-08-12 16:14:44 |
Daniel Nichter |
percona-toolkit: importance |
Medium |
High |
|
2013-08-12 16:14:49 |
Daniel Nichter |
percona-toolkit: assignee |
|
Daniel Nichter (daniel-nichter) |
|
2013-08-13 21:44:16 |
Daniel Nichter |
summary |
pt-kill doesn't honor connection parameters in config files |
pt-kill --log-dsn may not work on Perl 5.8 |
|
2013-08-13 21:44:33 |
Daniel Nichter |
tags |
config-file percona-33351 pt-kill |
config-file percona-33351 perl-5.8 perl-bug pt-kill |
|
2013-08-14 00:36:30 |
Daniel Nichter |
percona-toolkit: status |
In Progress |
Fix Committed |
|
2013-10-17 06:39:37 |
Hrvoje Matijakovic |
percona-toolkit: status |
Fix Committed |
Fix Released |
|