Release Notes for MariaDB Enterprise Server 10.6.21-17

MariaDB Enterprise Server 11.6.21-17 is a Stable (GA) maintenance release of MariaDB Enterprise Server 10.6, released on 2025-03-19

circle-info

The most recent release of MariaDB Enterprise Server 10.6 is:

MariaDB Enterprise Server 10.6.21-17 is a Stable (GA) maintenance release of MariaDB Enterprise Serverarrow-up-right 10.4. This release includes a variety of fixes.

MariaDB Enterprise Server 10.6.21-17 was released on 19 Mar 2025.

Fixed Security Vulnerabilities

CVE (with cve.orgarrow-up-right link)

CVSS base score

Changes in Storage Engines

  • This release incorporates MariaDB ColumnStore engine version 23.10.3.

Notable changes

  • Starting with this release we generate a Software Bill of Materials (SBOM) JSON file provided in the downloads archive, which can be reached from the "All Files" link on the MariaDB Enterprise Server downloads page (MENT-2200)

  • New parameter --skip-freed-pages for Innochecksum. Use this parameter to not get freed undo logs reported as existing undo log pages. (MDEV-35394arrow-up-right)

  • Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+ (MDEV-35505arrow-up-right)

  • MariaDB now supports MySQL 8.0 binlog events, including PARTIAL_UPDATE_ROWS_EVENT, TRANSACTION_PAYLOAD_EVENT, and HEARTBEAT_LOG_EVENT_V2. (MDEV-35643arrow-up-right)

  • InnoDB deadlock output query length increased to improve visibility of deadlocked statements. (MDEV-32576arrow-up-right)

  • Galeraarrow-up-right 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 have been updated

Issues Fixed

Can result in data loss

  • Fix incorrect writing of timestamp into binary log, causing discrepancy upon binlog replaying (MDEV-31761arrow-up-right)

  • 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-34958arrow-up-right)

  • History is now stored on the same partitions on different Galera nodes when system versioning is enabled (MDEV-35096arrow-up-right)

  • Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys (MDEV-30111arrow-up-right)

Can result in hang or crash

  • Fix client crash the command after client sets character set to utf32 (MDEV-34090arrow-up-right)

  • Fix possible crash where server could not construct a geomery object from the input (MDEV-33987arrow-up-right)

  • Fix possible InnoDB hang while running out of buffer pool (MDEV-35409arrow-up-right)

  • Fix possible Spider thread hang in 'Update' state on 2nd INSERT (MDEV-35064arrow-up-right)

  • 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-33783arrow-up-right)

    • NOTE: System tables should never be modified by a user anyhow

  • FIx streaming replication transaction crash with innodb_snapshot_isolation (MDEV-35281arrow-up-right)

  • Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled (MDEV-35465arrow-up-right)

  • Fix failing assertion causing disruption and replication failure (MDEV-24035arrow-up-right)

  • Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory (MDEV-35387arrow-up-right)

  • Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED (MDEV-35571arrow-up-right)

  • Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY (MDEV-29935arrow-up-right)

  • Fix possible hang during CREATE TABLE...SELECT error handling, especially with innodb_snapshot_isolation enabled (MDEV-35647arrow-up-right)

  • Fix incorrect locking order of LOCK_log/LOCK_commit_ordered, and LOCK_global_system_variables (MDEV-29744arrow-up-right)

  • Fix possible memory leak on SHUTDOWN (MDEV-35326arrow-up-right)

  • Fix possible memory leak while shutting down server after installing the auth_gssapi plugin (MDEV-35575arrow-up-right)

  • Fix possible crash on DELETE from a HEAP table (MDEV-22695arrow-up-right)

  • Fix possible server crash when using INSERT DELAYED on tables with virtual columns. (MDEV-26891arrow-up-right)

  • Fix possible crash during index traversal using tree_search_next. (MDEV-28130arrow-up-right)

  • Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE (MDEV-25654arrow-up-right)

  • Fix possible hang or crash where zero offset applied to null pointer (MDEV-35864arrow-up-right)

  • Fix possible crash on bootup in spider_sys_open_table «ext-issue»«MDEV-32822arrow-up-right», «ext-issue»«MDEV-34302arrow-up-right» (MDEV-34925arrow-up-right)

  • Fix possible Spider crash or hang when the first byte of a connection key is changed (MDEV-34849arrow-up-right)

  • Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer (MDEV-35549arrow-up-right)

  • Fix assertion failure on cascading foreign key update of table with vcol index in parent (MDEV-29182arrow-up-right)

  • Fix assertion failure where CURRENT_USER was not correctly copied during condition pushdown (MDEV-35090arrow-up-right)

  • Fix cluster node hang during shutdown if threadpool is used (MDEV-35710arrow-up-right)

  • 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-24935arrow-up-right)

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

  • Fix assertion failure when executing XA PREPARE (and possibly other XA statements) on Galera cluster nodes (MENT-2212)

  • Fix assertion failure when executing XA statements on Galera cluster nodes (MENT-2214)

  • 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-33064arrow-up-right)

  • Fix possible crash in wsrep_check_sequence (MDEV-33245arrow-up-right)

