Percona XtraDB Cluster - HA scalable solution for MySQL

Percona XtraDB Cluster 5.6.14-25.1

PXC 5.6

Milestone information

Project:
Percona XtraDB Cluster
Series:
5.6
Version:
5.6.14-25.1
Released:
2013-11-21  
Registrant:
Hrvoje Matijakovic
Release registered:
2013-11-22
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:
11 Raghavendra D Prabhu
Blueprints:
No blueprints are targeted to this milestone.
Bugs:
83 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features

Percona XtraDB Cluster is now using Galera Replicator 3.1 and wsrep API 5.6.14-25.1.

Percona XtraDB Cluster has implemented a number of XtraDB performance improvements for I/O-bound high-concurrency workloads.

Percona XtraDB Cluster has implemented a number of performance improvements for Page cleaner thread tuning.

ALL_O_DIRECT method for innodb_flush_method has been ported from 5.5 version.

Statement Timeout feature has been ported from the Twitter branch.

Percona XtraDB Cluster has extended the SELECT INTO ... OUTFILE and SELECT INTO DUMPFILE to add the support for UNIX sockets and named pipes.

Percona XtraDB Cluster has implemented more efficient log block checksums with new innodb_log_checksum_algorithm variable.

Percona XtraDB Cluster now supports Per-query variable statements.

Limited support for Query Cache has been implemented. Query cache cannot still be fully enabled during the startup. To enable query cache, mysqld should be started with query_cache_type=1 and query_cache_size=0 and then query_cache_size should be changed to desired value during runtime.

RPM packages are now made relocatable which means they now support installation to custom prefixes.

Bugs fixed

Some wsrep variables (wsrep_provider, wsrep_provider_options, wsrep_cluster_address...) could be “doubly” allocated which caused memory leaks. Bug fixed #1072839.

If SELECT FOR UPDATE... query was aborted due to multi-master conflict, the client wouldn’t get back the deadlock error. From client perspective the transaction would be successful. Bug fixed #1187739.

Temporary tables are not replicated, but any DDL on those tables were, which would generates error messages on other nodes. Bugs fixed #1194156, #1084702, #1212247.

When setting the gcache.size to a larger value than the default 128M, the mysql service command did not allow enough time for the file to be preallocated. Bug fixed #1207500.

When installing first Percona-XtraDB-Cluster-client and then Percona-XtraDB-Cluster-server on two single statements or a single statement with both packages , yum would install percona-xtrabackup-20 instead percona-xtrabackup package as dependency of Percona-XtraDB-Cluster-server. Bug fixed #1226185.

Different mutex implementation in the 5.6 could lead to server assertion error. Bug fixed #1233383.

Enabling wsrep_log_conflicts variable could cause issues with lock_mutex. Bug fixed #1234382.

Server could freeze with mixed DML/DDL load because TOI brute force aborts were not properly propagated. Bug fixed #1239571.

CREATE TABLE AS SELECT would fail with explicit temporary tables, when binlogging was enabled and autocommit was set to 0. Bug fixed #1240098.

Transaction cleanup function did not get called for autocommit statements after rollback, it would stay in LOCAL_COMMIT even after rollback finished which caused problems when the next transaction started. Bug fixed #1240567.

DDL statements like CREATE TEMPORARY TABLE LIKE would be replicated and applied in all cluster nodes. This caused temporary table definitions to pile up in slave threads. Bug fixed #1246257.

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

Write set flags defined in wsrep API are now exposed to application side appliers too. Bug fixed #1247402.

Local brute force aborts are counted accurately. Bug fixed #1247971.

Certain combinations of transaction rollbacks could leave stale transactional MDL locks. Bug fixed #1247978.

After turning UNIV_SYNC_DEBUG on, node that was started from clean state would crash immediately at startup. Bug fixed #1248908.

Server built with UNIV_SYNC_DEBUG would assert if SQL load has DELETE statements on tables with foreign key constraints with ON DELETE CASCADE option. Bug fixed #1248921.

Xtrabackup SST dependencies have been added as Optional/Recommended/Suggested dependencies. Bug fixed #1250326.

Other bugs fixed: bug fixed #1020457, bug fixed #1250865, bug fixed #1249753, bug fixed #1248396, bug fixed #1247980, bug fixed #1238278, bug fixed #1234421, bug fixed #1228341, bug fixed #1228333, bug fixed #1225236, bug fixed #1221354, bug fixed #1217138, bug fixed #1206648, bug fixed #1200647, bug fixed #1180792, bug fixed #1163283, bug fixed #1234229, bugs fixed #1250805, bug fixed #1233301, and bug fixed #1210509.

0 blueprints and 83 bugs targeted

