Galera updated to 26.4.27
Proxy protocol connections from remote host leaked memory, if DNS name resolution is allowed (skip_name_resolve is not set) (MENT-2685)
For users without PROCESS privilege, SHOW PROCESSLIST and INFORMATION_SCHEMA.PROCESSLIST will now show events running under the same user context. (MDEV-34482)
When accessing a MEMORY table whose data is lost to restarting a read-only server with replication connection(s) configured for the first time, the automatically-generated TRUNCATE query in the Binary Log is now annotated with a comment and accompanied by a warning in the Error Log. (MDEV-38600)
DROP PARTITION, CONVERT OUT require both ALTER and DROP privileges (MDEV-39028)

Issues Fixed

Can result in data loss

Crash recovery may fail after a crash during an instant ALTER TABLE…PAGE_COMPRESSED=1. Fix: make the operation rebuild the table. (MDEV-38079)
Replica updates table to wrong values, further replication failures (MDEV-38731)
Galera snapshot transfer with the default wsrep_sst_method=rsync could create corrupted backups when any InnoDB tables contain FULLTEXT INDEX. (MDEV-32115)
Replication would break (or diverge) with STATEMENT binlog format when check_constraint_checks was modified from the configured startup value because the variable was not written to the binary log with the affected event. (MDEV-32447)
Fixed issue when using ROWS EXAMINED with log_out=TABLE This could, depending on version, cause a crash or having the next query aborting with 'empty result' (MDEV-38683)

Can result in hang or crash

Fixed a crash in InnoDB when processing long or encoded database names in Foreign Keys (MDEV-24356)
Fixed a server crash that could occur during query optimization when a stored procedure queries a view containing CONCAT or GROUP_CONCAT functions. (MDEV-36678)
Warning: Memory not freed: 32" after server shutdown when SELECT COLUMN_JSON() has been used (MDEV-36929)
PAGE_COMPRESSED ALTER TABLE operations inconsistent with innodb_file_per_table setting (MDEV-37886)
CREATE TABLE ... SELECT on mysql.innodb_table_stats can hang (MDEV-38822)
Fixed a server assertion that occurred when an InnoDB DDL operation (such as ALTER TABLE) encountered a lock wait timeout during internal statistics updates. (MDEV-38882)
JSON search functions, JSON_EXISTS, JSON_EXTRACT, JSON_VALUE, JSON_QUERY, JSON_CONTAINS, JSON_CONTAINS_PATH, JSON_ARRAY_APPEND, JSON_ARRAY_INSERT, JSON_LENGTH, JSON_INSERT, JSON_REMOVE, JSON_KEYS, could result in a overwrite of memory resulting in a crash. (MDEV-39213)
Fixed critical crashes in InnoDB purge threads when processing tables with indexed virtual columns. Resolved race conditions where purge workers incorrectly reused cached TABLE* objects across different tables in the same batch, and added retry logic to handle concurrent DDL operations that could invalidate table handles during purge processing. (MDEV-39261)
By inserting a crafted large JSON value into the mysql.global_priv table and triggering FLUSH PRIVILEGES, the server can crash (MDEV-39266)
Potential MariaDB Cluster hang when a DDL command or Sequence access is replicated to a cluster by async replication (MENT-2671, MDEV-38260)
Server can hang or crash after FLUSH QUERY CACHE is executed (MDEV-25365)
If user has limited write set size using wsrep_max_ws_rows or wsrep_max_ws_size for Galera then multi-table update that updates transactional and non-transactional table is not allowed. Furthermore, limiting write set size is not allowed if there is active Galera transaction. (MDEV-28750)
In SELECT statements where a HAVING claused used JSON_KEYS the server could crash. (MDEV-33984)
Extended the dependency tracking of DDL statements operating on a table which is referenced by foreign key constraints. This prevents potential replication time conflicts of such DDL statements with other transactions operation on the foreign key referencing tables. (MDEV-34784)
MariaDB crashes when parsing fuzzer generated PARTITION (MDEV-36362)
Fixed a critical assertion failure in InnoDB that occurred during consecutive ALTER IGNORE TABLE operations when using the COPY algorithm. The fix prevents a race condition where the background purge thread could "pin" a table object while it was being renamed or dropped, leading to a server crash. (MDEV-36436)
Corrected a server crash that could occur when strings where appended in a JSON_NORMALIZE SQL function. (MDEV-37640)
Fixed an issue where a parallel replica configured to skip ER_CONNECTION_KILLED (i.e. --slave-skip-errors=1927) can hang or crash because it honored this configuration, but should not (this error code is internally repurposed for replication worker threads and cannot be ignored). (MDEV-38624)
wsrep_slave_FK_checks configuration option was deprecated and from no on has no effect. Slave foreign key checks are always on as otherwise leads to massive data inconsistency on all replicas which subsequently results in master node abort. (MDEV-38787)
An update on a view which is using a table with a Sequence and NEXTVAL can crash the server (MDEV-38815)
Regression on MDL conflict handling (MDEV-38895)
Assertion on InnoDB temporary table, partition table and also during partial rollback when an ALTER IGNORE is executed. (MDEV-38928)
If wsrep_restart_slave is used the MariaDB Enterprise Cluster replica node may hang during shutdown. (MDEV-39011)
Fixed a server crash in the InnoDB purge thread caused by missing indexed virtual column data in the undo log during UPDATE operations. (MDEV-39081)
In a multi-table UPDATE, the table list could incorrectly include tables that were not opened because they were not truly modified. This occurred when an UPDATE modified a table referenced by a foreign key constraint from a table that was not part of the multi-table update. (MDEV-39685)

