Release Notes for MariaDB Enterprise Server 10.5.5-3
This page is part of MariaDB's Documentation.
The parent of this page is: Release Notes for MariaDB Enterprise Server 10.5
Topics on this page:
Overview
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 |
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_ , spider_mon_ servers tables , spider_xa_ , and spider_member xa_ updated. (MENT-812)failed_ log Setting SHUTDOWN_
WAIT_ now only requires SHUTDOWN privilege, not the generic SUPER privilege. (MENT-731)FOR_ SLAVES
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_ is not crash safe. (MDEV-21347)optimize_ ddl=OFF 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_ uponCONVERSION_ FAILED 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_ was changed between CREATE TABLE and ALTER TABLE. (MDEV-23295)row_ format 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_ system variable default value changed frommax_ sleep_ delay 150000
to0
(now deprecated)innodb_
concurrency_ system variable default value changed fromtickets 5000
to0
(now deprecated)innodb_
thread_ system variable default value changed fromsleep_ delay 10000
to0
(now deprecated)spider_
link_ system table schema changedmon_ servers spider_
tables system table schema changedspider_
xa_ system table schema changedfailed_ log spider_
xa_ system table schema changedmember
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.
Installation Instructions
Enterprise Cluster Topology with MariaDB Enterprise Server 10.5
Primary/Replica Topology with MariaDB Enterprise Server 10.5
HTAP Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 5
Single-Node Enterprise ColumnStore 5 with MariaDB Enterprise Server 10.5 and Object Storage
Single-Node Enterprise ColumnStore 5 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