mariadb-11.4.4

[Bruce Dubbs]

New point version.

[Bruce Dubbs]

MariaDB 11.4.4 Release Notes

Notable Items

Storage Engines

InnoDB

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

Spider

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

S3

• engine S3 cause 500 error for huawei buckets

Optimizer

• Crash caused by query containing constant having clause
• Assertion with optimizer_join_limit_pref_ratio and 1-table select

Data Definition - Alter Table

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

Galera

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

Backup

• Recovery fails to note some log corruption
• InnoDB fails to merge the change buffer to ROW_FORMAT=COMPRESSED tables
• Can't selectively restore sequences using innodb tables from backup

JSON

• JSON_TABLE doesn't properly unquote strings
• JSON_TABLE default values should allow non-string literals

General

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

[Bruce Dubbs]

Fixed at commit 7ec5010085.