Percona Toolkit moved to https://jira.percona.com/projects/PT

Percona Toolkit moved to https://jira.percona.com/projects/PT 2.0.4

Bug fixes and pt-kill --group-by

Milestone information

Project:
Percona Toolkit moved to https://jira.percona.com/projects/PT
Series:
2.0
Version:
2.0.4
Released:
 
Registrant:
Daniel Nichter
Release registered:
Active:
No. Drivers cannot target bugs and blueprints to this milestone.  

Download RDF metadata

Activities

Assigned to you:
No blueprints or bugs assigned to you.
Assignees:
5 Baron Schwartz, 2 Brian Fraser, 16 Daniel Nichter
Blueprints:
1 Implemented
Bugs:
22 Fix Released

Download files for this release

File Description Downloads

Release notes 

Percona Toolkit 2.0.4 fixes 25 bugs and adds a minor new feature to pt-kill. Highlights of the changes follow.

* pt-kill now has a --filter option which allows for arbitrary --group-by
* pt-online-schema-change now requires that its new --execute option be given, otherwise the tool will exit. This is a safeguard to encourage users to read the documentation, particularly when replication is involved. As such, it fixes the "bug" that the tool might do something for which the user is not prepared.
* pt-stalk received a new option: --[no]stalk, which allows collecting data without watching the server, a feature unintentionally omitted from the previous release.

This release is completely backwards compatible with previous 2.0 releases. All users are encouraged to upgrade.

Changelog 

View the full changelog

* Added --filter to pt-kill to allow arbitrary --group-by
* Fixed bug 932331: Added --[no]stalk to pt-stalk
* Fixed bug 933232: Added --execute to pt-online-schema-change
* Fixed bug 873598: pt-online-schema-change doesn't like reserved words in column names
* Fixed bug 928966: pt-pmp still uses insecure /tmp
* Fixed bug 933232: pt-online-schema-change can break replication
* Fixed bug 941225: Use of qw(...) as parentheses is deprecated at pt-kill line 3511
* Fixed bug 821694: pt-query-digest doesn't recognize hex InnoDB txn IDs
* Fixed bug 894255: pt-kill shouldn't check if STDIN is a tty when --daemonize is given
* Fixed bug 916999: pt-table-checksum error: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed
* Fixed bug 926598: DBD::mysql bug causes pt-upgrade to use wrong precision (M) and scale (D)
* Fixed bug 928226: pt-diskstats illegal division by zero
* Fixed bug 928415: Typo in pt-stalk doc: --trigger should be --function
* Fixed bug 930317: pt-archiver doc refers to nonexistent pt-query-profiler
* Fixed bug 930533: pt-sift looking for *-processlist1; broken compatibility with pt-stalk
* Fixed bug 932331: pt-stalk cannot collect without stalking
* Fixed bug 932442: pt-table-checksum error when column name has two spaces
* Fixed bug 940503: pt-stalk disk space checks wrong on 32bit platforms
* Fixed bug 944420: --daemonize doesn't always close STDIN
* Fixed bug 945834: pt-sift invokes pt-diskstats with deprecated argument
* Fixed bug 945836: pt-sift prints awk error if there are no stack traces to aggregate
* Fixed bug 945842: pt-sift generates wrong state sum during processlist analysis
* Fixed bug 946438: pt-query-digest should print a better message when an unsupported log format is specified
* Fixed bug 946776: pt-table-checksum ignores --lock-wait-timeout
* Fixed bug 940440: Bad grammar in pt-kill docs

1 blueprint and 22 bugs targeted

Blueprint Priority Assignee Delivery
pt-kill custom --group-by pt-kill custom --group-by 4 High Daniel Nichter  11 Implemented
Bug report Importance Assignee Status
873598 #873598 pt-online-schema-change doesn't like reserved words in column names 3 High Daniel Nichter  10 Fix Released
928966 #928966 pt-pmp still uses insecure /tmp 3 High Daniel Nichter  10 Fix Released
933232 #933232 pt-online-schema-change can break replication 3 High Daniel Nichter  10 Fix Released
941225 #941225 Use of qw(...) as parentheses is deprecated at pt-kill line 3511 3 High Brian Fraser  10 Fix Released
821694 #821694 pt-query-digest doesn't recognize hex InnoDB txn IDs 4 Medium Daniel Nichter  10 Fix Released
894255 #894255 pt-kill shouldn't check if STDIN is a tty when --daemonize is given 4 Medium Daniel Nichter  10 Fix Released
916999 #916999 pt-table-checksum error: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed 4 Medium Daniel Nichter  10 Fix Released
926598 #926598 DBD::mysql bug causes pt-upgrade to use wrong precision (M) and scale (D) 4 Medium Daniel Nichter  10 Fix Released
928226 #928226 pt-diskstats illegal division by zero 4 Medium Brian Fraser  10 Fix Released
928415 #928415 Typo in pt-stalk doc: --trigger should be --function 4 Medium Daniel Nichter  10 Fix Released
930317 #930317 pt-archiver doc refers to nonexistent pt-query-profiler 4 Medium Daniel Nichter  10 Fix Released
930533 #930533 pt-sift looking for *-processlist1; broken compatibility with pt-stalk 4 Medium Baron Schwartz  10 Fix Released
932331 #932331 pt-stalk cannot collect without stalking 4 Medium Daniel Nichter  10 Fix Released
932442 #932442 pt-table-checksum error when column name has two spaces 4 Medium Daniel Nichter  10 Fix Released
940503 #940503 pt-stalk disk space checks wrong on 32bit platforms 4 Medium Daniel Nichter  10 Fix Released
944420 #944420 --daemonize doesn't always close STDIN 4 Medium Daniel Nichter  10 Fix Released
945834 #945834 pt-sift invokes pt-diskstats with deprecated argument 4 Medium Baron Schwartz  10 Fix Released
945836 #945836 pt-sift prints awk error if there are no stack traces to aggregate 4 Medium Baron Schwartz  10 Fix Released
945842 #945842 pt-sift generates wrong state sum during processlist analysis 4 Medium Baron Schwartz  10 Fix Released
946438 #946438 pt-query-digest should print a better message when an unsupported log format is specified 4 Medium Baron Schwartz  10 Fix Released
946776 #946776 pt-table-checksum ignores --lock-wait-timeout 4 Medium Daniel Nichter  10 Fix Released
940440 #940440 Bad grammar in pt-kill docs 5 Low Daniel Nichter  10 Fix Released
This milestone contains Public information
Everyone can see this information.