Can result in unexpected behaviour

Empty string is erroneously allowed as a GEOMETRY column value (MDEV-15479)
Fixes the issue occurred when ALTER TABLE contained duplicate DROP FOREIGN KEY operations (e.g., "DROP FOREIGN KEY f1, DROP FOREIGN KEY f1"). (MDEV-19194)
The Debian helper script previous tried to CHECK TABLE on all Aria/MyiSAM tables. The discovery and execution though a combination of bash and SQL escaping that resulted in incorrect table names being checked in a variety of situtions. Because Aria has crash recovery the Debian's auto-check table on startup functionality was removed. (MDEV-34902)
Fix InnoDB index corruption when renaming key names with case-only differences. (MDEV-34951)
Parallel replication hang and stall due to incorrectly handled row lock conflict, missing deadlock kill (MDEV-37133)
Fixed mariabackup to report my_close() failures and prevent false success messages when disk space is exhausted. (MDEV-38562)
An UPDATE could fail to return the error ER_CHECKREAD when innodb_snapshot_isolation=ON and the transaction that had last modified the record was committed during the lock acquisition. (MDEV-39263)
mbstream insufficient path validation (MDEV-39408)
wsrep unsafe handling of parameters (MDEV-39413)
FILE privilege isn't checked for derived table (MDEV-39493)
A parameter-injection gap existed in wsrep_sst_rsync because it failed to validate the joiner-supplied WSREP_SST_OPT_REMOTE_USER and WSREP_SST_OPT_REMOTE_PSWD values before interpolating them into the donor-written stunnel.conf and the rsync magic file. (MDEV-39648)
The wsrep_notify_cmd functionality was susceptible to a parameter-injection vulnerability, as it failed to validate the peer-supplied wsrep_node_name and wsrep_node_incoming_address values before interpolating them into the notification command line. (MDEV-39721)
An appropriately privileged user (with SUPER privileges) could execute shell commands as the uid of the mariadbd process because the values of the system variables wsrep_sst_donor and wsrep_sst_receive_address, which can be modified at runtime, were not properly sanitized when used to construct a shell command. (MDEV-39676)
An appropriately privileged user (with SUPER or SYSTEM_VARIABLES_ADMIN privileges) could execute shell commands as the uid of the mariadbd process because the values of the system variable wsrep_sst_auth , which can be modified at runtime, were not properly sanitized when used to construct a shell command. (MENT-2692)
An appropriately privileged user (with SUPER or SYSTEM_VARIABLES_ADMIN privileges) could execute shell commands as the uid of the mariadbd process because the values of the system variable wsrep_sst_node_address , which can be modified at runtime, were not properly sanitized when used to construct a shell command. (MENT-2693)
A MariaDB Enterprise Cluster SST is not possible with datadir locatated on NFS and log-bin enabled (MENT-2435)
When a mariadb server operates as a donor node in a galera cluster and uses mariabackup SST method, it will spawn mariabackup process to prepare the backup file and sending it to the joiner node. In earlier versions, this spawned mariabackup process inherited the max open file limits set for the parent mariadb server process. This has been changed so that the mariabackup process now honors the open_files_limit variable value configured in [mariabackup] group in the mariadb configuration file and mariabackup process can have different open file limits than the mariadb server, (MDEV-21935)
Queries with IN predicates operating on NULL values could sometimes return wrong results. (MDEV-32868)
For INSERT.. ON DUPLICATE KEY UPDATE, AFTER UPDATE trigger is now always executed in case of duplicate key, even if update did not result in any data changes. This matches the existing behavior of UPDATE command. (MDEV-33083)
mariabackup prepare fails with data-at-rest encryption and "-u root" option (MDEV-34570)
Master & Relay Log info files read 2^31 and above incorrectly (MDEV-38020)
Fixed an issue where the InnoDB system tablespace failed to shrink due to legacy internal tables. MariaDB now automatically detects and removes these orphaned entries during startup, allowing for successful defragmentation and reduction of the tablespace size. (MDEV-38412)
mysql_change_user() with long passwords throws an error (MDEV-38550)
On 64-bit systems other than IBM AIX, the minimum and default values of innodb_buffer_pool_size_max were changed to 8 MiB and 8 TiB, respectively. (MDEV-38671)
An error during the execution of CREATE TEMPORARY TABLE…SELECT no longer results in a rollback of the entire transaction, but of the failing statement. (MDEV-38769)
Fixed incorrectly formatted session tracking info in OK packet, after changing to database with UTF16/UTF32 default charset (MDEV-38954)
After a successful execution of SET GLOBAL innodb_buffer_pool_size, the buffer pool would be included in future core dumps, contrary to the expectation on Linux and FreeBSD. (MDEV-38958)
ALTER TABLE ... IGNORE could trigger the assertion trx->undo_no == 1 in InnoDB's undo log handling when a duplicate key error occurred during the copy phase. (MDEV-38993)
The error message ER_CHECKREAD (1020) was revised to suggest that InnoDB has rolled back the transaction: "try restarting transaction" (MDEV-39264)
SHOW CREATE ROUTINE does not apply to roles (MDEV-39288)
Write set buffers were released too early in the Galera library causing failure on IST with message "IST didn't contain all write sets, +expected last : last received: ". (MDEV-39643)
The server failed to parse schema-qualified table names when the unquoted table name began with a digit. (MDEV-39654)

