All pages
Powered by GitBook
1 of 1

Loading...

Release Notes for MariaDB Enterprise Server 10.6.12-8

MariaDB Enterprise Server 11.6.12-8 is a Stable (GA) maintenance release of MariaDB Enterprise Server 10.6, released on 2023-05-24

MariaDB Enterprise Server 10.6.12-8 is a Stable (GA) maintenance release of MariaDB Enterprise Server 10.6. This release includes a variety of fixes. Users of MariaDB Enterprise Server 10.6.12-7 are encouraged to upgrade. Additional steps are required if upgrading from Enterprise Server 10.6.12-7 to 10.6.12-8.

The next scheduled maintenance release for MariaDB Enterprise Server is 2023-06-12.

MariaDB Enterprise Server 10.6.12-8 was released on 2023-05-24.

Fixed Security Vulnerabilities

#1: MariaDB CVEs are assigned a word rating instead of a CVSS base score. See the for details.

Upgrade Procedure

MariaDB Enterprise Server 10.6.12-8 has a special upgrade procedure that only applies to users who previously deployed MariaDB Enterprise Server 10.6.12-7.

The following procedure is required to truncate the undo log tablespaces:

  1. Upgrade from ES 10.6.12-7 to 10.6.12-8 using the normal upgrade procedure.

  2. After the server has been started with ES 10.6.12-8, set innodb_fast_shutdown=0:

  1. Shutdown the server:

  1. Change innodb_undo_tablespaces to a different value than its current value:

  1. Start the server:

Notable Changes

  • The optimizer can now use column histogram data when estimating output cardinality of hashed (BNL-H) joins. ()

    • Starting with this release, the has a new flag called hash_join_cardinality that can enable the feature.

    • When enabled, the optimizer uses a formula that provides conservative estimates.

    • To enable this functionality in a given session, set the flag using the

Issues Fixed

Can result in a hang or crash

  • When a prepared statement is used to query a view that contains a UNION, the server can crash. ()

  • When is set and is greater than 0, replica servers can hang if data is inserted into tables with a sequence. ()

    • In previous releases, the replica server would treat full inserts into the sequence as DDL statements, which would cause it to acquire an exclusive lock on the sequence table. If another parallel replication thread is waiting on the lock at the same time, the two threads can deadlock.

Can result in unexpected behavior

  • For certain data distributions, the optimizer histogram code can produce wrong selectivity, which can lead to performance degradation. ()

  • The optimizer does not take into account the selectivity of the equality conditions for Block Nested Hash (BNL-H) joins.

    • In previous releases, this issue can cause mis-estimates and bad query plans when running with set to 3 or higher (the default is 2).

  • InnoDB does not free undo logs when they are no longer needed. ()

    • In the previous release, when is set to 0, the undo logs would be stored in the InnoDB system tablespace (ibdata1 by default), so this issue could cause the InnoDB system tablespace to grow indefinitely.

    • Starting with this release, InnoDB frees undo logs when they are no longer needed.

Changes in Storage Engines

  • This release incorporates MariaDB ColumnStore engine version 23.02.3.

Interface Changes

  • hash_join_cardinality=off has been incrementally added to the default value of the system variable.

Platforms

In alignment to the , MariaDB Enterprise Server 10.6.12-8 is provided for:

  • CentOS 7 (x86_64)

  • Debian 10 (x86_64, ARM64)

  • Debian 11 (x86_64, ARM64)

  • Red Hat Enterprise Linux 7 (x86_64)

Windows packages are not currently available for this release.

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

Installation Instructions

Upgrade Instructions

:
  • Starting with this release, replica servers manage their locks better to avoid deadlocks in this scenario.

  • When InnoDB splits or merges a B-tree page, the server can hang due to a race condition. (MDEV-29835)

  • When InnoDB undo log truncation is enabled by setting innodb_undo_log_truncate=ON, if some undo log tablespace exceeds innodb_max_undo_log_size, the server can hang. (MDEV-30863)

    • In previous releases, InnoDB chooses an undo log tablespace for truncation and marks all the related rollback segments with the state "truncation in progress". When the truncation is completed, InnoDB fails to re-enable the rollback segments. Consequently, if there are further write transactions before the server is shut down, the transactions must wait for usable rollback segments in a busy-loop. Since InnoDB does not re-enable the rollback segments, the transactions wait indefinitely.

    • Starting with this release, InnoDB properly manages the state of rollback segments when InnoDB undo log truncation is enabled.

  • When the lateral derived optimization is used to execute a query, the derived table is re-filled on every incoming row combination, even if the parameter values have not changed. (
    )
  • When is optimistic and is greater than 0, can fail with an out-of-order binlog error if the sequence uses InnoDB. (MDEV-31077)

    • In previous releases, the following error can be raised:

  • For servers that previously ran ES 10.6.12-7, a special procedure is required to truncate the undo log tablespaces after the upgrade is complete.
  • InnoDB history list length increases faster in MariaDB Enterprise Server 10.6 compared to MariaDB Enterprise Server 10.5 for the same load. (MDEV-29401)

  • 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 18.04 (x86_64, ARM64)

  • Ubuntu 20.04 (x86_64, ARM64)

  • Ubuntu 22.04 (x86_64, ARM64)

  • CVE (with cve.org link)

    CVSS base score

    CVE-2022-47015

    N/A (Medium)#1

    MariaDB Engineering Policy
    MDEV-30812
    MDEV-31102
    MDEV-29621
    MDEV-31067
    MDEV-31234
    innodb_undo_tablespaces
    enterprise lifecycle
    MariaDB Corporation Engineering Policies".
    MDEV-26301
    SET GLOBAL innodb_fast_shutdown=0;
    $ sudo systemctl stop mariadb
    [mariadb]
    innodb_undo_tablespaces=4
    $ sudo systemctl start mariadb
    SET optimizer_switch='hash_join_cardinality=on';
    Last_Error: Error 'An attempt was made to binlog GTID 0-1-100 which would create an out-of-order sequence number with existing GTID 0-1-100 and gtid stric mode is enabled' on query. Default database: 'test'. Query: 'alter sequence s1 restart with 1' will be shown.

    The most recent release of MariaDB Enterprise Server 10.6 is:

    MariaDB Enterprise Server 10.6.23-19 Download Now

    optimizer_switch system variable
    binlog_row_image=FULL
    slave_parallel_threads
    join_cache_level
    optimizer_switch
    Deploy MariaDB Enterprise with Repositories
    Deploy MariaDB Enterprise with Package Tarballs
    Deploy MariaDB Enterprise with Docker
    Upgrade to MariaDB Enterprise Server 10.6
    SET statement
    slave_parallel_mode
    slave_parallel_threads
    ALTER SEQUENCE

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