-------------------------------------------------------------------
Sun Aug 10 14:19:11 UTC 2014 - andreas.stieger@gmx.de
- Percona Toolkit 2.2.10
* Fixed bug: pt-table-checksum deadlock
* Fixed bug: 5.6 slow query log Thead_id becomes Id
* Fixed bug: pt-table-checksum + PXC inconsistent results upon
--resume
* Fixed bug: pt-online-schema-change doesn't work with HASH
indexes
* Fixed bug: pt-table-checksum max load 20% rounds down
* Fixed bug: some shell tools output error when queried for
--version
-------------------------------------------------------------------
Thu Jul 10 20:35:37 UTC 2014 - andreas.stieger@gmx.de
- Percona Toolkit 2.2.9
* pt-query-digest could not parse the binlogs from MySQL 5.6
because the binlog format was changed.
* pt-online-schema-change did not find child tables as expected.
* pt-stalk would fail when variable or threshold was a non-integer.
* pt-deadlock-logger was inserting older deadlocks into the deadlock
table even if it was already there
* pt-online-schema-change foreign-keys-method=none cloud break FK
constraints in a way that is hard to recover from
-------------------------------------------------------------------
Thu Jun 5 20:44:03 UTC 2014 - andreas.stieger@gmx.de
- Percona Toolkit 2.2.8
* Removed pt-agent
* Added pt-slave-restart GTID support
* Added pt-table-checksum --plugin
* Fixed bug: --ignore-tables does not work correctly
* Fixed bug: pt-deadlock-logger logs incorrect ts
* Fixed bug: pt-mysql-summary blank InnoDB section for 5.6
* Fixed bug: pt-online-schema-change requests password twice
* Fixed bug: pt-query-digest dosn't fingerprint true/false
literals correctly
* Fixed bug: pt-show-grant --ask-pass prints "Enter password" to
STDOUT
- some spec cleanup
- refresh percona-toolkit-2.2.x-disable-default-version-check.patch
to not fail %check
-------------------------------------------------------------------
Mon Feb 24 19:29:34 UTC 2014 - andreas.stieger@gmx.de
- Percona Toolkit 2.2.7 [bnc#864194] CVE-2014-2029
Improves sanitisation of input and output for commands run when
performing a version check.
As this would still transmit data to an external entity without
prompting, the automatic version check remains disabled in this
package unless requested via command line or global/tool specific
or user configuratoin. (--version-check)
-------------------------------------------------------------------
Sun Feb 16 23:57:34 UTC 2014 - andreas.stieger@gmx.de
- disable automatic version check for all tools
[bnc#864194] CVE-2014-2029
Prevents transmission of version information to an external host
in the default configuration.
Can be used by owner of a Percona Server (or an attacker who can
control this destination for the client) to collect arbitrary
MySQL configuration parameters and execute commands (with -v).
Now the version check needs to be requested via command line or
global/tool specific/user configuration. (--version-check)
- added /etc/percona-toolkit/percona-toolkit.conf configuration
directory and template configuration file
- added patches:
* percona-toolkit-2.2.x-disable-default-version-check.patch
-------------------------------------------------------------------
Fri Dec 27 21:35:21 UTC 2013 - andreas.stieger@gmx.de
- update to 2.2.6 [bnc#856861]
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
-------------------------------------------------------------------
Sun Oct 20 14:10:18 UTC 2013 - andreas.stieger@gmx.de
- use re-released 2.2.5 tarball without backup files
-------------------------------------------------------------------
Thu Oct 17 11:39:27 UTC 2013 - andreas.stieger@gmx.de
- update to 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:
* 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.
-------------------------------------------------------------------
Thu Jul 18 22:34:14 UTC 2013 - andreas.stieger@gmx.de
- update to 2.2.4:
* Implemented pt-query-digest anonymous JSON output
* Implemented pt-online-schema-change timestamp output
- fixing the following bugs:
* Zero values causes "Invalid --set-vars value: var=0"
* pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
* pt-heartbeat docs don't account for --utc
* pt-online-schema-change error copying rows: Undefined subroutine &pt_online_schema_change::get
* pt-query-digest docs don't mention --type=rawlog
* pt-query-digest doesn't group db and `db` together
* pt-query-digest and pt-fingerprint don't strip some multi-line comments
* pt-sift does not work if pt-stalk did not collect due to a full disk
* pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
* pt-table-checksum doesn't use non-unique index with highest cardinality
* pt-table-checksum fails if explicit_defaults_for_timestamp is enabled in 5.6
* pt-upgrade reports differences on NULL
* pt-variable-advisor has the wrong default value for innodb_max_dirty_pages_pct in 5.5 and 5.6
* pt-variable-advisor shows key_buffer_size in 5.6 as unconfigured (even though it is)
-------------------------------------------------------------------
Wed Jul 3 18:04:10 UTC 2013 - andreas.stieger@gmx.de
- update to 2.2.3
* Added new tool: pt-agent
* Fixed bug: pt-online-schema-change causes "ERROR 1146 (42S02):
Table 'db._t_new' doesn't exist"
-------------------------------------------------------------------
Mon Apr 29 18:25:28 UTC 2013 - andreas.stieger@gmx.de
- update to 2.2.2
* Added --show-all to pt-query-digest
* Added --recursion-method=cluster to pt-table-checksum
- fixing the following bugs:
* pt-archiver --bulk-insert may corrupt data
* pt-heartbeat --utc --check always returns 0
* pt-query-digest --processlist reports duplicate queries for
replication thread
* pt-query-digest 2.2 prints unwanted debug info on tcpdump
parsing errors
* pt-query-digest 2.2 prints too many string values
* pt-stalk prints the wrong variable name in verbose mode when
--function is used
* pt-stalk plugins can't access the real --prefix
* pt-table-checksum pxc same_node function incorrectly uses
wsrep_sst_receive_address
* Some tools don't have --help or --version
* Some tools use @@hostname without /*!50038*/
* An explicitly set wsrep_node_incoming_address may make SHOW
STATUS LIKE 'wsrep_incoming_addresses' return a portless address
-------------------------------------------------------------------
Mon Apr 8 21:26:02 UTC 2013 - andreas.stieger@gmx.de
- update to 2.2.1
This is the first release in the 2.2 series. Users are advised to
re-read documentation for tools.
- new features:
* Support for MySQL 5.6
* Support for Percona XtraDB Cluster
- major updates:
* Redesigned pt-query-digest
* Redesigned pt-upgrade
* Redesigned pt-fk-error-logger
* Redesigned pt-deadlock-logger
- changed options:
* Changed --set-vars in all tools
* Renamed --retries to --tries in pt-online-schema-change
* Added --check-read-only to pt-heartbeat
* Added MySQL options to pt-mysql-summary
* Added MySQL options to pt-stalk
- removed switches:
* Removed --lock-wait-timeout from pt-online-schema-change (use --set-vars)
* Removed --lock-wait-timeout from pt-table-checksum (use --set-vars)
- removed tools:
* Removed pt-query-advisor
* Removed pt-tcp-model
* Removed pt-trend
* Removed pt-log-player
- new defaults:
* Enabled --version-check by default in all tools
- fixing the following bugs:
* Fixed bug: Several tools don't have --database
* Fixed bug: Quoter::serialize_list() doesn't handle multiple NULL values
* Fixed bug: pt-config-diff needs to parse wsrep_provider_options
* Fixed bug: pt-fk-error-logger --run-time works differently than pt-deadlock-logger --run-time
* Fixed bug: pt-online-schema-change doesn't retry RENAME TABLE
* Fixed bug: pt-online-schema-change blocks on metadata locks
* Fixed bug: pt-stalk --no-stalk silently clobbers other options, acts magically
* Fixed bug: pt-stalk truncates InnoDB status if there are too many transactions
* Fixed bug: pt-table-checksum doesn't warn if no slaves are found
-------------------------------------------------------------------
Fri Feb 15 21:29:01 UTC 2013 - andreas.stieger@gmx.de
- update to 2.1.9 [bnc#804102], fixing the following bugs:
* pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
* pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
* pt-online-schema-change fails with "Duplicate entry" on MariaDB
* pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
* pt-pmp doesn't list the origin lib for each function
* pt-query-digest shouldn't print "Error: none" for tcpdump
* pt-query-digest fails to parse non-SQL errors
* pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave
* pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index
instead of the PRIMARY index"
* pt-stalk is too verbose, fills up log
-------------------------------------------------------------------
Fri Jan 11 13:25:36 UTC 2013 - andreas.stieger@gmx.de
- update to 2.1.8
* Beta support for MySQL 5.6
* Beta support for Percona XtraDB Cluster
* pt-online-schema-change: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
* pt-table-checksum: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
* pt-upgrade: Added --[no]disable-query-cache
- fixing the following bugs:
* Bad pod2rst transformation
* Bad online docs formatting for --[no]vars
* pt-config-diff is case-sensitive
* pt-config-diff doesn't handle end-of-line comments
* pt-config-diff Use of uninitialized value in substitution (s///) at line 1996
* pt-deadlock-logger doesn't handle usernames with dashes
* pt-heartbeat handles timezones inconsistently
* pt-kill --log-dsn timestamp is wrong
* pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
* pt-online-schema-change checks for foreign keys on MyISAM tables
* pt-query-advisor hangs on big queries
* pt-query-advisor RES.001 is incorrect
* pt-query-advisor false positive on RES.001
* pt-query-advisor issues wrong RES.001
* pt-query-digest fails to parse timestamp with no query
* pt-query-digest doesn't parse general log with "Connect user as user"
* pt-query-digest with custom --group-by throws error
* pt-query-digest prints negative byte offset
* pt-query-digest help output mangled
* pt-slave-restart CHANGE MASTER query causes error
* pt-stalk purge_samples slows down checks
* pt-stalk does not report NFS iostat
* pt-table-checksum doesn't ignore tables for --replicate-check-only
* pt-table-checksum v2 fails when --resume + --ignore-database is used
* pt-table-checksum debug statement for "Chosen hash func" prints undef
* pt-table-checksum Illegal division by zero at line 7950
* pt-table-checksum uninitialized value in numeric lt (<) at line 8611
* Tools let --set-vars clobber the required SQL mode
- also contains fixes from 2.1.7:
* pt-table-checksum 2.1.6 crashes using PTDEBUG
* pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
-------------------------------------------------------------------
Mon Nov 19 12:41:54 UTC 2012 - andreas.stieger@gmx.de
- update to 2.1.6
* pt-online-schema-change: Columns can now be renamed without data loss
* pt-online-schema-change: New --default-engine option
* pt-stalk: Plugin hooks available through the --plugin option to extend the tool's functionality
- fixing the following bugs
* --version-check default should be explicitly "off"
* LOAD DATA LOCAL INFILE broken in some platforms
* Useless use of cat in Daemon.pm
* Tools exit 0 on error parsing options, should exit non-zero
* pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
* pt-table-checksum breaks replication if a slave table is missing or different
* pt-table-checksum doesn't honor --run-time while checking replication lag
* pt-table-checksum error: Use of uninitialized value in int at line 2778
* pt-table-checksum can crash with --columns if none match
* pt-table-checksum dies if creating the --replicate table fails
* pt-table-checksum doesn't test all hash functions
* pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
* pt-deadlock-logger can't parse db/tbl/index on partitioned tables
* pt-online-schema-change DELETE trigger fails when altering primary key
* pt-online-schema-change fails if sql_mode explicitly or implicitly uses ANSI_QUOTES
* pt-online-schema-change fails with "I need a max_rows argument"
* pt-online-schema-change --quiet doesn't disable --progress
* pt-online-schema-change doesn't report how many warnings it suppressed
* pt-upgrade fails if select column > 64 chars
* pt-mysql-summary may report the wrong cnf file
* pt-mysql-summary incorrectly categorizes databases
* pt-show-grant doesn't support column-level grants
* pt-query-digest review table privilege checks don't work
* pt-query-digest docs for event attributes link to defunct Maatkit wiki
* pt-duplicate-key-checker fails when it encounters a crashed table
* pt-stalk deletes non-empty files
* pt-stalk --no-stalk and --iterations 1 don't wait for the collect
* pt-fifo-split is processing n-1 rows initially
* pt-find documentation error with mtime and InnoDB
* pt-trend output has no header
* pt-visual-explain docs link to missing pdf
* pt-fk-error-logger crashes if there's no foreign key error
* pt-fk-error-logger --dest table example doesn't work
-------------------------------------------------------------------
Sun Nov 11 13:16:38 UTC 2012 - andreas.stieger@gmx.de
- fix SLE 11 build by adding alternative perl macros
-------------------------------------------------------------------
Tue Oct 16 20:34:53 UTC 2012 - andreas.stieger@gmx.de
- update to 2.1.5
* pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB
Cluster nodes
* pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based
slaves as cluster nodes
* pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
* Missing version-check page
-------------------------------------------------------------------
Tue Oct 2 17:25:30 UTC 2012 - andreas.stieger@gmx.de
- update to 2.1.4
* pt-table-checksum: Percona XtraDB Cluster support
* pt-table-checksum: Implemented the standard --run-time option
* Implemented the version-check feature in several tools, enabled with the --version-check option
* Document gdb dependency
* Unquoted arguments to tr break the bash tools
- fixing the following Percona bugs:
* pt-diskstats shows wrong device names
* pt-duplicate-key-checker error parsing InnoDB table with no PK or unique keys
* pt-online-schema-change dropping FK limitation isn't documented
* pt-online-schema-changes fails if db+tbl name exceeds 64 characters
* pt-query-digest --type tcpdump memory usage keeps increasing
* pt-query-digest won't distill LOCK TABLES in lowercase
* pt-stalk warns about bad "find" usage
* pt-stalk df -h throws away needed details
* pt-stalk --notify-by-email fails
* pt-stalk does not get all InnoDB lock data
* pt-summary should show information about Fusion-io cards
* pt-table-checksum doesn't work if slaves use RBR
* pt-table-checksum --check-slave-lag docs aren't clear
* pt-table-checksum --defaults-file isn't used for slaves
* pt-table-sync and text columns with just whitespace
* pt-table-sync base_count fails on n = 1000, base = 10
* pt-table-sync division by zero error with varchar primary key
* pt-table-sync priv checks need to be removed
* pt-upgrade error "I need a right_sth argument"
* sh warnings in pt-summary and pt-mysql-summary
* ChangeHandler doesn't quote varchar columns with hex-looking values
* CentOS 5 yum dependency resolution for perl module is wrong
* Percona Toolkit RPM should contain a dependency on perl-Time-HiRes
-------------------------------------------------------------------
Wed Sep 5 19:24:31 UTC 2012 - andreas.stieger@gmx.de
- initial package for Percona Toolkit 2.1.3,
based on upstream spec file some OBS occurrences
- based on and replacing Maatkit, obsoleting their last release 7410