All pages
Powered by GitBook
1 of 37

Release Notes - MariaDB 10.4 Series

MariaDB 10.4 was a long-term maintenance series of MariaDB maintained until June 2024

MariaDB 10.4 Changes & Improvements

MariaDB 10.4 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

MariaDB 10.4 is a previous major stable version. The first stable release of 10.4 was in June 2019, and it was maintained until June 2024.

Implemented Features

See the Differences in MariaDB Enterprise Server 10.4 page for items that are different between MariaDB Community Server 10.4 and MariaDB Enterprise Server 10.4.

Authentication

  • See Authentication from MariaDB 10.4 for an overview of the changes.

  • The unix_socket authentication plugin is now default on Unix-like systems, which is a major change to authentication in MariaDB (MDEV-12484)

  • User password expiry (MDEV-7597)

  • Account Locking (MDEV-13095)

  • The obsolete mysql.host table is no longer created (MDEV-15851)

  • Much faster privilege checks for MariaDB setups with many user accounts or many database grants (MDEV-15649)

  • mysql.user table is retired. User accounts and global privileges are now stored in the mysql.global_priv table (MDEV-17658)

  • SET PASSWORD support for ed25519 and other authentication plugins (MDEV-12321)

InnoDB

  • Added instant DROP COLUMN and changing of the order of columns (MDEV-15562)

  • More Instant VARCHAR extension or ROW_FORMAT=DYNAMIC and ROW_FORMAT=COMPACT (MDEV-15563)

    • change CHAR(0) to any VARCHAR

    • change a CHAR that is longer than 255 bytes to VARCHAR or wider CHAR

    • change a VARCHAR that is shorter than 128 bytes into any longer VARCHAR

  • Instant collation or charset changes for non-indexed columns (MDEV-15564)

  • Reduced redo log volume for undo tablespace initialization (MDEV-17138)

  • Removed crash-upgrade support for pre-10.2.19 TRUNCATE TABLE (MDEV-13564)

  • Added key rotation for innodb_encrypt_log (MDEV-12041)

  • Implement innodb_checksum_algorithm=full_crc32 (MDEV-12026)

Optimizer

  • Implementation of the optimizer trace, one can enable the optimizer trace by enabling the system variable optimizer_trace (MDEV-6111)

  • Engine Independent Table Statistics is now enabled by default; new default values are use_stat_tables=PREFERABLY_FOR_QUERIES and optimizer_use_condition_selectivity=4 (MDEV-15253)

    • Two new values for the variable use_stat_tables: COMPLEMENTARY_FOR_QUERIES and PREFERABLY_FOR_QUERIES (MDEV-17255)

    • Histograms are now used (but not collected) by default (MDEV-18608).

    • analyze_sample_percentage variable added. The default value is 100 (ANALYZE will use the whole table), but one can also set analyze to only use a sample of table data to collect the statistics.

  • Condition pushdown optimization now has bigger scope:

    • Conditions can be pushed into materialized IN-subqueries (MDEV-12387)

    • Conditions in HAVING clause can be pushed to WHERE. This behavior is controlled through optimizer switch flag condition_pushdown_from_having.

  • The optimizer switch flag optimize_join_buffer_size now defaults to on (MDEV-17903)

  • Rowid Filtering optimization added (MDEV-16188). It is controlled through optimizer switch flag rowid_filter .

Syntax

  • Temporal tables extended with support for application-time periods (MDEV-16973, MDEV-16974, MDEV-16975, MDEV-17082)

  • Support of brackets (parentheses) for specifying precedence in UNION/EXCEPT/INTERSECT operations (MDEV-11953)

  • New FLUSH SSL command to reload SSL certificates without server restart (MDEV-16266)

  • New CAST target — CAST(x AS INTERVAL DAY_SECOND(N)) (MDEV-17776)

  • IF NOT EXISTS clause added to INSTALL PLUGIN and IF EXISTS clause added to UNINSTALL PLUGIN and UNINSTALL SONAME (MDEV-16294)

  • Unique indexes can be created on BLOB or TEXT fields (MDEV-371)

Variables

For a list of all new variables, see System Variables Added in MariaDB 10.4 and Status Variables Added in MariaDB 10.4.

  • Added to the tcp_nodelay system variable (MDEV-16277)

  • Removed the Innodb_pages0_read status variable (MDEV-15705).

  • New sql-mode setting, TIME_ROUND_FRACTIONAL (MDEV-16991)

  • New variable gtid_cleanup_batch_size for determining how many old rows must accumulate in the mysql.gtid_slave_pos table before a background job will be run to delete them.

  • The default for eq_range_index_dive_limit is now 200 (previously 0) (MDEV-18551)

  • core_file on Windows now defaults to ON (MDEV-18439)

Replication

  • Speed up rotation of binary logs, SHOW BINARY LOGS etc with optimizing binary log index file locking (MDEV-19116, MDEV-19117).

  • A new server command, SHUTDOWN WAIT FOR ALL SLAVES, and a new mysqladmin shutdown --wait-for-all-slaves option, are added to instruct the server to wait for the last binlog event to be sent to all connected slaves before shutting down. (MDEV-18450).

Backup

  • BACKUP STAGE allows one to implement very efficient backups with minimal locking. MDEV-5336.

Galera 4

In MariaDB 10.4.2 and later, Galera has been upgraded from Galera 3 to Galera 4.

Galera 4 Versions

The following table lists each version of the Galera 4 wsrep provider, and it lists which version of MariaDB each one was first released in. If you would like to install Galera 4 using yum, apt, or zypper, then the package is called galera-4.

Galera Version
Released in MariaDB Version

Galera Version

Released in MariaDB Version

26.4.21

11.8.1, 11.7.2, 11.4.5,10.11.11, 10.6.21, 10.5.28

26.4.20

11.7.1, 11.6.2, 11.4.4, 11.2.6, 10.11.10, 10.6.20, 10.5.27

26.4.19

11.4.3, 11.2.5, 11.1.6, 10.11.9, 10.6.19, 10.5.26

26.4.18

11.2.4, 11.1.5, 11.0.6, 10.11.8, 10.6.18, 10.5.25, 10.4.34

26.4.16

11.2.2, 11.1.3, 11.0.4, 10.11.6, 10.10.7, 10.6.16, 10.5.23, 10.4.32

26.4.14

10.10.3, 10.9.5, 10.8.7, 10.7.8, 10.6.12, 10.5.19, 10.4.28

26.4.13

10.10.2, 10.9.4, 10.8.6, 10.7.7, 10.6.11, 10.5.18, 10.4.27

26.4.12

10.10.1, 10.9.2, 10.8.4, 10.7.5, 10.6.9, 10.5.17, 10.4.26

26.4.11

10.8.1, 10.7.2, 10.6.6, 10.5.14, 10.4.22

26.4.9

10.6.4, 10.5.12, 10.4.21

26.4.8

10.6.1, 10.5.10, 10.4.19

26.4.7

10.5.9, 10.4.18

26.4.6

10.5.7, 10.4.16

26.4.5

10.5.4, 10.4.14

26.4.4

10.5.1, 10.4.13

26.4.3

10.5.0, 10.4.9

26.4.2

10.4.4

26.4.1

10.4.3

26.4.0

10.4.2

New Features in Galera 4

The mysql database contains new tables related to Galera replication:

  • wsrep_cluster

  • wsrep_cluster_members

  • wsrep_streaming_log

End users may read but not modify these tables.

The new streaming replication feature allows replicating transactions of unlimited size. With streaming replication, a cluster is replicating a transaction in small fragments during transaction execution. This transaction fragmenting is controlled by two new configuration variables:

  • wsrep_trx_fragment_unit (bytes, rows, statements) defines the metrics for how to measure transaction size limit for fragmenting. Possible values are:

    • bytes: transaction’s binlog events buffer size in bytes

    • rows: number of rows affected by the transaction

    • statements: number of SQL statements executed in the multi-statement transaction

  • wsrep_trx_fragment_size defines the limit for fragmenting. When a transaction’s size, in terms of the configured fragment unit, has grown over this limit, a new fragment will be replicated.

Transactions replicated through galera replication will now process the commit phase using MariaDB's group commit logic. This will affect transaction throughput, especially when binary logging is enabled in the cluster.

Limitations in Galera 4

Rolling Upgrades from Galera 3 to Galera 4

Rolling upgrades from MariaDB 10.3 (or earlier) to MariaDB 10.4 also require an upgrade from Galera 3 to Galera 4. Galera 4 has a lot of changes and improvements that were not present in Galera 3.

Prior to the General Availability (GA) releases of MariaDB 10.4 and Galera 4, earlier versions of MariaDB 10.4 and Galera 4 had bugs that could lead to problems if Galera 4 nodes were in a cluster with Galera 3 nodes during a rolling upgrade. In these versions, rolling upgrades were not supported. This meant that, in order to upgrade a cluster, the cluster had to be completely stopped, and the nodes could only be restarted after the entire cluster had been upgraded to MariaDB 10.4 and Galera 4.

These bugs have been fixed in more recent versions, and rolling upgrades from Galera 3 to Galera 4 are supported. In order to perform a rolling upgrade, it is recommended to upgrade to MariaDB 10.4.6 or later and Galera 26.4.2 or later. However, as a general rule, users should try to ensure that they are upgrading to the latest versions of MariaDB 10.4 and Galera 4.

For more detailed information on how to upgrade, see Upgrading from MariaDB 10.3 to MariaDB 10.4 with Galera Cluster.

General

  • Crash safe Aria-based system tables (MDEV-16421)

  • Added Linux abstract socket support (MDEV-15655)

  • Enabled C++11 (MDEV-16410)

  • Performance improvements in Unicode collations (MDEV-17534, MDEV-17511, MDEV-17502, MDEV-17474)

  • User data type plugins (MDEV-4912, in progress)

  • Improvements with SQL standard INTERVAL support to help functions TIMESTAMP() and ADDTIME() return more predictable results.

    • Historically, MariaDB uses the TIME data type for both "time of the day" values and "duration" values. In the first meaning the natural value range is from '00:00:00' to '23:59:59.999999', in the second meaning the range is from '-838:59:59.999999' to '+838:59:59.999999'.

    • To remove this ambiguity and for the SQL standard conformance we plan to introduce a dedicated data type INTERVAL that will be able to store values in the range at least from '-87649415:59:59.999999' to '+87649415:59:59.999999', which will be enough to represent the time difference between TIMESTAMP'0001-01-01 00:00:00' and TIMESTAMP'9999-12-31 23:59:59.999999'.

    • As a first step we support this range of values for intermediate calculations when TIME-alike string and numeric values are used in INTERVAL (i.e. duration) context, e.g. as the second argument of SQL functions TIMESTAMP(ts,interval) and ADDTIME(ts,interval), so the following can now be calculated:

SELECT ADDTIME(TIMESTAMP'0001-01-01 00:00:00', '87649415:59:59.999999');
-> '9999-12-31 23:59:59.999999'  

SELECT TIMESTAMP(DATE'0001-01-01', '87649415:59:59.999999')
-> '9999-12-31 23:59:59.999999'  

SELECT ADDTIME(TIME'-838:59:59.999999', '1677:59:59.999998');
-> '838:59:59.999999'
  • Support for window UDF functions via the new method x_remove (MDEV-15073)

  • Json service for plugins (MDEV-5313)

  • Change in behavior for FLUSH TABLES (MDEV-5336).

  • The JSON_VALID function is automatically used as a CHECK constraint for the JSON data type alias in order to ensure that a valid json document is inserted (MDEV-13916)

  • MariaDB Named Commands (MDEV-17591)

  • MariaDB systemd multi-instance service have changed. See systemd page for details.