In case if the view mysql.user was created (e.g. in 10.6) with a server with an unexpected character_set_client or collation_connection, e.g. utf8mb3 and utf8mb3_general_ci, mysql_upgrade does not fix it to the expected latin1 and latin1_swedish_ci. (MDEV-38698)
No longer necessary RPM conflict between between MariaDB-common and mysql-common removed. (MDEV-38771)
Restored galera_new_cluster script functionality to take optional service name. (MDEV-39262)
InnoDB would fail to start up on data files from MariaDB Server 10.x or earlier when innodb_force_recovery=6 is specified. (MDEV-39303)

The setting innodb_log_file_mmap=ON did not enable memory-mapped log file parsing. (MDEV-38730)
InnoDB will initiate page writes and checkpoints from a single thread also during startup and shutdown, which improves performance. (MDEV-38968)
The PERFORMANCE_SCHEMA instrument wait/synch/rwlock/innodb/log_latch was removed in order to improve throughput by 0.5% or more. (MDEV-39040)
Performance improvement in the oltp_read_write benchmark with transaction-isolation=READ-COMMITTED. (MENT-2687)

Unexpected results

Change the "-0" results in many SELECT scenarios to just return "0". (MDEV-38670)
wsrep_slave_FK_checks configuration option was deprecated and from now on has no effect. Slave foreign key checks are always on as otherwise leads to massive data inconsistency on all replicas which subsequently results in master node abort. (MDEV-39385)
Incorrect Calculation while using Avg Function (MDEV-23278)
SHOW BINLOG EVENTS showed incorrect/inverted values for foreign_key_checks, check_constraint_checks, sql_auto_is_null, and unique_checks flags. (MDEV-29804)
0 changed to 0.0 caused by DISTINCT and UNION ALL (MDEV-30255)
Optimizer trace does not escape double quotes, produces invalid JSON (MDEV-30354)
CHANGE MASTER TO is implicitly changing the value of 'Using_Gtid' from 'No' to 'No' (MDEV-37842)
Master/Relay Log Info files ignore trailing garbage and overflows in numeric lines (MDEV-38010)
Incorrect HAVING clause evaluation on grouped derived tables. (MDEV-38070)
Correct JSON_EXTRACT to return the correct results when its input is from a derived table. It previously incorrectly returned NULL. (MDEV-38873)
Default expressions for table columns previously allowed an incompatible mix of collations with the functions IF, NVL2, IFNULL. Now ER_CANT_AGGREGATE_2COLLATIONS is returned. (MDEV-39002)
Is was previously possible to insert 0 or "0" into an ENUM where the ENUM defination didn't include these values. Now an Error WARN_DATA_TRUNCATED is returned in sql_mode=STRICT_ALL_TABLES. (MDEV-39043)
Wrong Results in Identical Queries Involving Grouping and Bitwise NOT (~) (MDEV-39131)
Incorrect result with LEFT JOIN and QUOTE (MDEV-39235)
InnoDB system tablespace autoshrink fails with error "InnoDB: Cannot shrink the system tablespace; there is not much space to reclaim (last used extent=<N+64>, fixed size=..., header size=<N+64>" although shrinking should be possible (MENT-2690)

