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

Milestone information

Project:
Percona Server moved to https://jira.percona.com/projects/PS
Series:
5.6
Version:
5.6.26-74.0
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 Alexey Kopytov, 1 George Ormond Lorch III, 8 Krunal Bauskar, 24 Laurynas Biveinis, 5 Sergei Glushchenko, 3 Tomislav Plavcic, 5 Vlad Lesin, 6 Yura Sorokin
Blueprints:
7 Implemented
Bugs:
48 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features
TokuDB storage engine source has been merged into the Percona Server code. TokuDB storage engine tokudb_version variable now has the same value as the Percona Server version variable version.

TokuDB Hot Backup has been renamed to Percona TokuBackup and it is now open source. Source code has been integrated into Percona Server code as a git submodule. TokuDB Hot Backup plugin source has been merged into Percona Server code.

Tokutek Fractal Tree has been renamed to Percona FT and its source code has been integrated into Percona Server code as a git submodule.

TokuDB tests for Percona Server 5.6 have been merged into Percona Server 5.6 code.

Google SNAPPY compression/decompression algorithm is now available as TokuDB Compression table format.

Percona Server now supports changing the server_id variable per session, by implementing the new pseudo_server_id variable. This feature is also fixing upstream bug #35125.

Percona Server has temporarily disabled savepoints in triggers and stored functions. The reason is that even having fixed bug #1438990 and bug #1464468 we have found more cases where savepoints in triggers break binary logging and replication, resulting in server crashes and broken slaves. This feature will be disabled until the above issues are properly resolved.

LOCK TABLES FOR BACKUP now flushes the current binary log coordinates to InnoDB. Thus, under active LOCK TABLES FOR BACKUP, the binary log coordinates in InnoDB are consistent with its redo log and any non-transactional updates (as the latter are blocked by LOCK BINLOG FOR BACKUP). It is planned that this change will enable Percona XtraBackup to avoid issuing the more invasive LOCK BINLOG FOR BACKUP command under some circumstances.

innodb_stress has been added to the list of default MTR suites. For most supported systems satisfying the newly added dependencies is straightforward, but on CentOS 5, the default Python is too old. Thus python26 and python26-mysqldb packages should be installed there and python26 should be made the default python for the testsuite environment.

Three new TokuDB variables, tokudb_client_pool_threads, tokudb_cachetable_pool_threads, and tokudb_checkpoint_pool_threads, have been implemented to improve the controlling of thread pool size.

Percona Server has implemented new tokudb_enable_partial_eviction option in TokuDB to allow disabling of partial eviction of nodes.

Percona Server has implemented new tokudb_compress_buffers_before_eviction option in TokuDB which allows the evictor to compress unused internal node partitions in order to reduce memory requirements as a first step of partial eviction before fully evicting the partition and eventually the entire node.
Bugs Fixed
Querying GLOBAL_TEMPORARY_TABLES table would crash threads working with internal temporary tables used by ALTER TABLE. Bug fixed #1113388.

Selecting from GLOBAL_TEMPORARY_TABLES table while running an online ALTER TABLE on a partitioned table in parallel could lead to a server crash. Bug fixed #1193264.

Kill Idle Transactions feature could cause an assertion on a debug build due to a race condition. Bug fixed #1206008.

libmylsqclient_16 symbols were missing in Percona Server shared library package on RHEL/CentOS 7. Bug fixed #1420691.

Prepared statements in stored procedures could crash Response Time Distribution plugin. Bug fixed #1426345.

When variable innodb_corrupt_table_action is set to Warn/Salvage then server could crash on updating table statistics during query execution on affected tables. Bug fixed #1426610.

A sequence of failing TRUNCATE TABLE, then insert to that table, and CHECK TABLE would crash the server. Bug fixed #1433197.

When InnoDB change buffering was enabled and used, executing a FLUSH TABLE ... FOR EXPORT would cause a server hang and SHOW PROCESSLIST would show that table in a System Lock state. Bug fixed #1454441 (upstream #77011).

