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

Milestone information

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

Kill Idle Transactions feature has been re-implemented by setting a connection socket read timeout value instead of periodically scanning the internal InnoDB transaction list. This makes the feature applicable to any transactional storage engine, such as TokuDB, and, in future, MyRocks. This re-implementation is also addressing some existing bugs, including server crashes: #1166744, #1179136, #907719, and #1369373.
Bugs Fixed
Logical row for TokuDB tables could get inaccurate over time. Bug fixed #1651844 (#732).

Repeated execution of SET STATEMENT ... FOR <SELECT FROM view> could lead to a server crash. Bug fixed #1392375.

CREATE TEMPORARY TABLE would create a transaction in binary log on a read only server. Bug fixed #1539504 (upstream #83003).

Using Per-query variable statement with subquery temporary tables could cause a memory leak. Bug fixed #1635927.

Fixed new compilation warnings with GCC 6. Bugs fixed #1641612 and #1644183.

A server could crash if a bitmap write I/O error happens in the background log tracking thread while a FLUSH CHANGED_PAGE_BITMAPS is executing concurrently. Bug fixed #1651656.

TokuDB was using wrong function to calculate free space in data files. Bug fixed #1656022 (#1033).

CONCURRENT_CONNECTIONS column in the USER_STATISTICS table was showing incorrect values. Bug fixed #728082.

Audit Log Plugin when set to JSON format was not escaping characters properly. Bug fixed #1548745.

InnoDB index dives did not detect some of the concurrent tree changes, which could return bogus estimates. Bug fixed #1625151 (upstream #84366).

INFORMATION_SCHEMA.INNODB_CHANGED_PAGES queries would needlessly read potentially incomplete bitmap data past the needed LSN range. Bug fixed #1625466.

Percona Server cmake compiler would always attempt to build RocksDB even if -DWITHOUT_ROCKSDB=1 argument was specified. Bug fixed #1638455.

Lack of free pages in the buffer pool is not diagnosed with innodb_empty_free_list_algorithm set to backoff (which is the default). Bug fixed #1657026.

mysqld_safe now limits the use of rm and chown to avoid privilege escalation. chown can now be used only for /var/log directory. Bug fixed #1660265. Thanks to Dawid Golunski (https://legalhackers.com).

Renaming a TokuDB table to a non-existent database with tokudb_dir_per_db enabled would lead to a server crash. Bug fixed #1030.

Read Free Replication optimization could not be used for TokuDB partition tables. Bug fixed #1012.
Other bugs fixed: #1486747, #1617715, #1633988, #1638198 (upstream #82823), #1642230, #1646384, #1640810, #1647530, #1651121, #1658843, #1156772, #1644583, #1648389, #1648737, #1650256, and #1647723.

4 blueprints and 36 bugs targeted