Can result in unexpected behaviour

  • Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction (MDEV-35446arrow-up-right)

  • Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy (MDEV-35157arrow-up-right)

  • For an authentication with the ed25519 authentication plugin the password of the CREATE USER statement is now masked in the audit log (MDEV-35507arrow-up-right)

  • MariaDB Audit now detects all DCLs forms for masking a password (MDEV-35522arrow-up-right)

  • Fix potential issue in secondary Index with ROW_FORMAT=COMPRESSED and Change buffering enabled (MDEV-35679arrow-up-right)

  • sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers (MDEV-35651arrow-up-right)

  • Fix doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages (MDEV-34898arrow-up-right)

  • START TRANSACTION, when triggering an implicit commit as a COMMIT or ROLLBACK has not been executed before, now resets optional characteristics added to the last START TRANSACTION command (MDEV-35335arrow-up-right)

  • mariadb-binlog can now correctly process more than one logfile when --stop-datetime is specified (MDEV-35528arrow-up-right)

  • 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-34924arrow-up-right)

  • EXCHANGE PARTITION now works for tables with unique blobs (MDEV-35612arrow-up-right)

  • Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump (MDEV-29968arrow-up-right)

  • Setting pseudo_thread_id to a value exceeding 4 bytes previously resulted in truncation when written to the binary log (MDEV-35646arrow-up-right)

  • 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-19761arrow-up-right)

  • Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node. (MDEV-35852arrow-up-right)

  • Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column (MDEV-35445arrow-up-right)

  • 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-34813arrow-up-right)

  • Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently. (MDEV-35018arrow-up-right)

  • 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-33658arrow-up-right)

  • Fix possibly wrong result using a degenerated subquery (SELECT <expr>) with window function (MDEV-35869arrow-up-right)

  • The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error (MDEV-20281arrow-up-right)

  • Fix debian-start script failure when using non-standard socket path (MDEV-35907arrow-up-right)

  • wsrep_sst_mariadb-backup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours (MDEV-35749arrow-up-right)

  • Replicate_* fields in Show-Slave-Status may be truncated, impacting replication monitoring. (MENT-2238)

  • 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-35910arrow-up-right)

  • NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures (MDEV-34665arrow-up-right)

  • Cloning of table statistics while saving the InnoDB table stats is now avoided (MDEV-35363arrow-up-right)

Changelog

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

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.6.21-17 is provided for:

  • AlmaLinux 8 (x86_64, ARM64)

  • AlmaLinux 9 (x86_64, ARM64)

  • Debian 11 (x86_64, ARM64)

  • Debian 12 (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, PPC64LE)

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

  • Ubuntu 22.04 (x86_64, ARM64)

  • Ubuntu 24.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 Policiesarrow-up-right for details.

Installation Instructions

Upgrade Instructions

This page is: Copyright © 2025 MariaDB. All rights reserved.

spinner

Last updated

Was this helpful?