MariaDB 10.4.34 Release Notes

Download Release Notes Changelog Overview of 10.4

^{Alternate download from mariadb.org}

Release date: 16 May 2024

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.34 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• Fix adaptive hash index corruption after ALTER TABLE…DISCARD TABLESPACE (MDEV-33400)
• Fix InnoDB: Failing assertion on UPDATE (MDEV-32346)
• Fix fatal InnoDB error or assertion `!is_v' failure upon multi-update with indexed virtual column (MDEV-31154)
• Fix InnoDB fatal error: Clustered record field for column x not found (MDEV-33558)
• Fix alter operation hang when encryption thread works on the same tablespace (MDEV-33770)
• Fix MariaDB segfault on rowid filter query involving generated column (MDEV-33795)
• Fix discard/import tablespace, restart, index corruption (MDEV-33512)
• Fix alter table corruption while applying the modification log (MDEV-19044)
• Fix weird read view after ROLLBACK of other transactions (MDEV-33802)
• Table no longer gets rebuilt with ALTER TABLE ADD COLUMN (MDEV-33214)

RocksDB

• Unsafe use of LOCK_thd_kill in my_malloc_size_cb_func() (MDEV-33443)

Spider

• Improve Spider performance by pushing down TIMESTAMPDIFF function (MDEV-28992) and CASE statement (MDEV-28993) to data nodes
• Fix sql plugin init failure with traditional sql_mode (MDEV-33584)
• Fix parsing failure on valid left join select by translating the on expression to () (MDEV-33679)
• Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using MariaDB 10.5 local and MariaDB 10.6 remote (MDEV-33777)
• Fix bug where Spider variables were not available if Spider was loaded upon server startup (MDEV-33441)

Backup

• mariadb-backup now preserves innodb_encrypt_tables (MDEV-33334)
• Fix mariabackup problem on older mariadb (opendir(NULL)) caused by MDEV-30968 (MDEV-31251)
• mariadb-backup --backup now includes retry logic for undo tablespaces (MDEV-33980)
• Fix crash recovery in mariabackup --prepare due to insufficient innodb_log_file_size (MDEV-33540)

Character Sets, Data Types

• Default charset now works with PHP MySQLi extension (MDEV-32975)

Optimization & Tuning

• Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables (MDEV-21102)

Replication

• --gtid-ignore-duplicate can double-apply event in case of parallel replication retry (MDEV-33475)

Galera

• Galera 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 nodes have been updated

SQL, Data Definition, and Data Manipulation

• Fix incorrect DEFAULT expression evaluated in UPDATE (MDEV-33790)

Prepared Statements

• Incorrect handling of UPDATE in PS mode in case a table's colum declared as NOT NULL (MDEV-33549)
• Crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT, UBSAN runtime error: member call on null pointer of type 'struct TABLE_LIST' in Item_param::save_in_field (MDEV-15703)

General

Server

• Original IP not shown in network related error messages when proxy_protocol is in use (MDEV-33506)

Changelog

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

Contributors

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