Release Notes for MariaDB Enterprise Server 10.2.26-2

Fixed Security Vulnerabilities

Notable Changes

• Merge upstream changes from MyRocks (MDEV-19795)

• DISKS plugin now requires the FILE privilege to display information in the disks table in the information schema, the table will otherwise be empty (MDEV-18328)

• Merge relevant InnoDB changes from MySQL 5.7.27

• Compatibility change: Change innodb_log_optimize_ddl to OFF by default

• Compatibility change: Change innodb_adaptive_hash_index to OFF by default

Issues Fixed

• SERVER_AUDIT v2 does not work with PS protocol

• DROP TABLE IF EXISTS killed on master but was replicated (MDEV-20348)

• Post-merge fixes for rocksdb.group_min_max test (MDEV-20113)

• Replication hangs with "preparing" and never starts (MDEV-20247)

• Failing assertion when REDO log files reach 512Gb while preparing backup (MDEV-20060)

• Removed --rsync legacy option from enterprise build of MariaDB Backup

• Changes to mysql_install_db script text

• Temporary tables created with data-at-rest encryption are not fully encrypted (MDEV-17228)

• InnoDB bugs related to creating tables (MDEV-19292, MDEV-20102)

• ALTER TABLE for InnoDB can result in a crash in some cases (MDEV-15641)

• Bugs in InnoDB related to indexed virtual columns (MDEV-16222), (MDEV-17005)

• Failing tests in buildbot related to FULLTEXT INDEX (MDEV-14154)

• Server startup bug with encrypted InnoDB table (MDEV-19914)

• Possible crash when Galera and foreign key is used, if the referenced record is deleted at the same time (MDEV-19660)

• Recovery with mariabackup crash related to InnoDB with custom innodb_data_file_path (MDEV-19978)

• Add page-id matching check in innochecksum tool (MDEV-19871)

• DROP TEMPORARY table is logged despite no CREATE was logged in binary log (MDEV-20091)

• mysql_upgrade_service throws exception upgrading from 10.0 to 10.3 (MDEV-19427)

• Loading the audit plugin causes performance regression (MDEV-18661)

• REPLACE on table with virtual_field can cause crash (MDEV-19771)

• Fix Aria ER_CRASHED_ON_USAGE and Assertion (MDEV-19595)

Interface Changes

• mariabackup --rsync option removed

• mysqld --innodb-encrypt-temporary-tables option added

• mysqld --rocksdb-cache-dump option added

• mysqld --rocksdb-cache-high-pri-pool-ratio option added

• mysqld --rocksdb-cache-index-and-filter-with-high-priority option added

• mysqld --rocksdb-delete-cf option added

• mysqld --rocksdb-enable-insert-with-update-caching option added

• mysqld --rocksdb-read-free-rpl-tables option removed

• mysqld --rocksdb-rollback-on-timeout option added

• mysqld --rocksdb-stats-level option added

• Innodb_encryption_n_temp_blocks_decrypted status variable added

• Innodb_encryption_n_temp_blocks_encrypted status variable added

• wsrep_applier_thread_count status variable added

• wsrep_rollbacker_thread_count status variable added

• innodb_encrypt_temporary_tables system variable added

• rocksdb_cache_dump system variable added

• rocksdb_cache_high_pri_pool_ratio system variable added

• rocksdb_cache_index_and_filter_with_high_priority system variable added

• rocksdb_delete_cf system variable added

• rocksdb_enable_insert_with_update_caching system variable added

• rocksdb_read_free_rpl_tables system variable removed

• rocksdb_rollback_on_timeout system variable added

• rocksdb_stats_level system variable added

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.2.26-2 is provided for:

• CentOS 7

• CentOS 6

• Debian 9

• Debian 8

• Red Hat Enterprise Linux 7

• Red Hat Enterprise Linux 6

• Ubuntu 18.04

• Ubuntu 16.04

• Microsoft Windows

Installation Instructions

• MariaDB Enterprise Server 10.2

• Enterprise Cluster Topology with MariaDB Enterprise Server 10.2

• Primary/Replica Topology with MariaDB Enterprise Server 10.2

Upgrade Instructions

• Upgrading to MariaDB Enterprise Server 10.2 on CentOS 7

• Upgrading to MariaDB Enterprise Server 10.2 on Debian 9

• Upgrading to MariaDB Enterprise Server 10.2 on Red Hat Enterprise Linux 7

• Upgrading to MariaDB Enterprise Server 10.2 on Ubuntu 18.04