FLUSH INDEX_STATISTICS / FLUSH CHANGED_PAGE_BITMAPS and FLUSH USER_STATISTICS / RESET CHANGE_PAGE_BITMAPS pairs of commands were inadvertently joined, i.e. issuing either command had the effect of both. The first pair, besides flushing both index statistics and changed page bitmaps, had the effect of FLUSH INDEX_STATISTICS requiring SUPER instead of RELOAD privilege. The second pair resulted in FLUSH USER_STATISTICS destroying changed page bitmaps. Bug fixed #1472251.

Enabling super_read_only together with read_only in my.cnf would result in server crashing on startup. The workaround is to enable super_read_only dynamically on a running server.Bug fixed #1389935 ( the fix was ported from Facebook patch #14d5d9).

Enabling super_read_only as a command line option would not enable read_only. Bug fixed #1389935 ( the fix was ported from Facebook patch #14d5d9).

If a new connection thread was created while a SHOW PROCESSLIST command or a INFORMATION_SCHEMA.PROCESSLIST query was in progress, it could have a negative TIME_MS value returned in the PROCESSLIST output. Bug fixed #1379582.

With Support for Fake Changes enabled, a write to an InnoDB table that would cause B-tree reorganization could lead to server assertion with unknown error code 1000. Bug fixed #1410410.

Running ALTER TABLE ... DISCARD TABLESPACE with Support for Fake Changes enabled would lead to a server assertion. Bug fixed #1372219.

ALTER TABLE did not allow to change a column to NOT NULL if the column was referenced in a foreign key. Bug fixed #1470677 (upstream #77591).

DROP TABLE IF EXISTS which fails due to a foreign key presence could break replication if slave had replication filters. Bug fixed #1475107 (upstream #77684).

Enabling Log Archiving for XtraDB when --innodb-read-only option was enabled would cause server to crash. Bug fixed #1484432.

LRU manager thread flushing was being accounted to buffer_flush_background InnoDB metrics which was wrong and redundant. Bug fixed #1491420.

Fixed a typo in the cleaner thread loop where n_flushed is added to, instead of reset, by the idle server flushing. This may cause a cleaner thread sleep skip on a non-idle server. Bug fixed #1491435.

Running TokuDB for a long time with lots of file open and close operations could lead to a server crash due to server incorrectly setting a reserved value. Bug fixed #690.

Fixed TokuDB memory leak due to data race in context status initialization. Bug fixed #697.

Removed unnecessary calls to malloc_usable_size() function in PerconaFT library to improve the performance. Bug fixed #682.
Other bugs fixed: #1370002, #1464468, #1287299, #1472256, #867, #870, #878, #658, #661, #663, #665, #687, #696, #698, #870, #685, and #878.

7 blueprints and 48 bugs targeted

