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

  • innodb_thread_concurrency

  • innodb_commit_concurrency

  • innodb_replication_delay

  • innodb_concurrency_tickets

  • innodb_thread_sleep_delay

  • innodb_adaptive_max_sleep_delay

• Spider storage engine now allows parameters driver and filedsn 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 wrapper odbc (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 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 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 to 0 (now deprecated)

• innodb_concurrency_tickets system variable default value changed from 5000 to 0 (now deprecated)

• innodb_thread_sleep_delay system variable default value changed from 10000 to 0 (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 with the enterprise lifecycle, MariaDB Enterprise Server 10.5.5-3 is provided for:

• AlmaLinux 8 (x86_64, ARM64)

• AlmaLinux 9 (x86_64, ARM64)

• Debian 11 (x86_64, ARM64)

• Debian 12 (x86_64, ARM64)

• Microsoft Windows (x86_64) (MariaDB Enterprise Cluster excluded)

• Red Hat Enterprise Linux 8 (x86_64, ARM64)

• Red Hat Enterprise Linux 9 (x86_64, ARM64)

• Rocky Linux 8 (x86_64, ARM64)

• Rocky Linux 9 (x86_64, ARM64)

• SUSE Linux Enterprise Server 12 (x86_64)

• SUSE Linux Enterprise Server 15 (x86_64, ARM64)

• Ubuntu 20.04 (x86_64, ARM64)

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.

Installation Instructions

• MariaDB Enterprise Server 10.5

• Enterprise Cluster Topology with MariaDB Enterprise Server 10.5

• Primary/Replica Topology with MariaDB Enterprise Server 10.5

• ColumnStore Object Storage Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 23.02

• ColumnStore Shared Local Storage Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 23.02

• HTAP Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 23.02

• Single-Node Enterprise ColumnStore 23.02 with MariaDB Enterprise Server 10.5and Object Storage

• Single-Node Enterprise ColumnStore 23.02 with MariaDB Enterprise Server 10.5

• Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.5

• Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.5

Upgrade Instructions

• Upgrade to MariaDB Enterprise Server 10.5

• Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.5

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}