Percona Server moved to https://jira.percona.com/projects/PS 5.7.10-2rc2

Milestone information

Project:
Percona Server moved to https://jira.percona.com/projects/PS
Series:
5.7
Version:
5.7.10-2rc2
Released:
2016-02-05  
Registrant:
Hrvoje Matijakovic
Release registered:
2016-02-06
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, 10 Laurynas Biveinis, 1 Nickolay Ihalainen, 1 Sergei Glushchenko, 7 Tomislav Plavcic, 3 Yura Sorokin
Blueprints:
No blueprints are targeted to this milestone.
Bugs:
25 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features
Complete list of changes between Percona Server 5.6 and 5.7 can be seen in Changed in Percona Server 5.7.

5.7 binlog group commit algorithm is now supported in TokuDB as well.

New TokuDB index statistics reporting has been implemented to be compatible with the changes implemented in upstream 5.7. Following the InnoDB example, the default value for tokudb_cardinality_scale_percent has been changed from 50% to 100%. Implementing this also addresses a server crash deep in the optimizer code.
Known Issues
In Percona Server 5.7 super_read_only feature has been replaced with upstream implementation. There are currently two known issues compared to Percona Server 5.6 implementation:

Bug #78963, super_read_only aborts STOP SLAVE if variable relay_log_info_repository is set to TABLE which could lead to a server crash in Debug builds.
Bug #79328, super_read_only set as a server option has no effect.
InnoDB crash recovery might fail if innodb_flush_method is set to ALL_O_DIRECT. The workaround is to set this variable to a different value before starting up the crashed instance (bug #1529885).
Bugs Fixed
Clustering secondary index could not be created on a partitioned TokuDB table. Bug fixed #1527730 (#720).

Percona TokuBackup was failing to compile with Percona Server 5.7. Bug fixed #123.

Granting privileges to a user authenticating with PAM Authentication Plugin could lead to a server crash. Bug fixed #1521474.

TokuDB status variables were missing from Percona Server 5.7.10-1. Bug fixed #1527364 (#923).

Attempting to rotate the audit log file would result in audit log file name foo.log.%u (literally) instead of a numeric suffix. Bug fixed #1528603.

Adding an index to an InnoDB temporary table while expand_fast_index_creation was enabled could lead to server assertion. Bug fixed #1529555.

TokuDB would not be upgraded on Debian/Ubuntu distributions while performing an upgrade from Percona Server 5.6 to Percona Server 5.7 even if explicitly requested. Bug fixed #1533580.

Server would assert when both TokuDB and InnoDB tables were used within one transaction on a replication slave which has binary log enabled and slave updates logging disabled. Bug fixed #1534249 (upstream bug #80053).

MeCab Full-Text Parser Plugin has not been included in the previous release. Bug fixed #1534617.

Fixed server assertion caused by Performance Schema memory key mix-up in SET STATEMENT ... FOR ... statements. Bug fixed #1534874.

Service name on CentOS 6 has been renamed from mysqld back to mysql. This change requires manual service restart after being upgraded from Percona Server 5.7.10-1. Bug fixed #1542332.

Setting the innodb_sched_priority_purge (available only in debug builds) while purge threads were stopped would cause a server crash. Bug fixed #1368552.

Enabling TokuDB with ps_tokudb_admin script inside the Docker container would cause an error due to insufficient privileges even when running as root. In order for this script to be used inside docker containers this error has been changed to a warning that a check is impossible. Bug fixed #1520890.

Write-heavy workload with a small buffer pool could lead to a deadlock when free buffers are exhausted. Bug fixed #1521905.

InnoDB status will start printing negative values for spin rounds per wait, if the wait number, even though being accounted as a signed 64-bit integer, will not fit into a signed 32-bit integer. Bug fixed #1527160 (upstream #79703).

Percona Server 5.7 couldn’t be restarted after TokuDB has been installed with ps_tokudb_admin script. Bug fixed #1527535.

Fixed memory leak when utility_user is enabled. Bug fixed #1530918.

Page cleaner worker threads were not instrumented for Performance Schema. Bug fixed #1532747 (upstream bug #79894).

Busy server was preferring LRU flushing over flush list flushing too strongly which could lead to performance degradation. Bug fixed #1534114.

libjemalloc.so.1 was missing from binary tarball. Bug fixed #1537129.

When cmake/make/make_binary_distribution workflow was used to produce binary tarballs it would produce tarballs with mysql-... naming instead of percona-server-.... Bug fixed #1540385.

Added proper memory cleanup if for some reason a table is unable to be opened from a dead closed state. This prevents an assertion from happening the next time the table is attempted to be opened. Bug fixed #917.

Variable tokudb_support_xa has been modified to prevent setting it to anything but ON/ENABLED and to print a SQL warning anytime an attempt is made to change it, just like innodb_support_xa. Bug fixed #928.

0 blueprints and 25 bugs targeted

Bug report Importance Assignee Status
1527730 #1527730 TokuDB - Can not create a clustering index on a partitioned table 2 Critical George Ormond Lorch III  10 Fix Released
1179451 #1179451 innodb_show_verbose_locks and innodb_show_locks_held untested in MTR (broken in 5.7) 3 High Yura Sorokin  10 Fix Released
1521474 #1521474 Server is crashing when we grant privileges to user with PAM plugin 3 High Sergei Glushchenko  10 Fix Released
1527364 #1527364 TokuDB status variables are missing from Percona Server 5.7.10-rc1 3 High George Ormond Lorch III  10 Fix Released
1528603 #1528603 Audit log rotation broken 3 High Laurynas Biveinis  10 Fix Released
1529555 #1529555 InnoDB: Failing assertion: id != srv_tmp_space.space_id() in fsp_space_modify_check 3 High Laurynas Biveinis  10 Fix Released
1533580 #1533580 tokudb upgrade fails during the 5.6 -> 5.7 upgrade 3 High Tomislav Plavcic  10 Fix Released
1534246 #1534246 "ctype_ucs.test" fails sporadically 3 High Yura Sorokin  10 Fix Released
1534249 #1534249 sql/binlog.cc:7987: virtual int MYSQL_BIN_LOG::prepare(THD*, bool): Assertion `thd->slave_thread ? opt_log_slave_updates : thd->variables.sql_log_bin' failed. 3 High George Ormond Lorch III  10 Fix Released
1534617 #1534617 libpluginmecab.so is missing from 5.7.10-1rc1 3 High Tomislav Plavcic  10 Fix Released
1534874 #1534874 Assertion `(old_mh->m_key == key) || (old_mh->m_key == 0)' failed in mysys/my_malloc.c:80 3 High Laurynas Biveinis  10 Fix Released
1542332 #1542332 Percona Server 5.7.10-1rc1 centos 6 service name 3 High Tomislav Plavcic  10 Fix Released
1368552 #1368552 InnoDB: Failing assertion: purge_sys->state == PURGE_STATE_RUN | abort (sig=6) in innodb_sched_priority_purge_update 4 Medium Yura Sorokin  10 Fix Released
1520890 #1520890 Error enabling TokuDB through ps_tokudb_admin 4 Medium Tomislav Plavcic  10 Fix Released
1521905 #1521905 Deadlock with small buffer pool 4 Medium Nickolay Ihalainen  10 Fix Released
1527160 #1527160 InnoDB status may show negative values for spin rounds per wait 4 Medium Laurynas Biveinis  10 Fix Released
1527535 #1527535 Percona Server 5.7 can't be restarted after TokuDB has been installed with ps_tokudb_admin 4 Medium Tomislav Plavcic  10 Fix Released
1530918 #1530918 Utility user memory leak 4 Medium Laurynas Biveinis  10 Fix Released
1532747 #1532747 Page cleaner worker threads are not instrumented for performance schema 4 Medium Laurynas Biveinis  10 Fix Released
1534114 #1534114 Busy server prefers LRU flushing over flush list flushing too strongly 4 Medium Laurynas Biveinis  10 Fix Released
1537129 #1537129 libjemalloc.so.1 missing from binary tarball 4 Medium Tomislav Plavcic  10 Fix Released
1524763 #1524763 Some issues with audit log testcases 5 Low Laurynas Biveinis  10 Fix Released
1525109 #1525109 Some --big-test tests were forgotten to update in 5.7.10 5 Low Laurynas Biveinis  10 Fix Released
1530102 #1530102 rpl.rpl_bug68490 fails under Valgrind in Jenkins 5 Low Laurynas Biveinis  10 Fix Released
1540385 #1540385 make_binary_distribution produces tarballs with "mysql-..." naming instead of "percona-server-..." 5 Low Tomislav Plavcic  10 Fix Released
This milestone contains Public information
Everyone can see this information.