MariaDB 10.5.25 Release Notes

Download Release Notes Changelog Overview of 10.5

^{Alternate download from mariadb.org}

Release date: 16 May 2024

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

MariaDB 10.5.25 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

From this version, the mariadb-dump tool adds a new sandbox 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.

Storage Engines

InnoDB

• Adaptive hash index corruption after ALTER TABLE…DISCARD TABLESPACE (MDEV-33400)
• InnoDB: Failing assertion: sym_node->table != NULL in pars_retrieve_table_def on UPDATE (MDEV-32346)
• Fatal InnoDB error or assertion `!is_v' failure upon multi-update with indexed virtual column (MDEV-31154)
• Fatal error InnoDB: Clustered record field for column x not found (MDEV-33558)
• Alter operation hangs when encryption thread works on the same tablespace (MDEV-33770)
• MariaDB segfault on rowid filter query involving generated column (MDEV-33795)
• Discard/Import Tablespace, Restart, Index Corruption (MDEV-33512)
• Alter table corrupts while applying the modification log (MDEV-19044)
• Weird read view after ROLLBACK of other transactions. (MDEV-33802)
• Read only server throws error when running a create temporary table as select statement (MDEV-33889)
• Change buffer index fails to delete the records (MDEV-32489)
• Innodb include OS error information when failing to write to iblogfile0 (MDEV-33397)
• In-place migration from MySQL 5.7 causes invalid AUTO_INCREMENT values (MDEV-33277)
• InnoDB may corrupt its log before upgrading it on startup (MDEV-32445)
• Table is getting rebuild with ALTER TABLE ADD COLUMN (MDEV-33214)

Federated

• Wrong result on 2nd execution of PS for query with derived table (MDEV-31361)

Spider

• Server crashes when deleting partitions from a table with spider engine (MDEV-33731)
• spider plugin init failure with no_zero_date sql_mode (MDEV-33494)
• sql plugin init failure with traditional sql_mode (MDEV-33584)
• spider returns parsing failure on valid left join select by translating the on expression to () (MDEV-33679)
• Spider: ERROR 12710 (HY000): Invalid information from remote table when using MariaDB 10.5 local and MariaDB 10.6 remote (MDEV-33777)
• Spider: @@insert_id 128 to TINYINT: Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed. (MDEV-28105)
• 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)
• Fix mariabackup --backup FATAL ERROR: ... Can't open datafile cool_down/t3 (MDEV-33011)
• 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)
• Fix crash in mariadb-backup --prepare --export after --prepare (MDEV-33023)
• mariadb-backup now considers O/S user when --user option is omitted (MDEV-32893)

Character Sets, Data Types

• ORDER BY COLLATE improperly applied to non-character columns (MDEV-33318)
• Default charset doesn't work with PHP MySQLi extension (MDEV-32975)
• Bad SEPARATOR value in GROUP_CONCAT on character set conversion (MDEV-33772)
• Out of range error in AVG(YEAR(datetime)) due to a wrong data type (MDEV-33496)
• GREATEST() and LEAST() malfunction for NULL (MDEV-21034)

JSON

• View created via JSON_ARRAYAGG now returns correct json object (MDEV-30646)
• JSON_TYPE now detects the type of String Values and correctly returns Date/DateTime values (MDEV-19487)
• JSON_REMOVE no longer returns NULL on valid arguments (MDEV-22141)
• JSON_EXTRACT no longer returns multiple values for same path (MDEV-32287)

Encryption, TLS, SSL

• WolfSSL's math is unnecessarily slow (MDEV-33482)

Optimization & Tuning

• Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables (MDEV-21102)
• Wrong result with cross Join given join order (MDEV-30975)
• Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT (MDEV-31276)
• Wrong result with semi-join and splittable derived table (MDEV-23878)
• Aggregation functions fail to leverage uniqueness property (MDEV-30660)

Plugins

• The audit plugin now reports the user and host in all cases (MDEV-33393)

Replication

• --gtid-ignore-duplicate can double-apply event in case of parallel replication retry (MDEV-33475)
• Server crash in Rows_log_event::update_sequence upon replaying binary log (MDEV-31779)
• Slave crashed:reload_acl_and_cache during shutdown (MDEV-30260)
• When binlog_annotate_row_events on , event of binlog file is truncated (MDEV-9179)

SQL, Data Definition, and Data Manipulation

• Transportable Tablespaces leave AUTO_INCREMENT in mismatched state, causing INSERT errors in newly imported tables when .cfg is not used. (MDEV-18288)
• wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption (MDEV-30046)
• Incorrect DEFAULT expression evaluated in UPDATE (MDEV-33790)
• 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)
• Wrong result on 2-nd execution of PS to select from view using derived (MDEV-31277)
• The TIMESTAMP value of '1970-01-01 00:00:00' can be indirectly inserted in strict mode (MDEV-34088)
• Zero datetime reinterprets as '1970-01-01 00:00:00' on field_datetime=field_timestamp (MDEV-34069)
• unix_timestamp(coalesce(timestamp_column)) returns NULL on '1970-01-01 00:00:00.000001' (MDEV-34061)
• Server Crash using UDF in WHERE clause of VIEW (MDEV-24507)
• Update for portion changes autoincrement key in period table (MDEV-25370)
• CREATE TABLE with generated column and RLIKE results in sigabrt (MDEV-21058)

General

Scripts & Clients

• It's now possible to disable system commands with the mariadb --sandbox option. (MDEV-21778)
• mariadb-dump now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.(MDEV-33727)
• mariadb-dump commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions (MDEV-4827)
• Loading time zones now works with alter_algorithm INPLACE (MDEV-33044) )

Server

• 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 (MDEV-29345)
• MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params (MDEV-26923)

Security

• Fixes for the following security vulnerabilities:
  • CVE-2024-21096

Changelog

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