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

Bug fixes and pt-kill --log-dsn

Milestone information

Project:
Percona Toolkit moved to https://jira.percona.com/projects/PT
Series:
2.1
Version:
2.1.3
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:
19 Brian Fraser, 18 Daniel Nichter
Blueprints:
1 Implemented
Bugs:
36 Fix Released

Download files for this release

File Description Downloads

Release notes 

Percona Toolkit 2.1.3 has been released. This release includes 31 bug fixes and one new feature: pt-kill --log-dsn to log information about killed queries to a table. The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:

* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5

pt-table-checksum used to check the user's privileges, but the method was not always reliable, and due to http://bugs.mysql.com/bug.php?id=61846 it became quite unreliable on MySQL 5.5. So the privs check was removed altogether, meaning that the tool may fail later if the user's privileges are insufficient.

* Fixed bug 950294: pt-table-checksum should always create schema and tables wi
th IF NOT EXISTS

In certain cases where the master and replicas have different schemas and/or tables, pt-table-checksum could break replication because the checksums table did not exist on a replica.

* Fixed bug 821703: pt-query-digest --processlist may crash
* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns

Certain distributions of MySQL add extra columns to SHOW PROCESSLIST which caused pt-query-digest --processlist to crash at times.

* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost

pt-kill is meant to be a long-running daemon, so naturally it's important that it stays connected to MySQL.

* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error

The combination of these pt-heartbeat options could cause replication to break due to a duplicate key error.

* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value
in numeric lt (<) at line 6519

This bug was related to how --quiet was handled, and it could happen even if --quiet wasn't given on the command line.

All in all, this is solid bug fix release, and 2.1 users are encouraged to upgrade.

Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).

Changelog 

This release does not have a changelog.

1 blueprint and 36 bugs targeted

Blueprint Priority Assignee Delivery
Make pt-kill log its actions Make pt-kill log its actions 4 High Brian Fraser  11 Implemented
Bug report Importance Assignee Status
941469 #941469 pt-kill doesn't reconnect if its connection is lost 3 High Daniel Nichter  10 Fix Released
962330 #962330 pt-slave-delay incorrectly computes lag if started when slave is already lagging 3 High Brian Fraser  10 Fix Released
980318 #980318 pt-upgrade results truncated if hostnames are long 3 High Daniel Nichter  10 Fix Released
1030031 #1030031 pt-table-checksum reports wrong number of DIFFS 3 High Daniel Nichter  10 Fix Released
821703 #821703 pt-query-digest --processlist may crash 4 Medium Brian Fraser  10 Fix Released
844880 #844880 pt-variable-advisor shows binary logging as both enabled and disabled 4 Medium Brian Fraser  10 Fix Released
869005 #869005 pt-table-sync should always set REPEATABLE READ 4 Medium Daniel Nichter  10 Fix Released
883098 #883098 pt-query-digest crashes if processlist has extra columns 4 Medium Brian Fraser  10 Fix Released
889739 #889739 pt-config-diff doesn't diff quoted strings properly 4 Medium Brian Fraser  10 Fix Released
903510 #903510 pt-tcp-model crashes in --type=requests mode on empty file 4 Medium Brian Fraser  10 Fix Released
916168 #916168 pt-table-checksum privilege check fails on MySQL 5.5 4 Medium Daniel Nichter  10 Fix Released
916168 #916168 pt-table-checksum privilege check fails on MySQL 5.5 4 Medium Daniel Nichter  10 Fix Released
924950 #924950 pt-query-digest --group-by db may crash profile report 4 Medium Daniel Nichter  10 Fix Released
937225 #937225 pt-query-advisor OUTER JOIN advice in JOI.003 is confusing 4 Medium Brian Fraser  10 Fix Released
940733 #940733 pt-ioprofile leaves behind temp directory 4 Medium Brian Fraser  10 Fix Released
950294 #950294 pt-table-checksum should always create schema and tables with IF NOT EXISTS 4 Medium Brian Fraser  10 Fix Released
953141 #953141 pt-table-checksum ignores its default and explicit --recursion-method 4 Medium Brian Fraser  10 Fix Released
969669 #969669 pt-duplicate-key-checker --key-types=k doesn't work 4 Medium Daniel Nichter  10 Fix Released
969703 #969703 pt-sift defaults to '.' instead of '/var/lib/pt-talk' 4 Medium Daniel Nichter  10 Fix Released
977226 #977226 pt-summary doesn't detect LSI RAID control 4 Medium Brian Fraser  10 Fix Released
984915 #984915 DSNParser does not check success of --set-vars 4 Medium Brian Fraser  10 Fix Released
1004567 #1004567 pt-heartbeat --update --replace causes duplicate key error 4 Medium Daniel Nichter  10 Fix Released
1004567 #1004567 pt-heartbeat --update --replace causes duplicate key error 4 Medium Daniel Nichter  10 Fix Released
1016114 #1016114 pt-online-schema-change docs don't mention default values 4 Medium Brian Fraser  10 Fix Released
1016127 #1016127 Install hint for DBD::mysql is wrong 4 Medium Brian Fraser  10 Fix Released
1020997 #1020997 pt-online-schema-change fails when table is empty 4 Medium Daniel Nichter  10 Fix Released
1020997 #1020997 pt-online-schema-change fails when table is empty 4 Medium Daniel Nichter  10 Fix Released
1022628 #1022628 pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519 4 Medium Brian Fraser  10 Fix Released
1022851 #1022851 pt-sift error: PREFIX: unbound variable 4 Medium Daniel Nichter  10 Fix Released
1028614 #1028614 pt-index-usage ignores --database 4 Medium Daniel Nichter  10 Fix Released
1028614 #1028614 pt-index-usage ignores --database 4 Medium Daniel Nichter  10 Fix Released
1030975 #1030975 pt-table-sync crashes if sql_mode includes ANSI_QUOTES 4 Medium Brian Fraser  10 Fix Released
821696 #821696 pt-variable-advisor shows too long of a snippet 5 Low Brian Fraser  10 Fix Released
934310 #934310 pt-tcp-model --quantile docs wrong 5 Low Brian Fraser  10 Fix Released
954990 #954990 pt-stalk --nostalk does not work 5 Low Daniel Nichter  10 Fix Released
954990 #954990 pt-stalk --nostalk does not work 5 Low Daniel Nichter  10 Fix Released
This milestone contains Public information
Everyone can see this information.