All pages
Powered by GitBook
1 of 1

Loading...

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

CVSS base score

Notable Changes

  • New function calculates the spherical distance between two geometries (point or multipoint) on a sphere. ()

  • Galera updated to 26.4.8

  • Issue deprecation warnings for values none, innodb, strict_none, strict_innodb ()

Issues Fixed

Can result in data loss

  • fails to rename a column in table and causes server to crash. table is not accessible after restart. ()

  • Table corruption ER_NO_SUCH_TABLE_IN_ENGINE or ER_CRASHED_ON_USAGE after ALTER on table with foreign key. ()

  • deletes the current source file after a No space left on device error, before exiting. Only the incomplete target file is still available. ()

Can result in a hang or crash

  • Possible hang when or is used with and a multi-master setup ()

  • Possible memory corruption with when inserting values bigger than 4096 bytes into variable-length fields (, , , and related types). ()

  • fails on compressed tables. ()

Can result in unexpected behavior

  • SUMcolumn from a derived table returns invalid values. ([MDEV-23291](https://jira.mariadb.org/browse/MDEV-23291))

  • returns an incorrect result. ()

  • Incorrect behavior of when it is executed as a prepared statement. ()

  • Query returns a

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. ()

Interface Changes

  • command-line option added

  • mariadb_repo_setup --skip-check-installed command-line option added

  • function added

Platforms

In alignment with the , 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)

Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see .

Installation Instructions

Upgrade Instructions

avoids unnecessary rollbacks with streaming replication. (
)
  • Improved TLS/SSL error reporting. (MDEV-21730)

  • Possible corruption in online for with ROW_FORMAT=REDUNDANT (MDEV-24730)
  • DELETE HISTORY may delete current data on . (MDEV-25468)

  • Encrypted transactional tables remain corrupt after crash recovery, automatic repair does not work. (MDEV-17913)

  • Server crashes in check_grant upon invoking function with enabled. (MDEV-25242)
  • MariaDB Client crashes when is set and is undefined. (MDEV-24879)

  • Possible Server crash when . Only seen when using a table space per table and if the tablespace size is increased at the time of the drop. (MDEV-20648)

  • Possible server hang with and indexed virtual columns after an error with , , on virtual columns. (MDEV-24786)

  • MariaDB Enterprise Cluster conflict resolution issues. (MDEV-24923)

  • Index count mismatch due to aborted FULLTEXT INDEX (MDEV-25200)

  • MariaDB Enterprise Cluster node crashes when inserting a row into a table that contains a virtual column and does not have a primary key. (MDEV-25047)

  • Server crashes when 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)

  • subquery with correlation in ON expression crashes. (MDEV-25407)

  • Server crashes in row_undo_mod_clust_low upon rollback of read-only transaction. (MDEV-25457)

  • Server crashes on the second execution of a stored procedure when the stored procedure uses an invalid multi-table statement to update a view. (MDEV-24823)

  • startup hangs when a recovered transaction exists for the or system tables and a DDL transaction needs to be rolled back. (MDEV-25503)

  • Server crashes when tries to fetch data from table containing a FULLTEXT INDEX and the table's tablespace was discarded. (MDEV-25536)

  • Server crashes on when a WHERE condition references a derived table. (MDEV-21603)

  • Potential hang in purge when virtual indexed columns exist. (MENT-1203)

  • After or , change buffer entries for secondary indexes are lost on restart. (MENT-1217)

  • Crash with nested table value constructors. (MDEV-22786)

  • Server crashes when an aggregate function is called on a table value constructed with the or VALUE() functions. (MDEV-24919)

  • Server crashes when a statement has a subquery that references a table value constructed with the or VALUE() functions. (MDEV-24910)

  • Server crashes when a statement has an clause that references the UNION of two table values constructed with the VALUES() or VALUE() functions. (MDEV-24840)

  • Possible memory corruption or crash if a table definition is evicted from the cache during a transaction commit. (MDEV-24811)

  • Server crashes when the function is called on a column. (MDEV-22703, MDEV-24958, MDEV-24942)

  • Server crashes when a statement queries an table and uses a JOIN (MDEV-24929)

  • Server crash in optimize_schema_tables_memory_usage after from (MDEV-24868)

  • Server crashes when a FULLTEXT INDEX is added to an table and the tablespace for the table was previously discarded. (MDEV-25070)

  • Server crashes when the optimizer incorrectly removes a GROUP BY from a subquery, because the column is specified in both the list and the GROUP BY list. (MDEV-24925)

  • Server crashes when a 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)

  • Crash with .. with non-existing field in ON condition. (MDEV-25206)

  • Server crashes due to an assertion with multi-master workloads on MariaDB Enterprise Cluster when is disabled and a conflicting transaction is aborted for a higher priority transaction. (MDEV-24954)

  • Possible hang when KILL CONNECTION or KILL QUERY is used with MariaDB Enterprise Cluster and a multi-master setup. (MDEV-24967)

  • Possible memory corruption when streaming replication is used for MariaDB Enterprise Cluster. (MDEV-24964)

  • MariaDB Enterprise Cluster node crashes when the system table is truncated. (MDEV-24865)

  • MariaDB Enterprise Cluster node crashes when set to NULL (MDEV-24856)

  • Server crashes when a column is dropped from an table with the INSTANT algorithm. (MDEV-25057)

  • MariaDB Enterprise Cluster node crashes when CREATE TABLE t1 ( .. ) SELECT .. FROM t2 is executed where t1 is an table and t2 is a non-InnoDB table. (MDEV-21697)

  • MariaDB Enterprise Cluster node crashes when an uncommitted transaction is replicated using streaming replication while is enabled and the transaction is committed while is disabled. (MDEV-25226)

  • Server crashes with MariaDB Enterprise Cluster when a non-InnoDB table is locked with the LOCK TABLE statement and a concurrent connections executes that references the same table. (MDEV-22227)

  • Possible server crash after failing instant on secondary indexes. (MDEV-25360)

  • Server crashes in thd_clear_errors() (MDEV-23542)

  • MariaDB Enterprise Backup crashes when called without parameters on Windows. (MDEV-24106)

  • Server crashes during crash recovery when freed pages exist in the tablespace of an encrypted table. Also affects [[mariadb-backup|MariaDB Enterprise Backup]] during --prepare (MDEV-24792)

  • MariaDB Enterprise Cluster conflict resolution issues. (MDEV-25579, MDEV-24980, MDEV-25378)

  • error when a subquery contains a
    JOIN
    with an
    ON
    clause that references an outer column. (
    )
  • Query returns a ER_BAD_FIELD_ERROR error when a Common Table Expression (CTE) contains a UNION (MDEV-24597)

  • Query returns wrong result when the or aggregate functions are used and the aggregated column is indexed. (MDEV-25112)

  • Wrong result (extra rows and wrong values) with incremental block nested loop hash. (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)

  • Server fails to start using mysqld_multi with mysqld_safe options. (MDEV-21039)

  • Duplicate key may be generated during MariaDB Enterprise Cluster configuration change. (MDEV-24853)

  • State snapshot transfer (SST) for MariaDB Enterprise Cluster using [[mariadb-backup|MariaDB Enterprise Backup]] fails when the --log-bin option was set on the command-line with no value at server startup. (MDEV-24903)

  • Race condition between persistent statistics and or TRUNCATE (MDEV-25051)

  • Race condition between and STATS_AUTO_RECALC (MDEV-10682)

  • Incorrect message about field length is written to the when is executed on an table. (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 subquery, unknown table aliases in the redundant part are ignored. (MDEV-23449)

  • Selectivity shown with in field "filter" is incorrect for columns. (MDEV-22583)

  • Histogram statistics are used even with optimizer_use_condition_selectivity=3 (MDEV-19474)

  • shows nonsensical value for key_len with type=index (MDEV-11172)

  • SSL connection fails when server and client certs are signed by same CA. (MDEV-23740)

  • Wrong function name in error messages upon call. (MDEV-25272)

  • [[mariadb-backup|MariaDB Enterprise Backup]] fails --prepare on large backup. (MDEV-24197)

  • State snapshot transfer (SST) for MariaDB Enterprise Cluster using [[mariadb-backup|MariaDB Enterprise Backup]] fails when the password for the backup user is set via the MYSQL_PWD environment variable. (MDEV-25321)

  • State snapshot transfer (SST) for MariaDB Enterprise Cluster using [[mariadb-backup|MariaDB Enterprise Backup]] fails when the --innodb option was set on the command-line at server startup. (MDEV-25328)

  • An extra warning is returned when the EXPLAIN EXTENDED statement is executed in a prepared statement. (MDEV-25108)

  • Complex query in stored procedure returns wrong results. (MDEV-25182)

  • wrongly checks for field's default value if AFTER is used. (MDEV-25403)

  • Incorrect name resolution for subqueries in ON expressions. (MDEV-25362)

  • When is executed, a race condition between group commit and binary log rotation causes the old binary log file to become obsolete before the group commit has been written to it. (MDEV-24526)

  • [[mariadb-backup|MariaDB Enterprise Backup]] logs an error instead of a warning when it reads an invalid log block checksum during a --backup. (MDEV-25456)

  • Rows are wrongly omitted when an index is read using Multiversion Concurrency Control (MVCC). (MDEV-25459)

  • aborts after failed into table with virtual column. (MDEV-24583)

  • fails to fetch index type when index mismatch happens. (MDEV-22928)

  • MariaDB Enterprise Cluster silently enables 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)

  • causes "Ignoring data file ... with space ID xxxx, since the redo log references ... with space ID xxxx." for [[mariadb-backup|MariaDB Enterprise Backup]]. (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)

  • spatial indexes miss large geometry fields. (MENT-1205)

  • Table alias from previous statement interferes with later commands. (MENT-1200)

  • statement does not show details about sub-queries when the primary table is a table value constructed with the or VALUE() functions. (MDEV-24936)

  • JOIN of a materialized derived table returns wrong result when the split_materialized optimization is enabled. (MDEV-25128)

  • Uninitialized value upon CREATE .. SELECT .. VALUE and variety of resulting errors with different engines. (MDEV-24710)

  • Dropping primary key column from a always fails with Error 1072 (MDEV-24690)

  • ALTER TABLE .. ADD COLUMN .. AS ROW START returns misleading ER_VERS_DUPLICATE_ROW_START_END error. (MDEV-25172)

  • Unexpected ER_DUP_ENTRY error when the Primary Key column is dropped from a . (MDEV-25327)

  • doesn't work properly with semi-sync replication. (MDEV-24773)

  • Sequence created by one connection remains invisible to another. (MDEV-24545)

  • routine_definition in loses tablename if it starts with an _ and is not backticked. (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 table is queried. (MDEV-24975)

  • not replicated with MariaDB Enterprise Cluster. (MDEV-24956)

  • The setting can result in unexpected warnings when using MariaDB Enterprise Cluster. (MDEV-21402)

  • The statement fails with ER_MUST_CHANGE_PASSWORD when the statement is executed in a prepared statement and the user's password is expired. (MDEV-25197)

  • MariaDB Enterprise Cluster FLUSH SSL command doesn't reload wsrep cert. (MENT-1089)

  • State snapshot transfer (SST) for MariaDB Enterprise Cluster using causes shutdown of donor node to fail. (MDEV-25423)

  • returns The connect info 'tab' for table is too long when creating a Spider Table. (MDEV-22265)

  • garbd has connection issues. (MENT-1168)

  • Galera startup log shows data load error when enabling server audit log through configuration file. (MENT-1196)

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

  • Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.4

    4.9

    CVE-2021-2154

    4.9

    MDEV-13467
    MDEV-25106
    MariaDB Enterprise Cluster
    MDEV-24763
    MDEV-24532
    MariaDB Enterprise Backup
    MDEV-25221
    KILL CONNECTION
    KILL QUERY
    MariaDB Enterprise Cluster
    MDEV-18874
    MariaDB Enterprise Cluster
    MDEV-24978
    MDEV-25121
    MDEV-24790
    MDEV-24860
    ER_BAD_FIELD_ERROR
    MDEV-24728
    mariadb-backup
    enterprise lifecycle
    MariaDB Corporation Engineering Policies".
    10
    Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.4
    cve.org
    CVE-2021-2166
    MDEV-25553
    MDEV-25002
    wsrep_provider_options
    wsrep_on
    wsrep_on
    ST_DISTANCE_SPHERE()
    innodb_checksum_algorithm
    ALTER TABLE
    InnoDB
    InnoDB
    InnoDB
    BLOB
    TEXT
    VARCHAR
    innodb_flush_method=O_DIRECT
    CAST('0e1111111111' AS DECIMAL(38,0))
    SET STATEMENT
    --innodb-force-recovery
    ST_DISTANCE_SPHERE
    MariaDB Enterprise Server 10.4
    Enterprise Cluster Topology with MariaDB Enterprise Server
    .4
    Primary/Replica Topology with MariaDB Enterprise Server 10.4
    Upgrade to MariaDB Enterprise Server 10.4
    Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.4
    ALTER TABLE
    InnoDB
    system-versioned table
    Aria
    userstat
    --default-character-set
    --character-sets-dir
    dropping a table
    InnoDB
    UPDATE
    INSERT
    REPLACE
    InnoDB
    EXISTS
    UPDATE
    InnoDB
    mysql.innodb_index_stats
    mysql.innodb_table_stats
    InnoDB
    SHOW TABLES
    InnoDB
    DROP INDEX
    CREATE INDEX
    InnoDB
    VALUES()
    SELECT
    VALUES()
    SELECT
    IN()
    DEFAULT()
    BLOB
    SELECT
    Information Schema
    SELECT
    information_schema.innodb_sys_columns
    InnoDB
    SELECT
    SELECT
    CREATE VIEW
    SELECT
    log_slave_updates
    mysql.user
    InnoDB
    InnoDB
    CREATE VIEW
    InnoDB ALTER
    InnoDB
    MIN()
    MAX()
    RENAME TABLE
    ANALYZE TABLE
    error log
    CHECK TABLE
    InnoDB
    IN()
    EXPLAIN
    BIT
    EXPLAIN
    ST_GeomFromGeoJSON
    ALTER TABLE
    FLUSH LOGS
    InnoDB
    InnoDB
    InnoDB
    SELECT
    REPLACE
    InnoDB
    InnoDB
    RENAME TABLE
    InnoDB
    EXPLAIN
    VALUES()
    system-versioned table
    system-versioned table
    slave_compressed_protocol
    information_schema.routines
    INFORMATION_SCHEMA.OPTIMIZER_TRACE
    ALTER TABLE
    sql_safe_updates
    SET PASSWORD
    mariadb-dump
    MariaDB Enterprise Spider
    mysql.server_audit_filters

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