MariaDB 11.2 is a short-term development series of MariaDB, and will be maintained for one year after its Generally Available release. It is an evolution of MariaDB 11.1 with several entirely new features.
MariaDB 11.2.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into .
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.2-preview.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
The is now shrunk by reclaiming unused space at startup ()
now allows retrieval of the key when iterating on JSON objects ()
New functions , and to check for JSON intersection ()
extracts key/value pairs from a JSON object ()
All binlog* variables are now visible as system variables, specifically , , ()
enhancement ()
Temporary tables are now displayed in the , and ()
This page is licensed: CC BY-SA / Gnu FDL
: validation of stored program statements ()
Remove the deprecated variable ()
Extend and to support an initialization vector and algorithm ()
InnoDB
JSON
Miscellaneous
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.
MariaDB 10.9 is the current short-term maintenance stable series of MariaDB, maintained until August 2023. It is an evolution of MariaDB 10.8 with several entirely new features.
Assertion mysql_mutex_assert_owner(&log_sys.flush_order_mutex) failed in mtr_t::commit() ()
Frequent "Data structure corruption" in InnoDB after OOM ()
Recovery or backup of instant ALTER TABLE is incorrect ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.8.2 Release notes
The most recent release of is: Stable (GA)
| | |
Release date: 12 Feb 2022
Do not use non-stable (non-GA) releases in production!
is the current development series of MariaDB. It is an evolution of with several entirely new features.
is a release.
InnoDB Temporary Tablespace (ibtmp1) is continuously growing ()
Full text index corruption if shutdown before changes are fully flushed ()
does not parse NULL properties properly ()
InnoDB hangs on multiple concurrent requests of a cold ROW_FORMAT=COMPRESSED page ()
Notable Items
Issues Fixed
Security
Changelog
Contributors
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.
MariaDB 11.1 was a short-term maintenance series of MariaDB maintained until August 2024
Notable Items
InnoDB
General
Security
Changelog
Contributors
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.
MariaDB 11.0 is a current short-term stable series of MariaDB and will be maintained until June 2024. It is an evolution of MariaDB 10.11 with several entirely new features.
Given a time in picoseconds, the new function returns a human-readable time value and unit indicator ()
InnoDB does not free UNDO after the fix of ()
InnoDB hang fixes (, , )
is not updated correctly ()
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 ON by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. ()
Crash with condition pushable into derived and containing outer reference ( )
New status variable: ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 11.6.0 Vector Release Notes
Release date: 29 July 2024
Vector is a . It is an evolution of with several entirely new features.
Vector is a preview release intended to highlight early work on Vectors. Features are to be considered preview, and will not be a part of .
It is available as a source download only from the download site, and is available as a container quay.io/mariadb-foundation/mariadb-devel:11.6-preview.
Thanks, and enjoy MariaDB!
Release Notes - MariaDB 11.7 Rolling Releases
MariaDB 11.7 was a rolling release, and is no longer maintained.
Release Notes - MariaDB 10.8 Series
MariaDB 10.8 was a short-term maintenance stable series of MariaDB maintained until May 2023
InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)
Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"
Crash with for multi-table update of system table (MDEV-31224)
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.
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.
for single-table / statements. Update and delete statements that use subqueries can now use all subquery optimization strategies that MariaDB offers, so now if you use subqueries in UPDATE or DELETE, these statements will likely be much faster ()
Queries with the or functions comparing against a constant can now make use of indexes, so these will be noticeably quicker in certain instances. For example SELECT * FROM t2 WHERE YEAR(a) = 2019 or SELECT * FROM t2 WHERE DATE(a) <= '2017-01-01'. See ()
The option is now a system variable, and the tx_isolation system variable is deprecated ()
Remove and related parameters ()
Rename xtrabackup_* files to mariadb_backup_* ()
For a list of all new variables, see .
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
:
:
Date
Release
Status
Release Notes
Changelog
This page is licensed: CC BY-SA / Gnu FDL
Release Notes - MariaDB 11.2 Series
MariaDB 11.2 was a short-term maintenance series of MariaDB maintained until November 2024
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.
MariaDB 10.7 is a previous short-term maintenance stable series of MariaDB, supported until February 2023. It is an evolution of MariaDB 10.6 with several entirely new features.
As mentioned in the , 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 and the page for more details.
corruption with ()
recovery and backup fixes (, , )
Upgrade after a crash is not supported ()
updated to 26.4.14
Fixes for cluster wide write conflict resolving ()
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE ()
Seconds_Behind_Master is showed now more precisely at the slave applier start, including in the delayed mode ()
mysqlbinlog --verbose is made to show the type of compressed columns ()
added as an alias for ()
Infinite sequence of recursive calls when processing embedded CTE ()
Crash with a query containing nested WINDOW clauses ()
Major performance regression with 10.6.11 ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
Remove load throttling ()
InnoDB shutdown hangs when the change buffer is corrupted ()
innodb_fast_shutdown=0 fails to report change buffer merge progress ()
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 (, )
Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA ()
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.
Notable Items
InnoDB
Galera
Replication
JSON
General
Security
Changelog
Contributors
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.
MariaDB 12.0.2 is a Stable (GA) release. It is an evolution of MariaDB 11.8 with several entirely new features.
MariaDB 12.0 is a rolling release. One is expected to upgrade to MariaDB 12.1.2, there will be no 12.0.3.
Thanks, and enjoy MariaDB!
For an overview of MariaDB 12.0 see thepage.
Thanks, and enjoy MariaDB!
After SET GLOBAL innodb_buffer_pool_size was aborted while attempting to shrink the buffer pool, executing SET GLOBAL innodb_adaptive_hash_index=ON could lead to corruption of the adaptive hash index. ()
When innodb_buffer_pool_size is being shrunk while there are no data pages cached, InnoDB could hang or crash. ()
Assertion when adding FK to MyISAM/Aria table with a vector index ()
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 ()
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. ()
CREATE OR REPLACE with self-referencing CHECK hangs forever, cannot be killed ()
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 ()
Split Materialized code: last_refills is never set in 11.0+ ()
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 ()
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 ()
UNIQUE constraint that was USING HASH and UNIQUE constraint WITHOUT OVERLAPS could be violated under heavy load in READ COMMITTED transaction isolation mode. ()
Changing the server character set in my.cnf could cause debian-start script to fail with "Illegal mix of collations" ().
aws_key_management compilation was previously broken, is now fixed. plugin can be compiled again. As before, -DNOT_FOR_DISTRIBUTION=ON is necessary to build it. ()
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 and SLES 15 SP7 are new packages in this release. Because of incompatibilities of packages between SLES service pack versions there are now separate packages for 15sp6 and 15sp7. 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 12.0.1, with links to detailed information on each push, see the .
After a successful shrinking of innodb_buffer_pool_size, there will be no message about it in the server error log.
After a failed shrinking of innodb_buffer_pool_size, the adaptive hash index will not be re-enabled if innodb_adaptive_hash_index was ON when SET GLOBAL innodb_buffer_pool_size=... started to execute. (MDEV-36868)
AUTO_INCREMENT leads to non-serializable on results (MDEV-36330)
Vector index was corrupted if one statement was rolled back (e.g. insert violating a unique constraint) in the middle of a larger transaction. (MDEV-37068)
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.
Don't generate index_merge plans, if a column is present in both Secondary Key and Primary Key indexes and either of the indexes include it with DESC order (as the scan itself is not a ROR scan). (MDEV-36410)
Incorrect handling of null values on join conditions. (MDEV-37057)
Optimize Rows_log_event Reporting of Process Info (MDEV-36839)
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)
This is the last release of the interim Ubuntu 24.10 which ended its standard support in July 2025 (MDBF-1090)
Ubuntu 25.04 (Plucky Puffin) packages are available for amd64 and arm64 (MDBF-849)
Debian 13 (Trixie) packages are available for amd64, arm64, ppc64le and i386 (MDBF-848)
Notable Items
Storage Engines
InnoDB
Aria
Data Definition - Alter Table
Partitioning
Data Definition - Create Table
Server
mariabackup
Optimizer
JSON
Galera
Replication
Stored routines
Authentication and Privilege System
Locking
Data Manipulation - Insert
Character Sets
Plugin - AWS key management
Packaging
Sequences
XA
General
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.
MariaDB 11.3 is a previous rolling release. It is the first release in the new release model. From 11.3, we stop doing GA bug fix releases within each minor version. See Adjusting the MariaDB Server release model (mariadb.org).
Upgrading
See and .
New Features & Improvements
Connection Redirection
Added a using the system variable ()
At the moment client-side support is missing
Shrink without restart by setting the system variable. ()
Add keywords "SQL_BEFORE_GTIDS" and "SQL_AFTER_GTIDS" for ().
SQL_BEFORE_GTIDS stops the replica when it sees gtids of the option's argument list, without executing them.
It is now possible to create on tables that contain ()
data types can now be cast into types ()
This means INET4 values can be compared with INET6 values and can be inserted into INET6 columns;
the server can automatically convert INET4 value into INET6 as needed.
Values generated by the Key Derivation Function are resistant against password hashing generators, so are good for strongly hashed passwords ().
function can now print the current time zone abbreviation and current time zone offset from UTC with %Z and %z format specifiers. ()
Queries like can now use an index on varchar_col if its collation is case insensitive. An option, , has been added to enable this optimization. ()
Add a new database-level , SHOW CREATE ROUTINE that allows one to see the routine definition even if the user isn't the routine owner ()
Added a SENT_ROWS column to the table, as well as extended the display size for the columns in processlist to ensure that most results will fit in display ()
Setting a non-default value will now always issue a deprecation warning ()
mode has been deprecated ()
The storage engine now supports table options instead of having to encode them in COMMENT/CONNECTION strings. When any table option is specified, Spider will ignore COMMENT/CONNECTION strings at the same table/partition/subpartition. A new variable is introduced to ignore them globally at all levels (table/partition/subpartition). Another variable, , is introduced to suppress warnings when Spider ignores COMMENT/CONNECTION strings. ()
The following deprecated features and system variables have been removed ():
sr_YU (deprecated since )
"engine_condition_pushdown" in (deprecated since )
, , , (deprecated since )
For a list of all new variables, see .
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
MariaDB 10.10 is a current short-term maintenance stable series of MariaDB, maintained until November 2023. It is an evolution of MariaDB 10.9 with several entirely new features.
As mentioned in the , 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 and the page for more details.
corruption with ()
recovery and backup fixes (, , )
Upgrade after a crash is not supported ()
updated to 26.4.14
Fixes for cluster wide write conflict resolving ()
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE ()
is now shown now more precisely at the slave applier start, including in the delayed mode ()
mysqlbinlog --verbose is made to show the type of compressed columns ()
added as an alias for ()
Infinite sequence of recursive calls when processing embedded CTE ()
Crash with a query containing nested WINDOW clauses ()
Major performance regression with 10.6.11 ()
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed information on each push, see the .
MariaDB 11.1 is a current development series of MariaDB, and will be maintained for one year after its Generally Available release. It is an evolution of MariaDB 11.0 with several entirely new features.
MariaDB 11.1.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into .
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.1-preview.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
Remove and related parameters ()
for single-table / statements. Update and delete statements that use subqueries can now use all subquery optimization strategies that MariaDB offers, so now if you use subqueries in UPDATE or DELETE, these statements will likely be much faster ()
Queries with the or functions comparing against a constant can now make use of indexes, so these will be noticeably quicker in certain instances. For example SELECT * FROM t2 WHERE YEAR(a) = 2019 or SELECT * FROM t2 WHERE DATE(a) <= '2017-01-01' ()
ALTER ONLINE TABLE - not released in the final ()
function for validating a JSON schema ()
Rename xtrabackup_* files to mariadb_backup_* ()
This page is licensed: CC BY-SA / Gnu FDL
(deprecated since )
"parser" in table comment (deprecated since )
16 Feb 2024
Stable (GA)
InnoDB
Replication
Data Types
Functions
Date and Time
Optimizer
Privileges
Processlist
OLD_MODE
mariadb-backup
Spider
Removed
Variables
Security Vulnerabilities Fixed in
List of All Releases
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.
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 (, )
Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA ()
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.
InnoDB
Galera
Replication
JSON
General
Security
Changelog
Contributors
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.
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.
MariaDB 11.3 is a current development series of MariaDB. It is an evolution of MariaDB 11.2 with several entirely new features.
MariaDB 11.3.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.3.
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.3-preview.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
Added a using the system variable ()
At the moment client-side support is missing
Shrink without restart by setting the system variable. ()
Add keywords "SQL_BEFORE_GTIDS" and "SQL_AFTER_GTIDS" for ().
SQL_BEFORE_GTIDS stops the replica when it sees gtids of the option's argument list, without executing them.
Note that this feature did not make it into , but is in .
is now enabled in the server by default. No configuration necessary, if no server certificate was provided a self-signed certificate will be automatically generated by the server. See on mariadb.org ().
Clients now can validate self-signed server certificates if the or authentication is used and account password is not empty ().
data types can now be cast into types ()
This means, INET4 values can be compared with INET6 values and can be inserted into INET6 columns, the server can automatically convert INET4 value into INET6 as needed.
Values generated by the Key Derivation Function are resistant against password hashing generators, so are good for strongly hashed passwords ().
function can now print the current time zone abbreviation and current time zone offset from UTC with %Z and %z format specifiers. ()
Queries like can now use an index on varchar_col if its collation is case insensitive. An option, , has been added to enable this optimization. ()
Add a new database-level , SHOW CREATE ROUTINE that allows to see the routine definition even if the user isn't the routine owner ()
Added a SENT_ROWS column to the table, as well as extended the display size for the columns in processlist to ensure that most results will fit in display ()
Note that this feature did not make it into , but is in .
Add views for in information_schema (), in particular
New view
Setting a non-default value will now always issue a deprecation warning ()
mode has been deprecated ()
The storage engine now supports table options instead of having to encode them in COMMENT/CONNECTION strings. When any table option is specified, Spider will ignore COMMENT/CONNECTION strings at the same table/partition/subpartition. A new variable is introduced to ignore them globally at all levels (table/partition/subpartition). Another variable, , is introduced to suppress warnings when Spider ignores COMMENT/CONNECTION strings. ()
The following deprecated features and system variables have been removed ():
(deprecated since )
sr_YU (deprecated since )
"engine_condition_pushdown" in (deprecated since )
MariaDB 10.8 is a previous short-term maintenance stable series of MariaDB, maintained until May 2023. It is an evolution of MariaDB 10.7 with several entirely new features.
The server no longer tolerates incorrectly configured SSL (). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.
Assertion on info.page_size failed in xb_delta_open_matching_space ()
locks database for minutes ()
Adaptive hash index ,
MVCC and locking (, , , )
Virtual columns (, )
updated to 26.4.13
Galera server crashes after 10.3 > 10.4 upgrade ()
status variable prints 0 as port number if the port is not mentioned in system variable ()
XA COMMIT is not binlogged when the has not updated any transaction engine ()
Concurrent statements made to binlog without any mixup ()
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 .
MariaDB 10.9 is a current development series of MariaDB. It is an evolution of MariaDB 10.8 with several entirely new features.
MariaDB 10.9.0 is not a single release, but is instead a number of preview releases based on feature branches. Each should be considered Alpha.
Read more about feature preview releases .
Thanks, and enjoy MariaDB!
Remember, these features are in separate preview packages. The subsection header text corresponds to the preview package name.
function ()
Implement range notation for ()
Support negative index ()
Extend to support [SHOW ANALYZE ] ()
Add EXPLAIN FOR CONNECTION syntax support to ()
Asynchronous write () (not included in )
Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for ()
now shows TEMPORARY for local temporary tables () (not included in )
Merge to sql variable ()
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 12.2.1 Release Notes
MariaDB 12.2.1 is a Release Candidate (RC) release of MariaDB Community Server 12.2, released on 2025-11-21
"parser" in table comment (deprecated since MariaDB 10.2.11)
Connection Redirection
InnoDB
Replication
SSL/TLS
Data Types
Functions
Date and Time
Optimizer
Privileges
Processlist
Application-Time Periods
OLD_MODE
mariadb-backup
Spider
Removed
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.
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.
for implementing using keys stored in the Hashicorp Vault KMS (MDEV-19281)
JSON file interface to wsrep node state / SST progress logging (MDEV-26971)
Allow to change without server restart (MDEV-27812)
JSON
SHOW ANALYZE FORMAT=JSON
Async redo log write
Miscellaneous
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.
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.
New statement for performing actions as another user (MDEV-20299)
Implement SHA2 support for file_key_management.so plugin (TDE) (MDEV-34712)
Comparison (stored_func(),1)=ROW(1,1) erroneously called stored_func() twice per row. It led to a performance degradation, as well as to a double execution of the possible stored function side effects. (MDEV-36322)
Add support for the pre-defined weak SYS_REFCURSOR (MDEV-20034)
system variable limits the number of opened at the same time
Add the FM format to , which suppresses following padding (MDEV-36216)
Add support for TRIGGERS that fire on multiple events (MDEV-10164)
Server displays if it was started with the option (MDEV-27669)
has been added as a system variable (previously it was just an option). It determines whether to show the user and password in (SHOW SLAVE HOSTS) on the primary.
system variable added (previously it was just an option), which permits not skipping events having our server id.
Ensure that creation and usage of temporary tables in replication is predictable ()
system variable.
In Galera, needless foreign key checks during Incremental State Transfers are now avoided (MDEV-34822)
The now logs HOST:PORT of incoming connections instead of just the host (MDEV-1282)
Added tls_version field for connection audit plugins (MDEV-33834)
Get option group suffix from $MARIADB_GROUP_SUFFIX in addition to $MYSQL_GROUP_SUFFIX (MDEV-21375)
Can set an alternative directory path for searching scripts invoked via the source command, with the mariadb client option (MDEV-23818)
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.
MariaDB 10.7 is a previous short-term maintenance stable series of MariaDB, maintained until February 2023. It is an evolution of MariaDB 10.6 with several entirely new features.
The server no longer tolerates incorrectly configured SSL (). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.
Assertion on info.page_size failed in xb_delta_open_matching_space ()
Adaptive hash index ,
MVCC and locking (, , , )
Virtual columns (, )
updated to 26.4.13
Galera server crashes after 10.3 > 10.4 upgrade ()
status variable prints 0 as port number if the port is not mentioned in system variable ()
XA COMMIT is not binlogged when the has not updated any transaction engine ()
Concurrent statements made to binlog without any mixup ()
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 .
MariaDB 11.0 is a current development series of MariaDB, and will be maintained for one year after its Generally Available release. It is an evolution of MariaDB 10.11 with several entirely new features.
MariaDB 11.0.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into .
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:10.11-preview.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
This is the main change that practically defines this release. Read about new optimizer cost model on its own page
Implement wsrep_provider_options as plugin
Add details about node eviction status to the JSON file with Galera node status
Remove the
Deprecate
Deprecate
Move mysql compatibility symlinks to different package
ad hoc client versions are confusing
Set by default
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 12.2.2 Release Notes
MariaDB 12.2.2 is a Stable (GA) release of MariaDB Community Server 12.2, released on 2026-02-12
Join optimizer is now able to infer that derived table with GROUP BY clause has distinct GROUP BY columns ()
: [NO_]ROWID_FILTER (),
: [NO_]INDEX_MERGE ()
: Implicit query block names ()
Remove depth limit of 32 from JSON functions ()
Add ()
Implement .PARAMETER_DEFAULT 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. ()
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 ()
Fixes for the following :
For a complete list of changes made in MariaDB 12.2.2, with links to detailed information on each push, see the .
MariaDB 10.8 is a previous short-term maintenance stable series of MariaDB, maintained until May 2023. It is an evolution of MariaDB 10.7 with several entirely new features.
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.
MDEV-29668 SUPER no longer allows actions that have fine-grained dedicated privileges
New optimizer cost model
Galera
Removing/Deprecating old code
Other changes
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.
InnoDB Temporary Tablespace (ibtmp1) is continuously growing (MDEV-28240)
Full text index corruption if shutdown before changes are fully flushed (MDEV-29342)
does not parse NULL properties properly (MDEV-27151)
InnoDB hangs on multiple concurrent requests of a cold ROW_FORMAT=COMPRESSED page (MDEV-27983)
Notable Items
Issues Fixed
Security
Changelog
Contributors
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.
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.
Re-design the upper level of handling UPDATE and DELETE statements ()
Deprecate the / functions ()
Available as container: quay.io/mariadb-foundation/mariadb-devel:10.10-misc
Do not use alpha releases on production systems!
For a complete list of changes made in MariaDB 10.10.0, with links to detailed information on each push, see the changelog.
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.
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.
Optimizer
Optimizer hints
Miscellaneous
Notable Items
Data Definition - Create Table
Plugin - Audit Log
Security
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.
MariaDB 10.7 is a previous short-term maintenance stable series of MariaDB, supported until February 2023. It is an evolution of MariaDB 10.6 with several entirely new features.
FULLTEXT search with apostrophe, and mandatory words ()
ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()
is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. ()
ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS ()
INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback ()
updated to 26.4.12
Possible to write/update with read_only=ON and not a SUPER privilege ()
Node crashes with Transport endpoint is not connected mysqld got signal 6 ()
Server crash in JOIN_CACHE::free or in copy_fields ()
Queries that use DISTINCT and an always-constant function like COLLATION(aggregate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not constant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause ()
MariaDB Server SEGV on INSERT .. SELECT ()
Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
Wrong result with table elimination combined with not_null_range_scan ()
If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.
and have been deprecated (, )
Spider's high-availability feature has been deprecated ()
: extract document fragment into JSON column ()
now supports with ()
now also has a session scope, not only global ()
New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.
Crash in ()
Fixes for the following :
For a complete list of changes made in , with links to detailed information on each push, see the .
MariaDB 10.8 is the current development series of MariaDB. It is an evolution of MariaDB 10.7 with several entirely new features.
MariaDB 10.8.0 is not a single release, but is instead a number of feature preview releases based on feature branches. Each should be considered as having a maturity of an release.
Read more about feature preview releases .
Thanks, and enjoy MariaDB!
Remember, these features are in separate preview packages. The subsection header text corresponds to the preview package name.
Stored procedures already have support for the parameter qualifiers. Added as well for and (IN only) (). This was a by .
Normally, gets fully executed on the primary first and only then it is and starts executing on replicas. With this feature ALTER TABLE gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes. This way the replication lag caused by a heavy ALTER TABLE can be completely eliminated ().
Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (, , , ).
autosize ().
Improve the for concurrency ().
For that are partitioned BY SYSTEM_TIME with the LIMIT or INTERVAL clause, that is, when the server automatically switches to the new history partition when the previous one becomes full, one can now use an AUTO keyword to tell the server to create more history partitions automatically as needed ().
Note that this feature was not included in .
Histograms in the statistics tables are more precise and stored as JSON, not binary (, , ).
This was mostly internal refactoring work. As a result one can now declare connections using the REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This works both for the whole table and per partition (, ).
Add an optional argument to the function, as well as the function, which uses the Castagnoli polynomial. (). Note: The order of the 2-ary arguments was swapped after the preview release: crc32('MariaDB')=crc32(crc32('Maria'),'DB')
Deprecate the variable ().
now handles --default-*
(or mysqlbinlog as it was called back when the task was created) now supports both filtering events by GTID ranges through --start-position and --stop-position, and validating a binary log's ordering of GTIDs through --gtid-strict-mode ().
On newer versions of Windows (Windows 10 1903 or later), the mariadb client defaults to the utf8mb4 character set. Several problems with Unicode input and output in client were fixed. Command line utilities now accept all Unicode characters in user names, database names, file names etc (in the past, characters were restricted to the current ANSI codepage).
Do not use alpha releases on production systems!
For a complete list of changes made in , with links to detailed information on each push, see the changelog.
Do not use alpha 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.
sequences related row-format events are made to correspond to binlog_row_image (MDEV-28487)
Possible reason of FLUSH BINARY LOGS hang is eliminated (MDEV-28948)
Fix out-of-order gtid error in the circular semisync setup (MDEV-28609)
Galera4 not able to report proper wsrep_incoming_addresses (MDEV-20627)
Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB (MDEV-27862)
Add support for OpenSSL 3.0 in Galera (MDEV-25949)
A query with a subuquery in this form could cause a crash:
Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.
Optimizer uses all partitions after upgrade to 10.3 (MDEV-28246)
For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.
Range optimizer regression for key IN (const, ....) (MDEV-25020)
The issue can be observed on MariaDB 10.5.9 and later versions which have the fix for MDEV-9750. That fix introduceds optimizer_max_sel_arg_weight.
If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:
ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade (MDEV-28727)
Server crash upon CREATE VIEW with unknown column in ON condition (MDEV-29088)
password_reuse_check plugin mixes username and password (MDEV-28838)
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
table.keyXpartY [NOT] IN ( ... )
Notable Items
InnoDB
Replication
Galera
Optimizer
Spider
JSON
CONNECT
General
Security
Changelog
Contributors
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.
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.
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.
ASAN errors in spider_db_free_result after partition DDL ()
Server crashes when calling spider UDF after aria_encrypt_tables is enabled ()
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 ()
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)
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 11.5 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 ()
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.
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.
The default has been changed from latin1 to utf8mb4 (MDEV-19123)
Added the --dir option to , allowing one to restore all tables from a backup directory created using (MDEV-33627)
Added the related --database, --ignore-database, --table and --ignore-table options.
Refactor threading
Automatic SST user account management ()
Improve selectivity computations for multi-part keys (MDEV-33697)
Single-table now support table aliases (MDEV-33988)
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.
The new system variable defines how many segments are used, default is 1, maximum 128
MDL scalability improvements ()
Asynchronous replication between two can now use parallel replication
This is managed by the new system variable ()
The now supports buffered logging
The size of the buffer is defined using the new system variable ()
Faster distance calculations via extrapolation ()
New authentication plugin for MySQL compatibility ()
()
Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY () ()
Retry applying of write sets on nodes ()
Controlled through the system variable
now supports with the -L or --wildcards
Fixes for the following :
For a complete list of changes made in MariaDB 12.1.2, with links to detailed information on each push, see the .
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.9.4 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 7 Nov 2022
is the current short-term maintenance stable series of MariaDB, maintained until August 2023. It is an evolution of with several entirely new features.
is a release.
For an overview ofsee thepage.
MariaDB 11.5.0 Release Notes
Release date: 18 March 2024
is an upcoming development series of MariaDB. It is an evolution of with several entirely new features.
is a single preview release. Features are to be considered preview, and none are guaranteed to make it into .
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.5-preview.
Thanks, and enjoy MariaDB!
will now by default issue a warning if the user has active sessions, or fail in Oracle mode (MDEV-35617)
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.
The server no longer tolerates incorrectly configured SSL (MDEV-29811). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.
Assertion on info.page_size failed in xb_delta_open_matching_space (MDEV-18589)
Galera server crashes after 10.3 > 10.4 upgrade (MDEV-29375)
status variable prints 0 as port number if the port is not mentioned in system variable (MDEV-28868)
XA COMMIT is not binlogged when the has not updated any transaction engine (MDEV-25616)
Concurrent statements made to binlog without any mixup (MDEV-25606)
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 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:
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 issue #469)
The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes issue #468).
Adds OCI labels to image (fixes and )
MariaDB config: skip-host-cache and skip-name-resolve moved to /etc/mysql/mariadb.conf.d/05-skipcache.cnf
Fixes for the following :
CVE--``#
For a complete list of changes made in MariaDB 10.9.4, with links to detailed information on each push, see the changelog.
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.
There are two system variables used for controlling this feature:
: Limits the temporary space allowance per user
: Limits the temporary space allowance for all users.
The range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (MDEV-32188).
is now supported for partitioned tables (MDEV-12404)
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 release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See MDEV-27789 for more details.Please use a later release.
Do not use non-stable (non-GA) releases in production!
MariaDB 10.8 is the current development series of MariaDB. It is an evolution of MariaDB 10.7 with several entirely new features.
is a release.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
does not disallow .isl file creation ()
Indexed columns are broken with NO_PAD ()
insert-intention lock conflicts with waiting ORDINARY lock ()
Support descending indexes in the range optimizer ()
updated to 26.4.11
Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory ()
Alter Sequence do not replicate to another nodes with in Galera Cluster ()
Seconds behind master corrected from artificial spikes at relay-log rotation ()
Statement rollback in binlog when transaction creates or drop temporary table is set right ()
CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to stabilize its parallel execution on slave ()
prohibition running two upgrades in parallel (, , )
script updated to version 2022-02-08, with the following fixes and enhancements:
Default location of the script has been moved to: (old location is deprecated, but still works)
Faster initialization by disabling binary logging during initialization ()
mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 ()
A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options ()
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!
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 11.7 Changes & Improvements
MariaDB 11.7 is no longer maintained. Please use a .
is a .
are now included in the binaries
Numerous improvements ()
Release Notes - MariaDB 11.5 Rolling Releases
MariaDB 11.5 was a rolling release, and is no longer maintained.
Fix deadlock caused by lock_rec_unlock_unmodified() (MDEV-34690)
Fix duplicate key error in table 'mysql.innodb_table_stats' (MDEV-34207)
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 INSERT...SELECT' on MyISAM table suddenly replicated by alera (MDEV-34647)
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)
Optimizer
Data Definition - Alter Table
Galera
Backup
JSON
General
Changelog
Contributors
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.
Support for RHEL and SLES aarch64 repositories added
New function added to verify that the MariaDB Server version, if specified on the command line, follows the correct naming and that a corresponding repository actually exists.
Fixed repository pinning for Ubuntu and Debian repositories
MariaDB Server 10.7 is now the default server version
mysql@localhost user is created with the environment variable MARIADB_MYSQL_LOCALHOST_USER=1 and additional grants (beyond USAGE) with MARIADB_MYSQL_LOCALHOST_GRANTS={global grant list} (MDEV-27732)
skip innodb buffer pool loads/dumps on temporary startup/shutdown for faster startup/initialization, and accurate "healthcheck.sh --innodb_buffer_pool_loaded"
change group ownership on datadir/socket dir (issue #401)
log note about note on Securing system users, mysql_secure_installation not required (reddit suggestion)
MariaDB names of executable programs and scripts used instead of historical mysql ones
Notable Items
InnoDB
Optimizer
Galera
Replication
Packaging & Misc
Docker Library
Changelog
Contributors
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.
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.
can now do most operations with ALGORITHM=COPY, LOCK=NONE, that is, in most cases, unless the algorithm and lock level are explicitly specified, ALTER TABLE will be performed using the algorithm while simultaneously allowing concurrent on the altered table.
For more information, refer to, .
The is now shrunk by reclaiming unused space at startup ()
now allows retrieval of the key when iterating on JSON objects ()
New functions , and to check for JSON intersection ()
extracts key/value pairs from a JSON object ()
All binlog* variables are now visible as system variables, specifically , , ()
enhancement ()
Temporary tables are now displayed in the , and ()
For a list of all new variables, see .
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
MariaDB 10.7 is a previous short-term maintenance stable series of MariaDB, supported until February 2023. It is an evolution of MariaDB 10.6 with several entirely new features.
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.
InnoDB Temporary Tablespace (ibtmp1) is continuously growing (MDEV-28240)
Full text index corruption if shutdown before changes are fully flushed (MDEV-29342)
does not parse NULL properties properly (MDEV-27151)
InnoDB hangs on multiple concurrent requests of a cold ROW_FORMAT=COMPRESSED page (MDEV-27983)
Notable Items
Issues Fixed
Security
Changelog
Contributors
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.
Stored procedures already have support for the parameter qualifiers. Added as well for and (IN only) (MDEV-10654). This was a contribution by ManoharKB.
Normally, gets fully executed on the primary first and only then it is and starts executing on replicas. With this feature ALTER TABLE gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes. This way the replication lag caused by a heavy ALTER TABLE can be completely eliminated (MDEV-11675).
Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (MDEV-13756, MDEV-26938, MDEV-26939, MDEV-26996).
Histograms in the statistics tables are more precise and stored as JSON, not binary (MDEV-21130, MDEV-26519, blog post).
This was mostly internal refactoring work. As a result one can now declare connections using the REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This works both for the whole table and per partition (MDEV-5271, MDEV-27106).
Add an optional argument to the function, as well as the function, which uses the Castagnoli polynomial. (MDEV-27208). Note: The order of the 2-ary arguments was swapped after the preview release: crc32('MariaDB')=crc32(crc32('Maria'),'DB')
now handles --default-* options in exactly the same way as other MariaDB tools ().
UCA are now notably faster (, ).
(or mysqlbinlog as it was called back when the task was created) now supports both filtering events by GTID ranges through --start-position and --stop-position, and validating a binary log's ordering of GTIDs through --gtid-strict-mode (MDEV-4989).
On newer versions of Windows (Windows 10 1903 or later), the mariadb client defaults to the utf8mb4 character set. Several problems with Unicode input and output in client were fixed. Command line utilities now accept all Unicode characters in user names, database names, file names etc (in the past, characters were restricted to the current ANSI codepage).
For a list of all new variables, see .
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
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.
There are two system variables used for controlling this feature:
: Limits the temporary space allowance per user
: Limits the temporary space allowance for all users.
The range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (MDEV-32188).
is now supported for partitioned tables (MDEV-12404)
ANALYZE for statement should show selectivity of pushed index condition (MDEV-18478)
Permit bulk implementation to return ALL individual results (MDEV-30366)
Send initial values of system variables in first OK packet (MDEV-31609)
New in the Information Schema for storing information about users, , and the limits set by (MDEV-23729, MDEV-32218)
Add more columns to Information Schema , and tables (MDEV-33151)
Add QUERIES column to Information Schema table (MDEV-33152)
Deprecate and ignore the system variable (MDEV-33655)
Change to uca1400_ai_ci, a modern Unicode collation with proper support for SMP characters (including emoji)(MDEV-25829)
Parallel dump of multiple databases via with the --dir option ()
Deprecate ()
The following deprecated features have been removed:
... COMPRESSED...
the correct syntax is COMPRESSED... ...
(and the related variable).
For a list of all new variables, see and .
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
Add listcve macro here - removed for performance reasons
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.
Semisync-slave server recovery is refined to correctly rollback prepared transaction ()
Circular semisync setup endless event circulation is handled ()
Semisync-slave server recovery is extended to work on new server_id server ()
Incorrect binlogs after Galera SST using rsync and ()
does not detect multi-source replication slave ()
Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage ()
Query performance degradation in newer MariaDB versions when using many tables ()
A SEGV in Item_field::used_tables/update_depend_map_for_order... ()
ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries ()
The following variables have been deprecated:
and ()
and ()
()
Server are ()
For RHEL/CentOS 7, non x86_64 architectures are no longer supported upstream and so our support will also be dropped with this release
Packages for Ubuntu 22.04 LTS "Jammy" and Fedora 36 are not yet available pending the resolution of : Backport OpenSSL-3.0 compatibility to 10.6 branch
Fixes for the following :
For a complete list of changes made in , with links to detailed information on each push, see the .
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.
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.
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 ()
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)
NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
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 11.1 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 ()
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.
Thanks, and enjoy MariaDB!
InnoDB corruption due to lack of file locking (MDEV-28495)
Possible to write/update with read_only=ON and not a SUPER privilege (MDEV-28546)
Node crashes with Transport endpoint is not connected mysqld got signal 6 (MDEV-25068)
Galera4 not able to report proper wsrep_incoming_addresses ()
Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB ()
Add support for OpenSSL 3.0 in Galera ()
Server crash in JOIN_CACHE::free or in copy_fields (MDEV-23809)
Queries that use DISTINCT and an always-constant function like COLLATION(aggregate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not constant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause (MDEV-29139)
A query with a subuquery in this form could cause a crash:
MariaDB Server SEGV on INSERT .. SELECT (MDEV-26427)
Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.
Optimizer uses all partitions after upgrade to 10.3 ()
For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.
Range optimizer regression for key IN (const, ....) ()
The issue can be observed on and later versions which have the fix for . That fix introduceds optimizer_max_sel_arg_weight.
If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:
Wrong result with table elimination combined with not_null_range_scan (MDEV-28858)
If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.
Assertion `tmp >= 0' failed in best_access_path (MDEV-28882)
If one uses histogram_type=JSON_HB, has collected a histogram of that type and runs a query that selects a very narrow range near histogram end, they can hit an assertion in the optimizer due to rounding errors in the histogram causing negative selectivity.
The version number now matches the server version (and the system variable removed) (MDEV-26282)
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
table.keyXpartY [NOT] IN ( ... )
Notable Items
InnoDB
Replication
Galera
Optimizer
Spider
JSON
CONNECT
General
Security
Changelog
Contributors
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.
Possible to write/update with read_only=ON and not a SUPER privilege (MDEV-28546)
Node crashes with Transport endpoint is not connected mysqld got signal 6 (MDEV-25068)
Galera4 not able to report proper wsrep_incoming_addresses ()
Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB ()
Add support for OpenSSL 3.0 in Galera ()
Implement a method to add IPs to allowlist for Galera Cluster node addresses that can make SST/IST requests ()
Server crash in JOIN_CACHE::free or in copy_fields (MDEV-23809)
Queries that use DISTINCT and an always-constant function like COLLATION(aggregate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not constant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause (MDEV-29139)
A query with a subuquery in this form could cause a crash:
MariaDB Server SEGV on INSERT .. SELECT (MDEV-26427)
Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.
Optimizer uses all partitions after upgrade to 10.3 ()
For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.
Range optimizer regression for key IN (const, ....) ()
The issue can be observed on and later versions which have the fix for . That fix introduceds optimizer_max_sel_arg_weight.
If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:
Wrong result with table elimination combined with not_null_range_scan (MDEV-28858)
If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.
Assertion `tmp >= 0' failed in best_access_path (MDEV-28882)
If one uses histogram_type=JSON_HB, has collected a histogram of that type and runs a query that selects a very narrow range near histogram end, they can hit an assertion in the optimizer due to rounding errors in the histogram causing negative selectivity.
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
table.keyXpartY [NOT] IN ( ... )
Notable Items
InnoDB
Replication
Galera
Optimizer
General
Security
Changelog
Contributors
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.
Thanks, and enjoy MariaDB!
Reduced scalability bottlenecks. Minimum size of increased from 1MB to 4MB to cater for rare error message. (MDEV-27774)
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.
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.
shows warning on missing directory $pamtooldir/auth_pam_tool_dir (MDEV-32142)
main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 ()
(mysql_install_db) doesn't properly grant to all default root user accounts ()
main.events_stress or events.events_stress fails with view-protocol (MDEV-31455)
main.delete_use_source fails (hangs) with view-protocol (MDEV-31457)
main.sum_distinct-big and main.merge-big fail with timeout with view-protocol (MDEV-31465)
main.secure_file_priv_win fails with 2nd execution PS protocol ()
Windows : mtr output on is messed up with large MTR_PARALLEL ()
main.mysql_client_test_comp failed in buildbot, error on exec ()
main.order_by_pack_big fails with view-protocol ()
mysql_install_db_win.test fails on second execution ()
mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 (MDEV-18200)
mbstream breaks page compression on XFS (MDEV-25734)
Prefix keys for CHAR work differently for MyISAM vs InnoDB (MDEV-30048)
Inconsistent results of DISTINCT with NOPAD (MDEV-30050)
Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT (MDEV-28835)
Compressed varchar values lost on joins when sorting on columns from joined table(s) ()
UBSAN shift exponent X is too large for 64-bit type 'long long int' in sql/field.cc ()
Wrong bit encoding using COALESCE ()
Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims (MDEV-31117)
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 (MDEV-31996)
ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler (MDEV-28998)
ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 ()
Server crashes in check_sequence_fields upon CREATE TABLE .. SEQUENCE=1 AS SELECT .. ()
slow log Rows_examined out of range ()
"rpm --setugids" breaks PAM authentication ()
incorrect examined rows in case of stored function usage ()
Compilation failing on MacOS (unknown warning option -Wno-unused-but-set-variable) ()
Server crash upon inserting into Mroonga table with compressed column ()
hash unique corrupts index on virtual blobs ()
insert into an empty table fails with hash unique ()
Valgrind/MSAN warnings in dynamic_column_update_move_left ()
Memory leak showed in test suite ()
Test from subselect.test fails with statement memory protection ()
Memory leak when executing PS for query with IN subquery ()
Allow the setting of Auto_increment on FK referenced columns ()
mariadb-upgrade fails with sql_safe_updates = on ()
Assertion `!(thd->server_status & (1U | 8192U))' failed in MDL_context::release_transactional_locks ()
Information schema leaks table names and structure to unauthorized users ()
Missing CHACHA20-POLY1305 support in WolfSSL ()
incorrect error about cyclic reference about JSON type virtual column ()
Disable TLS v1.0 and 1.1 for MariaDB ()
Better indication of refusing to start because of ProtectHome ()
Database upgrade fails: slow_log table ()
myrocks_hotbackup.1 and test suite files installed when engine is disabled ()
client_ed25519.dll isn't included for HeidiSQL. ()
Assertion `!m_null_value' failed in int FixedBinTypeBundle::cmp_item_fbt::compare or in cmp_item_inet6::compare ()
type_test.type_test_double fails with 'NUMERIC_SCALE NULL' ()
LeakSanitizer errors in get_quick_select or Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed ()
Update signal handler user info more compassion and correct url ()
maria-install-db fails on MacOS ()
MSAN / Valgrind errors in Item_func_like::get_mm_leaf upon query from partitioned table ()
MSAN / Valgrind errors in Item_func_like::get_mm_leaf with temporal field ()
ASAN errors in base_list_iterator::next / setup_table_map upon 2nd execution of PS ()
safe_mutex: Found wrong usage of mutex 'LOCK_thd_data' and 'wait_mutex' ()
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 MariaDB Backup -
Refactor docker_mariadb_init in the entrypoint for extending the MariaDB image
CIS failure due to world-writable directory /var/run/mysqld, added sticky bit - reported by @ollie1
Add for root@MARIADB_ROOT_HOST - reported by Matthieu Gusmini
added --galera_online test, to match what the does.
Added the system variable to manage [notes when an index cannot be used](https://mariadb.com/docs/general-resources/development-articles/mariadb-internals/mariadb-internals-documentation-query-optimizer/notes-when-an-index-cannot-be-used
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.
280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode ()
SQL/PL package body does not appear in ()
Unexpected result when combining , subselect and ()
UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op ()
Assorted assertion failures in json_find_path with certain collations ()
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.
Thanks, and enjoy MariaDB!
MariaDB now detects and converts previously incompatible MySQL partition schemes (MDEV-29253)
280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode ()
SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION ()
Unexpected result when combining , subselect and ()
variables do not get assigned from subselects ()
Crash after setting global session_track_system_variables to an invalid value ()
ODKU of non-versioning column inserts history row ()
UPDATE not working properly on transaction precise system versioned table ()
UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op ()
Assorted assertion failures in json_find_path with certain collations ()
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.
Performance regression in fil_space_t::try_to_close() introduced in ()
InnoDB recovery hangs when buffer pool ran out of memory ()
InnoDB undo log truncation fails to wait for purge of history (
MariaDB crash due to DB_FAIL reported for a corrupted page ()
Deadlock between INSERT and InnoDB non-persistent statistics update ()
InnoDB hang on B-tree split or merge ()
Performance regression in locking reads from secondary indexes ()
Improve adaptive flushing ()
Make page flushing even faster ()
Purge misses a chance to free not-yet-reused undo pages ()
InnoDB temporary tablespace: reclaiming of free space does not work ()
Deadlock between CHECK TABLE and bulk insert ()
returns an empty string for U+0251 in uca1400 collations for utf8 ()
Fix miscount of doublewrites by ()
mariadb-backup doesn't utilise innodb-undo-log-directory (if specified as a relative path) during copy-back operation (MDEV-28187)
mariadb-backup issues error messages during InnoDB tablespaces export on partial backup preparing (MDEV-29050)
mariadb-backup does not copy Aria logs if aria_log_dir_path is used (MDEV-30968)
Race condition between buffer pool flush and log file deletion in mariadb-backup --prepare ()
Fixed a deadlock on parallel slave involving full image Write event on the sequence engine (MDEV-29621)
Fixed an attempted out-of-order binlogging error on slave involving ALTER on the sequence engine (MDEV-31077)
Corrected non-versioned master to versioned slave replication on no-unique attribute table (MDEV-30430)
Mended encrypted binlog master to error out to gtid-mode slave when master could not decrypt a binlog file ()
Refined optimistic parallel slave to error-exit without any hang ()
Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always initialized ()
Fixed the slave applier to report a correct error when gtid_slave_pos insert fails for some (engine) reasons ()
Made parallel slave reports in performance schema consistent with that of show-slave-status ()
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 (MDEV-26301).
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. (MDEV-30812)
Queries using SELECT DISTINCT some_expression(aggregate_function()) could produce wrong query result. (MDEV-20057)
now prints more information about : block-nl-join element now has r_loops, r_effective_rows and r_other_time_ms fields (, , ).
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 ()
EXPLAIN could erroneously report that is used for partitioned tables. Partitioned tables do not support it. ()
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 ().
Add replication setup to containers contributed by Md Sahil (MDEV-29762)
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.
Extend to support authentication_string (MDEV-33479)
New definition for Seconds_Behind_Master (MDEV-33856)
Added three variables to
New
Set thread names for MariaDB Server threads (MDEV-32537)
For a list of all new variables, see and .
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
Add listcve macro here - removed for performance reasons
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.
Remove the global sequence DICT_HDR_ROW_ID for DB_ROW_ID ()
Remove the ()
Deprecate ()
Fixes for cluster wide write conflict resolving ()
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE ()
Seconds_Behind_Master is showed now more precisely at the slave applier start, including in the delayed mode ()
is made to show the type of compressed columns ()
11.0, unlike previous version, no longer includes mysql named compatible executable symlinks inside the container.
mysql compatible symlinks are no longer installed in core package, but are delegated to a -compat package ()
Use of mysql named executables (except for Windows) will result in a deprecation warning ()
Infinite sequence of recursive calls when processing embedded ()
Crash with a query containing nested WINDOW clauses ()
Json Range only affects first row of the result set ()
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!
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.10.7 Release Notes
Release date: 13 Nov 2023
is a previous short-term maintenance stable series of MariaDB, November 2023. It is an evolution of with several entirely new features.
is a release.
is the last release of the release series.
MariaDB 11.2.5 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 8 Aug 2024
is a current short-term stable series of MariaDB and will be October 2024. It is an evolution of with several entirely new features.
is a release.
For an overview ofsee the
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. (MDEV-32050)
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.
InnoDB fails to start on innodb_undo_tablespaces mismatch (MDEV-30158)
mariadb-backup.skip_innodb crashes when innodb_undo_tablespaces > 0 (MDEV-30122)
Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA (MDEV-30423)
In this release repositories for Fedora 37 and Ubuntu 22.10 Kinetic have been added.
Notable Items
InnoDB
Galera
Replication
Docker Official Images
Packaging
General
Security
Changelog
Contributors
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.
shows warning on missing directory $pamtooldir/auth_pam_tool_dir (MDEV-32142)
main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 ()
(mysql_install_db) doesn't properly grant to all default root user accounts ()
main.events_stress or events.events_stress fails with view-protocol (MDEV-31455)
main.delete_use_source fails (hangs) with view-protocol (MDEV-31457)
main.sum_distinct-big and main.merge-big fail with timeout with view-protocol (MDEV-31465)
main.secure_file_priv_win fails with 2nd execution PS protocol ()
Windows : mtr output on is messed up with large MTR_PARALLEL ()
main.mysql_client_test_comp failed in buildbot, error on exec ()
main.order_by_pack_big fails with view-protocol ()
mysql_install_db_win.test fails on second execution ()
mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 (MDEV-18200)
mbstream breaks page compression on XFS (MDEV-25734)
Prefix keys for CHAR work differently for MyISAM vs InnoDB (MDEV-30048)
Inconsistent results of DISTINCT with NOPAD (MDEV-30050)
Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT (MDEV-28835)
Compressed varchar values lost on joins when sorting on columns from joined table(s) ()
UBSAN shift exponent X is too large for 64-bit type 'long long int' in sql/field.cc ()
Wrong bit encoding using COALESCE ()
Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims (MDEV-31117)
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 (MDEV-31996)
ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler (MDEV-28998)
ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 ()
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.
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 ()
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)
NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
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 11.2 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 ()
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.
Implement SHA2 support for file_key_management.so plugin (TDE) ()
Comparison ROW(stored_func(),1)=ROW(1,1) erroneously called stored_func() twice per row. It led to a performance degradation, as well as to a double execution of the possible stored function side effects. ()
Add support for the pre-defined weak SYS_REFCURSOR ()
TO_CHAR FM format not recognized in SQL_MODE=Oracle ()
Support mariadb-check and CHECK TABLE with SEQUENCE ()
find_order_in_list mismatch when order item needs fixing() ()
If the join_condition is specified via USING (column_list), the query plan depends on the sequence of tables in the query ()
Add support for optimizer hints ()
New GIS functions. These functions improve compatibility with MySQL 8.
()
()
()
Add support for TRIGGERS that fire on multiple events ()
Server now displays if it was started with option ()
Skip FK checks in Galera during applying in IST ()
Log HOST:PORT of incoming connection instead of just the host ()
Add tls_version field for connection audit plugins ()
Get option group suffix from $MARIADB_GROUP_SUFFIX in addition to $MYSQL_GROUP_SUFFIX ()
Can set an alternative directory path for searching scripts invoked via the source command, with the --script-dir mariadb client option ()
For a complete list of changes made in MariaDB 12.0.1, with links to detailed information on each push, see the .
For a full list of contributors to MariaDB 12.0.1, see the .
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.9.8 Release Notes
| | |
Release date: 14 Aug 2023
is a previous short-term stable series of MariaDB, August 2023. It is an evolution of with several entirely new features.
is a release.
is the last release of the release series.
MariaDB 10.9.5 Release Notes
| | |
Release date: 6 Feb 2023
is the current short-term maintenance stable series of MariaDB, maintained until August 2023. It is an evolution of with several entirely new features.
is a release.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
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. (MDEV-32050)
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.
280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode (MDEV-26186)
SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION ()
Unexpected result when combining , subselect and ()
variables do not get assigned from subselects ()
Crash after setting global session_track_system_variables to an invalid value ()
ODKU of non-versioning column inserts history row ()
UPDATE not working properly on transaction precise system versioned table ()
ANALYZE doesn't work with pushed derived tables ()
get_partition_set is never executed in ha_partition::multi_range_key_create_key due to bitwise & with 0 constant ()
Client can crash the server with a mysql_list_fields("view") call ()
I_S.parameters not immediately changed updated after procedure change ()
bzero wipes more bytes than necessary in set_global_from_ddl_log_entry ()
Assertion ``0'failed inType_handler_row::field_typeuponTO_CHAR` with wrong argument ()
mysql_upgrade fails due to old_mode="", with "Cannot load from mysql.proc. The table is probably corrupted" ()
version >= 6 are now stored without byte-swapping, UUIDs with version >=8 and variant=0 are now considered invalid, old tables are supported, old (always byte swapped) and new (swapped for version < 6) UUIDs can be compared and converted transparently (MDEV-29959)
UBSAN: null pointer passed as argument 1, which is declared to never be null in my_strnncoll_binary on SELECT ... COUNT or GROUP_CONCAT (MDEV-28384)
Possibly wrong result or Assertion 0' failed in Item_func_round::native_op` ()
UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op ()
Assorted assertion failures in json_find_path with certain collations ()
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.
As mentioned in the 10.9.4 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.
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.
The server no longer tolerates incorrectly configured SSL (). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.
Assertion on info.page_size failed in xb_delta_open_matching_space ()
locks database for minutes ()
Adaptive hash index ,
MVCC and locking (, , , )
Virtual columns (, )
updated to 26.4.13
Galera server crashes after 10.3 > 10.4 upgrade ()
status variable prints 0 as port number if the port is not mentioned in system variable ()
Minor correction in warning message ()
False replication error-stop of from a non-existing user on primary () in combination with a filtering replica is corrected
replication is mended on a replica that filters system tables ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 11.5.1 Release Notes
Release date: 30 May 2024
is a development version of the MariaDB rolling release. It is an evolution of with several entirely new features.
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.
There are two system variables used for controlling this feature:
: Limits the temporary space allowance per user.
: Limits the temporary space allowance for all users.
The range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (MDEV-32188).
is now supported for partitioned tables (MDEV-12404)
Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) (MDEV-33515)
Deprecate and ignore the system variable (MDEV-33655)
Change default Unicode collation to uca1400_ai_ci ()
Parallel dump of multiple databases via with the --dir option ()
Deprecate ()
Fixes for the following :
CVE-`-```
For a complete list of changes made in MariaDB 11.5.1, with links to detailed information on each push, see the changelog.
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.
MariaDB 11.1 is a current short-term stable series of MariaDB and will be maintained until August 2024. It is an evolution of MariaDB 11.0 with several entirely new features.
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. now performs its work across all five phases instead of doing almost all of it while holding BLOCK_COMMIT, which substantially shortens the window in which commits are blocked, 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 .
update case insensitive (large) unique key with insensitive change of value - duplicate key (MDEV-29345)
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)
Notable Items
Storage Engines
InnoDB
Backup
,
JSON
Encryption, TLS, SSL
Optimization & Tuning
Plugins
Replication
Galera
SQL, Data Definition, and Data Manipulation
Platforms & Packaging
General
Scripts & Clients
Server
Security
Changelog
Contributors
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.
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.
Windows packages were delayed but have now been added to the downloads site
Unique hash key on column prefix is computed incorrectly (MDEV-29954)
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 (MDEV-28613)
Assertion ``0'failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search ()
Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table ()
Crash emitting "Unsupported meta-data version number" error message ()
LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED ()
Inplace alter rebuild increases file size ()
BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY ()
GNU libc posix_fallocate() may be extremely slow ()
InnoDB wrong error message ()
Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 ()
InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe ()
InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty ()
innodb_fast_shutdown=0 hang after incomplete startup ()
innodb_undo_log_truncate=ON prevents fast shutdown ()
Adaptive flush recommendation ignores dirty ratio and checkpoint age ()
gcol.gcol_purge contaminates further execution of innodb.gap_locks ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Adaptive flushing is still not getting invoked in 10.5.11 ()
History list is not shrunk unless there is a pause in the workload ()
path separator near ib_buffer_pool incorrect ()
Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption ()
Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON ()
If tables are frequently created, renamed, dropped, a backup cannot be restored ()
on table to be accessible to those with privileges ()
Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE (MDEV-24541)
JSON_VALID fail to validate integer zero in scientific notation (MDEV-32587)
ASAN errors in Item_func_json_contains_path::val_int upon PS execution ()
mysql_json cannot be used on newly created table ()
Problems with a stored function EMPTY() on upgrade to 10.6 ()
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 (MDEV-29421)
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES (MDEV-29963)
ASANheap-use-after-free in spider_link_get_key on LOCK TABLES ()
Crash when lateral derived is guaranteed to return no rows ()
Bogus error executing PS for query using CTE with renaming of columns ()
Spider: Valid LEFT JOIN results in ERROR 1064 ()
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()
Spider tests failing in asan/valgrind builds ()
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()
Syntax error upon query with subquery from Spider table ()
Spider doesn't recognize semi JOIN ()
MariaDB, SPIDER engine, usage of REGEXP ()
Spider: variable spider_same_server_link not functioning correctly ()
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()
Spider spawns unnecessarily many system threads for stats synchronization ()
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 ()
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()
ASAN errors in spider_conn_queue_and_merge_loop_check ()
Crash caused by multi-table UPDATE over derived with hanging CTE (MDEV-28615)
Crash on query using CTE with the same name as a base table (MDEV-31657)
Crash with query using constant subquery as left part of IN subquery (MDEV-29362)
Incorrect result interceptor passed to mysql_explain_union() ()
Add variable to influence how costs for secondary keys are calculated. ()
INSERT ... SELECT Does not produce an optimizer trace ()
Unusable key notes do not get reported for some operations ()
Unusable key notes report wrong predicates for > and >= ()
ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note (MDEV-32795)
Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY (MDEV-22230)
FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure ()
Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types ()
The can optionally (when is enabled) include the thread ID and database / table in its log (MDEV-27087). NULL is displayed if there is no database (MDEV-32906)
is now dynamic, and contains new options, and old options have been deprecated (MDEV-32884)
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.
Upgrade to 12.6.
Using two temporary tables in OPTIMIZE TABLE lead to crash ()
REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode ()
CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" ()
Failure when executing PS for query using IN subquery ()
Potential memory leak on executing of create view statement ()
Assertion failures ()
Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES ()
Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds ()
Set TaskMax=infinity in the MariaDB systemd unit ()
Unreliable autocommit flag on connection creation ()
A connection can control RAND() in following connection ()
THD::rli_fake/rgi_fake not cleared on new connection ()
Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> ()
Server crash in find_field_in_table ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Failure to call SP invoking another SP with parameter requiring type conversion ()
The database part is not case sensitive in SP names ()
EXCHANGE PARTITION with non-matching vcol expression segfault ()
Wrong user in SET DEFAULT ROLE error ()
quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') ()
mysql.slow_log reports incorrect start time ()
Update federated table and column privileges ()
Disable transparent huge pages after page buffers have been allocated ()
Deprecate ()
sys schema view session_ssl_status is empty ()
Memory pressure ()
Fixes for the following :
For a complete list of changes made in MariaDB 11.2.3, with links to detailed information on each push, see the changelog.
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.
shows warning on missing directory $pamtooldir/auth_pam_tool_dir (MDEV-32142)
main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 ()
(mysql_install_db) doesn't properly grant to all default root user accounts ()
main.events_stress or events.events_stress fails with view-protocol (MDEV-31455)
main.delete_use_source fails (hangs) with view-protocol (MDEV-31457)
main.sum_distinct-big and main.merge-big fail with timeout with view-protocol (MDEV-31465)
main.secure_file_priv_win fails with 2nd execution PS protocol ()
Windows : mtr output on is messed up with large MTR_PARALLEL ()
main.mysql_client_test_comp failed in buildbot, error on exec ()
main.order_by_pack_big fails with view-protocol ()
mysql_install_db_win.test fails on second execution ()
mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 (MDEV-18200)
mbstream breaks page compression on XFS (MDEV-25734)
Prefix keys for CHAR work differently for MyISAM vs InnoDB (MDEV-30048)
Inconsistent results of DISTINCT with NOPAD (MDEV-30050)
Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT (MDEV-28835)
Compressed varchar values lost on joins when sorting on columns from joined table(s) ()
UBSAN shift exponent X is too large for 64-bit type 'long long int' in sql/field.cc ()
Wrong bit encoding using COALESCE ()
Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims (MDEV-31117)
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 (MDEV-31996)
ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler (MDEV-28998)
ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 ()
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.
MariaDB 11.2 is a current short-term stable series of MariaDB, maintained until November 2024. It is an evolution of MariaDB 11.1 with several entirely new features.
wsrep_sst_mariadb-backup not working on FreeBSD ()
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 ()
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 ()
Added database level privilege ()
option breaks importing sql dumps ()
Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 ()
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!
This page is licensed: CC BY-SA / Gnu FDL
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. (MDEV-32050)
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)
Wrong result of: WHERE inet6_column IN ('','::1') (MDEV-31719)
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)
Raise notes when an index cannot be used on data type mismatch (MDEV-32203)
Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE (MDEV-31792)
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)
utf8mb3_key_col=utf8mb4_value cannot be used for ref access (MDEV-32113)
ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 (MDEV-29502)
Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT (MDEV-17711)
main.mysqlcheck fails on ARM with ASAN use-after-poison in my_mb_wc_filename (MDEV-26494)
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.
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)
Wrong result of: WHERE inet6_column IN ('','::1') (MDEV-31719)
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)
Raise notes when an index cannot be used on data type mismatch (MDEV-32203)
Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE (MDEV-31792)
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)
utf8mb3_key_col=utf8mb4_value cannot be used for ref access (MDEV-32113)
ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 (MDEV-29502)
getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO (MDEV-32275)
Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT (MDEV-17711)
main.mysqlcheck fails on ARM with ASAN use-after-poison in my_mb_wc_filename (MDEV-26494)
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.
is a current short-term stable series of MariaDB and will be June 2024. It is an evolution of with several entirely new features.
is a release.
For an overview ofsee thepage.
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 (MDEV-29954)
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 (MDEV-28613)
Assertion ``0'failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search ()
Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table ()
Crash emitting "Unsupported meta-data version number" error message ()
LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED ()
Inplace alter rebuild increases file size ()
BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY ()
GNU libc posix_fallocate() may be extremely slow ()
InnoDB wrong error message ()
Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 ()
InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe ()
InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty ()
innodb_fast_shutdown=0 hang after incomplete startup ()
innodb_undo_log_truncate=ON prevents fast shutdown ()
Adaptive flush recommendation ignores dirty ratio and checkpoint age ()
gcol.gcol_purge contaminates further execution of innodb.gap_locks ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Adaptive flushing is still not getting invoked in 10.5.11 ()
History list is not shrunk unless there is a pause in the workload ()
path separator near ib_buffer_pool incorrect ()
Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption ()
Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON ()
If tables are frequently created, renamed, dropped, a backup cannot be restored ()
on table to be accessible to those with privileges ()
Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE (MDEV-24541)
JSON_VALID fail to validate integer zero in scientific notation (MDEV-32587)
ASAN errors in Item_func_json_contains_path::val_int upon PS execution ()
mysql_json cannot be used on newly created table ()
Problems with a stored function EMPTY() on upgrade to 10.6 ()
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 (MDEV-29421)
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES (MDEV-29963)
ASANheap-use-after-free in spider_link_get_key on LOCK TABLES ()
Crash when lateral derived is guaranteed to return no rows ()
Bogus error executing PS for query using CTE with renaming of columns ()
Spider: Valid LEFT JOIN results in ERROR 1064 ()
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()
Spider tests failing in asan/valgrind builds ()
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()
Syntax error upon query with subquery from Spider table ()
Spider doesn't recognize semi JOIN ()
MariaDB, SPIDER engine, usage of REGEXP ()
Spider: variable spider_same_server_link not functioning correctly ()
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()
Spider spawns unnecessarily many system threads for stats synchronization ()
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 ()
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()
ASAN errors in spider_conn_queue_and_merge_loop_check ()
Crash caused by multi-table UPDATE over derived with hanging CTE (MDEV-28615)
Crash on query using CTE with the same name as a base table (MDEV-31657)
Crash with query using constant subquery as left part of IN subquery (MDEV-29362)
Incorrect result interceptor passed to mysql_explain_union() ()
INSERT ... SELECT Does not produce an optimizer trace ()
Add variable to influence how costs for secondary keys are calculated. ()
Unusable key notes do not get reported for some operations ()
Unusable key notes report wrong predicates for > and >= ()
ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note (MDEV-32795)
Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY (MDEV-22230)
FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure ()
Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types ()
The can optionally (when is enabled) include the thread ID and database / table in its log (MDEV-27087). NULL is displayed if there is no database (MDEV-32906)
is now dynamic, and contains new options, and old options have been deprecated (MDEV-32884)
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.
Upgrade to 12.6.
Using two temporary tables in OPTIMIZE TABLE lead to crash ()
REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode ()
CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" ()
Failure when executing PS for query using IN subquery ()
Potential memory leak on executing of create view statement ()
Assertion failures ()
Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES ()
Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds ()
Set TaskMax=infinity in the MariaDB systemd unit ()
Unreliable autocommit flag on connection creation ()
A connection can control RAND() in following connection ()
THD::rli_fake/rgi_fake not cleared on new connection ()
Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> ()
Server crash in find_field_in_table ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Failure to call SP invoking another SP with parameter requiring type conversion ()
The database part is not case sensitive in SP names ()
EXCHANGE PARTITION with non-matching vcol expression segfault ()
Wrong user in SET DEFAULT ROLE error ()
quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') ()
mysql.slow_log reports incorrect start time ()
Update federated table and column privileges ()
Disable transparent huge pages after page buffers have been allocated ()
Deprecate ()
sys schema view session_ssl_status is empty ()
Memory pressure ()
Fixes for the following :
CVE-`-```
For a complete list of changes made in MariaDB 11.0.5, with links to detailed information on each push, see the changelog.
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.
MariaDB 11.0 is a current short-term stable series of MariaDB and will be maintained until June 2024. It is an evolution of MariaDB 10.11 with several entirely new features.
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. now performs its work across all five phases instead of doing almost all of it while holding BLOCK_COMMIT, which substantially shortens the window in which commits are blocked, 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 .
This page is licensed: CC BY-SA / Gnu FDL
Server no longer aborts while altering an InnoDB statistics table (MDEV-33462)
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)
update case insensitive (large) unique key with insensitive change of value - duplicate key (MDEV-29345)
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)
Notable Items
Storage Engines
InnoDB
Backup
,
JSON
Encryption, TLS, SSL
Optimization & Tuning
Plugins
Replication
Galera
SQL, Data Definition, and Data Manipulation
Platforms & Packaging
General
Scripts & Clients
Server
Security
Changelog
Contributors
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.
Fix possible InnoDB hang while running out of buffer pool ()
Fix assertion failure on cascading foreign key update of table with vcol index in parent ()
Fix potential issue in secondary Index with ROW_FORMAT=COMPRESSED and Change buffering enabled ()
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 ()
Fix possible Spider thread hang in 'Update' state on 2nd INSERT ()
Fix possible crash on bootup in spider_sys_open_table «ext-issue»«», «ext-issue»«» ()
44 new added. These are aliases for MySQL collations to make it easier to replicate from MySQL to MariaDB ()
The includes a new column, COMMENT which contains information about which collation the alias refers to.
Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys ()
Fix incorrect formatting of timestamp during parsing of a binary log, causing point in time recovery discrepancies ()
can now correctly process more than one logfile when --stop-datetime is specified ()
Setting pseudo_thread_id to a value exceeding 4 bytes previously resulted in truncation when written to the binary log ()
Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY ()
Fix failing assertion causing disruption and replication failure ()
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 ()
History is now stored on the same partitions on different Galera nodes when system versioning is enabled ()
Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE ()
EXCHANGE PARTITION now works for tables with unique blobs ()
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 ()
For an authentication with the the password of the CREATE USER statement is now masked in the audit log ()
MariaDB Audit now detects all DCLs forms for masking a password ()
Adding a regular index on a vector column leads to invalid table structure ()
Vector values become zero after / restore, impacting data integrity for vector columns. ()
Server can crash when a SELECT query is including a DISTINCT and ORDER BY, and a vector index is used ()
Fix possible crash where server could not construct a geometry object from the input ()
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 ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 11.2.4 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 16 May 2024
is a current short-term stable series of MariaDB and will be October 2024. It is an evolution of with several entirely new features.
is a release.
For an overview ofsee the
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 (MDEV-29968)
MariaDB now supports MySQL 8.0 binlog events, including PARTIAL_UPDATE_ROWS_EVENT, TRANSACTION_PAYLOAD_EVENT, and HEARTBEAT_LOG_EVENT_V2. (MDEV-35643)
no longer ignores binary log events written with system timestamp 4294967295 and possibly all following events, avoiding potential data loss during recovery from binlogs (MDEV-33239)
Table flags, preserved from the old storage engine after changing the storage engine of a table, can no longer break replication (MDEV-31794)
Fix issue where / ALL REPLICAS errors without returning an error if the command could be executed due to wrong privileges. (MDEV-21858)
NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures (MDEV-34665)
Fix possibly wrong result using a degenerated subquery (SELECT ) with window function (MDEV-35869)
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 the error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY". (MDEV-34813)
Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled (MDEV-35465)
Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory (MDEV-35387)
Fix cluster node hang during shutdown if threadpool is used (MDEV-35710)
MariaDB Cluster and ALTER INPLACE running in Total Order Isolation (wsrep_OSU_method=TOI) now correctly abort a DML INSERT operation in InnoDB (MDEV-33064)
Fix possible crash in wsrep_check_sequence (MDEV-33245)
Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction (MDEV-35446)
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 (MDEV-34924)
Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node. (MDEV-35852)
Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently. (MDEV-35018)
Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+ (MDEV-35505)
Fix possible crash in wsrep_sst_mariadb-backup script when upgrading node in cluster from 10.11.9 to 10.11.10. (MDEV-35526)
wsrep_sst_mariadb-backup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours (MDEV-35749)
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 (MDEV-33783)
Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED (MDEV-35571)
Fix possible crash during index traversal using tree_search_next. (MDEV-28130)
FIx assertion failure where CURRENT_USER was not correctly copied during condition pushdown
(MDEV-35090)
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 (MDEV-35335)
sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers (MDEV-35651)
The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error (MDEV-20281)
Fix doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages (MDEV-34898)
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 (MDEV-33658)
During an online table rebuild of an InnoDB statistics table, opt_search_plan_for_table() no longer sometimes degrades to full table scan (MDEV-35443)
Fix debian-start script failure when using non-standard socket path (MDEV-35907)
Fix possible hang or crash where zero offset applied to null pointer (MDEV-35864)
Fixed issue where ST_PointFromWKB ignored SRID parameter and returned 0 (MDEV-32619)
Fix possible hang during CREATE TABLE…SELECT error handling, especially with innodb_snapshot_isolation enabled (MDEV-35647)
Fix incorrect locking order of LOCK_log/LOCK_commit_ordered and LOCK_global_system_variables (MDEV-29744)
Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy (MDEV-35157)
Fix possible memory leak while shutting down server after installing the auth_gssapi plugin (MDEV-35575)
Fix possible server crash when using INSERT DELAYED on tables with virtual columns. (MDEV-26891)
Fix possible Spider crash or hang when the first byte of a connection key is changed (MDEV-34849)
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 (MDEV-19761)
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. (MDEV-24935)
Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy (MDEV-35157)
Comparison of UUID v1 and V6 could return incorrect results (MDEV-35468)
INSERT SELECT on NOT NULL columns with BEFORE UPDATE trigger can fail with error 1048 (23000) (MDEV-36026)
It was not possible to use a package body variable as a fetch target, instead error "Undeclared variable" was returned. (MDEV-36047)
Validation of SSL certificate fails for mariadb-backup. For a MariaDB Cluster (Galera) SST operations can be affected (MDEV-35368)
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.
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) (MDEV-33515)
Fix InnoDB holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL (MDEV-32899)
Fix adaptive hash index corruption after (MDEV-33400)
Server no longer aborts while altering an InnoDB statistics table ()
Fix LeakSanitizer errors in rec_copy_prefix_to_buf ()
Fix InnoDB fatal error: Clustered record field for column x not found ()
Fix InnoDB hang when temporarily running out of buffer pool ()
Fix alter operation hang when encryption thread works on the same tablespace ()
Fix discard/import tablespace, restart, index corruption ()
Fix server hang on DROP INDEX or RENAME INDEX ()
Fix mariadb-backup --backup hang ()
Fix server hang caused by InnoDB change buffer ()
Fix assertion failures upon adding a too long key to table with COMPRESSED row format ()
IMPORT TABLESPACE no longer fails with column count or index count mismatch ()
Fix alter table corruption while applying the modification log ()
Fix inconsistent behaviors of UPDATE under RU & RC isolation level ()
Fix weird SELECT view when a record is modified to the same value by two transactions ()
Fix inconsistent read and write, which use the same predicate (WHERE clause) ()
Fix inconsistent SELECT view when modifying a record added by another transaction ()
Fix weird read view after ROLLBACK of other transactions ()
Read only server no longer throws error when running a create temporary table as select statement ()
Change buffer index no longer fails to delete the records ()
Fix InnoDB include OS error information when failing to write to iblogfile0 ()
Fix phantom rows caused by UPDATE of PRIMARY KEY ()
New system variable,
In-place migration from MySQL 5.7 no longer causes invalid AUTO_INCREMENT values ()
Fix InnoDB log corruption before upgrading it on startup ()
Table no longer gets rebuilt with ALTER TABLE ADD COLUMN ()
Fixed that internal temporary tables did not wait for freed disk space, and related issues (MDEV-33813)
Fix wrong result on 2nd execution of prepared statement for query with derived table (MDEV-31361)
Improve Spider performance by pushing down function (MDEV-28992) and statement (MDEV-28993) to data nodes
Fix server crash when deleting partitions from a table with spider engine (MDEV-33731)
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 (MDEV-33242)
Fix spider plugin init failure with no_zero_date sql_mode ()
Fix sql plugin init failure with traditional sql_mode ()
Fix parsing failure on valid left join select by translating the on expression to () ()
Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using local and remote ()
Fix bug where were not available if Spider was loaded upon server startup ()
Port backup features from Enterprise Server. now performs its work across all five phases instead of doing almost all of it while holding BLOCK_COMMIT, which substantially shortens the window in which commits are blocked, and obsoletes the and options (MDEV-32932)
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 (MDEV-33979)
Transportable Tablespaces no longer leave in a mismatched state (MDEV-18288)
Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption (MDEV-30046)
Fix incorrect DEFAULT expression evaluated in (MDEV-33790)
Fix server crash when UPDATE statement with duplicate key is run after setting a low thread_stack ()
Fix incorrect handling of in PS mode when a table's column declared as NOT NULL ()
Fix crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT ()
Fix wrong result on 2nd execution of PS to select from view using derived ()
Fix wrong warnings on 2nd execution of PS for query with GROUP_CONCAT ()
value of '1970-01-01 00:00:00' can no longer be indirectly inserted in ()
Fix out of range error in (()) due to a wrong data type ()
Fix zero datetime reinterpreting as '1970-01-01 00:00:00' on field_datetime=field_timestamp ()
unix_timestamp(coalesce(timestamp_column)) no longer returns NULL on '1970-01-01 00:00:00.000001' ()
Fix crash using UDF in WHERE clause of VIEW ()
Fix update for portion changes autoincrement key in period table ()
Fix SIGABRT resulting from CREATE TABLE with generated column and RLIKE ()
MariaDB-client community can't be installed in red hat ubi9 (MDEV-32791)
It's now possible to disable system commands with the option. (MDEV-21778)
now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.(MDEV-33727)
commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions (MDEV-4827)
Loading now works with INPLACE ()
Moving from MariaDB 10.5 to 10.6 mysql_upgrade is not updating some system tables (MDEV-33726)
Original IP not shown in network related error messages when proxy_protocol is in use (MDEV-33506)
Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup (MDEV-33469)
update case insensitive (large) unique key with insensitive change of value - duplicate key ()
MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params ()
Slowdown when running nested statement with many partitions ()
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.
MariaDB 11.7.1 Release Notes
Release date: 21 Nov 2024
is a . It is an evolution of with several entirely new features.
is a release.
Thanks, and enjoy MariaDB!
are a feature that allow MariaDB Server to perform as a relational vector database. Previously available in the special Vector preview release, it has now been added to MariaDB Community Server 11.7.1 with various enhancements (MDEV-34939)
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.
Note that the Debian packages have compatibility problems with PHP and NodeJS. We suggest that these users hold off upgrading, wait until the next 11.x release, MariaDB 11.4.2, or implement one of the following workarounds:
Edit /etc/mysql/mariadb.conf.d/50-server.cnf and change character-set-collations = utf8mb4=uca1400_ai_ci to character-set-collations = utf8mb4=general_ci or
run this as root: sed -i -e '/character-set-collations/d' /etc/mysql/mariadb.conf.d/50-server.cnf
Note that upgrading from earlier versions will leave all users, including root and other users with ALL PRIVILEGES ON *.*, and ALL PRIVILEGES ON db.*, without the privilege. While the users with read privileges on mysql.proc will be have the effective privileges of SHOW CREATE ROUTINE, they are unable to GRANT them.
To gain the privileges back on a global user, e.g. root@localhost:
Start server with as a configuration option
Run
Execute
To re-gain a database level privileges, using a user with SHOW CREATE ROUTINE on *.* execute , optionally WITH GRANT OPTION.
is a previous stable rolling release of MariaDB. It is an evolution of with several entirely new features. It is a rolling release — one is expected to upgrade to 11.4.2, there will be no 11.3.3 — see .
is a release.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
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 ()
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"
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 ()
MariaDB 11.1 is a current short-term stable series of MariaDB, maintained until August 2024. It is an evolution of MariaDB 11.1 with several entirely new features.
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 ()
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"
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 ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
Execute
Remove the skip-grant-tables option from the configuration file.
Assertion ``0'failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search ()
Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table ()
Crash emitting "Unsupported meta-data version number" error message ()
LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED ()
Inplace alter rebuild increases file size ()
BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY ()
GNU libc posix_fallocate() may be extremely slow ()
InnoDB wrong error message ()
Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 ()
InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe ()
InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty ()
innodb_fast_shutdown=0 hang after incomplete startup ()
innodb_undo_log_truncate=ON prevents fast shutdown ()
Adaptive flush recommendation ignores dirty ratio and checkpoint age ()
gcol.gcol_purge contaminates further execution of innodb.gap_locks ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Adaptive flushing is still not getting invoked in 10.5.11 ()
History list is not shrunk unless there is a pause in the workload ()
path separator near ib_buffer_pool incorrect ()
Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption ()
Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON ()
Some calls to buf_read_ahead_linear() seem to be useless ()
Opening all .ibd files on InnoDB startup can be slow ()
InnoDB LRU flushing does not run before running out of buffer pool ()
innodb_undo_log_truncate=ON is blocking page writes ()
If tables are frequently created, renamed, dropped, a backup cannot be restored ()
on table to be accessible to those with privileges ()
ASAN errors in Item_func_json_contains_path::val_int upon PS execution ()
mysql_json cannot be used on newly created table ()
Problems with a stored function EMPTY() on upgrade to 10.6 ()
ASANheap-use-after-free in spider_link_get_key on LOCK TABLES ()
Crash when lateral derived is guaranteed to return no rows ()
Bogus error executing PS for query using CTE with renaming of columns ()
Spider: Valid LEFT JOIN results in ERROR 1064 ()
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()
Spider tests failing in asan/valgrind builds ()
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()
Syntax error upon query with subquery from Spider table ()
Spider doesn't recognize semi JOIN ()
MariaDB, SPIDER engine, usage of REGEXP ()
Spider: variable spider_same_server_link not functioning correctly ()
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()
Spider spawns unnecessarily many system threads for stats synchronization ()
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 ()
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()
ASAN errors in spider_conn_queue_and_merge_loop_check ()
Incorrect result interceptor passed to mysql_explain_union() ()
Add variable to influence how costs for secondary keys are calculated. ()
INSERT ... SELECT Does not produce an optimizer trace ()
Unusable key notes do not get reported for some operations ()
Unusable key notes report wrong predicates for > and >= ()
FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure ()
Assertion (col.vers_sys_end()) upon inplace ALTER with virtual columns ()
DELETE with ORDER BY and semijoin optimization causing crash ()
Invalid expr in cleanup_session_expr() upon INSERT DELAYED ()
SIGSEGV in my_decimal::operator= and Assertion 0'failed inItem_type_holder::val_decimal` on SELECT ()
LONG UNIQUE does not work like unique key when using replace ()
LONG UNIQUE gives error when used with REPLACE ()
Backport to 10.6 ()
Assertion ``0' failed in Item_type_holder::val_int` ()
)
Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types ()
should be a Warning, not an Error (
)
mariadb-upgrade should remove mysql.plugin entries for plugins that became bundled ()
)
wsrep_provider_options can be truncated on deep and long directory paths ()
Server crashes in rpl_sql_thread_info::cached_charset_compare / wsrep_apply_events ()
Galera crash when "create a table as select" ()
Cluster is inconsistent after SAVEPOINT statement is rolled back ()
WSREP GTID MODE is inconsistent ()
IST "Donor does not know my secret" with ssl-mode=VERIFY_CA ()
SHOW SLAVE STATUS Can Deadlock an Errored Slave ()
main.rpl_mysqldump_slave Fails with "Master binlog wasn't deleted" Assertion ()
rpl_seconds_behind_master_spike Sensitive to IO Thread Stop Position ()
Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty ()
"Read semi-sync reply magic number error" warnings on master ()
Second Semi-sync Replica Can Hang at Connect Time ()
Semi-sync ACKed Transaction can Timeout and Switch Off Semi-sync with Multiple Replicas ()
Semi-Sync Ack_Receiver Thread Should Allow COM_QUIT Command ()
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.
Upgrade to 12.6.
Using two temporary tables in OPTIMIZE TABLE lead to crash ()
REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode ()
CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" ()
Failure when executing PS for query using IN subquery ()
Potential memory leak on executing of create view statement ()
Assertion failures ()
Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES ()
Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds ()
Set TaskMax=infinity in the MariaDB systemd unit ()
Unreliable autocommit flag on connection creation ()
A connection can control RAND() in following connection ()
THD::rli_fake/rgi_fake not cleared on new connection ()
Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> ()
Server crash in find_field_in_table ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Failure to call SP invoking another SP with parameter requiring type conversion ()
The database part is not case sensitive in SP names ()
EXCHANGE PARTITION with non-matching vcol expression segfault ()
Wrong user in SET DEFAULT ROLE error ()
quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') ()
mysql.slow_log reports incorrect start time ()
Update federated table and column privileges ()
Deprecate ()
sys schema view session_ssl_status is empty ()
Memory pressure ()
Notable Items
InnoDB
Backup
JSON
Spider
Optimizer
Data Definition, Data Manipulation
Character Sets, Data Types
Plugins
Galera
Replication
General
Security
Changelog
Contributors
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.
Some calls to buf_read_ahead_linear() seem to be useless ()
Opening all .ibd files on InnoDB startup can be slow ()
InnoDB LRU flushing does not run before running out of buffer pool ()
innodb_undo_log_truncate=ON is blocking page writes ()
If tables are frequently created, renamed, dropped, a backup cannot be restored ()
on table to be accessible to those with privileges ()
ASAN errors in Item_func_json_contains_path::val_int upon PS execution ()
mysql_json cannot be used on newly created table ()
Problems with a stored function EMPTY() on upgrade to 10.6 ()
ASANheap-use-after-free in spider_link_get_key on LOCK TABLES ()
Crash when lateral derived is guaranteed to return no rows ()
Bogus error executing PS for query using CTE with renaming of columns ()
Spider: Valid LEFT JOIN results in ERROR 1064 ()
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()
Spider tests failing in asan/valgrind builds ()
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()
Syntax error upon query with subquery from Spider table ()
Spider doesn't recognize semi JOIN ()
MariaDB, SPIDER engine, usage of REGEXP ()
Spider: variable spider_same_server_link not functioning correctly ()
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()
Spider spawns unnecessarily many system threads for stats synchronization ()
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 ()
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()
ASAN errors in spider_conn_queue_and_merge_loop_check ()
Incorrect result interceptor passed to mysql_explain_union() ()
Add variable to influence how costs for secondary keys are calculated. ()
INSERT ... SELECT Does not produce an optimizer trace ()
Unusable key notes do not get reported for some operations ()
Unusable key notes report wrong predicates for > and >= ()
FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure ()
Assertion (col.vers_sys_end()) upon inplace ALTER with virtual columns ()
DELETE with ORDER BY and semijoin optimization causing crash ()
Invalid expr in cleanup_session_expr() upon INSERT DELAYED ()
SIGSEGV in my_decimal::operator= and Assertion 0'failed inItem_type_holder::val_decimal` on SELECT ()
LONG UNIQUE does not work like unique key when using replace ()
LONG UNIQUE gives error when used with REPLACE ()
Backport to 10.6 ()
Assertion ``0' failed in Item_type_holder::val_int` ()
)
Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types ()
should be a Warning, not an Error (
)
mariadb-upgrade should remove mysql.plugin entries for plugins that became bundled ()
)
wsrep_provider_options can be truncated on deep and long directory paths ()
Server crashes in rpl_sql_thread_info::cached_charset_compare / wsrep_apply_events ()
Galera crash when "create a table as select" ()
Cluster is inconsistent after SAVEPOINT statement is rolled back ()
WSREP GTID MODE is inconsistent ()
IST "Donor does not know my secret" with ssl-mode=VERIFY_CA ()
SHOW SLAVE STATUS Can Deadlock an Errored Slave ()
main.rpl_mysqldump_slave Fails with "Master binlog wasn't deleted" Assertion ()
rpl_seconds_behind_master_spike Sensitive to IO Thread Stop Position ()
Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty ()
"Read semi-sync reply magic number error" warnings on master ()
Second Semi-sync Replica Can Hang at Connect Time ()
Semi-sync ACKed Transaction can Timeout and Switch Off Semi-sync with Multiple Replicas ()
Semi-Sync Ack_Receiver Thread Should Allow COM_QUIT Command ()
Upgrade to 12.6.
Using two temporary tables in OPTIMIZE TABLE lead to crash ()
REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode ()
CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" ()
Failure when executing PS for query using IN subquery ()
Potential memory leak on executing of create view statement ()
Assertion failures ()
Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES ()
Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds ()
Set TaskMax=infinity in the MariaDB systemd unit ()
Unreliable autocommit flag on connection creation ()
A connection can control RAND() in following connection ()
THD::rli_fake/rgi_fake not cleared on new connection ()
Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> ()
Server crash in find_field_in_table ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Failure to call SP invoking another SP with parameter requiring type conversion ()
The database part is not case sensitive in SP names ()
EXCHANGE PARTITION with non-matching vcol expression segfault ()
Wrong user in SET DEFAULT ROLE error ()
quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') ()
mysql.slow_log reports incorrect start time ()
Update federated table and column privileges ()
Disable transparent huge pages after page buffers have been allocated ()
Deprecate ()
sys schema view session_ssl_status is empty ()
Memory pressure ()
Notable Items
InnoDB
Backup
JSON
Spider
Optimizer
Data Definition, Data Manipulation
Character Sets, Data Types
Plugins
Galera
Replication
General
Security
Changelog
Contributors
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.
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.
MariaDB 10.10 is a previous short-term maintenance stable series of MariaDB, maintained until November 2023. It is an evolution of MariaDB 10.9 with several entirely new features.
MariaDB now detects and converts previously incompatible MySQL partition schemes ()
As per the , this will be the last release of for Ubuntu 18.04 LTS "Bionic" and Ubuntu 22.10 "Kinetic"
doesn't ignore error as it should ()
280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode ()
version >= 6 are now stored without byte-swapping, UUIDs with version >=8 and variant=0 are now considered invalid, old tables are supported, old (always byte swapped) and new (swapped for version < 6) UUIDs can be compared and converted transparently ()
UBSAN: null pointer passed as argument 1, which is declared to never be null in my_strnncoll_binary on SELECT ... COUNT or GROUP_CONCAT ()
SIGSEGV in log_sort_flush_list() in InnoDB crash recovery ()
InnoDB tables are being flagged as corrupted on an I/O bound server ()
Duplicate entry allowed into a ()
Various crashes upon INSERT/UPDATE after changing Aria settings ()
Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded ()
SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT ()
that double as table params overriding mechanism is buggy ()
InnoDB engine statistics for each table ()
Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` ()
Problem with open ranges on prefix blobs keys ()
Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers ()
ends up in optimistic parallel slave binlog out-of-order ()
takes very long time on a busy system ()
Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_mariadb-backup ()
Node has been dropped from the cluster on Startup / Shutdown with async replica ()
KILL QUERY maintains nodes data consistency but breaks GTID sequence ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.7 Changes & Improvements
is no longer maintained. Please use a .
The most recent release of is: Stable (GA)
is a previous short-term maintenance stable series. The first stable release was in February 2022, and it was maintained for one year.
See and .
SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION (MDEV-30662)
UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op (MDEV-30932)
Assorted assertion failures in json_find_path with certain collations (MDEV-23187)
Server crashes when wsrep_sst_donor and wsrep_cluster_address set to NULL (MDEV-28433)
Create temporary sequence can cause inconsistency (MDEV-31335)
Galera 4 unable to query cluster state if not primary component (MDEV-21479)
Notable Items
Upgrading from MySQL
General
Character Sets, Data Types
InnoDB
Aria
Spider
Optimizer
Replication
Galera
Security
Changelog
Contributors
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.
ALTER TABLE ... CONVERT PARTITION .. TO TABLE (MDEV-22166), and
ALTER TABLE ... CONVERT TABLE ... TO PARTITION ... (MDEV-22165) as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP
password_reuse_check plugin is a new password validation plugin that prevents the new password from being the same as the one being used during the configurable retention period. (MDEV-9245)
In bulk insert, pre-sort and build indexes one page at a time (MDEV-24621)
GET DIAGNOSTICS supports a new condition property name ROW_NUMBER. In multi-row inserts it allows one to retrieve a number of a row that has caused the error (MDEV-10075, MDEV-26611)
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.
MariaDB 10.8 is a previous short-term maintenance stable series of MariaDB, maintained until May 2023. It is an evolution of MariaDB 10.7 with several entirely new features.
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 ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
Performance regression in fil_space_t::try_to_close() introduced in ()
InnoDB recovery hangs when buffer pool ran out of memory ()
InnoDB undo log truncation fails to wait for purge of history (
MariaDB crash due to DB_FAIL reported for a corrupted page ()
Deadlock between INSERT and InnoDB non-persistent statistics update ()
InnoDB hang on B-tree split or merge ()
Performance regression in locking reads from secondary indexes ()
Improve adaptive flushing ()
Make page flushing even faster ()
Purge misses a chance to free not-yet-reused undo pages ()
InnoDB temporary tablespace: reclaiming of free space does not work ()
Deadlock between CHECK TABLE and bulk insert ()
Fix miscount of doublewrites by ()
Race condition between buffer pool flush and log file deletion in mariadb-backup --prepare ()
Mended encrypted binlog master to error out to gtid-mode slave when master could not decrypt a binlog file ()
Refined optimistic parallel slave to error-exit without any hang ()
Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always initialized ()
Fixed the slave applier to report a correct error when gtid_slave_pos insert fails for some (engine) reasons ()
Made parallel slave reports in performance schema consistent with that of show-slave-status ()
now prints more information about : block-nl-join element now has r_loops, r_effective_rows and r_other_time_ms fields (, ).
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 ()
EXPLAIN could erroneously report that is used for partitioned tables. Partitioned tables do not support it. ()
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 ().
Notable Items
InnoDB
Backup
Replication
Optimizer
Docker Official Image
Security
Changelog
Contributors
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.
FULLTEXT search with apostrophe, and mandatory words ()
ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()
is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. ()
ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS ()
INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback ()
updated to 26.4.12
Possible to write/update with read_only=ON and not a SUPER privilege ()
Node crashes with Transport endpoint is not connected mysqld got signal 6 ()
Server crash in JOIN_CACHE::free or in copy_fields ()
Queries that use DISTINCT and an always-constant function like COLLATION(aggregate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not constant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause ()
MariaDB Server SEGV on INSERT .. SELECT ()
Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
Wrong result with table elimination combined with not_null_range_scan ()
If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.
Assertion `tmp >= 0' failed in best_access_path ()
and have been deprecated (, )
Spider's high-availability feature has been deprecated ()
: extract document fragment into JSON column ()
now supports with ()
now also has a session scope, not only global ()
New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.
Crash in ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
ALTER TABLE wrong-result fix ()
Crash recovery fixes (, )
DDL crash recovery fixes (, , , , , )
Avoid crashes on corrupted data (, , , , , )
Bulk load bug fixes (, )
Performance fixes (, )
sequences related row-format events are made to correspond to binlog_row_image ()
Possible reason of FLUSH BINARY LOGS hang is eliminated ()
Fix out-of-order gtid error in the circular semisync setup ()
Galera4 not able to report proper wsrep_incoming_addresses ()
Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB ()
Add support for OpenSSL 3.0 in Galera ()
A query with a subuquery in this form could cause a crash:
Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.
Optimizer uses all partitions after upgrade to 10.3 ()
For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.
Range optimizer regression for key IN (const, ....) ()
The issue can be observed on and later versions which have the fix for . That fix introduceds optimizer_max_sel_arg_weight.
If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:
If one uses histogram_type=JSON_HB, has collected a histogram of that type and runs a query that selects a very narrow range near histogram end, they can hit an assertion in the optimizer due to rounding errors in the histogram causing negative selectivity.
ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade ()
Server crash upon CREATE VIEW with unknown column in ON condition ()
password_reuse_check plugin mixes username and password ()
As per the , this will be the last release of for Debian 10 "Buster" for ppc64el
Repositories for Ubuntu 22.04 and RHEL/Rocky 9 have been added in this release
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
table.keyXpartY [NOT] IN ( ... )
Notable Items
InnoDB
Replication
Galera
Optimizer
Spider
JSON
CONNECT
General
Security
Changelog
Contributors
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.
Do not use non-stable (non-GA) releases in production!
MariaDB 11.1 is the current short-term development series of MariaDB, which will be maintained for one year after the Stable (GA) release. It is an evolution of MariaDB 11.0 with several entirely new features.
The option is now a system variable, and the tx_isolation system variable is deprecated ()
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 .
Do not use non-stable (non-GA) releases in production!
This page is licensed: CC BY-SA / Gnu FDL
InnoDB hang fixes (, , )
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"
Notable Items
InnoDB
Optimizer
Security
Changelog
Contributors
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.
MariaDB 10.9 is the current short-term maintenance stable series of MariaDB, maintained until August 2023. It is an evolution of MariaDB 10.8 with several entirely new features.
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 ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
Performance regression in fil_space_t::try_to_close() introduced in ()
InnoDB recovery hangs when buffer pool ran out of memory ()
InnoDB undo log truncation fails to wait for purge of history (
MariaDB crash due to DB_FAIL reported for a corrupted page ()
Deadlock between INSERT and InnoDB non-persistent statistics update ()
InnoDB hang on B-tree split or merge ()
Performance regression in locking reads from secondary indexes ()
Improve adaptive flushing ()
Make page flushing even faster ()
Purge misses a chance to free not-yet-reused undo pages ()
InnoDB temporary tablespace: reclaiming of free space does not work ()
Deadlock between CHECK TABLE and bulk insert ()
Fix miscount of doublewrites by ()
Race condition between buffer pool flush and log file deletion in mariadb-backup --prepare ()
Mended encrypted binlog master to error out to gtid-mode slave when master could not decrypt a binlog file ()
Refined optimistic parallel slave to error-exit without any hang ()
Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always initialized ()
Fixed the slave applier to report a correct error when gtid_slave_pos insert fails for some (engine) reasons ()
Made parallel slave reports in performance schema consistent with that of show-slave-status ()
now prints more information about : block-nl-join element now has r_loops, r_effective_rows and r_other_time_ms fields (, ).
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 ()
EXPLAIN could erroneously report that is used for partitioned tables. Partitioned tables do not support it. ()
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 ().
Notable Items
InnoDB
Backup
Replication
Optimizer
Docker Official Image
General
Security
Changelog
Contributors
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.
MariaDB 10.8 is a previous short-term maintenance stable series of MariaDB, maintained until May 2023. It is an evolution of MariaDB 10.7 with several entirely new features.
As mentioned in the , 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 and the page for more details.
corruption with ()
recovery and backup fixes (, , )
Upgrade after a crash is not supported ()
updated to 26.4.14
Fixes for cluster wide write conflict resolving ()
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE ()
is now shown now more precisely at the slave applier start, including in the delayed mode ()
mysqlbinlog --verbose is made to show the type of compressed columns ()
added as an alias for ()
Infinite sequence of recursive calls when processing embedded CTE ()
Crash with a query containing nested WINDOW clauses ()
Major performance regression with 10.6.11 ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
Remove load throttling ()
InnoDB shutdown hangs when the change buffer is corrupted ()
innodb_fast_shutdown=0 fails to report change buffer merge progress ()
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 (, )
Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA ()
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.
InnoDB
Galera
Replication
JSON
General
Security
Changelog
Contributors
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.
MariaDB 11.1 is a current short-term stable series of MariaDB, maintained until August 2024. It is an evolution of MariaDB 11.0 with several entirely new features.
MariaDB now detects and converts previously incompatible MySQL partition schemes ()
As per the , this will be the last release of for Ubuntu 18.04 LTS "Bionic" and Ubuntu 22.10 "Kinetic"
In this release repositories for Debian 12 "Bookworm" have been added.
doesn't ignore error as it should ()
UBSAN: null pointer passed as argument 1, which is declared to never be null in my_strnncoll_binary on SELECT ... COUNT or GROUP_CONCAT ()
Possibly wrong result or Assertion 0' failed in Item_func_round::native_op` ()
Crashing on I/O error is unhelpful ()
SIGSEGV in log_sort_flush_list() in InnoDB crash recovery ()
InnoDB tables are being flagged as corrupted on an I/O bound server ()
Various crashes upon INSERT/UPDATE after changing settings ()
Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded ()
SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT ()
that double as table params overriding mechanism is buggy ()
InnoDB engine statistics for each table ()
Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` ()
Problem with open ranges on prefix blobs keys ()
Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers ()
ends up in optimistic parallel slave binlog out-of-order ()
takes very long time on a busy system ()
Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_mariadb-backup ()
Node has been dropped from the cluster on Startup / Shutdown with async replica ()
KILL QUERY maintains nodes data consistency but breaks GTID sequence ()
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 .
This page is licensed: CC BY-SA / Gnu FDL
280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode ()
SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION ()
Unexpected result when combining , subselect and ()
variables do not get assigned from subselects ()
Crash after setting global session_track_system_variables to an invalid value ()
ODKU of non-versioning column inserts history row ()
UPDATE not working properly on transaction precise system versioned table ()
UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op ()
Assorted assertion failures in json_find_path with certain collations ()
Duplicate entry allowed into a ()
Server Status is reported in seconds ()
dies with Floating point exception ()
Add InnoDB engine information to the ()
Deadlock with 3 concurrent by ()
innodb protection against dual processes accessing data insufficient ()
Server crashes when wsrep_sst_donor and wsrep_cluster_address set to NULL ()
Create temporary sequence can cause inconsistency ()
Galera 4 unable to query cluster state if not primary component ()
Notable Items
Localization
Upgrading from MySQL
General
Character Sets, Data Types
InnoDB
Aria
Spider
Optimizer
Replication
Galera
Security
Changelog
Contributors
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.