All pages
Powered by GitBook
1 of 1

Loading...

Release Notes for MariaDB Enterprise Server 10.4.17-10

This tenth release of is a maintenance release. This release includes security fixes.

MariaDB Enterprise Server 10.4.17-10 was released on 2020-12-14.

Fixed Security Vulnerabilities

CVE (with link)

CVSS base score

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

Notable Changes

  • Galera wsrep library updated to 26.4.6 in .

  • In alignment with the , this release does not include CentOS 6.x and RHEL 6.x packages.

  • The audit plugin (not ) did not log proxy users. The new plugin version 2.0.3 introduces an event sub-type PROXY_CONNECT for event type CONNECT. ()

did not log proxy users. The new plugin version 2.0.3 introduces an event sub-type PROXY_CONNECT for event type . (MENT-977)

  • On connect, if a proxy user is used, an extra line will be logged: TIME,HOSTNAME,user,localhost,ID,0,PROXY_CONNECT,test,plug_dest@%,0

  • The event type can also be used in filters "connect_event": ["CONNECT","DISCONNECT","PROXY_CONNECT"]

  • Performance improvements for comparisons of temporal data types with temporal literals. ()

Issues Fixed

Can result in data loss

  • Data corruption possible for encrypted tables if the non-default option is used. (MENT-910)

  • Temporary tables created by the user or the system can overwrite existing files on creation. ()

  • Table can disappear after command if is used before altering a child table to remove a primary key. ()

  • Server crashes on an instant ALTER TABLE .. MODIFY

Can result in a hang or crash

  • persistent stats analyze forces full scan which results in a lock crash. (MENT-1024)

  • hang on with error message Semaphore wait has lasted > 300 seconds. (MENT-1007)

  • Server crash can happen on filesort with a setting for to a value lower than the default of 64 ()

Can result in unexpected behavior

  • Defining a view with SQL syntax ISNULL(ID)=0 incorrectly returns a syntax error. (MENT-1015)

  • reports an error that it cannot find an Aria log file './aria_log.00000000' (MENT-907)

  • failure for incremental backups. ()

Interface Changes

  • system variable default value changed from ON to OFF

  • system variable added

  • command-line option added

  • system variable maximum value changed from 200 to 1048576 to 1048576

Platforms

In alignment with the , MariaDB Enterprise Server 10.4.17-10 is provided for:

  • Red Hat Enterprise Linux 7

  • Red Hat Enterprise Linux 8

  • CentOS 7

  • CentOS 8

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

Note

In alignment with the , this release does not include CentOS 6.x and RHEL 6.x packages.

Installation Instructions

Upgrade Instructions

