MariaDB 10.11.14 Release Notes
Alternate download from mariadb.org
Release date: 6 Aug 2025
MariaDB 10.11 is a stable long term series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.
MariaDB 10.11.14 is a Stable (GA) release.
For an overview of MariaDB 10.11 see the MariaDB 10.11 Changes & Improvements page.
Thanks, and enjoy MariaDB!
Notable Items
Storage Engines
InnoDB
Fatal InnoDB error: Unknown error Temp file write failure (MDEV-36017)
When innodb_buffer_pool_size is being shrunk while there are no data pages cached, InnoDB could hang or crash. (MDEV-37263)
After a successful shrinking of innodb_buffer_pool_size, there will be no message about it in the server error log.
After a failed shrinking of innodb_buffer_pool_size, the adaptive hash index will not be re-enabled if innodb_adaptive_hash_index was ON when SET GLOBAL innodb_buffer_pool_size=... started to execute. (MDEV-36868)
AUTO_INCREMENT leads to non-serializable on results (MDEV-36330)
The new parameter innodb_linux_aio controls which Linux implementation to use for innodb_use_native_aio=ON. (MDEV-36234)
innodb_linux_aio=auto is equivalent to innodb_linux_aio=io_uring when it is available, and falling back to innodb_linux_aio=aio when not.
Previously, only one implementation (libaio or io_uring) was available. Currently, if io_uring is disabled in the environment, we will fall back to the older libaio interface.
Data Definition - Alter Table
Adding (with ALTER TABLE) a UNIQUE constraint that is USING HASH to a table with foreign keys could've caused the table to become corrupted. (MDEV-36852)
DROP DEFAULT makes SHOW CREATE non-idempotent (MDEV-29001)
Data Definition - Create Table
CREATE OR REPLACE with self-referencing CHECK hangs forever, cannot be killed (MDEV-29155)
Data Manipulation - Insert
UNIQUE constraint that was USING HASH and UNIQUE constrant WITHOUT OVERLAPS could be violated under heavy load in READ COMMITTED transaction isolation mode. (MDEV-37199)
Partitioning
Server crashes in do_mark_index_columns instead of ER_DUP_ENTRY on partitioned table (MDEV-36817)
A replica would crash while replicating UPDATE and DELETE DML statements that target a table which previously had a partition that was converted to a separate table via ALTER TABLE .. CONVERT PARTITION .. TO TABLE. For example, if the command looked like ALTER TABLE t1 CONVERT PARTITION p1 TO TABLE t_new; the replica would crash when trying to update/deleterows in table t1 after running the command. (MDEV-36906)
Server
Segfault on INTERSECT ALL with UNION in Oracle mode (MDEV-25158)
In certain cases privileges on sequences were too restrictive, for example, SELECT on a table might've erroneously required INSERT privilege on a sequences (MDEV-36870)
mariadb-backup
This commit fixes a bug where Aria tables are used in (master->slave1->slave2) and a backup is taken on slave2. In this case it is possible that the replication position in the backup, stored in mysql.gtid_slave_pos, will be wrong. This will lead to replication errors if one is trying to use the backup as a new slave (MDEV-36143)
Maria-backup would crash during the 'maria_recovery' part. This could happen if server was doing repair or creating indexes while the backup was running. (MDEV-36860)
Optimizer
MariaDB server crash when a query includes a derived table containing unnamed column. (MDEV-24588)
Crash in add_keyuses_for_splitting() when joining with a derived table (MDEV-30711)
Don't generate index_merge plans, if a column is present in both Secondary Key and Primary Key indexes and either of the indexes include it with DESC order (as the scan itself is not a ROR scan). (MDEV-36410)
JSON
Starting from 10.11.12, Incorrect handling of UTF-8 characters (and other character sets requiring more than a single byte representation) in the minimum/maximum positions of a table during the execution of ANALYZE TABLE tbl PERSISTENT FOR ALL resulted in an endless loop consuming more memory and prevented the server from terminating. (MDEV-36765)
Galera
Galera updated to 26.4.23
galera_3nodes.inconsistency_shutdown test occasionally hangs (MDEV-36968)
Galera-26.4.23 corrects an incompatibility with OpenZFS >= 2.3.0 enabling the use of galera on this filesystem.
Replication
semi sync makes the master unresponsive when a replica is stopped (MDEV-36934)
parallel slave ALTER-SEQUNCE attempted to binlog out-of-order (MDEV-35570)
mysqldump --dump-slave always starts stopped slave (MDEV-7611)
Optimize Rows_log_event Reporting of Process Info (MDEV-36839)
Seconds_Behind_Master Spike at Log Rotation on Parallel Replication (MDEV-36840)
Stored routines
Crash when calling stored function in FOR loop argument (MDEV-26115)
Authentication and Privilege System
ALTER TABLE require ALTER privilege on sequence from DEFAULT value expression (MDEV-36280)
Locking
Deadlock does not rollback transaction fully (MDEV-36959)
Character Sets
Changing the server character set in
my.cnf
could causedebian-start
script to fail with "Illegal mix of collations" (MDEV-36815).
Packaging
mariadb systemd mult-instance service was changed to not attempt changes to the permissions on its pam helper server. This prevented unconstructive behaviour and errors in the systemd journal when starting the mariadb@.service. (MDEV-36738)
Sequences
Remove the error codes added to 10.11 by the MDEV-36032 patch (MDEV-36856)
XA
DML committed within XA transaction block after deadlock error and implicit rollback (MDEV-37141)
General
Add analyze_max_length option to not collect statistics for long char/varchars (MDEV-36536)
Packages for RHEL8 no longer depend on liburing. The RHEL8 kernel had insufficient kernel support so linking was an unneeded dependency. libaio was sufficient (MDBF-1042)
SLES 15 SP6 is a new package in this release. Because of incompatibilities of packages between SLES service pack versions there are now separate packages for 15sp6. An upgradeable repo file should include "sles/$releasever/$basearch" rather than the "sles15-amd64" or "sles/15/x86_64" path that may exist currently. (MDBF-1067, MDEV-36945)
Fedora 42 is a new release version and x86_64 and aarch64 packages are available (MDBF-1060)
Red Hat Enterprise Linux 10 packages are available for x86_64, aarch64, ppc64le, and s390x hardware platforms (MDBF-995)
Centos Stream 9 previously missed building a MariaDB-provider-lzo package and this has been corrected (MDBF-1038)
Changelog
For a complete list of changes made in MariaDB 10.11.14, with links to detailed information on each push, see the changelog.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?