Blueprint Priority Assignee Delivery
Merge MySQL 5.6.26 Merge MySQL 5.6.26 5 Essential Vlad Lesin  11 Implemented
Tokutek source trees merge Tokutek source trees merge 4 High Tomislav Plavcic  11 Implemented
Per-session server_id Per-session server_id 3 Medium Sergei Glushchenko  11 Implemented
Temporarily disable savepoints in triggers and stored functions Temporarily disable savepoints in triggers and stored functions 3 Medium Laurynas Biveinis  11 Implemented
Add innodb_stress to the list of default MTR suites Add innodb_stress to the list of default MTR suites 2 Low Laurynas Biveinis  11 Implemented
TokuDB - add SNAPPY compression to TokuDB TokuDB - add SNAPPY compression to TokuDB 2 Low George Ormond Lorch III  11 Implemented
Backup-safe binlog information Backup-safe binlog information 1 Undefined Alexey Kopytov  11 Implemented
Bug report Importance Assignee Status
1113388 #1113388 field.cc:3822: virtual longlong Field_long::val_int(): Assertion `table->in_use == _current_thd()' failed 3 High Laurynas Biveinis  10 Fix Released
1113388 #1113388 field.cc:3822: virtual longlong Field_long::val_int(): Assertion `table->in_use == _current_thd()' failed 3 High Laurynas Biveinis  10 Fix Released
1193264 #1193264 handle_fatal_signal in ha_partition::clone (sql/ha_partition.cc:3412) 3 High Laurynas Biveinis  10 Fix Released
1193264 #1193264 handle_fatal_signal in ha_partition::clone (sql/ha_partition.cc:3412) 3 High Laurynas Biveinis  10 Fix Released
1206008 #1206008 InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED in file trx0trx.ic line 60 | handle_fatal_signal (sig=6) in raise > abort > trx_state_eq 3 High Yura Sorokin  10 Fix Released
1206008 #1206008 InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED in file trx0trx.ic line 60 | handle_fatal_signal (sig=6) in raise > abort > trx_state_eq 3 High Yura Sorokin  10 Fix Released
1420691 #1420691 RHEL 7 libmysqlclient incompatibilities 3 High Tomislav Plavcic  10 Fix Released
1420691 #1420691 RHEL 7 libmysqlclient incompatibilities 3 High Tomislav Plavcic  10 Fix Released
1426345 #1426345 Prepared statements in stored procedures crash query response time plugin 3 High Vlad Lesin  10 Fix Released
1426345 #1426345 Prepared statements in stored procedures crash query response time plugin 3 High Vlad Lesin  10 Fix Released
1426610 #1426610 mtr is not committed if detect corruption in btr_estimate_number_of_different_key_vals 3 High Krunal Bauskar  10 Fix Released
1426610 #1426610 mtr is not committed if detect corruption in btr_estimate_number_of_different_key_vals 3 High Krunal Bauskar  10 Fix Released
1433197 #1433197 handle_fatal_signal (sig=11) in ha_innobase::check | handler/ha_innodb.cc:12244 3 High Krunal Bauskar  10 Fix Released
1433197 #1433197 handle_fatal_signal (sig=11) in ha_innobase::check | handler/ha_innodb.cc:12244 3 High Krunal Bauskar  10 Fix Released
1454272 #1454272 Slave with MTS enabled may get broken after restart 3 High   10 Fix Released
1454272 #1454272 Slave with MTS enabled may get broken after restart 3 High   10 Fix Released
1454441 #1454441 Hanging "System Lock" when executing "flush table ... for export" 3 High Sergei Glushchenko  10 Fix Released
1454441 #1454441 Hanging "System Lock" when executing "flush table ... for export" 3 High Sergei Glushchenko  10 Fix Released
1464468 #1464468 Slave crash with malformed binlog event 3 High Vlad Lesin  10 Fix Released
1464468 #1464468 Slave crash with malformed binlog event 3 High Vlad Lesin  10 Fix Released
1472251 #1472251 FLUSH INDEX_STATISTICS / FLUSH CHANGED_PAGE_BITMAPS and FLUSH USER_STATISTICS / RESET CHANGE_PAGE_BITMAPS pairs of commands are joined 3 High Laurynas Biveinis  10 Fix Released
1472251 #1472251 FLUSH INDEX_STATISTICS / FLUSH CHANGED_PAGE_BITMAPS and FLUSH USER_STATISTICS / RESET CHANGE_PAGE_BITMAPS pairs of commands are joined 3 High Laurynas Biveinis  10 Fix Released
1483956 #1483956 mysql abort when enable super_read_only with read_only 3 High Laurynas Biveinis  10 Fix Released
1483956 #1483956 mysql abort when enable super_read_only with read_only 3 High Laurynas Biveinis  10 Fix Released
1287299 #1287299 percona_log_slow_query_plan.test fails randomly 4 Medium Yura Sorokin  10 Fix Released
1287299 #1287299 percona_log_slow_query_plan.test fails randomly 4 Medium Yura Sorokin  10 Fix Released
1370002 #1370002 virtual THD::~THD(): Assertion `timer == __null' failed in sql_class.cc:1799 | abort (sig=6) in THD::~THD 4 Medium Laurynas Biveinis  10 Fix Released
1370002 #1370002 virtual THD::~THD(): Assertion `timer == __null' failed in sql_class.cc:1799 | abort (sig=6) in THD::~THD 4 Medium Laurynas Biveinis  10 Fix Released
1379582 #1379582 tmp->start_utime > now_utime impossibility leading to negative TIME_MS values in processlist 4 Medium Sergei Glushchenko  10 Fix Released
1379582 #1379582 tmp->start_utime > now_utime impossibility leading to negative TIME_MS values in processlist 4 Medium Sergei Glushchenko  10 Fix Released
1389935 #1389935 set --read_only on when --super_read_only is used as command line option 4 Medium Laurynas Biveinis  10 Fix Released
1389935 #1389935 set --read_only on when --super_read_only is used as command line option 4 Medium Laurynas Biveinis  10 Fix Released
1410410 #1410410 innodb_fake_changes cause unknown error code 1000 4 Medium Krunal Bauskar  10 Fix Released
1410410 #1410410 innodb_fake_changes cause unknown error code 1000 4 Medium Krunal Bauskar  10 Fix Released
1470677 #1470677 ALTER TABLE does not allow to change NULL/NOT NULL if foreign key exists 4 Medium Laurynas Biveinis  10 Fix Released
1470677 #1470677 ALTER TABLE does not allow to change NULL/NOT NULL if foreign key exists 4 Medium Laurynas Biveinis  10 Fix Released
1475107 #1475107 DROP TABLE IF EXISTS may brake replication if slave has replication filters 4 Medium Yura Sorokin  10 Fix Released
1475107 #1475107 DROP TABLE IF EXISTS may brake replication if slave has replication filters 4 Medium Yura Sorokin  10 Fix Released
1484432 #1484432 Setting innodb_log_archive crashes --innodb-read-only server | InnoDB: Failing assertion: !srv_read_only_mode in log0log.cc line 2192 4 Medium Laurynas Biveinis  10 Fix Released
1484432 #1484432 Setting innodb_log_archive crashes --innodb-read-only server | InnoDB: Failing assertion: !srv_read_only_mode in log0log.cc line 2192 4 Medium Laurynas Biveinis  10 Fix Released
1491420 #1491420 LRU manager thread accounts its flushes under buffer_flush_background innodb metrics 4 Medium Laurynas Biveinis  10 Fix Released
1491420 #1491420 LRU manager thread accounts its flushes under buffer_flush_background innodb metrics 4 Medium Laurynas Biveinis  10 Fix Released
1491435 #1491435 Page cleaner thread spinning CPU because of heuristics calculation typo 4 Medium Laurynas Biveinis  10 Fix Released
1491435 #1491435 Page cleaner thread spinning CPU because of heuristics calculation typo 4 Medium Laurynas Biveinis  10 Fix Released
1372219 #1372219 Failing assertion: discard.n_recs == 1 in file row0import.cc line 3453 | abort (sig=6) in row_import_update_discarded_flag 5 Low Krunal Bauskar  10 Fix Released
1372219 #1372219 Failing assertion: discard.n_recs == 1 in file row0import.cc line 3453 | abort (sig=6) in row_import_update_discarded_flag 5 Low Krunal Bauskar  10 Fix Released
1472256 #1472256 Thread statistics are not turned on in percona_userstat.test 5 Low Laurynas Biveinis  10 Fix Released
1472256 #1472256 Thread statistics are not turned on in percona_userstat.test 5 Low Laurynas Biveinis  10 Fix Released
This milestone contains Public information
Everyone can see this information.