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

Milestone information

Project:
Percona Server moved to https://jira.percona.com/projects/PS
Series:
5.7
Version:
5.7.17-12
Released:
2017-03-24  
Registrant:
Hrvoje Matijakovic
Release registered:
2017-03-24
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:
6 George Ormond Lorch III, 24 Laurynas Biveinis, 3 Robert Golebiowski, 3 Sergei Glushchenko, 1 Vlad Lesin, 2 Yura Sorokin
Blueprints:
3 Implemented
Bugs:
37 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features
Percona Server has implemented new mysqldump --order-by-primary-desc option. This feature tells mysqldump to take the backup by descending primary key order (PRIMARY KEY DESC) which can be useful if storage engine is using reverse order column family for a primary key.

mysqldump will now detect when MyRocks is installed and available by seeing if there is a session variable named rocksdb_skip_fill_cache and setting it to 1 if it exists.

mysqldump will now automatically enable session variable rocksdb_bulk_load if it is supported by target server.
Bugs Fixed
If the variable thread_handling was set to pool-of-threads in the MySQL configuration file, server couldn’t be gracefully shut down by a SIGTERM signal. Bug fixed #1537554.

When innodb_ft_result_cache_limit was exceeded by internal memory allocated by InnoDB during the FT scan not all memory was released which could lead to server assertion. Bug fixed #1634932 (upstream #83648).

Executing the FLUSH LOGS on a read-only slave with a user that doesn’t have the SUPER privilege would result in Error 1290. Bug fixed #1652852 (upstream #84350).

FLUSH LOGS was disabled with read_only and super_read_only variables. Bug fixed #1654682 (upstream #84437).

If SHOW BINLOGS or PERFORMANCE_SCHEMA.GLOBAL_STATUS query, and a transaction commit would run in parallel, they could deadlock. Bug fixed #1657128.

A long-running binary log commit would block SHOW STATUS, which in turn could block a number of of other operations such as client connects and disconnects. Bug fixed #1646100.

Log tracking initialization did not find last valid bitmap data correctly. Bug fixed #1658055.

A query using range scan with a complex range condition could lead to a server crash. Bug fixed #1660591 (upstream #84736).

Race condition between buffer pool page optimistic access and eviction could lead to a server crash. Bug fixed #1664280.

If Audit Log Plugin was unable to create file pointed by audit_log_file, server would crash during the startup. Bug fixed #1666496.

A DROP TEMPORARY TABLE ... for a table created by a CREATE TEMPORARY TABLE ... SELECT ... would get logged in the binary log on a disconnect with mixed mode replication. Bug fixed #1671013.

TokuDB did not use index with even if cardinality was good. Bug fixed #1671152.

Row-based replication events were not reflected in Rows_updated fields in the User Statistics INFORMATION_SCHEMA tables. Bug fixed #995624.

When DuplicateWeedout strategy was used for joins, use was not reported in the query plan info output extension for the slow query log. Bug fixed #1592694.

It was impossible to use column compression dictionaries with partitioned InnoDB tables. Bug fixed #1653104.

Diagnostics for OpenSSL errors have been improved. Bug fixed #1660339 (upstream #75311).

3 blueprints and 37 bugs targeted

