Release Notes for MariaDB Enterprise Server 10.4.22-14

MariaDB Enterprise Server 10.4.22-14 is a maintenance release of MariaDB Enterprise Server 10.4. This release includes a variety of fixes.

MariaDB Enterprise Server 10.4.22-14 was released on 2021-12-13.

Fixed Security Vulnerabilities

Notable Changes

• Galera updated to 26.4.10

• Enterprise Spider no longer enables pushdown of UDFs and Stored Functions to the Data Node by default: (MDEV-26545)
  • The default value of spider_use_pushdown_udf has changed from -1 to 0
  • In previous releases, Enterprise Spider pushed UDFs and Stored Functions down to the Data Node by default, which could cause query results to be inconsistent.
  • Starting with this release, all UDFs and stored functions are evaluated on the Spider Node by default. If desired, pushdown of UDFs and Stored Functions can be explicitly enabled by setting spider_use_pushdown_udf=1. Testing is recommended to confirm that query results are consistent.

• Performance Schema tables provide descriptions of each column in the COMMENT column option. (MDEV-25325)

• A new system variable wsrep_gtid_seq_no has been added. It is required by MariaDB Enterprise Cluster for the replication of the MariaDB Global Transaction ID to other nodes in the cluster (MENT-932)

Issues Fixed

Can result in a hang or crash

• MariaDB Enterprise Cluster, powered by Galera, can crash on INSERT if the table does not have a primary key and if the data for a field exceeds 4096 bytes. (MDEV-24978)

• When an InnoDB tablespace (.ibd) file is imported using ALTER TABLE .. IMPORT TABLESPACE without a corresponding .cfg file, InnoDB causes a server crash. (MDEV-26131, MDEV-20931)

• When OPTIMIZE TABLE (or mariadb-check -o) is executed against an InnoDB table with a FULLTEXT index, InnoDB can cause a server crash. (MDEV-25702, MENT-1198)

• Resolving aggregate functions that are used in a view can cause in a crash. (MDEV-24454)

• Executing CREATE OR REPLACE TABLE AS SELECT under LOCK TABLE can cause in a crash. (MDEV-23391)

• If two InnoDB tables have a foreign key and an operation cascades from the parent table to the child table, an index on a virtual generated column in the child table can become corrupt. (MDEV-26866)

• MariaDB Enterprise Cluster, powered by Galera, crashes with errors like:
  [ERROR] WSREP: Trx 236236 tries to abort slave trx 236238 (MDEV-25835)

• Server crashes when a table uses a sequence as a column default (DEFAULT NEXT_VALUE(my_seq)) and the table is used concurrently by both a prepared statement and a normal statement. (MDEV-22785)

• InnoDB causes server crash when a table is converted from utf8mb3 to utf8mb4 (MDEV-25951)

• When enabling MariaDB Enterprise Audit, server crash can occur. (MENT-1307)

• MariaDB Enterprise Audit occasionally hangs when rotating logs. (MENT-1339)

• InnoDB sometimes causes server crash during ALTER TABLE .. IMPORT TABLESPACE when the imported tablespace contains columns that have been instantly reordered or dropped. The MariaDB error log contains the following error message: (MDEV-26621, MDEV-18543)
  Schema mismatch (Index field name newcol doesn't match tablespace metadata field name name for field position…

• MariaDB Enterprise Cluster can crash due to an incorrect conflict resolution on multi-master setup. (MDEV-25368, MDEV-25114)

• MariaDB Enterprise Cluster hangs while it is executing DELETE FROM mysql.wsrep_cluster, which can be seen in the process list. (MDEV-26760, MDEV-25883)

Can result in unexpected behavior

• skip_networking does not prevent replication. (MDEV-24969)

• MariaDB Enterprise Cluster joiner node incorrectly uses localhost for TLS certificate verification and fails to join cluster when wsrep_sst_method=mariabackup and encrypt=3 are configured. (MDEV-26360)

• mariadb --binary-mode is not able to replay some mysqlbinlog outputs if
  0 is in the data. (MDEV-25444)

• Memory leak with row-based replication can lead to high memory usage on replica servers. (MDEV-26712)

• SHOW CREATE VIEW and mariadb-dump generate invalid SQL for some complex views. (MDEV-26299)

• When statement-based or mixed replication is used and a DML statement encounters an error in a transaction that creates or drops a temporary table, non-committed writes to transactional tables can be incorrectly replicated to replica servers. (MDEV-26833)

• MariaDB Enterprise Cluster joiner node fails to join cluster when wsrep_sst_method=mariabackup and Backward Compatible SST TLS Mode is configured. (MDEV-26211)

• Spider does not work correctly for UDF and stored functions if used in a query's WHERE conditions. (MDEV-26545)

• If an INVISIBLE column has a computed default value, an INSERT statement that doesn't specify a value for the column causes the default value to be ignored. (MDEV-25891)

• Password validation plugins (including simple_password_check) cause a user's existing password hash to be removed from the server's in-memory privilege cache when the user tries to change their password to an invalid password. (MDEV-26650)

• In packets sent from the server, a column's "Original Name" field can contain the column's alias instead of original name of the column. This metadata mismatch can cause MariaDB Connectors to raise an exception. (MDEV-23519)

• When using MariaDB Enterprise Cluster and MariaDB Replication with GTID between two clusters, MariaDB Replication between the clusters is not working. Also, system variable wsrep_gtid_seq_no is missing. (MENT-1324)

• With MariaDB Enterprise Cluster, a TRUNCATE on a table with a Foreign Key Constraint is not replicated to other nodes. (MDEV-26053)

Related to install and upgrade

• On CentOS 7, auth_pam_tool has incorrect permissions. (MDEV-26380)

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.4.22-14 is provided for:

• CentOS 7 (x86_64)

• CentOS 8 (x86_64, ARM64)

• Debian 9 (x86_64, ARM64)

• Debian 10 (x86_64, ARM64)

• Microsoft Windows (x86_64)

• Red Hat Enterprise Linux 7 (x86_64)

• Red Hat Enterprise Linux 8 (x86_64, ARM64)

• SUSE Linux Enterprise Server 12 (x86_64)

• SUSE Linux Enterprise Server 15 (x86_64, ARM64)

• Ubuntu 18.04 (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

• MariaDB Enterprise Server 10.4

• Enterprise Cluster Topology with MariaDB Enterprise Server 10.4

• Primary/Replica Topology with MariaDB Enterprise Server 10.4

• Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.4

• Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.4

Upgrade Instructions

• Upgrade to MariaDB Enterprise Server 10.4

• Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.4