Percona Toolkit 2.1.2

Bug fixes, pt-query-advisor JSON output, and new pt-online-schema-change options

Milestone information

Project:
Percona Toolkit
Series:
2.1
Version:
2.1.2
Released:
2012-06-12  
Registrant:
Daniel Nichter
Release registered:
2012-06-25
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:
8 Baron Schwartz, 17 Brian Fraser, 53 Daniel Nichter
Blueprints:
2 Implemented
Bugs:
76 Fix Released

Download files for this release

File Description Downloads

Release notes 

Percona Toolkit 2.1.2 has been released. This is a very important release because it fixes a critical bug in pt-table-sync (bug 1003014) which caused various failures. All users of Percona Toolkit 2.1 should upgrade to this release. There were 47 other bug fixes, several new options, and other changes. The following is a high-level summary of the most important changes.

In addition to the critical bug fix mentioned above, another important pt-table-sync bug was fixed, bug 1002365: –ignore-* options did not work with –replicate. The –lock-and-rename feature of the tool was also disabled unless running MySQL 5.5 or newer because it did not work reliably in earlier versions of MySQL.

Several important pt-table-checksum bugs were fixed. First, a bug caused the tool to ignore the primary key. Second, the tool did not wait for the checksum table to replicate, so it could select from a nonexistent table on a replica and crash. Third, it did not check if all checksum queries were safe and chunk index with more than 3 columns could cause MySQL to scan many more rows than expected.

pt-online-schema-change received many improvements and fixes: it did not retry deadlocks, but now it does; –no-swap-tables caused an error; it did not handle column renames; it did not allow disabling foreign key checks; –dry-run always failed on tables with foreign keys; it used different keys for chunking and triggers; etc. In short: pt-online-schema-change 2.1.2 is superior to 2.1.1.

Two pt-archiver bugs were fixed: bug 979092, –sleep conflicts with bulk operations; and bug 903379, –file doesn’t create a file.

–recursion-method=none was implemented in pt-heartbeat, pt-online-schema-change, pt-slave-find, pt-slave-restart, pt-table-checksum, and pt-table-sync. This allows these tools to avoid executing SHOW SLAVE STATUS which requires a privilege not available to Amazon RDS users.

Other bugs were fixed in pt-stalk, pt-variable-advisor, pt-duplicate-key-checker, pt-diskstats, pt-query-digest, pt-sift, pt-kill, pt-summary, and pt-deadlock-logger.

Percona Toolkit 2.1.2 should be backwards-compatible with 2.1.1, so users are strongly 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.

2 blueprints and 76 bugs targeted

