All pages
Powered by GitBook
1 of 1

Loading...

Release Notes for MariaDB Enterprise Server 10.3.29-12

This twelfth release of 10.3 is a maintenance release. This release includes a variety of fixes.

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

  • updated to 25.3.3

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

Issues Fixed

Can result in data loss

  • fails to rename a column in an table and causes the server to crash. The table is not accessible after a 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. ()

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

  • Server crashes when the function is called on a column. (, , )

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

  • Server crashes in optimize_schema_tables_memory_usage after from ()

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 an

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

  • Minor version upgrade does not perform a server restart. ()

Interface Changes

  • command-line option added

  • skip-check-installed command-line option added

  • function added

Platforms

In alignment with the , MariaDB Enterprise Server 10.3.29-12 is provided for:

  • CentOS 7

  • CentOS 8

  • Debian 9

  • Debian 10

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

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

Possible corruption in online for with (MDEV-24730)

  • may delete current data on the . (MDEV-25468)

  • Server crashes in check_grant upon invoking the function with enabled. (MDEV-25242)
  • 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 InnoDB and indexed virtual columns after an error with , , or on virtual columns. (MDEV-24786)

  • conflict resolution issues. (MDEV-24923)

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

  • 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 InnoDB 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 the 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 system tables and a DDL transaction need to be rolled back. (MDEV-25503)

  • Server crashes when tries to fetch data from a 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)

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

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

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

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

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

  • conflict resolution issues. (MDEV-24892)

  • when a subquery contains a
    JOIN
    with an
    ON
    clause that references an outer column. (
    )
  • Query returns an 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 a configuration change. (MDEV-24853)

  • State snapshot transfer (SST) for using 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 (MDEV-25051)

  • Race condition between and STATS_AUTO_RECALC (MDEV-10682)

  • Incorrect message about field length is written to the error log 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)

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

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

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

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

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

  • fails on large backup. (MDEV-24197)

  • State snapshot transfer (SST) for using fails when the password for the backup user is set via the MYSQL_PWD environment variable. (MDEV-25321)

  • State snapshot transfer (SST) for using fails when the option was set on the command-line at server startup. (MDEV-25328)

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

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

  • wrongly checks for the 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 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 InnoDB index is read using Multiversion Concurrency Control (MVCC). (MDEV-25459)

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

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

  • silently enables InnoDB 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)

  • RENAME TABLE causes "Ignoring data file ... with space ID xxxx, since the redo log references ... with space ID xxxx." for . (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)

  • fails to replicate the statement when is enabled. (MDEV-25258)

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

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

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

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

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

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

  • / not logged with MariaDB Audit Plugin. (MDEV-23457)

  • Red Hat Enterprise Linux 7
  • Red Hat Enterprise Linux 8

  • SUSE Linux Enterprise Server 12

  • SUSE Linux Enterprise Server 15

  • Ubuntu 18.04

  • Ubuntu 20.04

  • Microsoft Windows

  • 4.9

    CVE-2021-2154

    4.9

    MDEV-13467
    MDEV-25106
    MDEV-24763
    MDEV-24532
    MDEV-25221
    MDEV-18874
    MDEV-24978
    MDEV-25121
    MDEV-24811
    MDEV-22703
    MDEV-24958
    MDEV-24942
    MDEV-24929
    MDEV-24868
    MDEV-23291
    MDEV-24790
    MDEV-24860
    MDEV-24728
    MDEV-25240
    enterprise lifecycle
    MariaDB Corporation Engineering Policies
    cve.org
    CVE-2021-2166
    MDEV-25002
    Galera
    MariaDB Enterprise Cluster
    MariaDB Enterprise Cluste
    MariaDB Enterprise Cluste
    MariaDB Enterprise Server
    ST_DISTANCE_SPHERE()
    innodb_checksum_algorithm
    ALTER TABLE
    InnoDB
    InnoDB
    ER_NO_SUCH_TABLE_IN_ENGINE
    ER_CRASHED_ON_USAGE
    ALTER
    InnoDB
    MariaDB Enterprise Backup
    KILL CONNECTION
    KILL QUERY
    MariaDB Enterprise Cluster
    BLOB
    TEXT
    VARCHAR
    innodb_flush_method=O_DIRECT
    DEFAULT()
    BLOB
    SELECT
    Information Schema
    SELECT
    information_schema.innodb_sys_columns
    CAST('0e1111111111' AS DECIMAL(38,0))
    SET STATEMENT
    ER_BAD_FIELD_ERROR
    mariadb-backup
    --innodb-force-recovery
    mariadb_repo_setup
    ST_DISTANCE_SPHERE
    ALTER TABLE
    InnoDB
    ROW_FORMAT=REDUNDANT
    DELETE HISTORY
    system-versioned table
    userstat
    MariaDB Client
    --default-character-set
    --character-sets-dir
    dropping a table
    UPDATE
    INSERT
    REPLACE
    EXISTS
    UPDATE
    InnoDB
    mysql.innodb_index_stats or innodb-system-variables/#innodb_table_stats|mysql.innodb_table_stats
    InnoDB
    SHOW TABLES
    InnoDB
    DROP INDEX
    CREATE INDEX
    InnoDB
    VALUES()
    VALUE()
    SELECT
    VALUES()
    VALUE()
    SELECT
    VALUES()
    VALUE()
    InnoDB
    SELECT
    SELECT
    MariaDB Enterprise Cluster
    ER_BAD_FIELD_ERROR
    MIN()
    MAX()
    MariaDB Enterprise Cluster
    MariaDB Enterprise Cluster
    MariaDB Enterprise Backup
    RENAME TABLE
    TRUNCATE
    ANALYZE TABLE
    CHECK TABLE
    InnoDB
    IN()
    Selectivity
    EXPLAIN
    BIT
    optimizer_use_condition_selectivity=3
    EXPLAIN
    ST_GeomFromGeoJSON
    MariaDB Enterprise Backup
    --prepare
    MariaDB Enterprise Cluster
    MariaDB Enterprise Backup
    MariaDB Enterprise Cluster
    MariaDB Enterprise Backup
    --innodb
    EXPLAIN EXTENDED
    ALTER TABLE
    FLUSH LOGS
    InnoDB
    InnoDB
    SELECT
    REPLACE
    InnoDB
    MariaDB Enterprise Cluster
    MariaDB Enterprise Backup
    InnoDB
    MariaDB Enterprise Cluster
    SET PASSWORD
    strict_password_validation
    EXPLAIN
    VALUES()
    VALUE()
    split_materialized
    system-versioned table
    ER_VERS_DUPLICATE_ROW_START_END
    ER_DUP_ENTRY
    system-versioned table
    slave_compressed_protocol
    |information_schema.routines
    CREATE PROCEDURE
    DROP PROCEDURE