MariaDB 10.6.20 Release Notes

Download Release Notes Changelog Overview of 10.6

^{Alternate download from mariadb.org}

Release date: 1 Nov 2024

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.20 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• Trying to read 16384 bytes at 70368744161280 outside the bounds of the file: ./ibdata1 (MDEV-34453)
• MariaDB crashes with SIGILL because the OS does not support AVX512 (MDEV-34565)
• lock_rec_unlock_unmodified() causes deadlock (MDEV-34690)
• Can't write; duplicate key in table 'mysql.innodb_table_stats' (MDEV-34207)
• ALTER TABLE...IMPORT TABLESPACE with FULLTEXT SEARCH may corrupt the adaptive hash index (MDEV-35059)
• XA prepare don't release unmodified records in non-blocking mode (MDEV-34466)
• Contention between secondary index UPDATE and purge due to large innodb_purge_batch_size (MDEV-34515)
• Redundant page lookups hurt performance (MDEV-34791)

Spider

• Server crashes when calling spider UDF after aria_encrypt_tables is enabled (MDEV-34682)
• SELECT MIN on Spider table returns more rows than expected (MDEV-26345)
• spider group by handler wrong result on order by aggregate (MDEV-29546)

S3

• Storage Engine S3 causes 500 error when using Huawai Cloud S3 and possibly other S3 providers (MDEV-34867)
  • A new option S3-provider has been added. S3-provider=Huawai needs to be set for Huawai Cloud S3

Optimizer

• Crash caused by query containing constant having clause (MDEV-23983)
• Assertion with optimizer_join_limit_pref_ratio and 1-table select (MDEV-35072)

Data Definition - Alter Table

• Under Windows Subsystem for Linux, InnoDB crashes on ALTER TABLE or OPTIMIZE TABLE (MDEV-34938)
• modification of the column fails to check foreign key constraint (MDEV-34392)
• Incorrect NULL value handling for instantly dropped BLOB columns (MDEV-35122)

Galera

• Galera updated to 26.4.20
• Server crashes when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table (MDEV-31173)
• TOI (ALTER) hangs on a parent table if SR transaction is in progress on a child table (MDEV-34836)
• INSERT...SELECT' on MyISAM table suddenly replicated by Galera (MDEV-34647)
• With wsrep_mode=REPLICATE_ARIA only part of mixed-engine transactions is replicated (MDEV-30653)
• galera_ssl_reload failed with warning message (MDEV-32778)
• when InnoDB gets an assertion failure, WSREP layer is not handled gracefully (MDEV-32363)

Backup

• Recovery fails to note some log corruption (MDEV-34802)
• InnoDB fails to merge the change buffer to ROW_FORMAT=COMPRESSED tables (MDEV-34879)
• Can't selectively restore sequences using innodb tables from backup (MDEV-32350)

JSON

• JSON_TABLE doesn't properly unquote strings (MDEV-27412)
• JSON_TABLE: default values should allow non-string literals (MDEV-25822)

General

• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.6 for SLES 12, and Windows 11 22H2
• mysqld hangs on startup when --init-file target does not exists (MDEV-34814)
• LOAD DATA INFILE with geometry data fails (MDEV-34883)
• heap-use-after-free in group_concat with compressed or GIS columns (MDEV-16699)
• Assertion `!is_cond()' failed in Item_bool_func::val_int / do_select (MDEV-35135)
• Trigger doesn't work correctly with bulk update (MDEV-34718)
• Assertion failure in find_producing_item upon a query from a view (MDEV-35276)
• Quick mode produces the bug for mariadb client (MDEV-34704)

Changelog

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