Security Vulnerabilities Fixed in MariaDB 10.4

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page.

  • CVE-2023-5157: MariaDB 10.4.26

  • CVE-2023-22084: MariaDB 10.4.32

  • CVE-2022-47015: MariaDB 10.4.29

  • CVE-2022-38791: MariaDB 10.4.26

  • CVE-2022-32091: MariaDB 10.4.26

  • CVE-2022-32089: MariaDB 10.4.26

  • CVE-2022-32088: MariaDB 10.4.25

  • CVE-2022-32087: MariaDB 10.4.25

  • CVE-2022-32086: MariaDB 10.4.25

  • CVE-2022-32085: MariaDB 10.4.25

  • CVE-2022-32084: MariaDB 10.4.26

  • CVE-2022-32083: MariaDB 10.4.25

  • CVE-2022-32081: MariaDB 10.4.26

  • CVE-2022-31624: MariaDB 10.4.22

  • CVE-2022-27458: MariaDB 10.4.25

  • CVE-2022-27457: MariaDB 10.4.25

  • CVE-2022-27456: MariaDB 10.4.25

  • CVE-2022-27455: MariaDB 10.4.25

  • CVE-2022-27452: MariaDB 10.4.25

  • CVE-2022-27451: MariaDB 10.4.25

  • CVE-2022-27449: MariaDB 10.4.25

  • CVE-2022-27448: MariaDB 10.4.25

  • CVE-2022-27447: MariaDB 10.4.25

  • CVE-2022-27446: MariaDB 10.4.25

  • CVE-2022-27445: MariaDB 10.4.25

  • CVE-2022-27444: MariaDB 10.4.25

  • CVE-2022-27387: MariaDB 10.4.25

  • CVE-2022-27386: MariaDB 10.4.25

  • CVE-2022-27385: MariaDB 10.4.22

  • CVE-2022-27384: MariaDB 10.4.25

  • CVE-2022-27383: MariaDB 10.4.25

  • CVE-2022-27382: MariaDB 10.4.25

  • CVE-2022-27381: MariaDB 10.4.25

  • CVE-2022-27380: MariaDB 10.4.25

  • CVE-2022-27379: MariaDB 10.4.25

  • CVE-2022-27378: MariaDB 10.4.25

  • CVE-2022-27377: MariaDB 10.4.25

  • CVE-2022-27376: MariaDB 10.4.25

  • CVE-2022-24052: MariaDB 10.4.23

  • CVE-2022-24051: MariaDB 10.4.23

  • CVE-2022-24050: MariaDB 10.4.23

  • CVE-2022-24048: MariaDB 10.4.23

  • CVE-2022-21595: MariaDB 10.4.23

  • CVE-2022-21451: MariaDB 10.4.19

  • CVE-2022-21427: MariaDB 10.4.25

  • CVE-2022-0778: MariaDB 10.4.23

  • CVE-2021-46669: MariaDB 10.4.25

  • CVE-2021-46668: MariaDB 10.4.24

  • CVE-2021-46667: MariaDB 10.4.22

  • CVE-2021-46666: MariaDB 10.4.20

  • CVE-2021-46665: MariaDB 10.4.24

  • CVE-2021-46664: MariaDB 10.4.24

  • CVE-2021-46663: MariaDB 10.4.24

  • CVE-2021-46662: MariaDB 10.4.22

  • CVE-2021-46661: MariaDB 10.4.24

  • CVE-2021-46659: MariaDB 10.4.23

  • CVE-2021-46658: MariaDB 10.4.21

  • CVE-2021-46657: MariaDB 10.4.20

  • CVE-2021-35604: MariaDB 10.4.22

  • CVE-2021-27928: MariaDB 10.4.18

  • CVE-2021-2389: MariaDB 10.4.21

  • CVE-2021-2372: MariaDB 10.4.21

  • CVE-2021-2194: MariaDB 10.4.16

  • CVE-2021-2166: MariaDB 10.4.19

  • CVE-2021-2154: MariaDB 10.4.19

  • CVE-2021-2144: MariaDB 10.4.9

  • CVE-2021-2022: MariaDB 10.4.14

  • CVE-2021-2007: MariaDB 10.4.7

  • CVE-2020-7221: MariaDB 10.4.12

  • CVE-2020-2922: MariaDB 10.4.7

  • CVE-2020-28912: MariaDB 10.4.16

  • CVE-2020-2814: MariaDB 10.4.13

  • CVE-2020-2812: MariaDB 10.4.13

  • CVE-2020-2780: MariaDB 10.4.9

  • CVE-2020-2760: MariaDB 10.4.13

  • CVE-2020-2752: MariaDB 10.4.13

  • CVE-2020-2574: MariaDB 10.4.12

  • CVE-2020-15180: MariaDB 10.4.15

  • CVE-2020-14812: MariaDB 10.4.16

  • CVE-2020-14789: MariaDB 10.4.16

  • CVE-2020-14776: MariaDB 10.4.16

  • CVE-2020-14765: MariaDB 10.4.16

  • CVE-2020-13249: MariaDB 10.4.13

  • CVE-2019-2974: MariaDB 10.4.9

  • CVE-2019-2938: MariaDB 10.4.9

  • CVE-2019-2805: MariaDB 10.4.7

  • CVE-2019-2758: MariaDB 10.4.7

  • CVE-2019-2740: MariaDB 10.4.7

  • CVE-2019-2739: MariaDB 10.4.7

  • CVE-2019-2737: MariaDB 10.4.7

  • CVE-2019-2628: MariaDB 10.4.5

  • CVE-2019-2627: MariaDB 10.4.5

  • CVE-2019-2614: MariaDB 10.4.5

  • CVE-2018-25032: MariaDB 10.4.26

List of All MariaDB 10.4 Releases

Date
Release
Status
Release Notes
Changelog

Date

Release

Status

Release Notes

Changelog

16 May 2024

MariaDB 10.4.34

Stable (GA)

Release Notes

Changelog

7 Feb 2024

MariaDB 10.4.33

Stable (GA)

Release Notes

Changelog

13 Nov 2023

MariaDB 10.4.32

Stable (GA)

Release Notes

Changelog

14 Aug 2023

MariaDB 10.4.31

Stable (GA)

Release Notes

Changelog

7 Jun 2023

MariaDB 10.4.30

Stable (GA)

Release Notes

Changelog

10 May 2023

MariaDB 10.4.29

Stable (GA)

Release Notes

Changelog

6 Feb 2023

MariaDB 10.4.28

Stable (GA)

Release Notes

Changelog

7 Nov 2022

MariaDB 10.4.27

Stable (GA)

Release Notes

Changelog

15 Aug 2022

MariaDB 10.4.26

Stable (GA)

Release Notes

Changelog

20 May 2022

MariaDB 10.4.25

Stable (GA)

Release Notes

Changelog

12 Feb 2022

MariaDB 10.4.24

Stable (GA)

Release Notes

Changelog

9 Feb 2022

MariaDB 10.4.23

Stable (GA)

Release Notes

Changelog

8 Nov 2021

MariaDB 10.4.22

Stable (GA)

Release Notes

Changelog

6 Aug 2021

MariaDB 10.4.21

Stable (GA)

Release Notes

Changelog

23 Jun 2021

MariaDB 10.4.20

Stable (GA)

Release Notes

Changelog

7 May 2021

MariaDB 10.4.19

Stable (GA)

Release Notes

Changelog

22 Feb 2021

MariaDB 10.4.18

Stable (GA)

Release Notes

Changelog

11 Nov 2020

MariaDB 10.4.17

Stable (GA)

Release Notes

Changelog

3 Nov 2020

MariaDB 10.4.16

Stable (GA)

Release Notes

Changelog

7 Oct 2020

MariaDB 10.4.15

Stable (GA)

Release Notes

Changelog

10 Aug 2020

MariaDB 10.4.14

Stable (GA)

Release Notes

Changelog

12 May 2020

MariaDB 10.4.13

Stable (GA)

Release Notes

Changelog

28 Jan 2020

MariaDB 10.4.12

Stable (GA)

Release Notes

Changelog

11 Dec 2019

MariaDB 10.4.11

Stable (GA)

Release Notes

Changelog

8 Nov 2019

MariaDB 10.4.10

Stable (GA)

Release Notes

Changelog

5 Nov 2019

MariaDB 10.4.9

Stable (GA)

Release Notes

Changelog

11 Sep 2019

MariaDB 10.4.8

Stable (GA)

Release Notes

Changelog

31 Jul 2019

MariaDB 10.4.7

Stable (GA)

Release Notes

Changelog

18 Jun 2019

MariaDB 10.4.6

Stable (GA)

Release Notes

Changelog

21 May 2019

MariaDB 10.4.5

RC

Release Notes

Changelog

7 Apr 2019

MariaDB 10.4.4

RC

Release Notes

Changelog

25 Feb 2019

MariaDB 10.4.3

RC

Release Notes

Changelog

29 Jan 2019

MariaDB 10.4.2

Beta

Release Notes

Changelog

20 Dec 2018

MariaDB 10.4.1

Beta

Release Notes

Changelog

9 Nov 2018

MariaDB 10.4.0

Alpha

Release Notes

Changelog

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.34 Release Notes

DownloadRelease NotesChangelogOverview of 10.4

Alternate download from mariadb.org

Release date: 16 May 2024

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.34 is a Stable (GA) release.

MariaDB 10.4.34 is the last release of the MariaDB 10.4 release series.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

  • Fix adaptive hash index corruption after ALTER TABLE…DISCARD TABLESPACE (MDEV-33400)

  • Fix InnoDB: Failing assertion on UPDATE (MDEV-32346)

  • Fix fatal InnoDB error or assertion ``!is_v'` failure upon multi-update with indexed virtual column (MDEV-31154)

  • Fix InnoDB fatal error: Clustered record field for column x not found (MDEV-33558)

  • Fix alter operation hang when encryption thread works on the same tablespace (MDEV-33770)

  • Fix MariaDB segfault on rowid filter query involving generated column (MDEV-33795)

  • Fix discard/import tablespace, restart, index corruption (MDEV-33512)

  • Fix alter table corruption while applying the modification log (MDEV-19044)

  • Fix weird read view after ROLLBACK of other transactions (MDEV-33802)

  • Table no longer gets rebuilt with ALTER TABLE ADD COLUMN (MDEV-33214)

RocksDB

  • Unsafe use of LOCK_thd_kill in my_malloc_size_cb_func() (MDEV-33443)

Spider

  • Improve Spider performance by pushing down TIMESTAMPDIFF function (MDEV-28992) and CASE statement (MDEV-28993) to data nodes

  • Fix sql plugin init failure with traditional sql_mode (MDEV-33584)

  • Fix parsing failure on valid left join select by translating the on expression to () (MDEV-33679)

  • Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using MariaDB 10.5 local and MariaDB 10.6 remote (MDEV-33777)

  • Fix bug where Spider variables were not available if Spider was loaded upon server startup (MDEV-33441)

Backup

  • MariaDB Backup now preserves innodb_encrypt_tables (MDEV-33334)

  • Fix MariaDB Backup problem on older mariadb (opendir(NULL)) caused by MDEV-30968 (MDEV-31251)

  • mariadb-backup --backup now includes retry logic for undo tablespaces (MDEV-33980)

  • Fix crash recovery in mariadb-backup --prepare due to insufficient innodb_log_file_size (MDEV-33540)

Character Sets, Data Types

  • Default charset now works with PHP MySQLi extension (MDEV-32975)

Optimization & Tuning

  • Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables (MDEV-21102)

Replication

  • --gtid-ignore-duplicate can double-apply event in case of parallel replication retry (MDEV-33475)

Galera

  • Galera updated to 26.4.18

    • NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes nodes have been updated

SQL, Data Definition, and Data Manipulation

  • Fix incorrect DEFAULT expression evaluated in UPDATE (MDEV-33790)

Prepared Statements

  • Incorrect handling of UPDATE in PS mode in case a table's colum declared as NOT NULL (MDEV-33549)

  • Crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT, UBSAN runtime error: member call on null pointer of type 'struct TABLE_LIST' in Item_param::save_in_field (MDEV-15703)

General

Server

  • Original IP not shown in network related error messages when proxy_protocol is in use (MDEV-33506)

Security

  • Fixes for the following security vulnerabilities:

    • CVE--``#

Changelog

For a complete list of changes made in MariaDB 10.4.34, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.34, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.33 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.33Release NotesChangelogOverview of 10.4

Release date: 7 Feb 2024

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.33 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

  • Windows packages were delayed but have now been added to the downloads site

InnoDB

  • Unique hash key on column prefix is computed incorrectly (MDEV-29954)

  • Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old (MDEV-28613)

  • Assertion ``0'failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search (MDEV-21245)

  • Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table (MDEV-31574)

  • Crash emitting "Unsupported meta-data version number" error message (MDEV-29972)

  • LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED (MDEV-32890)

  • Inplace alter rebuild increases file size (MDEV-26740)

  • BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY (MDEV-31441)

  • GNU libc posix_fallocate() may be extremely slow (MDEV-32268)

  • InnoDB wrong error message (MDEV-32833)

  • Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 (MDEV-31000)

Backup

  • mariadb-backup has wrong or missing plugin-dir default? (MDEV-29110)

  • mariadb-backup fails when innodb_max_dirty_pages_pct contains a fraction (is not an integer) (MDEV-20286)

  • BACKUP LOCKS on table to be accessible to those with database LOCK TABLES privileges (MDEV-28367)

JSON

  • Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE (MDEV-24541)

  • JSON_VALID fail to validate integer zero in scientific notation (MDEV-32587)

  • ASAN errors in Item_func_json_contains_path::val_int upon PS execution (MDEV-32867)

Spider

  • Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider (MDEV-29421)

  • SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES (MDEV-29963)

  • ASAN heap-use-after-free in spider_link_get_key on LOCK TABLES (MDEV-31357)

  • Crash when lateral derived is guaranteed to return no rows (MDEV-31279)

  • Bogus error executing PS for query using CTE with renaming of columns (MDEV-31995)

  • Spider: Valid LEFT JOIN results in ERROR 1064 (MDEV-26247)

  • Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache (MDEV-28739)

  • Spider tests failing in asan/valgrind builds (MDEV-32849)

  • Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service (MDEV-29870)

  • Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table (MDEV-29163)

  • heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table (MDEV-30014)

  • Syntax error upon query with subquery from Spider table (MDEV-30392)

  • Spider doesn't recognize semi JOIN (MDEV-31645)

  • MariaDB, SPIDER engine, usage of REGEXP (MDEV-32986)

  • Spider: variable spider_same_server_link not functioning correctly (MDEV-29718)

  • Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown (MDEV-33008)

  • Spider spawns unnecessarily many system threads for stats synchronization (MDEV-29020)

    • Defaults for spider_table_crd_thread_count and spider_table_sts_thread_count changed from 10 to 1

  • SIGSEGV in spider_db_delete_all_rows on TRUNCATE, UBSAN: member call on null pointer of type 'struct spider_db_handler' in spider_db_delete_all_rows (MDEV-33191)

  • mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' (MDEV-27103)

  • Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete (MDEV-28683)

Optimizer

  • Crash caused by multi-table UPDATE over derived with hanging CTE (MDEV-28615)

  • Crash on query using CTE with the same name as a base table (MDEV-31657)

  • Crash with query using constant subquery as left part of IN subquery (MDEV-29362)

