Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC 5.5.30-23.7.4

Milestone information

Project:
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Series:
5.5
Version:
5.5.30-23.7.4
Released:
 
Registrant:
Raghavendra D Prabhu
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 Alexey Bychko, 2 Ignacio Nin, 9 Raghavendra D Prabhu
Blueprints:
No blueprints are targeted to this milestone.
Bugs:
39 Fix Released

Download files for this release

File Description Downloads

Release notes 

Percona is glad to announce the release of Percona XtraDB Cluster on April 16th, 2013. Binaries are available from downloads area or from our software repositories.

This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our bug tracking system.
New Features

    Percona XtraDB Cluster has implemented initial implementation of weighted quorum. Weight for node can be assigned via pc.weight option in the wsrep_provider_options variable. Accepted values are in the range [0, 255] (inclusive). Quorum is computed using weighted sum over group members.

    Percona XtraDB Cluster will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost.

    This release of Percona XtraDB Cluster has fixed number of foreign key and packaging bugs.

Bugs fixed

    Fixed yum dependencies that were causing conflicts in CentOS 6.3 during installation. Bug fixed #1031427 (Ignacio Nin).

    In case the Percona XtraDB Cluster was built from the source rpm, wsrep revision information would be missing. Bug fixed #1128906 (Alexey Bychko).

    The method of generating md5 digest over tuples in a table with no primary key was not deterministic and this could cause a node failure. Bug fixed #1019473 (Seppo Jaakola).

    Percona XtraDB Cluster was built with YaSSL which could cause some of the programs that use it to crash. Fixed by building packages with OpenSSL support rather than the bundled YaSSL library. Bug fixed #1104977 (Raghavendra D Prabhu).

    Clustercheck script would hang in case the MySQL server on a node is hung. As a consequence clustercheck script would never fail-over that server. Bug fixed #1035927 (Raghavendra D Prabhu).

    High values in variables evs.send_window and evs.user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka).

    Standard MySQL port would be used when port number isn’t explicitly defined in the wsrep_node_incoming_address. Bug fixed #1082406 (Alex Yurchenko).

    Dropping a non-existing temporary table would be replicated when TOI was used in wsrep_OSU_method variable. This bug was fixed for the case when DROP TEMPORARY TABLE statement was used, but it will still replicate in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo Jaakola).

    In case two nodes in a 3-node cluster had to abort due to inconsistency, one wouldn’t correctly notify the surviving node which would lead to surviving node to loose the primary component and cause subsequent downtime. Bug fixed #1108165 (Alex Yurchenko).

    In some cases non-uniform foreign key reference could cause a slave crash. Fixed by using primary key of the child table when appending exclusive key for cascading delete operation. Bug fixed #1089490 (Seppo Jaakola).

    Parallel applying would fail in case mixed CHAR and VARCHAR columns would be used in foreign key definitions. Bug fixed #1100496 (Seppo Jaakola).

    Debian packages included the old version of innotop. Fixed by removing innotop and its InnoDBParser Perl package from source and Debian installation. Bug fixed #1032139 (Alexey Bychko).

    The mysqld_safe script would fail to retrieve the galera replication position on Ubuntu 10.04, because the different shell was used. Bug fixed #1108431 (Alex Yurchenko).

    Cascading foreign key constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola).

    If MySQL replication threads were started before running wsrep recovery, this would lead to memory corruption and server crash. Bug fixed #1132974 (Seppo Jaakola).

    Conflicting prepared statements in multi-master use case could cause node to hang. This was happening due to prepared statement execution loop, which does not honor wsrep status codes correctly. Bug fixed #1144911 (Seppo Jaakola).

    State Snapshot Transfer with XtraBackup would fail if the tmpdir was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu).

    Issues with compiling Galera on the ARM architecture has been fixed. Bug fixed #1133047 (Alex Yurchenko).

    Upstream bugfix for bug #59354 triggered a regression that could cause transaction conflicts. Bug fixed #1158221 (Seppo Jaakola).

    Galera builds would fail when they were built with the new boost library. Bug fixed #1131736 (Alex Yurchenko).

    Folder lost+found wasn’t included in the rsync SST filter, which caused the SST failure due to insufficient privileges. Fixed by excluding lost+found folder if found. Bug fixed #1154095 (Alex Yurchenko).

    If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements, a cluster node could remain hanging for unresolved MDL conflict. Fixed by adding a new method to cancel a thread waiting for InnoDB concurrency. Bug fixed #1155183 (Seppo Jaakola).

    Handling of the network issues in Galera has been improved. Bug fixed #1153727 (Teemu Ollakka).

    Fixed the wrong path in the /etc/xinetd.d/mysqlchk script. Bugs fixed #1000761 and #1132934 (Raghavendra D Prabhu).

    When upgrading the Percona-XtraDB-Cluster-server package, /usr/bin/clustercheck would get overwritten, and any changes (such as username and password) would be lost. Bug fixed #1158443 (Raghavendra D Prabhu).

    In case CREATE TABLE AS SELECT statement was running in parallel with the DDL statement on the selected table, in some cases first statement could be left hanging. Bug fixed #1164893 (Seppo Jaakola).

    Galera builds would fail when gcc 4.8 was used. Bug fixed #1164992 (Alex Yurchenko).

    Percona-XtraDB-Cluster-galera package version number didn’t match the wsrep_provider_version one. Bug fixed #1111672 (Alexey Bychko).

    Only rpm debug build was available for Percona XtraDB Cluster, fixed by providing the deb debug build as well. Bug fixed #1096123 (Ignacio Nin).

