Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Release notes for MariaDB Community Server 10.11 series releases
MariaDB 10.11.16 is a Stable (GA) release of MariaDB Community Server 10.11, released on 2026-02-04
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.
For an overview of MariaDB 10.11 see the page.
Thanks, and enjoy MariaDB!
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. ()
Fixed crash in Aria when doing a sub transaction like reading an entry from the proc table. ()
Server shutdown prevented by RocksDB setting rocksdb_pause_background_work ()
Spider could crash when loop detection variables were artificially manipulated. ()
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 ()
InnoDB: Failing assertion: tail.trx_no <= last_trx_no ()
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. ()
OPTIMIZE table not replicating ()
Atomic DDL: Assertion !param->got_error failed upon unsuccessful multi-RENAME TABLE ()
Cannot remove default value of NOT NULL column ()
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. ()
ER_GET_ERRNO or server crash upon EXPLAIN DELETE with fulltext search subquery ()
Empty value inserted if BEFORE trigger and ENUM NOT NULL field ()
Server crashes after INSERT.. ON duplicate KEY UPDATE i = DEFAULT; ()
An unresolvable outer reference can cause a server to crash. ()
Unexpected type changing after changing AVG to MAX ()
Unexpected Data too long error on subselect as a multiplication argument ()
Event scheduler spams the error log ()
Server crash upon moving InnoDB table with fulltext index between databases ()
Memory leak in innodb.import_hidden_fts_debug ()
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 ()
ST_OVERLAPS returns true despite dim(originalInput1) ≠dim(originalInput2) ()
Malformed spatial data could've caused a crash inside InnoDB ()
Unexpected success and result set upon erroneous JSON_VALUE call ()
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 ()
Segfault when preparing unreferenced select in recursive CTE ()
ref_ptrs exhaust on multiple ORDER by func from winfunc ()
Prohibited semijoin with rownum, correctly process in HAVING rownum. ()
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 ()
Lots of joins can crash the server ()
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 ()
sys.ps_setup_save does not restore SQL_LOG_BIN after error, causes replication discrepancy ()
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 ()
Hashicorp plugin lets keys timeout and doesn't use cached keys on vault errors ()
Userstat Plugin CPU_TIME much higher than BUSY_TIME ()
Auth Switch with Long Password Corrupts Database Name ()
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. ()
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 ()
Server crashes after select from view ()
SIGSEGV in store_server_fields on CREATE SERVER ()
Inconsistent results for make_set of cast ()
SHOW FUNCTION CODE package_func crashes on the second execution ()
Inconsistent behaviors when casting into time ()
Crash when reading a corrupted view frm file ()
For a complete list of changes made in MariaDB 10.11.16, with links to detailed information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
If the server was killed during an operation that creates a .ibd file, such as TRUNCATE TABLE, it could fail to recover. (MDEV-38026)
MariaBackup fails during rollback of inplace FTS alter table (MDEV-38041)
In multi-threaded write-heavy workloads, buf_pool.flush_list_mutex could become a point of contention. (MDEV-38069)
Secondary indexes could be corrupted for InnoDB tables that contain indexed virtual columns. (MDEV-38140)
Server hang during concurrent set innodb_encryption_threads (MDEV-38271)
Under some circumstances, some read operations could unnecessarily wait for an InnoDB log write. (MDEV-38589)
REFERENCES permission on particular schema is sometimes ignored (MDEV-38209)
Sequence Fails with Galera Version 26.4.16 and later (MariaDB Server 10.6.17) in the Presence of Enabled Streaming Replication (MDEV-34124)
Applier thread performing IST is left with REPEATABLE_READ isolation level (MDEV-37229)
Galera cluster crashes when granting permission to non existing user after setting max_error_count and wsrep_ignore_apply_errors to zero (MDEV-37991)
Galera nodes should operate when transaction-read-only=ON (MDEV-38073)
Restore of dumped databases fails since ver 11.8.4 with ERROR 1100 if constraints are in place (MDEV-38216)
Long blob prefix keys could cause a crash in galera. (MDEV-38374)
We are trying to push aggregate into WHERE (MDEV-38487)
Presence of Spider disables "external" XA commit (MDEV-37972)
MDEV-37686 fixes are reverted which should restore parallel slave functionality back to normal (MDEV-38212)
An issue is fixed where GRANT EXECUTE ON PROCEDURE would fail on the master, but would still be replicated and executed successfully on the slave. (MDEV-38506)
Release date: 22 May 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.13 is a Stable (GA) release.
For an overview of MariaDB 10.11 see theWhat is MariaDB 10.11? page.
Thanks, and enjoy MariaDB!
Huge performance drop after update (MDEV-36759)
InnoDB buffer pool reserves all assigned memory even with no/minimum load (MDEV-36780)
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 (MDEV-36781)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.6 for Ubuntu 20.04 LTS 'focal'
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.
For a full list of contributors to MariaDB 10.11.13, see the MariaDB Foundation release announcement.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.11.4 is a Stable (GA) release of MariaDB Community Server 10.11, released on 2023-06-07
The most recent release of MariaDB 10.11 is:
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!
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 ()
Crash with condition pushable into derived and containing outer reference ( )
Crash with for multi-table update of system table ()
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
is not updated correctly ()
InnoDB monitor trx_rseg_history_len was accidentally disabled by default ()
Revert " : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"
MariaDB 10.11.14 is a Stable (GA) release of MariaDB Community Server 10.11, released on 2025-08-06
The most recent release of MariaDB 10.11 is:
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.
For an overview of MariaDB 10.11 see the page.
Thanks, and enjoy MariaDB!
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.
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 ()
CREATE OR REPLACE with self-referencing CHECK hangs forever, cannot be killed ()
UNIQUE constraint that was USING HASH and UNIQUE constrant WITHOUT OVERLAPS could be violated under heavy load in READ COMMITTED transaction isolation mode. ()
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. ()
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 ()
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. ()
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). ()
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. ()
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.
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 ()
Crash when calling stored function in FOR loop argument ()
ALTER TABLE require ALTER privilege on sequence from DEFAULT value expression ()
Deadlock does not rollback transaction fully ()
Changing the server character set in my.cnf could cause debian-start script to fail with "Illegal mix of collations" ().
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. ()
Remove the error codes added to 10.11 by the MDEV-36032 patch ()
DML committed within XA transaction block after deadlock error and implicit rollback ()
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. (, )
For a complete list of changes made in MariaDB 10.11.14, with links to detailed information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.11.10 is a Stable (GA) release of MariaDB Community Server 10.11, released on 2024-11-01
The most recent release of MariaDB 10.11 is:
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!
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
Fix crash caused by query containing constant having clause ()
Fix assertion with optimizer_join_limit_pref_ratio and 1-table select ()
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 ()
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 ()
now properly unquotes strings ()
default values now allows non-string literals ()
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 ()
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
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.
Seconds_Behind_Master Spike at Log Rotation on Parallel Replication (MDEV-36840)
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)
Fix possible adaptive hash index corruption with ALTER TABLE...IMPORT TABLESPACE and FULLTEXT SEARCH (MDEV-35059)
XA prepare now correctly releases unmodified records in non-blocking mode (MDEV-34466)
Fix contention between secondary index UPDATE and purge due to large innodb_purge_batch_size (MDEV-34515)
New default of 127 for (previously 1000).
Fix redundant page lookups that hurt performance (MDEV-34791)
Implement on 64-bit systems for improving ib_logfile0 reads (MDEV-34062)
Fix case where with wsrep_mode=REPLICATE_ARIA, only part of the mixed-engine transactions was replicated (MDEV-30653)
Fix galera_ssl_reload failure with warning message (MDEV-32778)
When InnoDB gets an assertion failure, WSREP layer is now handled gracefully (MDEV-32363)
Fix assertion `!is_cond()' failed in Item_bool_func::val_int / do_select (MDEV-35135)
Trigger now works correctly with bulk update (MDEV-34718)
Fix assertion failure in find_producing_item upon a query from a view (MDEV-35276)
Add new setting, to the mariadb client for use in --quick mode (MDEV-34704)
MariaDB 10.11.1 is a Release Candidate (RC) release of MariaDB Community Server 10.11, released on 2022-11-17
The most recent release of MariaDB 10.11 is:
Release date: 17 Nov 2022
Do not use non-stable (non-GA) releases in production!
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!
now accepts a comma-separated list of addresses to bind to ()
Allow to be changed after database creation ()
Formerly only a server option, is now a global system variable ()
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
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 ).
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Do not use non-stable (non-GA) releases in production!
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
The full fingerprint of the key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8
The key can be imported now in preparation for this change using the following command:
MariaDB config: skip-host-cache and skip-name-resolve moved to /etc/mysql/mariadb.conf.d/05-skipcache.cnf
sudo rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEYRelease date: 8 Aug 2024
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.9 is a Stable (GA) release.
For an overview of MariaDB 10.11 see the What is MariaDB 10.11? page.
Thanks, and enjoy MariaDB!
now builds indexes more efficiently (MDEV-33087)
Unsetting the system variable restores the old behavior.
Fix unexpected storage read IO for the redo log, reintroduce (MDEV-33894)
Correctly terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing ()
Alter operation on redundant table no longer aborts the server ()
Fix MariaDB crash with SIGILL because the OS does not support AVX512 ()
Fix InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound ()
wait_for_read in buf_page_get_low no longer hurts performance ()
Fix InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211 ()
Fix index corruption when doing a REPAIR TABLE that has a size of over 4G (MDEV-34522)
UBSAN: runtime error: applying non-zero offset in spider_free_mem and SIGSEGV in spider_free_mem on SELECT (MDEV-31475)
SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' (MDEV-32487)
SIGSEGV in spider_db_conn::fin_loop_check, and ASAN: heap-use-after-free in spider_db_mbase::fin_loop_check on SHOW TABLE STATUS ()
SIGSEGV in ha_spider::lock_tables on BEGIN after table lock ()
SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT and SELECT ()
Spider: Crashes, asserts, hangs, memory corruptions and ASAN heap-use-after-free's ()
Spider: @@insert_id 128 to TINYINT: Assertion ``!is_set() || (m_status == DA_OK_BULK && is_bulk_op())'` failed. ()
ASAN errors in spider_db_free_result after partition DDL ()
Server crashes when calling spider UDF after aria_encrypt_tables is enabled ()
MariaDB Server crashes with ill-formed partitions (MDEV-32155)
SIGSEGV in parse_engine_part_options on INSERT, SELECT or ALTER (MDEV-34421)
Assertion ``auto_increment_value'failed inha_partition::info` on INSERT into MEMORY table (MDEV-24610)
On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb from strings/ctype-mb.c and other locations (MDEV-34226)
On startup: UBSAN: runtime error: applying zero offset to null pointer in skip_trailing_space and my_hash_sort_utf8mb3_general1400_nopad_as_ci (MDEV-34187)
SHOW CREATE DATABASE statement crashes the server when db name contains some unicode characters, ASAN stack-buffer-overflow ()
Wrong result set with utf8mb4_danish_ci and BNLH join ()
On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info in sql/sql_select.cc (MDEV-34227)
Crash after killing query while it is processed by test_quick_select (MDEV-30651)
Extend condition normalization to include 'NOT a' ()
Constant subquery causing a crash in pushdown optimization ()
Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table ()
2nd execution name resolution problem with pushdown into unions ()
Assertion ``(key_part->key_part_flag & 4) == 0'` failed key_hashnr ()
Crash caused by query containing constant having clause ()
Using NAME_CONST() (or executing query from the stored procedure and referring to a local variable) changes the plan and may make execution slower ()
ORDER BY DESC causes ROWID Filter optimization performance degradation ()
Auto-generated from table no longer breaks replication (MDEV-25607)
Fix replication failure when are used where the replica has set and the client has touched a different database when running DML such as inserts. (MDEV-33921)
Fix replication error when is used in conjunction with a password longer than 41 ascii characters (MDEV-23857)
The option is utilized to avoid a possible error state in ()
Hide password passed on commandline from xtrabackup_info (MDEV-34434)
Galera updated to 26.4.19
NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
galera_gtid_2_cluster: Assertion ``thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'` (MDEV-32633)
table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0 ()
Deadlock found when trying to get lock during applying ()
Change error code for Galera unkillable threads ()
10.11.8 cluster becomes inconsistent when using composite primary key and partitioning ()
wsrep_sst_mariadb-backup use /tmp dir during SST rather then user defined tmpdir ()
system variable added, and value added to the at startup (MDEV-34494)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.11 for Debian 10 "Buster", RHEL/CentOS 7, Ubuntu 23.10 "Mantic", and Fedora 38
Repositories for Ubuntu 24.04 "Noble" have been added
no longer unnecessarily traverses tablespaces list (MDEV-34670)
Fix unknown variable defaults-group-suffix= with ()
no longer hangs on macOS ()
Fix transaction termination with ER_LOCK_TABLE_FULL when lock memory is growing ()
Disable new connections in case of fatal signal ()
Control over memory allocated for SP/PS ()
now work correctly with bulk insert ()
Fix assertion ``table->field[0]->ptr >= table->record[0] && table->field[0]->ptr <= table->record[0] + table->s->reclength'failed invoid handler::assert_icp_limitations(uchar*)` ()
- now compatible with ()
Fixes for the following :
CVE--``#
For a complete list of changes made in MariaDB 10.11.9, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.11.9, see the MariaDB Foundation release announcement.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.
This page is licensed: CC BY-SA / Gnu FDL
Release date: 16 Feb 2023
MariaDB 10.11 is a long term maintenance release series of MariaDB, maintained until February 2028. It is an evolution of MariaDB 10.10 with several entirely new features.
MariaDB 10.11.2 is a Stable (GA) release.
For an overview of MariaDB 10.11 see the What is MariaDB 10.11? page.
Thanks, and enjoy MariaDB!
As mentioned in the 10.11.1 release notes, our Yum/DNF/Zypper repositories for Red Hat Enterprise Linux, CentOS, Fedora, openSUSE, and SUSE are changing with this release to being signed with a new GPG key with SHA2 digest algorithms instead of SHA1. See this blog post and the page for more details.
corruption with (MDEV-25004)
recovery and backup fixes (MDEV-29999, MDEV-30179, MDEV-30438)
Upgrade after a crash is not supported (MDEV-24412)
Remove load throttling ()
InnoDB shutdown hangs when the change buffer is corrupted ()
innodb_fast_shutdown=0 fails to report change buffer merge progress ()
mariadb-backup --backup --incremental --throttle=... hangs ()
Crash after recovery, with InnoDB: Tried to read ()
Trying to write ... bytes at ... outside the bounds ()
TRUNCATE breaks FOREIGN KEY locking (, )
INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces ()
Fixed hangs and error handling in B-tree operations (, )
InnoDB bulk insert fixes (, )
InnoDB fails to start on innodb_undo_tablespaces mismatch ()
mariadb-backup.skip_innodb crashes when innodb_undo_tablespaces > 0 ()
Fixes for cluster wide write conflict resolving (MDEV-29684)
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE (MDEV-30323)
is now shown now more precisely at the slave applier start, including in the delayed mode (MDEV-29639)
is made to show the type of compressed columns (MDEV-25277)
Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA ()
Infinite sequence of recursive calls when processing embedded CTE (MDEV-30248)
Crash with a query containing nested WINDOW clauses (MDEV-30052)
Major performance regression with 10.6.11 (MDEV-29988)
Json Range only affects first row of the result set ()
As per the , this will be the last release of for Fedora 35.
In this release repositories for Fedora 37 and Ubuntu 22.10 Kinetic have been added.
Fixes for the following :
CVE-`-```
For a complete list of changes made in MariaDB 10.11.1, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.11.2, see the MariaDB Foundation release announcement.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.
This page is licensed: CC BY-SA / Gnu FDL
Release date: 26 Sep 2022
Do not use non-stable (non-GA) releases in production!
MariaDB 10.11 is a current development series of MariaDB. It is an evolution of MariaDB 10.10 with several entirely new features.
Unlike recent new releases, MariaDB 10.11.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 10.11.
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:10.11-preview.
For an overview of MariaDB 10.11 see the What is MariaDB 10.11? page.
Thanks, and enjoy MariaDB!
Windows - passwordless login for mariadb root user, for OS admin users, using the (MDEV-26715)
Separate and privileges (MDEV-29596)
Semi-join optimization for single-table update/delete statements (MDEV-7487)
Allow pushdown of queries involving UNIONs in outer select to foreign engines (MDEV-25080)
Make show time spent in the query optimizer (MDEV-28926)
Performance Issues reading the (MDEV-29104)
Full table scan in the and tables (MDEV-20609)
setting, , to allow history modification (MDEV-16546)
: dump and restore historical data (MDEV-16029)
and are now dynamic, and their values can be changed without restarting the server (MDEV-11026)
Rename variables (MDEV-7567)
(min_examined_row_limit)
(slow_query_log)
(slow_query_log_file) This will be renamed to in the next release.
(long_query_time)
is now a system variable, no longer just an option ()
Do not use alpha releases on production systems! For a complete list of changes made in MariaDB 10.11.0, with links to detailed information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.
This page is licensed: CC BY-SA / Gnu FDL
Release date: 4 Feb 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.11 is a Stable (GA) release.
For an overview of MariaDB 10.11 see theWhat is MariaDB 10.11? page.
Thanks, and enjoy MariaDB!
Fix possible InnoDB hang while running out of buffer pool (MDEV-35409)
Fix assertion failure on cascading foreign key update of table with vcol index in parent (MDEV-29182)
Fix potential issue in secondary Index with ROW_FORMAT=COMPRESSED and Change buffering enabled (MDEV-35679)
Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column ()
New parameter --skip-freed-pages for . Use this parameter to not get freed undo logs reported as existing undo log pages. ()
Cloning of table statistics while saving the InnoDB table stats is now avoided ()
InnoDB deadlock output query length increased to improve visibility of deadlocked statements. ()
now works with INDEX DESC ()
Fix occasional failure of recovery of a multi-batch operation with InnoDB on startup ()
Fix possible crash on DELETE from a HEAP table (MDEV-22695)
Fix possible Spider thread hang in 'Update' state on 2nd INSERT (MDEV-35064)
Fix possible crash on bootup in spider_sys_open_table «ext-issue»«MDEV-32822», «ext-issue»«MDEV-34302» (MDEV-34925)
Fix incorrect formatting of timestamp during parsing of a binary log, causing point in time recovery discrepancies (MDEV-31761)
can now correctly process more than one logfile when --stop-datetime is specified (MDEV-35528)
Setting pseudo_thread_id to a value exceeding 4 bytes previously resulted in truncation when written to the binary log (MDEV-35646)
MariaDB now supports MySQL 8.0 binlog events, including PARTIAL_UPDATE_ROWS_EVENT, TRANSACTION_PAYLOAD_EVENT, and HEARTBEAT_LOG_EVENT_V2. ()
Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY (MDEV-29935)
Fix failing assertion causing disruption and replication failure (MDEV-24035)
Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition (MDEV-35910)
NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures ()
Fix possibly wrong result using a degenerated subquery (SELECT ) with window function ()
History is now stored on the same partitions on different Galera nodes when system versioning is enabled (MDEV-35096)
Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE (MDEV-25654)
EXCHANGE PARTITION now works for tables with unique blobs (MDEV-35612)
algorithm = instant can now correctly be used if a table has partitions and one tries to change a column with an index which is not the partitions key. This previously gave error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY". ()
Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys (MDEV-30111)
Fix client crash the command after client sets character set to utf32 (MDEV-34090)
Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer (MDEV-35549)
Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump ()
Galera updated to 26.4.21
NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
FIx streaming replication transaction crash with innodb_snapshot_isolation (MDEV-35281)
Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled ()
Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory ()
Fix cluster node hang during shutdown if threadpool is used ()
MariaDB Cluster and ALTER INPLACE running in Total Order Isolation (wsrep_OSU_method=TOI) now correctly abort a DML INSERT operation in InnoDB ()
Fix possible crash in wsrep_check_sequence ()
Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction ()
Rows in table mysql.gtid_slave_pos are now correctly deleted on Galera nodes when wsrep_gtid_mode = 1 is used, which previously lead to wrong information about replica delays ()
Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node. ()
Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently. ()
Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+ ()
Fix possible crash in wsrep_sst_mariadb-backup script when upgrading node in cluster from 10.11.9 to 10.11.10. ()
wsrep_sst_mariadb-backup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours ()
For an authentication with the the password of the CREATE USER statement is now masked in the audit log (MDEV-35507)
MariaDB Audit now detects all DCLs forms for masking a password (MDEV-35522)
Fix possible crash where server could not construct a geomery object from the input (MDEV-33987)
Fix trigger created with "" which is adding rows to another table using "FOR EACH ROW insert into table2(id, name) values (NEW.id, NEW.name);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table (MDEV-34958)
After changing the table definition for the system table 'mysql.servers', a following execution of CREATE SERVER would previously lead to a server crash.
NOTE: System tables should never be modified by a user anyhow ()
Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED ()
Fix possible crash during index traversal using tree_search_next. ()
FIx assertion failure where CURRENT_USER was not correctly copied during condition pushdown ()
START TRANSACTION, when triggering an implicit commit as a COMMIT or ROLLBACK has not been executed before, now resets optional characteristics added to the last START TRANSACTION command ()
sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers ()
The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error ()
Fix doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages ()
Can now correctly add a foreign key on a table with a long UNIQUE multi-column index that contains a foreign key as a prefix ()
During an online table rebuild of an InnoDB statistics table, opt_search_plan_for_table() no longer sometimes degrades to full table scan ()
Fix debian-start script failure when using non-standard socket path ()
Fix possible hang or crash where zero offset applied to null pointer ()
Fixed issue where ST_PointFromWKB ignored SRID parameter and returned 0 ()
Fix possible hang during CREATE TABLE…SELECT error handling, especially with innodb_snapshot_isolation enabled ()
Fix incorrect locking order of LOCK_log/LOCK_commit_ordered and LOCK_global_system_variables ()
Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy ()
Fix possible memory leak on SHUTDOWN ()
Fix possible memory leak while shutting down server after installing the auth_gssapi plugin ()
Fix possible server crash when using INSERT DELAYED on tables with virtual columns. ()
Fix possible Spider crash or hang when the first byte of a connection key is changed ()
A BEFORE INSERT Trigger previously returned with error ""Field 'xxx' doesn't have a default value", if a NULL value is added for a column defined NOT NULL without explicit value and no DEFAULT specified ()
Calling a stored routine that executes a join on three or more tables and referencing not-existent column name in the USING clause could previously result in a crash on its second invocation. ()
Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy ()
Comparison of UUID v1 and V6 could return incorrect results ()
Fixes for the following :
For a complete list of changes and bugfixes made in MariaDB 10.11.11, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 10.11.11, see the MariaDB Foundation release announcement.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.
This page is licensed: CC BY-SA / Gnu FDL
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.12 is a Stable (GA) release.
For an overview of MariaDB 10.11 see the What is MariaDB 10.11? page.
Thanks, and enjoy MariaDB!
Incorrect undo logging for indexes on virtual columns whose index ID does not fit in 32 bits (MDEV-36613)
Race conditions between ALTER TABLE or OPTIMIZE TABLE and the purge of transaction history were fixed. (MDEV-36122)
ASAN errors in dict_sys_t::load_table / get_foreign_key_info after failing to load a table (MDEV-33167)
CREATE INDEX fails to heal a FOREIGN KEY constraint ()
Doublewrite recovery of innodb_checksum_algorithm=full_crc32 page_compressed pages does not work ()
innodb_snapshot_isolation=1 gives error for not committed row changes ()
The deprecated parameter innodb_purge_rseg_truncate_frequency is not being recognized ()
dict_stats_fetch_from_ps() unnecessarily holds exclusive dict_sys.latch ()
Stall and crash when page cleaner fails to generate free pages during Async flush ()
Performance regression in INSERT…SELECT due to unnecessarily making InnoDB log durable. ()
decreasing innodb_buffer_pool_size at runtime does not release memory ()
LSN allocation is a bottleneck ()
(and remove buffer pool chunks) ()
FLUSH TABLES will no longer cause InnoDB persistent statistics to be reloaded. RENAME TABLE will. This change of logic improves the performance in general, and avoids a case where statistics for relatively rarely modified tables are never updated. ()
The Linux memory pressure interface, which could previously not be disabled and could cause performance anomalies, was rewritten and is disabled by default. ()
Race condition between log_t::resize_start() and log_t::resize_abort() ()
Memory leak after failed CREATE TABLE…SELECT; crash on CREATE TABLE…SELECT that reads from multiple tables ()
Server crashes when resizing default innodb buffer pool after setting innodb-buffer-pool-chunk-size to 1M ()
The untested ha_spider::index_first_internal constructs broken queries (MDEV-36324)
Unexpected error 1264 'Out of Range Value for Column' when inserting into ... select ... from a spider table (MDEV-35874)
Tests calling the udf spider_copy_tables fail with --view-protocol (MDEV-36335)
group by handler missing constant fields when selecting from a view (MDEV-36307)
A multi-table UPDATE ... ORDER BY ... LIMIT statement could update the wrong rows when the ORDER BY clause was resolved by using temporary and filesort. (MDEV-35955)
A query using a subquery in form:
could cause a crash in the optimizer. The essential part is that ON expression has only two kinds of references: 1.to inner side of the outer join and 2. to outside the subquery. (MDEV-32084)
find_order_in_list mismatch when order item needs fixing() (MDEV-36607)
If the join_condition is specified via USING (column_list), the query plan depends on the sequence of tables in the query (MDEV-36592)
Large N-way OR causes a lot of index_merge variants to be created and discarded (MDEV-34620)
Wrong result in loose index scan ()
Incorrect error handling on DDL with FULLTEXT INDEX (MDEV-36061)
ALTER TABLE…SEQUENCE does not work correctly with InnoDB (MDEV-36038)
The server could crash when an UPDATE is about to commit concurrently with a CREATE INDEX that includes VIRTUAL columns (MDEV-36281)
ALTER TABLE…DROP COLUMN after a failed ALTER TABLE…DROP COLUMN could lead to a server crash ()
mariadb-backup --backup crash during innodb_undo_log_truncate=ON, innodb_encrypt_log=ON (MDEV-36152)
MariaDB Backup returns with an error like "Error on file ./test/t1#P#p513.MYD open during test.t1 table copy for partitioned MyISAM tables when running out of file handles (MDEV-36437)
make mariadb-backup to force an innodb checkpoint (MDEV-30000)
Server aborts while deleting the record in spatial index (MDEV-35420)
Upgrades fail on Windows (MDEV-36128)
Field pointer may be uninitialized in fill_record (MDEV-36181)
Wrong results from tables with a single record and an aggregate (MDEV-35238)
Galera updated to 26.4.22
With wsrep_ignore_apply_errors = 0, the node crashes due to assertion thd->is_error() failed in Sql_cmd_dml::prepare(), shown in the logs (MDEV-35946)
In some cases, if there are MDL locks (for example, when LOCK TABLE is executed), a node could get stuck in the system thread due to incorrect handling of metadata locks (MDL) in server code when a transaction was BF aborted. (MDEV-35941)
Regression after the fix for - sometimes the server crashes with an assertion in wsrep::transaction::before_rollback(), for example when using OPTIMIZE TABLE on an ARIA table with wsrep_osu_method=RSU. ()
In Galera, creating sequence with a small cache leads to signal 6 error: [ERROR] WSREP: FSM: no such a transition REPLICATING -> COMMITTED. ()
Assertion `commit_trx' failed in innobase_commit() (ha_innodb.cc). An INSERT with sql_log_bin=0 is still replicated in Galera (per ), despite binary logging being disabled. This results in a partial binlog bypass, requiring a two-phase commit (2PC). During 2PC, the INSERT is first prepared (entering the PREPARED state in InnoDB), and on commit, the new assertion from fails, causing a crash with "Assertion 'commit_trx' failed" in logs. ()
When a sequence is used and inserts run in parallel on multiple Galera nodes, a transaction may be aborted after passing certification. If it then attempts to roll back, the binlog statement cache—which includes reserved sequence values—may be written prematurely. This causes a crash with the diagnostic "WSREP: FSM: no such a transition REPLICATING -> COMMITTED" in the logs, as the transaction is supposed to replay and only write to the binlog during the final commit. ()
After a corrupted table on one node triggers the cluster to vote to evict a node that failed a transaction, the current master can't commit any more and hangs. To avoid this crash in the future, the user should also update the galera library to version 26.4.21+. ()
Creating partitioned tables is disallowed when wsrep_osu_method=TOI and wsrep_strict_ddl=ON, preventing alteration or deletion of partitioned tables. ()
Attempting to create a CONNECT engine table results in "non-InnoDB sequences in Galera cluster" error message in logs due to an incorrect engine check. ()
Build fails with cmake 4.0.0 due to wsrep ()
A Galera node may hang due to improper mutex handling: a thread held lock_sys.wait_mutex while triggering a streaming replication rollback, which also tried to acquire THD::LOCK_thd_kill, leading to incorrect mutex usage. In debug versions, this leads to diagnostics like "safe_mutex: Found wrong usage of mutex 'wait_mutex' and 'LOCK_thd_data'", but in both debug and release versions, there is some probability that the node may hang. ()
A Galera node might hang if foreign key (FK) and unique key (UK) checks are disabled on multiple appliers executing INSERTs into the same table, because InnoDB might treat these operations as bulk inserts, leading one applier to acquire a table-level lock. If another applier with a lower sequence number then waits for this lock, a deadlock can occur within Galera. Specifically, the lock holder waits for the earlier applier to commit, while the earlier applier is blocked by the lock. ()
corruption when query cache cannot allocate block (MDEV-34075)
Stack looping and SIGSEGV in Item_args::walk_args on UPDATE (MDEV-31647)
Server crash in find_field_in_tables, Assertion `name' failed in find_field_in_table_ref (MDEV-25012)
Server crash when inserting from derived table containing insert target table (MDEV-32086)
MariaDB effectively running as root CAP_DAC_OVERRIDE (MDEV-36229)
Build fails with cmake 4.0 ()
mysqldump does not preserve case of table names in generated sql ()
Incorrect result for BETWEEN over unique blob prefix ()
Incorrect query result for comparisons of binary_column NOT LIKE binary_column ()
Semi-sync Replica Can't Kill Dump Thread When Using SSL (MDEV-36663)
Mysqlbinlog --stop-position does not warn if EOF not reached with --read-from-remote-server (MDEV-35694)
Long server_audit_file_path causes buffer overflow (MDEV-36245)
Bad value for the variable "Buffer pool size" (MDEV-21203)
Error while installing MariaDB on Windows Server 2022 due to antivirus interference. (MDEV-35983)
RHEL 8 (and compatible) + Ubuntu 20.04 cannot start systemd servce (EXIT_CAPABILTIES/218) (MDEV-36591)
JSON_UNQUOTE doesn't work with emojis (MDEV-35614)
Fixes for the following :
For a complete list of changes made in MariaDB 10.11.12, with links to detailed information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.
This page is licensed: CC BY-SA / Gnu FDL
WHERE col IN (SELECT ... LEFT JOIN tbl ON tbl.column=reference_outside_subquery)MariaDB 10.11.3 is a Stable (GA) release of MariaDB Community Server 10.11, released on 2023-05-10
The most recent release of MariaDB 10.11 is:
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!
Crash on in a table ()
UNIQUE USING HASH accepts duplicate entries for tricky collations ()
rec_get_offsets() is not optimal ()
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 ()
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 ()
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. ()
Add replication setup to containers contributed by Md Sahil ()
Added LTS tags for easier identification of LTS releases:
lts-jammy
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.
Fixes for the following :
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
InnoDB recovery hangs when buffer pool ran out of memory (MDEV-30551)
InnoDB undo log truncation fails to wait for purge of history (MDEV-30671
MariaDB crash due to DB_FAIL reported for a corrupted page (MDEV-30397)
Deadlock between INSERT and InnoDB non-persistent statistics update (MDEV-30638)
InnoDB hang on B-tree split or merge (MDEV-29835)
Performance regression in locking reads from secondary indexes (MDEV-30357)
Improve adaptive flushing (MDEV-26055)
Make page flushing even faster (MDEV-26827)
Purge misses a chance to free not-yet-reused undo pages (MDEV-29593)
InnoDB temporary tablespace: reclaiming of free space does not work (MDEV-26782)
Deadlock between CHECK TABLE and bulk insert (MDEV-30798)
returns an empty string for U+0251 in uca1400 collations for utf8 (MDEV-30661)
System-wide max transaction id corrupted after changing the undo tablespaces (MDEV-30311)
Fix miscount of doublewrites by (MDEV-31124)
Refined optimistic parallel slave to error-exit without any hang (MDEV-30780)
Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always intialized (MDEV-30620)
Fixed the slave applier to report a correct error when gtid_slave_pos insert fails for some (engine) reasons (MDEV-31038)
Made parallel slave reports in performance schema consistent with that of show-slave-status (MDEV-26071)
now prints more information about Block Nested Loop joins: block-nl-join element now has r_loops, r_effective_rows and r_other_time_ms fields (MDEV-30806, MDEV-30972).
A GROUP BY query with MIN(primary_key) in select list and primary_key<>const in the WHERE could produce wrong result when executed with "Using index for group-by" strategy (MDEV-30605)
EXPLAIN could erroneously report that is used for partitioned tables. Partitioned tables do not support it. (MDEV-30596)
A bug in selectivity computations for SINGLE/DOUBLE_PREC_HB histograms could cause wrong estimates to be produced. This could cause the optimizer to pick sub-optimal query plans (MDEV-31067).
Release date: 6 Nov 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.15 is a Stable (GA) release.
For an overview of MariaDB 10.11 see the MariaDB 10.11 Changes & Improvements page.
Thanks, and enjoy MariaDB!
The InnoDB purge subsystem will no longer reset transaction identifiers in freshly inserted records, because it did severely hurt performance in some workloads. (MDEV-16168)
InnoDB could crash after a DROP TABLE, TRUNCATE TABLE, OPTIMIZE TABLE or a table-rebuilding ALTER TABLE if innodb_adaptive_hash_index entries existed in the table. (MDEV-26599)
InnoDB could crash if the definition of the InnoDB persistent statistics tables were incorrect. (MDEV-31740)
Workloads that are bound by innodb_log_file_size would write out unnecessarily many data pages in an attempt to advance the log checkpoint. ()
ALTER TABLE could fail to update InnoDB persistent statistics. ()
innochecksum misinterprets doublewrite buffer pages ()
Crash recovery after bulk load data reports corruption ()
InnoDB could crash during the crash recovery of a corrupted database. ()
There was a very small chance of InnoDB crashing or misbehaving after an attempt to reduce innodb_buffer_pool_size. ()
The forced use of THD accessor functions hurts InnoDB performance ()
CHECK TABLE…EXTENDED could flag bogus corruption on a column prefix index. ()
During workload after crash recovery, an incorrect (too large) innodb_buffer_pool_pages_dirty could be reported. ()
In rare cases, shutdown might hang ()
Lock checks for secondary indexes were unnecessarily accessing some history and could access freed BLOB pages that correspond to column prefixes. ()
Recovery of Aria transactional tables did not work in big-endian machines like s390x and Sparc (MDEV-34914)
Failure to detect corruption during backups of Aria table (MDEV-37520)
BsonGet_String and JsonGet_String with a NULL argument resulted in an empty string warning. This now has an "Argument is NULL" warning. (MDEV-37633)
FederatedX error 10000 on multi-table UPDATE/DELETE (MDEV-29874)
myisamchk -V crashes (MDEV-37505)
Corrected python3 compatibility of myrocks_hotbackup thanks to contributor i18n.site (MDEV-36010)
Server may crash in spider bg mode if multiple queries are sent by spider bg threads consecutively (MDEV-36325)
Spider: XA COMMIT ONE PHASE fails with "This xid does not exist" (MDEV-37829)
InnoDB could potentially crash if there is any lock conflict on an internal FTS_%_CONFIG table of a FULLTEXT INDEX while one of the INFORMATION_SCHEMA views INNODB_TRX, INNODB_LOCKS, or INNODB_LOCK_WAITS are being accessed. (MDEV-36545)
The minimum value of the parameter innodb_ft_min_token_size was increased to 1, similar to the parameter ft_min_word_len. (MDEV-37423)
Fixed crashing bug when inserting into a tables with several nextval(sequence) default values. (MDEV-37172)
Galera updated to 26.4.24
NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
Setting wsrep_slave_threads causes thread hang when wsrep is not enabled (MDEV-30418)
MariaDB Cluster server crash during insert when replication filters are used ()
Inconsistency detected - create sequence ()
InnoDB partition table disallow local GTIDs in galera ()
Galera replication does not preserve the character set and collation associated with views, etc. ()
MDL conflict between CREATE TRIGGER and INSERT ()
Under selinux, the galera SST port checking resulted in excessive AVC notices. This has been simplified under selinux. ()
Change several Plugin Maturity Levels (MDEV-37858)
Wrong query_ids are logged by the server_audit plugin for inserts by triggers when multi-insert statements are used (MDEV-37434)
Fix server_audit rwlock Performance Schema instrumentation (MDEV-37555)
The number of concurrent connections reported by userstats, when enabled, is updated. (MDEV-23283)
Hashicorp Plugin: enable key version caching by default (MDEV-30849)
Prevent MariaDB server crash when a query includes a derived table containing unnamed column. (MDEV-24588)
Crash when considering Split-Materialized plan (MDEV-29638)
Wrong result when split optimization is used for grouping with order by and limit (MDEV-31887)
Correlated derived table query merges can cause crashes, especially with prepared statements. ()
Crash if subquery is a UNION of SELECT rand() and uncorrelated SELECT ()
UPDATE/DELETE of single table queries would now show r_table_time_ms, and r_other_time_ms during ANALYZE FORMAT=JSON ()
Item_func_nextval::val_int() crash on INSERT...SELECT with subqueries ()
IS TRUE incorrectly converts outer join to inner ()
Wrong result with Loose Scan on QUICK_GROUP_MIN_MAX_SELECT WITH TIES ()
disable_index_merge_plans causes SELECT data loss when more than 100 ORs ()
Server crash on cleanup of non-fully-constructed-due-to-an-error CTE (MDEV-32308)
very long query cannot be killed quickly (MDEV-37938)
LIMIT ROWS EXAMINED prematurely triggers during optimization (MDEV-22241)
Exchange partition with virtual columns fails (MDEV-34033)
ALTER TABLE allows adding unique hash key with duplicate values (MDEV-37296)
LOCATE(X,Y,NULL) is not NULL ()
DDL in procedure propagates no locking to tables locked by DML (MDEV-16686)
Errors or assertion failure upon REPAIR on partitioned Aria table with misplaced rows (MDEV-33190)
On Fedora, RHEL, and derivatives, depend on the mysql-selinux-1.0.14 package that provides the correct selinux rules for the /usr/sbin/mariadbd that is installed. (MDEV-24941)
Crash when calling stored function in FOR loop argument (MDEV-26115)
Several bugs in SPATIAL INDEX page splitting logic could crash InnoDB if the PRIMARY KEY or the SPATIAL data is variable-length. (MDEV-27675)
Wrong results for self-touching shapes. (MDEV-31499)
Corrected the creation of views on JSON_TABLEs to require no special privileges. (MDEV-27898)
View containing JSON_TABLE does not return JSON (MDEV-34081)
Wrong result json_table (MDEV-36319)
Correct return value of JSON_VALUE which in the previous release, incorrectly converted a valid empty string return value to a NULL. This has been reverted to correct behaviour. ()
mysqli silently trims each json_arrayagg result to modulo 64KB ()
A tmpfiles file will now create /run/mysqld path on Debian/Ubuntu packaged distributions. (MDEV-15502)
server cannot load client plugins on Debian (MDEV-34744)
Previous systemd warnings in recent systemd versions about uninitialised environment variables have been corrected. (MDEV-35904)
The PrivateDevices=false directive in the systemd service has been removed as it was an old kernel incompatibility that this directived worked around. With this, the MariaDB is restricted further. Those using InnoDB on raw devices will need to add an override for this. See https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/systemd#useful-systemd-options ()
Parallel slave worker crashes During Backup at retrying (MDEV-37453)
mariadb-dump -T did not encode table names like the server did for frm files, so some tables can be created in the server, but not dumped with mariadb-dump -T, for example, a table con on Windows. (MDEV-37483)
Using mytop with DBD-MariaDB and host=localhost specified resulted in an unexpected error because the driver did not expect a port 3306. Contribution thanks to Jean Weisbuch. (MDEV-37852)
REPLACE on a precise-versioned table returns duplicate key error (ER_DUP_ENTRY) (MDEV-15990)
Parameterized PS converts error to warning, causes replication problems (MDEV-34046)
Fixed bug in maria-backup where 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)
On Windows, when MSI package is installed, with ADDLOCAL parameter passed to msiexec.exe, and Visual C++ Redistributable package is not installed on the target machine, installation may fail during "create database" step. (MDEV-36938)
Fix --master-retry-count=0 not infinite as described (MDEV-36002)
Ensure that Annotate_rows is always written direct after GTID information, before any table_map events. Before this patch the event could be written in a random position in the binary log. This change make the place of the Annotate_rows event predictable.
When mixing transactional and not transactional tables in the same transaction, the Annotate rows event was not always written in the case of a rollback. This is now fixed. (MDEV-37356)
ALTER TABLE ... ENGINE=MRG_MyISAM is now properly logged as an DDL. This ensure that the changed MERGE table cannot be used by a slave thread until after the ALTER command has been executed. ()
Galera galera_new_cluster script and its systemd interactions was rewritten to avoid selinux errors. This will require the mysql-selinux-1.0.14+ version that is a dependency of the server in RPM+selinux distributions. (MDEV-37726)
Fixes for the following :
For a complete list of changes made in MariaDB 10.11.14, with links to detailed information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.11.8 is a Stable (GA) release of MariaDB Community Server 10.11, released on 2024-05-16
The most recent release of MariaDB 10.11 is:
Release date: 16 May 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!
From this version, the tool adds a new command to the top of every dump file. This command cannot be interpreted by MariaDB command line client versions that do not have the sandbox command, or by MySQL command line clients, and an error will be generated in these clients. Other methods of importing the dump will work not have this issue.
Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) ()
Fix InnoDB holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL ()
Fix adaptive hash index corruption after ()
Fixed that internal temporary tables did not wait for freed disk space, and related issues ()
Fix wrong result on 2nd execution of prepared statement for query with derived table ()
Improve Spider performance by pushing down function () and statement () to data nodes
Fix server crash when deleting partitions from a table with spider engine ()
SPIDER plugin initialization no longer fails at 'create table if not exists mysql.spider_tables ... with 'Specified key was too long; max key length is 1000 bytes', Warning: Memory not freed: 10720 ()
Port backup features from Enterprise Server. This adds support for to , and obsoletes the and options ()
now preserves ()
Fix problem on older mariadb (opendir(NULL)) caused by ()
Fixed improper application of COLLATE to non-character columns ()
Default charset now works with PHP MySQLi extension ()
Fixed Bad SEPARATOR value in on character set conversion ()
View created via now returns correct json object ()
now detects the type of String Values and correctly returns Date/DateTime values ()
no longer returns NULL on valid arguments ()
WolfSSL's math is unnecessarily slow ()
Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables ()
Wrong result with cross Join given join order ()
Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT ()
The now reports the user and host in all cases ()
--gtid-ignore-duplicate can double-apply event in case of parallel replication retry ()
Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure ()
mysql_manager_submit Segfault at Startup Still Possible During Recovery ()
updated to 26.4.18
NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
Disallow bulk insert operation during partition update statement ()
Transportable Tablespaces no longer leave in a mismatched state ()
Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption ()
Fix incorrect DEFAULT expression evaluated in ()
MariaDB-client community can't be installed in red hat ubi9 ()
It's now possible to disable system commands with the option. ()
now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.()
commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions ()
Moving from to 10.6 mysql_upgrade is not updating some system tables ()
Original IP not shown in network related error messages when proxy_protocol is in use ()
Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup ()
Fixes for the following :
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
Fix LeakSanitizer errors in rec_copy_prefix_to_buf (MDEV-33230)
Fix InnoDB fatal error: Clustered record field for column x not found (MDEV-33558)
Fix InnoDB hang when temporarily running out of buffer pool (MDEV-33613)
Fix alter operation hang when encryption thread works on the same tablespace (MDEV-33770)
Fix MariaDB segfault on rowid filter query involving generated column (MDEV-33795)
Fix discard/import tablespace, restart, index corruption (MDEV-33512)
Fix server hang on DROP INDEX or RENAME INDEX (MDEV-33993)
Fix mariadb-backup --backup hang (MDEV-33669)
Fix server hang caused by InnoDB change buffer (MDEV-33543)
Fix assertion failures upon adding a too long key to table with COMPRESSED row format (MDEV-31161)
IMPORT TABLESPACE no longer fails with column count or index count mismatch (MDEV-30655)
Fix alter table corruption while applying the modification log (MDEV-19044)
Fix inconsistent behaviors of UPDATE under RU & RC isolation level (MDEV-26643)
Fix weird SELECT view when a record is modified to the same value by two transactions (MDEV-26642)
Fix inconsistent read and write, which use the same predicate (WHERE clause) (MDEV-29565)
Fix inconsistent SELECT view when modifying a record added by another transaction (MDEV-26671)
Fix weird read view after ROLLBACK of other transactions (MDEV-33802)
Read only server no longer throws error when running a create temporary table as select statement (MDEV-33889)
Change buffer index no longer fails to delete the records (MDEV-32489)
Fix InnoDB include OS error information when failing to write to iblogfile0 (MDEV-33397)
Fix phantom rows caused by UPDATE of PRIMARY KEY (MDEV-32898)
New system variable,
In-place migration from MySQL 5.7 no longer causes invalid AUTO_INCREMENT values (MDEV-33277)
Fix InnoDB log corruption before upgrading it on startup (MDEV-32445)
Table no longer gets rebuilt with ALTER TABLE ADD COLUMN (MDEV-33214)
Fix spider plugin init failure with no_zero_date sql_mode (MDEV-33494)
Fix sql plugin init failure with traditional sql_mode (MDEV-33584)
Fix parsing failure on valid left join select by translating the on expression to () (MDEV-33679)
Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using MariaDB 10.5 local and MariaDB 10.6 remote (MDEV-33777)
Fix bug where were not available if Spider was loaded upon server startup (MDEV-33441)
Fix mariadb-backup --backup FATAL ERROR: ... Can't open datafile cool_down/t3 (MDEV-33011)
mariadb-backup --backup now includes retry logic for undo tablespaces (MDEV-33980)
Fix crash recovery in mariadb-backup --prepare due to insufficient (MDEV-33540)
Fix crash in mariadb-backup --prepare --export after --prepare (MDEV-33023)
mariadb-backup now considers O/S user when --user option is omitted (MDEV-32893)
Fixed and problems with (MDEV-21034)
Optimizer choosing incorrect index in 10.6, 10.5 but not in 10.4 (MDEV-33306)
Aggregation functions fail to leverage uniqueness property (MDEV-30660)
Partitioning is broken on big endian architectures (MDEV-33623)
server option changed from having a numeric value to a set value with new options to affect the optimizer. The old numeric values still work.
Slave crashed:reload_acl_and_cache during shutdown (MDEV-30260)
Rpl_semi_sync_slave_status is ON When Replication Is Not Configured (MDEV-33546)
When binlog_annotate_row_events on , event of binlog file is truncated (MDEV-9179)
Add more warnings to be able to better diagnose network issues (MDEV-33582)
Improve times and states in show processlist for replication (MDEV-33620)
Adapt parallel slave's round-robin scheduling to XA events (MDEV-33668)
release row locks for non-modified rows at XA PREPARE (MDEV-33454)
Semi-sync Wait Point AFTER_COMMIT Slow on Workloads with Heavy Concurrency (MDEV-33551)
Fix incorrect handling of in PS mode when a table's column declared as NOT NULL (MDEV-33549)
Fix crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT (MDEV-15703)
Fix wrong result on 2nd execution of PS to select from view using derived (MDEV-31277)
Fix wrong warnings on 2nd execution of PS for query with GROUP_CONCAT (MDEV-31276)
value of '1970-01-01 00:00:00' can no longer be indirectly inserted in (MDEV-34088)
Fix out of range error in (()) due to a wrong data type (MDEV-33496)
Fix zero datetime reinterpreting as '1970-01-01 00:00:00' on field_datetime=field_timestamp (MDEV-34069)
unix_timestamp(coalesce(timestamp_column)) no longer returns NULL on '1970-01-01 00:00:00.000001' (MDEV-34061)
Fix crash using UDF in WHERE clause of VIEW (MDEV-24507)
Fix update for portion changes autoincrement key in period table (MDEV-25370)
Fix SIGABRT resulting from CREATE TABLE with generated column and RLIKE (MDEV-21058)
Loading now works with INPLACE (MDEV-33044)
MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params (MDEV-26923)
Slowdown when running nested statement with many partitions (MDEV-33502)
MariaDB 10.11.7 is a Stable (GA) release of MariaDB Community Server 10.11, released on 2024-02-07
The most recent release of MariaDB 10.11 is:
Release date: 7 Feb 2024
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!
Windows packages were delayed but have now been added to the downloads site
Unique hash key on column prefix is computed incorrectly ()
Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old ()
mariadb-backup has wrong or missing plugin-dir default? ()
mariadb-backup fails when innodb_max_dirty_pages_pct contains a fraction (is not an integer) ()
Missing required privilege CONNECTION ADMIN ()
Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE ()
JSON_VALID fail to validate integer zero in scientific notation ()
ASAN
Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider ()
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES ()
Crash caused by multi-table UPDATE over derived with hanging CTE ()
Crash on query using CTE with the same name as a base table ()
Crash with query using constant subquery as left part of IN subquery ()
ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note ()
Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY ()
InnoDB: CHAR+nopad does not work well ()
CAST(AS UNSIGNED) fails with --view-protocol ()
JSON_ARRAYAGG charset issue ()
The can optionally (when is enabled) include the thread ID and database / table in its log (). NULL is displayed if there is no database ()
Backport SQL service, introduced by ()
"plugin already loaded" should be a Warning, not an Error (
Node has been dropped from the cluster on Startup / Shutdown with async replica ()
Inconsistency in Galera caused by ALTER being aborted before entering TOI mode ()
Assertion ``total_length + thd->wsrep_sr().log_position() == saved_pos'failed in intwsrep_write_cache_inc(THD*, IO_CACHE*, size_t*)` ()
Server crashes in Item_func_binlog_gtid_pos::val_str / Binary_string::c_ptr_safe ()
binlog corruption (/tmp no space left on device at the same moment) ()
multi source replication filters breaking GTID semantic ()
As per the , this will be the last release of for Fedora 37, Ubuntu 23.04 "Lunar", and Windows Server 2019
is now dynamic, and contains new options, and old options have been deprecated ()
New value, NO_NULL_COLLATION_IDS, a compatibility setting to support connectors (in particular MySQL Connector/NET) that give an exception when collation ids returned by are NULL. It is automatically set when a MySQL Connector/NET connection is determined.
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search (MDEV-21245)Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table (MDEV-31574)
Crash emitting "Unsupported meta-data version number" error message (MDEV-29972)
LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED (MDEV-32890)
Inplace alter rebuild increases file size (MDEV-26740)
BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY (MDEV-31441)
GNU libc posix_fallocate() may be extremely slow (MDEV-32268)
InnoDB wrong error message (MDEV-32833)
Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 (MDEV-31000)
InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe (MDEV-32269)
InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty (MDEV-32968)
innodb_fast_shutdown=0 hang after incomplete startup (MDEV-32798)
innodb_undo_log_truncate=ON prevents fast shutdown (MDEV-33062)
Adaptive flush recommendation ignores dirty ratio and checkpoint age (MDEV-31939)
gcol.gcol_purge contaminates further execution of innodb.gap_locks (MDEV-28682)
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE (MDEV-27744)
Adaptive flushing is still not getting invoked in 10.5.11 (MDEV-26055)
History list is not shrunk unless there is a pause in the workload (MDEV-33213)
path separator near ib_buffer_pool incorrect (MDEV-32983)
Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption (MDEV-32371)
Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON (MDEV-31861)
Assertion ``end_lsn == page_lsn'failed inrecv_recover_page` (MDEV-33137)
Some calls to buf_read_ahead_linear() seem to be useless (MDEV-32068)
Opening all .ibd files on InnoDB startup can be slow (MDEV-32027)
InnoDB LRU flushing does not run before running out of buffer pool (MDEV-33053)
innodb_undo_log_truncate=ON is blocking page writes (MDEV-33112)
If tables are frequently created, renamed, dropped, a backup cannot be restored (MDEV-32939)
on table to be accessible to those with privileges (MDEV-28367)
Item_func_json_contains_path::val_intmysql_json cannot be used on newly created table (MDEV-32235)
Problems with a stored function EMPTY() on upgrade to 10.6 (MDEV-31616)
Crash when lateral derived is guaranteed to return no rows (MDEV-31279)
Bogus error executing PS for query using CTE with renaming of columns (MDEV-31995)
Spider: Valid LEFT JOIN results in ERROR 1064 (MDEV-26247)
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache (MDEV-28739)
Spider tests failing in asan/valgrind builds (MDEV-32849)
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service (MDEV-29870)
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table (MDEV-29163)
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table (MDEV-30014)
Syntax error upon query with subquery from Spider table (MDEV-30392)
Spider doesn't recognize semi JOIN (MDEV-31645)
MariaDB, SPIDER engine, usage of REGEXP (MDEV-32986)
Spider: variable spider_same_server_link not functioning correctly (MDEV-29718)
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown (MDEV-33008)
Spider spawns unnecessarily many system threads for stats synchronization (MDEV-29020)
Defaults for and changed from 10 to 1
SIGSEGV in spider_db_delete_all_rows on TRUNCATE, UBSAN: member call on null pointer of type 'struct spider_db_handler' in spider_db_delete_all_rows (MDEV-33191)
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' (MDEV-27103)
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete (MDEV-28683)
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included (MDEV-30170)
ASAN errors in spider_conn_queue_and_merge_loop_check (MDEV-29002)
mysql_explain_union() (MDEV-33165)INSERT ... SELECT Does not produce an optimizer trace (MDEV-29298)
Unusable key notes do not get reported for some operations (MDEV-32958)
Unusable key notes report wrong predicates for > and >= (MDEV-32957)
Add variable to influence how costs for secondary keys are calculated. (MDEV-33118)
FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure (MDEV-29092)
Assertion !"wrong page type"'` or Assertion "wrong page type" == 0'failed ininnobase_instant_tryonALTER` (MDEV-18322)
Assertion (col.vers_sys_end()) upon inplace ALTER with virtual columns (MDEV-20545)
DELETE with ORDER BY and semijoin optimization causing crash (MDEV-32212)
Invalid expr in cleanup_session_expr() upon INSERT DELAYED (MDEV-29932)
SIGSEGV in my_decimal::operator= and Assertion 0'failed inItem_type_holder::val_decimal` on SELECT (MDEV-29070)
LONG UNIQUE does not work like unique key when using replace (MDEV-32837)
LONG UNIQUE gives error when used with REPLACE (MDEV-32839)
Backport MDEV-32532 to 10.6 (MDEV-32903)
Assertion ``0' failed in Item_type_holder::val_int` (MDEV-29494)
Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types (MDEV-32879)
mariadb-upgrade should remove mysql.plugin entries for plugins that became bundled (MDEV-32043)
wsrep_provider_options can be truncated on deep and long directory paths (MDEV-32634)
Server crashes in rpl_sql_thread_info::cached_charset_compare / wsrep_apply_events (MDEV-22232)
Galera crash when "create a table as select" (MDEV-27806)
Cluster is inconsistent after SAVEPOINT statement is rolled back (MDEV-32549)
WSREP GTID MODE is inconsistent (MDEV-31905)
IST "Donor does not know my secret" with ssl-mode=VERIFY_CA (MDEV-32344)
SHOW SLAVE STATUS Can Deadlock an Errored Slave (MDEV-10653)
main.rpl_mysqldump_slave Fails with "Master binlog wasn't deleted" Assertion (MDEV-32953)
rpl_seconds_behind_master_spike Sensitive to IO Thread Stop Position (MDEV-33327)
Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty (MDEV-33283)
"Read semi-sync reply magic number error" warnings on master (MDEV-32551)
Second Semi-sync Replica Can Hang at Connect Time (MDEV-32792)
Semi-sync ACKed Transaction can Timeout and Switch Off Semi-sync with Multiple Replicas (MDEV-32960)
Semi-Sync Ack_Receiver Thread Should Allow COM_QUIT Command (MDEV-32385)
Upgrade to 12.6.
Using two temporary tables in OPTIMIZE TABLE lead to crash (MDEV-31523)
REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode (MDEV-29095)
CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" (MDEV-21618)
Failure when executing PS for query using IN subquery (MDEV-32569)
Potential memory leak on execuing of create view statement (MDEV-32466)
Assertion failures (MDEV-32965)
Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES (MDEV-32733)
Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds (MDEV-33169)
Set TaskMax=inifinity in the MariaDB systemd unit (MDEV-30236)
Unreliable autocommit flag on connection creation (MDEV-32875)
A connection can control RAND() in following connection (MDEV-33148)
THD::rli_fake/rgi_fake not cleared on new connection (MDEV-32844)
Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> (MDEV-20471)
Server crash in find_field_in_table (MDEV-32082)
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE (MDEV-27744)
Failure to call SP invoking another SP with parameter requiring type conversion (MDEV-33270)
The database part is not case sensitive in SP names (MDEV-33019)
EXCHANGE PARTITION with non-matching vcol expression segfault (MDEV-28127)
Wrong user in SET DEFAULT ROLE error (MDEV-26875)
quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') (MDEV-28651)
mysql.slow_log reports incorrect start time (MDEV-11628)
Update federated table and column privileges (MDEV-32984)
Disable transparent huge pages after page buffers have been allocated (MDEV-33279)
Deprecate (MDEV-32617)
sys schema view session_ssl_status is empty (MDEV-32751)
Memory pressure (MDEV-24670)
MariaDB 10.11.6 is a Stable (GA) release of MariaDB Community Server 10.11, released on 2023-11-13
The most recent release of MariaDB 10.11 is:
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!
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 ()
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 ()
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 ()
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 ()
(mysqlbinlog) option ()
(mysqladmin) wrong error with ()
shows warning on missing directory $pamtooldir/auth_pam_tool_dir ()
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 full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 ()
mbstream breaks page compression on XFS ()
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 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 ()
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 ()
Added the system variable, which permits warnings to be logged in addition to errors.
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 -
Added the system variable to manage .
Fixes for the following :
For a complete list of changes made in , with links to detailed information on each push, see the .
For a full list of contributors to , see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
InnoDB: tried to purge non-delete-marked record of an index on a virtual column prefix (MDEV-30024)
lock_row_lock_current_waits counter in information_schema.innodb_metrics may become negative (MDEV-30658)
SET GLOBAL innodb_max_purge_lag_wait=… hangs if innodb_read_only=ON (MDEV-31813)
Auto-increment no longer works for explicit FTS_DOC_ID (MDEV-32017)
Assertion `pos < table->n_def' failed in dict_table_get_nth_col (MDEV-32337)
innochecksum man pages seem to be inconsistent with the binary (10.2.25) (MDEV-20583)
innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error (MDEV-30825)
wrong table name in innodb's "row too big" errors (MDEV-32128)
Optimize is_file_on_ssd() to speedup opening tablespaces on Windows (MDEV-32228)
Race condition between page write completion and log checkpoint (MDEV-32511)
After crash recovery, Checksum mismatch + Failing assertion: !i || prev_id + 1 == space_id, (MDEV-31851)
Deadlock due to log_free_check(), involving trx_purge_truncate_rseg_history() and trx_undo_assign_low() (MDEV-32049)
Write-ahead logging is broken for freed pages (MDEV-32552)
X-lock on supremum for prepared transaction for RR (MDEV-30165)
Assertion failures in log_sort_flush_list upon crash recovery (MDEV-32029)
Race condition between page write completion and log checkpoint (MDEV-32511)
Assertion `purge_sys.tail.trx_no <= purge_sys.rseg->last_trx_no()' (MDEV-30100)
Assertion `index->is_btree() || index->is_ibuf()' failed in btr_search_guess_on_hash (MDEV-30802)
InnoDB hang in buf_flush_wait_LRU_batch_end() (MDEV-32134)
InnoDB may hang when running out of buffer pool (MDEV-32588)
Corrupt index(es) on busy table when using FOREIGN KEY (MDEV-30531)
InnoDB Recovery doesn't display encryption message when no encryption configuration passed (MDEV-31098)
Wrong information about innodb_checksum_algorithm in the information_schema.SYSTEM_VARIABLES (MDEV-31473)
InnoDB may fail to recover after being killed in fil_delete_tablespace() (MDEV-31826)
Create separate tpool thread for async aio (MDEV-31095)
UNDO logs still growing for write-intensive workloads (MDEV-32050)
Increase the default for from 300 to 1000 (MDEV-32050)
Deprecate .
The motivation for introducing this in MySQL seems to have been to avoid stalls due to freeing undo log pages or truncating undo log tablespaces. In MariaDB, should be a much lighter operation because it will not involve any log checkpoint. ()
Slow full index scan in 10.6 vs 10.5 for the (slow) I/O-bound case (MDEV-30986)
LOAD DATA into InnoDB w/partitions: huge performance loss, affected 10.6+ (MDEV-31835)
Disable read-ahead for temporary tablespace (MDEV-32145)
Server crashes inside filesort at my_decimal::to_binary (MDEV-32324)
Assertion `bitmap_is_set(&m_part_info->read_partitions, m_part_spec.start_part)' failed in ha_partition::handle_ordered_index_scan (MDEV-24283)
Crash when searching for the best split of derived table (MDEV-32064)
Test case from opt_tvc.test fails with statement memory protection (MDEV-32225)
Significant slowdown for query with many outer joins (MDEV-32351)
test_if_skip_sort_order() should catch the join types JT_EQ_REF, JT_CONST and JT_SYSTEM and skip sort order for these (MDEV-32475)
jointable materialization subquery optimization ignoring errors, then failing ASSERT. (MDEV-31983)
Server crashes in JOIN::cleanup after erroneous query with view (MDEV-32164)
Prepared statement return wrong result (missing row) (MDEV-9938)
Assertion `range->rows >= s->found_records' failed in best_access_path (MDEV-32682)
SHOW SLAVE STATUS Last_SQL_Errno Race Condition on Errored Slave Restart (MDEV-31177)
seconds_behind_master is inaccurate for Delayed replication (MDEV-32265)
detailize the semisync replication magic number error (MDEV-32365)
Parallel replication deadlock