Data Definition, Data Manipulation

  • ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note (MDEV-32795)

  • Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY (MDEV-22230)

  • FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure (MDEV-29092)

  • Assertion !"wrong page type"'` or Assertion "wrong page type" == 0'failed ininnobase_instant_tryonALTER` (MDEV-18322)

  • Assertion (col.vers_sys_end()) upon inplace ALTER with virtual columns (MDEV-20545)

  • DELETE with ORDER BY and semijoin optimization causing crash (MDEV-32212)

  • Invalid expr in cleanup_session_expr() upon INSERT DELAYED (MDEV-29932)

  • SIGSEGV in my_decimal::operator= and Assertion 0'failed inItem_type_holder::val_decimal` on SELECT (MDEV-29070)

Character Sets, Data Types

  • InnoDB: CHAR+nopad does not work well (MDEV-26743)

  • CAST(AS UNSIGNED) fails with --view-protocol (MDEV-32645)

Plugins

  • Backport SQL service, introduced by MDEV-19275 (MDEV-27595)

  • "plugin already loaded" should be a Warning, not an Error (MDEV-32041)

  • mariadb-upgrade should remove mysql.plugin entries for plugins that became bundled (MDEV-32043)

Galera

  • Node has been dropped from the cluster on Startup / Shutdown with async replica (MDEV-31413)

  • Inconsistency in Galera caused by ALTER being aborted before entering TOI mode (MDEV-32938)

  • Assertion ``total_length + thd->wsrep_sr().log_position() == saved_pos'failed in intwsrep_write_cache_inc(THD*, IO_CACHE*, size_t*)` (MDEV-28971)

  • wsrep_provider_options can be truncated on deep and long directory paths (MDEV-32634)

  • Server crashes in rpl_sql_thread_info::cached_charset_compare / wsrep_apply_events (MDEV-22232)

  • Galera crash when "create a table as select" (MDEV-27806)

Replication

  • Server crashes in Item_func_binlog_gtid_pos::val_str / Binary_string::c_ptr_safe (MDEV-33045)

  • binlog corruption (/tmp no space left on device at the same moment) (MDEV-27436)

  • multi source replication filters breaking GTID semantic (MDEV-26632)

  • SHOW SLAVE STATUS Can Deadlock an Errored Slave (MDEV-10653)

  • main.rpl_mysqldump_slave Fails with "Master binlog wasn't deleted" Assertion (MDEV-32953)

  • rpl_seconds_behind_master_spike Sensitive to IO Thread Stop Position (MDEV-33327)

General

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Windows Server 2019

  • Upgrade HeidiSQL to 12.6.

  • Using two temporary tables in OPTIMIZE TABLE lead to crash (MDEV-31523)

  • REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode (MDEV-29095)

  • CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" (MDEV-21618)

  • Failure when executing PS for query using IN subquery (MDEV-32569)

  • Potential memory leak on execuing of create view statement (MDEV-32466)

  • Assertion failures (MDEV-32965)

  • Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES (MDEV-32733)

  • Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds (MDEV-33169)

  • Set TaskMax=inifinity in the MariaDB systemd unit (MDEV-30236)

  • Unreliable autocommit flag on connection creation (MDEV-32875)

  • A connection can control RAND() in following connection (MDEV-33148)

  • THD::rli_fake/rgi_fake not cleared on new connection (MDEV-32844)

  • Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> (MDEV-20471)

  • Server crash in find_field_in_table (MDEV-32082)

  • LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE (MDEV-27744)

  • Failure to call SP invoking another SP with parameter requiring type conversion (MDEV-33270)

  • The database part is not case sensitive in SP names (MDEV-33019)

  • EXCHANGE PARTITION with non-matching vcol expression segfault (MDEV-28127)

Security

  • Fixes for the following security vulnerabilities:

    • CVE--``#

Changelog

For a complete list of changes made in MariaDB 10.4.33, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.33, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.32 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.32Release NotesChangelogOverview of 10.4

Release date: 13 Nov 2023

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.32 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • DROP INDEX followed by CREATE INDEX may corrupt data (MDEV-32132)

  • ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. (MDEV-31875)

  • Server aborts during alter operation when table doesn't have foreign index (MDEV-32527)

  • row_merge_fts_doc_tokenize() handles FTS plugin parser inconsistently (MDEV-32578)

  • InnoDB: tried to purge non-delete-marked record of an index on a virtual column prefix (MDEV-30024)

  • lock_row_lock_current_waits counter in information_schema.innodb_metrics may become negative (MDEV-30658)

  • SET GLOBAL innodb_max_purge_lag_wait=… hangs if innodb_read_only=ON (MDEV-31813)

  • Auto-increment no longer works for explicit FTS_DOC_ID (MDEV-32017)

  • Assertion `pos < table->n_def' failed in dict_table_get_nth_col (MDEV-32337)

  • innochecksum man pages seem to be inconsistent with the binary (10.2.25) (MDEV-20583)

  • innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error (MDEV-30825)

  • wrong table name in innodb's "row too big" errors (MDEV-32128)

  • Optimize is_file_on_ssd() to speedup opening tablespaces on Windows (MDEV-32228)

Optimizer

  • Crash when HAVING in a correlated subquery references columns in the outer query (MDEV-29731)

  • Server crashes at TABLE::add_tmp_key (MDEV-32320)

  • Server crashes inside filesort at my_decimal::to_binary (MDEV-32324)

  • Assertion `bitmap_is_set(&m_part_info->read_partitions, m_part_spec.start_part)' failed in ha_partition::handle_ordered_index_scan (MDEV-24283)

  • Crash when searching for the best split of derived table (MDEV-32064)

  • Test case from opt_tvc.test fails with statement memory protection (MDEV-32225)

  • Significant slowdown for query with many outer joins (MDEV-32351)

  • test_if_skip_sort_order() should catch the join types JT_EQ_REF, JT_CONST and JT_SYSTEM and skip sort order for these (MDEV-32475)

Replication

  • rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables (MDEV-10356)

  • Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication (MDEV-31482)

  • strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT (MDEV-32249)

  • Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE (MDEV-31792)

  • SHOW SLAVE STATUS Last_SQL_Errno Race Condition on Errored Slave Restart (MDEV-31177)

  • seconds_behind_master is inaccurate for Delayed replication (MDEV-32265)

  • detailize the semisync replication magic number error (MDEV-32365)

  • Parallel replication deadlock victim preference code errorneously removed (MDEV-31655)

Galera

  • Galera updated to 26.4.16

  • Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed. (MDEV-24912)

  • Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failed (MDEV-31285)

  • wsrep_sst_mariadb-backup not working on FreeBSD (MDEV-31467)

  • Galera library 26.4.16 fails with every server version (MDEV-32024)

  • Galera node remains paused after interleaving FTWRLs (MDEV-32282)

  • Failed to insert streaming client (MDEV-32051)

  • When set at runtime, wsrep_sst_method accepts any value (MDEV-31470)

  • galera needs packaging script changes to successfully build (MDEV-32642)

Data Definition

  • MariaDB crash on calling function (MDEV-23902)

  • ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations (MDEV-31970)

Scripts and Clients

  • mariadb-binlog -T/--table (mysqlbinlog) option (MDEV-25369)

  • mariadb-admin (mysqladmin) wrong error with simple_password_check (MDEV-22418)

  • mariadb-install-db shows warning on missing directory $pamtooldir/auth_pam_tool_dir (MDEV-32142)

  • main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 (MDEV-19369)

  • mariadb-install-db (mysql_install_db) doesn't properly grant proxy privileges to all default root user accounts (MDEV-21194)

Tests

  • main.events_stress or events.events_stress fails with view-protocol (MDEV-31455)

  • main.delete_use_source fails (hangs) with view-protocol (MDEV-31457)

  • main.sum_distinct-big and main.merge-big fail with timeout with view-protocol (MDEV-31465)

  • main.secure_file_priv_win fails with 2nd execution PS protocol (MDEV-32023)

  • Windows : mtr output on is messed up with large MTR_PARALLEL (MDEV-32387)

  • main.mysql_client_test_comp failed in buildbot, error on exec (MDEV-16641)

mariadb-backup

  • mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 (MDEV-18200)

  • mbstream breaks page compression on XFS (MDEV-25734)

Character Sets, Data Types, Collations

  • Prefix keys for CHAR work differently for MyISAM vs InnoDB (MDEV-30048)

  • Inconsistent results of DISTINCT with NOPAD (MDEV-30050)

  • Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT (MDEV-28835)

  • Compressed varchar values lost on joins when sorting on columns from joined table(s) (MDEV-31724)

  • UBSAN shift exponent X is too large for 64-bit type 'long long int' in sql/field.cc (MDEV-32226)

  • Wrong bit encoding using COALESCE (MDEV-32244)

Spider

  • Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims (MDEV-31117)

  • Segfault when setting spider_delete_all_rows to 0 and delete all rows of a spider table, ASAN heap-use-after-free in spider_db_delete_all_rows (MDEV-31996)

  • ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler (MDEV-28998)

General

  • binlog_do_db option breaks importing sql dumps (MDEV-29989)

  • Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 (MDEV-32025)

  • getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO (MDEV-32275)

  • Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT (MDEV-17711)

  • main.mysqlcheck fails on ARM with ASAN use-after-poison in my_mb_wc_filename (MDEV-26494)

  • main.delayed fails with wrong error code or timeout when executed after main.deadlock_ftwrl (MDEV-27523)

  • Assertion failed: !pfs->m_idle || (state == PSI_SOCKET_STATE_ACTIVE) (MDEV-28561)

  • MyISAM wrong server status flags (MDEV-28820)

  • Server crashes in check_sequence_fields upon CREATE TABLE .. SEQUENCE=1 AS SELECT .. (MDEV-29771)

  • slow log Rows_examined out of range (MDEV-30820)

  • "rpm --setugids" breaks PAM authentication (MDEV-30904)

  • incorrect examined rows in case of stored function usage (MDEV-31742)

  • Compilation failing on MacOS (unknown warning option -Wno-unused-but-set-variable) (MDEV-31890)

  • Server crash upon inserting into Mroonga table with compressed column (MDEV-31966)

  • hash unique corrupts index on virtual blobs (MDEV-32012)

  • insert into an empty table fails with hash unique (MDEV-32015)

  • Valgrind/MSAN warnings in dynamic_column_update_move_left (MDEV-32140)

  • Memory leak showed in MDEV-6146 test suite (MDEV-32223)

  • Test from subselect.test fails with statement memory protection (MDEV-32245)

  • Memory leak when executing PS for query with IN subquery (MDEV-32369)

  • Allow the setting of Auto_increment on FK referenced columns (MDEV-32018)

  • mariadb-upgrade fails with sql_safe_updates = on (MDEV-29914)

  • Assertion `!(thd->server_status & (1U | 8192U))' failed in MDL_context::release_transactional_locks (MDEV-32541)

  • Information schema leaks table names and structure to unauthorized users (MDEV-32500)

  • Missing CHACHA20-POLY1305 support in WolfSSL (MDEV-31653)

  • incorrect error about cyclic reference about JSON type virtual column (MDEV-32586)

  • Disable TLS v1.0 and 1.1 for MariaDB (MDEV-31369)

  • Better indication of refusing to start because of ProtectHome (MDEV-25177)

  • Database upgrade fails: slow_log table (MDEV-27757)

  • myrocks_hotbackup.1 and test suite files installed when engine is disabled (MDEV-29993)

  • client_ed25519.dll isn't inluded for HeidiSQL. (MDEV-31315)

Docker Official Images

  • Invert single and double quotes for sql command definitions in healthcheck.sh due to failure under sql_mode=ANSI_QUOTES - contribution by Dominik Häckel

  • healthcheck.sh --no-defaults behaviour was corrected - reported by Dominik Häckel

  • Added /docker-entrypoint-init.d for tar{,compression} from MariaDB Backup - instructions

  • Refactor docker_mariadb_init in the entrypoint for extending the MariaDB image

  • CIS failure due to world-writable directory /var/run/mysqld, added sticky bit - reported by @ollie1

  • Add PROXY privileges for root@MARIADB_ROOT_HOST - reported by Matthieu Gusmini

  • healthcheck.sh added --galera_online test, to match what the mariadb-operator does.

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2023-22084

Changelog

For a complete list of changes made in MariaDB 10.4.32, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.32, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.31 Release Notes

DownloadRelease NotesChangelogOverview of 10.4

Alternate download from mariadb.org

Release date: 14 Aug 2023

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.31 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

General

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Ubuntu 18.04 LTS "Bionic"

  • mysqldump --force doesn't ignore error as it should (MDEV-31092)

  • ROW variables do not get assigned from subselects (MDEV-31250)

  • Crash after setting global session_track_system_variables to an invalid value (MDEV-25237)

  • ODKU of non-versioning column inserts history row (MDEV-23100)

  • UPDATE not working properly on transaction precise system versioned table (MDEV-25644)

  • Assertion ``const_item_cache == true'failed inItem_func::fix_fields` (MDEV-31319)

  • ANALYZE doesn't work with pushed derived tables (MDEV-29284)

  • get_partition_set is never executed in ha_partition::multi_range_key_create_key due to bitwise & with 0 constant (MDEV-24712)

  • Client can crash the server with a mysql_list_fields("view") call (MDEV-30159)

  • I_S.parameters not immediatly changed updated after procedure change (MDEV-31064)

