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 (with cve.org link)

CVSS base score

CVE-2021-27928

N/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)
Parameter innodb_idle_flush_pct has no effect and is defined as deprecated. (MDEV-24536)
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)
wsrep_provider and wsrep_notify_cmd system variables are read-only. (MDEV-25179)
Galera wsrep library updated to 26.4.7 in MariaDB Enterprise Cluster.
CREATE USER and ALTER USER allow either order for ACCOUNT LOCK and PASSWORD EXPIRE (MDEV-24098)

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

Possible segfault on CREATE TABLE with explicit FTS_DOC_ID_INDEX using multiple fields. (MDEV-24403)
Server crashes upon attempt to update view through second execution of a stored procedure. (MDEV-16940)
CREATE VIEW containing WITH clause can crash. (MDEV-22781)
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)
Server hang due to Galera lock conflict resolution. (MDEV-23328)
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 lock conflicts between two wsrep high priority threads in MariaDB Enterprise Cluster on tables having unique secondary keys. (MDEV-23851)
Server crash when VALUE() uses a subselect. (MDEV-24675)
Possible crash of the server when audit logging is active. (MENT-1098)
MariaDB Enterprise Cluster crash after execution of XA START (MDEV-24469)
Hang with innodb_use_native_aio=0 and innodb_write_io_threads=1 (MDEV-24313)
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

SHOW GRANTS is missing the WITH GRANT privilege for roles. (MDEV-24289)
mysqld_safe log messages are missing in the error log file. (MDEV-21367)
CHECK_CLAUSE field in INFORMATION_SCHEMA.CHECK_CONSTRAINTS truncates check constraints expressions. (MDEV-24139)
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)
Race condition between KILL and transaction commit with MariaDB Enterprise Cluster. (MDEV-23536)
Plugin system variables and activation options can break mariadbd --wsrep_recover for MariaDB Enterprise Cluster. (MDEV-20717)
SELECT INTO OUTFILE used permission 666 where 644 should be used to limit the privileges to change the file. (MDEV-23875)
Syntax error on correct syntax for CREATE VIEW that includes X is null = 0 (MDEV-24194)
Altered connection limits for user have no effect. (MDEV-17852)
Syntax error when using COLLATE for creating virtual columns. (MDEV-12161)
Auto purge of relaylogs stops when relay-log-file is slave-relay-log.999999 and slave_parallel_threads is enabled. (MDEV-8134)
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)
server_audit doesn't respect filters for PROXY_CONNECT events. (MDEV-24318)
server_audit plugin doesn't consider proxy users in server_audit_excl_users and server_audit_excl_users (MDEV-19442)
With ALTER USER .. IDENTIFIED BY command, password isn't replaced by asterisks in audit log. (MENT-1128)
UPDATE does not insert history row for system versioned or application period based tables if the row has not changed. (MDEV-23446)
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)
[CREATE TABLE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements-and-structure/sql-statements/data-definition/create/create-table) .. SELECT FROM does not create table if VALUE() is not using a scalar value. (MDEV-24618)
InnoDB may report incorrect binlog position information after RESET MASTER (MDEV-22351)
Sequences which are used as default by a table are not dumped in right order by mariadb-dump (MDEV-21785)
SHOW CREATE USER generates invalid SQL for user where password expiry and account lock set. (MDEV-24098)
Garbd of MariaDB Enterprise Cluster can't initiate SST (MDEV-23647)
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)
ALTER TABLE for tables with CHECK CONSTRAINTS returns with Out of Memory error. (MDEV-24274)
Alter rename table does not remove table from performance_schema.objects_summary_global_by_type when using algorithm=copy (MDEV-24364)
Persistent statistics are lost for InnoDB table after ALTER TABLE (MDEV-24564)
The default setting of innodb_max_dirty_pages_pct_lwm=0 has effects on innodb_adaptive_flushing=ON with results in a performance regression. (MDEV-24537)
Accessing INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION may break innodb_open_files logic. (MDEV-24190)
performance_schema.events_transactions_history_long.trx_id reports garbage. (MDEV-24600)
S3, same-backend replication: Dropping a table on primary causes error on replica. (MDEV-24351)
BINLOG REPLAY privilege is missing from SHOW PRIVILEGES (MDEV-24344)
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)

mariadb-upgrade fails with error messages ALGORITHM=INSTANT is not supported for this operation (MDEV-16735)
mariadb-upgrade hangs when executing ALTER TABLE on the mysql.event system table, if the table is not empty (MDEV-24452)
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
CHECK_CONSTRAINTS information schema table schema changed
group_concat_max_len system variable maximum value changed from 18446744073709551615 to 4294967295
innodb_idle_flush_pct system variable removed
innodb_write_io_threads system variable minimum value changed from 1 to 2
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
max_sort_length system variable minimum value changed from 8 to 64
optimizer_max_sel_arg_weight system variable added
setup_actors performance schema table schema changed
THREAD_POOL_QUEUES information schema table schema changed

Platforms

In alignment with the enterprise lifecycle, MariaDB Enterprise Server 10.5.9-6 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".

Installation Instructions

Upgrade Instructions

PreviousRelease Notes for MariaDB Enterprise Server 10.5.10-7 NextRelease Notes for MariaDB Enterprise Server 10.5.8-5

Last updated 10 days ago

Was this helpful?