openSUSE Recommended Update: percona-toolkit: 2.2.6 version update ______________________________________________________________________________ Announcement ID: openSUSE-RU-2014:0056-1 Rating: moderate References: #856861 Affected Products: openSUSE 13.1 ______________________________________________________________________________ An update that has one recommended fix can now be installed. Description: Percona Toolkit was updated to 2.2.6 [bnc#856861] This is a strongly recommended bugfix release fixing potential data loss. Highlighted fixes: * pt-table-sync deletes child table rows In the worst case, pt-table-sync could delete all rows in child tables. Now pt-table-sync has option --[no]check-child-tables which is on by default. In cases were this can be triggered, pt-table-sync prints a warning and skips the table. * pt-duplicate-key-checker misses exact duplicate unique indexes * pt-online-schema-change gets stuck looking for its own _new table * pt-mysql-summary schema dump prompt can't be disabled pt-mysql-summary no longer prompts to dump and summarize schemas. To do this, you must specify --databases or, a new option, --all-databases. Potentially backwards-incompatible change. Added options: * Added pt-query-digest support for Percona Server slow log rate limiting * Added pt-agent --ping * Added pt-mysql-summary --all-databases * Added pt-stalk --sleep-collect * Added pt-table-sync --[no]check-child-tables Further changes: * PTDEBUG prints some info to STDOUT * pt-agent requires restart after changing MySQL options * pt-agent --install on PXC is not documented * pt-agent --install doesn’t check for previous install * pt-agent --install suggest MySQL user isn’t quoted * pt-agent --install error about slave is confusing * pt-agent --uninstall fails if agent is running * pt-agent docs don’t list privs required for its MySQL user * pt-deadlock-logger docs use pt-fk-error-logger * pt-duplicate-key-checker error when EXPLAIN key_len=0 * pt-query-digest stats prints to STDOUT instead of STDERR * pt-stak error parsing df with NFS Also contains changes from 2.2.5: * Query_time histogram has been added to the pt-query-digest JSON output, not the actual chart but the values necessary to render the chart later, so the values for each bucket. * As of pt-table-checksum 2.2.5, skipped chunks cause a non-zero exit status. An exit status of zero or 32 is equivalent to a zero exit status with skipped chunks in previous versions of the tool. * New --no-drop-triggers option has been implemented for pt-online-schema-change in case users want to rename the tables manually, when the load is low. * New --new-table-name option has been added to pt-online-schema-change which can be used to specify the temporary table name. Bugs Fixed in 2.2.5: * pt-archiver would delete the data even with the --dry-run option. * pt-query-digest didn’t distill LOAD DATA correctly. * pt-query-digest didn’t distill INSERT/REPLACE without INTO correctly. * pt-agent docs were referencing wrong web address. * pt-table-checksum --recursion-method=cluster option would crash if no nodes were found. Patch Instructions: To install this openSUSE Recommended Update use YaST online_update. Alternatively you can run the command listed for your product: - openSUSE 13.1: zypper in -t patch openSUSE-2014-28 To bring your system up-to-date, use "zypper patch". Package List: - openSUSE 13.1 (noarch): percona-toolkit-2.2.6-2.4.1 References: https://bugzilla.novell.com/856861