Character Sets, Data Types

  • UBSAN: null pointer passed as argument 1, which is declared to never be null in my_strnncoll_binary on SELECT ... COUNT or GROUP_CONCAT (MDEV-28384)

  • Possibly wrong result or Assertion 0' failed in Item_func_round::native_op` (MDEV-23838)

  • Assertion ``(length % 4) == 0'failed inmy_lengthsp_utf32onSELECT` (MDEV-29019)

  • UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op (MDEV-30932)

  • Assorted assertion failures in json_find_path with certain collations (MDEV-23187)

InnoDB

  • innochecksum dies with Floating point exception (MDEV-31641)

  • Deadlock with 3 concurrent DELETEs by unique key (MDEV-10962)

  • Assertion ``!strcmp(index->table->name.m_name, "SYS_FOREIGN") || !strcmp(index->table->name.m_name, "SYS_FOREIGN_COLS")'failed inbtr_node_ptr_max_size` (MDEV-19216)

  • MODIFY COLUMN can break FK constraints, and lead to unrestorable dumps (MDEV-31086)

Aria

  • Various crashes upon INSERT/UPDATE after changing Aria settings (MDEV-28054)

  • Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded (MDEV-26258)

Spider

  • SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT (MDEV-29447)

  • Spider variables that double as table params overriding mechanism is buggy (MDEV-31524)

Optimizer

  • Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` (MDEV-31348)

  • Problem with open ranges on prefix blobs keys (MDEV-31800)

  • Equal on two RANK window functions create wrong result (MDEV-20010)

  • Recursive CTE execution is interrupted without errors or warnings (MDEV-31214)

  • MAX_SEL_ARG memory exhaustion is not visible in the optimizer trace (MDEV-30964)

  • SHOW TABLES not working properly with lower_case_table_names=2 (MDEV-30765)

  • Segfault on select query using index for group-by and filesort (MDEV-30143)

Replication

  • Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers (MDEV-30619)

  • ALTER SEQUENCE ends up in optimistic parallel slave binlog out-of-order (MDEV-31503)

  • STOP SLAVE takes very long time on a busy system (MDEV-13915)

  • rpl.rpl_manual_change_index_file occasionally fails in BB with Result length mismatch (MDEV-30214)

Galera

  • Node has been dropped from the cluster on Startup / Shutdown with async replica (MDEV-31413)

  • MariaDB stuck on starting commit state (waiting on commit order critical section) (MDEV-29293)

  • Assertion state() == s_aborting || state() == s_must_replay failed in int wsrep::transaction::after_rollback() (MDEV-30013)

  • Assertion !wsrep_has_changes(thd) || (thd->lex->sql_command == SQLCOM_CREATE_TABLE && !thd->is_current_stmt_binlog_format_row()) || thd->wsrep_cs().transaction().state() == wsrep::transaction::s_aborted failed (MDEV-30388)

  • Server crashes when wsrep_sst_donor and wsrep_cluster_address set to NULL (MDEV-28433)

  • Create temporary sequence can cause inconsistency (MDEV-31335)

  • Galera 4 unable to query cluster state if not primary component (MDEV-21479)

Security

  • Fixes for the following security vulnerabilities:

    • CVE--``#

Changelog

For a complete list of changes made in MariaDB 10.4.31, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.31, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.30 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.30Release NotesChangelogOverview of 10.4

Release date: 7 Jun 2023

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.30 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • Server crashes in st_join_table::choose_best_splitting (MDEV-31403)

  • Crash with condition pushable into derived and containing outer reference (MDEV-31240)

  • Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"

Optimizer

  • Crash with condition pushable into derived and containing outer reference (MDEV-31403 MDEV-31240)

  • Crash with EXPLAIN EXTENDED for multi-table update of system table (MDEV-31224)

Security

  • Fixes for the following security vulnerabilities:

    • CVE--``#

Changelog

For a complete list of changes made in MariaDB 10.4.30, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.30, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.29 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.29Release NotesChangelogOverview of 10.4

Release date: 10 May 2023

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.29 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • Crash on ROLLBACK in a ROW_FORMAT=COMPRESSED table (MDEV-30882)

  • UNIQUE USING HASH accepts duplicate entries for tricky collations (MDEV-30034)

  • rec_get_offsets() is not optimal (MDEV-30567)

Backup

  • mariadb-backup doesn't utilise innodb-undo-log-directory (if specified as a relative path) during copy-back operation (MDEV-28187)

  • mariadb-backup issues error messages during InnoDB tablespaces export on partial backup preparing (MDEV-29050)

  • mariadb-backup does not copy Aria logs if aria_log_dir_path is used (MDEV-30968)

Replication

  • Fixed a deadlock on parallel slave involving full image Write event on the sequence engine (MDEV-29621)

  • Fixed an attempted out-of-order binlogging error on slave involving ALTER on the sequence engine (MDEV-31077)

  • Corrected non-versioned master to versioned slave replication on no-unique attribute table (MDEV-30430)

  • Mended encrypted binlog master to error out to gtid-mode slave when master could not decrypt a binlog file (MDEV-28798)

  • Refined optimistic parallel slave to error-exit without any hang (MDEV-30780)

Optimizer

  • Split Materialized optimization is improved to re-fill the materialized table only if necessary. The fewer number of table refills is taken into account when choosing query plan, too (MDEV-26301).

  • Queries using SELECT DISTINCT some_expression(aggregate_function()) could produce wrong query result. (MDEV-20057)

  • EXPLAIN could erroneously report that Rowid Filter optimization is used for partitioned tables. Partitioned tables do not support it. (MDEV-30596)

  • A bug in selectivity computations for SINGLE/DOUBLE_PREC_HB histograms could cause wrong estimates to be produced. This could cause the optimizer to pick sub-optimal query plans (MDEV-31067).

Docker Official Images

  • Add replication setup to containers contributed by Md Sahil (MDEV-29762)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2022-47015

Changelog

For a complete list of changes made in MariaDB 10.4.29, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.29, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.28 Release Notes

DownloadRelease NotesChangelogOverview of 10.4

Release date: 6 Feb 2023

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.28 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

  • As mentioned in the 10.4.27 release notes, our Yum/DNF/Zypper repositories for Red Hat Enterprise Linux, CentOS, openSUSE, and SUSE are changing with this release to being signed with a new GPG key with SHA2 digest algorithms instead of SHA1. See this blog post and the GPG page for more details.

InnoDB

  • Full-text index corruption with system versioning (MDEV-25004)

Galera

  • Galera updated to 26.4.14

  • Fixes for cluster wide write conflict resolving (MDEV-29684)

Replication

  • Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE (MDEV-30323)

  • Seconds_Behind_Master is now shown now more precisely at the slave applier start, including in the delayed mode (MDEV-29639)

  • mysqlbinlog --verbose is made to show the type of compressed columns (MDEV-25277)

JSON

  • JSON_PRETTY added as an alias for JSON_DETAILED (MDEV-19160)

General

  • Infinite sequence of recursive calls when processing embedded CTE (MDEV-30248)

  • Crash with a query containing nested WINDOW clauses (MDEV-30052)

  • Major performance regression with 10.6.11 (MDEV-29988)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 10.4.28, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.28, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.27 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.27Release NotesChangelogOverview of 10.4

Release date: 7 Nov 2022

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.27 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

SSL

  • The server no longer tolerates incorrectly configured SSL (MDEV-29811). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.

Backup

  • mariadb-backup --compress hangs (MDEV-29043)

  • Assertion on info.page_size failed in xb_delta_open_matching_space (MDEV-18589)

InnoDB

  • InnoDB unnecessarily extends data files (MDEV-13013)

  • Adaptive hash index MDEV-27700, MDEV-29384

  • MVCC and locking MDEV-29666, MDEV-27927

  • Virtual columns MDEV-29299, MDEV-29753

Galera

  • Galera updated to 26.4.13

  • Galera server crashes after 10.3 > 10.4 upgrade (MDEV-29375)

  • wsrep_incoming_addresses status variable prints 0 as port number if the port is not mentioned in wsrep_node_incoming_address system variable (MDEV-28868)

JSON

  • JSON_VALUE() does not parse NULL properties properly (MDEV-27151)

Replication

  • minor correction in unsafe warning message (MDEV-28827)

  • False replication error-stop of REVOKE PRIVILEGES from a non-existing user on primary (MDEV-28530) in combination with a filtering replica is corrected

  • SET DEFAULT ROLE replication is mended on a replica that filters system tables (MDEV-28294)

Repositories

  • Beginning with the next release (Q1 2023), our Yum, DNF, and Zypper repositories for Red Hat, Fedora, and SUSE will be migrated to being signed with a new GPG key. The key we are migrating to is the same one we already use for our Debian and Ubuntu Repositories.

    • The short Key ID is: 0xC74CD1D8

    • The long Key ID is: 0xF1656F24C74CD1D8

    • The full fingerprint of the key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8

    • The key can be imported now in preparation for this change using the following command:

sudo rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEY

Docker Official Image

The following changes have been made to the docker.io/library/mariadb container image.

  • The number of gpg packages packages has been removed, leaving enough to apt-get update, but dirmngr that would fetch keys has been removed. (inspired by issue #469)

  • The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes issue #468).

  • Adds OCI labels to image (fixes issue 436 and users need for version)

  • MariaDB config: skip-host-cache and skip-name-resolve moved to /etc/mysql/mariadb.conf.d/05-skipcache.cnf

Security

  • Fixes for the following security vulnerabilities: <</style

Changelog

For a complete list of changes made in MariaDB 10.4.27, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.27, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.26 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.26Release NotesChangelogOverview of 10.4

Release date: 15 Aug 2022

MariaDB 10.4 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.26 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • InnoDB corruption due to lack of file locking (MDEV-28495)

  • FULLTEXT search with apostrophe, and mandatory words (MDEV-20797)

  • ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table (MDEV-28779)

  • ALTER TABLE wrong-result fix (MDEV-26294)

Replication

  • ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS (MDEV-21087)

  • INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback (MDEV-21443)

  • sequences related row-format events are made to correspond to binlog_row_image (MDEV-28487)

Galera

  • Galera updated to 26.4.12

  • Possible to write/update with read_only=ON and not a SUPER privilege (MDEV-28546)

  • Node crashes with Transport endpoint is not connected mysqld got signal 6 (MDEV-25068)

  • Galera4 not able to report proper wsrep_incoming_addresses (MDEV-20627)

Optimizer

  • Server crash in JOIN_CACHE::free or in copy_fields (MDEV-23809)

    • Queries that use DISTINCT and an always-constant function like COLLATION(aggegate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not costant.

  • Crash when using ANY predicand with redundant subquery in GROUP BY clause (MDEV-29139)

    • A query with a subuquery in this form could cause a crash:

... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
  • MariaDB Server SEGV on INSERT .. SELECT (MDEV-26427)

    • Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.

  • restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly (MDEV-28749)

    • Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.

  • Optimizer uses all partitions after upgrade to 10.3 (MDEV-28246)

    • For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.

CONNECT

  • CONNECT Engine now supports INSERT IGNORE with Mysql Table type (MDEV-27766)

mysql Client

  • New mysql client option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.

General

  • Crash in JSON_EXTRACT (MDEV-29188)

  • ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade (MDEV-28727)

  • Server crash upon CREATE VIEW with unknown column in ON condition (MDEV-29088)

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Debian 10 "Buster" for ppc64el

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2023-5157

    • CVE-2022-32089

    • CVE-2022-32081

    • CVE-2018-25032

    • CVE-2022-32091

    • CVE-2022-32084

    • CVE-2022-38791

Changelog

For a complete list of changes made in MariaDB 10.4.26, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.26, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.25 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.25Release NotesChangelogOverview of 10.4

Release date: 20 May 2022

MariaDB 10.4 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.25 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • innodb_disallow_writes removed (MDEV-25975)

  • InnoDB gap locking fixes (MDEV-20605, MDEV-28422)

Replication

  • Server initialization time gtid_slave_pos purge related reason of crashing in binlog background thread is removed (MDEV-26473)

  • Shutdown of the semisync master can't produce inconsistent state anymore (MDEV-11853)

  • Binlogs disappear after rsync IST (MDEV-28583)

  • master crash is eliminated in compressed semisync replication protocol with packet counting amendment (MDEV-25580)

  • OPTIMIZE on a sequence does not cause counterfactual ER_BINLOG_UNSAFE_STATEMENT anymore (MDEV-24617)

  • Automatically generated Gtid_log_list_event is made to recognize within replication event group as a formal member (MDEV-28550)

  • Replication unsafe INSERT .. ON DUPLICATE KEY UPDATE using two or more unique key values at a time with MIXED format binlogging is corrected (MDEV-28310)

  • Replication unsafe INSERT .. ON DUPLICATE KEY UPDATE stops issuing unnecessary "Unsafe statement" with MIXED binlog format (MDEV-21810)

  • Incomplete replication event groups are detected to error out by the slave IO thread (MDEV-27697)

  • mysqlbinlog --stop-never --raw now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)

Backup

  • Incorrect binlogs after Galera SST using rsync and MariaDB Backup (MDEV-27524)

  • MariaDB Backup does not detect multi-source replication slave (MDEV-21037)

  • Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage (MDEV-27343)

  • MariaDB Backup prepare fails for incrementals if a new schema is created after full backup is taken (MDEV-28446)

Optimizer

  • A SEGV in Item_field::used_tables/update_depend_map_for_order... (MDEV-26402)

  • ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries (MDEV-27699)

  • Subquery in an UPDATE query uses full scan instead of range (MDEV-22377)

  • Assertion `item1->type() == Item::FIELD_ITEM ... (MDEV-19398)

  • Server crashes in Expression_cache_tracker::fetch_current_stats (MDEV-28268)

  • MariaDB server crash at Item_subselect::init_expr_cache_tracker (MDEV-26164, MDEV-26047)

  • Crash with union of my_decimal type in ORDER BY clause (MDEV-25994)

  • SIGSEGV in st_join_table::cleanup (MDEV-24560)

  • Assertion `!eliminated' failed in Item_subselect::exec (MDEV-28437)

General

  • Server error messages are now available in Chinese (MDEV-28227)

  • For RHEL/CentOS 7, non x86_64 architectures are no longer supported upstream and so our support will also be dropped with this release

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Debian 9 "Stretch"

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-46669

    • CVE-2022-21427

    • CVE-2022-27376

    • CVE-2022-27377

    • CVE-2022-27378

    • CVE-2022-27379

    • CVE-2022-27380

    • CVE-2022-27381

    • CVE-2022-27382

    • CVE-2022-27383

    • CVE-2022-27384

    • CVE-2022-27386

    • CVE-2022-27387

    • CVE-2022-27444

    • CVE-2022-27445

    • CVE-2022-27446

    • CVE-2022-27447

    • CVE-2022-27448

    • CVE-2022-27449

    • CVE-2022-27451

    • CVE-2022-27452

    • CVE-2022-27455

    • CVE-2022-27456

    • CVE-2022-27457

    • CVE-2022-27458

    • CVE-2022-32087

    • CVE-2022-32086

    • CVE-2022-32085

    • CVE-2022-32083

    • CVE-2022-32088

Changelog

For a complete list of changes made in MariaDB 10.4.25, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.25, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.24 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.24Release NotesChangelogOverview of 10.4

Release date: 12 Feb 2022

MariaDB 10.4 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.24 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

  • This release fixes a blocking problem with the MariaDB 10.4.23 release when manually running mariadb-upgrade. (MDEV-27789)

  • See MariaDB 10.4.23 for other changes since the previous release.

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-46665

    • CVE-2021-46664

    • CVE-2021-46661

    • CVE-2021-46668

    • CVE-2021-46663

Changelog

For a complete list of changes made in MariaDB 10.4.24, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.24, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.23 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.23Release NotesChangelogOverview of 10.4

Release date: 9 Feb 2022

This release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See MDEV-27789 for more details.Please use a later release.

MariaDB 10.4 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.23 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • --skip-symbolic-links does not disallow .isl file creation (MDEV-26870)

  • Indexed CHAR columns are broken with NO_PAD collations (MDEV-25440)

Galera

  • Galera updated to 26.4.11

  • Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory (MDEV-27181)

  • Alter Sequence do not replicate to another nodes with in Galera Cluster (MDEV-19353)

  • Galera crash - Assertion. Possible parallel writeset problem (MDEV-26803)

  • CREATE TABLE with FOREIGN KEY constraint fails to apply in parallel (MDEV-27276)

Replication

  • Seconds behind master corrected from artificial spikes at relay-log rotation (MDEV-16091)

  • Statement rollback in binlog when transaction creates or drop temporary table is set right (MDEV-26833)

  • CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to stabilize its parallel execution on slave (MDEV-27365)

Packaging & Misc

  • prohibition running two upgrades in parallel (MDEV-27068, MDEV-27107, MDEV-27279)

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Ubuntu 21.04 Hirsute, CentOS 8, and Fedora 33

  • mariadb_repo_setup script updated to version 2022-02-08, with the following fixes and enhancements:

    • Default location of the script has been moved to: mariadb_repo_setup (old location is deprecated, but still works)

    • The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: mariadb-keyring-2019.gpg and the checksum for the file can be found at: mariadb-keyring-2019.gpg.sha256

    • Support for RHEL and SLES aarch64 repositories added

    • New function added to verify that the MariaDB Server version, if specified on the command line, follows the correct naming and that a corresponding repository actually exists.

    • Fixed repository pinning for Ubuntu and Debian repositories

    • MariaDB Server 10.7 is now the default server version

Docker Library

  • Faster initialization by disabling binary logging during initialization (MDEV-27074)

  • mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 (MDEV-25670)

  • A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options (MDEV-25434)

  • mysql@localhost user is created with the environment variable MARIADB_MYSQL_LOCALHOST_USER=1 and additional grants (beyond USAGE) with MARIADB_MYSQL_LOCALHOST_GRANTS={global grant list} (MDEV-27732)

  • skip innodb buffer pool loads/dumps on temporary startup/shutdown for faster startup/initialization, and accurate "healthcheck.sh --innodb_buffer_pool_loaded"

  • change group ownership on datadir/socket dir (issue #401)

  • log note about note on Securing system users, mysql_secure_installation not required (reddit suggestion)

  • speed up Docker Library initialization of timezones (MDEV-27608, MDEV-23326)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2022-24052

    • CVE-2022-24051

    • CVE-2022-24050

    • CVE-2022-24048

    • CVE-2021-46659

    • CVE-2022-0778

    • CVE-2022-21595

Changelog

For a complete list of changes made in MariaDB 10.4.23, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.23, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.22 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.22Release NotesChangelogOverview of 10.4

Release date: 8 Nov 2021

MariaDB 10.4 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.22 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

Galera

  • Galera updated to 26.4.11

  • Fix for WSREP: invalid state ROLLED_BACK (FATAL) (MDEV-25114)

InnoDB

  • ALTER TABLE…IMPORT TABLESPACE fixes (MDEV-18543, MDEV-20931, MDEV-26131, MDEV-26621)

  • innodb_undo_log_truncate fixes (MDEV-26450, MDEV-26672, MDEV-26864)

Replication

  • Memory hogging on slave by ROW event applier is eliminated (MDEV-26712)

  • mysql --binary-mode now properly handles \\0 in data (MDEV-25444)

  • Fixes race condition between SHOW BINARY LOGS and RESET MASTER (MDEV-20215)

  • Missed statement rollback in case transaction drops or create temporary table is corrected (MDEV-26833)

Audit Plugin

  • The QUERY_DDL server_audit_events setting now logs CREATE/DROP [PROCEDURE / FUNCTION / USER] statements. See MariaDB Audit Plugin - Log Settings. (MDEV-23457)

Packaging & Misc

  • Session tracking flag in OK_PACKET (MDEV-26868)

  • Some views force server (and mysqldump) to generate invalid SQL for their definitions (MDEV-26299)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-35604

    • CVE-2021-46667

    • CVE-2021-46662

    • CVE-2022-27385

    • CVE-2022-27385

    • CVE-2022-31624

Changelog

For a complete list of changes made in MariaDB 10.4.22, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.22, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.21 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.21Release NotesChangelogOverview of 10.4

Release date: 6 Aug 2021

Warning: This version can cause InnoDB file corruption on FreeBSD and on AIX. If you are using AIX, please, stick to an earlier release, or upgrade to a more recent release. If you are using FreeBSD, upgrade to the bugfix release (the version ends with _1) of the mariadb-server from the Ports Collection. See MDEV-26537.

MariaDB 10.4 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.21 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

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

  • Encryption: Automatically disable key rotation checks for file_key_management plugin (MDEV-14180)

  • Some fixes from MySQL 5.7.35 (MDEV-26205)

Optimizer

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

  • Queries that have more than 32 equality conditions comparing columns of different tables ("tableX.colX=tableY.colY) could cause a stack overrun in the query optimizer (MDEV-17783, MDEV-23937)

  • "Condition pushdown into derived table" optimization cannot be applied if the expression being pushed refers to a derived table column which is computed from expression that has a stored function call, @session variable reference, or other similar construct. The fix for MDEV-25969 makes it so that only the problematic part of the condition is not pushed. The rest of the condition is now pushed. (MDEV-25969)

  • A query with window function on the left side of the subquery could cause a crash. (MDEV-25630)

Packaging & Misc

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Ubuntu 20.10 Groovy

  • Galera updated to 26.4.9

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-2372

    • CVE-2021-2389

    • CVE-2021-46658

MongoDB protocol support files for the CONNECT engine are missing in this release. If you want to use CONNECT engine with MongoDB, you need to downloadMongo2.jar or Mongo3.jar and put a path to this file into the connect_class_path in the my.cnf.

Changelog

For a complete list of changes made in MariaDB 10.4.21, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.21, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.20 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.20Release NotesChangelogOverview of 10.4

Release date: 23 Jun 2021

MariaDB 10.4 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.20 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

This version of MariaDB is being released now to fix the following two regressions:

  • Table alias from previous statement interferes later commands (MDEV-25672)

  • Join using derived with aggregation returns incorrect results (MDEV-25714)

In addition to the above, this release also contains the following fixes:

InnoDB

  • InnoDB spatial indexes miss large geometry fields after MDEV-25459 (MDEV-25758)

  • Double free of transaction during truncate operation (MDEV-25663)

  • Double free of table when inplace alter FTS add index fails (MDEV-25721)

  • Potential hang in purge for virtual columns (MDEV-25664)

  • Change buffer entries for secondary indexes are lost on InnoDB restart (MDEV-25869)

Replication

  • Do not replicate killed multi-table OPTIMIZE TABLE when the signal arrives before any table has been processed (MDEV-22530)

  • Fix optistic parallel applier to not deadlock on admin commands OPTIMIZE, REPAIR, and ANALYZE (MDEV-17515)

  • Backport MDEV-20821 parallel slave server shutdown hang (MDEV-22370)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-46666

    • CVE-2021-46657

MongoDB protocol support files for the CONNECT engine are missing in this release. If you want to use CONNECT engine with MongoDB, you need to downloadMongo2.jar or Mongo3.jar and put a path to this file into the connect_class_path in the my.cnf.

Changelog

For a complete list of changes made in MariaDB 10.4.20, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.20, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.19 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.19Release NotesChangelogOverview of 10.4

Release date: 7 May 2021

MariaDB 10.4 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.19 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

  • ST_DISTANCE_SPHERE for calculating the spherical distance between two geometries (point or multipoint) on a sphere (MDEV-13467)

  • Crash with invalid multi-table update of view in 2nd execution of SP (MDEV-24823)

  • Incorrect name resolution for subqueries in ON expressions (MDEV-25362)

  • Complex query in Store procedure corrupts results (MDEV-25182)

  • DELETE HISTORY may delete current data on system-versioned table (MDEV-25468)

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

  • Server crashes in thd_clear_errors() (MDEV-23542)

  • The statement set password=password('') executed in PS mode fails in case it is run by a user with expired password (MDEV-25197)

mariadb-backup

  • RENAME TABLE causes "Ignoring data file" messages (MDEV-25568)

InnoDB

  • Deprecated the *innodb and *none options in innodb_checksum_algorithm (MDEV-25106)

  • MVCC read from index on CHAR or VARCHAR wrongly omits rows (MDEV-25459)

  • Race conditions in persistent statistics (MDEV-10682, MDEV-18802, MDEV-25051)

  • Sequence created by one connection remains invisible to another (MDEV-24545)

  • innodb_flush_method=O_DIRECT fails on compressed tables (MDEV-25121)

Replication

  • Replication Heartbeat event was uncapable to cary 4GB+ offsets (MDEV-16146)

  • FLUSH LOGS race against Binlog checkpoint event creation (MDEV-24526)

  • slave_compressed_protocol did not work correctly with semi-sync (MDEV-24773)

Galera

  • Galera updated to 26.4.8

  • SET PASSWORD command fail with wsrep api (MDEV-25258)

  • Long BF log wait turns on InnoDB Monitor output without telling, never turns it off (MDEV-25319)

  • Assertion ``state_ == s_exec'failed inwsrep::client_state::start_transaction` (MDEV-22227)

  • Frequently Crashing Mariadb Cluster 10.4.18 (MDEV-24980)

  • Signal 11 on TABLE_LIST::placeholder() (MDEV-24878)

  • ALTER TABLE not replicated with Galera in MariaDB 10.5.9 (MDEV-24956)

  • "Flush SSL" command doesn't reload wsrep cert (MDEV-22668)

  • Avoid unnecessary rollbacks with SR (MDEV-25553)