Blueprint Priority Assignee Delivery
Stable test suite 5 Essential Daniel Nichter  11 Implemented
pt-query-advisor JSON output 3 Medium Brian Fraser  11 Implemented
Bug report Importance Assignee Status
1003014 #1003014 pt-table-sync --replicate and --sync-to-master error "index does not exist" 2 Critical Daniel Nichter  10 Fix Released
1003014 #1003014 pt-table-sync --replicate and --sync-to-master error "index does not exist" 2 Critical Daniel Nichter  10 Fix Released
919499 #919499 pt-table-checksum fails with binary log error in mysql >= 5.5.18 3 High Daniel Nichter  10 Fix Released
919499 #919499 pt-table-checksum fails with binary log error in mysql >= 5.5.18 3 High Daniel Nichter  10 Fix Released
978432 #978432 pt-table-checksum ignoring primary key 3 High Daniel Nichter  10 Fix Released
978432 #978432 pt-table-checksum ignoring primary key 3 High Daniel Nichter  10 Fix Released
979092 #979092 pt-archiver --sleep conflicts with bulk operations 3 High Daniel Nichter  10 Fix Released
979092 #979092 pt-archiver --sleep conflicts with bulk operations 3 High Daniel Nichter  10 Fix Released
988036 #988036 pt-online-schema-change causes deadlocks under heavy write load 3 High Daniel Nichter  10 Fix Released
988036 #988036 pt-online-schema-change causes deadlocks under heavy write load 3 High Daniel Nichter  10 Fix Released
989227 #989227 Using PTDEBUG crashes pt-online-schema-change 2.1 3 High Daniel Nichter  10 Fix Released
994010 #994010 pt-online-schema-change 2.1.1 crashes without InnoDB 3 High Daniel Nichter  10 Fix Released
994010 #994010 pt-online-schema-change 2.1.1 crashes without InnoDB 3 High Daniel Nichter  10 Fix Released
994947 #994947 pt-stalk doesn't reset cycles_true after collection 3 High Daniel Nichter  10 Fix Released
994947 #994947 pt-stalk doesn't reset cycles_true after collection 3 High Daniel Nichter  10 Fix Released
1002365 #1002365 pt-table-sync --ignore-* options don't work with --replicate 3 High Daniel Nichter  10 Fix Released
1002365 #1002365 pt-table-sync --ignore-* options don't work with --replicate 3 High Daniel Nichter  10 Fix Released
1004551 #1004551 pt-online-schema-change --no-swap-tables causes error 3 High Daniel Nichter  10 Fix Released
1008778 #1008778 pt-table-checksum doesn't wait for checksum table to replicate 3 High Daniel Nichter  10 Fix Released
1010232 #1010232 pt-table-checksum doesn't check the size of checksum chunks 3 High Daniel Nichter  10 Fix Released
823403 #823403 pt-table-sync --lock-and-rename doesn't work on 5.1 4 Medium Brian Fraser  10 Fix Released
844034 #844034 pt-show-grants --separate fails with proxy user 4 Medium Baron Schwartz  10 Fix Released
885382 #885382 pt-query-digest --embedded-attributes doesn't check cardinality 4 Medium Brian Fraser  10 Fix Released
885382 #885382 pt-query-digest --embedded-attributes doesn't check cardinality 4 Medium Brian Fraser  10 Fix Released
888114 #888114 Infinite loop in pt-query-digest if a report crashes 4 Medium Daniel Nichter  10 Fix Released
888114 #888114 Infinite loop in pt-query-digest if a report crashes 4 Medium Daniel Nichter  10 Fix Released
894140 #894140 pt-duplicate-key-checker sometimes recreates a key it shouldn't 4 Medium Daniel Nichter  10 Fix Released
894140 #894140 pt-duplicate-key-checker sometimes recreates a key it shouldn't 4 Medium Daniel Nichter  10 Fix Released
898138 #898138 pt-variable-advisor doesn't recognize 5.5.3+ concurrent_insert values 4 Medium Daniel Nichter  10 Fix Released
898138 #898138 pt-variable-advisor doesn't recognize 5.5.3+ concurrent_insert values 4 Medium Daniel Nichter  10 Fix Released
903379 #903379 pt-archiver --file doesn't create a file 4 Medium Brian Fraser  10 Fix Released
903379 #903379 pt-archiver --file doesn't create a file 4 Medium Brian Fraser  10 Fix Released
903443 #903443 pt-deadlock-logger crashes on MySQL 5.5 4 Medium Brian Fraser  10 Fix Released
903443 #903443 pt-deadlock-logger crashes on MySQL 5.5 4 Medium Brian Fraser  10 Fix Released
923896 #923896 pt-kill: uninitialized value causes script to exit 4 Medium Brian Fraser  10 Fix Released
923896 #923896 pt-kill: uninitialized value causes script to exit 4 Medium Brian Fraser  10 Fix Released
941064 #941064 pt-deadlock-logger can't clear deadlocks on 5.5 4 Medium Baron Schwartz  10 Fix Released
946707 #946707 pt-sift loses STDIN after pt-diskstats 4 Medium Brian Fraser  10 Fix Released
952727 #952727 pt-diskstats shows incorrect wr_mb_s 4 Medium Baron Schwartz  10 Fix Released
952727 #952727 pt-diskstats shows incorrect wr_mb_s 4 Medium Baron Schwartz  10 Fix Released
972399 #972399 pt-table-checksum docs are not rendered right 4 Medium Baron Schwartz  10 Fix Released
972399 #972399 pt-table-checksum docs are not rendered right 4 Medium Baron Schwartz  10 Fix Released
976108 #976108 pt-online-schema-change doesn't allow to disable foreign key checks 4 Medium Daniel Nichter  10 Fix Released
976108 #976108 pt-online-schema-change doesn't allow to disable foreign key checks 4 Medium Daniel Nichter  10 Fix Released
976109 #976109 pt-online-schema-change doesn't handle column renames 4 Medium Daniel Nichter  10 Fix Released
976109 #976109 pt-online-schema-change doesn't handle column renames 4 Medium Daniel Nichter  10 Fix Released
986151 #986151 mktemp error with pt-stalk 4 Medium Daniel Nichter  10 Fix Released
986151 #986151 mktemp error with pt-stalk 4 Medium Daniel Nichter  10 Fix Released
987393 #987393 pt-table-checksum: Empy tables cause "undefined value as an ARRAY" errors 4 Medium Daniel Nichter  10 Fix Released
987393 #987393 pt-table-checksum: Empy tables cause "undefined value as an ARRAY" errors 4 Medium Daniel Nichter  10 Fix Released
987694 #987694 There is no --recursion-method=none option 4 Medium Daniel Nichter  10 Fix Released
987694 #987694 There is no --recursion-method=none option 4 Medium Daniel Nichter  10 Fix Released
993436 #993436 pt-summary Memory: Total reports M instead of G 4 Medium Daniel Nichter  10 Fix Released
993436 #993436 pt-summary Memory: Total reports M instead of G 4 Medium Daniel Nichter  10 Fix Released
994002 #994002 pt-online-schema-change 2.1.1 doesn't choose the PRIMARY KEY 4 Medium Daniel Nichter  10 Fix Released
994002 #994002 pt-online-schema-change 2.1.1 doesn't choose the PRIMARY KEY 4 Medium Daniel Nichter  10 Fix Released
994176 #994176 pt-diskstats --group-by=all --headers=scroll prints a header for every sample 4 Medium Daniel Nichter  10 Fix Released
994176 #994176 pt-diskstats --group-by=all --headers=scroll prints a header for every sample 4 Medium Daniel Nichter  10 Fix Released
995274 #995274 Can't use an undefined value as an ARRAY reference at pt-table-checksum line 2206 4 Medium Daniel Nichter  10 Fix Released
995274 #995274 Can't use an undefined value as an ARRAY reference at pt-table-checksum line 2206 4 Medium Daniel Nichter  10 Fix Released
996110 #996110 pt-table-checksum crashes if InnoDB is disabled 4 Medium Daniel Nichter  10 Fix Released
996110 #996110 pt-table-checksum crashes if InnoDB is disabled 4 Medium Daniel Nichter  10 Fix Released
996915 #996915 Invalid --max-load and --critical-load crash pt-online-schema-change 4 Medium Daniel Nichter  10 Fix Released
996915 #996915 Invalid --max-load and --critical-load crash pt-online-schema-change 4 Medium Daniel Nichter  10 Fix Released
997155 #997155 pt-table-sync sets binlog_format needlessly 4 Medium Baron Schwartz  10 Fix Released
998831 #998831 pt-online-schema-change -- Should have an option to NOT drop tables on failure 4 Medium Daniel Nichter  10 Fix Released
998831 #998831 pt-online-schema-change -- Should have an option to NOT drop tables on failure 4 Medium Daniel Nichter  10 Fix Released
1002448 #1002448 pt-online-schema-change: typo for finding usable indexes 4 Medium Brian Fraser  10 Fix Released
1003003 #1003003 pt-online-schema-change uses different keys for chunking and triggers 4 Medium Brian Fraser  10 Fix Released
1003315 #1003315 pt-online-schema-change --dry-run always fails on table with foreign keys 4 Medium Brian Fraser  10 Fix Released
1011738 #1011738 pt-table-checksum SKIPPED is zero but chunks were skipped 4 Medium Daniel Nichter  10 Fix Released
820104 #820104 pt-query-digest --[no]zero-bool doesn't work 5 Low Daniel Nichter  10 Fix Released
856024 #856024 Lintian warnings when building percona-toolkit Debian package 5 Low Baron Schwartz  10 Fix Released
912902 #912902 Some shell tools still use basename 5 Low Brian Fraser  10 Fix Released
945079 #945079 Shell tools TMPDIR may break 5 Low Brian Fraser  10 Fix Released
949630 #949630 pt-query-digest mentions a Subversion repository 5 Low Brian Fraser  10 Fix Released
This milestone contains Public information
Everyone can see this information.