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.mitre.org link)

CVSS base score

CVE-2021-27928

N/A #f1

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

  • CREATE USER and ALTER USER allow either order for ACCOUNT LOCK and PASSWORD EXPIRE (MDEV-24098)

  • Galera wsrep library updated to 26.4.7 in MariaDB Enterprise Cluster.

Changes in Storage Engines

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

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

  • Possible crash of the server when audit logging is active. (MENT-1098)

  • A query on a table with composite key and range condition on multiple attributes can result in a crash. (MENT-1126)

  • MariaDB Enterprise Cluster crash after execution of XA START (MDEV-24469)

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_incl_users (MDEV-19442)

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

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

  • 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 .. SELECT FROM does not create table if VALUE() is not using a scalar value. (MDEV-24618)

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

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

  • Quick memory exhaustion with extended_keys=on on queries having multiple IN or NOT IN using InnoDB. (MDEV-9750)

  • ALTER TABLE for tables with CHECK CONSTRAINTS returns with Out of Memory error. (MDEV-24274)

Install and Upgrade

  • ALTER TABLE event takes infinite time which, for example, breaks mariadb-upgrade to 10.5 (MDEV-24452)

  • Enterprise upgrade from 10.4 to 10.5 fails with option disable-s3 in the 10.4 configuration file. (MENT-1068)

  • mariadb-upgrade fails with error messages ALGORITHM=INSTANT is not supported for this operation (MDEV-16735)

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

Upgrade Instructions