Release date: 13 Nov 2023

This version of MariaDB Server can cause InnoDB to hang on systems with very intensive write loads when running out of I/O slots. This problem is fixed with MariaDB Server 10.11.7. See also

is the current stable long term series of MariaDB, February 2028. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

• followed by may corrupt data ()

• ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. ()

• Server aborts during alter operation when table doesn't have foreign index ()

Optimizer

• New setting, cset_narrowing, to enable the ()

• Crash when HAVING in a correlated subquery references columns in the outer query ()

• Server crashes at TABLE::add_tmp_key ()

Replication

• rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables ()

• Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication ()

• strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT ()

• updated to 26.4.16

• Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed. ()

• Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failed ()

Data Definition

• MariaDB crash on calling function ()

• ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations ()

• vcol circular references lead to stack overflow ()

Scripts and Clients

• (mysqlbinlog) option ()

• (mysqladmin) wrong error with ()

• shows warning on missing directory $pamtooldir/auth_pam_tool_dir ()

Tests

• main.events_stress or events.events_stress fails with view-protocol ()

• main.delete_use_source fails (hangs) with view-protocol ()

• main.sum_distinct-big and main.merge-big fail with timeout with view-protocol ()

mariadb-backup

• mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 ()

• mbstream breaks page compression on XFS ()

Character Sets, Data Types, Collations

• Prefix keys for CHAR work differently for MyISAM vs InnoDB ()

• Inconsistent results of DISTINCT with NOPAD ()

• Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT ()

Spider

• Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims ()

• Segfault when setting spider_delete_all_rows to 0 and delete all rows of a spider table, ASAN heap-use-after-free in spider_db_delete_all_rows ()

• ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler ()

General

• option breaks importing sql dumps ()

• Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 ()

• getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO ()

SQL Error Log Plugin

• Added the system variable, which permits warnings to be logged in addition to errors.

Docker Official Images

• Invert single and double quotes for sql command definitions in due to failure under - contribution by Dominik Häckel

• --no-defaults behaviour was corrected - reported by Dominik Häckel

• Added /docker-entrypoint-init.d for tar{,compression} from -

Warnings and Notes

• Added the system variable to manage .

Security

• Fixes for the following :

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

_{This page is licensed: CC BY-SA / Gnu FDL}

Release date: 22 May 2025

MariaDB 10.11 is a stable long term series of MariaDB, February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.

MariaDB 10.11.13 is a Stable (GA) release.

For an overview of MariaDB 10.11 see theWhat is MariaDB 10.11? page.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

• Huge performance drop after update ()

• InnoDB buffer pool reserves all assigned memory even with no/minimum load ()

• Possible data loss in the unlikely scenario when GET GLOBAL innodb_buffer_pool_size is shrinking the size of the buffer pool while the buffer pool contains ROW_FORMAT=COMPRESSED tables that use a non-default KEY_BLOCK_SIZE that is equal to innodb_page_size/1024 ()

General

• As per the , this will be the last release of for Ubuntu 20.04 LTS 'focal'

Changelog

For a complete list of changes and bugfixes made in MariaDB 10.11.13, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.11.13, see the .

_{This page is licensed: CC BY-SA / Gnu FDL}

Release date: 7 Jun 2023

is the current long term maintenance development series of MariaDB, February 2028. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

• Server crashes in st_join_table::choose_best_splitting ()

• Crash with condition pushable into derived and containing outer reference ()

• InnoDB does not free UNDO after the fix of ()

Optimizer

• Crash with condition pushable into derived and containing outer reference ( )

• Crash with for multi-table update of system table ()

Security

• Fixes for the following :

  • CVE--``#

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

_{This page is licensed: CC BY-SA / Gnu FDL}

Release date: 17 Nov 2022

is a current development series of MariaDB. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Notable Items

Authentication

• now accepts a comma-separated list of addresses to bind to ()

InnoDB

• Allow to be changed after database creation ()

Replication

• Formerly only a server option, is now a global system variable ()

Repositories

• Beginning with the next release (Q1 2023), our Yum, DNF, and Zypper repositories for Red Hat, Fedora, and SUSE will be migrated to being signed with a new . The key we are migrating to is the same one we already use for our Debian and Ubuntu Repositories.

  • The short Key ID is: 0xC74CD1D8

  • The long Key ID is: 0xF1656F24C74CD1D8

