All pages
Powered by GitBook
1 of 1

Loading...

Release Notes for MariaDB Enterprise Server 10.5.10-7

MariaDB Enterprise Server 10.5.10-7 is a Stable (GA) maintenance release of MariaDB Enterprise Server 10.5, released on 2021-06-14

This seventh release of MariaDB Enterprise Server 10.5 is a maintenance release. This release includes a variety of fixes.

MariaDB Enterprise Server 10.5.10-7 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. ()

  • 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 or after 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

  • SUM column from a derived table returns invalid values. ()

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

Changes in Storage Engines

  • This release incorporates MariaDB ColumnStore storage engine version 5.6.1 (before 2021-06-30).

  • This release incorporates MariaDB ColumnStore storage engine version 5.6.2 (after 2021-06-30).

Interface Changes

  • information schema table schema adds LEVEL column

  • mariadb-backup --innodb-force-recovery 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.5.10-7 is provided for:

  • AlmaLinux 8 (x86_64, ARM64)

  • AlmaLinux 9 (x86_64, ARM64)

  • Debian 11 (x86_64, ARM64)

  • Debian 12 (x86_64, ARM64)

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)

  • New field LEVEL exists in table to differentiate between column-level and table-level CHECK constraints. (MDEV-24601)

  • Remove useless counter (MDEV-25211)

  • Possible corruption in online for with (MDEV-24730)

  • DELETE HISTORY may delete current data on system versioned table. (MDEV-25468)

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

  • Killing server during may lose transaction. (MDEV-25305)

  • recovery can fail with [ERROR] InnoDB: Not applying INSERT_REUSE_REDUNDANT due to corruption if is set to a different value than none (MENT-1208)

  • can report [ERROR] InnoDB: Flagged corruption of .. in table ... in CHECK TABLE; Wrong count if is set to a different value than none (MENT-1218)

  • Server crashes in check_grant upon invoking function with userstat 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)

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

  • 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 IN() clause that references the UNION of two table values constructed with the 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 crashes 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 mysql.user 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 crash in thd_clear_errors() (MDEV-23542)

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

  • Server crashes when an statement is executed, is set to NBO, and sql_mode is set to the empty string (''). (MENT-1134)

  • MariaDB Enterprise Cluster can crash when total order isolation (TOI) is used for Galera and is executed with ENGINE= using an unknown engine. Only happens with (no engine substitution). (MDEV-24833)

  • MariaDB Enterprise Backup crashes during --prepare. (MDEV-24848)

  • Server crashes when , , or is executed on an table and is set to a value other than none (MDEV-25018)

  • Server hangs during checkpoint when is executed. (MDEV-24302)

  • MariaDB Enterprise Cluster conflict resolution issues. (MDEV-24989, MDEV-25405, MDEV-25427)

  • Shutdown crash during innodb.innodb_buffer_pool_resize_temporary (MDEV-25483)

  • MariaDB Enterprise Cluster crashes after with multiple tables. Only seen if (MENT-1144)

  • Server hangs on early shutdown if InnoDB needs to purge indexed virtual columns. (MENT-1206)

  • 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 [[|MIN|MIN()]] 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 Enterprise Backup fails when the option was set on the command-line with no value at server startup. (MDEV-24903)

  • Race condition between persistent statistics and or [-TRUNCATE|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 =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 Enterprise Backup fails --prepare on large backup. (MDEV-24197)

  • State snapshot transfer (SST) for MariaDB Enterprise Cluster using 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 Enterprise Backup fails when the 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 InnoDB group commit has been written to it. (MDEV-24526)

  • 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 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 system-versioned table always fails with Error 1072 (MDEV-24690)

  • [ALTER TABLE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements-and-structure/sql-statements/data-definition/alter/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 system-versioned table. (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 mariadb-dump causes shutdown of donor node to fail. (MDEV-25423)

  • MariaDB Enterprise Spider 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 mysql.server_audit_filters data load error when enabling server audit log through configuration file. (MENT-1196)

  • [ALTER TABLE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements-and-structure/sql-statements/data-definition/alter/alter-table) .. IMPORT TABLESPACE fails after DROP INDEX (MDEV-25265)

  • Upgrade to 10.5.9 breaks root user ability to GRANT (MDEV-25030)

  • shows 0 for I/O statistics that were previously removed. (MDEV-15756)

  • adaptive flushing fails to start when is exceeded. (MDEV-25093)

  • Replica server fails with ER_ROW_IS_REFERENCED_2 when DROP TABLE parent_table, child_table is executed on the primary server and foreign_key_checks is enabled. (MDEV-25530)

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

  • Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.5

  • Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.5

  • CVE-2021-2166

    4.9

    CVE-2021-2154

    4.9

    MDEV-13467
    Galera
    MDEV-25106
    MDEV-24763
    ER_NO_SUCH_TABLE_IN_ENGINE
    ER_CRASHED_ON_USAGE
    MDEV-24532
    mariadb-backup|MariaDB Enterprise Backup
    MDEV-25221
    KILL CONNECTION
    KILL QUERY
    MariaDB Enterprise Cluster
    MDEV-18874
    MariaDB Enterprise Cluster
    MDEV-24978
    MDEV-25121
    MDEV-23291
    MDEV-24790
    MDEV-24860
    ER_BAD_FIELD_ERROR
    enterprise lifecycle
    MariaDB Corporation Engineering Policies
    MariaDB Enterprise Server
    10
    .5
    10
    cve.org
    MariaDB Enterprise Cluster
    MDEV-25553
    MDEV-25002
    wsrep_provider_options
    wsrep_on
    wsrep_on
    wsrep_osu_method
    wsrep_osu_method=NBO
    ST_DISTANCE_SPHERE()
    innodb_checksum_algorithm
    ALTER TABLE
    InnoDB
    InnoDB
    ALTER
    InnoDB
    BLOB
    TEXT
    VARCHAR
    innodb_flush_method=O_DIRECT
    CAST('0e1111111111' AS DECIMAL(38,0))
    SET STATEMENT
    CHECK_CONSTRAINTS
    ST_DISTANCE_SPHERE
    Enterprise Cluster Topology with MariaDB Enterprise Server
    .5
    Primary/Replica Topology with MariaDB Enterprise Server 10.5
    ColumnStore Object Storage Topology with MariaDB Enterprise Server 10.5
    and MariaDB Enterprise ColumnStore 23.02
    Upgrade to MariaDB Enterprise Server 10.5
    Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.5
    INFORMATION_SCHEMA.CHECK_CONSTRAINTS
    Innodb_buffered_aio_submitted
    ALTER TABLE
    InnoDB
    ROW_FORMAT=REDUNDANT
    Aria
    RESET MASTER
    MyRocks
    InnoDB
    innodb_change_buffering
    InnoDB
    innodb_change_buffering
    --default-character-set
    --character-sets-dir
    dropping a table
    InnoDB
    UPDATE
    INSERT
    REPLACE
    InnoDB
    UPDATE
    InnoDB
    mysql.innodb_index_stats
    mysql.innodb_table_stats
    InnoDB
    SHOW TABLES
    InnoDB
    VALUES()
    SELECT
    VALUES()
    SELECT
    VALUES()
    DEFAULT()
    BLOB
    SELECT
    Information Schema
    SELECT
    information_schema.innodb_sys_columns
    InnoDB
    SELECT
    SELECT
    CREATE VIEW .. SELECT
    log_slave_updates
    InnoDB
    InnoDB
    CREATE VIEW
    InnoDB ALTER
    ALTER TABLE
    ALTER TABLE
    sql_mode=''
    DROP TABLE
    TRUNCATE
    ALTER TABLE
    InnoDB
    innodb_change_buffering
    InnoDB
    RESET MASTER
    OPTIMIZE TABLE
    MAX()
    --log-bin
    RENAME TABLE
    ANALYZE TABLE
    error log
    CHECK TABLE
    InnoDB
    IN()
    EXPLAIN
    BIT
    optimizer_use_condition_selectivity
    EXPLAIN
    ST_GeomFromGeoJSON
    --innodb
    ALTER TABLE
    FLUSH LOGS
    InnoDB
    InnoDB
    SELECT
    REPLACE
    InnoDB
    InnoDB
    RENAME TABLE
    InnoDB
    EXPLAIN
    VALUES()
    slave_compressed_protocol
    information_schema.routines
    INFORMATION_SCHEMA.OPTIMIZER_TRACE
    ALTER TABLE
    sql_safe_updates
    SET PASSWORD
    SHOW ENGINE INNODB STATUS
    InnoDB
    innodb_adaptive_flushing_lwm
    ColumnStore Shared Local Storage Topology with MariaDB Enterprise Server 10.5
    and MariaDB Enterprise ColumnStore 23.02
    HTAP Topology with MariaDB Enterprise Server 10.5
    and MariaDB Enterprise ColumnStore 23.02
    Single-Node Enterprise ColumnStore 23.02 with MariaDB Enterprise Server 10.5
    and Object Storage
    Single-Node Enterprise ColumnStore 23.02 with MariaDB Enterprise Server 10.5

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