Release Notes for MariaDB Enterprise Server 10.4.14-8

This eighth release of MariaDB Enterprise Server 10.4 is a maintenance release, including a variety of fixes.

MariaDB Enterprise Server 10.4.14-8 was released on 2020-09-08.

Fixed Security Vulnerabilities

Notable Changes

• Limit innodb_encryption_threads to 255 (MDEV-22258)

• Minimum value of max_sort_length raised to 8 (previously 4) so fixed size data types like DOUBLE and BIGINT are not truncated for lower values of max_sort_length . (MDEV-22715)

• Backport from MariaDB Server 10.5.4 of improvements to DROP TABLE for InnoDB. (MENT-636)

UPDATE privilege for system user mariadb.sys removed for system table mysql.global_priv (MDEV-23237)

Issues Fixed

Can result in data loss

• InnoDB doublewrite recovery can corrupt data pages. (MDEV-11799)

• InnoDB table can disappear when trying to change primary key after disabling Foreign Key checks and violating a Foreign Key constraint. (MENT-804)

• InnoDB corruption in delete buffering. (MDEV-22497)

• Rollback of INSERT fails when column reorder occurs. (MDEV-22637)

• Possible data inconsistency when executing ADD PRIMARY KEY with concurrent DML transactions. (MDEV-23244)

• InnoDB table corruption after DROP INDEX (MDEV-22988)

• ALTER TABLE to extend a CHAR column was incorrectly allowed to be instant. (MDEV-22771)

Can result in a hang or crash

• InnoDB deadlock in FLUSH TABLES .. FOR EXPORT (MDEV-22890)

• InnoDB data file extension is not crash-safe. (MDEV-23190)

• innodb_log_optimize_ddl=OFF is not crash safe. (MDEV-21347)

• Deadlock involving parallel workers, STOP SLAVE , and FLUSH TABLES WITH READ LOCK (MDEV-23089)

• Crashes when running a SQL query containing a specific subquery pattern. (MDEV-23221)

• Dropping the adaptive hash index may cause DDL to lock up InnoDB. (MDEV-22456)

• RESET MASTER TO could result in a crash when the value exceeds the max allowed 2147483647 (MDEV-22451)

• Crash on WITH RECURSIVE large query (MDEV-22748)

• Crash with Prepared Statement with a ? parameter inside a re-used CTE. (MDEV-22779)

• Possible crash after changing the query_cache size. (MDEV-5924)

• Crash in CREATE TABLE AS SELECT when the precision of returning type = 0 (MDEV-22502)

• ENUM or SET in a CREATE TABLE statement which has a 0x00 byte in one of the values could crash the server. (MDEV-22111)

• InnoDB recovery can block server startup. (MENT-915)

• Possible crash of a MariaDB Enterprise Cluster node when KILL is executed (MDEV-23147)

• Possible crash when executing FLUSH PRIVILEGES . (MDEV-23009)

• Server can hang when started with --plugin-load-add=server_audit and records in mysql.plugin refer to non-existent libraries. (MDEV-19918)

• Server hangs on start up when loading MariaDB Enterprise Audit if old SERVER_AUDIT plugin is installed (MENT-273)

Can result in unexpected behavior

• Service shutdown fails if OS datetime has been updated backwards. (MDEV-17481)

• ALTER TABLE .. ANALYZE PARTITION can run for hours for huge tables if engine-independent persistent statistics are enabled, due to reading and locking of all rows in the InnoDB table instead of for the partition. (MDEV-21472)

• UPDATE can fail with privilege error when UPDATE privilege exists at database level but SELECT privilege exists at table level. (MDEV-23010)

• Latency and throughput regression identified in write-heavy benchmarks for latest releases in MariaDB Server 10.2, 10.3, and 10.4. (MENT-909)

• When giving a parallel optimistic slave a replication stop position with START SLAVE UNTIL .. file .. pos stops at an earlier position earlier than defined if the transaction that spans over the given stop position has to roll back due to conflicts. (MDEV-15152)

• mariabackup --prepare does not stop on errors while applying InnoDB redo log. (MDEV-22354)

• Point in time recovery of binary log fails with syntax error when sql_mode=ORACLE. (MDEV-23108)

• Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE .. SELECT when sql_mode=ORACLE. (MDEV-19632)

• Regression in Audit Plugin Performance. (MENT-700)

• ROW_FORMAT mismatch in instant ALTER TABLE . An instant ADD or DROP column or reorder could create a dummy table object with the wrong ROW_FORMAT when innodb_default_row_format was changed between CREATE TABLE and ALTER TABLE . (MDEV-23295)

• Slow InnoDB shutdown on large instances when using Windows OS. (MDEV-22778)

• Rounding functions return wrong datatype. (MDEV-23366, MDEV-23367, MDEV-23368, MDEV-23350, MDEV-23351, MDEV-23337, MDEV-23323)

• PAM v2 plugin produces zombie processes. (MDEV-21385)

• Performance regression when using MariaDB Enterprise Audit. (MENT-870)

Related to install and upgrade

• UNINSTALL PLUGIN and UNINSTALL SONAME can't run if the library file doesn't exist. (MDEV-21258)

Changes in Storage Engines

• This release includes ColumnStore 1.4.4.

Interface Changes

• mariabackup --help command-line option added

• mariabackup --mysqld-args command-line option added

• max_sort_length system variable minimum value changed from 4 to 8

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.4.14-8 is provided for:

• Red Hat Enterprise Linux 8

• Red Hat Enterprise Linux 7

• Red Hat Enterprise Linux 6

• CentOS 8

• CentOS 7

• CentOS 6

• Debian 10

• Debian 9

• Debian 8

• SUSE Linux Enterprise Server 15

• SUSE Linux Enterprise Server 12

• Ubuntu 20.04

• 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

• Upgrade to MariaDB Enterprise Server 10.4

• Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.4