Percona Server moved to https://jira.percona.com/projects/PS 5.6.33-79.0

Milestone information

Project:
Percona Server moved to https://jira.percona.com/projects/PS
Series:
5.6
Version:
5.6.33-79.0
Released:
2016-10-18  
Registrant:
Hrvoje Matijakovic
Release registered:
2016-10-18
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:
3 George Ormond Lorch III, 50 Laurynas Biveinis, 6 Sergei Glushchenko, 1 Yura Sorokin
Blueprints:
2 Implemented
Bugs:
58 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features
Percona Server has implemented support for per-column VARCHAR/BLOB compression for the XtraDB storage engine. This also features compression dictionary support, to improve compression ratio for relatively short individual rows, such as JSON data.

A new TokuDB tokudb_dir_per_db option has been introduced to address two TokuDB shortcomings, the renaming of data files on table/index rename, and the ability to group data files together within a directory that represents a single database. This feature is disabled by default.
Bugs Fixed
After fixing bug #1540338, system table engine validation check is no longer skipped for tables that don’t have an explicit ENGINE clause in a CREATE TABLE statement. If MySQL upgrade statements are replicated, and slave does not have the MyISAM set as a default storage engine, then the CREATE TABLE mysql.server statement would attempt to create an InnoDB table and fail because mysql_system_tables.sql script omitted explicit engine setting for this table. Bug fixed #1600056.

Audit Log Plugin malformed record could be written after audit_log_flush was set to ON in ASYNC and PERFORMANCE modes. Bug fixed #1613650.

A race condition between HandlerSocket and server shutdown could lead to a server stall if shutdown was issued immediately after HandlerSocket startup. Bug fixed #1617198.

HandlerSocket could access freed memory on startup. Bug fixed #1617998.

Workloads with statements that take non-transactional locks (LOCK TABLES, global read lock, and similar) could have caused deadlocks when running under Thread Pool with high priority queue enabled and thread_pool_high_prio_mode set to transactions. Fixed by placing such statements into the high priority queue even with the above thread_pool_high_prio_mode setting. Bugs fixed #1619559 and #1374930.

Fixed memory leaks in Audit Log Plugin. Bug fixed #1620152 (upstream #71759).

Server could crash due to a glibc bug in handling short-lived detached threads. Bug fixed #1621012 (upstream #82886).

QUERY_RESPONSE_TIME_READ and QUERY_RESPONSE_TIME_WRITE were returning QUERY_RESPONSE_TIME table data if accessed through a name that is not full uppercase. Bug fixed #1552428.

Fixed memory leaks in HandlerSocket. Bug fixed #1617949.

KILL QUERY was not behaving consistently and it would hang in some cases. Bug fixed #1621046 (upstream #45679).

Cipher ECDHE-RSA-AES128-GCM-SHA256 was listed in the list of supported ciphers but it wasn’t supported. Bug fixed #1622034 (upstream #82935).

Successful doublewrite recovery was showed as a warning in the error log. Bug fixed #1622985.

Variable query_cache_type couldn’t be set to 0 if it was already set to that value. Bug fixed #1625501 (upstream #69396).

LRU manager thread could run too long on a server shutdown, causing a server crash. Bug fixed #1626069.

tokudb_default was not recognized by Percona Server as a valid row format. Bug fixed #1626206.

InnoDB ANALYZE TABLE didn’t remove its table from the background statistics processing queue. Bug fixed #1626441 (upstream #71761).

Upstream merge for #81657 to 5.6 was incorrect. Bug fixed #1626936 (upstream #83124).

Fixed multi-threaded slave thread leaks that happened in case of thread create failure. Bug fixed #1619622 (upstream #82980).

Shutdown waiting for a purge to complete was undiagnosed for the first minute. Bug fixed #1616785.

Unnecessary InnoDB change buffer merge attempts are now skipped upon reading disk pages of non-applying types. Bug fixed #1618393 (upstream #75235).
Other bugs fixed: #1614439, #1614949, #1616392 (upstream #82798), #1624993 (#736), #1613647, #1626002 (upstream #83073), #904714, #1610102, #1610110, #1613663, #1613728, #1613986, #1614885, #1615959, #1615970, #1616333, #1616404, #1616768, #1617150, #1617216, #1617267, #1618478, #1618811, #1618819, #1619547, #1619572, #1620583, #1622449, #1622456, #1622977, #1623011, #1624992 (#1014), #1625176, #1625187, #1626500, #1628417, #964, and #735.

