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

Percona Server moved to https://jira.percona.com/projects/PS 5.7.18-14

Milestone information

Project:
Percona Server moved to https://jira.percona.com/projects/PS
Series:
5.7
Version:
5.7.18-14
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:
2 EvgeniyPatlan, 5 George Ormond Lorch III, 24 Laurynas Biveinis, 2 Nickolay Ihalainen, 5 Robert Golebiowski, 1 Sergei Glushchenko, 3 Vlad Lesin, 4 Yura Sorokin
Blueprints:
5 Implemented
Bugs:
46 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features
Percona Server 5.7 packages are now available for Ubuntu 17.04 (Zesty Zapus).

Percona Server now supports Prefix Index Queries Optimization.

Percona Server has implemented support for Gap locks detection from a Facebook MySQL patch.

tokudb_dir_cmd can now be used to edit the TokuDB files.
Bugs Fixed
Deadlock could occur in I/O-bound workloads when server was using several small buffer pool instances in combination with small redo log files and variable innodb_empty_free_list_algorithm set to backoff algorithm. Bug fixed #1651657.

Fixed a memory leak in Percona TokuBackup. Bug fixed #1669005.

Compressed columns with dictionaries could not be added to a partitioned table by using ALTER TABLE. Bug fixed #1671492.

Fixed a memory leak that happened in case of failure to create a multi-threaded slave worker thread. Bug fixed #1675716.

In-Place upgrade from Percona Server 5.6 to 5.7 by using standalone packages would fail if /var/lib/mysql wasn’t defined as the datadir. Bug fixed #1687276.

Combination of using any audit API-using plugin, like Audit Log Plugin and Response Time Distribution, with multi-byte collation connection and PREPARE statement with a parse error could lead to a server crash. Bug fixed #1688698 (upstream #86209).

Fix for a #1433432 bug caused a performance regression due to suboptimal LRU manager thread flushing heuristics. Bug fixed #1631309.

Creating Compressed columns with dictionaries in MyISAM tables by specifying partition engines would not result in error. Bug fixed #1631954.

It was not possible to configure basedir as a symlink. Bug fixed #1639735.

Replication slave did not report Seconds_Behind_Master correctly when running in multi-threaded slave mode. Bug fixed #1654091 (upstream #84415).

DROP TEMPORARY TABLE would create a transaction in binary log on a read-only server. Bug fixed #1668602 (upstream #85258).

Processing GTIDs in the relay log that were already been executed were causing write/fsync amplification. Bug fixed #1669928 (upstream #85141).

Text/BLOB fields were not handling sorting of the empty string consistently between InnoDB and filesort. Bug fixed #1674867 (upstream #81810) by porting a Facebook patch for MySQL.

InnoDB adaptive hash index was using a partitioning algorithm which would produce uneven distribution when the server contained many tables with an identical schema. Bug fixed #1679155 (upstream #81814).

For plugin variables that are signed numbers, doing a SHOW VARIABLES would always show an unsigned number. Fixed by porting a Facebook patch for MySQL.

5 blueprints and 46 bugs targeted