Changelog

For the complete list of changes in this release, see the changelog.

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 11.4.12-9 is provided for:

AlmaLinux 8 (x86_64, ARM64)
AlmaLinux 9 (x86_64, ARM64)
AlmaLinux 10 (x86_64, ARM64)
Debian 11 (x86_64, ARM64)
Debian 12 (x86_64, ARM64)
Oracle Linux 8 (x86_64, ARM64)
Oracle Linux 9 (x86_64, ARM64)
Oracle Linux 10 (x86_64, ARM64)
Red Hat Enterprise Linux 8 (x86_64, ARM64)
Red Hat Enterprise Linux 9 (x86_64, ARM64, PPC64LE)
Red Hat Enterprise Linux 10 (x86_64, ARM64)
Rocky Linux 8 (x86_64, ARM64)
Rocky Linux 9 (x86_64, ARM64)
Rocky Linux 10 (x86_64, ARM64)
SUSE Linux Enterprise Server 15 (x86_64, ARM64)
Ubuntu 22.04 (x86_64, ARM64)
Ubuntu 24.04 (x86_64, ARM64)
Microsoft Windows (x86_64) (Without MariaDB Enterprise Cluster (Galera) support)
Red Hat UBI 8 (x86_64, ARM64)
- Red Hat UBI 8 is part of the Enterprise Server Docker Image. It does not support MariaDB Enterprise Cluster (Galera) or MariaDB ColumnStore.

Some components of MariaDB Enterprise Server are supported on a subset of platforms. See MariaDB Engineering Policies for details.

Installation Instructions

Upgrade Instructions

Upgrade to MariaDB Enterprise Server 11.4

PreviousWhat's New in MariaDB Enterprise Server 11.4 NextRelease Notes for MariaDB Enterprise Server 11.4.10-8

Last updated 10 days ago

Was this helpful?

Fixed Security Vulnerabilities

Changes in Storage Engines

Notable changes