2 blueprints and 58 bugs targeted

Blueprint Priority Assignee Delivery
Merge MySQL 5.6.33 Merge MySQL 5.6.33 5 Essential Laurynas Biveinis  11 Implemented
Column Compression with optional Predefined Dictionary Column Compression with optional Predefined Dictionary 4 High Yura Sorokin  11 Implemented
Bug report Importance Assignee Status
1600056 #1600056 Slave replication fails on master upgrade 'InnoDB does not support system tables' 3 High Laurynas Biveinis  10 Fix Released
1613650 #1613650 audit_log: malformed record could be written after audit_log_flush=ON in ASYNC and PERFORMANCE modes 3 High Sergei Glushchenko  10 Fix Released
1614439 #1614439 audit_log/audit_log.c:522: audit_log_general_record: Assertion `errors == 0' failed 3 High Sergei Glushchenko  10 Fix Released
1614949 #1614949 audit plugin: Invalid read of size 1 3 High Sergei Glushchenko  10 Fix Released
1616392 #1616392 Small buffer pools might be too small for rseg init during crash recovery 3 High Laurynas Biveinis  10 Fix Released
1617198 #1617198 Intermittently stalled or crashing shutdown if it's issued immediately after HandlerSocket startup 3 High Laurynas Biveinis  10 Fix Released
1617998 #1617998 HandlerSocket may access freed memory on startup 3 High Laurynas Biveinis  10 Fix Released
1619559 #1619559 Thread pool and lock tables cause deadlock 3 High Laurynas Biveinis  10 Fix Released
1620152 #1620152 The audit log plugin uses too much memory 3 High Sergei Glushchenko  10 Fix Released
1621012 #1621012 Server may crash due to a glibc bug in handling short-lived detached threads 3 High Laurynas Biveinis  10 Fix Released
1624993 #1624993 TokuDB heap corruption 3 High George Ormond Lorch III  10 Fix Released
1626519 #1626519 Valgrind: Invalid read of size 8 at get_record_buffer by audit_log_notify 3 High Sergei Glushchenko  10 Fix Released
1552428 #1552428 QUERY_RESPONSE_TIME_READ & QUERY_RESPONSE_TIME_WRITE broken if accessed through non-uppercase name 4 Medium Laurynas Biveinis  10 Fix Released
1613647 #1613647 Sporadic audit_log_filter_users failures 4 Medium Sergei Glushchenko  10 Fix Released
1617949 #1617949 HandlerSocket leaks thread objects 4 Medium Laurynas Biveinis  10 Fix Released
1621046 #1621046 KILL QUERY not behaving consistently and will hang in some cases 4 Medium Laurynas Biveinis  10 Fix Released
1622034 #1622034 Cipher ECDHE-RSA-AES128-GCM-SHA256 listed in man/Ssl_cipher_list, not supported 4 Medium Laurynas Biveinis  10 Fix Released
1622985 #1622985 Successful doublewrite recovery should not be a warning 4 Medium Laurynas Biveinis  10 Fix Released
1625501 #1625501 Can't set query_cache_type to 0 when it is already 0 4 Medium Laurynas Biveinis  10 Fix Released
1626002 #1626002 GCC 5 and 6 miscompile mach_parse_compressed 4 Medium Laurynas Biveinis  10 Fix Released
1626069 #1626069 LRU manager thread might run too long on server shutdown 4 Medium Laurynas Biveinis  10 Fix Released
1626206 #1626206 tokudb_default not recognized by Percona Server as valid row_format 4 Medium George Ormond Lorch III  10 Fix Released
1626441 #1626441 ANALYZE TABLE should remove its table from background stat processing queue 4 Medium Laurynas Biveinis  10 Fix Released
1626936 #1626936 Bug 81657 fix merge to 5.6 broken 4 Medium Laurynas Biveinis  10 Fix Released
904714 #904714 Intermittent rpl.percona_bug860910 failures 5 Low Laurynas Biveinis  10 Fix Released
1610102 #1610102 Upstream 5.5 test failures with --repeat=2 5 Low Laurynas Biveinis  10 Fix Released
1610110 #1610110 5.5 test failures with --parallel=2 5 Low Laurynas Biveinis  10 Fix Released
1613663 #1613663 Test main.mysqltest is unstable 5 Low Laurynas Biveinis  10 Fix Released
1613728 #1613728 Test rpl.rpl_bug58546 may crash server due to concurrent DBUG access 5 Low Laurynas Biveinis  10 Fix Released
1613986 #1613986 Test percona_changed_page_bmp_crash produces warnings if doublewrite was used for recovery 5 Low Laurynas Biveinis  10 Fix Released
1614885 #1614885 Spurious Valgrind error on main.udf 5 Low Laurynas Biveinis  10 Fix Released
1615959 #1615959 Unsuppressed Valgrind warning on plugin_auth_qa_2 5 Low Laurynas Biveinis  10 Fix Released
1615970 #1615970 "InnoDB: Failed to set NUMA memory policy" on 32-bit hosts 5 Low Laurynas Biveinis  10 Fix Released
1616333 #1616333 Test rpl.rpl_backup_locks_mts is unstable 5 Low Laurynas Biveinis  10 Fix Released
1616404 #1616404 Test perfschema.setup_instruments_defaults is unstable 5 Low Laurynas Biveinis  10 Fix Released
1616768 #1616768 -Wempty-body warning regression in dispatch_command 5 Low Laurynas Biveinis  10 Fix Released
1617150 #1617150 Test rpl.rpl_semi_sync_uninstall_plugin is unstable 5 Low Laurynas Biveinis  10 Fix Released
1617216 #1617216 Test percona_processlist_row_stats is unstable 5 Low Laurynas Biveinis  10 Fix Released
1617267 #1617267 -Wunused-but-set-variable warning in Global_backup_lock::set_explicit_locks_duration for should_own 5 Low Laurynas Biveinis  10 Fix Released
1618478 #1618478 innodb.percona_changed_page_bmp might not shutdown server under 60 seconds under ASan 5 Low Laurynas Biveinis  10 Fix Released
1618811 #1618811 MTR Subunit support should report testcase check failures 5 Low Laurynas Biveinis  10 Fix Released
1618819 #1618819 audit_log testcases do not wait for connections to finish disconnecting 5 Low Laurynas Biveinis  10 Fix Released
1619547 #1619547 rpl_end.inc/check-warnings.test/check-testcase.test etc do not wait for client disconnects to complete 5 Low Laurynas Biveinis  10 Fix Released
1619572 #1619572 Test rpl.rpl_init_slave leaves max_connections = 500 at the end intermittently 5 Low Laurynas Biveinis  10 Fix Released
1619622 #1619622 Multi-threaded slave leaks worker threads in case of thread create failure 5 Low Laurynas Biveinis  10 Fix Released
1620583 #1620583 Test change_user_notembedded is unstable 5 Low Laurynas Biveinis  10 Fix Released
1622449 #1622449 Test innodb.innodb_replace is unstable 5 Low Laurynas Biveinis  10 Fix Released
1622456 #1622456 Test main.mysql_client_test fails testcase check intermittently 5 Low Laurynas Biveinis  10 Fix Released
1622977 #1622977 Test connect_debug is unstable 5 Low Laurynas Biveinis  10 Fix Released
1623011 #1623011 Test rpl.rpl_percona_crash_resistant_rpl is unstable 5 Low Laurynas Biveinis  10 Fix Released
1624992 #1624992 tokudb/t/dir-per-db-with-custom-data-dir-master.opt should have --loose- prefixes 5 Low George Ormond Lorch III  10 Fix Released
1625176 #1625176 Test main.partition_innodb_plugin is unstable 5 Low Laurynas Biveinis  10 Fix Released
1625187 #1625187 Test sys_vars.innodb_buffer_pool_load_now_basic is unstable 5 Low Laurynas Biveinis  10 Fix Released
1626500 #1626500 Test rpl.rpl_percona_bug1070255 is unstable 5 Low Laurynas Biveinis  10 Fix Released
1628417 #1628417 3-byte read function uint3korr reads 4 bytes on x86 5 Low Laurynas Biveinis  10 Fix Released
1374930 #1374930 put threads with GLOBAL READ lock (executing ftwrl) into high priority queue 6 Wishlist Laurynas Biveinis  10 Fix Released
1616785 #1616785 Shutdown waiting for purge to complete is undiagnosed for the 1st minute 6 Wishlist Laurynas Biveinis  10 Fix Released
1618393 #1618393 Optimize ibuf merge when reading a page from disk 6 Wishlist Laurynas Biveinis  10 Fix Released
This milestone contains Public information
Everyone can see this information.