InnoDB

• Crash on in a 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 ()

Optimizer

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

Docker Official Images

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

Security

• Fixes for the following :

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

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)

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

JSON

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

Replication

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

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

• 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 . 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:

Docker Official Image

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

• The number of gpg 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 : <</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.

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

  • and mysql-connector-java (all versions)

• Arbitrary InnoDB buffer pool and data file corruption ()

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

• Fixes for the following :

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

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

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

Security

• Fixes for the following :

  • CVE-2021-46665

  • CVE-2021-46664

  • CVE-2021-46661

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.

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

• : Crash on DROP TABLE if the data file is corrupted

• some cleanup of AIO code, to better report errors

• : MRR scan over partitioned InnoDB table produces "Out of memory" error

• : Table cannot be loaded after instant ADD/DROP COLUMN

• : heap-use-after-poison in ADD PRIMARY KEY after instant ADD COLUMN

• : Memory leak after failed ADD PRIMARY KEY

• : trx_undo_seg_free() is never redo-logged

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

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

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

• (MDEV-13095)

• a number of bugs related to MDEV-15562 Instant DROP COLUMN have been fixed

• New variable, for limiting the number of failed connection attempts by a user.

• : Maximum value of 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:

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

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

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

List of slave transaction errors that will result in a retry rather than a halt () have been increased by default, assisting setups to be more robust (MDEV-16543).

Notable Changes

This will be the first alpha release in the MariaDB 10.4 series.

Notable changes of this release include:

InnoDB

• Added instant 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

• (MDEV-12387)

Variables

• Added the system variable (MDEV-16277)

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

General

• IF NOT EXISTS clause added to and IF EXISTS clause added to and (MDEV-16294)

• The obsolete is no longer created (MDEV-15851)

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

• Crash safe -based ()

• Added Linux abstract socket support ()

• Enabled C++11 ()

• support for and other ()

• Performance improvements in collations (, , , )

• User data type plugins (, in progress)

• Improvements with SQL standard INTERVAL support to help functions and 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'.

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!

Notable Items

InnoDB

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

• Indexed columns are broken with NO_PAD (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 ()

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

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

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

  • The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: and the checksum for the file can be found at:

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

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

• speed up Docker Library initialization of timezones (, )

Security

• Fixes for the following :

  • CVE-2022-24052

  • CVE-2022-24051

  • CVE-2022-24050

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.

Notable changes of this release include:

• MDEV-19922: updated to 10.2

• MDEV-19795: Merge upstream .

• MDEV-17228: Encrypted temporary tables are not encrypted.

• MDEV-18328: is now stable and requires the .

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

• : When the ctas from a big table is interrupted ,then you can't drop or recreate the table

• : 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 .

• ALTER TABLE: , , , , ,

• Indexed virtual columns: , ,

• FULLTEXT INDEX:

• Encryption: ,

• Galera + FOREIGN KEY:

• Recovery & mariadb-backup:

• : DROP TEMPORARY table is logged despite no CREATE was logged

• : Add page id matching check in innochecksum tool

• : Server hangs on shutdown during installation of Spider

• As per the , this will be the last release of for OpenSUSE 42.3 and Ubuntu 18.10 "Cosmic"

• Fixes for the following :

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.

Notable changes of this release include:

• MDEV-12484: The 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:

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

• extended with support for (, , , )

• : The default for is now 200 (previously 0)

• : The flag optimize_join_buffer_size now defaults to on

• New flags rowid_filter and condition_pushdown_from_having

• : on Windows now defaults to ON

• : are now used (but not collected) by default.

• : The function is automatically used as a for the in order to ensure that a valid json document is inserted

• updated to 3.3.14

• Unique indexes can be created on or fields ()

• : is deprecated and now set to OFF by default

• system variable

• InnoDB ALTER TABLE fixes: , , , , ,

• mariadb-backup fixes: , ,

• New InnoDB features:

  • : Implement

  • : More Instant VARCHAR extension

  • : Instant collation or charset changes for non-indexed columns
• Debian has stopped supporting the ppc64el architecture for Debian 8 Jessie and so this is the last release of on Jessie for that architecture

• Fixes for the following :

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

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:

CVE-2019-2737

InnoDB

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

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

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

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

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

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

• innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error ()

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

• Optimize is_file_on_ssd() to speedup opening tablespaces on Windows ()

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

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

• Significant slowdown for query with many outer joins ()

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

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

• seconds_behind_master is inaccurate for Delayed replication ()

• detailize the semisync replication magic number error ()

• Parallel replication deadlock victim preference code errorneously removed ()

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

• Galera node remains paused after interleaving FTWRLs ()

• Failed to insert streaming client ()

• When set at runtime, accepts any value ()

• galera needs packaging script changes to successfully build ()

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

• (mysqlbinlog) option (MDEV-25369)

• (mysqladmin) wrong error with (MDEV-22418)

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

• (mysql_install_db) doesn't properly grant to all default root user accounts ()

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

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

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

• Wrong bit encoding using COALESCE ()

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

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

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

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

• MyISAM wrong server status flags ()

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

• slow log Rows_examined out of range ()

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

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

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

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

• hash unique corrupts index on virtual blobs ()

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

• Valgrind/MSAN warnings in dynamic_column_update_move_left ()

• Memory leak showed in test suite ()

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

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

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

• mariadb-upgrade fails with sql_safe_updates = on ()

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

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

• Missing CHACHA20-POLY1305 support in WolfSSL ()

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

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

• Better indication of refusing to start because of ProtectHome ()

• Database upgrade fails: slow_log table ()

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

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

Docker Official Images

• Invert single and double quotes for sql command definitions in due to failure under - contribution by Dominik Häckel

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

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

• 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 for root@MARIADB_ROOT_HOST - reported by Matthieu Gusmini

• added --galera_online test, to match what the does.

Security

• Fixes for the following :

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

Events

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

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

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

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

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

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

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

• Corruption for SET GLOBAL innodb_ string variables ()

• parameter, --ignore-table-data, added ()

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

• Added the xml-report option to ()

• Packages and for Ubuntu 20.04 "focal" added

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

• Fixes for the following :

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!

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

• Crashes with nested table value constructors ()

• Server crashes in thd_clear_errors() ()

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

mariadb-backup

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

InnoDB

• Deprecated the *innodb and *none options in (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 ()

• innodb_flush_method=O_DIRECT fails on compressed tables ()

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

• Signal 11 on TABLE_LIST::placeholder() ()

• ALTER TABLE not replicated with Galera in ()

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

• Avoid unnecessary rollbacks with SR ()

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 :

  • CVE-2021-2166

  • CVE-2021-2154

  • CVE-2022-21451

MongoDB protocol support files for the engine are missing in this release. If you want to use engine with MongoDB, you need to download Mongo2.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.

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 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:

  • : Server hangs after dropping full text indexes and restart

  • : InnoDB hang on DROP FULLTEXT INDEX

  • : FTS row mismatch after crash recovery
• : Duplicate key with auto increment

• ALTER TABLE:

  • : DROP Virtual Column crash

  • : BtrBulk is unnecessarily holding dict_index_t::lock

• System-Versioned Tables:

  • : FK constraints on versioned tables use historical rows, which may cause constraint violation

  • : Unexpected ER_ROW_IS_REFERENCED_2 or server crash in row_ins_foreign_report_err upon DELETE from versioned table with FK

• : corruption after instant DROP/reorder COLUMN

• updated to 26.4.3

• Packages for Ubuntu 19.10 Eoan have been added in this release

• Fixes for the following :

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.

• Fixes for the following :

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

CVE-2020-2760

CVE-2021-2144