> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/enterprise-server/old-releases/10.4/10.4.19-12.md).

# Release Notes for MariaDB Enterprise Server 10.4.19-12

This twelfth release of MariaDB Enterprise Server 10.4 is a maintenance release. This release includes a variety of fixes.

MariaDB Enterprise Server 10.4.19-12 was released on 2021-06-14.

## Fixed Security Vulnerabilities

| CVE (with [cve.org](https://cve.mitre.org/) link)                             | CVSS base score |
| ----------------------------------------------------------------------------- | --------------- |
| [CVE-2021-2166](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2021-2166) | 4.9             |
| [CVE-2021-2154](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2021-2154) | 4.9             |

## Notable Changes

* New function [ST\_DISTANCE\_SPHERE()](/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st_distance_sphere.md) calculates the spherical distance between two geometries (point or multipoint) on a sphere. ([MDEV-13467](https://jira.mariadb.org/browse/MDEV-13467))
* Galera updated to 26.4.8
* Issue deprecation warnings for [innodb\_checksum\_algorithm](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_checksum_algorithm) values `none, innodb, strict_none, strict_innodb` ([MDEV-25106](https://jira.mariadb.org/browse/MDEV-25106))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) avoids unnecessary rollbacks with streaming replication. ([MDEV-25553](https://jira.mariadb.org/browse/MDEV-25553))
* Improved TLS/SSL error reporting. ([MDEV-21730](https://jira.mariadb.org/browse/MDEV-21730))

## Issues Fixed

### Can result in data loss

* [ALTER TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) fails to rename a column in [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) table and causes server to crash. [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) table is not accessible after restart. ([MDEV-24763](https://jira.mariadb.org/browse/MDEV-24763))
* Table corruption ER\_NO\_SUCH\_TABLE\_IN\_ENGINE or ER\_CRASHED\_ON\_USAGE after ALTER on [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) table with foreign key. ([MDEV-24532](https://jira.mariadb.org/browse/MDEV-24532))
* [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md) deletes the current source file after a No space left on device error, before exiting. Only the incomplete target file is still available. ([MDEV-25221](https://jira.mariadb.org/browse/MDEV-25221))
* Possible corruption in online [ALTER TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) for [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) with ROW\_FORMAT=REDUNDANT ([MDEV-24730](https://jira.mariadb.org/browse/MDEV-24730))
* [DELETE HISTORY](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/delete.md#delete-history) may delete current data on [system-versioned table](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md). ([MDEV-25468](https://jira.mariadb.org/browse/MDEV-25468))
* Encrypted transactional [Aria](/docs/server/server-usage/storage-engines/aria.md) tables remain corrupt after crash recovery, automatic repair does not work. ([MDEV-17913](https://jira.mariadb.org/browse/MDEV-17913))

### Can result in a hang or crash

* Possible hang when [KILL CONNECTION](/docs/server/reference/sql-statements/administrative-sql-statements/kill.md) or [KILL QUERY](/docs/server/reference/sql-statements/administrative-sql-statements/kill.md) is used with [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) and a multi-master setup ([MDEV-18874](https://jira.mariadb.org/browse/MDEV-18874))
* Possible memory corruption with [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) when inserting values bigger than 4096 bytes into variable-length fields ([BLOB](/docs/server/reference/data-types/string-data-types/blob.md), [TEXT](/docs/server/reference/data-types/string-data-types/text.md), [VARCHAR](/docs/server/reference/data-types/string-data-types/varchar.md), and related types). ([MDEV-24978](https://jira.mariadb.org/browse/MDEV-24978))
* [innodb\_flush\_method=O\_DIRECT](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_flush_method) fails on compressed tables. ([MDEV-25121](https://jira.mariadb.org/browse/MDEV-25121))
* Server crashes in `check_grant` upon invoking function with [userstat](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics.md#userstat) enabled. ([MDEV-25242](https://jira.mariadb.org/browse/MDEV-25242))
* [Mariadb client](/docs/server/clients-and-utilities/mariadb-client.md) crashes when [--default-character-set](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-options.md) is set and [--character-sets-dir](/docs/server/server-management/variables-and-modes/server-system-variables.md#character_sets_dir) is undefined. ([MDEV-24879](https://jira.mariadb.org/browse/MDEV-24879))
* Possible Server crash when [dropping a table](/docs/server/server-usage/tables/drop-table.md). Only seen when using a table space per table and if the tablespace size is increased at the time of the drop. ([MDEV-20648](https://jira.mariadb.org/browse/MDEV-20648))
* Possible server hang with [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) and indexed virtual columns after an error with [UPDATE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/update.md), [INSERT](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert.md), [REPLACE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replace.md) on virtual columns. ([MDEV-24786](https://jira.mariadb.org/browse/MDEV-24786))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) conflict resolution issues. ([MDEV-24923](https://jira.mariadb.org/browse/MDEV-24923))
* Index count mismatch due to aborted `FULLTEXT INDEX` ([MDEV-25200](https://jira.mariadb.org/browse/MDEV-25200))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) node crashes when inserting a row into a table that contains a virtual column and does not have a primary key. ([MDEV-25047](https://jira.mariadb.org/browse/MDEV-25047))
* Server crashes when [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) fails to add a new index on a new virtual column and a concurrent connection executes a query that accesses the freed virtual column. ([MDEV-24971](https://jira.mariadb.org/browse/MDEV-24971))
* [EXISTS](/docs/server/reference/sql-statements/data-manipulation/selecting-data/subqueries/subqueries-and-exists.md) subquery with correlation in `ON` expression crashes. ([MDEV-25407](https://jira.mariadb.org/browse/MDEV-25407))
* Server crashes in `row_undo_mod_clust_low` upon rollback of read-only transaction. ([MDEV-25457](https://jira.mariadb.org/browse/MDEV-25457))
* Server crashes on the second execution of a stored procedure when the stored procedure uses an invalid multi-table [UPDATE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/update.md) statement to update a view. ([MDEV-24823](https://jira.mariadb.org/browse/MDEV-24823))
* [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) startup hangs when a recovered transaction exists for the [mysql.innodb\_index\_stats](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-options.md) or [mysql.innodb\_table\_stats](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-options.md) system tables and a DDL transaction needs to be rolled back. ([MDEV-25503](https://jira.mariadb.org/browse/MDEV-25503))
* Server crashes when [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) tries to fetch data from table containing a `FULLTEXT INDEX` and the table's tablespace was discarded. ([MDEV-25536](https://jira.mariadb.org/browse/MDEV-25536))
* Server crashes on [SHOW TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables.md) when a WHERE condition references a derived table. ([MDEV-21603](https://jira.mariadb.org/browse/MDEV-21603))
* Potential hang in [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) purge when virtual indexed columns exist. (MENT-1203)
* After [DROP INDEX](/docs/server/reference/sql-statements/data-definition/drop/drop-index.md) or [CREATE INDEX](/docs/server/reference/sql-statements/data-definition/create/create-index.md), change buffer entries for secondary indexes are lost on [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) restart. (MENT-1217)
* Crash with nested table value constructors. ([MDEV-22786](https://jira.mariadb.org/browse/MDEV-22786))
* Server crashes when an aggregate function is called on a table value constructed with the [VALUES()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/values-value.md) or [VALUE()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/values-value.md) functions. ([MDEV-24919](https://jira.mariadb.org/browse/MDEV-24919))
* Server crashes when a [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md) statement has a subquery that references a table value constructed with the [VALUES()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/values-value.md) or [VALUE()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/values-value.md) functions. ([MDEV-24910](https://jira.mariadb.org/browse/MDEV-24910))
* Server crashes when a [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md) statement has an [IN()](/docs/server/reference/sql-structure/operators/comparison-operators/in.md) clause that references the `UNION` of two table values constructed with the VALUES() or VALUE() functions. ([MDEV-24840](https://jira.mariadb.org/browse/MDEV-24840))
* Possible memory corruption or crash if a table definition is evicted from the cache during a transaction commit. ([MDEV-24811](https://jira.mariadb.org/browse/MDEV-24811))
* Server crashes when the [DEFAULT()](/docs/server/reference/sql-functions/secondary-functions/information-functions/default.md) function is called on a [BLOB](/docs/server/reference/data-types/string-data-types/blob.md) column. ([MDEV-22703](https://jira.mariadb.org/browse/MDEV-22703), [MDEV-24958](https://jira.mariadb.org/browse/MDEV-24958), [MDEV-24942](https://jira.mariadb.org/browse/MDEV-24942))
* Server crashes when a [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md) statement queries an [Information Schema](/docs/server/reference/system-tables/information-schema.md) table and uses a JOIN ([MDEV-24929](https://jira.mariadb.org/browse/MDEV-24929))
* Server crash in optimize\_schema\_tables\_memory\_usage after [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md) from [information\_schema.innodb\_sys\_columns](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_columns-table.md) ([MDEV-24868](https://jira.mariadb.org/browse/MDEV-24868))
* Server crashes when a `FULLTEXT INDEX` is added to an [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) table and the tablespace for the table was previously discarded. ([MDEV-25070](https://jira.mariadb.org/browse/MDEV-25070))
* Server crashes when the optimizer incorrectly removes a `GROUP BY` from a subquery, because the column is specified in both the [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md) list and the `GROUP BY` list. ([MDEV-24925](https://jira.mariadb.org/browse/MDEV-24925))
* Server crashes when a [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md) statement has a subquery in the FROM clause that contains a `GROUP BY` clause and multiple indexes are used: one index is used to resolve the `GROUP BY` clause and another index is used for the LATERAL DERIVED optimization. ([MDEV-23723](https://jira.mariadb.org/browse/MDEV-23723))
* Crash with [CREATE VIEW](/docs/server/server-usage/views/create-view.md) .. [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md) with non-existing field in `ON` condition. ([MDEV-25206](https://jira.mariadb.org/browse/MDEV-25206))
* Server crashes due to an assertion with multi-master workloads on [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) when [log\_slave\_updates](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md) is disabled and a conflicting transaction is aborted for a higher priority transaction. ([MDEV-24954](https://jira.mariadb.org/browse/MDEV-24954))
* Possible hang when [KILL CONNECTION](/docs/server/reference/sql-statements/administrative-sql-statements/kill.md) or [KILL QUERY](/docs/server/reference/sql-statements/administrative-sql-statements/kill.md) is used with [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) and a multi-master setup. ([MDEV-24967](https://jira.mariadb.org/browse/MDEV-24967))
* Possible memory corruption when streaming replication is used for [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/). ([MDEV-24964](https://jira.mariadb.org/browse/MDEV-24964))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) node crashes when the [mysql.user](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-user-table.md) system table is truncated. ([MDEV-24865](https://jira.mariadb.org/browse/MDEV-24865))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) node crashes when [wsrep\_provider\_options](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_provider_options) set to `NULL` ([MDEV-24856](https://jira.mariadb.org/browse/MDEV-24856))
* Server crashes when a column is dropped from an [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) table with the `INSTANT` algorithm. ([MDEV-25057](https://jira.mariadb.org/browse/MDEV-25057))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) node crashes when `CREATE TABLE t1 ( .. ) SELECT .. FROM t2` is executed where `t1` is an [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) table and `t2` is a non-InnoDB table. ([MDEV-21697](https://jira.mariadb.org/browse/MDEV-21697))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) node crashes when an uncommitted transaction is replicated using streaming replication while [wsrep\_on](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_on) is enabled and the transaction is committed while [wsrep\_on](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_on) is disabled. ([MDEV-25226](https://jira.mariadb.org/browse/MDEV-25226))
* Server crashes with [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) when a non-InnoDB table is locked with the [LOCK TABLE](/docs/server/reference/sql-statements/transactions/lock-tables.md) statement and a concurrent connections executes [CREATE VIEW](/docs/server/server-usage/views/create-view.md) that references the same table. ([MDEV-22227](https://jira.mariadb.org/browse/MDEV-22227))
* Possible server crash after failing instant [InnoDB ALTER](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) on secondary indexes. ([MDEV-25360](https://jira.mariadb.org/browse/MDEV-25360))
* Server crashes in `thd_clear_errors()` ([MDEV-23542](https://jira.mariadb.org/browse/MDEV-23542))
* [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md) crashes when called without parameters on Windows. ([MDEV-24106](https://jira.mariadb.org/browse/MDEV-24106))
* Server crashes during crash recovery when freed pages exist in the tablespace of an encrypted [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) table. Also affects [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md) during [--prepare](/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options.md#prepare) ([MDEV-24792](https://jira.mariadb.org/browse/MDEV-24792))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) conflict resolution issues. ([MDEV-25579](https://jira.mariadb.org/browse/MDEV-25579), [MDEV-24980](https://jira.mariadb.org/browse/MDEV-24980), [MDEV-25378](https://jira.mariadb.org/browse/MDEV-25378))

### Can result in unexpected behavior

* `SUM` column from a derived table returns invalid values. ([MDEV-23291](https://jira.mariadb.org/browse/MDEV-23291))
* [CAST('0e1111111111' AS DECIMAL(38,0))](/docs/server/reference/sql-functions/string-functions/cast.md) returns an incorrect result. ([MDEV-24790](https://jira.mariadb.org/browse/MDEV-24790))
* Incorrect behavior of [SET STATEMENT](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-statement.md) when it is executed as a prepared statement. ([MDEV-24860](https://jira.mariadb.org/browse/MDEV-24860))
* Query returns a ER\_BAD\_FIELD\_ERROR error when a subquery contains a `JOIN` with an `ON` clause that references an outer column. ([MDEV-25002](https://jira.mariadb.org/browse/MDEV-25002))
* Query returns a ER\_BAD\_FIELD\_ERROR error when a Common Table Expression (CTE) contains a `UNION` ([MDEV-24597](https://jira.mariadb.org/browse/MDEV-24597))
* Query returns wrong result when the [MIN()](/docs/server/reference/sql-functions/aggregate-functions/min.md) or [MAX()](/docs/server/reference/sql-functions/aggregate-functions/max.md) aggregate functions are used and the aggregated column is indexed. ([MDEV-25112](https://jira.mariadb.org/browse/MDEV-25112))
* Wrong result (extra rows and wrong values) with incremental block nested loop hash. ([MDEV-21104](https://jira.mariadb.org/browse/MDEV-21104))
* Query returns wrong results when a JOIN is evaluated using the Block Nested Loop Hash (BLNH) optimization with a compound index. ([MDEV-24767](https://jira.mariadb.org/browse/MDEV-24767))
* Server fails to start using `mysqld_multi` with `mysqld_safe` options. ([MDEV-21039](https://jira.mariadb.org/browse/MDEV-21039))
* Duplicate key may be generated during [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) configuration change. ([MDEV-24853](https://jira.mariadb.org/browse/MDEV-24853))
* State snapshot transfer (SST) for [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) using [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md) fails when the --log-bin option was set on the command-line with no value at server startup. ([MDEV-24903](https://jira.mariadb.org/browse/MDEV-24903))
* Race condition between persistent statistics and [RENAME TABLE](/docs/server/reference/sql-statements/data-definition/rename-table.md) or TRUNCATE ([MDEV-25051](https://jira.mariadb.org/browse/MDEV-25051))
* Race condition between [ANALYZE TABLE](/docs/server/reference/sql-statements/table-statements/analyze-table.md) and `STATS_AUTO_RECALC` ([MDEV-10682](https://jira.mariadb.org/browse/MDEV-10682))
* Incorrect message about field length is written to the [error log](/docs/server/server-management/server-monitoring-logs/error-log.md) when [CHECK TABLE](/docs/server/reference/sql-statements/table-statements/check-table.md) is executed on an [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) table. ([MDEV-24748](https://jira.mariadb.org/browse/MDEV-24748))
* No error is returned when the optimizer removes a redundant part of a subquery that contains an unknown table alias. For example, if the optimizer removes a redundant `GROUP BY` clause from an [IN()](/docs/server/reference/sql-structure/operators/comparison-operators/in.md) subquery, unknown table aliases in the redundant part are ignored. ([MDEV-23449](https://jira.mariadb.org/browse/MDEV-23449))
* Selectivity shown with [EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain.md) in field `"filter"` is incorrect for [BIT](/docs/server/reference/data-types/numeric-data-types/bit.md) columns. ([MDEV-22583](https://jira.mariadb.org/browse/MDEV-22583))
* Histogram statistics are used even with optimizer\_use\_condition\_selectivity=3 ([MDEV-19474](https://jira.mariadb.org/browse/MDEV-19474))
* [EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain.md) shows nonsensical value for `key_len` with `type=index` ([MDEV-11172](https://jira.mariadb.org/browse/MDEV-11172))
* SSL connection fails when server and client certs are signed by same CA. ([MDEV-23740](https://jira.mariadb.org/browse/MDEV-23740))
* Wrong function name in error messages upon [ST\_GeomFromGeoJSON](/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_geomfromgeojson.md) call. ([MDEV-25272](https://jira.mariadb.org/browse/MDEV-25272))
* [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md) fails [--prepare](/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options.md#prepare) on large backup. ([MDEV-24197](https://jira.mariadb.org/browse/MDEV-24197))
* State snapshot transfer (SST) for [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) using [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md) fails when the password for the backup user is set via the `MYSQL_PWD` environment variable. ([MDEV-25321](https://jira.mariadb.org/browse/MDEV-25321))
* State snapshot transfer (SST) for [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) using [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md) fails when the [--innodb](/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options.md#innodb) option was set on the command-line at server startup. ([MDEV-25328](https://jira.mariadb.org/browse/MDEV-25328))
* An extra warning is returned when the EXPLAIN EXTENDED statement is executed in a prepared statement. ([MDEV-25108](https://jira.mariadb.org/browse/MDEV-25108))
* Complex query in stored procedure returns wrong results. ([MDEV-25182](https://jira.mariadb.org/browse/MDEV-25182))
* [ALTER TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) wrongly checks for field's default value if `AFTER` is used. ([MDEV-25403](https://jira.mariadb.org/browse/MDEV-25403))
* Incorrect name resolution for subqueries in ON expressions. ([MDEV-25362](https://jira.mariadb.org/browse/MDEV-25362))
* When [FLUSH LOGS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md) is executed, a race condition between [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) group commit and binary log rotation causes the old binary log file to become obsolete before the [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) group commit has been written to it. ([MDEV-24526](https://jira.mariadb.org/browse/MDEV-24526))
* [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md) logs an error instead of a warning when it reads an invalid log block checksum during a [--backup](/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-options.md#backup). ([MDEV-25456](https://jira.mariadb.org/browse/MDEV-25456))
* Rows are wrongly omitted when an [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) index is read using Multiversion Concurrency Control (MVCC). ([MDEV-25459](https://jira.mariadb.org/browse/MDEV-25459))
* [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md) aborts after failed [REPLACE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replace.md) into table with virtual column. ([MDEV-24583](https://jira.mariadb.org/browse/MDEV-24583))
* [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) fails to fetch index type when index mismatch happens. ([MDEV-22928](https://jira.mariadb.org/browse/MDEV-22928))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) silently enables [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) Monitor output and never disables it when a `wsrep` slave thread tries to perform a brute-force (BF) kill, but fails due to a long lock wait. ([MDEV-25319](https://jira.mariadb.org/browse/MDEV-25319))
* [RENAME TABLE](/docs/server/reference/sql-statements/data-definition/rename-table.md) causes `"Ignoring data file ... with space ID xxxx, since the redo log references ... with space ID xxxx."` for [MariaDB Enterprise Backup](/docs/server/server-usage/backup-and-restore/mariadb-enterprise-backup.md). ([MDEV-25568](https://jira.mariadb.org/browse/MDEV-25568))
* The Replication Heartbeat binary log event (`Heartbeat_log_event`) uses 4 bytes to store the log position within the current binary log file, so the log position overflows when the binary log file size exceeds 4 GB. ([MDEV-16146](https://jira.mariadb.org/browse/MDEV-16146))
* [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) spatial indexes miss large geometry fields. (MENT-1205)
* Table alias from previous statement interferes with later commands. (MENT-1200)
* [EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/explain.md) statement does not show details about sub-queries when the primary table is a table value constructed with the [VALUES()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/values-value.md) or [VALUE()](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/values-value.md) functions. ([MDEV-24936](https://jira.mariadb.org/browse/MDEV-24936))
* `JOIN` of a materialized derived table returns wrong result when the split\_materialized optimization is enabled. ([MDEV-25128](https://jira.mariadb.org/browse/MDEV-25128))
* Uninitialized value upon `CREATE .. SELECT .. VALUE` and variety of resulting errors with different engines. ([MDEV-24710](https://jira.mariadb.org/browse/MDEV-24710))
* Dropping primary key column from a [system-versioned table](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md) always fails with Error 1072 ([MDEV-24690](https://jira.mariadb.org/browse/MDEV-24690))
* `ALTER TABLE .. ADD COLUMN .. AS ROW START` returns misleading [ER\_VERS\_DUPLICATE\_ROW\_START\_END](/docs/server/reference/error-codes/mariadb-error-codes-4100-to-4199/e4134.md) error. ([MDEV-25172](https://jira.mariadb.org/browse/MDEV-25172))
* Unexpected [ER\_DUP\_ENTRY](/docs/server/reference/error-codes/mariadb-error-codes-1000-to-1099/e1062.md) error when the Primary Key column is dropped from a [system-versioned table](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md). ([MDEV-25327](https://jira.mariadb.org/browse/MDEV-25327))
* [slave\_compressed\_protocol](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md) doesn't work properly with semi-sync replication. ([MDEV-24773](https://jira.mariadb.org/browse/MDEV-24773))
* Sequence created by one connection remains invisible to another. ([MDEV-24545](https://jira.mariadb.org/browse/MDEV-24545))
* `routine_definition` in [information\_schema.routines](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-routines-table.md) loses tablename if it starts with an \_ and is not backticked. ([MDEV-25501](https://jira.mariadb.org/browse/MDEV-25501))
* `JOIN` of a derived table using an aggregation function returns incorrect results. (MENT-1210)
* Server temporarily consumes extra 4 GB of memory every time the [INFORMATION\_SCHEMA.OPTIMIZER\_TRACE](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-optimizer_trace-table.md) table is queried. ([MDEV-24975](https://jira.mariadb.org/browse/MDEV-24975))
* [ALTER TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) not replicated with [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/). ([MDEV-24956](https://jira.mariadb.org/browse/MDEV-24956))
* The setting [sql\_safe\_updates](/docs/server/server-management/variables-and-modes/server-system-variables.md#sql_safe_updates) can result in unexpected warnings when using [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/). ([MDEV-21402](https://jira.mariadb.org/browse/MDEV-21402))
* The [SET PASSWORD](/docs/server/reference/sql-statements/account-management-sql-statements/set-password.md) statement fails with [ER\_MUST\_CHANGE\_PASSWORD](/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1862.md) when the statement is executed in a prepared statement and the user's password is expired. ([MDEV-25197](https://jira.mariadb.org/browse/MDEV-25197))
* [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) [FLUSH SSL](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md) command doesn't reload wsrep cert. (MENT-1089)
* State snapshot transfer (SST) for [MariaDB Enterprise Cluster](https://mariadb.com/docs/galera-cluster/) using [mariadb-dump](/docs/server/clients-and-utilities/backup-restore-and-import-clients/mariadb-dump.md) causes shutdown of donor node to fail. ([MDEV-25423](https://jira.mariadb.org/browse/MDEV-25423))
* [MariaDB Enterprise Spider](/docs/server/server-usage/storage-engines/spider.md) returns `The connect info 'tab' for table is too long` when creating a Spider Table. ([MDEV-22265](https://jira.mariadb.org/browse/MDEV-22265))
* `garbd` has connection issues. (MENT-1168)
* [Galera](https://mariadb.com/docs/galera-cluster/) startup log shows [mysql.server\_audit\_filters](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-servers-table.md) data load error when enabling server audit log through configuration file. (MENT-1196)

### Related to install and upgrade

* Missing `libsepol` dependency on SLES 12 and SLES 15. (MENT-1163)
* `caching_sha2_password.so` isn't included in Debian packages. ([MDEV-24728](https://jira.mariadb.org/browse/MDEV-24728))

## Interface Changes

* [mariadb-backup](/docs/server/server-usage/backup-and-restore/mariadb-backup.md) [--innodb-force-recovery](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_force_recovery) command-line option added
* mariadb\_repo\_setup --skip-check-installed command-line option added
* [ST\_DISTANCE\_SPHERE](/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st_distance_sphere.md) function added

## Platforms

In alignment with the [enterprise lifecycle](/docs/release-notes/enterprise-server/about/enterprise-server-lifecycle.md), MariaDB Enterprise Server 10.4.19-12 is provided for:

* CentOS 7 (x86\_64)
* Debian 10 (x86\_64, ARM64)
* Microsoft Windows (x86\_64) (MariaDB Enterprise Cluster excluded)
* Red Hat Enterprise Linux 7 (x86\_64)
* Red Hat Enterprise Linux 8 (x86\_64, ARM64)
* Rocky Linux 8 (x86\_64, ARM64 Red Hat Enterprise Linux 8 packages)
* SUSE Linux Enterprise Server 12 (x86\_64)
* SUSE Linux Enterprise Server 15 (x86\_64, ARM64)
* Ubuntu 20.04 (x86\_64, ARM64)

Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see [MariaDB Corporation Engineering Policies".](https://mariadb.com/engineering-policies).

## Installation Instructions

* [MariaDB Enterprise Server 10.4](/docs/server/architecture/topologies/single-node-topologies/enterprise-server.md)
* [Enterprise Cluster Topology with MariaDB Enterprise Server 10.4](/docs/server/architecture/topologies/galera-cluster.md)
* [Primary/Replica Topology with MariaDB Enterprise Server 10.4](/docs/server/architecture/topologies/primary-replica.md)
* [Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.4](/docs/server/architecture/topologies/mariadb-enterprise-spider-topologies/sharded-mariadb-enterprise-spider-topology.md)
* [Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.4](/docs/server/architecture/topologies/mariadb-enterprise-spider-topologies/federated-mariadb-enterprise-spider-topology.md)

## Upgrade Instructions

* Upgrade to MariaDB Enterprise Server 10.4
* [Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.4](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-on-linux/upgrading-between-major-mariadb-versions.md)

<sub>*This page is: Copyright © 2026 MariaDB. All rights reserved.*</sub>

{% @marketo/form formid="4316" formId="4316" %}