Blueprint Priority Assignee Delivery
Merge MySQL 5.7.18 Merge MySQL 5.7.18 5 Essential Laurynas Biveinis  11 Implemented
MyRocks and TokuDB common macros and build with FORCE option MyRocks and TokuDB common macros and build with FORCE option 4 High George Ormond Lorch III  11 Implemented
Import FB MySQL fix for SHOW signed variables Import FB MySQL fix for SHOW signed variables 3 Medium George Ormond Lorch III  11 Implemented
Index-only prefix index queries, 5.7 Index-only prefix index queries, 5.7 3 Medium Laurynas Biveinis  11 Implemented
Port FacebookSQL gap lock detection, logging, and error. Port FacebookSQL gap lock detection, logging, and error. 3 Medium George Ormond Lorch III  11 Implemented
Bug report Importance Assignee Status
1629250 #1629250 Log parsing buffer overflow 3 High   10 Fix Released
1651657 #1651657 Percona Server hangs during oltp prepare with several buffer pool instances and small innodb_log_file_size 3 High Nickolay Ihalainen  10 Fix Released
1660828 #1660828 handle_fatal_signal (sig=11) in sql_digest_storage::copy 3 High   10 Fix Released
1664519 #1664519 Terminate called after throwing an instance of 'std::out_of_range' 3 High   10 Fix Released
1669005 #1669005 Valgrind error on tokudb.backup.tokudb_backup_exclude 3 High Vlad Lesin  10 Fix Released
1671492 #1671492 Unable to add compression columns to a partitioned table via 'ALTER TABLE' 3 High Yura Sorokin  10 Fix Released
1674299 #1674299 Conditional jump or move depends on uninitialised value(s) at exec_relay_log_event 3 High Robert Golebiowski  10 Fix Released
1675716 #1675716 Memory leak on a failure to create a MTS worker thread 3 High Laurynas Biveinis  10 Fix Released
1687276 #1687276 In-Place upgrade from 5.6 to 5.7 using Standalone Packages fails 3 High EvgeniyPatlan  10 Fix Released
1688698 #1688698 audit plugin + MB collation connection + PREPARE stmt parse error crash | handle_fatal_signal (sig=11) in read_token from digest_add_token 3 High Laurynas Biveinis  10 Fix Released
1631309 #1631309 performance regression from fix for lp:1433432 4 Medium Nickolay Ihalainen  10 Fix Released
1631954 #1631954 It is possible to create COMPRESSED columns in MyISAM tables via specifying partition engines 4 Medium Yura Sorokin  10 Fix Released
1639735 #1639735 basedir cannot be a symlink 4 Medium EvgeniyPatlan  10 Fix Released
1654091 #1654091 slave doesn't report Seconds_Behind_Master when running slave_parallel_workers > 0 4 Medium Robert Golebiowski  10 Fix Released
1668602 #1668602 DROP TEMPORARY TABLE creates a transaction in binary log on read only server 4 Medium Laurynas Biveinis  10 Fix Released
1669928 #1669928 Write/fsync amplification w/ duplicate GTIDs 4 Medium Yura Sorokin  10 Fix Released
1670588 #1670588 Cannot start Percona Server using mysql.server due to calling mysqld_safe from absolute path 4 Medium   10 Fix Released
1672389 #1672389 Make MTR dump server's error log in case warnings found 4 Medium Laurynas Biveinis  10 Fix Released
1674507 #1674507 gap lock error tests not specifying engine on all tables 4 Medium George Ormond Lorch III  10 Fix Released
1674867 #1674867 MyRocks - missing server binary collation patch 4 Medium George Ormond Lorch III  10 Fix Released
1675623 #1675623 the fill_help_tables.sql file is out of date 4 Medium   10 Fix Released
1650294 #1650294 Test main.audit_log_filter_users is unstable 5 Low Sergei Glushchenko  10 Fix Released
1659224 #1659224 Test main.status is unstable 5 Low Laurynas Biveinis  10 Fix Released
1662908 #1662908 Testcases restart in InnoDB read only mode incorrectly | Intermittent errors in the error log on innodb.percona_log_archive_ro 5 Low Laurynas Biveinis  10 Fix Released
1669002 #1669002 tokudb.backup tests not cleaning up, fail with --repeat=2 5 Low Vlad Lesin  10 Fix Released
1671473 #1671473 Test perfschema.selects is unstable 5 Low Laurynas Biveinis  10 Fix Released
1673800 #1673800 Test main.type_temporal_fractional is unstable 5 Low Laurynas Biveinis  10 Fix Released
1674284 #1674284 Test funcs_1.processlist_priv_no_prot is unstable 5 Low Laurynas Biveinis  10 Fix Released
1676441 #1676441 Test innodb.percona_fast_prefix_index_fetch is unstable 5 Low Laurynas Biveinis  10 Fix Released
1676705 #1676705 mysql-test/extra/binlog_tests/tmp_table.test does not disconnect temp table connections, intermittently failing following tests 5 Low Laurynas Biveinis  10 Fix Released
1676847 #1676847 segfault-t failing under recent AddressSanitizer 5 Low Laurynas Biveinis  10 Fix Released
1677130 #1677130 field-t deletes Fake_TABLE objects through base TABLE pointer w/o virtual dtor 5 Low Laurynas Biveinis  10 Fix Released
1677162 #1677162 Test main.sp-threads is unstable 5 Low Laurynas Biveinis  10 Fix Released
1677943 #1677943 Bug 1668602 fix did not re-record rpl_semi_sync test 5 Low Laurynas Biveinis  10 Fix Released
1678692 #1678692 Test main.subquery_sj_none_bkaunique is unstable 5 Low Laurynas Biveinis  10 Fix Released
1680510 #1680510 rpl_diff.inc in 5.7 does not compare data from different servers 5 Low Yura Sorokin  10 Fix Released
1683993 #1683993 Test rpl.rpl_slow_query_log is unstable 5 Low Laurynas Biveinis  10 Fix Released
1684012 #1684012 Test main.log_tables is unstable 5 Low Laurynas Biveinis  10 Fix Released
1684078 #1684078 Test rpl.rpl_server_uuid is unstable 5 Low Laurynas Biveinis  10 Fix Released
1684264 #1684264 Test innodb.monitor is unstable 5 Low Laurynas Biveinis  10 Fix Released
1687386 #1687386 Test innodb.create_tablespace is failing on 5.7 5 Low Robert Golebiowski  10 Fix Released
1687432 #1687432 rpl.rpl_read_only is failing on 5.7 5 Low Robert Golebiowski  10 Fix Released
1687600 #1687600 Test innodb.innodb_file_limit_check is failing on 5.7 5 Low Robert Golebiowski  10 Fix Released
1674281 #1674281 MTR testcase timeouts should include server error logs 6 Wishlist Laurynas Biveinis  10 Fix Released
1679155 #1679155 InnoDB adaptive hash index uses a bad partitioning algorithm for the real world 6 Wishlist Laurynas Biveinis  10 Fix Released
1662725 #1662725 Slave fails to apply relay log if certain XA transaction exists 1 Undecided Vlad Lesin  10 Fix Released
This milestone contains Public information
Everyone can see this information.