Docker Official Image

The following changes have been made to the docker.io/library/mariadb container image.

• The number of gpg packages has been removed, leaving enough to apt-get update, but dirmngr that would fetch keys has been removed. (inspired by )

• The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes ).

Security

• Fixes for the following :

  • CVE-`-```

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

Do not use non-stable (non-GA) releases in production!

_{This page is licensed: CC BY-SA / Gnu FDL}

Release date: 10 May 2023

is the current long term maintenance development series of MariaDB, February 2028. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

• Crash on in a table ()

• UNIQUE USING HASH accepts duplicate entries for tricky collations ()

• rec_get_offsets() is not optimal ()

Backup

• mariadb-backup doesn't utilise innodb-undo-log-directory (if specified as a relative path) during copy-back operation ()

• mariadb-backup issues error messages during InnoDB tablespaces export on partial backup preparing ()

• mariadb-backup does not copy Aria logs if aria_log_dir_path is used ()

Replication

• Fixed a deadlock on parallel slave involving full image Write event on the sequence engine ()

• Fixed an attempted out-of-order binlogging error on slave involving ALTER on the sequence engine ()

• Corrected non-versioned master to versioned slave replication on no-unique attribute table ()

Optimizer

• optimization is improved to re-fill the materialized table only if necessary. The fewer number of table refills is taken into account when choosing query plan, too ()

• New optimizer_switch option, , is added. It is off by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. ()

• Queries using SELECT DISTINCT some_expression(aggregate_function()) could produce wrong query result. ()

Docker Official Image

• Add replication setup to containers contributed by Md Sahil ()

• Added LTS tags for easier identification of LTS releases:

  • lts-jammy

General

• As per the , this will be the last release of for Fedora 36.

• In this release repositories for Fedora 38 and Ubuntu 23.04 Lunar have been added.

Security

• Fixes for the following :

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

_{This page is licensed: CC BY-SA / Gnu FDL}

Release date: 6 Aug 2025

is a stable long term series of MariaDB, February 2028. It is an evolution of with several entirely new features.

MariaDB 10.11.14 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• Fatal InnoDB error: Unknown error Temp file write failure ()

• When innodb_buffer_pool_size is being shrunk while there are no data pages cached, InnoDB could hang or crash. ()

• After a successful shrinking of innodb_buffer_pool_size, there will be no message about it in the server error log.

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. ()

• DROP DEFAULT makes SHOW CREATE non-idempotent ()

Data Definition - Create Table

• CREATE OR REPLACE with self-referencing CHECK hangs forever, cannot be killed ()

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. ()

Partitioning

• Server crashes in do_mark_index_columns instead of ER_DUP_ENTRY on partitioned table ()

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

Server

• Segfault on INTERSECT ALL with UNION in Oracle mode ()

• In certain cases privileges on sequences were too restrictive, for example, SELECT on a table might've erroneously required INSERT privilege on a sequences ()

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

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

Optimizer

• MariaDB server crash when a query includes a derived table containing unnamed column. ()

• Crash in add_keyuses_for_splitting() when joining with a derived table ()

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

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. ()

Galera

• updated to 26.4.23

• galera_3nodes.inconsistency_shutdown test occasionally hangs ()

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

• parallel slave ALTER-SEQUNCE attempted to binlog out-of-order ()

• mysqldump --dump-slave always starts stopped slave ()

Stored routines

• Crash when calling stored function in FOR loop argument ()

Authentication and Privilege System

• ALTER TABLE require ALTER privilege on sequence from DEFAULT value expression ()

Locking

• Deadlock does not rollback transaction fully ()

Character Sets

• Changing the server character set in my.cnf could cause debian-start script to fail with "Illegal mix of collations" ().

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. ()

Sequences

• Remove the error codes added to 10.11 by the MDEV-36032 patch ()

XA

• DML committed within XA transaction block after deadlock error and implicit rollback ()

General

• Add option to not collect statistics for long char/varchars ()

• Packages for RHEL8 no longer depend on liburing. The RHEL8 kernel had insufficient kernel support so linking was an unneeded dependency. libaio was sufficient ()

• 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. (, )

Changelog

For a complete list of changes made in MariaDB 10.11.14, with links to detailed information on each push, see the .

