MariaDB 10.5.25 Release Notes

Download Release Notes Changelog Overview of 10.5

Alternate download from

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.

For an overview of MariaDB 10.5 see the What is MariaDB 10.5? page.

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


  • Fix adaptive hash index corruption after ALTER TABLE…DISCARD TABLESPACE (MDEV-33400)
  • Fix fatal InnoDB error or assertion `!is_v' failure upon multi-update with indexed virtual column (MDEV-31154)
  • Fix InnoDB: Failing assertion on UPDATE (MDEV-32346)
  • Fix fatal error InnoDB: 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)
  • Read only server no longer throws error when running a create temporary table as select statement (MDEV-33889)
  • Change buffer index no longer fails to delete the records (MDEV-32489)
  • Fix InnoDB include OS error information when failing to write to iblogfile0 (MDEV-33397)
  • In-place migration from MySQL 5.7 no longer causes invalid AUTO_INCREMENT values (MDEV-33277)
  • Fix InnoDB log corruption before upgrading it on startup (MDEV-32445)
  • Table no longer gets rebuilt with ALTER TABLE ADD COLUMN (MDEV-33214)


  • Fix wrong result on 2nd execution of prepared statement for query with derived table (MDEV-31361)


  • 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)


Character Sets, Data Types


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)



  • --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 no longer leave AUTO_INCREMENT in a mismatched state (MDEV-18288)
  • Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption (MDEV-30046)
  • Fix incorrect DEFAULT expression evaluated in UPDATE (MDEV-33790)
  • Fix incorrect handling of UPDATE in PS mode when a table's column declared as NOT NULL (MDEV-33549)
  • Fix wrong result on 2nd execution of PS to select from view using derived (MDEV-31277)
  • TIMESTAMP value of '1970-01-01 00:00:00' can no longer be indirectly inserted in strict mode (MDEV-34088)
  • Fix zero datetime reinterpreting as '1970-01-01 00:00:00' on field_datetime=field_timestamp (MDEV-34069)
  • unix_timestamp(coalesce(timestamp_column)) no longer returns NULL on '1970-01-01 00:00:00.000001' (MDEV-34061)
  • Fix crash using UDF in WHERE clause of VIEW (MDEV-24507)
  • Fix update for portion changes autoincrement key in period table (MDEV-25370)
  • Fix SIGABRT resulting from CREATE TABLE with generated column and RLIKE (MDEV-21058)


Scripts & Clients


  • 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)



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


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

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' 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.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.