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

Milestone information

Project:
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Series:
5.5
Version:
5.5.41-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:
4 Alexey Kopytov, 10 Hrvoje Matijakovic, 11 Raghavendra D Prabhu
Blueprints:
No blueprints are targeted to this milestone.
Bugs:
37 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

BUGS FIXED

XtraBackup SST wouldn’t stop when MySQL was SIGKILLed. This would prevent MySQL to initiate a new transfer as port 4444 was already utilized. Bug fixed #1380697.

garbd was returning incorrect return code, ie. when garbd was already started, return code was 0. Bugs fixed #1308103 and #1422863.

wsrep_sst_xtrabackup-v2 script was causing innobackupex to print a false positive stack trace into the log. Bug fixed #1407599.

MyISAM DDL (CREATE TABLE only) isn’t replicated anymore when wsrep_replicate_myisam is OFF. Note, for older nodes in the cluster, wsrep_replicate_myisam should work since the TOI decision (for MyISAM DDL) is done on origin node. Mixing of non-MyISAM and MyISAM tables in the same DDL statement is not recommended with wsrep_replicate_myisam OFF since if any table in list is MyISAM, the whole DDL statement is not put under TOI (total order isolation). This also doesn’t work if default_storage_engine is set to MyISAM (which is not recommended for Percona XtraDB Cluster) and a table is created without the ENGINE option. Bug fixed #1402338.

Percona XtraDB Cluster now shows a warning in case additional utilities, like pv which may not affect critical path of SST, are not installed. Bug fixed #1248688.

wsrep_causal_reads variable was not honored when declared as global. Bug fixed #1361859.

garbd would not work when cluster address was specified without the port. Bug fixed #1365193.

garbd was running as root user on Debian. Bug fixed #1392388.

Errors in garbd init script stop/start functions have been fixed. Bug fixed #1367956.

If mysqld gets killed during the SST it will leave an unclean data directory behind. This would cause Percona XtraDB Cluster to fail when the server would be started next time because the data directory would be corrupted. This was fixed by resuming the startup in case wsrep-recover failed to recover due to corrupted data directory. The old behavior is still achievable through --exit-on-recover-fail command line parameter to mysqld_safe or exit-on-recover-fail under [mysqld_safe] in my.cnf. Bug fixed #1378578.

gvwstate.dat file was removed on joiner when XtraBackup SST method was used. Bug fixed #1388059.

xtrabackup-v2 SST did not clean the undo log directory. Bug fixed #1394836.

stderr of SST/Innobackupex is logged to syslog with appropriate tags if sst-syslog is in [sst] or [mysqld_safe] has syslog in my.cnf. This can be overridden by setting the sst-syslog to -1 in [sst]. Bug fixed #1399134.

clustercheck can now check if the node is PRIMARY or not, to allow for synced nodes which go out of PRIMARY not to take any writes/reads. Bug fixed #1403566.

Race condition between donor and joiner in Xtrabackup SST Configuration has been fixed. This caused XtraBackup SST to fail when joiner took longer to spawn the second listener for SST. Bug fixed #1405668.

SST will now fail early if the xtrabackup_checkpoints file is missing on the joiner side. Bug fixed #1405985.

socat utility was not properly terminated after a timeout. Bug fixed #1409710.

10 seconds timeout in Xtrabackup SST Configuration script was not enough for the joiner to delete existing files before it started the socat receiver on systems with big datadir. Bug fixed #1413879.

Conflict between enforce_storage_engine and wsrep_replicate_myisam for CREATE TABLE has been fixed. Bug fixed #1435482.

SST processes are now spawned with fork/exec instead of posix_spawn to allow for better cleanup of child processes in event of non-graceful termination (SIGKILL or a crash etc.). Bug fixed #1382797.

Variable length arrays in WSREP code were causing debug builds to fail. Bug fixed #1409042.

Signal handling in mysqld has been fixed for SST processes. Bug fixed #1399175.

Inserts to a table with autoincrement primary key could result in duplicate key error if another node joined or dropped from the cluster during the insert processing. Bug fixed #1366997.

Other bugs fixed: #1391634 and #1396757.

0 blueprints and 37 bugs targeted

