Release Notes for MariaDB Enterprise Server 10.5.5-3
This third release of MariaDB Enterprise Server 10.5 is a maintenance release, including a variety of fixes.
MariaDB Enterprise Server 10.5.5-3 was released on 2020-09-08.
Note
With MariaDB Enterprise Server 10.5 "mysql" command names are replaced with "mariadb" command names. Symbolic links are in place to maintain backward compatibility with the old names and prevent disruption. (MDEV-21303)
Fixed Security Vulnerabilities
CVE (with cve.org link) | CVSS base score |
---|---|
CVE-2021-2022 | 4.4 |
Notable Changes
- UPDATE privilege for system user
mariadb.sys
removed for system table mysql.global_priv (MDEV-23237)
- Deprecated InnoDB configuration parameters: (MDEV-23379)
- Spider storage engine now allows parameters
driver
andfiledsn
for the ODBC wrapper. System tables spider_link_mon_servers , spider_tables , spider_xa_member , and spider_xa_failed_log updated. (MENT-812)
- Setting SHUTDOWN_WAIT_FOR_SLAVES now only requires SHUTDOWN privilege, not the generic SUPER privilege. (MENT-731)
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)
- Possible data inconsistency when executing
ADD PRIMARY KEY
with concurrent DML transactions. (MDEV-23244)
- InnoDB table corruption can occur 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)
- 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 crashes upon SHOW CREATE PROCEDURE for stored procedures after upgrade from MariaDB Server 10.3. (MENT-819)
- Crash with
CREATE TEMPORARY TABLE .. ENGINE=SPIDER
using wrapperodbc
(MENT-807)
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)
- 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 instantADD
orDROP
column or reorder could create a dummy table object with the wrongROW_FORMAT
when innodb_default_row_format was changed between CREATE TABLE and ALTER TABLE. (MDEV-23295)
- Slow InnoDB shutdown on large instance 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)
- Fixes to performance regressions introduced in MariaDB 10.5.4. (MDEV-23369, MDEV-23410)
- Change in InnoDB I/O thread count is not reflected in system variables. (MENT-866)
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 Enterprise ColumnStore 1.5.3 (plugin version 1.5.3.2).
- This release includes Enterprise Spider 3.4, including ODBC Wrapper support.
Interface Changes
- innodb_adaptive_max_sleep_delay system variable default value changed from
150000
to0
(now deprecated)
- innodb_concurrency_tickets system variable default value changed from
5000
to0
(now deprecated)
- innodb_thread_sleep_delay system variable default value changed from
10000
to0
(now deprecated)
- spider_link_mon_servers system table schema changed
- spider_tables system table schema changed
- spider_xa_failed_log system table schema changed
- spider_xa_member system table schema changed
Platforms
In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.5.5-3 is provided for:
- CentOS 8
- CentOS 7
- Debian 10
- Debian 9
- Red Hat Enterprise Linux 8
- Red Hat Enterprise Linux 7
- 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".
Note
MariaDB Enterprise Server 10.5 removes support for Red Hat Enterprise Linux (RHEL) 6 and CentOS 6.