The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2025-03-12. For the latest, interactive version please visit https://mariadb.com/kb/.

Release Notes for MariaDB Enterprise Server 10.5.9-6

This sixth release of MariaDB Enterprise Server 10.5 is a maintenance release. This release includes security fixes.

MariaDB Enterprise Server 10.5.9-6 was released on 2021-03-15.

Fixed Security Vulnerabilities

CVE (with cve.org link)CVSS base score
CVE-2021-27928N/A (Critical)#1

#1:
MariaDB CVEs are assigned a word rating instead of a CVSS base score. See the MariaDB Engineering Policy for details.

Notable Changes

  • The new mariadb-dump --system={all, users, plugins, udfs, servers, stats, timezones} command-line option allows dumping system information in logical form. (MDEV-23630)
  • Added primary host and port info to replica stop messages. (MDEV-10272)
  • New MariaDB Enterprise Backup option --log-innodb-page-corruption to continue the backup process when corruption is encountered. Corrupted pages are logged in backup_corrupted file in the backup destination directory. (MDEV-22929)
  • MariaDB Enterprise Backup adds completed with Error! to the end of the log file if the backup is started with parameter --log-innodb-page-corruption and completed with corrupted tables. The new log entry canceled with Error! will be used when the backup could not be completed. (MENT-1059)

Issues Fixed

Can result in data loss

  • Crash on recovery after server kill during instant ADD COLUMN (MDEV-24323)

Can result in a hang or crash

  • Server crashes upon attempt to update view through second execution of a stored procedure. (MDEV-16940)
  • Possible crash for a query using recursive CTE without having a default schema defined. (MDEV-24019)
  • Server crash on WITH RECURSIVE UNION ALL (CTE) query. (MDEV-23619)
  • Possible crash in replication when applying a transaction that contains cascading foreign key delete for a table and that has an indexed virtual column. (MDEV-23033)
  • Possible crash of the server when audit logging is active. (MENT-1098)
  • Encryption is modifying a freed page for InnoDB, which results in a crash. (MDEV-24695)
  • A query on a table with composite key and range condition on multiple attributes can result in a crash. (MENT-1126)

Can result in unexpected behavior

  • mysqld_safe log messages are missing in the error log file. (MDEV-21367)
  • Unexpected error message when selecting from view that uses mergeable derived table. (MDEV-24314)
  • Permission denied error message is returned on users with SELECT permissions for nested CTEs. (MDEV-20751)
  • Regression: SELECT .. UNION .. with inconsistent column names fails. (MDEV-19179)
  • SELECT INTO OUTFILE used permission 666 where 644 should be used to limit the privileges to change the file. (MDEV-23875)
  • Altered connection limits for user have no effect. (MDEV-17852)
  • Syntax error when using COLLATE for creating virtual columns. (MDEV-12161)
  • ORDER BY in view definition leads to wrong result with GROUP BY on query using view. (MDEV-23826)
  • SUM column from a derived table returns invalid values. (MDEV-23291)
  • With ALTER USER .. IDENTIFIED BY command, password isn't replaced by asterisks in audit log. (MENT-1128)
  • Wrong duplicate primary key error between the history row generated on referential action and the history row on evaluating foreign referential action for self-reference in a system versioned table. (MDEV-21138, MDEV-23644)
  • Wrong number of decimal digits in certain UNION or subquery constellations, like union of unsigned and NULL type. (MDEV-24387)
  • Misleading error message from mariadb-binlog might be interpreted as a point in time recovery is not possible. (MDEV-23846)
  • High memory usage in the optimizer when a query is using SELECT .. FROM tbl .. WHERE unique_key not in (long-list) AND .. unique_key not in (long-list) AND .. (MDEV-24711)
  • S3, same-backend replication: Dropping a table on primary causes error on replica. (MDEV-24351)
  • Flushing starts only when 90% (srv_max_buf_pool_modified_pct) pages are modified. (MDEV-24917)
  • Quick memory exhaustion with extended_keys=on on queries having multiple IN or NOT IN using InnoDB. (MDEV-9750)
  • Enterprise upgrade from 10.4 to 10.5 fails with option disable-s3 in the 10.4 configuration file. (MENT-1068)

Changes in Storage Engines

This release incorporates MariaDB ColumnStore storage engine version 5.5.2.

Interface Changes

  • aria_sort_buffer_size system variable maximum value changed from 18446744073709551615 to 9223372036854775807
  • mariadb-backup --log-innodb-page-corruption command-line option added
  • mariadb-dump --system command-line option added
  • mariadb_es_repo_setup --include-unsupported command-line option added
  • mariadb_es_repo_setup --skip-check-installed command-line option added
  • mariadb_es_repo_setup --version command-line option added
  • mariadb_repo_setup --version command-line option added
  • mariadbd --innodb-idle-flush-pct command-line option removed
  • mariadbd --optimizer-max-sel-arg-weight command-line option added

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.5.9-6 is provided for:

  • CentOS 7
  • CentOS 8
  • Debian 9
  • Debian 10
  • Red Hat Enterprise Linux 7
  • Red Hat Enterprise Linux 8
  • SUSE Linux Enterprise Server 12
  • SUSE Linux Enterprise Server 15
  • Ubuntu 16.04
  • Ubuntu 18.04
  • Ubuntu 20.04
  • Microsoft Windows

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

Installation Instructions

Upgrade Instructions

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.