Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC 5.5.37-25.10

Milestone information

Project:
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Series:
5.5
Version:
5.5.37-25.10
Released:
 
Registrant:
Hrvoje Matijakovic
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:
1 Hrvoje Matijakovic, 6 Raghavendra D Prabhu
Blueprints:
No blueprints are targeted to this milestone.
Bugs:
91 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features

Percona XtraDB Cluster now supports stream compression/decompression with new xtrabackup-sst compressor/decompressor options.

Garbd init script and configuration files have been packaged for CentOS and Debian, in addition, in Debian garbd is packaged separately in percona-xtradb-cluster-garbd-2.x package.

New meta packages are now available in order to make the Percona XtraDB Cluster installation easier.

Debian/Ubuntu debug packages are now available for Galera and garbd.

New SST options have been implemented: inno-backup-opts, inno-apply-opts, inno-move-opts which pass options to backup, apply and move stages of innobackupex.

Initial configurable timeout, of 100 seconds, to receive a first packet via SST has been implemented, so that if donor dies somewhere in between, joiner doesn’t hang. Timeout can be configured with the sst-initial-timeout variable.

The joiner would wait and not fall back to choosing other potential donor nodes (not listed in wsrep_sst_donor) by their state. This happened even when comma was added at the end. This fixes it for that particular case.

Support for Query Cache has been implemented.

Bugs fixed

To avoid disabling Parallel Apply in case of SAVEPOINT or ROLLBACK TO SAVEPOINT the wsrep_cert_deps_distance being 1.0 at all times. Bug fixed #1277703.

First connection would hang after changing the wsrep_cluster_address variable. Bug fixed #1022250.

When gmcast.listen_addr was set manually it did not allow nodes own address in gcomm address list. Bug fixed #1099478.

wsrep_sst_rsync would silently fail on joiner when rsync server port was already taken. Bug fixed #1099783.

Example wsrep_notify script failed on node shutdown. Bug fixed #1132955.

Server would segfault on INSERT DELAYED with wsrep_replicate_myisam set to 1 due to unchecked dereference of NULL pointer. Bug fixed #1165958.

When grastate.dat file was not getting zeroed appropriately it would lead to RBR error during the IST. Bug fixed #1180791.

gcomm exception in PC validate_state_msgs() during cluster partitioning/re-merges” has been fixed. Bug fixed #1182367.

Due to the Provides: line in Percona XtraDB Cluster (which provides Percona-Server-server), the command yum install Percona-Server-server would install Percona XtraDB Cluster instead of the expected Percona Server. Bug fixed #1201499.

Replication of partition tables without binlogging enabled failed, partition truncation didn’t work because of lack of TO isolation there. Bug fixed #1219605.

Exception during group merge after partitioning event has been fixed. Bug fixed #1232747.

Default value for binlog_format is now ROW. This is done so that Percona XtraDB Cluster is not started with wrong defaults leading to non-deterministic outcomes like crash. Bug fixed #1243228.

CREATE TABLE AS SELECT was not replicated, if the select result set was empty. Bug fixed #1246921.

INSERT would return deadlock instead of duplicate key on secondary unique key collision. Bug fixed #1255147.

Joiner node would not initialize storage engines if rsync was used for SST and the first view was non-primary. Bug fixed #1257341.

Table level lock conflict resolving was releasing the wrong lock. Bug fixed #1257678.

Resolved the perl dependencies needed for Percona XtraDB Cluster 5.6. Bug fixed #1258563.

Obsolete dependencies have been removed from Percona XtraDB Cluster. Bug fixed #1259256.

GCache file allocation could fail if file size was a multiple of page size. Bug fixed #1259952.

Percona XtraDB Cluster didn’t validate the parameters of wsrep_provider_options when starting it up. Bug fixed #1260193.

Fixed rsync SST for compatibility with rsync version 3.1.0. Bug fixed #1261673.

During the installation of percona-xtradb-cluster-garbd-3.x package, Debian tries to start it, but as the configuration is not set, it would fail to start and leave the installation in iF state. Bug fixed #1262171.