Bug report Importance Assignee Status
1244100 #1244100 use of uninitialized vale in MYSQL_BIN_LOG::write() 3 High   10 Fix Released
1250805 #1250805 getaddrinfo failure 3 High   10 Fix Released
587170 #587170 Adding AUTO_INCREMENT column to a table results in data inconsistency 1 Undecided   10 Fix Released
812059 #812059 Set FD_CLOEXEC flag on all mysqld file descriptors by default 1 Undecided   10 Fix Released
1012138 #1012138 set gcs.fc_master_slave=YES gives error 1 Undecided   10 Fix Released
1020457 #1020457 implement WSREP_APPLIER_CLOSING return in apply_cb 1 Undecided   10 Fix Released
1072839 #1072839 memory leaks with wsrep variables 1 Undecided   10 Fix Released
1084309 #1084309 Dependency Conflict between Percona-XtraDB-Cluster-shared and Percona-Server-shared-compat 1 Undecided Raghavendra D Prabhu  10 Fix Released
1084702 #1084702 dropping a non-existing temporary table will be replicated 1 Undecided   10 Fix Released
1088267 #1088267 attempt to kill slave thread can cause server hanging 1 Undecided   10 Fix Released
1108035 #1108035 PXC innodb_buffer_pool_restore_at_startup and wsrep_recovery 1 Undecided   10 Fix Released
1109341 #1109341 Improve thread status visibility in PXC 1 Undecided Raghavendra D Prabhu  10 Fix Released
1112363 #1112363 Problems with debian upgrade 1 Undecided   10 Fix Released
1129512 #1129512 Preferred SST Donors List 1 Undecided   10 Fix Released
1134892 #1134892 Standalone 5.5.29 wsrep_23.7.2.r3843 server crash at rem0rec.c line 564 1 Undecided   10 Fix Released
1158221 #1158221 trx tries to abort slave trx 1 Undecided   10 Fix Released
1162421 #1162421 CTAS processing can assert with debug build 1 Undecided   10 Fix Released
1163283 #1163283 message relay requesting goes on/off with multicast 1 Undecided   10 Fix Released
1167368 #1167368 ifconfig does not detect wsrep_node_address correctly on german debian installation 1 Undecided   10 Fix Released
1180792 #1180792 wsrep_flow_control_sent/recv not a global counter? 1 Undecided   10 Fix Released
1185523 #1185523 PXC nodes hang on shutdown when using pool-of-threads 1 Undecided   10 Fix Released
1187526 #1187526 trx_commit_for_mysql() called twice in innobase_commit_low() 1 Undecided   10 Fix Released
1187739 #1187739 SELECT FOR UPDATE query will not return deadlock error if BF aborted 1 Undecided   10 Fix Released
1194156 #1194156 TRUNCATE TEMPORARY table is replicated 1 Undecided   10 Fix Released
1200647 #1200647 MySQL 5.6 integration issues 1 Undecided   10 Fix Released
1206129 #1206129 LOAD DATA INFILE not replicating properly in cluster 1 Undecided   10 Fix Released
1206648 #1206648 percona 5.6 install on debian fails due to default config reference to /etc/mysql/conf.d 1 Undecided   10 Fix Released
1207500 #1207500 mysql service script does not allow enough time for preallocation of a large gcache.size 1 Undecided Raghavendra D Prabhu  10 Fix Released
1210509 #1210509 Protocol::end_statement(): Assertion `0' failed 1 Undecided   10 Fix Released
1212247 #1212247 CREATE TABLE t LIKE <temporary table> 1 Undecided   10 Fix Released
1212955 #1212955 Server deadlock while DDL 1 Undecided   10 Fix Released
1216805 #1216805 Excessive conflicts in FK parent table 1 Undecided   10 Fix Released
1216904 #1216904 mtr test main.merge fails 1 Undecided   10 Fix Released
1217138 #1217138 Assertion `pfs_thread->m_events_statements_count == 0' failed in 5.6 branch 1 Undecided   10 Fix Released
1219856 #1219856 Status for TOI threads 1 Undecided   10 Fix Released
1221354 #1221354 Build failure in galera-3.x: strict-aliasing rules 1 Undecided   10 Fix Released
1225236 #1225236 Assertion `klass->m_flags & (1 << 1)' failed in 5.6 branch 1 Undecided   10 Fix Released
1226185 #1226185 Wrong package (rpm) dependency of xtrabackup in a specific case 1 Undecided Raghavendra D Prabhu  10 Fix Released
1228333 #1228333 wsrep_sst_rsync fails in PXC 5.6 1 Undecided   10 Fix Released
1228341 #1228341 Crash with debug build on PXC 5.6 1 Undecided Raghavendra D Prabhu  10 Fix Released
1228618 #1228618 Incompatible SST between 5.5.29 and 5.5.33 1 Undecided   10 Fix Released
1229107 #1229107 pc.checksum is enabled by default 1 Undecided   10 Fix Released
1230160 #1230160 potential memory leak on realloc() in wsrep_write_cache() 1 Undecided   10 Fix Released
1231067 #1231067 /var/lock/subsys/mysql should be cleaned up by init script 1 Undecided Raghavendra D Prabhu  10 Fix Released
1231121 #1231121 Make SST cleanup configurable 1 Undecided Raghavendra D Prabhu  10 Fix Released
1232789 #1232789 FLUSH STATUS zeroes up wsrep_cluster_size and wsrep_local_index 1 Undecided   10 Fix Released
1233301 #1233301 Deadlock with wsrep_kill_victim 1 Undecided Raghavendra D Prabhu  10 Fix Released
1233353 #1233353 Handler command and concurrent DDL can cause node hanging 1 Undecided   10 Fix Released
1233383 #1233383 innodb: unprotected access to was_chosen_as_deadlock_victim 1 Undecided   10 Fix Released
1234229 #1234229 WSREP: conc slot cancel not supported 1 Undecided   10 Fix Released
1234382 #1234382 Issue with lock_sys->mutex when wsrep_log_conflicts 1 Undecided   10 Fix Released
1234421 #1234421 void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed. 1 Undecided   10 Fix Released
1235244 #1235244 Add support for key and crt 1 Undecided Raghavendra D Prabhu  10 Fix Released
1237021 #1237021 'service mysql status' not producing valid exit codes 1 Undecided   10 Fix Released
1237889 #1237889 ALTER TABLE causes Failing assertion: trx_is_registered_for_2pc(trx) 1 Undecided   10 Fix Released
1238278 #1238278 ha_innodb.cc:5713: void wsrep_innobase_mysql_sort(int, uint, unsigned char*, unsigned int): Assertion `tmp_length == str_length' failed. 1 Undecided   10 Fix Released
1238331 #1238331 Segfault in find_wsrep_new_cluster() when loading plugin. 1 Undecided   10 Fix Released
1239571 #1239571 wsrep_innobase_kill_one_trx() is missing BF thd for TOI BF aborts in 5.6 1 Undecided   10 Fix Released
1240040 #1240040 No key information for DROP VIEW 1 Undecided   10 Fix Released
1240098 #1240098 CTAS fails with explicit TEMPORARY tables, binlogging enabled and autocommit=0 1 Undecided   10 Fix Released
1240112 #1240112 WSREP check for locks_unsafe_for_binlog is not used 1 Undecided   10 Fix Released
1240500 #1240500 Audit mysqld.cc for thread_scheduler 1 Undecided Raghavendra D Prabhu  10 Fix Released
1240567 #1240567 wsrep_exec_mode remains in LOCAL_COMMIT after AC rollback 1 Undecided   10 Fix Released
1241760 #1241760 thd->db may get reset during transaction replay 1 Undecided   10 Fix Released
1243150 #1243150 wsrep hton refactoring 1 Undecided   10 Fix Released
1243739 #1243739 cppcheck issues 1 Undecided   10 Fix Released
1244661 #1244661 unreleased write set handlers after randgen run 1 Undecided   10 Fix Released
1244667 #1244667 sql_parse.cc:4895: int mysql_execute_command(THD*): Assertion `!thd->in_active_multi_stmt_transaction() || thd->in_multi_stmt_transaction_mode()' failed. 1 Undecided   10 Fix Released
1245333 #1245333 wsrep commit callback does not release mdl locks 1 Undecided   10 Fix Released
1246128 #1246128 Invalid write of size 8 | Address 0x1c23d1e8 is 168 bytes inside a block of size 176 free'd | Galera 23.2.8 1 Undecided   10 Fix Released
1246257 #1246257 CREATE TEMPORARY TABLE LIKE... will be replicated 1 Undecided   10 Fix Released
1246921 #1246921 CTAS with empty result set will not be replicated 1 Undecided   10 Fix Released
1247344 #1247344 Relocatable RPMs 1 Undecided Raghavendra D Prabhu  10 Fix Released
1247971 #1247971 Implement wsrep_bf_aborts counter status variable 1 Undecided   10 Fix Released
1247978 #1247978 rollbacks may leave stale transactional MDL locks 1 Undecided   10 Fix Released
1247980 #1247980 FLUSH STATUS should call wsrep->stats_reset() 1 Undecided   10 Fix Released
1248089 #1248089 Query Cache support 1 Undecided   10 Fix Released
1248396 #1248396 Port xtrabackup SST version updates to PXC 5.6 1 Undecided   10 Fix Released
1248908 #1248908 sync level violation with wsrep checkpointing 1 Undecided   10 Fix Released
1248921 #1248921 UNIV_SYNC_DEBUG build asserts with cascading FK load 1 Undecided   10 Fix Released
1249753 #1249753 thd->mem_root not freed on appliers 1 Undecided   10 Fix Released
1250326 #1250326 Add xtrabackup SST dependencies as Optional/Recommended/Suggested dependencies 1 Undecided   10 Fix Released
1250865 #1250865 Revision number in RPM 1 Undecided   10 Fix Released
This milestone contains Public information
Everyone can see this information.