The Ultimate Guide to High Availability with MariaDB

Release Notes for MariaDB Enterprise Server 10.5.28-22

MariaDB Enterprise Server 10.5.28-22 is a maintenance release of MariaDB Enterprise Server 10.5. This release includes a variety of fixes.

MariaDB Enterprise Server 10.5.28-22 was released on 19 Mar 2025.

Contents

  1. Fixed Security Vulnerabilities
  2. Changes in Storage Engines
  3. Notable changes
  4. Issues Fixed
    1. Can result in data loss
    2. Can result in hang or crash
    3. Can result in unexpected behaviour
    4. Related to performance
  5. Changelog
  6. Platforms
  7. Installation Instructions
  8. Upgrade Instructions

Fixed Security Vulnerabilities

CVE (with cve.org link)CVSS base score
CVE-2025-214904.9

Changes in Storage Engines

  • This release incorporates MariaDB ColumnStore engine version 5.6.9.

Notable changes

  • Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+ (MDEV-35505)
  • Galera updated to 26.4.21
    • 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

Issues Fixed

Can result in data loss

  • Fix incorrect writing of timestamp into binary log, causing discrepancy upon binlog replaying (MDEV-31761)
  • Fix trigger created with "CREATE TRIGGER `table1_after_insert` AFTER INSERT" which is adding rows to another table using "FOR EACH ROW insert into table2(`id`, `name`) values (NEW.`id`, NEW.`name`);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table (MDEV-34958)
  • History is now stored on the same partitions on different Galera nodes when system versioning is enabled (MDEV-35096)
  • Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys (MDEV-30111)

Can result in hang or crash

  • Fix client crash the command after client sets character set to utf32 (MDEV-34090)
  • Fix possible crash where server could not construct a geomery object from the input (MDEV-33987)
  • Fix possible Spider thread hang in 'Update' state on 2nd INSERT (MDEV-35064)
  • After changing the table definition for the system table 'mysql.servers', a following execution of CREATE SERVER would previously lead to a server crash. (MDEV-33783)
    • NOTE: System tables should never be modified by a user anyhow
  • Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled (MDEV-35465)
  • Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory (MDEV-35387)
  • Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED (MDEV-35571)
  • Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY (MDEV-29935)
  • Fix possible memory leak on SHUTDOWN (MDEV-35326)
  • Fix possible memory leak while shutting down server after installing the auth_gssapi plugin (MDEV-35575)
  • Fix possible crash on DELETE from a HEAP table (MDEV-22695)
  • Fix possible server crash when using INSERT DELAYED on tables with virtual columns. (MDEV-26891)
  • Fix possible crash during index traversal using `tree_search_next`. (MDEV-28130)
  • Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE (MDEV-25654)
  • Fix possible Spider crash or hang when the first byte of a connection key is changed (MDEV-34849)
  • Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer (MDEV-35549)
  • Fix assertion failure on cascading foreign key update of table with vcol index in parent (MDEV-29182)
  • Fix assertion failure where CURRENT_USER was not correctly copied during condition pushdown (MDEV-35090)
  • Fix cluster node hang during shutdown if threadpool is used (MDEV-35710)
  • Calling a stored routine that executes a join on three or more tables and referencing not-existent column name in the USING clause could previously result in a crash on its second invocation. (MDEV-24935)
  • Fix possible assertion failure when Galera cluster is in 'split-brain' state due to loss of communication between nodes (fix requires Galera library 26.4.21+) (MENT-2175)
  • In rare cases, an ALTER TABLE or other operation could previously hang when using NBO mode on a cluster with very low network latencies (for example, when both nodes are running on the same physical machine) (MENT-2215)
  • MariaDB Cluster and ALTER INPLACE running in Total Order Isolation (wsrep_OSU_method=TOI) now correctly abort a DML INSERT operation in InnoDB (MDEV-33064)
  • Fix possible crash in wsrep_check_sequence (MDEV-33245)

Can result in unexpected behaviour

  • Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction (MDEV-35446)
  • Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy (MDEV-35157)
  • For an authentication with the ed25519 authentication plugin the password of the CREATE USER statement is now masked in the audit log (MDEV-35507)
  • MariaDB Audit now detects all DCLs forms for masking a password (MDEV-35522)
  • sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers (MDEV-35651)
  • mariadb-binlog can now correctly process more than one logfile when --stop-datetime is specified (MDEV-35528)
  • Rows in table mysql.gtid_slave_pos are now correctly deleted on Galera nodes when wsrep_gtid_mode = 1 is used, which previously lead to wrong information about replica delays (MDEV-34924)
  • EXCHANGE PARTITION now works for tables with unique blobs (MDEV-35612)
  • Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump (MDEV-29968)
  • Setting `pseudo_thread_id` to a value exceeding 4 bytes previously resulted in truncation when written to the binary log (MDEV-35646)
  • A BEFORE INSERT Trigger previously returned with error "Field 'xxx' doesn't have a default value", if a NULL value was added for a column defined NOT NULL without explicit value and no DEFAULT specified (MDEV-19761)
  • Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node. (MDEV-35852)
  • Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column (MDEV-35445)
  • algorithm = instant can now correctly be used if a table has partitions and one tries to change a column with an index which is not the partitions key. This previously gave error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY" (MDEV-34813)
  • Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently. (MDEV-35018)
  • Can now correctly add a foreign key on a table with a long UNIQUE multi-column index that contains a foreign key as a prefix (MDEV-33658)
  • Fix possibly wrong result using a degenerated subquery (SELECT <expr>) with window function (MDEV-35869)
  • The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error (MDEV-20281)
  • Fix debian-start script failure when using non-standard socket path (MDEV-35907)
  • wsrep_sst_mariabackup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours (MDEV-35749)
  • For a SPIDER engine based table a SELECT from the spider table and INSERT into a local table fails with 'Out of Range Value for Column XX_YY' Causes ERROR 1264 (22003) (MENT-2204)
  • Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition (MDEV-35910)
  • NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures (MDEV-34665)
  • During an online table rebuild of an InnoDB statistics table, opt_search_plan_for_table() no longer sometimes degrades to full table scan (MDEV-35443)

Changelog

For the complete list of changes in this release, see the changelog.

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.5.28-22 is provided for:

  • AlmaLinux 8 (x86_64, ARM64)
  • AlmaLinux 9 (x86_64, ARM64)
  • Debian 11 (x86_64, ARM64)
  • Microsoft Windows (x86_64) (MariaDB Enterprise Cluster excluded)
  • Red Hat Enterprise Linux 8 (x86_64, ARM64)
  • Red Hat Enterprise Linux 9 (x86_64, ARM64)
  • Rocky Linux 8 (x86_64, ARM64)
  • Rocky Linux 9 (x86_64, ARM64)
  • SUSE Linux Enterprise Server 12 (x86_64)
  • SUSE Linux Enterprise Server 15 (x86_64, ARM64)
  • Ubuntu 20.04 (x86_64, ARM64)
  • Red Hat UBI 8 (x86_64, ARM64)
    • Red Hat UBI 8 is part of the Enterprise Server Docker Image. It does not support MariaDB Enterprise Cluster (Galera) or MariaDB ColumnStore.

Some components of MariaDB Enterprise Server are supported on a subset of platforms. See MariaDB Engineering Policies for details.

Installation Instructions

Upgrade Instructions

Comments

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.
Back to Top