_{This page is licensed: CC BY-SA / Gnu FDL}

Download Release Notes Changelog Overview of 10.11

^{Alternate download from mariadb.org}

Release date: 4 Feb 2026

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.16 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• innodb_undo_log_truncate=ON leads to out-of-bounds write ()

• Bogus [ERROR] InnoDB: Compressed page checksum mismatch could be reported for ROW_FORMAT=COMPRESSED tables. ()

• When innodb_buffer_pool_size is not large enough to buffer all log records during crash recovery, InnoDB may fail to recover a page from the doublewrite buffer. ()

Aria

• Fixed crash in Aria when doing a sub transaction like reading an entry from the proc table. ()

RocksDB

• Server shutdown prevented by RocksDB setting rocksdb_pause_background_work ()

Spider

• Spider could crash when loop detection variables were artificially manipulated. ()

Authentication and Privilege System

• Only users with the TRIGGER privilege could see rows in the INFORMATION_SCHEMA.TRIGGERS table. The standard defines that only the columns ACTION_CONDITION, ACTION_STATEMENT and DEFINER columns are shown as NULL unless the user is the owner of the schema or has TRIGGER privilege, the other columns only require any edit privilege ()

• INSERT ... RETURNING exposes columns for which the user lacks SELECT privilege ()

• CHECK TABLE command can be executed by users with the table-level CREATE but not with global CREATE ()

Backup

• InnoDB: Failing assertion: tail.trx_no <= last_trx_no ()

Character Sets

• ASCII strings will be sent to client connections slightly faster. ()

• On IA-32 and AMD64 depending on the build options, the server could crash due to an unaligned access when sending data to a client connection. ()

Data Definition - Alter Table

• OPTIMIZE table not replicating ()

• Atomic DDL: Assertion !param->got_error failed upon unsuccessful multi-RENAME TABLE ()

• Cannot remove default value of NOT NULL column ()

Data Definition - Create Table

• On an error in CREATE TEMPORARY TABLE ... SELECT, InnoDB internally aborted a transaction, while the server thought the transaction still existed. This caused various inconsistencies in the binary log, disappearing savepoints, and more. The issue was fixed differently in different versions. In 10.11.16, 11.4.10, 11.8.6, and 12.2.2, the transaction is consistently and completely rolled back if CREATE TEMPORARY TABLE ... SELECT fails with an error. In 12.3.1, there is no rollback at all. ()

• If the server was killed during an operation that creates a .ibd file, such as TRUNCATE TABLE, it could fail to recover. ()

Data Manipulation - Delete

• ER_GET_ERRNO or server crash upon EXPLAIN DELETE with fulltext search subquery ()

Data Manipulation - Insert

• Empty value inserted if BEFORE trigger and ENUM NOT NULL field ()

• Server crashes after INSERT.. ON duplicate KEY UPDATE i = DEFAULT; ()

Data Manipulation - Subquery

• An unresolvable outer reference can cause a server to crash. ()

Data types

• Unexpected type changing after changing AVG to MAX ()

• Unexpected Data too long error on subselect as a multiplication argument ()

Events

• Event scheduler spams the error log ()

Full-text Search

• Server crash upon moving InnoDB table with fulltext index between databases ()

• Memory leak in innodb.import_hidden_fts_debug ()

Galera

• updated to 26.4.25

  • NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated

• wsrep_store_key_val_for_row() may invoke memcpy() on nullptr ()

GIS

• ST_OVERLAPS returns true despite dim(originalInput1) ≠ dim(originalInput2) ()

• Malformed spatial data could've caused a crash inside InnoDB ()

JSON

• Unexpected success and result set upon erroneous JSON_VALUE call ()

Optimizer

• EXPLAIN FOR CONNECTION (subquery) causes crash ()

• Server crashes in Item_field::used_tables upon queries from a view ()

• Incorrect results for INTERSECT ALL in ORACLE mode ()

Optimizer - CTE

• Segfault when preparing unreferenced select in recursive CTE ()

Optimizer - Window functions

• ref_ptrs exhaust on multiple ORDER by func from winfunc ()

OTHER

• Prohibited semijoin with rownum, correctly process in HAVING rownum. ()

Packaging

• ed25519 client authentication plugin would fail to load for anything but mariadb client utility. This has been fixed now. ()

