MariaDB 10.9.5 Release Notes

Download | Release Notes | Changelog | Overview of 10.9

Release date: 6 Feb 2023

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.

MariaDB 10.9.5 is a Stable (GA) release.

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

Thanks, and enjoy MariaDB!

Notable Items

• 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 GPG page for more details.

InnoDB

• Full-text index corruption with system versioning (MDEV-25004)

• innodb_undo_log_truncate=ON recovery and backup fixes (MDEV-29999, MDEV-30179, MDEV-30438)

• Upgrade after a crash is not supported (MDEV-24412)

• Remove InnoDB buffer pool load throttling (MDEV-25417)

• InnoDB shutdown hangs when the change buffer is corrupted (MDEV-30009)

• innodb_fast_shutdown=0 fails to report change buffer merge progress (MDEV-29984)

• mariadb-backup --backup --incremental --throttle=... hangs (MDEV-29896)

• Crash after recovery, with InnoDB: Tried to read (MDEV-30132)

• Trying to write ... bytes at ... outside the bounds (MDEV-30069)

• TRUNCATE breaks FOREIGN KEY locking (MDEV-29504, MDEV-29849)

• INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces (MDEV-30119)

• Fixed hangs and error handling in B-tree operations (MDEV-29603, MDEV-30400)

• InnoDB bulk insert fixes (MDEV-30047, MDEV-30321)

Galera

• Galera updated to 26.4.14

• Fixes for cluster wide write conflict resolving (MDEV-29684)

Replication

• Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE (MDEV-30323)

• Seconds_Behind_Master is now shown now more precisely at the slave applier start, including in the delayed mode (MDEV-29639)

• mysqlbinlog --verbose is made to show the type of compressed columns (MDEV-25277)

• Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA (MDEV-30423)

JSON

• JSON_PRETTY added as an alias for JSON_DETAILED (MDEV-19160)

General

• Infinite sequence of recursive calls when processing embedded CTE (MDEV-30248)

• Crash with a query containing nested WINDOW clauses (MDEV-30052)

• Major performance regression with 10.6.11 (MDEV-29988)

• Json Range only affects first row of the result set (MDEV-30304)

• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.9 for Fedora 35.

• In this release repositories for Fedora 37 and Ubuntu 22.10 Kinetic have been added.

Security

• Fixes for the following security vulnerabilities:

  • CVE--``#

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.9.5, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

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