Blueprint Priority Assignee Delivery
Merge MySQL 5.7.17 Merge MySQL 5.7.17 5 Essential Yura Sorokin  11 Implemented
Column Compression Extensions for 5.7 Column Compression Extensions for 5.7 4 High Yura Sorokin  11 Implemented
Import Facebook MySQL my_io_perf* functionality for MyRocks 5.7 Import Facebook MySQL my_io_perf* functionality for MyRocks 5.7 4 High George Ormond Lorch III  11 Implemented
Socket-based kill idle transaction feature re-implementation, 5.7 Socket-based kill idle transaction feature re-implementation, 5.7 3 Medium Laurynas Biveinis  11 Implemented
Bug report Importance Assignee Status
1645386 #1645386 TokuDB renaming table to nonexistent DB destroys table 2 Critical Vlad Lesin  10 Fix Released
1651844 #1651844 tokudb table rows decrease to 0, table has 10m rows in it - no indexes being used on any query plan 2 Critical George Ormond Lorch III  10 Fix Released
1166744 #1166744 Some issues with kill_idle_transaction implementation at InnoDB level 3 High Laurynas Biveinis  10 Fix Released
1179136 #1179136 Kill idle transaction debug build assert: safe_mutex: Trying to destroy a mutex that was locked at sql_class.cc, line 880 at sql_class.cc, line 1773 3 High Laurynas Biveinis  10 Fix Released
1392375 #1392375 Crashing repeated execution of SET STATEMENT ... FOR <SELECT FROM view> | Assertion `sl->join == 0' failed in reinit_stmt_before_use | sig 6 abort in sql/sql_prepare.cc:2619 3 High Laurynas Biveinis  10 Fix Released
1486747 #1486747 InnoDB AUTO_INCREMENT produces same value twice 3 High   10 Fix Released
1539504 #1539504 CREATE TEMPORARY TABLE creates a transaction in binary log on read only server 3 High Laurynas Biveinis  10 Fix Released
1617715 #1617715 mysql_upgrade of PS 5.7.14 doesn't update the "slave_master_info" schema 3 High   10 Fix Released
1633988 #1633988 Debug assertion `thd == _current_thd()' failed with audit_log plugin turned on when "too many connections" error occured 3 High Sergei Glushchenko  10 Fix Released
1635927 #1635927 Memory leak when using per-query variables with subquery temp tables 3 High Laurynas Biveinis  10 Fix Released
1638198 #1638198 Cannot compile Percona-Server-5.6 from source (gmock download error) 3 High   10 Fix Released
1641612 #1641612 New compilation warnings with GCC 6 (-Wshift-negative-value, -Wdeprecated-declarations, -Wnonnull-compare, -Wc+11-compat, -Wmisleading-indentation) 3 High Laurynas Biveinis  10 Fix Released
1642230 #1642230 handle_fatal_signal (sig=11) in THD::set_new_thread_id 3 High Laurynas Biveinis  10 Fix Released
1646384 #1646384 ANALYZE TABLE crashes debug build on --innodb-read-only instance 3 High Laurynas Biveinis  10 Fix Released
1651656 #1651656 Server crash if a changed page bitmap error occurs concurrently with executing FLUSH CHANGED_PAGE_BITMAPS 3 High Laurynas Biveinis  10 Fix Released
1656022 #1656022 Partition pruning doesn't seem to work with TokuDB engine 3 High George Ormond Lorch III  10 Fix Released
728082 #728082 USER_STATISTICS shows incorrect value for number of concurrent connections 4 Medium Nickolay Ihalainen  10 Fix Released
1548745 #1548745 audit_log json is not escaping characters properly 4 Medium Sergei Glushchenko  10 Fix Released
1625151 #1625151 InnoDB index dives do not detect concurrent tree changes, return bogus estimates 4 Medium Laurynas Biveinis  10 Fix Released
1625466 #1625466 INFORMATION_SCHEMA.INNODB_CHANGED_PAGES queries needlessly read potentially incomplete bitmap data past the query range 4 Medium Laurynas Biveinis  10 Fix Released
1638455 #1638455 Percona-Server-5.6 cmake compiler always check RocksDB even if we pass -DWITHOUT_ROCKSDB=1 argument 4 Medium George Ormond Lorch III  10 Fix Released
1640810 #1640810 Adding COMPRESSED attributes to InnoDB special tables fields can lead to server crashes 4 Medium Yura Sorokin  10 Fix Released
1647530 #1647530 InnoDB: Failing assertion: success | InnoDB: page_zip_apply_log: 97>>1 > 1 | InnoDB: unable to decompress space 6 page 3 4 Medium Yura Sorokin  10 Fix Released
1651121 #1651121 Test innodb.percona_changed_page_bmp_debug unstable under load 4 Medium Laurynas Biveinis  10 Fix Released
1657026 #1657026 Lack of free pages in the buffer pool is not diagnosed with innodb_empty_free_list_algorithm=backoff 4 Medium Laurynas Biveinis  10 Fix Released
1658843 #1658843 MyRocks - gap lock error logic does not account for ISO mode 4 Medium George Ormond Lorch III  10 Fix Released
1156772 #1156772 Missing sys_vars test for innodb_kill_idle_transaction 5 Low Laurynas Biveinis  10 Fix Released
1644183 #1644183 New GCC 6 -Wnonnull-compare warnings on 5.5 release build 5 Low Laurynas Biveinis  10 Fix Released
1644583 #1644583 Test main.percona_expand_fast_index_creation is unstable 5 Low Laurynas Biveinis  10 Fix Released
1648389 #1648389 Spurious unsuppressed warning on rpl.rpl_parallel_switch_sequential 5 Low Laurynas Biveinis  10 Fix Released
1648718 #1648718 Testcase rpl.rpl_get_master_version_and_clock almost completely broken 5 Low Laurynas Biveinis  10 Fix Released
1648737 #1648737 Testcase opt_trace.temp_table is unstable 5 Low Laurynas Biveinis  10 Fix Released
1650256 #1650256 Test main.join_cache_bka_nixbnl is unstable 5 Low Laurynas Biveinis  10 Fix Released
907719 #907719 innodb_kill_idle_transaction should be implemented in the server 6 Wishlist Laurynas Biveinis  10 Fix Released
1369373 #1369373 minor changes to optimize innodb_kill_idle_transaction 6 Wishlist Laurynas Biveinis  10 Fix Released
1647723 #1647723 mysqltest should diagnose popen call failure 6 Wishlist Laurynas Biveinis  10 Fix Released
This milestone contains Public information
Everyone can see this information.