Bug report Importance Assignee Status
1275814 #1275814 Required query-cache config changes missing 3 High Hrvoje Matijakovic  10 Fix Released
1292534 #1292534 Doc: Installation steps should describe how to overcome package conflicts with common distros 3 High Hrvoje Matijakovic  10 Fix Released
1253055 #1253055 wsrep_load_data_splitting variable is missing description 4 Medium Hrvoje Matijakovic  10 Fix Released
1380697 #1380697 wsrep_sst_xtrabackup-v2 doesn't stop when mysql is SIGKILLed 4 Medium Raghavendra D Prabhu  10 Fix Released
1382797 #1382797 Modify SST code to use fork()/exec() to allow cleanup on fatal signals 4 Medium Alexey Kopytov  10 Fix Released
1409042 #1409042 Variable length arrays in WSREP code 4 Medium Alexey Kopytov  10 Fix Released
1308103 #1308103 Return code incorrect when garbd is already running 5 Low   10 Fix Released
1399175 #1399175 Incorrect POSIX_SPAWN_SETSIGDEF usage in wsrep_utils.cc 5 Low Alexey Kopytov  10 Fix Released
1407599 #1407599 wsrep_sst_xtrabackup-v2 script causes innobackupex to print a false positive stack trace into the log 5 Low Raghavendra D Prabhu  10 Fix Released
1402338 #1402338 Don't replicate MyISAM DDL (CREATE/DROP) when wsrep-replicate-myisam is OFF 6 Wishlist Raghavendra D Prabhu  10 Fix Released
1248688 #1248688 Soft failure/warning on SST dependencies 1 Undecided   10 Fix Released
1259649 #1259649 Document the key/value pairs of wsrep_provider_options 1 Undecided Hrvoje Matijakovic  10 Fix Released
1292533 #1292533 Doc: Installation page should describe any additional dependencies needed for common distros 1 Undecided Hrvoje Matijakovic  10 Fix Released
1292535 #1292535 Doc: FAQ should explain health checking better 1 Undecided Hrvoje Matijakovic  10 Fix Released
1361859 #1361859 global.wsrep_causal_reads no longer honored 1 Undecided   10 Fix Released
1362152 #1362152 Multi-master diagram is incorrect in manual 1 Undecided Hrvoje Matijakovic  10 Fix Released
1365193 #1365193 garbd does not work when specifying cluster address without the port 1 Undecided   10 Fix Released
1366997 #1366997 Duplicate entry error for primary key following cluster size change 1 Undecided Alexey Kopytov  10 Fix Released
1367956 #1367956 Garbd - errors in init script stop/start functions 1 Undecided   10 Fix Released
1370458 #1370458 [DOC] wsrep_desync description needs improving 1 Undecided Hrvoje Matijakovic  10 Fix Released
1378578 #1378578 Resume mysqld startup in case wsrep-recover fails 1 Undecided   10 Fix Released
1388059 #1388059 Xtrabackup SST clobbers the gvwstate.dat file on a Joiner 1 Undecided   10 Fix Released
1391634 #1391634 Restart logic with systemd 1 Undecided   10 Fix Released
1392369 #1392369 wsrep_cluster_address is dynamic, but our documentation says it is not 1 Undecided Hrvoje Matijakovic  10 Fix Released
1392388 #1392388 garbd runs as root on debian 1 Undecided   10 Fix Released
1394836 #1394836 sst xtrabackup-v2 did not clean undo log dir 1 Undecided   10 Fix Released
1396757 #1396757 rhel7 / systemd -- killing mysqld causes lingering systemd processes 1 Undecided   10 Fix Released
1399134 #1399134 Log the innobackupex/SST logs in SST to syslog if possible 1 Undecided Raghavendra D Prabhu  10 Fix Released
1403566 #1403566 Check for primary in clustercheck 1 Undecided Raghavendra D Prabhu  10 Fix Released
1405668 #1405668 Race condition between donor and joiner in PXB SST 1 Undecided Raghavendra D Prabhu  10 Fix Released
1405985 #1405985 Fail early if xtrabackup_checkkpoints is missing 1 Undecided Raghavendra D Prabhu  10 Fix Released
1409710 #1409710 wsrep_xtrabackup_sst-v2 sst-initial-timeout doesn't work when 'timeout -k' is unsupported 1 Undecided Raghavendra D Prabhu  10 Fix Released
1413247 #1413247 PXC manual doesn't cover all wsrep_provider_options 1 Undecided Hrvoje Matijakovic  10 Fix Released
1413879 #1413879 wsrep_sst_xtrabackup-v2 script, longer sleep needed before SST 1 Undecided Raghavendra D Prabhu  10 Fix Released
1415722 #1415722 PXC 5.5 is not available for Ubuntu 14.10 1 Undecided   10 Fix Released
1422863 #1422863 garbd service status always returns 0, breaking puppet 1 Undecided Raghavendra D Prabhu  10 Fix Released
1435482 #1435482 enforce_storage_engine=Innodb not compatible with wsrep_replicate_myisam 1 Undecided Raghavendra D Prabhu  10 Fix Released
This milestone contains Public information
Everyone can see this information.