Release Notes for MariaDB Enterprise Server 10.4.7-2

Fixed Security Vulnerabilities

Notable Changes

• Merge relevant InnoDB changes from MySQL 5.7.27

• Spider now maintains sql_mode between Spider Node and Data Nodes

• Adjust spin loops to the x86 PAUSE instruction latency

• Compatibility change: Change innodb_log_optimize_ddl to OFF by default

• Compatibility change: Change innodb_adaptive_hash_index to OFF by default

• 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)

Issues Fixed

• SERVER_AUDIT v2 does not work with PS protocol

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

• Changes to mysql_install_db script text

• 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)

• 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)

• 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)

• Test change: innodb.trx_id_future fails on 10.3+ (MDEV-20138)

• Possible foreign key corruption for ALTER TABLE … ADD COLUMN with InnoDB (MDEV-19630)

• Corruption after instant ADD or DROP when the index tree shrinks (MDEV-19916)

• Cannot load compressed BLOB with InnoDB (MDEV-19974)

• Bug in versioned tables when deleting history (MDEV-19814)

• Compressed columns cannot be restored from dump (MDEV-17363)

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

• Encrypted temporary tables cannot be read with full_crc32 (MDEV-20340)

• Change of COLLATE with InnoDB unnecessarily requires ALGORITHM=COPY (MDEV-17301)

• Changing an index comment unnecessarily rebuilds index (MDEV-18266)

• Server hangs on shutdown during installation of Spider (MDEV-20179)

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

• spider_sync_sql_mode system variable added

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.4.7-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

Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see "MariaDB Corporation Engineering Policies".

Installation Instructions

• MariaDB Enterprise Server 10.4

• Enterprise Cluster Topology with MariaDB Enterprise Server 10.4

• Primary/Replica Topology with MariaDB Enterprise Server 10.4

• Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.4

• Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.4

Upgrade Instructions