Runtime checks have been added for dynamic variables which are Galera incompatible. Bug fixed #1262188.

Node would get stuck and required restart if DDL was performed after FLUSH TABLES WITH READ LOCK. Bug fixed #1265656.

xtrabackup-v2 is now used as default SST method in wsrep_sst_method. Bug fixed #1268837.

FLUSH TABLES WITH READ LOCK behavior on the same connection was changed to conform to MySQL behavior. Bug fixed #1269085.

Read-only detection has been added in clustercheck, which can be helpful during major upgrades (this is used by xinetd for HAProxy etc.) Bug fixed #1269469.

Binary log directory is now being cleanup as part of the XtraBackup SST. Bug fixed #1273368.

clustercheck script would mark node as down on Debian based systems if it was run with default values because it was looking for the defaults-extra-file in the wrong directory. Bug fixed #1276076.

Deadlock would happen when NULL unique key was inserted. Workaround has been implemented to support NULL keys, by using the md5 sum of full row as key value. Bug fixed #1276424.

Variables innodb-log-group-home-dir and innodb-data-home-dir are now handled by default (ie., there is no need to set them up in sst_special_dirs). Bug fixed #1276904.

Builds now use system Zlib instead of bundled one. Bug fixed #1277928.

Binlog events were created for the statements for non-InnoDB tables, but they were never cleaned from transaction cache, which could lead to node crash. Bug fixed #1277986.

Galera2 is now installed in /usr/lib/galera2/libgalera_smm.so with a compatibility symlink to /usr/lib/libgalera_smm.so. Bug fixed #1279328.

If transaction size exceeds the wsrep_max_ws_size limit, there will appear a warning message in the error log and replication is skipped. However, the transaction was committed in the master node, and cluster would be in inconsistent state. Bug fixed #1280557.

Updating an unique key value could cause server to hang if slave node has enabled parallel slaves. Bug fixed #1280896.

Fixed incorrect warnings and implemented better handling of repeated usage with same value for wsrep_desync. Bug fixed #1281696.

Using LOAD DATA INFILE in with autocommit set to 0 and wsrep_load_data_splitting set to ON could lead to incomplete loading of records while chunking. Bug fixed #1281810.

Garbd could crash on CentOS if variable gmcast.listen_addr wasn’t set. Bug fixed #1283100.

Node couldn’t be started with wsrep_provider_options option debug set to 1. Bug fixed #1285208.

Boostrapping with pc.bootstrap=1 at runtime in a NON-PRIMARY state would lead to crash. Bug fixed #1286450.

Asynchronous replication slave thread is stopped when the node tries to apply next replication event while the node is in non-primary state. But it would then remain stopped after node successfully re-joined the cluster. Bug fixed #1288479.

New versions of xtrabackup SST scripts were ignoring --socket parameter passed by mysqld. Bug fixed #1289483.

Regression in Galera required explicitly setting socket.ssl to Yes even if you set up variables socket.ssl_key and socket.ssl_cert. Bug fixed #1290006.

The mysql-debug UNIV_DEBUG binary was missing from RPM/DEB server packages. Bug fixed #1290087.

XtraBackup SST would fail if progress option was used with large number of files. Bug fixed #1294431.

When Query Cache was used and a node would go into non-PRIM state, queries which returned results earlier (and cached into query cache) would still return results whereas newer queries (or the ones not cached) would return unknown command. Bug fixed #1296403.

Brute Force abort did not work with INSERTs to table with single unique key. Bug fixed #1299116.

Compiling on FreeBSD 10.0 with CLANG would result in fatal error. Bug fixed #1309507.

Use-after-free memory corruption in one_thread_per_connection_end has been fixed. Bug fixed #1310875.

Xtrabackup wouldn’t copy empty test database during the SST. Bug fixed #1231088.

Xtrabackup SST failed when /tmp/test directory existed, fixed by creating unique directories in SST script. Bug fixed #1294760.