On connect, if a proxy user is used, an extra line will be logged: TIME,HOSTNAME,user,localhost,ID,0,PROXY_CONNECT,test,plug_dest@%,0
  • Better MariaDB GTID support for the option. (MDEV-19264)

  • New global variable (MDEV-16952)

  • The new parameter --include-unsupported for the script mariadb_es_repo_setup can be used to enable a repository of unsupported packages in the repository configuration. The repository currently includes the CONNECT Storage Engine. The storage engine can be installed by yum install MariaDB-connect-engine or apt-get install mariadb-plugin-connect-engine (MENT-1003)

  • Back port of a MariaDB Server 10.5 feature to not acquire record locks when covering table locks exist. (MENT-403)

  • Change by default. (MDEV-23720)

  • Performance improvements for comparisons of temporal data types. (MDEV-23537)
    of a column from
    "not null" to "null"
    . A virtual column must exist in the table. (
    )
  • One instant including multiple RENAME for indexes can corrupt the index cache. (MDEV-23356)

  • A rolling upgrade for from 10.3 to 10.4 can result in data loss. (MDEV-22723)

  • DELETE .. FOR PORTION OF statement accepts non-constant FROM .. TO clause. This contradicts the documentation and is inconsistent with the behavior of the statement. (MDEV-22596)

  • Potential stack overflow in fulltext search with a complex MATCH .. AGAINST string. (MDEV-23999)

  • mariadb-backup can hang if the server goes idle after a particular kind of redo log write. (MDEV-23982)

  • A server crash can occur when encryption is enabled for temporary tables () and queries use window functions. (MDEV-23867)

  • A crash of MariaDB Server is possible when binary logging is activated, caused by improper raising of an error or replication checksum. (MDEV-23832)

  • assertion on after ALTER-TABLE|ALTER TABLE .. DISCARD TABLESPACE (MDEV-23705)

  • Server crashes after failed attempt to create unique key on virtual column. (MDEV-23685)

  • Possible server crash when using an index on a spatial data type with InnoDB. (MDEV-23600)

  • Possible server crash when a string function is used for a column of type and the string function is used in a subquery which is returning a row. (MDEV-23535)

  • node can crash on high , , or load from many connections executed on the same table with foreign keys. (MDEV-23557)

  • Server crashes if a query is executed on an table with a foreign key where the foreign key was removed while using . This case should result in an SQL error. (MDEV-23470)

  • Recursive procedure call ends with a crash instead of SQL error. (MDEV-23463)

  • fails to open the table during removal of VIRTUAL column DDL while using , due to lack of referenced index. (MDEV-23387)

  • Server crash when altering a table after its tablespace has been discarded already. (MDEV-22939)

  • caused a variety of non-determinism failures if the given position did not exist. (MDEV-22473)

  • SET GLOBAL ``replicate_do_db = DEFAULT causes a crash. (MDEV-20744)

  • JSON_MERGE_PATCH(json_doc, json_doc [, json_doc] ...) can crash if the first parameter is set to NULL and the second is not valid JSON. (MDEV-20593)

  • Server crashes after with ON DELETE SET NULL for foreign key and a virtual column in index. (MDEV-20396)

  • Server can crash on a prepared statement executed via . (MDEV-19838)

  • Crash on on a table that contains indexed virtual columns. (MDEV-18366)

  • Possible server crash for queries using the window function (MDEV-15180)

  • Server crash can occur when is used. (MDEV-23534)

  • Possible crash when using Spider Tables and partitions. (MDEV-20100)

  • crashes. (MENT-1011)

  • node crash with Galera message Assertion server_state_.rollback_mode() == wsrep::server_state::rm_async' failed`. in the error log. (MENT-937)

  • Galera node crashes or hangs during IST if the connection between donor and joiner is unstable or if cluster configuration changes take place at the same time. (MENT-514)

  • crash if bulk updates are executed on Galera. (MDEV-23872)

  • Possible server crash with executed on a system versioned table, if variable system_versioning_asof was set to a value of type instead of . (MDEV-23562)

  • Server crash when SELECT WSREP_LAST_SEEN_GTID() while Galera replication is not enabled (wsrep-on=OFF). (MDEV-23466)

  • Server crash if function FORMAT(num, decimal_position[, locale]) is used with a decimal_position > 30. ([MDEV-23415](https://jira.mariadb.org/browse/MDEV-23415))

  • Multiple calls to a Stored Procedure from another Stored Procedure crashes server. (MDEV-23094)

  • Server crash when an invalid is set. (MDEV-23092)

  • Server hang if TABLE LOCK is used after BACKUP LOCK was used. (MDEV-22879)

  • Server crash on table updates using FOR PORTION OF (MDEV-22805)

  • Assertion on executing with a prepared statement using when is on and is TOI (MDEV-22681)

  • Server crash if a transaction is started with SET SESSION wsrep_on=1, but the global is 0 (MDEV-22443)

  • crash when used with sharding and XA, and (default). (MDEV-19794)

  • node can crash with an error message WSREP: MDL BF-BF conflict in the error log. The error is related to tables with foreign keys and running or on them. (MDEV-21577)

  • Aborting a query on an table with does not show an SQL error message, if the query could not be aborted. (MDEV-23938)
  • Optimizer has chosen an inefficient plan, if a multi-component index, a second index, and a WHERE or ON clause with conditions over these indexes are used. (MDEV-23811)

  • Some rounding has been done in an unexpected way for decimal numbers. (MDEV-23702)

  • Server crashes after changing at runtime via a statement. (MDEV-23693)

  • Creating a view removes parentheses on expressions from the , which results in wrong results. (MDEV-23656)

  • mysql_tzinfo_to_sql under is slow. (MDEV-23440)

  • UDF cannot be uninstalled if the UDF library file doesn't exist. (MDEV-23327)

  • with type can return an unexpected result, if the given value for "expr" includes many leading zeros. (MDEV-23105)

  • replication broken if only one timezone is loaded. (MDEV-22626)

  • SST donation fails, FLUSH TABLES WITH READ LOCK times out. (MDEV-22543)

  • Memory leaks possible after with FOREIGN KEY (MDEV-22277)

  • SST fails for if data-directory has lost+found directory. (MDEV-21951)

  • caused a variety of non-determinism failures if the given position did not exist. (MDEV-21839)

  • Linux AIO returned OS error 22 if parameters set to innodb_flush_method O_DIRECT and (default). (MDEV-21584)

  • CREATE OR REPLACE TRIGGER in not replicating, if a trigger with the same name already exists. (MDEV-21578)

  • mysqld_multi no longer works with different server binaries. (MDEV-21526)

  • Possible error for incremental backup for encrypted tablespaces. (MDEV-20755)

  • Possible slow server start and stop if full text indexes are used. (MDEV-18867)

  • The parentheses in a VIEW can be defined incorrectly for a combination of = and BETWEEN (MDEV-17408)

  • ER_BASE64_DECODE_ERROR upon replaying binary log. (MDEV-16372)

  • Several IPv6 issues with powered by Galera. (MDEV-21770, MDEV-23576, MDEV-23580, MDEV-23581, MDEV-23574)

  • Subquery on fails with error message. (MENT-1016)

  • A AUTO_INCREMENT does not increment with compound primary key on partitioned table. (MENT-997)

  • CREATE TEMPORARY TABLE .. LIKE () returns error if unique index is defined in the table. (MDEV-23968)

  • CREATE .. SELECT can result in empty result on join versioned table. (MDEV-23799)

  • ErrorERROR 4142 (HY000): SYSTEM_TIME partitions in table t1 does not support historical query upon querying a view, when that view is selecting from the versioned table with partitions. It only happens if the view itself was created using FOR SYSTEM_TIME ALL (MDEV-23779)

  • Disk space not reused for Blob in data file. (MDEV-23072)

  • will not dump sequence definition details on --no-data dump. (MDEV-21786)

  • fails to validate corruption on a table that was corrupted by a bug related to instant ADD or DROP (fixed in MariaDB Enterprise Server 10.3.17, 10.4.7). (MDEV-21251)

  • Subquery execution not terminated after LIMIT ROWS EXAMINED is exceeded. (MDEV-18335)

  • Deadlock between BACKUP STAGE BLOCK_COMMIT and parallel replication. (MDEV-23586)

  • Possible memory leak in galera library. (MDEV-23559)

  • Wrong result of MIN(time_expr) and MAX(time_expr) with GROUP BY (MDEV-23525)

  • Syntax error results in misleading message on about missing system table mysql.proc (MDEV-23518)

  • FORMAT(num, decimal_position [, locale]) where decimal position is 0 or 38 and num is DECIMAL(38,38) returns incorrect results. (MDEV-23118)

  • A query result includes a data row twice depending on the WHERE clause used, if partitioning is used. (MDEV-22246)

  • Assertion after ROLLBACK AND CHAIN (MDEV-22055)

  • mariadb_es_repo_setup curl failed on Ubuntu Focal if ca-certificates is not installed. Now it will prompt an error about missing ca-certificates (MENT-971)

  • Debian 9
  • Debian 10

  • SUSE Linux Enterprise Server 12

  • SUSE Linux Enterprise Server 15

  • Ubuntu 16.04

  • Ubuntu 18.04

  • Ubuntu 20.04

  • Microsoft Windows

  • 6.5

    CVE-2020-14812

    4.9

    CVE-2020-14789

    4.9

    CVE-2020-14776

    4.9

    CVE-2020-28912

    N/A (Critical)#1

    MariaDB Engineering Policy
    MariaDB Engineering Policy
    MDEV-19443
    MDEV-23551
    MDEV-23569
    MDEV-22934
    MDEV-24033
    MDEV-24026
    enterprise lifecycle
    MariaDB Corporation Engineering Policies.
    MariaDB Engineering Policy
    cve.org
    CVE-2020-14765
    MDEV-23672
    MariaDB Enterprise Cluster
    MariaDB Enterprise Cluster
    MariaDB Enterprise Cluster
    MariaDB Enterprise Cluster
    MariaDB Enterprise Cluster
    wsrep_provider
    wsrep_on
    wsrep_osu_method
    wsrep_on
    MariaDB Enterprise Cluster
    Galera
    Galera
    MariaDB Enterprise Cluster
    Galera cluster
    MariaDB Enterprise Cluster
    MariaDB MariaDB Connector/ODBC
    MariaDB Enterprise Server 10.4
    MariaDB Enterprise Audit
    MariaDB Enterprise Audit
    CONNECT
    InnoDB
    innodb_background_scrub_data_uncompressed=ON
    ALTER TABLE
    SET FOREIGN_KEY_CHECKS=0
    InnoDB
    InnoDB
    INSERT
    max_sort_length
    MariaDB Enterprise Backup
    MariaDB Enterprise Backup
    innodb_log_optimize_ddl
    innodb_max_purge_lag_wait
    mariadbd
    --innodb-max-purge-lag-wait
    performance_schema_digests_size
    MariaDB Enterprise Server 10.4
    Enterprise Cluster Topology with MariaDB Enterprise Server 10.4
    Primary/Replica Topology with MariaDB Enterprise Server 10.4
    Enterprise Spider Sharded Topology with MariaDB Enterprise Server 10.4
    Upgrade to MariaDB Enterprise Server 10.4
    Upgrade from MariaDB Community Server to MariaDB Enterprise Server 10.4
    mariadb-backup
    --slave-info
    InnoDB
    innodb_max_purge_lag_wait
    InnoDB
    innodb_log_optimize_ddl=OFF
    ALTER TABLE
    UPDATE
    InnoDB
    encrypt_tmp_files=ON
    InnoDB
    TRUNCATE
    DATETIME
    INSERT
    DELETE
    UPDATE
    InnoDB
    FOREIGN_KEY_CHECKS=0
    InnoDB
    FOREIGN_KEY_CHECKS=0
    SHOW BINLOG EVENTS FROM ...
    DELETE
    SELECT
    SELECT
    NTH_VALUE()
    SET GLOBAL replicate_do_table
    MariaDB Enterprise Audit
    SELECT
    DATE
    DATETIME
    CREATE TABLE
    EXECUTE IMMEDIATE
    Spider
    spider_internal_xa=OFF
    OPTIMIZE
    REPAIR
    InnoDB
    KILL QUERY
    innodb_buffer_pool_size
    SET
    SELECT
    InnoDB
    CAST(expr AS type)
    DECIMAL
    ALTER TABLE
    MariaDB Enterprise Backup
    SHOW BINLOG EVENTS FROM ...
    innodb_use_native_aio=1
    --prepare
    information_schema
    system versioned table
    mysqldump
    CHECK TABLE
    SHOW CREATE PROCEDURE
    Enterprise Spider Federated Topology with MariaDB Enterprise Server 10.4

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