Packaging & Misc

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Ubuntu 16.04 Xenial

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-2166

    • CVE-2021-2154

    • CVE-2022-21451

MongoDB protocol support files for the CONNECT engine are missing in this release. If you want to use CONNECT engine with MongoDB, you need to downloadMongo2.jar or Mongo3.jar and put a path to this file into the connect_class_path in the my.cnf.

Changelog

For a complete list of changes made in MariaDB 10.4.19, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.19, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.18 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.18Release NotesChangelogOverview of 10.4

Release date: 22 Feb 2021

Last month long-time MariaDB VP of Engineering, Rasmus Johansson, passed due to complications from cancer. His loss has been felt keenly by the whole MariaDB team. Our thoughts are with his family during this difficult time and this release is dedicated to his memory.

MariaDB 10.4 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.18 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

InnoDB

  • MDEV-24188 - Hang in buf_page_create() after reusing a previously freed page

  • MDEV-24275 - InnoDB persistent stats analyze forces full scan forcing lock crash

  • MDEV-24449 - Corruption of system tablespace or last recovered page

Galera

  • Galera updated to 26.4.7

  • MDEV-23328 - Server hang due to Galera lock conflict resolution

  • MDEV-23851 - BF-BF Conflict issue because of UK GAP locks

  • MDEV-20717 - Plugin system variables and activation options can break mysqld --wsrep_recover

  • MDEV-24469 - Assertion active() == false failed with "XA START.."

  • MDEV-23647 - Garbd can't initiate SST anymore in 10.5

  • MDEV-25179 - wsrep_provider and wsrep_notify_cmd system variables are now read-only

