All pages
Powered by GitBook
1 of 1

Loading...

Release Notes for MariaDB Enterprise Server 10.2.38-12

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

MariaDB Enterprise Server 10.2.38-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

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)

  • caching_sha2_password.so isn't included in Debian packages. ()

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

Interface Changes

  • command-line option added

  • command-line option added

  • function added

Platforms

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

  • CentOS 7

  • CentOS 8

  • Debian 9

  • Red Hat Enterprise Linux 7

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

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

Server crashes in check_grant upon invoking function with enabled. (MDEV-25242)
  • MariaDB Client crashes when --default-character-set is set and --character-sets-dir 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)

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

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

  • fails on large backup. (MDEV-24197)

  • State snapshot transfer (SST) for MariaDB Enterprise Cluster using MariaDB Enterprise Server 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 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 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)

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

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

  • MariaDB Enterprise Cluster fails to replicate statement when is enabled. (MDEV-25258)

  • Red Hat Enterprise Linux 8
  • SUSE Linux Enterprise Server 12

  • SUSE Linux Enterprise Server 15

  • Ubuntu 18.04

  • Microsoft Windows

  • 4.9

    CVE-2021-2154

    4.9

    MDEV-13467
    Galera
    MDEV-24763
    ER_NO_SUCH_TABLE_IN_ENGINE
    ER_CRASHED_ON_USAGE
    MDEV-24532
    MDEV-25221
    MariaDB Enterprise Cluster
    MDEV-18874
    MariaDB Enterprise Cluster
    MDEV-24978
    MDEV-25121
    MDEV-23291
    MDEV-24790
    SET STATEMENT
    MDEV-24860
    ER_BAD_FIELD_ERROR
    MDEV-24728
    MDEV-25240
    enterprise lifecycle
    "MariaDB Corporation Engineering Policies".
    cve.org
    CVE-2021-2166
    MDEV-25002
    ST_DISTANCE_SPHERE()
    ALTER TABLE
    InnoDB
    InnoDB
    ALTER
    InnoDB
    MariaDB Enterprise Backup
    KILL CONNECTION
    KILL QUERY
    BLOB
    TEXT
    VARCHAR
    innodb_flush_method=O_DIRECT
    CAST('0e1111111111' AS DECIMAL(38,0))
    mariadb-backup --innodb-force-recovery
    mariadb_repo_setup --skip-check-installed
    ST_DISTANCE_SPHERE
    userstat
    dropping a table
    InnoDB
    UPDATE
    INSERT
    REPLACE
    InnoDB
    UPDATE
    InnoDB
    mysql.innodb_index_stats
    mysql.innodb_table_stats
    InnoDB
    SHOW TABLES
    InnoDB
    DROP INDEX
    CREATE INDEX
    MIN()
    MAX()
    MariaDB Enterprise Backup
    RENAME TABLE
    TRUNCATE
    ANALYZE TABLE
    error log
    CHECK TABLE
    InnoDB
    IN()
    EXPLAIN
    BIT
    optimizer_use_condition_selectivity=3
    EXPLAIN
    ST_GeomFromGeoJSON
    MariaDB Enterprise Backup
    --prepare
    MariaDB Enterprise Backup
    --innodb
    EXPLAIN EXTENDED
    ALTER TABLE
    FLUSH LOGS
    InnoDB
    InnoDB
    MariaDB Enterprise Backup
    InnoDB
    SELECT
    REPLACE
    InnoDB
    RENAME TABLE
    MariaDB Enterprise Backup
    InnoDB
    SET PASSWORD
    strict_password_validation