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

Milestone information

Project:
Percona Server moved to https://jira.percona.com/projects/PS
Series:
5.6
Version:
5.6.30-76.3
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:
1 EvgeniyPatlan, 3 George Ormond Lorch III, 13 Laurynas Biveinis, 2 Tomislav Plavcic, 1 Vlad Lesin, 1 Yura Sorokin
Blueprints:
1 Implemented
Bugs:
23 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

Bugs Fixed
When Read Free Replication was enabled for TokuDB and there was no explicit primary key for the replicated TokuDB table there could be duplicated records in the table on update operation. The fix disables Read Free Replication for tables without explicit primary key and does rows lookup for UPDATE and DELETE binary log events and issues warning. Bug fixed #1536663 (#950).

Attempting to execute a non-existing prepared statement with Response Time Distribution plugin enabled could lead to a server crash. Bug fixed #1538019.

TokuDB was using using different memory allocators, this was causing safemalloc warnings in debug builds and crashes because memory accounting didn’t add up. Bug fixed #1546538 (#962).

Fixed heap allocator/deallocator mismatch in Metrics for scalability measurement. Bug fixed #1581051.

Percona Server is now built with system zlib library instead of the older bundled one. Bug fixed #1108016.

Reduced the memory overhead per page in the InnoDB buffer pool. The fix was based on Facebook patch #91e979e. Bug fixed #1536693 (upstream #72466).

CREATE TABLE ... LIKE ... could create a system table with an unsupported enforced engine. Bug fixed #1540338.

Change buffer merge could throttle to 5% of I/O capacity on an idle server. Bug fixed #1547525.

Slave_open_temp_tables would fail to decrement on the slave with disabled binary log if master was killed. Bug fixed #1567361.

Server will now show more descriptive error message when Percona Server fails with errno == 22 "Invalid argument", if innodb_flush_method was set to ALL_O_DIRECT. Bug fixed #1578604.

Killed connection threads could get their sockets closed twice on shutdown. Bug fixed #1580227.

AddressSanitizer build with LeakSanitizer enabled was failing at gen_lex_hash invocation. Bug fixed #1580993 (upstream #80014).

apt-cache show command for percona-server-client was showing innotop included as part of the package. Bug fixed #1201074.

mysql-systemd would fail with PAM authentication and proxies due to regression introduced when fixing #1534825 in Percona Server 5.6.29-76.2. Bug fixed #1558312.

Upgrade logic for figuring if TokuDB upgrade can be performed from the version on disk to the current version was broken due to regression introduced when fixing #684 in Percona Server 5.6.27-75.0. Bug fixed #717.

If ALTER TABLE was run while tokudb_auto_analyze variable was enabled it would trigger auto-analysis, which could lead to a server crash if ALTER TABLE DROP KEY was used because it would be operating on the old table/key meta-data. Bug fixed #945.

The TokuDB storage engine with tokudb_pk_insert_mode set to 1 is safe to use in all conditions. On INSERT IGNORE or REPLACE INTO, it tests to see if triggers exist on the table, or replication is active with !BINLOG_FORMAT_STMT before it allows the optimization. If either of these conditions are met, then it falls back to the “safe” operation of looking up the target row first. Bug fixed #952.

Bug in TokuDB Index Condition Pushdown was causing ORDER BY DESC to reverse the scan outside of the WHERE bounds. This would cause query to hang in a sending data state for several minutes in some environments with large amounts of data (3 billion records) if the ORDER BY DESC statement was used. Bugs fixed #988, #233, and #534.
Other bugs fixed: #1399562 (upstream #75112), #1510564 (upstream #78981), #1496282 (#964), #1496786 (#956), #1566790, #1552673, #1567247, #1567869, #718, #914, #970, #971, #972, #976, #977, #981, #637, and #982.

1 blueprint and 23 bugs targeted

Blueprint Priority Assignee Delivery
Merge MySQL 5.6.30 Merge MySQL 5.6.30 5 Essential Yura Sorokin  11 Implemented
Bug report Importance Assignee Status
1399562 #1399562 Optimize table removes the data directory in partitions 3 High   10 Fix Released
1510564 #1510564 It's possible to have innodb_open_files>open_files_limit and it can crash Percona Server 3 High   10 Fix Released
1536663 #1536663 TokuDB Read Free Replication will not propagate reliably if table PK is missing 3 High Vlad Lesin  10 Fix Released
1538019 #1538019 Crash on attempting to execute non-existing prepared statement with QRT enabled | handle_fatal_signal (sig=11) in query_response_time_audit_notify 3 High Laurynas Biveinis  10 Fix Released
1546538 #1546538 broken memory management in TokuDB 5.6.28-76.1 3 High George Ormond Lorch III  10 Fix Released
1552673 #1552673 Buffer pool may fail to remove dirty pages for a particular tablespace from the flush list 3 High Laurynas Biveinis  10 Fix Released
1581051 #1581051 Heap allocator/deallocator mismatch in scalability metrics plugin 3 High Laurynas Biveinis  10 Fix Released
1108016 #1108016 System libraries should be preferred to bundled ones 4 Medium Tomislav Plavcic  10 Fix Released
1536693 #1536693 More memory overhead per page in the InnoDB buffer pool 4 Medium Laurynas Biveinis  10 Fix Released
1540338 #1540338 CREATE TABLE ... LIKE ... may create a system table with an unsupported enforced engine | Assertion `!"Transactional table"' failed in sql/sql_base.cc:10502 4 Medium Laurynas Biveinis  10 Fix Released
1547525 #1547525 Change buffer merge throttled to 5% of I/O capacity on an idle server 4 Medium Laurynas Biveinis  10 Fix Released
1567361 #1567361 Slave_open_temp_tables fails to decrement on the slave w/ binlog off if master is killed 4 Medium Laurynas Biveinis  10 Fix Released
1578604 #1578604 Please check if ALL_O_DIRECT is ON if InnoDB log I/O fails with errno == 22 "Invalid argument" 4 Medium Laurynas Biveinis  10 Fix Released
1580227 #1580227 Killed connection threads might get their sockets closed twice on shutdown 4 Medium Laurynas Biveinis  10 Fix Released
1580993 #1580993 LeakSanitizer fails build at gen_lex_hash invocation 4 Medium Laurynas Biveinis  10 Fix Released
1201074 #1201074 "apt-cache show" for percona-server-client claims innotop is included 5 Low EvgeniyPatlan  10 Fix Released
1496282 #1496282 tokudb.i_s_tokudb_lock_waits_released testcase is unstable 5 Low George Ormond Lorch III  10 Fix Released
1496786 #1496786 tokudb.i_s_tokudb_locks_released testcase is unstable 5 Low George Ormond Lorch III  10 Fix Released
1566790 #1566790 Log archiving code cleanups 5 Low Laurynas Biveinis  10 Fix Released
1567247 #1567247 Miscellaneous XtraDB code review changes 5 Low Laurynas Biveinis  10 Fix Released
1567869 #1567869 Miscellaneous code review changes from 5.7 work 5 Low Laurynas Biveinis  10 Fix Released
1558312 #1558312 mysql-systemd fails with PAM auth and proxies 1 Undecided Tomislav Plavcic  10 Fix Released
1586122 #1586122 ON DUPLICATE KEY UPDATE causes foreign key errors to be reported as duplicate entry error 1 Undecided   10 Fix Released
This milestone contains Public information
Everyone can see this information.