Replication

  • MDEV-8134 - relay-log is corrected to rotate past 999999

  • MDEV-23033 - fixed slave applier for row-based events with FK constraints on virtual columns

  • MDEV-4633 - Relay_Log_Space of Show-Slave-Status is made thread-safe

  • MDEV-10272 - add master host/port info to slave thread exit messages

  • MDEV-23846 - improves mysqlbinlog error message issuing

Misc

  • MDEV-24122 - anomalies in mysql.user tables on previously 5.7 MySQL versions corrected

  • Binary tarballs now use WolfSSL v4.6.0

  • MDEV-23630 - mysqldump --system option

  • Fixes for the following security vulnerabilities:

    • CVE-2021-27928

Changelog

For a complete list of changes made in MariaDB 10.4.18, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.18, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.17 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.17Release NotesChangelogOverview of 10.4

Release date: 11 Nov 2020

MariaDB 10.4 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.17 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

  • Out-of-cycle release to fix regressions in MariaDB 10.4.16

  • Follow up to MDEV-19838 to alter protocol checks to support the following implementations (which add garbage to the end of some packets):

    • PHP PDO (all versions) (MDEV-24121)

    • mysqlnd (from PHP < 7.3) (MDEV-24121)

    • mysql-connector-python (all versions) (MDEV-24134)

    • and mysql-connector-java (all versions)

  • Arbitrary InnoDB buffer pool and data file corruption (MDEV-24096)

  • The query optimizer consumed a lot of memory when handling construct in form of key_column [NOT] IN (large-list-of constants) (MDEV-24117)

  • Fixes for the following security vulnerabilities:

    • CVE--``#

Changelog

For a complete list of changes made in MariaDB 10.4.17, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.17, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.16 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.16Release NotesChangelogOverview of 10.4

Release date: 3 Nov 2020

MariaDB 10.4 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.16 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

This release introduced an InnoDB data corruption bug (MDEV-24096). If any InnoDB tables contain indexed virtual columns or unique indexes on BLOB or TEXT columns, any InnoDB tables or tablespaces may become irrepairably corrupted.

  • Set the default value of innodb_log_optimize_ddl to OFF by default (MDEV-23720)

  • BLACKHOLE Storage Engine maximum index size increased from 1000 to 3500 bytes (MDEV-24017)

  • Calculating (auto rounding) issue (MDEV-23702)

  • Temporary tables can no longer overwrite existing files. Instead an error is returned should a conflict occur (MDEV-23569)

  • Binlog checksum verification at recovery time (MDEV-23832)

  • Verbose print-out of Geometry types by mysqlbinlog (MDEV-22330)

  • SHOW BINLOG EVENTS from validates when binlog checksummed (MDEV-21839)

  • Freeing memory of replicate_do_table (MDEV-23534)

  • Corrected verbose mysqlbinlog output for multi-record Rows-log-event (MDEV-16372)

  • SET GLOBAL replicate_do_db = DEFAULT no longer causes crash (MDEV-20744)

  • User killed queries that were running an index condition pushdown in InnoDB will now return an error (MDEV-23938)

  • Wrong direxec param data caused crash; Numerous fixes about Mac builds (by Dmitri Shulga) (MDEV-19838)

  • server_audit plugin now logs proxy users (MDEV-19443)

  • Crash on SELECT on a table with indexed virtual columns (MDEV-18366)

  • InnoDB updated to 5.7.32 (MDEV-23989)

  • Bug fixes related to adaptive hash index (MDEV-23452, MDEV-23370)

  • Fixed a bug in the recovery of encrypted tables (MDEV-23456)

  • Fixed a race condition in MVCC reads (MDEV-22924)

  • ALTER TABLE fixes (MDEV-22277, MDEV-22939, MDEV-23199, MDEV-23356, MDEV-23499, MDEV-23672, MDEV-23685, MDEV-23722)

  • Diskspace not reused for BLOB in data file (MDEV-23072)

  • InnoDB: Failing assertion: !space->referenced() (MDEV-23651)

  • SIGSEGV in maria_create() because of double free (MDEV-23222)

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

  • Error upon querying the view, that selecting from versioned table with partitions (MDEV-23779)

  • CREATE .. SELECT wrong result on join versioned table (MDEV-23799)

  • SIGSEGV in check_fields on UPDATE (MDEV-22805)

  • Parser fix (MDEV-23094)

  • Fixed crash in Innodb when rowid_filter query is killed (MDEV-22761)

  • Fixed a crash with the NTH_VALUE function (MDEV-15180)

  • Computing certain window functions on a server started with --encrypt-tmp_files=ON could cause a wrong query result or crash (MDEV-23867)

  • A query with a certain form of WHERE clause over a table with multiple indexes could pick a less efficient range plan (MDEV-23811)

  • Fixed a memory leak for correlated subqueries with ROLLUP (MDEV-17066)

Galera

  • Galera wsrep library updated to 26.4.6

  • Fixed assertion failure on before_commit (MDEV-22681)

  • Fixed assertion after ROLLBACK AND CHAIN (MDEV-22055)

  • IPv6 SST handling improved (MDEV-21770, MDEV-23576, MDEV-23580, MDEV-23581, MDEV-23574)

  • Fixed SIGSEGV in lock_rec_unlock (MDEV-23101)

  • Fixed replication of timezone if only 1 timezone is loaded (MDEV-22626)

  • Fixed replication of CREATE OR REPLACE TRIGGER (MDEV-21578)

  • Fixed SST FLUSH TABLES WITH READ LOCK timeout (MDEV-22543)

Notes

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for CentOS/RHEL 6 and Fedora 31

  • Packages for Ubuntu 20.10 "Groovy Gorilla" added

  • Packages for Debian 10 "buster" arm64 and ppc64el added

  • Packages for Debian 9 "stretch" arm64 added

  • Fixes for the following security vulnerabilities:

    • CVE-2020-14812

    • CVE-2020-14765

    • CVE-2020-14776

    • CVE-2020-14789

    • CVE-2020-28912 (MDEV-24040)

    • CVE-2021-2194 (MDEV-18366)

Changelog

For a complete list of changes made in MariaDB 10.4.16, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.16, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.15 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.15Release NotesChangelogOverview of 10.4

Release date: 7 Oct 2020

MariaDB 10.4 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.15 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

  • Fixes for the following security vulnerabilities:

    • CVE-2020-15180

Changelog

For a complete list of changes made in MariaDB 10.4.15, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.15, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.14 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 10 Aug 2020

MariaDB 10.4 is the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.14 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

Variables

  • Limit innodb_encryption_threads to 255 (MDEV-22258).

  • Minimum value of max_sort_length raised to 8 (previously 4) so fixed size data types like DOUBLE and BIGINT are not truncated for lower values of max_sort_length (MDEV-22715).

InnoDB

  • Fixed corruption in delete buffering (MDEV-22497)

  • Fixed a deadlock in FLUSH TABLES…FOR EXPORT (MDEV-22890)

  • InnoDB data file extension is not crash-safe (MDEV-23190)

  • Minor fixes related to encryption and FULLTEXT INDEX

  • Dropping the adaptive hash index may cause DDL to lock up InnoDB (MDEV-22456)

  • innodb_log_optimize_ddl=OFF is not crash safe (MDEV-21347)

  • Mariadb service won't shutdown when it's running and the OS datetime updated backwards (MDEV-17481)

  • Doublewrite recovery can corrupt data pages (MDEV-11799)

  • Fixed race conditions related to buffer pool resizing

  • ALTER TABLE fixes (MDEV-22637, MDEV-23244, MDEV-22988, MDEV-23295, MDEV-22771)

  • Slow InnoDB shutdown on large instance (MDEV-22778)

  • Performance improvements (MDEV-22778)

  • Crash recovery fixes (MDEV-21347, MDEV-23190, MDEV-11799)

Replication

  • Make the binlog dump thread to log into errorlog a requested GTID position (MDEV-20428)

  • Fix stop of the optimistic parallel slave at requested START-SLAVE-UNTIL position (MDEV-15152)

  • Properly handle RESET MASTER TO value, when the value exceeds the max allowed 2147483647 (MDEV-22451)

  • Correct 'relay-log.info' updating by concurrent parallel workers (MDEV-22806)

  • Eliminate deadlock involving parallel workers, STOP SLAVE and FLUSH TABLES WITH READ LOCK (MDEV-23089)

  • Correct master-slave automatic reconnection by slave to always pass through all steps of the initial connect. Specifically, do not skip master notification about slave binlog checksum awareness (MDEV-14203)

  • Refine mysqlbinlog output to print out START TRANSACTION at Gtid_log_event processing which satisfies clients that submit the output with sql_mode=oracle (MDEV-23108)

  • Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode (MDEV-19632)

Optimizer

  • ALTER TABLE ... ANALYZE PARTITION ... with EITS reads and locks all rows ... (MDEV-21472)

  • Print ranges in the optimizer trace created for non-indexed columns when optimizer_use_condition_selectivity >2 Now the optimizer trace shows the ranges constructed while getting estimates from EITS (MDEV-22665)

  • LATERAL DERIVED is not clearly visible in EXPLAIN FORMAT=JSON, make LATERAL DERIVED tables visible in EXPLAIN FORMAT=JSON output (MDEV-17568)

  • Crash on WITH RECURSIVE large query (MDEV-22748)

  • Crash with Prepared Statement with a '?' parameter inside a re-used CTE (MDEV-22779)

Other

  • div_precision_increment is now taken into account for all intermediate calculations. Previously results could be unpredictable. Note that this means results will have a lower precision in some cases - see div_precision_increment (MDEV-19232)

  • mariadb_schema data type qualifier allowing MariaDB native date types in an SQL_MODE that has conflicting data type translations.

  • MariaDB could crash after changing the query_cache size (MDEV-5924)

  • Errors and SIGSEGV on CREATE TABLE w/ various charsets (MDEV-22111)

  • Crash in CREATE TABLE AS SELECT when the precision of returning type = 0 (MDEV-22502)

  • XA: Reject DDL operations between PREPARE and COMMIT (MDEV-22420)

  • Stop mariadb-backup --prepare on errors during innodb redo log applying (MDEV-22354)

  • Server crashes in mysql_alter_table upon adding a non-null date column under NO_ZERO_DATE with ALGORITHM=INPLACE (MDEV-18042)

  • Can't uninstall plugin if the library file doesn't exist (MDEV-21258)

  • mariadb-backup parameter cleanup (MDEV-18215, MDEV-21298, MDEV-21301, MDEV-22894)

  • Rounding functions return wrong datatype (MDEV-23366, MDEV-23367, MDEV-23368, MDEV-23350, MDEV-23351, MDEV-23337, MDEV-23323)

  • Create mariadb.sys user on each update even is the user is not needed (MDEV-23102)

  • Galera wsrep library updated to 26.4.5

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Ubuntu 19.10 Eoan and Fedora 30

  • Fixes for the following security vulnerabilities:

    • CVE-2021-2022

Changelog

For a complete list of changes made in MariaDB 10.4.14, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.5.5, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.13 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 12 May 2020

MariaDB 10.4 is the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.13 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

Events

  • Fixed issue that, from MariaDB 10.3.19, disabled all events created by a server with a different server_id. Note that the fix does not re-enable affected events. (MDEV-21758)

Privileges

  • SHOW PRIVILEGES now correctly lists the Delete history privilege, rather than displaying it as Delete versioning rows. (MDEV-20382)

