Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC 5.5.39-25.11

Milestone information

Project:
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Series:
5.5
Version:
5.5.39-25.11
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 Alexey Kopytov
Blueprints:
No blueprints are targeted to this milestone.
Bugs:
35 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features

New session variable wsrep_sync_wait has been implemented to control causality check. The old session variable wsrep_causal_reads is deprecated but is kept for backward compatibility (#1277053).

systemd integration with RHEL/CentOS 7 is now available for Percona XtraDB Cluster (#1342223).

Bugs fixed

Percona XtraDB Cluster has implemented threadpool scheduling fixes. Bug fixed #1333348.

When gmcast.listen_addr was configured to a certain address, local connection point for outgoing connections was not bound to listen address. This would happen if OS has multiple interfaces with IP addresses in the same subnet, it may happen that OS would pick wrong IP for local connection point and other nodes would see connections originating from IP address which was not listened to. Bug fixed #1240964.

Client connections were closed unconditionally before generating SST request. Fixed by avoiding closing connections when wsrep is initialized before storage engines. Bug fixed #1258658.

Issue with re-setting galera provider (in wsrep_provider_options) has been fixed. Bug fixed #1260283.

Variable wsrep_provider_options couldn’t be set in runtime if no provider was loaded. Bug fixed #1260290.

Node consistency issues with foreign keys have been fixed. This fix introduces two new variables: wsrep_slave_FK_checks and wsrep_slave_UK_checks. These variables are set to TRUE and FALSE respectively by default. They control whether Foreign Key and Unique Key checking is done for applier threads. (#1260713).

When FLUSH TABLES WITH READ LOCK was used on a node with wsrep_causal_reads set to 1 while there was a DML on other nodes then, subsequent SELECTs/SHOW STATUS didn’t hang earlier providing non-causal output, that has been fixed here. Bug fixed #1271177.

Lowest group communication layer (evs) would fail to handle the situation properly when big number of nodes would suddenly start to see each other. Bugs fixed #1271918 and #1249805.

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

Fixed the events replication inconsistencies. Bug fixed #1312618.

Truncating the sorted version of multi-byte character conversion could lead to wsrep certification failures. Bug fixed #1314854.

wsrep_slave_threads was counted towards max_connections which could cause ERROR 1040 (HY000): Too many connections error. Bug fixed #1315588.

Leaving node was not set nonoperational if processed leave message originated from different view than the current one which could cause other nodes to crash. Bug fixed #1323412 (#41).

garb couldn’t be started with init script on RHEL 6.5. Bug fixed #1323652.

SST would fail when binlogs were in dedicated directory that’s located inside datadir. This bug was a regression introduced by bug fix for #1273368. Bug fixed #1326012.

GTID of TOI operations is now also synced to InnoDB tablespace in order to get consistent backups. Bug fixed #1329055.

mysql-debug (UNIV_DEBUG) is now distributed with binary tar.gz along with RPM and DEB packages. Bug fixed #1332073.

Startup failure with Undetected state gap has been fixed. Bug fixed #1334606.

The restart sequence in scripts/mysql.server would fail to capture and return if the start call failed to start the server, so a restart could occur that failed upon start-up, and the script would still return 0 as if it worked without any issues. Bug fixed #1339894.

wsrep consistency check is now enabled for REPLACE ... SELECT as well. This was implemented because pt-table-checksum uses REPLACE .. SELECT during checksumming. Bug fixed #1343209.

A memory leak in wsrep_mysql_parse function has been fixed. Bug fixed #1345023.

SHOW STATUS was generating debug output in the error log. Bug fixed #1347818.

The netcat in garbd init script has been replaced with nmap for compatibility in CentOS 7. Bug fixed #1349384.

Fixed netcat in SST script for CentOS 7 nmap-ncat. Bug fixed #1359767.

percona-xtradb-cluster-garbd-3.x package was installed incorrectly on Debian/Ubuntu. Bugs fixed #1360633 and #1334530.

Other bugs fixed: #1334331, #1338995, #1280270, #1272982, #1190774, and #1251765.

0 blueprints and 35 bugs targeted

Bug report Importance Assignee Status
1260283 #1260283 Issues with re-setting the provider 3 High   10 Fix Released
1271177 #1271177 FTWRL and wsrep_causal_reads with 'show status' 3 High   10 Fix Released
1272982 #1272982 Failures in conf17 test with xbstream 3 High   10 Fix Released
1312618 #1312618 Replication of events is not consistent with MySQL 3 High   10 Fix Released
1314854 #1314854 unavoidable wsrep certification failures with character unique key 3 High   10 Fix Released
1323412 #1323412 Primary node leaving the cluster causes other nodes to crash 3 High   10 Fix Released
1323652 #1323652 /etc/init.d/garb fails on RHEL 6.5 3 High   10 Fix Released
1329055 #1329055 update wsrep position in innodb also for TOI 3 High   10 Fix Released
1334331 #1334331 lp:1312618: follow up patch to fix a segfault 3 High   10 Fix Released
1334530 #1334530 Percona XtraDB Cluster Garbd wrong Init Script 3 High   10 Fix Released
1334606 #1334606 Undetected state gap. Can't continue. 3 High   10 Fix Released
1190774 #1190774 Issue at shutdown: Error in my_thread_global_end(): 2 threads didn't exit 4 Medium   10 Fix Released
1240964 #1240964 gmcast does not bind outgoing connections to listen addr 4 Medium   10 Fix Released
1249805 #1249805 Whole Cluste become NOT-Primary after ASIO issue on a node 4 Medium   10 Fix Released
1251765 #1251765 Donor asserts when SST script fails due to joiner misconfiguration 4 Medium   10 Fix Released
1260290 #1260290 wsrep_provider_options can't be set in runtime if no provider is loaded 4 Medium   10 Fix Released
1260713 #1260713 Node consistency issues with foreign key grammar 4 Medium   10 Fix Released
1271918 #1271918 Lowest group communication layer (evs) fails to handle the situation properly when big number of nodes suddenly start to see each other 4 Medium   10 Fix Released
1315588 #1315588 wsrep-slave-threads is counted towards max_connections 4 Medium   10 Fix Released
1326012 #1326012 SST fails when binlogs are in dedicated directory that's located inside datadir 4 Medium   10 Fix Released
1332073 #1332073 mysqld-debug with binaries 4 Medium   10 Fix Released
1339894 #1339894 scripts/mysql.server fails to return 1 if restart fails to start 4 Medium   10 Fix Released
1333348 #1333348 threadpool UNIV_DEBUG | void remove_global_thread(THD*): Assertion `thd->release_resources_done()' failed 5 Low Alexey Kopytov  10 Fix Released
1338995 #1338995 Init script should say 'State Transfer is in progress' instead of 'SST is in progress' 5 Low   10 Fix Released
1258658 #1258658 client connections are closed unconditionally before generating SST request 1 Undecided   10 Fix Released
1277053 #1277053 Add optional causality check to autocommit UPDATE/DELETE statements 1 Undecided   10 Fix Released
1280270 #1280270 mysql_tzinfo_to_sql generates "'wsrep_replicate_myisam' is a GLOBAL variable" error 1 Undecided   10 Fix Released
1280896 #1280896 updating a unique key can cause parallel applying to hang 1 Undecided   10 Fix Released
1342223 #1342223 systemd unit files for rhel/centos7 1 Undecided   10 Fix Released
1343209 #1343209 wsrep_consistency_check only handled on SQLCOM_INSERT_SELECT 1 Undecided   10 Fix Released
1345023 #1345023 Valgrind issue 1 Undecided   10 Fix Released
1347818 #1347818 SHOW STATUS generates debug output in error log 1 Undecided   10 Fix Released
1349384 #1349384 garb: nc: invalid option -- 'z' on centos 7 1 Undecided   10 Fix Released
1359767 #1359767 netcat issue with SST script 1 Undecided   10 Fix Released
1360633 #1360633 Issue with garbd packaging 1 Undecided   10 Fix Released
This milestone contains Public information
Everyone can see this information.