All pages
Powered by GitBook
1 of 1

Loading...

Release Notes for MariaDB Enterprise Server 10.3.31-13

This thirteenth release of10.3 is a maintenance release. This release includes a variety of fixes.

MariaDB Enterprise Server 10.3.31-13 was released on 2021-09-14.

Fixed Security Vulnerabilities

CVE (with link)

CVSS base sore

Backported Features

This release of MariaDB Enterprise Server includes features backported from MariaDB Enterprise Server 10.6.

  • Enhanced consistency for Semi-Sync Replication

    • When , consistency is guaranteed for a Primary server in an HA (Primary/Replica) topology when using semi-synchronous replication. ()

    • Prior to this release, when using semi-synchronous replication, if a Primary crashed before sending a transaction to the Replica, on restart, the Primary could recover incomplete InnoDB transactions when rejoining as a Replica.

Notable Changes

  • Galera updated to 25.3.34

  • ARM64 is now supported for several .

  • The script wsrep_sst_mariadb-backup checks all server-related configuration groups when processing a configuration file. ()

  • Prior to this release, only the [mysqld

Issues Fixed

Can result in data loss

  • When an statement is executed with ALGORITHM=INSTANT, a warning is not raised when the operation causes the default value of a DATE column to be truncated. ()

Can result in a * hang or crash

  • Possible server crash when pushing a WHERE condition over a mergeable derived table / view / CTE DT into a grouping view / derived table / CTE V whose item list contained set functions with constant arguments. ()

  • Server crashes on the second execution of a stored procedure or a prepared statement when the corresponding query executes a window function on a view, CTE, or derived table. ()

  • Server crashes are possible when executing a prepared statement with a hanging recursive CTE. ()

Can result in unexpected behavior

  • When fails after dropping the table, the DROP TABLE operation is not written into the binary log. ()

  • The statement does not quote role names properly for the DEFAULT ROLE. ()

  • The utility reports errors for freed pages. ()

As a result of this issue, a Joiner node writes the following error to the MariaDB Error Log:

  • With MariaDB Enterprise Cluster, when is set, rsync for a new SST process may be killed rather than the rsync for the old SST process. ()

  • With MariaDB Enterprise Cluster, the WSREP threads could write warnings about foreign keys to the MariaDB Error Log when wsrep_debug is not enabled. ()

    • In prior releases, the following warning could be written to the log:InnoDB: WSREP: referenced FK check fail: Lock wait index

Interface Changes

  • information schema table added

  • information schema table added

  • system variable default value changed from DEFAULT to "" (empty)

Platforms

In alignment with the , MariaDB Enterprise Server 10.3.31-13 is provided for:

  • CentOS 7 (x86_64)

  • CentOS 8 (x86_64, ARM64)

  • Debian 9 (x86_64, ARM64)

  • Debian 10 (x86_64, ARM64)

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

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

With this release, when using semi-synchronous replication and with , incomplete transactions will be rolled-back on the Replica, ensuring the new Primary (former Replica) and new Replica (former Primary) remain in sync.
] configuration group was checked when processing a configuration file.
  • MariaDB Enterprise Backup expects to stream a backup using the included mbstream utility. (MDEV-15730)

  • Prior to this release, MariaDB Enterprise Backup expected , even though the xbstream utility had been renamed to mbstream.

  • InnoDB no longer acquires advisory file locks by default. (MDEV-24393)

  • The table has been added and can be used to view details about SQL keywords. (MDEV-25129)

  • The table has been added and can be used to view details about built-in functions. (MDEV-25129)

  • When using data-at-rest encryption with the encryption plugin, InnoDB will automatically disable key rotation checks. (MDEV-14180)

    • The encryption plugin does not support key rotation, so key rotation checks are not required.

    • In previous releases, unnecessary key rotation checks with the plugin could reduce performance, unless they were explicitly disabled by setting .

  • Server crashes while executing a query with a CTE in a prepared statement or stored procedure. (MDEV-26025)
  • Server crashes while executing a query with a recursive CTE that is indirectly used twice. (MDEV-26202)

  • Server crashes due to infinite recursion while processing an embedded recursive CTE with missing RECURSIVE. (MDEV-26095)

  • Server crashes in InnoDB deadlock checker under high load. (MDEV-25594)

  • Server crashes when a virtual generated column has a prefix index. (MDEV-26220)

  • Server crashes are possible when using virtual generated columns. (MDEV-18166, MDEV-18249)

  • Server crashes while executing when a column is truncated. (MDEV-17890)

  • Server crashes while executing when a hostname cannot be resolved. (MDEV-26081)

  • Server crashes when a subquery references an outer column in an ORDER BY clause. (MDEV-25629)

  • Server crashes due to a stack overrun in the query optimizer while executing a query with more than 32 equality conditions that compare columns of different tables (such as tableX.colX=tableY.colY). (MDEV-17783)

  • Server crashes when a window function is the left expression of an IN(SELECT ..) subquery. (MDEV-25630)

  • Possible deadlock on a Replica server using GTID Replication when and , , or is executed. (MDEV-17515)

  • Server crashes when fails on an InnoDB table. (MDEV-25721)

  • Server crashes while executing on an InnoDB table with a Full-Text Index. (MDEV-25663)

  • Server crashes while executing on an InnoDB table with virtual generated columns that are indexed. (MDEV-25872)

  • Server crashes while executing when is enabled. (MDEV-25886)

  • Crash when parsing query using derived table containing table value constructors (MDEV-25484)

  • Server crashes when a connection is killed while executing after previously locking the table with . (MDEV-17749)

  • Server crashes when the global value of the system variable is set using a stored function that reads the value of another global system variable. (MDEV-16481)

  • When an unknown column is referenced in the WHERE clause of a recursive CTE, the query sometimes succeeds instead of failing with an . (MDEV-26189)

  • Reusing CTE inside a function fails with the error code. (MDEV-23886)

  • Several fixes for MariaDB Enterprise Cluster (Galera) SST scripts. (MDEV-20580, MDEV-25818, MDEV-25759, MDEV-25719, MDEV-15639, MDEV-15371, MDEV-18797, MENT-1170, MDEV-24979, MDEV-21192)

  • With MariaDB Enterprise Cluster, when , MariaDB Enterprise Backup does not inherit server options set by the Environment systemd configuration parameter. (MDEV-24962)

  • With MariaDB Enterprise Cluster, when is set, and and/or are set to custom paths, the rsync SST does not copy the binary log index. (MDEV-25978)

  • PRIMARY
    table
    schema
    .
    child_table`` Starting with this release, the WSREP threads will only write warnings about foreign keys to the MariaDB Error Log when wsrep_debug is enabled.
  • The statement may check the wrong maximum column length. (MDEV-26203)

  • The storage engine handles ">=" as ">" in some cases, where multi-column indexes are used. (MDEV-25985)

  • The system variable does not work correctly with the authentication plugin. (MDEV-25641)

  • The "Condition pushdown into derived table" optimization cannot be applied if the expression being pushed refers to a derived table column, which is computed from an expression that has a stored function call, @session variable reference, or other similar construct. (MDEV-25969)

  • A query that uses ORDER BY .. LIMIT clause and Range checked for each record optimization could produce incorrect results. (MDEV-25858)

  • An aborted statement is logged in the binary log and replicated to the Replica server. (MDEV-22530)

  • shows an execution plan different from the plan actually executed. (MDEV-25682)

  • shows an execution plan different from actually executed. (MDEV-25682)

  • Wrong result when selecting from views, derived tables, or CTEs with the form (SELECT .. LIMIT <n>) ORDER BY .. (MDEV-25679)

  • For system-versioned tables, the statement displays the system-invisible row_end column as part of the primary key. (MDEV-16857)

  • For system-versioned tables partitioned by SYSTEM_TIME``, overflowing the partitions can lead to incorrect results from queries. (MDEV-22247)

  • For tables, statements that use CASE WHEN .. THEN can result in a syntax error. (MDEV-24760)

  • For tables, statements that use the JSON_EXTRACT() function in the WHERE clause can result in a syntax error. (MDEV-24517)

  • For tables, statements that call native functions using remove_str (such as ) fail with the error code. (MDEV-24020)

  • For tables, server-side prepared statements (created by and executed by ) incorrectly turn unsigned integer literals into signed integers. (MDEV-25808)

  • For tables, statements that use the function fail with the error code. (MDEV-24523)

  • Red Hat Enterprise Linux 7 (x86_64)
  • Red Hat Enterprise Linux 8 (x86_64, ARM64)

  • SUSE Linux Enterprise Server 12 (x86_64)

  • SUSE Linux Enterprise Server 15 (x86_64, ARM64)

  • Ubuntu 18.04 (x86_64, ARM64)

  • Ubuntu 20.04 (x86_64, AM64)

  • Microsoft Windows (x86_64)

  • 5.9

    CVE-2021-4666

    5.5

    CVE-2021-4658

    5.5

    CVE-2021-4657

    5.5

    CVE-2021-2372

    4.4

    MDEV-21117
    platforms
    MDEV-25669
    MDEV-25971
    MDEV-25635
    MDEV-25565
    MDEV-26135
    MDEV-25595
    MDEV-26080
    MDEV-25361
    MDEV-25880
    MDEV-26062
    enterprise lifecycle
    MariaDB Corporation Engineering Policies
    cve.org
    CVE-2021-2389
    tail: cannot open 'mysql-bin.index' for reading: No such file or directory
    wsrep_sst_method=rsync
    wsrep_sst_method=mariadb-backup
    wsrep_sst_method=rsync
    MariaDB Enterprise Server
    rpl_semi_sync_slave_enabled=ON
    ALTER TABLE ... ADD COLUMN
    CREATE OR REPLACE TABLE
    SHOW GRANTS
    innochecksum
    KEYWORDS
    SQL_FUNCTIONS
    system_versioning_asof
    rpl_semi_sync_slave_enabled=ON
    --stream=mbstream
    --stream=xbstream
    information_schema.KEYWORDS
    information_schema.SQL_FUNCTIONS
    file_key_management
    file_key_management
    file_key_management
    innodb_encryption_rotate_key_age=0
    DELETE
    YEAR
    SET ROLE
    slave_parallel_mode=optimistic
    OPTIMIZE TABLE
    REPAIR TABLE
    ANALYZE TABLE
    ALTER TABLE .. ADD FULLTEXT INDEX
    TRUNCATE
    ALTER TABLE
    CHECK TABLE
    innodb_read_only
    ALTER TABLE
    LOCK TABLE
    system_versioning_asof
    ER_BAD_FIELD_ERROR
    ER_NO_SUCH_TABLE
    log-bin
    log-bin-index
    CREATE INDEX
    Spider
    max_password_errors
    ed25519
    OPTIMIZE TABLE
    EXPLAIN
    EXPLAIN
    SHOW INDEX
    SELECT
    Spider
    SELECT
    Spider
    SELECT
    Spider
    UPDATE
    TRIM()
    ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
    Spider
    PREPARE
    EXECUTE
    Spider
    JSON_REPLACE()
    ER_SP_DOES_NOT_EXIST