Performance

  • Optimizer flag rowid_filter leads to long query (MDEV-21794)

  • WSREP_ON is unnecessarily expensive to evaluate (MDEV-22203

  • Misc wsrep performance optimization (MDEV-7962)

Security

  • Added system user for user view which allows to remove root (MDEV-19650)

  • WolfSSL updated

  • ALTER USER doesn't remove excess authentication plugins from mysql.global_priv (MDEV-21928)

  • mysql_upgrade creating empty global_priv table (MDEV-21244)

Aria

  • Updated aria_pack to support transactional tables and added options: --datadir, --ignore-control-file, --require-control-file, more details here

ALTER TABLE

  • Error on online ADD PRIMARY KEY after instant DROP/reorder (MDEV-21658)

  • Assertion failure in file data0type.cc (MDEV-20726)

  • Server aborts upon attempt to create foreign key on spatial field (MDEV-21792)

  • DROP COLUMN, DROP INDEX is wrongly claimed to be ALGORITHM=INSTANT (MDEV-22465)

  • Introduce a file format constraint to ALTER TABLE. See innodb_instant_alter_column_allowed (MDEV-20590)

  • FORCE all partition to rebuild if any one of the partition does rebuild (MDEV-21832)

  • InnoDB aborts while adding instant column for discarded tablespace (MDEV-22446)

FULLTEXT INDEX

  • Assertion ``!table->fts->in_queue' failed in fts_optimize_remove_table` (MDEV-21550)

  • FTS thread aborts during shutdown (MDEV-21563)

Optimizer

  • Optimizer, Wrong query results with optimizer_switch="split_materialized=on" (MDEV-21614)

  • SHOW GRANTS does not quote role names properly (MDEV-20076)

  • Paritioning INSERT chooses wrong partition for RANGE partitioning by DECIMAL column (MDEV-21195)

mariadb-backup

  • mariadb-backup does not honor ignore_db_dirs from server config (MDEV-19347)

  • mariadb-backup --ftwrl-wait-timeout never times out on explicit lock (MDEV-20230)

Crash Recovery

  • Running out of file descriptors and eventual crash (MDEV-18027)

Galera

  • Galera wsrep library updated to 26.4.4

  • Galera Cluster Node During IST gets stuck going from "Synced" to "Joining:..." (MDEV-21002)

Other

  • HeidiSQL updated to 11.0 (MDEV-22032)

  • Wrong estimate of affected BLOB columns in update of PRIMARY KEY (MDEV-22384)

  • Duplicate key value is silently truncated to 64 characters in print_keydup_error (MDEV-20604)

  • Session tracking returns incorrectly long tracking data (MDEV-22504)

  • Add pam_user_map.so file to binary tarball package (MDEV-21913)

  • mysql_upgrade is made aware of the upstream slave tables to issue warnings when that takes place (MDEV-10047)

  • Corruption for SET GLOBAL innodb_ string variables (MDEV-22393)

  • mysqldump parameter, --ignore-table-data, added (MDEV-22037)

  • Server can fail while replicating conditional comments (Bug#28388217)

  • Added the xml-report option to mysql-test-run (MDEV-22176)

  • Packages and repositories for Ubuntu 20.04 "focal" added

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Debian 8 "Jessie"

  • Fixes for the following security vulnerabilities:

    • CVE-2020-2752

    • CVE-2020-2812

    • CVE-2020-2814

    • CVE-2020-2760

    • CVE-2020-13249

Changelog

For a complete list of changes made in MariaDB 10.4.13, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.13, see the MariaDB Foundation release announcement. Thanks, and enjoy MariaDB!

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.12 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Note that this version contains an issue that disabled all events created by a server with a different server_id. See MDEV-21758 for details.

DownloadRelease NotesChangelogOverview of 10.4

Release date: 28 Jan 2020

MariaDB 10.4 is the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.12 will be a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

General

  • MDEV-21337: fix aligned_malloc()

  • MDEV-21343: Threadpool/Unix- wait_begin() function does not wake/create threa ds, when it should

  • wolfssl updated to v4.3.0-stable

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Ubuntu 19.04 Disco

mariadb-backup

  • MDEV-21255: Deadlock of parallel slave and mariadb-backup (with failed log copy thread)

InnoDB

  • MDEV-20950: Reduce size of record offsets

  • MDEV-19176: Reduce the memory usage during recovery

  • MDEV-21429: TRUNCATE and OPTIMIZE are being refused due to "row size too large"

  • MDEV-21500: Server hang when using simulated AIO

  • MDEV-21509: Possible hang during purge of history, or rollback

  • MDEV-21511: Wrong estimate of affected BLOB columns in update

  • MDEV-21512: InnoDB may hang due to SPATIAL INDEX

  • MDEV-21513: Avoid some crashes in ALTER TABLE...IMPORT TABLESPACE

  • MDEV-18865: Assertion `t->first->versioned_by_id()' failed in innodb_prepare_commit_versioned

  • MDEV-21260: InnoDB does not report error when trying open volumes on UNC paths on Windows

Aria

  • MDEV-14183: aria_pack segfaults in compress_maria_file

Optimizer

  • MDEV-21318: Wrong results with window functions and implicit grouping

  • MDEV-16579: Wrong result of query using DISTINCT COUNT() OVER ()

  • MDEV-21383: Possible range plan is not used under certain conditions

Replication

  • MDEV-18046: Crashes caused by random values to the offset option of SHOW BINLOG EVENT offset command

  • MDEV-19376: Semisync Master could crash when it executed RESET MASTER and a replica reconnects using GTID protocol

  • MDEV-20821: parallel slave server shutdown may hang when slave workers were online

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2020-2574

    • CVE-2020-7221

Changelog

For a complete list of changes made in MariaDB 10.4.12, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.12, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.11 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Note that this version contains an issue that disabled all events created by a server with a different server_id. See MDEV-21758 for details.

DownloadRelease NotesChangelogOverview of 10.4

Release date: 11 Dec 2019

MariaDB 10.4 is the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.11 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

General

  • MDEV-13492: SEC_E_INVALID_TOKEN when server sends large message during SSL handshake

mariadb-backup

  • MDEV-18310: Aria engine: Undo phase failed from incremental backup

InnoDB

  • MDEV-20949: Stop issuing 'row size' error on DML

  • MDEV-20832: Don't print "row size too large" warnings in error log if innodb_strict_mode=OFF and log_warnings<=2

  • MDEV-21024: Remove redundant writes to the redo log

  • MDEV-21069: Crash on DROP TABLE if the data file is corrupted

  • some cleanup of AIO code, to better report errors

  • MDEV-20611: MRR scan over partitioned InnoDB table produces "Out of memory" error

  • MDEV-21088: Table cannot be loaded after instant ADD/DROP COLUMN

  • MDEV-21045: heap-use-after-poison in ADD PRIMARY KEY after instant ADD COLUMN

  • MDEV-21172: Memory leak after failed ADD PRIMARY KEY

  • MDEV-21158: trx_undo_seg_free() is never redo-logged

  • MDEV-20190: Instant operation fails when add column and collation change on non-indexed column

Optimizer

  • MDEV-21044: Wrong result when using a smaller size for sort buffer

  • MDEV-20611: MRR scan over partitioned InnoDB table produces "Out of memory" error

  • MDEV-20407: mysqld got signal 11; rowid_filter

Replication

  • MDEV-19376: Repl_semi_sync_master::commit_trx assertion failure

  • MDEV-20707: Missing memory barrier in parallel replication error handler in wait_for_prior_commit()

Versioning

  • MDEV-18929: 2nd execution of SP does not detect ER_VERS_NOT_VERSIONED

  • MDEV-21011: Table corruption reported for versioned partitioned table after DELETE

Misc

  • Packages for Fedora 31 have been added in this release

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Fedora 29

  • Fixes for the following security vulnerabilities:

    • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 10.4.11, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.11, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.10 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Note that this version contains an issue that disabled all events created by a server with a different server_id. See MDEV-21758 for details.

DownloadRelease NotesChangelogOverview of 10.4

Release date: 8 Nov 2019

MariaDB 10.4 is the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.10 will be a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

  • MDEV-20987: InnoDB fails to start when FTS table has FK relation

  • See also the release notes for MariaDB 10.4.9 for additional items of note

  • Fixes for the following security vulnerabilities:

    • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 10.4.10, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.10, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.9 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

After an upgrade MariaDB Server can crash if InnoDB tables exist with a FULLTEXT INDEX and a FOREIGN KEY constraint attached to them. We got reports that the crash already will be encountered on startup, but a crash is also possible at a later stage. See MDEV-20987 for more details.Do not download or use this release.

DownloadRelease NotesChangelogOverview of 10.4

Alternate download from mariadb.org

Release date: 5 Nov 2019

MariaDB 10.4 is the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.9 will be a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

  • MDEV-20864: Debug-only option innodb_change_buffer_dump for dumping the contents of the InnoDB change buffer to the server error log at startup.

  • mariadb-backup:

    • MDEV-18438: mbstream recreates xtrabackup_info on same directory as backup file

    • MDEV-20703: mariadb-backup creates binlog files in server binlog directory on --prepare --export step

  • FULLTEXT INDEX:

    • MDEV-19647: Server hangs after dropping full text indexes and restart

    • MDEV-19529: InnoDB hang on DROP FULLTEXT INDEX

    • MDEV-19073: FTS row mismatch after crash recovery

    • MDEV-20621: FULLTEXT INDEX activity causes InnoDB hang

  • MDEV-20927: Duplicate key with auto increment

  • ALTER TABLE:

    • MDEV-20799: DROP Virtual Column crash

    • MDEV-20852: BtrBulk is unnecessarily holding dict_index_t::lock

  • System-Versioned Tables:

    • MDEV-16210: FK constraints on versioned tables use historical rows, which may cause constraint violation

    • MDEV-20812: Unexpected ER_ROW_IS_REFERENCED_2 or server crash in row_ins_foreign_report_err upon DELETE from versioned table with FK

  • MDEV-20117: corruption after instant DROP/reorder COLUMN

  • Galera wsrep library updated to 26.4.3

  • Packages for Ubuntu 19.10 Eoan have been added in this release

  • Fixes for the following security vulnerabilities:

    • CVE-2019-2974

    • CVE-2019-2938

    • CVE-2020-2780

    • CVE-2021-2144

Changelog

For a complete list of changes made in MariaDB 10.4.9, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.9, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.8 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 11 Sep 2019

MariaDB 10.4 is the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.8 will be a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

  • Connect updated to Connect 1.06.0010

  • MDEV-20231: Update server HELP

  • MDEV-20066: This bug could cause a table to become corrupt if a column was added instantly

  • MDEV-15326: A race condition in InnoDB transaction commit that affects record locking was fixed

  • MDEV-17187: Table doesn't exist in engine after ALTER of FOREIGN KEY

  • MDEV-20301: InnoDB's MVCC has O(N^2) behaviors

  • MDEV-18128: Simplify .ibd file creation

  • MDEV-20060: Failing assertion: srv_log_file_size <= 512ULL << 30 while preparing backup

  • MDEV-20247: Replication hangs with "preparing" and never starts

  • MDEV-17614: Remove unnecessary locking for INSERT...ON DUPLICATE KEY UPDATE

  • MDEV-20311: row_ins_step accesses uninitialized memory

  • MDEV-20479: Assertion failure in dict_table_get_nth_col() after INSTANT DROP COLUMN

  • MDEV-20340: Encrypted temporary tables cannot be read with innodb_checksum_algorithm=full_crc32

  • MDEV-19947: Repositories for RHEL 8 ppc64le added

  • Fixes for the following security vulnerabilities:

    • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 10.4.8, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.8, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.7 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 31 Jul 2019

MariaDB 10.4 is the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.7 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

  • MDEV-19922: HeidiSQL updated to 10.2

  • MDEV-19795: Merge upstream MyRocks.

  • MDEV-17228: Encrypted temporary tables are not encrypted.

  • MDEV-18328: Disks Plugin is now stable and requires the FILE privilege.

  • MDEV-16508: Spider - sql_mode not maintained between spider node and data nodes.

  • Merge relevant InnoDB changes from MySQL 5.7.27

  • Adjust spin loops to the x86 PAUSE instruction latency (MDEV-19845)

  • MDEV-20102: When the ctas from a big table is interrupted ,then you can't drop or recreate the table

  • MDEV-19292: InnoDB's row size calculations were fixed, which might result in "Row size too large" errors when creating or altering tables with lots columns. This can occur even if previous MariaDB releases did not throw errors for the same tables. Some workarounds are listed at InnoDB Row Formats Overview: Upgrading Causes Row Size Too Large Errors.

  • ALTER TABLE: MDEV-15641, MDEV-19630, MDEV-19916, MDEV-19974, MDEV-17301, MDEV-18266

  • Indexed virtual columns: MDEV-16222, MDEV-17005, MDEV-19870

  • FULLTEXT INDEX: MDEV-14154

  • Encryption: MDEV-17228, MDEV-19914

  • Galera + FOREIGN KEY: MDEV-19660

  • Recovery & mariadb-backup: MDEV-19978

  • MDEV-20091: DROP TEMPORARY table is logged despite no CREATE was logged

  • MDEV-19871: Add page id matching check in innochecksum tool

  • MDEV-20179: Server hangs on shutdown during installation of Spider

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for OpenSUSE 42.3 and Ubuntu 18.10 "Cosmic"

  • Fixes for the following security vulnerabilities:

    • CVE-2019-2805

    • CVE-2019-2740

    • CVE-2019-2739

    • CVE-2019-2737

    • CVE-2019-2758

    • CVE-2020-2922

    • CVE-2021-2007

Changelog

For a complete list of changes made in MariaDB 10.4.7, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.7, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.6 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 18 Jun 2019

With this release, MariaDB 10.4 is now the current stable series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.6 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

  • MariaDB Server is now statically linked with the bundled wolfSSL library in MSI and ZIP packages on Windows, as well as in .deb packages provided by Debian's and Ubuntu's default repositories (MDEV-18531).

    • See TLS and Cryptography Libraries Used by MariaDB for more details.

  • MariaDB Named Commands (MDEV-17591)

  • System-versioned tables: MDEV-19486

  • Galera: MDEV-17458

  • Virtual columns: MDEV-19027, MDEV-19602

  • Recovery: MDEV-19541, MDEV-19587, MDEV-19435

  • Encryption: MDEV-19509, MDEV-19695

  • Other:

    • MDEV-19614 - SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables

    • MDEV-19725 - Incorrect error handling in ALTER TABLE

  • Fixes for the following security vulnerabilities:

    • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 10.4.6, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.6, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.5 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 21 May 2019

MariaDB 10.4 is the current development series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.5 is a Release Candidate (RC) release.

Do not use non-stable (non-GA) releases in production!

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

General Server

  • New mysqlimport option, --ignore-foreign-keys (MDEV-788).

  • Setting sql_mode to MSSQL implements a limited subset of Microsoft SQL Server's language. See SQL_MODE=MSSQL (MDEV-19142).

  • Add CAST(expr AS FLOAT) (MDEV-16872).

  • List of slave transaction errors that will result in a retry rather than a halt (slave_transaction_retry_errors) have been increased by default, assisting Spider setups to be more robust (MDEV-16543).

  • MDEV-15458 - Segfault in heap_scan() upon UPDATE after ADD SYSTEM VERSIONING

  • MDEV-19235 - MariaDB Server compiled for 128 Indexes crashes at startup

JSON

  • JSON_MERGE_PATCH and JSON_MERGE_PRESERVE (MDEV-13992)

InnoDB

  • Merge InnoDB changes from MySQL 5.6.44 and 5.7.26

  • Fixes of corruption or crashes: MDEV-19241, MDEV-13942, MDEV-19385, MDEV-16060, MDEV-18220, MDEV-17540

  • InnoDB recovery fixes and speedup: MDEV-12699, MDEV-19356

Encryption

  • MDEV-14398 - innodb_encrypt_tables will work even with innodb_encryption_rotate_key_age=0

System-Versioned Tables

  • MDEV-15966 - System-versioned tables are now protected from TRUNCATE TABLE statements.

Information schema

  • MDEV-19490 show tables fails when selecting the information_schema database

Statistics

  • MDEV-19407 - Assertion `field->table->stats_is_read' failed in is_eits_usable

  • New status variable, Aborted_connects_preauth, that records the number of connection attempts that were aborted prior to authentication (MDEV-19277).

Packaging

  • As per the MariaDB Deprecation Policy, this is the last release of MariaDB 10.4 for Fedora 28

  • Packages and a repository for Fedora 30 and Ubuntu 19.04 "disco" have been added with this release, visit the Repository Configuration Tool for instructions on adding the repository

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2019-2614

    • CVE-2019-2627

    • CVE-2019-2628

Changelog

For a complete list of changes made in MariaDB 10.4.5, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.5, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.4 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 7 Apr 2019

MariaDB 10.4 is the current development series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.4 is a Release Candidate release.

Do not use non-stable (non-GA) releases in production!

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

  • Enhancements:

    • MDEV-12026/MDEV-18644: innodb_checksum_algorithm=full_crc32 (more robust file format)

    • MDEV-13301: Optimize DROP INDEX, ADD INDEX into RENAME INDEX

    • MDEV-17380: innodb_flush_neighbors=ON should be ignored on SSD

  • InnoDB data corruption fixes: MDEV-14126, MDEV-18981, MDEV-18879, MDEV-18972, MDEV-18272

  • Performance fixes to purge, startup and shutdown: MDEV-18936, MDEV-18878, MDEV-18733

  • Various fixes to ALTER TABLE

  • Replication:

    • MDEV-18450: wait for all slaves shutdown

    • MDEV-19116, MDEV-19117: speed up rotation of binary logs, SHOW BINARY LOGS etc with optimizing binary log index file locking

  • Includes Connector/C 3.1.0

  • Repositories for CentOS 7, RHEL 7 & 8, Fedora 28 & 29, and SLES 12 & 15 now include a src.rpm file that you can use to build MariaDB. Instructions for doing so are found on theBuilding MariaDB from a Source RPM page

  • The Galera library in the repositories has been updated to version 26.4.2

  • As per the MariaDB Deprecation Policy, this is the last release of MariaDB 10.4 for Ubuntu 14.04 Trusty

  • Fixes for the following security vulnerabilities:

    • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 10.4.4, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.4, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.3 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 25 Feb 2019

MariaDB 10.4 is the current development series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.3 is a Release Candidate release.

Do not use non-stable (non-GA) releases in production!

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

  • MDEV-12484: The unix_socket authentication plugin is now default on Unix-like systems, which is a major change to authentication in MariaDB

  • MDEV-11340: Allow multiple alternative authentication methods for the same user

  • MDEV-7597: User password expiry

  • MDEV-6111: Implementation of the optimizer trace, one can enable the optimizer trace by enabling the system variable optimizer_trace

  • Temporal tables extended with support for application-time periods (MDEV-16973, MDEV-16974, MDEV-16975, MDEV-17082)

  • MDEV-18551: The default for eq_range_index_dive_limit is now 200 (previously 0)

  • MDEV-17903: The optimizer switch flag optimize_join_buffer_size now defaults to on

  • New optimizer switch flags rowid_filter and condition_pushdown_from_having

  • MDEV-18439: core_file on Windows now defaults to ON

  • MDEV-18608: Histograms are now used (but not collected) by default.

  • MDEV-13916: The JSON_VALID function is automatically used as a CHECK constraint for the JSON data type alias in order to ensure that a valid json document is inserted

  • Spider updated to 3.3.14

  • Unique indexes can be created on BLOB or TEXT fields (MDEV-371)

  • MDEV-18564: wsrep_load_data_splitting is deprecated and now set to OFF by default

  • analyze_sample_percentage system variable

  • InnoDB ALTER TABLE fixes: MDEV-18222, MDEV-18256, MDEV-18016, MDEV-18295, MDEV-16849, MDEV-18219

  • mariadb-backup fixes: MDEV-18194, MDEV-18415, MDEV-18611

  • New InnoDB features:

    • MDEV-12026: Implement innodb_checksum_algorithm=full_crc32

    • MDEV-15563: More Instant VARCHAR extension

    • MDEV-15564: Instant collation or charset changes for non-indexed columns

    • MDEV-16188: Use in-memory PK filters built from range index scans

  • Debian has stopped supporting the ppc64el architecture for Debian 8 Jessie and so this is the last release of MariaDB 10.4 on Jessie for that architecture

  • Fixes for the following security vulnerabilities:

    • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 10.4.3, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.3, see the MariaDB Foundation release announcement.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.2 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 29 Jan 2019

MariaDB 10.4 is the current development series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.2 is a Beta release.

Do not use beta releases in production!

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

  • Galera 4 version 26.4.0 has been added in this release, see the Galera 4 Notes section for details

  • Account Locking (MDEV-13095)

  • a number of bugs related to MDEV-15562 Instant DROP COLUMN have been fixed

  • New variable, max_password_errors for limiting the number of failed connection attempts by a user.

  • MDEV-17475: Maximum value of table_definition_cache is now 2097152.

Galera 4 Notes

Upgrading to Galera 4 version 26.4.0

Rolling upgrades from earlier 10.3 (or older) MariaDB releases are not supported in this release. For upgrading a 10.3-based cluster, any applications accessing the cluster should be stopped and the cluster shut down. Then for each cluster node the following procedure should be carried out:

  • Install MariaDB 10.4.2 and Galera 4 version 26.4.0

  • Start MariaDB server, but make sure it is not trying to connect to the cluster by configuring wsrep_provider=none

  • While MariaDB server is running, run mysql_upgrade for the server

  • Stop MariaDB server

After that, you can bootstrap the cluster. If there was ongoing application load on the cluster during the initial cluster shutdown phase, you should make sure to bootstrap the cluster with the node which was shutdown last.

We are working on rolling upgrade support for the final GA version of MariaDB 10.4. With a rolling upgrade, a live cluster can be upgraded node by node, and the cluster is able to process application load when having a hybrid setup of 10.3 and 10.4 nodes.

New Features in Galera 26.4.0

The ‘mysql’ schema contains new Galera replication related tables:

  • wsrep_cluster

  • wsrep_cluster_members

  • wsrep_streaming_log

End users may read but not modify these tables.

The new streaming replication feature allows replicating transactions of unlimited size. With streaming replication, a cluster is replicating a transaction in small fragments during transaction execution. This transaction fragmenting is controlled by two new configuration variables:

  • wsrep_trx_fragment_unit (bytes, rows, statements) defines the metrics for how to measure transaction size limit for fragmenting. Possible values are:

    • bytes: transaction’s binlog events buffer size in bytes

    • rows: number of rows affected by the transaction

    • statements: number of SQL statements executed in the multi-statement transaction

  • wsrep_trx_fragment_size defines the limit for fragmenting. When a transaction’s size, in terms of the configured fragment unit, has grown over this limit, a new fragment will be replicated.

Transactions replicated through galera replication will now process the commit phase using MariaDB's group commit logic. This will affect transaction throughput, especially when binary logging is enabled in the cluster.

Limitations in Galera 26.4.0

  • Upgrading from 10.3 version 25.3.25 to 10.4.2 version 26.4.0 must happen on a stopped cluster. Only after all nodes have been upgraded to MariaDB 10.4.2 and Galera 26.4.0 can the cluster be started up

  • Splitting transactions of LOAD DATA execution will conflict with streaming replication, and should not be used if streaming replication is configured

  • Fixes for the following security vulnerabilities:

    • CVE-`-```

Changelog

For a complete list of changes made in MariaDB 10.4.2, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.2, see the MariaDB Foundation release announcement.

Do not use beta releases in production!

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.1 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 20 Dec 2018

MariaDB 10.4 is the current development series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.1 is a Beta release.

Do not use beta releases in production!

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

This will be the first beta release in the MariaDB 10.4 series.

Notable changes of this release include:

Syntax

  • New FLUSH SSL command to reload SSL certificates without server restart (MDEV-16266)

  • New CAST target — CAST(x AS INTERVAL DAY_SECOND(N)) (MDEV-17776)

Variables

  • New sql-mode setting, TIME_ROUND_FRACTIONAL (MDEV-16991)

  • Two new values for the variable use_stat_tables: COMPLEMENTARY_FOR_QUERIES and PREFERABLY_FOR_QUERIES (MDEV-17255)

  • Engine Independent Table Statistics is now enabled by default; new default values are use_stat_tables=PREFERABLY_FOR_QUERIES and optimizer_use_condition_selectivity=4 (MDEV-15253)

  • New variable gtid_cleanup_batch_size for determining how many old rows must accumulate in the mysql.gtid_slave_pos table before a background job will be run to delete them.

Other Features

  • Support for window UDF functions via the new method x_remove (MDEV-15073)

  • Json service for plugins (MDEV-5313)

  • Much faster privilege checks for MariaDB setups with many user accounts or many database grants (MDEV-15649)

  • mysql.user table is retired. User accounts and global privileges are now stored in the mysql.global_priv table (MDEV-17658)

  • Change in behavior for FLUSH TABLES (MDEV-5336).

Bug Fixes

Lots of miscellaneous fixes, including:

  • Bug fixes for MDEV-15562 instant DROP COLUMN

Changelog

For a complete list of changes made in MariaDB 10.4.1, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.1, see the MariaDB Foundation release announcement.

Do not use beta releases in production!

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL

MariaDB 10.4.0 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.4

Release date: 9 Nov 2018

MariaDB 10.4 is the current development series of MariaDB. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.0 is an Alpha release.

Do not use alpha releases in production!

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Changes

This will be the first alpha release in the MariaDB 10.4 series.

Notable changes of this release include:

InnoDB

  • Added instant DROP COLUMN and changing of the order of columns (MDEV-15562)

  • Reduced redo log volume for undo tablespace initialization (MDEV-17138)

  • Removed crash-upgrade support for pre-10.2.19 TRUNCATE TABLE (MDEV-13564)

  • Added key rotation for innodb_encrypt_log (MDEV-12041)

Optimizer

  • Push conditions into materialized IN subqueries (MDEV-12387)

Variables

  • Added the tcp_nodelay system variable (MDEV-16277)

  • Removed the global Innodb_pages0_read status variable (MDEV-15705).

General

  • IF NOT EXISTS clause added to INSTALL PLUGIN and IF EXISTS clause added to UNINSTALL PLUGIN and UNINSTALL SONAME (MDEV-16294)

  • The obsolete mysql.host table is no longer created (MDEV-15851)

  • Support of brackets (parentheses) for specifying precedence in UNION/EXCEPT/INTERSECT operations (MDEV-11953)

  • Crash safe Aria-based system tables (MDEV-16421)

  • Added Linux abstract socket support (MDEV-15655)

  • Enabled C++11 (MDEV-16410)

  • SET PASSWORD support for ed25519 and other authentication plugins (MDEV-12321)

  • Performance improvements in Unicode collations (MDEV-17534, MDEV-17511, MDEV-17502, MDEV-17474)

  • User data type plugins (MDEV-4912, in progress)

  • Improvements with SQL standard INTERVAL support to help functions TIMESTAMP() and ADDTIME() return more predictable results.

    • Historically, MariaDB uses the TIME data type for both "time of the day" values and "duration" values. In the first meaning the natural value range is from '00:00:00' to '23:59:59.999999', in the second meaning the range is from '-838:59:59.999999' to '+838:59:59.999999'.

    • To remove this ambiguity and for the SQL standard conformance we plan to introduce a dedicated data type INTERVAL that will be able to store values in the range at least from '-87649415:59:59.999999' to '+87649415:59:59.999999', which will be enough to represent the time difference between TIMESTAMP'0001-01-01 00:00:00' and TIMESTAMP'9999-12-31 23:59:59.999999'.

    • As a first step we support this range of values for intermediate calculations when TIME-alike string and numeric values are used in INTERVAL (i.e. duration) context, e.g. as the second argument of SQL functions TIMESTAMP(ts,interval) and ADDTIME(ts,interval), so the following can now be calculated:

SELECT ADDTIME(TIMESTAMP'0001-01-01 00:00:00', '87649415:59:59.999999');
-> '9999-12-31 23:59:59.999999'  

SELECT TIMESTAMP(DATE'0001-01-01', '87649415:59:59.999999')
-> '9999-12-31 23:59:59.999999'  

SELECT ADDTIME(TIME'-838:59:59.999999', '1677:59:59.999998');
-> '838:59:59.999999'

Changelog

For a complete list of changes made in MariaDB 10.4.0, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.4.0, see the MariaDB Foundation release announcement.

Do not use alpha releases in production!

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

This page is licensed: CC BY-SA / Gnu FDL