Deadlock during server shutdown has been prevented. Bug fixed #1284670.

Race condition during update of wsrep_slave_threads has been avoided. Bug fixed #1290612.

Added new option to the init script to restart a node bootstrapped. Bug fixed #1291024.

Percona XtraDB Cluster server package no longer conflicts with mysql-libs package from CentOS repository. Bug fixed #1278516.

Server abort due to BF-BF lock conflict in lock0lock.c has been fixed. Bug fixed #1264809.

Crash due to segfault in gcache::RingBuffer::get_new_buffer() has been fixed. Bug fixed #1152565.

Applier would fail with lock wait timeout exceeded on rsync SST donor. Bug fixed #1255501.

rsync SST could hang due to missing lsof. Bug fixed #1313293.

Other bugs fixed: #1273101, #1297822, #1289776, #1279844, #1279343, #1278516, #1278417, #1277263, #1276994, #1272961, #1272723, #1269811, #1269351, #1269063, #1262887, #1262716, #1261996, #1261833, #1261138, #1269063, #1256887, #1256769, #1255501, and #1254633.

0 blueprints and 91 bugs targeted

Bug report Importance Assignee Status
1277703 #1277703 5.6 cluster reports wsrep_cert_deps_distance=1.0 in all cases | Parallel Apply not working 3 High   10 Fix Released
1022250 #1022250 First connection after changing wsrep_cluster_address hangs 1 Undecided   10 Fix Released
1099478 #1099478 setting gmcast.listen_addr manually does not allow nodes own address in gcomm address list 1 Undecided   10 Fix Released
1099783 #1099783 wsrep_sst_rsync fails silently on joiner when rsync server port is already taken 1 Undecided   10 Fix Released
1132955 #1132955 Example wsrep_notify script fails on node shutdown 1 Undecided   10 Fix Released
1152565 #1152565 Segfault in gcache::RingBuffer::get_new_buffer() 1 Undecided   10 Fix Released
1165958 #1165958 Segfault on INSERT DELAYED and wsrep_replicate_myisam=1 due to unchecked dereference of NULL pointer 1 Undecided   10 Fix Released
1180791 #1180791 RBR error on IST not zeroing grastate 1 Undecided   10 Fix Released
1182367 #1182367 gcomm exception in PC validate_state_msgs() 1 Undecided   10 Fix Released
1201499 #1201499 yum install Percona-Server-server installs Percona XtraDB-Cluster 1 Undecided Raghavendra D Prabhu  10 Fix Released
1219605 #1219605 "alter table t truncate partition p2;" replicate failed 1 Undecided   10 Fix Released
1231088 #1231088 Xtrabackup SST does not copy empty test database | Bump the minimum PXB to 2.1.6 1 Undecided   10 Fix Released
1232747 #1232747 terminate called after throwing an instance of 'std::out_of_range' 1 Undecided   10 Fix Released
1242720 #1242720 Add provision for stream compression/decompression 1 Undecided Raghavendra D Prabhu  10 Fix Released
1243228 #1243228 wsrep_check_opts doesn't check for default values 1 Undecided   10 Fix Released
1246921 #1246921 CTAS with empty result set will not be replicated 1 Undecided   10 Fix Released
1248089 #1248089 Query Cache support 1 Undecided   10 Fix Released
1254633 #1254633 GPLv3 file left over after relicense 1 Undecided   10 Fix Released
1255147 #1255147 INSERT returns deadlock instead of duplicate key on secondary unique key collision 1 Undecided   10 Fix Released
1255501 #1255501 applier fails with lock wait timeout exceeded on rsync SST donor 1 Undecided   10 Fix Released
1256769 #1256769 Update the galera packaging for CentOS 1 Undecided   10 Fix Released
1256788 #1256788 Port the garbd init script to debian and package it. 1 Undecided   10 Fix Released
1256887 #1256887 Concomitant installation of galera packages 1 Undecided   10 Fix Released
1257341 #1257341 joiner does not init storage engines if rsync SST and first view is non-prim 1 Undecided   10 Fix Released
1257678 #1257678 InnoDB table lock handling problem 1 Undecided   10 Fix Released
1258563 #1258563 Account for perl dependency{-ies} for PS/PXC 1 Undecided   10 Fix Released
1259063 #1259063 OpenSSL linking exceptions need to be added 1 Undecided   10 Fix Released
1259256 #1259256 Remove obsolete dependencies in PXC 1 Undecided   10 Fix Released
1259952 #1259952 GCache file allocation may fail if file size is a multiple of page size 1 Undecided   10 Fix Released
1260193 #1260193 XtraDB cluster doesn't check the parameters of wsrep_provider_options 1 Undecided   10 Fix Released
1261138 #1261138 Patched mysqld_safe has mysqladmin 1 Undecided Raghavendra D Prabhu  10 Fix Released
1261673 #1261673 Remove uid/gid from wsrep_sst_rsync | Rsync 3.1.0 - rsync: setgroups failed: Operation not permitted 1 Undecided   10 Fix Released
1261833 #1261833 Disable version-check in PXB SST 1 Undecided   10 Fix Released
1261996 #1261996 compilation on Solaris is broken 1 Undecided   10 Fix Released
1262171 #1262171 Garbd debian init script startup issue 1 Undecided   10 Fix Released
1262188 #1262188 Add runtime checks for dynamic variables which are galera incompatible 1 Undecided   10 Fix Released
1262716 #1262716 Error "WSREP_DEBUG was not declared in this scope" while compiling on Ubuntu 13.04 1 Undecided   10 Fix Released
1262887 #1262887 regression test for lp:1100496 runs too slowly 1 Undecided   10 Fix Released
1264809 #1264809 regression test for lp:1019473 causes server abort 1 Undecided   10 Fix Released
1265656 #1265656 Node stuck when performing FLUSH TABLES WITH READ LOCK; and DDL action. 1 Undecided   10 Fix Released
1268837 #1268837 Use xtrabackup-v2 as the default wsrep_sst_method value 1 Undecided   10 Fix Released
1269063 #1269063 Make WITH_WSREP=1 default for PXC tree 1 Undecided   10 Fix Released
1269085 #1269085 FTWRL behavior on same connection 1 Undecided   10 Fix Released
1269351 #1269351 Update build dependencies for bison 1 Undecided   10 Fix Released
1269469 #1269469 Account read-only in clustercheck 1 Undecided   10 Fix Released
1269745 #1269745 Create meta-packages 1 Undecided   10 Fix Released
1269811 #1269811 Dependency on -shared package 1 Undecided   10 Fix Released
1269836 #1269836 Debian debug packages for galera 1 Undecided   10 Fix Released
1270920 #1270920 mysqld can't handle wsrep error on exceeding max writeset size 1 Undecided   10 Fix Released
1272723 #1272723 Build fails in wsrep_mysqld.h when PFS is disabled 1 Undecided   10 Fix Released
1272961 #1272961 Issue with mysql-test-run 1 Undecided   10 Fix Released
1273101 #1273101 [DOC] Installation instructions, innodb_locks_unsafe_for_binlog is deprecated and should not be used in official docs 1 Undecided Hrvoje Matijakovic  10 Fix Released
1273368 #1273368 Add logic to clean binlog directory in PXB SST 1 Undecided   10 Fix Released
1276076 #1276076 pxc xinetd issues with debian my.cnf location 1 Undecided   10 Fix Released
1276424 #1276424 Deadlock with insertion of NULL unique key 1 Undecided   10 Fix Released
1276904 #1276904 Make sst-special-dirs a default 1 Undecided   10 Fix Released
1276994 #1276994 Merge PS 5.5.35/36 with layout changes 1 Undecided Raghavendra D Prabhu  10 Fix Released
1277263 #1277263 Merge with MySQL 5.5.36 1 Undecided   10 Fix Released
1277928 #1277928 Use WITH_ZLIB=system in builds 1 Undecided   10 Fix Released
1277986 #1277986 MEMORY/MyISAM tables + binlogging OFF | Empty GRA_*_*.log file(s) with Release build | Assertion failure binlog_cache_data::finalize(THD*, Log_event*): Assertion `!flags.finalized' failed in UNIV_DEBUG build. 1 Undecided   10 Fix Released
1278417 #1278417 Implicit declaration of wsrep_* functions causes upload failure in launchpad PPA's 1 Undecided   10 Fix Released
1278516 #1278516 CentOS: mysql-libs conflict with server package and new client packages 1 Undecided   10 Fix Released
1279220 #1279220 Remove query cache restrictions 1 Undecided   10 Fix Released
1279328 #1279328 Installation prefix for multiple galera installations 1 Undecided   10 Fix Released
1279343 #1279343 [DOC] wsrep_slave_threads is one-way dynamic 1 Undecided Raghavendra D Prabhu  10 Fix Released
1279844 #1279844 Workaround for ubuntu-lucid-32bit 1 Undecided Raghavendra D Prabhu  10 Fix Released
1280557 #1280557 transaction does not rollback after max write set size was exceeded 1 Undecided   10 Fix Released
1281682 #1281682 Add a sst option to pass options to innobackupex 1 Undecided   10 Fix Released
1281696 #1281696 wsrep_desync warnings 1 Undecided   10 Fix Released
1281810 #1281810 Loss of records with LOAD DATA INFILE in 5.6 with autocommit=0 + wsrep-load-data-splitting=ON | Crashes with UNIV_DEBUG 1 Undecided   10 Fix Released
1283100 #1283100 garbd crashes on CentOS 6 1 Undecided   10 Fix Released
1284670 #1284670 deadlock on server shutdown 1 Undecided   10 Fix Released
1285208 #1285208 debug=1 is broken in galera2/3 1 Undecided   10 Fix Released
1285380 #1285380 Donor in desynced state makes the joiner wait indefinitely 1 Undecided   10 Fix Released
1286450 #1286450 Boostrapping a Node in NON-PRIMARY Crashes 1 Undecided   10 Fix Released
1288479 #1288479 Asynchronous slave thread remains stopped after node re-joins the cluster 1 Undecided   10 Fix Released
1289483 #1289483 New versions of xtrabackup SST scripts ignore --socket parameter passed by mysqld 1 Undecided   10 Fix Released
1289776 #1289776 Check for MAGIC_FILE towards the end of PXB SST 1 Undecided   10 Fix Released
1290006 #1290006 SSL disabled without socket.ssl in Galera 1 Undecided   10 Fix Released
1290087 #1290087 Provide mysqld-debug in RPM/DEB. 1 Undecided   10 Fix Released
1290612 #1290612 Issue with wsrep_slave_threads 1 Undecided   10 Fix Released
1291024 #1291024 Restart node bootstrapped in PXC 1 Undecided   10 Fix Released
1292991 #1292991 Add initial-timeout to SST 1 Undecided   10 Fix Released
1294431 #1294431 cluster SST fail - /usr/bin/du: Argument list too long 1 Undecided   10 Fix Released
1294760 #1294760 xtrabackup SST fails if /tmp/test directory exists 1 Undecided   10 Fix Released
1296403 #1296403 Query cache should be invalidated in non-PRIMARY 1 Undecided   10 Fix Released
1297822 #1297822 RHEL/Centos Server packages that conflict with mysql-libs should require a suitable replacement 1 Undecided   10 Fix Released
1299116 #1299116 BF abort does not work with inserts to table with single unique key 1 Undecided   10 Fix Released
1309507 #1309507 Compile fails on FreeBSD ENOTREOVERABLE macro redefined 1 Undecided   10 Fix Released
1310875 #1310875 Valgrind: Use-after-free in one_thread_per_connection_end 1 Undecided   10 Fix Released
1313293 #1313293 rsync SST - add check for lsof and adjust package dependencies 1 Undecided   10 Fix Released
This milestone contains Public information
Everyone can see this information.