Other bug fixes: bug fixed #1162421 (Seppo Jaakola), bug fixed #1093054 (Alex Yurchenko), bug fixed #1166060 (Teemu Ollakka), bug fixed #1166065 (Teemu Ollakka).

Based on Percona Server 5.5.30-30.2 including all the bug fixes in it and on Codership wsrep API 5.5.30-23.7.4, Percona XtraDB Cluster 5.5.30-23.7.4 is now the current stable release. All of Percona‘s software is open-source and free.

Changelog 

This release does not have a changelog.

0 blueprints and 39 bugs targeted

Bug report Importance Assignee Status
1000761 #1000761 mysqlchk xinetd config incorrectly refers to /usr/local/bin/clustercheck instead of /usr/bin/clustercheck 3 High Raghavendra D Prabhu  10 Fix Released
1031427 #1031427 Painful Yum dependencies on CentOS6.3 3 High Ignacio Nin  10 Fix Released
1111672 #1111672 Percona-XtraDB-Cluster-galera package version # should match the wsrep_provider_version 4 Medium Raghavendra D Prabhu  10 Fix Released
1128906 #1128906 empty wsrep version if PXC built from source rpm 4 Medium Alexey Bychko  10 Fix Released
1096123 #1096123 Separate debian debug package not available 6 Wishlist Ignacio Nin  10 Fix Released
1010225 #1010225 Implement weighted quorum 1 Undecided   10 Fix Released
1019473 #1019473 Simultanious Crash of two nodes 1 Undecided   10 Fix Released
1032139 #1032139 debian packages include outdated innotop 1 Undecided   10 Fix Released
1035927 #1035927 clustercheck hangs when server is hung 1 Undecided Raghavendra D Prabhu  10 Fix Released
1080539 #1080539 cluster crash and can't normal shutdown under very high loads 1 Undecided   10 Fix Released
1082406 #1082406 An explicitly set wsrep_node_incoming_address may make SHOW STATUS LIKE 'wsrep_incoming_addresses' return a portless address 1 Undecided   10 Fix Released
1084702 #1084702 dropping a non-existing temporary table will be replicated 1 Undecided   10 Fix Released
1086978 #1086978 xtrabackup donor runs xtrabackup indefinitely when xtrabackup tmpdir on tmpfs 1 Undecided   10 Fix Released
1089490 #1089490 non-uniform FK reference can cause slave crash 1 Undecided   10 Fix Released
1093054 #1093054 2.4 chores 1 Undecided   10 Fix Released
1099774 #1099774 Ship server with libjemalloc 1 Undecided   10 Fix Released
1100496 #1100496 mixed CHAR and VARCHAR columns in foreign key definition makes parallel applying fail 1 Undecided   10 Fix Released
1104977 #1104977 Percona Server is still built with yaSSL 1 Undecided Raghavendra D Prabhu  10 Fix Released
1108165 #1108165 Node fails to gracefully leave the cluster 1 Undecided   10 Fix Released
1108431 #1108431 wsrep-recover fails in mysqld_safe, Ubuntu (dash) 1 Undecided   10 Fix Released
1130888 #1130888 cascading FK constraint can cause slave hanging 1 Undecided   10 Fix Released
1131102 #1131102 Provide SELinux/AppArmor policy for Percona-Server/PXC 1 Undecided Raghavendra D Prabhu  10 Fix Released
1131736 #1131736 Build fails with new boost library 1 Undecided   10 Fix Released
1132934 #1132934 xinetd mysqlchk contains bad clustercheck path 1 Undecided Raghavendra D Prabhu  10 Fix Released
1132974 #1132974 wsrep_recover processing conflicts with native replication threads 1 Undecided   10 Fix Released
1133047 #1133047 Can't build galera on ARM architecture 1 Undecided   10 Fix Released
1144911 #1144911 Prepared statements can cause node hanging 1 Undecided   10 Fix Released
1153727 #1153727 Graceful handling of possible network issues 1 Undecided   10 Fix Released
1154095 #1154095 rsync SST filter may include lost+found directory 1 Undecided   10 Fix Released
1155183 #1155183 innodb_thread_conccurrency limit can cause node stalling 1 Undecided   10 Fix Released
1158221 #1158221 trx tries to abort slave trx 1 Undecided   10 Fix Released
1158443 #1158443 /usr/bin/clustercheck gets overwritten on upgrade 1 Undecided Raghavendra D Prabhu  10 Fix Released
1160047 #1160047 xtrabackup sst fails if tmpdir is specified more than once in my.cnf 1 Undecided Raghavendra D Prabhu  10 Fix Released
1162421 #1162421 CTAS processing can assert with debug build 1 Undecided   10 Fix Released
1164893 #1164893 CTAS conflict with DDL can cause node hanging 1 Undecided   10 Fix Released
1164960 #1164960 Merge with PS 5.5.30.2 1 Undecided Raghavendra D Prabhu  10 Fix Released
1164992 #1164992 Galera build fails with gcc 4.8 1 Undecided   10 Fix Released
1166060 #1166060 sst_donate_other returns bad error code if pthread_create() fails 1 Undecided   10 Fix Released
1166065 #1166065 error code from sst_donate_cb_ is not handled 1 Undecided   10 Fix Released
This milestone contains Public information
Everyone can see this information.