• Package mariadb-common conflicts with mysql-common ()

• Incorrect BuildRequires entry in RHEL10 srpm ()

Parser

• Lots of joins can crash the server ()

Partitioning

• ALTER puts row into different partition for system_time interval partitioning ()

• INTERVAL partitioning by system time does not work close to the end of timestamp range ()

• On partitioned tables algorithm is not supported throw "no such file or directory" error ()

Performance Schema

• sys.ps_setup_save does not restore SQL_LOG_BIN after error, causes replication discrepancy ()

Plugin - Audit Log

• Audit log plugin will now log events for MariaDB Cluster (Galera) replication applier operations with a generic user name: <wsrep_applier>. Before this change the user name in audit logs has been empty ()

Plugin - Hashicorp Key Management

• Hashicorp plugin lets keys timeout and doesn't use cached keys on vault errors ()

Plugin - userstat

• Userstat Plugin CPU_TIME much higher than BUSY_TIME ()

Protocol

• Auth Switch with Long Password Corrupts Database Name ()

Replication

• An issue is fixed which could result in server hangs when a replica internally scans its mysql.gtid_slave_pos table contents. ()

• Race of rolling back and committing transaction to binlog ()

• For large transactions (i.e. those whose data exceeds the binlog_cache_size limit and spills into tmp files), provides a general performance improvement and fixes a bug that would lead to binlog corruption where the large transaction would have its GTID written into the binary log, without any additional transaction data, if the server's --tmp-dir was full. ()

Scripts & Clients

• There was a short gap when mariadb-secure-installation temporary files were potentially openable/readable by an unprivileged user. These files may contain database root password. ()

• Missing Null terminator in the definition of mysqldump's --system typelib ()

Sequences

• Server crashes after select from view ()

Server

• SIGSEGV in store_server_fields on CREATE SERVER ()

• Inconsistent results for make_set of cast ()

Stored routines

• SHOW FUNCTION CODE package_func crashes on the second execution ()

Temporal Types

• Inconsistent behaviors when casting into time ()

Views

• Crash when reading a corrupted view frm file ()

Changelog

For a complete list of changes made in MariaDB 10.11.16, with links to detailed information on each push, see the .

_{This page is licensed: CC BY-SA / Gnu FDL}

Release date: 1 Nov 2024

is a stable long term series of MariaDB, February 2028. It is an evolution of with several entirely new features.

is a release.

For an overview of see the page.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• Fix attempt to read outside the bounds of the file: ./ibdata1 ()

• Fix MariaDB crash with SIGILL because the OS does not support AVX512 ()

• Fix deadlock caused by lock_rec_unlock_unmodified() ()

• Fix server crash when calling after is enabled ()

• SELECT MIN on Spider table no longer returns more rows than expected ()

• Fix Spider group by handler wrong result on order by aggregate ()

• Fix Storage Engine S3 that caused 500 error when using Huawai Cloud S3 and possibly other S3 providers ()

  • A new option has been added. s3-provider=Huawai needs to be set for Huawai Cloud S3

  • New option , if true, SSL certificate verification for the S3 endpoint is disabled

Optimizer

• Fix crash caused by query containing constant having clause ()

• Fix assertion with optimizer_join_limit_pref_ratio and 1-table select ()

Data Definition - Alter Table

• Fix InnoDB crash under Windows Subsystem for Linux on ALTER TABLE or OPTIMIZE TABLE ()

• Modification of the column now correctly checks foreign key constraint ()

• Fix incorrect NULL value handling for instantly dropped BLOB columns ()

• Galera updated to 26.4.20

• Fix server crash when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table ()

• TOI (ALTER) no longer hangs on a parent table if SR transaction is in progress on a child table ()

Backup

• Recovery now correctly notes some log corruption ()

• InnoDB now correctly merges the change buffer to ROW_FORMAT=COMPRESSED tables ()

• Can now selectively restore sequences using innodb tables from backup ()

JSON

• now properly unquotes strings ()

• default values now allows non-string literals ()

General

• As per the , this will be the last release of for SLES 12, and Windows 11 22H2

• no longer hangs on startup when --init-file target does not exist ()

• LOAD DATA INFILE with geometry data no longer fails ()

Security

• Fixes for the following :

  • CVE--``#

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

_{This page is licensed: CC BY-SA / Gnu FDL}