Blueprint Priority Assignee Delivery
Import and improve Facebook MySQL mysqldump functionality for MyRocks 5.7 Import and improve Facebook MySQL mysqldump functionality for MyRocks 5.7 4 High George Ormond Lorch III  11 Implemented
Implement class Regex based on my_regex Implement class Regex based on my_regex 3 Medium George Ormond Lorch III  11 Implemented
Expose LOCK BINLOG FOR BACKUP function to plugins for 5.7. Expose LOCK BINLOG FOR BACKUP function to plugins for 5.7. 1 Undefined   11 Implemented
Bug report Importance Assignee Status
1665545 #1665545 Merge of MYR-27 into 5.7 reverted fix for MYR-35 2 Critical George Ormond Lorch III  10 Fix Released
1537554 #1537554 SIGTERM kills server instead of shutdown w/ threadpool, spurious mysqld_safe server restarts 3 High Laurynas Biveinis  10 Fix Released
1634932 #1634932 Assertion failure in thread x in file fts0que.cc line 3659 3 High Robert Golebiowski  10 Fix Released
1650321 #1650321 Valgrind error on main.audit_log_filter_commands 3 High Sergei Glushchenko  10 Fix Released
1652852 #1652852 Error 1290 executing flush logs in read-only slave 3 High Laurynas Biveinis  10 Fix Released
1654501 #1654501 libHotBackup.so fails to load on Ubuntu Yakkety 64-bit, debug build 3 High Vlad Lesin  10 Fix Released
1657128 #1657128 Deadlock by concurrent SHOW BINLOGS, performance_schema.global_status query, and binlog purge 3 High Laurynas Biveinis  10 Fix Released
1658055 #1658055 Log tracking initialisation does not find last valid bitmap data correctly 3 High Laurynas Biveinis  10 Fix Released
1660591 #1660591 5.7 range optimizer crash 3 High Laurynas Biveinis  10 Fix Released
1663251 #1663251 ASan errors on main.audit_log_filter_commands 3 High Sergei Glushchenko  10 Fix Released
1664280 #1664280 Race condition between buffer pool page optimistic access and eviction | InnoDB: Failing assertion: buf_page_in_file(bpage) in buf_page_make_young 3 High Laurynas Biveinis  10 Fix Released
1666496 #1666496 Server crashes on startup if plugin is unable to create file pointed by --audit_log_file 3 High Sergei Glushchenko  10 Fix Released
1671013 #1671013 CREATE TEMPORARY TABLE ... SELECT ... gets a DROP binlogged on disconnect in mixed 3 High Laurynas Biveinis  10 Fix Released
1671152 #1671152 tokudb does not use index even if cardinality is good 3 High George Ormond Lorch III  10 Fix Released
995624 #995624 RBR events are not reflected in userstat's Rows_updated 4 Medium Robert Golebiowski  10 Fix Released
1592694 #1592694 Query plan temp flag set is missed in create_duplicate_weedout_tmp_table 4 Medium Robert Golebiowski  10 Fix Released
1646100 #1646100 SHOW STATUS blocked by binlog commit | Server becomes unresponsive during flushing after loading big files through LOAD DATA INFILE 4 Medium Laurynas Biveinis  10 Fix Released
1653104 #1653104 Compression dictionaries are not being used in partitioned tables 4 Medium Yura Sorokin  10 Fix Released
1654682 #1654682 super-read-only not allow FLUSH LOGS on 5.7 4 Medium Laurynas Biveinis  10 Fix Released
1659548 #1659548 innodb_buffer_pool_evict_uncompressed might attempt to process non-unzip_LRU page, crashing debug build 4 Medium Laurynas Biveinis  10 Fix Released
1660339 #1660339 Bogus client SSL error messages produced using SSL_get_error not ERR_get_error error code 4 Medium Laurynas Biveinis  10 Fix Released
1663452 #1663452 Resource allocation failures in 'CREATE/DROP COMPRESSION_DICTIONARY' result in server crashes (debug mode) | handle_fatal_signal (sig=6) in innobase_create_zip_dict 4 Medium Yura Sorokin  10 Fix Released
1670834 #1670834 index only scans do not work for partitioned MyRocks tables and extended keys 4 Medium George Ormond Lorch III  10 Fix Released
1672871 #1672871 MyRocks - missing server optimizer patch for ICP 4 Medium George Ormond Lorch III  10 Fix Released
1626545 #1626545 Test perfschema.selects is unstable 5 Low Laurynas Biveinis  10 Fix Released
1658006 #1658006 Test sys_vars.rpl_init_slave_func is unstable 5 Low Laurynas Biveinis  10 Fix Released
1658021 #1658021 Test innodb.percona_changed_page_bmp_crash is unstable 5 Low Laurynas Biveinis  10 Fix Released
1659218 #1659218 Test sys_vars.innodb_buffer_pool_load_now_basic is unstable 5 Low Laurynas Biveinis  10 Fix Released
1659746 #1659746 Test main.index_merge_innodb is unstable 5 Low Laurynas Biveinis  10 Fix Released
1660239 #1660239 Test sys_vars.thread_cache_size_func is unstable 5 Low Laurynas Biveinis  10 Fix Released
1660243 #1660243 Test rpl.rpl_semi_sync_event is unstable 5 Low Laurynas Biveinis  10 Fix Released
1660348 #1660348 Intermittent testcase check warning on innodb_stress.innodb_hugestress_blob 5 Low Laurynas Biveinis  10 Fix Released
1662163 #1662163 innodb_fts.sync_block test unstable due to slow query log nondeterminism 5 Low Laurynas Biveinis  10 Fix Released
1664219 #1664219 Upstream 5.6 --repeat=2 test failures 5 Low Laurynas Biveinis  10 Fix Released
1664473 #1664473 5.6 --repeat=2 test failures 5 Low Laurynas Biveinis  10 Fix Released
1671076 #1671076 Test main.mysqldump is unstable 5 Low Laurynas Biveinis  10 Fix Released
1671123 #1671123 Test innodb.innodb-wl6445 is unstable 5 Low Laurynas Biveinis  10 Fix Released
This milestone contains Public information
Everyone can see this information.