All pages
Powered by GitBook
1 of 25

Release Notes - MariaDB 10.6 Series

Release notes for MariaDB Community Server 10.6 series releases

MariaDB 10.6 Changes & Improvements

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

MariaDB 10.6 is a long-term maintenance stable version. The first stable release was in July 2021, and it will be maintained until July 2026.

Upgrading

  • See Upgrading Between Major MariaDB Versions and Upgrading from MariaDB 10.5 to MariaDB 10.6.

New Features & Improvements

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

Atomic DDL

  • CREATE TABLE, ALTER TABLE, RENAME TABLE, DROP TABLE, DROP DATABASE and related DDL statements are now atomic. Either the statement is fully completed, or everything is reverted to it's original state. Note that when deleting multiple tables with DROP TABLE, only each individual drop is atomic, not the full list of tables). (MDEV-23842).

SQL Syntax

  • Implement SQL-standard SELECT ... OFFSET ... FETCH (MDEV-23908)

  • Add SELECT ... SKIP LOCKED syntax (InnoDB only) (MDEV-13115)

  • Indexes can be ignored (MDEV-7317, MDEV-25075)

  • JSON_TABLE, used to extract JSON data based on a JSON path expression and to return it as a relational table (MDEV-17399)

Oracle Compatibility

  • Anonymous subqueries in a FROM clause (no AS clause) are permitted in ORACLE mode (MDEV-19162)

  • ADD_MONTHS() added (MDEV-20025)

  • TO_CHAR() added (MDEV-20017)

  • SYS_GUID() added (MDEV-24285)

  • MINUS is mapped to EXCEPT in UNION (MDEV-20021)

  • ROWNUM function returns the current number of accepted rows in the current context (MDEV-24089)

InnoDB

  • Optimization to speed up inserts into an empty table (MDEV-515)

  • We intended to deprecate and eventually remove the InnoDB's COMPRESSED row format. The first step was to make the tables read-only by default, but this plan was abandoned from MariaDB 10.6.6 (MDEV-23497) (MDEV-27736)

  • Information Schema SYS_TABLESPACES now directly reflects the filesystem, and SYS_DATAFILES has been removed (MDEV-22343)

  • Defer writes to the InnoDB temporary tablespace (MDEV-12227)

  • The old MariaDB 5.5-compatible innodb checksum is no longer supported, only crc32. Removed the *innodb and *none options from innodb_checksum_algorithm, and the --strict-check/-C and --write/-w options from innochecksum (MDEV-25105)

Replication, Galera and Binlog

  • Increase master_host limit to 255, user to 128 (MDEV-24312)

  • The wsrep_mode system variable, for turning on WSREP features which are not part of default behavior (including the experimental Aria replication) (MDEV-20008, MDEV-20715, MDEV-24946)

  • The delay between binary log purges can now be specified with much greater precision. The system variable binlog_expire_logs_seconds is introduced as a form of alias for expire_logs_days, which now accepts a precision of 1/1000000 days (MDEV-19371)

  • Allow transition from unencrypted to TLS Galera cluster communication without cluster downtime (MDEV-22131)

Sys Schema

  • Bundle sys-schema, a collection of views, functions and procedures to help administrators get insight into database usage. (MDEV-9077)

Performance Schema

  • Merged replication instrumentation and tables (MDEV-16437, MDEV-20220)

Information Schema

  • The views INFORMATION_SCHEMA.KEYWORDS and INFORMATION_SCHEMA.SQL_FUNCTIONS have been added to the information schema (MDEV-25129)

Storage Engines

  • TokuDB has been removed (MDEV-19780)

  • CassandraSE has been removed (MDEV-23024)

Character Sets

  • The utf8 character set (and related collations) is now by default an alias for utf8mb3 rather than the other way around. It can be set to imply utf8mb4 by changing the value of the old_mode system variable (MDEV-8334)

General

  • Bundle sys schema (MDEV-9077)

  • Do not resend unchanged resultset metadata for prepared statements (MDEV-19237)

  • --bind-address=hostname now listens on both IPv6 and IPv4 addresses (MDEV-6536)

  • Support systemd socket activation (MDEV-5536)

  • For the GSSAPI plugin, support AD or local group name, and SIDs on Windows (MDEV-23959)

  • Check for $MARIADB_HOME/my.cnf (MDEV-21365)

Variables

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

  • max_recursive_iterations has been reduced to 1000 (MDEV-17239)

InnoDB Variables

The following deprecated variables have been removed (MDEV-23397):

  • innodb_adaptive_max_sleep_delay

  • innodb_background_scrub_data_check_interval

  • innodb_background_scrub_data_compressed

  • innodb_background_scrub_data_interval

  • innodb_background_scrub_data_uncompressed

  • innodb_buffer_pool_instances

  • innodb_commit_concurrency

  • innodb_concurrency_tickets

  • innodb_file_format

  • innodb_large_prefix

  • innodb_lock_schedule_algorithm

  • innodb_log_checksums

  • innodb_log_compressed_pages

  • innodb_log_files_in_group

  • innodb_log_optimize_ddl

  • innodb_page_cleaners

  • innodb_replication_delay

  • innodb_scrub_log

  • innodb_scrub_log_speed

  • innodb_sync_array_size

  • innodb_thread_concurrency

  • innodb_thread_sleep_delay

  • innodb_undo_logs

Security Vulnerabilities Fixed in MariaDB 10.6

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

  • CVE-2025-21490: MariaDB 10.6.21

  • CVE-2024-21096: MariaDB 10.6.18

  • CVE-2023-5157: MariaDB 10.6.9

  • CVE-2023-22084: MariaDB 10.6.16

  • CVE-2022-47015: MariaDB 10.6.13

  • CVE-2022-38791: MariaDB 10.6.9

  • CVE-2022-32091: MariaDB 10.6.9

  • CVE-2022-32089: MariaDB 10.6.9

  • CVE-2022-32088: MariaDB 10.6.8

  • CVE-2022-32087: MariaDB 10.6.8

  • CVE-2022-32086: MariaDB 10.6.8

  • CVE-2022-32085: MariaDB 10.6.8

  • CVE-2022-32084: MariaDB 10.6.9

  • CVE-2022-32083: MariaDB 10.6.8

  • CVE-2022-32082: MariaDB 10.6.9

  • CVE-2022-32081: MariaDB 10.6.9

  • CVE-2022-31624: MariaDB 10.6.5

  • CVE-2022-27458: MariaDB 10.6.8

  • CVE-2022-27457: MariaDB 10.6.8

  • CVE-2022-27456: MariaDB 10.6.8

  • CVE-2022-27455: MariaDB 10.6.8

  • CVE-2022-27452: MariaDB 10.6.8

  • CVE-2022-27451: MariaDB 10.6.8

  • CVE-2022-27449: MariaDB 10.6.8

  • CVE-2022-27448: MariaDB 10.6.8

  • CVE-2022-27447: MariaDB 10.6.8

  • CVE-2022-27446: MariaDB 10.6.8

  • CVE-2022-27445: MariaDB 10.6.8

  • CVE-2022-27444: MariaDB 10.6.8

  • CVE-2022-27387: MariaDB 10.6.8

  • CVE-2022-27386: MariaDB 10.6.8

  • CVE-2022-27385: MariaDB 10.6.5

  • CVE-2022-27384: MariaDB 10.6.8

  • CVE-2022-27383: MariaDB 10.6.8

  • CVE-2022-27382: MariaDB 10.6.8

  • CVE-2022-27381: MariaDB 10.6.8

  • CVE-2022-27380: MariaDB 10.6.8

  • CVE-2022-27379: MariaDB 10.6.8

  • CVE-2022-27378: MariaDB 10.6.8

  • CVE-2022-27377: MariaDB 10.6.8

  • CVE-2022-27376: MariaDB 10.6.8

  • CVE-2022-24052: MariaDB 10.6.6

  • CVE-2022-24051: MariaDB 10.6.6

  • CVE-2022-24050: MariaDB 10.6.6

  • CVE-2022-24048: MariaDB 10.6.6

  • CVE-2022-21595: MariaDB 10.6.6

  • CVE-2022-0778: MariaDB 10.6.6

  • CVE-2021-46669: MariaDB 10.6.8

  • CVE-2021-46668: MariaDB 10.6.7

  • CVE-2021-46667: MariaDB 10.6.5

  • CVE-2021-46665: MariaDB 10.6.7

  • CVE-2021-46664: MariaDB 10.6.7

  • CVE-2021-46663: MariaDB 10.6.7

  • CVE-2021-46662: MariaDB 10.6.5

  • CVE-2021-46661: MariaDB 10.6.7

  • CVE-2021-46659: MariaDB 10.6.6

  • CVE-2021-46658: MariaDB 10.6.3

  • CVE-2021-35604: MariaDB 10.6.3

  • CVE-2021-2389: MariaDB 10.6.4 [2]

  • CVE-2021-2372: MariaDB 10.6.4 [2]

  • CVE-2018-25032: MariaDB 10.6.9

List of All MariaDB 10.6 Releases

Date
Release
Status
Release Notes
Changelog

8 May 2025

MariaDB 10.6.22

Stable (GA)

Release Notes

Changelog

4 Feb 2025

MariaDB 10.6.21

Stable (GA)

Release Notes

Changelog

1 Nov 2024

MariaDB 10.6.20

Stable (GA)

Release Notes

Changelog

8 Aug 2024

MariaDB 10.6.19

Stable (GA)

Release Notes

Changelog

16 May 2024

MariaDB 10.6.18

Stable (GA)

Release Notes

Changelog

7 Feb 2024

MariaDB 10.6.17

Stable (GA)

Release Notes

Changelog

13 Nov 2023

MariaDB 10.6.16

Stable (GA)

Release Notes

Changelog

14 Aug 2023

MariaDB 10.6.15

Stable (GA)

Release Notes

Changelog

7 Jun 2023

MariaDB 10.6.14

Stable (GA)

Release Notes

Changelog

10 May 2023

MariaDB 10.6.13

Stable (GA)

Release Notes

Changelog

6 Feb 2023

MariaDB 10.6.12

Stable (GA)

Release Notes

Changelog

7 Nov 2022

MariaDB 10.6.11

Stable (GA)

Release Notes

Changelog

19 Sep 2022

MariaDB 10.6.10

Stable (GA)

Release Notes

Changelog

15 Aug 2022

MariaDB 10.6.9

Stable (GA)

Release Notes

Changelog

20 May 2022

MariaDB 10.6.8

Stable (GA)

Release Notes

Changelog

12 Feb 2022

MariaDB 10.6.7

Stable (GA)

Release Notes

Changelog

9 Feb 2022

MariaDB 10.6.6

Stable (GA)

Release Notes

Changelog

8 Nov 2021

MariaDB 10.6.5

Stable (GA)

Release Notes

Changelog

6 Aug 2021

MariaDB 10.6.4

Stable (GA)

Release Notes

Changelog

6 Jul 2021

MariaDB 10.6.3

Stable (GA)

Release Notes

Changelog

18 Jun 2021

MariaDB 10.6.2

RC

Release Notes

Changelog

21 May 2021

MariaDB 10.6.1

Beta

Release Notes

Changelog

26 Apr 2021

MariaDB 10.6.0

Alpha

Release Notes

Changelog

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

MariaDB 10.6.22 Release Notes

Download Release Notes Changelog Overview of 10.6

Alternate download from mariadb.org

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.22 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

  • Incorrect undo logging for indexes on virtual columns whose index ID does not fit in 32 bits (MDEV-36613)

  • Race conditions between ALTER TABLE or OPTIMIZE TABLE and the purge of transaction history were fixed. (MDEV-36122)

  • ASAN errors in dict_sys_t::load_table / get_foreign_key_info after failing to load a table (MDEV-33167)

  • CREATE INDEX fails to heal a FOREIGN KEY constraint (MDEV-35962)

  • Doublewrite recovery of innodb_checksum_algorithm=full_crc32 page_compressed pages does not work (MDEV-36180)

  • innodb_snapshot_isolation=1 gives error for not committed row changes (MDEV-36639)

  • The deprecated parameter innodb_purge_rseg_truncate_frequency is not being recognized (MDEV-36378)

  • dict_stats_fetch_from_ps() unnecessarily holds exclusive dict_sys.latch (MDEV-35436)

  • Stall and crash when page cleaner fails to generate free pages during Async flush (MDEV-36226)

  • Performance regression in INSERT…SELECT due to unnecessarily making InnoDB log durable. (MDEV-35813)

Spider

  • The untested ha_spider::index_first_internal constructs broken queries (MDEV-36324)

  • Unexpected error 1264 'Out of Range Value for Column' when inserting into ... select ... from a spider table (MDEV-35874)

  • Tests calling the udf spider_copy_tables fail with --view-protocol (MDEV-36335)

Optimizer

  • group by handler missing constant fields when selecting from a view (MDEV-36307)

Data Definition - Alter Table

  • Incorrect error handling on DDL with FULLTEXT INDEX (MDEV-36061)

  • ALTER TABLE…SEQUENCE does not work correctly with InnoDB (MDEV-36038)

  • The server could crash when an UPDATE is about to commit concurrently with a CREATE INDEX that includes VIRTUAL columns (MDEV-36281)

  • ALTER TABLE…DROP COLUMN after a failed ALTER TABLE…DROP COLUMN could lead to a server crash (MDEV-36236)

GIS

  • Server aborts while deleting the record in spatial index (MDEV-35420)

Upgrades

  • Upgrades fail on Windows (MDEV-36128)

OTHER

  • Field pointer may be uninitialized in fill_record (MDEV-36181)

  • Wrong results from tables with a single record and an aggregate (MDEV-35238)

Galera

  • With wsrep_ignore_apply_errors = 0, the node crashes due to assertion thd->is_error() failed in Sql_cmd_dml::prepare(), shown in the logs (MDEV-35946)

  • In some cases, if there are MDL locks (for example, when LOCK TABLE is executed), a node could get stuck in the system thread due to incorrect handling of metadata locks (MDL) in server code when a transaction was BF aborted. (MDEV-35941)

  • Regression after the fix for MDEV-31413 - sometimes the server crashes with an assertion in wsrep::transaction::before_rollback(), for example when using OPTIMIZE TABLE on an ARIA table with wsrep_osu_method=RSU. (MDEV-32631)

  • In Galera, creating sequence with a small cache leads to signal 6 error: [ERROR] WSREP: FSM: no such a transition REPLICATING -> COMMITTED. (MDEV-33850)

  • Assertion `commit_trx' failed in innobase_commit() (ha_innodb.cc). An INSERT with sql_log_bin=0 is still replicated in Galera (per MDEV-7205), despite binary logging being disabled. This results in a partial binlog bypass, requiring a two-phase commit (2PC). During 2PC, the INSERT is first prepared (entering the PREPARED state in InnoDB), and on commit, the new assertion from MDEV-24035 fails, causing a crash with "Assertion 'commit_trx' failed" in logs. (MDEV-35658)

  • When a sequence is used and inserts run in parallel on multiple Galera nodes, a transaction may be aborted after passing certification. If it then attempts to roll back, the binlog statement cache—which includes reserved sequence values—may be written prematurely. This causes a crash with the diagnostic "WSREP: FSM: no such a transition REPLICATING -> COMMITTED" in the logs, as the transaction is supposed to replay and only write to the binlog during the final commit. (MDEV-33589)

  • After a corrupted table on one node triggers the cluster to vote to evict a node that failed a transaction, the current master can't commit any more and hangs. To avoid this crash in the future, the user should also update the galera library to version 26.4.21+. (MDEV-34998)

  • Creating partitioned tables is disallowed when wsrep_osu_method=TOI and wsrep_strict_ddl=ON, preventing alteration or deletion of partitioned tables. (MDEV-27861)

  • Attempting to create a CONNECT engine table results in "non-InnoDB sequences in Galera cluster" error message in logs due to an incorrect engine check. (MDEV-35748)

  • Build fails with cmake 4.0.0 due to wsrep (MDEV-36422)

  • A Galera node may hang due to improper mutex handling: a thread held lock_sys.wait_mutex while triggering a streaming replication rollback, which also tried to acquire THD::LOCK_thd_kill, leading to incorrect mutex usage. In debug versions, this leads to diagnostics like "safe_mutex: Found wrong usage of mutex 'wait_mutex' and 'LOCK_thd_data'", but in both debug and release versions, there is some probability that the node may hang. (MDEV-36509)

Partitioning

  • corruption when query cache cannot allocate block (MDEV-34075)

Data Manipulation - Update

  • Stack looping and SIGSEGV in Item_args::walk_args on UPDATE (MDEV-31647)

Server

  • Server crash in find_field_in_tables, Assertion `name' failed in find_field_in_table_ref (MDEV-25012)

  • Server crash when inserting from derived table containing insert target table (MDEV-32086)

  • MariaDB effectively running as root CAP_DAC_OVERRIDE (MDEV-36229)

  • Build fails with cmake 4.0 (MDEV-36506)

Plugin - Audit

  • Long server_audit_file_path causes buffer overflow (MDEV-36245)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2025-30722

    • CVE-2025-30693

    • CVE-2023-52970

    • CVE-2023-52969

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.21 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 4 Feb 2025

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.21 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

  • Fix possible InnoDB hang while running out of buffer pool (MDEV-35409)

  • Fix assertion failure on cascading foreign key update of table with vcol index in parent (MDEV-29182)

  • Fix potential issue in secondary Index with ROW_FORMAT=COMPRESSED and Change buffering enabled (MDEV-35679)

  • Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column (MDEV-35445)

  • New parameter --skip-freed-pages for Innochecksum. Use this parameter to not get freed undo logs reported as existing undo log pages. (MDEV-35394)

  • Cloning of table statistics while saving the InnoDB table stats is now avoided (MDEV-35363)

  • InnoDB deadlock output query length increased to improve visibility of deadlocked statements. (MDEV-32576)

Memory

  • Fix possible crash on DELETE from a HEAP table (MDEV-22695)

Spider

  • Fix possible Spider thread hang in 'Update' state on 2nd INSERT (MDEV-35064)

  • Fix possible crash on bootup in spider_sys_open_table (MDEV-32822, MDEV-34302, MDEV-34925)

Replication

  • Fix incorrect formatting of timestamp during mariadb-binlog parsing of a binary log, causing point in time recovery discrepancies (MDEV-31761)

  • mariadb-binlog can now correctly process more than one logfile when --stop-datetime is specified (MDEV-35528)

  • Setting pseudo_thread_id to a value exceeding 4 bytes previously resulted in truncation when written to the binary log (MDEV-35646)

  • MariaDB now supports MySQL 8.0 binlog events, including PARTIAL_UPDATE_ROWS_EVENT, TRANSACTION_PAYLOAD_EVENT, and HEARTBEAT_LOG_EVENT_V2. (MDEV-35643)

Optimizer

  • Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY (MDEV-29935)

  • Fix failing assertion causing disruption and replication failure (MDEV-24035)

  • Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition (MDEV-35910)

  • NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures (MDEV-34665)

  • Fix possibly wrong result using a degenerated subquery (SELECT ) with window function (MDEV-35869)

Partitioning

  • History is now stored on the same partitions on different Galera nodes when system versioning is enabled (MDEV-35096)

  • Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE (MDEV-25654)

  • EXCHANGE PARTITION now works for tables with unique blobs (MDEV-35612)

  • algorithm = instant can now correctly be used if a table has partitions and one tries to change a column with an index which is not the partitions key. This previously gave error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY". (MDEV-34813)

Character Sets

  • Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys (MDEV-30111)

  • Fix client crash the command after client sets character set to utf32 (MDEV-34090)

  • Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer (MDEV-35549)

  • Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump (MDEV-29968)

Galera

  • Galera updated to 26.4.21

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

  • Fix streaming replication transaction crash with innodb_snapshot_isolation (MDEV-35281)

  • Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled (MDEV-35465)

  • Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory (MDEV-35387)

  • Fix cluster node hang during shutdown if threadpool is used (MDEV-35710)

  • MariaDB Cluster and ALTER INPLACE running in Total Order Isolation (wsrep_OSU_method=TOI) now correctly abort a DML INSERT operation in InnoDB (MDEV-33064)

  • Fix possible crash in wsrep_check_sequence (MDEV-33245)

  • Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction (MDEV-35446)

  • Rows in table mysql.gtid_slave_pos are now correctly deleted on Galera nodes when wsrep_gtid_mode = 1 is used, which previously lead to wrong information about replica delays (MDEV-34924)

  • Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node. (MDEV-35852)

  • Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently. (MDEV-35018)

  • Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+ (MDEV-35505)

  • Fix possible crash in wsrep_sst_mariadb-backup script when upgrading node in cluster from 10.11.9 to 10.11.10. (MDEV-35526)

  • wsrep_sst_mariadb-backup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours (MDEV-35749)

Audit Plugin

  • For an authentication with the ed25519 authentication plugin the password of the CREATE USER statement is now masked in the audit log (MDEV-35507)

  • MariaDB Audit now detects all DCLs forms for masking a password (MDEV-35522)

General

  • Fix possible crash where server could not construct a geomery object from the input (MDEV-33987)

  • Fix trigger created with "CREATE TRIGGER table1_after_insert AFTER INSERT" which is adding rows to another table using "FOR EACH ROW insert into table2(id, name) values (NEW.id, NEW.name);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table (MDEV-34958)

  • After changing the table definition for the system table 'mysql.servers', a following execution of CREATE SERVER would previously lead to a server crash.

    • NOTE: System tables should never be modified by a user anyhow (MDEV-33783)

  • Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED (MDEV-35571)

  • Fix possible crash during index traversal using tree_search_next. (MDEV-28130)

  • FIx assertion failure where CURRENT_USER was not correctly copied during condition pushdown (MDEV-35090)

  • START TRANSACTION, when triggering an implicit commit as a COMMIT or ROLLBACK has not been executed before, now resets optional characteristics added to the last START TRANSACTION command (MDEV-35335)

  • sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers (MDEV-35651)

  • The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error (MDEV-20281)

  • Fix doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages (MDEV-34898)

  • Can now correctly add a foreign key on a table with a long UNIQUE multi-column index that contains a foreign key as a prefix (MDEV-33658)

  • During an online table rebuild of an InnoDB statistics table, opt_search_plan_for_table() no longer sometimes degrades to full table scan (MDEV-35443)

  • Fix debian-start script failure when using non-standard socket path (MDEV-35907)

  • Fix possible hang or crash where zero offset applied to null pointer (MDEV-35864)

  • Fixed issue where ST_PointFromWKB ignored SRID parameter and returned 0 (MDEV-32619)

  • Fix possible hang during CREATE TABLE…SELECT error handling, especially with innodb_snapshot_isolation enabled (MDEV-35647)

  • Fix incorrect locking order of LOCK_log/LOCK_commit_ordered and LOCK_global_system_variables (MDEV-29744)

  • Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy (MDEV-35157)

  • Fix possible memory leak on SHUTDOWN (MDEV-35326)

  • Fix possible memory leak while shutting down server after installing the auth_gssapi plugin (MDEV-35575)

  • Fix possible server crash when using INSERT DELAYED on tables with virtual columns. (MDEV-26891)

  • Fix possible Spider crash or hang when the first byte of a connection key is changed (MDEV-34849)

  • A BEFORE INSERT Trigger previously returned with error ""Field 'xxx' doesn't have a default value", if a NULL value is added for a column defined NOT NULL without explicit value and no DEFAULT specified (MDEV-19761)

  • Calling a stored routine that executes a join on three or more tables and referencing not-existent column name in the USING clause could previously result in a crash on its second invocation. (MDEV-24935)

  • Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy (MDEV-35157)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2025-21490

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.20 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 1 Nov 2024

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.20 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

  • Fix attempt to read outside the bounds of the file: ./ibdata1 (MDEV-34453)

  • Fix MariaDB crash with SIGILL because the OS does not support AVX512 (MDEV-34565)

  • Fix deadlock caused by lock_rec_unlock_unmodified() (MDEV-34690)

  • Fix duplicate key error in table 'mysql.innodb_table_stats' (MDEV-34207)

  • Fix possible adaptive hash index corruption with ALTER TABLE...IMPORT TABLESPACE and FULLTEXT SEARCH (MDEV-35059)

  • XA prepare now correctly releases unmodified records in non-blocking mode (MDEV-34466)

  • Fix contention between secondary index UPDATE and purge due to large innodb_purge_batch_size (MDEV-34515)

    • New default of 127 for innodb_purge_batch_size (previously 1000).

  • Fix redundant page lookups that hurt performance (MDEV-34791)

Spider

  • Fix server crash when calling spider UDF after aria_encrypt_tables is enabled (MDEV-34682)

  • SELECT MIN on Spider table no longer returns more rows than expected (MDEV-26345)

  • Fix Spider group by handler wrong result on order by aggregate (MDEV-29546)

S3

  • Fix Storage Engine S3 that caused 500 error when using Huawai Cloud S3 and possibly other S3 providers (MDEV-34867)

    • A new option s3-provider has been added. s3-provider=Huawai needs to be set for Huawai Cloud S3

    • New option s3_ssl_no_verify, if true, SSL certificate verification for the S3 endpoint is disabled

Optimizer

  • Fix crash caused by query containing constant having clause (MDEV-23983)

  • Fix assertion with optimizer_join_limit_pref_ratio and 1-table select (MDEV-35072)

Data Definition - Alter Table

  • Fix InnoDB crash under Windows Subsystem for Linux on ALTER TABLE or OPTIMIZE TABLE (MDEV-34938)

  • Modification of the column now correctly checks foreign key constraint (MDEV-34392)

  • Fix incorrect NULL value handling for instantly dropped BLOB columns (MDEV-35122)

Galera

  • Galera updated to 26.4.20

  • Fix server crash when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table (MDEV-31173)

  • TOI (ALTER) no longer hangs on a parent table if SR transaction is in progress on a child table (MDEV-34836)

  • Fix INSERT...SELECT' on MyISAM table suddenly replicated by alera (MDEV-34647)

  • Fix case where with wsrep_mode=REPLICATE_ARIA, only part of the mixed-engine transactions was replicated (MDEV-30653)

  • Fix galera_ssl_reload failure with warning message (MDEV-32778)

  • When InnoDB gets an assertion failure, WSREP layer is now handled gracefully (MDEV-32363)

Backup

  • Recovery now correctly notes some log corruption (MDEV-34802)

  • InnoDB now correctly merges the change buffer to ROW_FORMAT=COMPRESSED tables (MDEV-34879)

  • Can now selectively restore sequences using innodb tables from backup (MDEV-32350)

JSON

  • JSON_TABLE now properly unquotes strings (MDEV-27412)

  • JSON_TABLE default values now allows non-string literals (MDEV-25822)

General

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.6 for SLES 12, and Windows 11 22H2

  • mariadbd no longer hangs on startup when --init-file target does not exist (MDEV-34814)

  • LOAD DATA INFILE with geometry data no longer fails (MDEV-34883)

  • Fix heap-use-after-free in group_concat with compressed or GIS columns (MDEV-16699)

  • Fix assertion `!is_cond()' failed in Item_bool_func::val_int / do_select (MDEV-35135)

  • Trigger now works correctly with bulk update (MDEV-34718)

  • Fix assertion failure in find_producing_item upon a query from a view (MDEV-35276)

  • Add new setting, --quick-max-column-width to the mariadb client for use in --quick mode (MDEV-34704)

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.19 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 8 Aug 2024

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.19 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

  • We fail to terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing (MDEV-34167)

  • Alter operation on redundant table aborts the server (MDEV-34222)

  • MariaDB crashes with SIGILL because the OS does not support AVX512 (MDEV-34565)

  • InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound (MDEV-34474)

  • wait_for_read in buf_page_get_low hurts performance (MDEV-34458)

  • InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211 (MDEV-34357)

Aria

  • Fix Aria index corruption when doing a REPAIR TABLE that has a size of over 4G (MDEV-34522)

Spider

  • UBSAN: runtime error: applying non-zero offset in spider_free_mem and SIGSEGV in spider_free_mem on SELECT (MDEV-31475)

  • SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' (MDEV-32487)

  • SIGSEGV in spider_db_conn::fin_loop_check, and ASAN: heap-use-after-free in spider_db_mbase::fin_loop_check on SHOW TABLE STATUS (MDEV-34541)

  • SIGSEGV in ha_spider::lock_tables on BEGIN after table lock (MDEV-29962)

  • SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT and SELECT (MDEV-32492)

  • Spider: Crashes, asserts, hangs, memory corruptions and ASAN heap-use-after-free's (MDEV-27902)

  • Spider: @@insert_id 128 to TINYINT: Assertion ``!is_set() || (m_status == DA_OK_BULK && is_bulk_op())'` failed. (MDEV-28105)

  • ASAN errors in spider_db_free_result after partition DDL (MDEV-29027)

  • Server crashes when calling spider UDF after aria_encrypt_tables is enabled (MDEV-34682)

Partitioning

  • MariaDB Server crashes with ill-formed partitions (MDEV-32155)

  • SIGSEGV in parse_engine_part_options on INSERT, SELECT or ALTER (MDEV-34421)

  • Assertion ``auto_increment_value'failed inha_partition::info` on INSERT into MEMORY table (MDEV-24610)

Character Sets

  • On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb from strings/ctype-mb.c and other locations (MDEV-34226)

  • On startup: UBSAN: runtime error: applying zero offset to null pointer in skip_trailing_space and my_hash_sort_utf8mb3_general1400_nopad_as_ci (MDEV-34187)

  • SHOW CREATE DATABASE statement crashes the server when db name contains some unicode characters, ASAN stack-buffer-overflow (MDEV-32376)

  • Wrong result set with utf8mb4_danish_ci and BNLH join (MDEV-34417)

Optimizer

  • On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info in sql/sql_select.cc (MDEV-34227)

  • Crash after killing query while it is processed by test_quick_select (MDEV-30651)

  • Extend condition normalization to include 'NOT a' (MDEV-19520)

  • Constant subquery causing a crash in pushdown optimization (MDEV-29363)

  • Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table (MDEV-33010)

  • 2nd execution name resolution problem with pushdown into unions (MDEV-34506)

  • Assertion ``(key_part->key_part_flag & 4) == 0'` failed key_hashnr (MDEV-34580)

  • Crash caused by query containing constant having clause (MDEV-23983)

  • Using NAME_CONST() (or executing query from the stored procedure and referring to a local variable) changes the plan and may make execution slower (MDEV-33971)

  • ORDER BY DESC causes ROWID Filter optimization performance degradation (MDEV-33875)

Replication

  • Auto-generated DELETE from HEAP table no longer breaks replication (MDEV-25607)

  • Fix replication failure when XA transactions are used where the replica has replicate_do_db set and the client has touched a different database when running DML such as inserts. (MDEV-33921)

  • Fix replication error when CHANGE MASTER TO is used in conjunction with a password longer than 41 ascii characters (MDEV-23857)

  • The --init-rpl-role option is utilized to avoid a possible error state in semisync recovery (MDEV-33465)

Backup

  • Hide password passed on commandline from xtrabackup_info (MDEV-34434)

Galera

  • Galera updated to 26.4.19

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

  • galera_gtid_2_cluster: Assertion ``thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'` (MDEV-32633)

  • table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0 (MDEV-34170)

  • Deadlock found when trying to get lock during applying (MDEV-31658)

  • Change error code for Galera unkillable threads (MDEV-12008)

  • 10.11.8 cluster becomes inconsistent when using composite primary key and partitioning (MDEV-34269)

  • wsrep_sst_mariadb-backup use /tmp dir during SST rather then user defined tmpdir (MDEV-32158)

Error Log

  • server_uid system variable added, and value added to the error log at startup (MDEV-34494)

General

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.6 for Debian 10 "Buster", RHEL/CentOS 7, and Fedora 38

  • IMPORT TABLESPACE no longer unnecessarily traverses tablespaces list (MDEV-34670)

  • Fix unknown variable defaults-group-suffix= with mariadb-secure-installation (MDEV-33265)

  • mariadb-install-db no longer hangs on macOS (MDEV-34129)

  • Fix transaction termination with ER_LOCK_TABLE_FULL when lock memory is growing (MDEV-34167)

  • Disable new connections in case of fatal signal (MDEV-34475)

  • Control over memory allocated for SP/PS (MDEV-14959)

  • Triggers now work correctly with bulk insert (MDEV-24411)

  • Fix assertion ``table->field[0]->ptr >= table->record[0] && table->field[0]->ptr <= table->record[0] + table->s->reclength'failed invoid handler::assert_icp_limitations(uchar*)` (MDEV-34632)

  • sandbox mode - now compatible with --binary-mode (MDEV-34203)

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.18 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 16 May 2024

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.18 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

From this version, the mariadb-dump tool adds a new sandbox command to the top of every dump file. This command cannot be interpreted by MariaDB command line client versions that do not have the sandbox command, or by MySQL command line clients, and an error will be generated in these clients. Other methods of importing the dump will work not have this issue.

Storage Engines

InnoDB

  • Fix InnoDB holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL (MDEV-32899)

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

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

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

  • Fix InnoDB hang when temporarily running out of buffer pool (MDEV-33613)

  • 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 server hang on DROP INDEX or RENAME INDEX (MDEV-33993)

  • Fix mariadb-backup --backup hang (MDEV-33669)

  • Fix server hang caused by InnoDB change buffer (MDEV-33543)

  • Fix assertion failures upon adding a too long key to table with COMPRESSED row format (MDEV-31161)

  • IMPORT TABLESPACE no longer fails with column count or index count mismatch (MDEV-30655)

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

  • Fix inconsistent behaviors of UPDATE under RU & RC isolation level (MDEV-26643)

  • Fix weird SELECT view when a record is modified to the same value by two transactions (MDEV-26642)

  • Fix inconsistent read and write, which use the same predicate (WHERE clause) (MDEV-29565)

  • Fix inconsistent SELECT view when modifying a record added by another transaction (MDEV-26671)

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

  • Read only server no longer throws error when running a create temporary table as select statement (MDEV-33889)

  • Change buffer index no longer fails to delete the records (MDEV-32489)

  • Fix InnoDB include OS error information when failing to write to iblogfile0 (MDEV-33397)

  • Fix phantom rows caused by UPDATE of PRIMARY KEY (MDEV-32898)

    • New system variable, innodb_snapshot_isolation

  • In-place migration from MySQL 5.7 no longer causes invalid AUTO_INCREMENT values (MDEV-33277)

  • Fix InnoDB log corruption before upgrading it on startup (MDEV-32445)

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

Aria

  • Fixed that internal temporary tables did not wait for freed disk space, and related issues (MDEV-33813)

Federated

  • Fix wrong result on 2nd execution of prepared statement for query with derived table (MDEV-31361)

Spider

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

  • Fix server crash when deleting partitions from a table with spider engine (MDEV-33731)

  • SPIDER plugin initialization no longer fails at 'create table if not exists mysql.spider_tables ... with 'Specified key was too long; max key length is 1000 bytes', Warning: Memory not freed: 10720 (MDEV-33242)

  • Fix spider plugin init failure with no_zero_date sql_mode (MDEV-33494)

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

  • Fix mariadb-backup --backup FATAL ERROR: ... Can't open datafile cool_down/t3 (MDEV-33011)

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

  • Fix crash in mariadb-backup --prepare --export after --prepare (MDEV-33023)

  • mariadb-backup now considers O/S user when --user option is omitted (MDEV-32893)

Character Sets, Data Types

  • Fixed improper application of ORDER BY COLLATE to non-character columns (MDEV-33318)

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

  • Fixed Bad SEPARATOR value in GROUP_CONCAT on character set conversion (MDEV-33772)

  • Fixed out of range error in AVG(YEAR(datetime)) due to a wrong data type (MDEV-33496)

  • Fixed GREATEST() and LEAST() problems with NULLs (MDEV-21034)

JSON

  • View created via JSON_ARRAYAGG now returns correct json object (MDEV-30646)

  • JSON_TYPE now detects the type of String Values and correctly returns Date/DateTime values (MDEV-19487)

  • JSON_REMOVE no longer returns NULL on valid arguments (MDEV-22141)

  • JSON_EXTRACT no longer returns multiple values for same path (MDEV-32287)

Encryption, TLS, SSL

  • WolfSSL's math is unnecessarily slow (MDEV-33482)

Optimization & Tuning

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

  • Wrong result with cross Join given join order (MDEV-30975)

  • Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT (MDEV-31276)

  • Wrong result with semi-join and splittable derived table (MDEV-23878)

  • Optimizer choosing incorrect index in 10.6, 10.5 but not in 10.4 (MDEV-33306)

    • optimizer_adjust_secondary_key_costs server option changed from having a numeric value to a set value with new options to affect the optimizer. The old numeric values still work.

  • Aggregation functions fail to leverage uniqueness property (MDEV-30660)

  • Partitioning is broken on big endian architectures (MDEV-33623)

Plugins

  • The audit plugin now reports the user and host in all cases (MDEV-33393)

Replication

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

  • Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure (MDEV-34042)

  • mysql_manager_submit Segfault at Startup Still Possible During Recovery (MDEV-33799)

  • Server crash in Rows_log_event::update_sequence upon replaying binary log (MDEV-31779)

  • Slave crashed:reload_acl_and_cache during shutdown (MDEV-30260)

  • When binlog_annotate_row_events on , event of binlog file is truncated (MDEV-9179)

  • Add more warnings to be able to better diagnose network issues (MDEV-33582)

  • Improve times and states in show processlist for replication (MDEV-33620)

  • Adapt parallel slave's round-robin scheduling to XA events (MDEV-33668)

  • release row locks for non-modified rows at XA PREPARE (MDEV-33454)

  • Semi-sync Wait Point AFTER_COMMIT Slow on Workloads with Heavy Concurrency (MDEV-33551)

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 have been updated

  • Disallow bulk insert operation during partition update statement (MDEV-33979)

SQL, Data Definition, and Data Manipulation

  • Transportable Tablespaces no longer leave AUTO_INCREMENT in a mismatched state (MDEV-18288)

  • Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption (MDEV-30046)

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

  • Fix server crash when UPDATE statement with duplicate key is run after setting a low thread_stack (MDEV-33622)

  • Fix incorrect handling of UPDATE in PS mode when a table's column declared as NOT NULL (MDEV-33549)

  • Fix crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT (MDEV-15703)

  • Fix wrong result on 2nd execution of PS to select from view using derived (MDEV-31277)

  • Fix wrong warnings on 2nd execution of PS for query with GROUP_CONCAT (MDEV-31276)

  • TIMESTAMP value of '1970-01-01 00:00:00' can no longer be indirectly inserted in strict mode (MDEV-34088)

  • Fix out of range error in AVG(YEAR(datetime)) due to a wrong data type (MDEV-33496)

  • Fix zero datetime reinterpreting as '1970-01-01 00:00:00' on field_datetime=field_timestamp (MDEV-34069)

  • unix_timestamp(coalesce(timestamp_column)) no longer returns NULL on '1970-01-01 00:00:00.000001' (MDEV-34061)

  • Fix crash using UDF in WHERE clause of VIEW (MDEV-24507)

  • Fix update for portion changes autoincrement key in period table (MDEV-25370)

  • Fix SIGABRT resulting from CREATE TABLE with generated column and RLIKE (MDEV-21058)

Platforms & Packaging

  • MariaDB-client community can't be installed in red hat ubi9 (MDEV-32791)

General

Scripts & Clients

  • It's now possible to disable system commands with the mariadb --sandbox option. (MDEV-21778)

  • mariadb-dump now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.(MDEV-33727)

  • mariadb-dump commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions (MDEV-4827)

  • Loading time zones now works with alter_algorithm INPLACE (MDEV-33044)

Server

  • Moving from MariaDB 10.5 to 10.6 mysql_upgrade is not updating some system tables (MDEV-33726)

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

  • Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup (MDEV-33469)

  • update case insensitive (large) unique key with insensitive change of value - duplicate key (MDEV-29345)

  • MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params (MDEV-26923)

  • Slowdown when running nested statement with many partitions (MDEV-33502)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2024-21096

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.17 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 7 Feb 2024

MariaDB 10.6 is a current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.17 is a Stable (GA) release.

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)

  • InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe (MDEV-32269)

  • InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty (MDEV-32968)

  • innodb_fast_shutdown=0 hang after incomplete startup (MDEV-32798)

  • innodb_undo_log_truncate=ON prevents fast shutdown (MDEV-33062)

  • Adaptive flush recommendation ignores dirty ratio and checkpoint age (MDEV-31939)

  • gcol.gcol_purge contaminates further execution of innodb.gap_locks (MDEV-28682)

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

  • Adaptive flushing is still not getting invoked in 10.5.11 (MDEV-26055)

  • History list is not shrunk unless there is a pause in the workload (MDEV-33213)

  • path separator near ib_buffer_pool incorrect (MDEV-32983)

  • Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption (MDEV-32371)

  • Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON (MDEV-31861)

  • Assertion ``end_lsn == page_lsn'failed inrecv_recover_page` (MDEV-33137)

  • Some calls to buf_read_ahead_linear() seem to be useless (MDEV-32068)

  • Opening all .ibd files on InnoDB startup can be slow (MDEV-32027)

  • InnoDB LRU flushing does not run before running out of buffer pool (MDEV-33053)

  • innodb_undo_log_truncate=ON is blocking page writes (MDEV-33112)

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)

  • Missing required privilege CONNECTION ADMIN (MDEV-33006)

  • If tables are frequently created, renamed, dropped, a backup cannot be restored (MDEV-32939)

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

  • mysql_json cannot be used on newly created table (MDEV-32235)

  • Problems with a stored function EMPTY() on upgrade to 10.6 (MDEV-31616)

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)

  • No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included (MDEV-30170)

  • ASAN errors in spider_conn_queue_and_merge_loop_check (MDEV-29002)

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)

  • Incorrect result interceptor passed to mysql_explain_union() (MDEV-33165)

  • Add optimizer_adjust_secondary_key_costs variable to influence how costs for secondary keys are calculated. (MDEV-33118)

  • INSERT ... SELECT Does not produce an optimizer trace (MDEV-29298)

  • Unusable key notes do not get reported for some operations (MDEV-32958)

  • Unusable key notes report wrong predicates for > and >= (MDEV-32957)

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)

  • LONG UNIQUE does not work like unique key when using replace (MDEV-32837)

  • LONG UNIQUE gives error when used with REPLACE (MDEV-32839)

  • Backport MDEV-32532 to 10.6 (MDEV-32903)

  • Assertion ``0' failed in Item_type_holder::val_int` (MDEV-29494)

Character Sets, Data Types

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

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

  • JSON_ARRAYAGG charset issue (MDEV-24784)

  • Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types (MDEV-32879)

Plugins

  • The SQL Error Log Plugin can optionally (when sql_error_log_with_db_and_thread_info is enabled) include the thread ID and database / table in its log (MDEV-27087). NULL is displayed if there is no database (MDEV-32906)

  • The SQL Error Log Plugin can optionally (when sql_error_log_with_db_and_thread_info is enabled) include the thread ID and database / table in its log (MDEV-27087)

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

  • Cluster is inconsistent after SAVEPOINT statement is rolled back (MDEV-32549)

  • WSREP GTID MODE is inconsistent (MDEV-31905)

  • IST "Donor does not know my secret" with ssl-mode=VERIFY_CA (MDEV-32344)

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)

  • Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty (MDEV-33283)

  • "Read semi-sync reply magic number error" warnings on master (MDEV-32551)

  • Second Semi-sync Replica Can Hang at Connect Time (MDEV-32792)

  • Semi-sync ACKed Transaction can Timeout and Switch Off Semi-sync with Multiple Replicas (MDEV-32960)

  • Semi-Sync Ack_Receiver Thread Should Allow COM_QUIT Command (MDEV-32385)

General

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.6 for Fedora 37, and Windows Server 2019

  • s3_debug is now dynamic, and s3_protocol_version contains new options, and old options have been deprecated (MDEV-32884)

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

  • Wrong user in SET DEFAULT ROLE error (MDEV-26875)

  • quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') (MDEV-28651)

  • mysql.slow_log reports incorrect start time (MDEV-11628)

  • Update federated table and column privileges (MDEV-32984)

  • Disable transparent huge pages after page buffers have been allocated (MDEV-33279)

  • Deprecate secure_auth=0 (MDEV-32617)

  • sys schema view session_ssl_status is empty (MDEV-32751)

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.16 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 13 Nov 2023

MariaDB 10.6 is the current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.16 is a Stable (GA) release.

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)

  • Race condition between page write completion and log checkpoint (MDEV-32511)

  • After crash recovery, Checksum mismatch + Failing assertion: !i || prev_id + 1 == space_id, (MDEV-31851)

  • Deadlock due to log_free_check(), involving trx_purge_truncate_rseg_history() and trx_undo_assign_low() (MDEV-32049)

  • Write-ahead logging is broken for freed pages (MDEV-32552)

  • X-lock on supremum for prepared transaction for RR (MDEV-30165)

  • Assertion failures in log_sort_flush_list upon crash recovery (MDEV-32029)

  • Race condition between page write completion and log checkpoint (MDEV-32511)

  • Assertion `purge_sys.tail.trx_no <= purge_sys.rseg->last_trx_no()' (MDEV-30100)

  • Assertion `index->is_btree() || index->is_ibuf()' failed in btr_search_guess_on_hash (MDEV-30802)

  • InnoDB hang in buf_flush_wait_LRU_batch_end() (MDEV-32134)

  • InnoDB may hang when running out of buffer pool (MDEV-32588)

  • Corrupt index(es) on busy table when using FOREIGN KEY (MDEV-30531)

  • InnoDB Recovery doesn't display encryption message when no encryption configuration passed (MDEV-31098)

  • Wrong information about innodb_checksum_algorithm in the information_schema.SYSTEM_VARIABLES (MDEV-31473)

  • InnoDB may fail to recover after being killed in fil_delete_tablespace() (MDEV-31826)

  • Create separate tpool thread for async aio (MDEV-31095)

  • UNDO logs still growing for write-intensive workloads (MDEV-32050)

    • Increase the default for innodb_purge_batch_size from 300 to 1000 (MDEV-32050)

    • Deprecate innodb_purge_rseg_truncate_frequency.

    • The motivation for introducing this in MySQL seems to have been to avoid stalls due to freeing undo log pages or truncating undo log tablespaces. In MariaDB, innodb_undo_log_truncate=ON should be a much lighter operation because it will not involve any log checkpoint. (MDEV-32050)

  • Slow full index scan in 10.6 vs 10.5 for the (slow) I/O-bound case (MDEV-30986)

  • LOAD DATA into InnoDB w/partitions: huge performance loss, affected 10.6+ (MDEV-31835)

  • Disable read-ahead for temporary tablespace (MDEV-32145)

Optimizer

  • New optimizer_switch setting, cset_narrowing, to enable the Charset Narrowing Optimization (MDEV-32113)

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

  • jointable materialization subquery optimization ignoring errors, then failing ASSERT. (MDEV-31983)

  • Server crashes in JOIN::cleanup after erroneous query with view (MDEV-32164)

  • Prepared statement return wrong result (missing row) (MDEV-9938)

  • Assertion `range->rows >= s->found_records' failed in best_access_path (MDEV-32682)

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)

  • Parallel replication lags because innobase_kill_query() may fail to interrupt a lock wait (MDEV-32096)

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)

  • replication breaks when using optimistic replication and replica is a galera node (MDEV-31833)

  • McAfee database vulnerability scan caused MariaDB crash with signal 6 (system abort) (MDEV-27004)

  • Assertion `mode_ == m_local || transaction_.is_streaming()' failed in int wsrep::client_state::bf_abort(wsrep::seqno) (MDEV-30217)

Data Definition

  • MariaDB crash on calling function (MDEV-23902)

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

  • vcol circular references lead to stack overflow (MDEV-31112)

  • OPTIMIZE TABLE crash (MDEV-28122)

  • Server crashes in Alter_info::add_stat_drop_index upon CREATE TABLE (MDEV-32449)

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)

  • main.order_by_pack_big fails with view-protocol (MDEV-31460)

  • mysql_install_db_win.test fails on second execution (MDEV-32232)

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)

  • ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 (MDEV-29502)

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)

  • Assertion `!m_null_value' failed in int FixedBinTypeBundle::cmp_item_fbt::compare or in cmp_item_inet6::compare (MDEV-27207)

  • type_test.type_test_double fails with 'NUMERIC_SCALE NULL' (MDEV-22243)

  • LeakSanitizer errors in get_quick_select or Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed (MDEV-32476)

  • Update signal hander user info more compassion and correct url (MDEV-32535)

  • maria-install-db fails on MacOS (MDEV-31871)

  • MSAN / Valgrind errors in Item_func_like::get_mm_leaf upon query from partitioned table (MDEV-32388)

  • MSAN / Valgrind errors in Item_func_like::get_mm_leaf with temporal field (MDEV-32531)

  • ASAN errors in base_list_iterator::next / setup_table_map upon 2nd execution of PS (MDEV-32656)

  • safe_mutex: Found wrong usage of mutex 'LOCK_thd_data' and 'wait_mutex' (MDEV-32728)

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.

Variables

  • Added the note_verbosity system variable to manage notes when an index cannot be used.

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2023-22084

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.15 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 14 Aug 2023

MariaDB 10.6 is a previous long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.15 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Upgrading from MySQL

  • MariaDB now detects and converts previously incompatible MySQL partition schemes (MDEV-29253)

General

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

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

  • 280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode (MDEV-26186)

  • SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION (MDEV-30662)

  • Unexpected result when combining DISTINCT, subselect and LIMIT (MDEV-28285)

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

  • bzero wipes more bytes than necessary in set_global_from_ddl_log_entry (MDEV-31521)

  • Assertion ``0'failed inType_handler_row::field_typeuponTO_CHAR` with wrong argument (MDEV-29152)

  • mysql_upgrade fails due to old_mode="", with "Cannot load from mysql.proc. The table is probably corrupted" (MDEV-28915)

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

  • Crashing on I/O error is unhelpful (MDEV-27593)

  • SIGSEGV in log_sort_flush_list() in InnoDB crash recovery (MDEV-31354)

  • InnoDB tables are being flagged as corrupted on an I/O bound server (MDEV-31767)

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

  • Server Status Innodb_row_lock_time% is reported in seconds (MDEV-29311)

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

  • Add InnoDB engine information to the slow query log (MDEV-31558)

  • innodb protection against dual processes accessing data insufficient (MDEV-31568)

  • ER_DUP_KEY in mysql.innodb_table_stats upon RENAME on sequence (MDEV-31607)

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

  • InnoDB: Failing assertion: page_type == i_s_page_type[page_type].type_value (MDEV-31386)

  • btr_estimate_n_rows_in_range() accesses unfixed, unlatched page (MDEV-30648)

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

  • Recovery or backup failure after innodb_undo_log_truncate=ON (MDEV-31487)

  • Assertion 'n & PENDING' failed in fil_space_t::set_needs_flush() (MDEV-31442)

  • fil_node_open_file() releases fil_system.mutex allowing other thread to open its file node (MDEV-31256)

  • ASAN errors in dict_v_col_t::detach upon adding key to virtual column (MDEV-31416)

  • Purge trying to access freed secondary index page (MDEV-31264)

  • Freed data pages are not always being scrubbed (MDEV-31253)

  • InnoDB recovery hangs after reporting corruption (MDEV-31353)

  • !cursor->index->is_committed() in row0ins.cc after update to 10.4.13 from 10.3.21 (MDEV-22739)

  • innodb_undo_log_truncate=ON fails to wait for purge of enough transaction history (MDEV-31355)

  • SET GLOBAL innodb_undo_log_truncate=ON does not free space when no undo logs exist (MDEV-31382)

  • innodb_read_ahead_threshold (linear read-ahead) does not work (MDEV-29967)

  • InnoDB recovery and mariadb-backup --prepare fail to report detailed progress (MDEV-29911)

  • fil_ibd_create() may hijack the file handle of an old file (MDEV-31347)

  • innodb_undo_log_truncate=ON recovery results in a corrupted undo log (MDEV-31373)

  • Server freeze due to innodb_change_buffering and innodb_file_per_table=0 (MDEV-31088)

  • Change buffer entries are left behind when freeing a page, causing secondary index corruption when the page is later reused (MDEV-31385)

  • Foreign Key Constraint actions don't affect Virtual Column (MDEV-18114)

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

  • ANALYZE FORMAT=JSON now includes InnoDB engine statistics for each table (MDEV-31577)

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

  • Assertion ``s->table->opt_range_condition_rows <= s->found_records'failed inapply_selectivity_for_table` (MDEV-31449)

  • Inconsistency between MRR and SQL layer costs can cause poor query plan (MDEV-31479)

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

  • Server crash in store_length, assertion failure in Type_handler_string_result::sort_length (MDEV-31743)

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)

  • On slave XA COMMIT/XA ROLLBACK fail to return an error in read-only mode (MDEV-30978)

  • Calling a function from a different database in a slave side trigger crashes (MDEV-29894)

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

Galera

  • Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_mariadb-backup (MDEV-31737)

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

  • KILL QUERY maintains nodes data consistency but breaks GTID sequence (MDEV-31075)

  • Assertion failure !lock.was_chosen_as_deadlock_victim in trx0trx.h:1065 (MDEV-30963)

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

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.14 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 7 Jun 2023

Warning: This version can cause InnoDB file corruption under high I/O-bound load. Stick to an earlier release, or upgrade to a more recent release, if possible. See MDEV-31767.

MariaDB 10.6 is the current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.14 is a Stable (GA) release.

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)

  • InnoDB does not free UNDO after the fix of MDEV-30671 (MDEV-31234)

  • InnoDB hang fixes (MDEV-31158, MDEV-31343, MDEV-31350)

  • Innodb_buffer_pool_read_requests is not updated correctly (MDEV-31309)

  • InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)

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

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.14, 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.6.13 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 10 May 2023

MariaDB 10.6 is the current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.13 is a Stable (GA) release.

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)

  • Performance regression in fil_space_t::try_to_close() introduced in MDEV-23855 (MDEV-30775)

  • InnoDB recovery hangs when buffer pool ran out of memory (MDEV-30551)

  • InnoDB undo log truncation fails to wait for purge of history (MDEV-30671

  • MariaDB crash due to DB_FAIL reported for a corrupted page (MDEV-30397)

  • Deadlock between INSERT and InnoDB non-persistent statistics update (MDEV-30638)

  • InnoDB hang on B-tree split or merge (MDEV-29835)

  • Performance regression in locking reads from secondary indexes (MDEV-30357)

  • Improve adaptive flushing (MDEV-26055)

  • Make page flushing even faster (MDEV-26827)

  • Purge misses a chance to free not-yet-reused undo pages (MDEV-29593)

  • InnoDB temporary tablespace: reclaiming of free space does not work (MDEV-26782)

  • Fix miscount of doublewrites by Innodb_data_written (MDEV-31124)

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)

  • Race condition between buffer pool flush and log file deletion in mariadb-backup --prepare (MDEV-30860)

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)

  • Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always intialized (MDEV-30620)

  • Fixed the slave applier to report a correct error when gtid_slave_pos insert fails for some (engine) reasons (MDEV-31038)

  • Made parallel slave reports in performance schema consistent with that of show-slave-status (MDEV-26071)

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

  • New optimizer_switch option, hash_join_cardinality, is added. It is off by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. (MDEV-30812)

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

  • ANALYZE FORMAT=JSON now prints more information about Block Nested Loop joins: block-nl-join element now has r_loops, r_effective_rows and r_other_time_ms fields (MDEV-30806, MDEV-30830, MDEV-30972).

  • A GROUP BY query with MIN(primary_key) in select list and primary_key<>const in the WHERE could produce wrong result when executed with "Using index for group-by" strategy (MDEV-30605)

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

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

General

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.6 for Fedora 36.

  • In this release repositories for Fedora 38 and Ubuntu 23.04 Lunar have been added.

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2022-47015

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.13, 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.6.12 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 6 Feb 2023

MariaDB 10.6 is the current long-term series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.12 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

  • As mentioned in the 10.6.11 release notes, our Yum/DNF/Zypper repositories for Red Hat Enterprise Linux, CentOS, Fedora, 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)

  • innodb_undo_log_truncate=ON recovery and backup fixes (MDEV-29999, MDEV-30179, MDEV-30438)

  • Upgrade after a crash is not supported (MDEV-24412)

  • Remove InnoDB buffer pool load throttling (MDEV-25417)

  • InnoDB shutdown hangs when the change buffer is corrupted (MDEV-30009)

  • innodb_fast_shutdown=0 fails to report change buffer merge progress (MDEV-29984)

  • mariadb-backup --backup --incremental --throttle=... hangs (MDEV-29896)

  • Crash after recovery, with InnoDB: Tried to read (MDEV-30132)

  • Trying to write ... bytes at ... outside the bounds (MDEV-30069)

  • TRUNCATE breaks FOREIGN KEY locking (MDEV-29504, MDEV-29849)

  • INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces (MDEV-30119)

  • Fixed hangs and error handling in B-tree operations (MDEV-29603, MDEV-30400)

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)

  • Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA (MDEV-30423)

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)

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.6 for Fedora 35.

  • In this release repositories for Fedora 37 and Ubuntu 22.10 Kinetic have been added.

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.11 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 7 Nov 2022

MariaDB 10.6 is the current long-term maintenance stable series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.11 is a Stable (GA) release.

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

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

InnoDB

  • Adaptive hash index MDEV-27700, MDEV-29384

  • MVCC and locking (MDEV-29666, MDEV-27927, MDEV-28709, MDEV-29635)

  • Virtual columns (MDEV-29299, MDEV-29753)

  • InnoDB crash recovery fixes (MDEV-29559)

  • Race condition between KILL and transaction commit (MDEV-29368)

  • Implement CHECK TABLE…EXTENDED for InnoDB (MDEV-24402)

  • InnoDB persistent statistics fail to update after bulk insert (MDEV-28327)

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)

Replication

  • XA COMMIT is not binlogged when the XA transaction has not updated any transaction engine (MDEV-25616)

  • Concurrent CREATE TRIGGER statements made to binlog without any mixup (MDEV-25606)

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

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.10 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 19 Sep 2022

MariaDB 10.6 is the current long-term maintenance stable series of MariaDB, maintained until July 2026. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.10 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Issues Fixed

  • Assertion mysql_mutex_assert_owner(&log_sys.flush_order_mutex) failed in mtr_t::commit() (MDEV-29383)

  • Frequent "Data structure corruption" in InnoDB after OOM (MDEV-29374)

  • Recovery or backup of instant ALTER TABLE is incorrect (MDEV-29438)

  • InnoDB Temporary Tablespace (ibtmp1) is continuously growing (MDEV-28240)

  • Full text index corruption if shutdown before changes are fully flushed (MDEV-29342)

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

  • InnoDB hangs on multiple concurrent requests of a cold ROW_FORMAT=COMPRESSED page (MDEV-27983)

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.9 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 15 Aug 2022

MariaDB 10.6 is the current long-term maintenance stable series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.8 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Regressions

Unfortunately, some bugs have been found post release, so this is updated to help avoid these issues if possible. All are fixed in MariaDB 10.6.10.

  • MDEV-29374 — a crash shortly after a page merge (can be triggered by an UPDATE or DELETE or, say, rollback of an INSERT) can cause data corruption

  • MDEV-29342 — if InnoDB table had a fulltext index and only one new row was inserted between the last sync (performed asynchronously by a dedicated thread) and server shutdown, the fulltext index wasn't properly updated and became out of sync with the data. Before 10.6.9 this happened silently, in 10.6.9 an assertion crashed the server after detecting the inconsistency.

  • MDEV-29383 InnoDB Race condition between backups and crash recovery. last good version MariaDB 10.6.8. Avoid by performing backups after crash recovery

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)

  • Crash recovery fixes (MDEV-28668, MDEV-28731)

  • DDL crash recovery fixes (MDEV-28752, MDEV-28802, MDEV-28864, MDEV-28870, MDEV-28923, MDEV-28977)

  • Avoid crashes on corrupted data (MDEV-13542, MDEV-18519, MDEV-21098, MDEV-22388, MDEV-28457)

Replication

  • explicit_defaults_for_timestamp is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. (MDEV-29078)

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

  • Possible reason of FLUSH BINARY LOGS hang is eliminated (MDEV-28948)

  • Fix out-of-order gtid error in the circular semisync setup (MDEV-28609)

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)

  • Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB (MDEV-27862)

  • Add support for OpenSSL 3.0 in Galera (MDEV-25949)

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.

  • Range optimizer regression for key IN (const, ....) (MDEV-25020)

    • The issue can be observed on MariaDB 10.5.9 and later versions which have the fix for MDEV-9750. That fix introduceds optimizer_max_sel_arg_weight.

    • If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:

table.keyXpartY [NOT] IN ( ... )
  • Wrong result with table elimination combined with not_null_range_scan (MDEV-28858)

    • If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.

OpenSSL

  • Backport OpenSSL-3.0 compatibility to 10.6 branch (MDEV-28133)

JSON

  • JSON_TABLE: extract document fragment into JSON column (MDEV-25875)

CONNECT

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

mariadb Client

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

General

  • explicit_defaults_for_timestamp now also has a session scope, not only global (MDEV-29225)

  • 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.6 for Debian 10 "Buster" for ppc64el

  • Repositories for Ubuntu 22.04 and RHEL/Rocky 9 have been added in this release

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2023-5157

    • CVE-2022-32082

    • 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 and bugfixes made in MariaDB 10.6.9, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.6.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.6.8 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 20 May 2022

MariaDB 10.6 is the current long-term maintenance stable series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.8 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Note that MariaDB 10.6.8 is not yet available for Ubuntu 22.04 due to MDEV-28133. MariaDB 10.6.9 will be available.

Notable Items

InnoDB

  • innodb_disallow_writes removed (MDEV-25975)

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

  • InnoDB performance improvements (MDEV-27557, MDEV-28185, MDEV-27767, MDEV-28313, MDEV-28137, MDEV-28465, MDEV-26789)

  • Backup regression fixes (MDEV-27919)

  • InnoDB portability: FreeBSD futexes (MDEV-26476), POWER and s390x transactional memory (MDEV-27956)

  • ALTER TABLE: Fixed bogus duplicate key errors (MDEV-15250)

  • DDL and crash recovery fixes (MDEV-27274, MDEV-27234, MDEV-27817)

  • Requests to recalculate persistent statistics were sometimes lost (MDEV-27805)

Replication

  • Semisync-slave server recovery is refined to correctly rollback prepared transaction (MDEV-28461)

  • Circular semisync setup endless event circulation is handled (MDEV-27760)

  • Semisync-slave server recovery is extended to work on new server_id server (MDEV-27342)

  • 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

  • Query performance degradation in newer MariaDB versions when using many tables (MDEV-28073)

  • 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

  • Packages for Ubuntu 22.04 LTS "Jammy" and Fedora 36 are not yet available pending the resolution of MDEV-28133: Backport OpenSSL-3.0 compatibility to 10.6 branch

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.6 for Debian 9 "Stretch", Ubuntu 21.10 "Impish", and Fedora 34

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-46669

    • 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 and bugfixes made in MariaDB 10.6.8, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.6.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.6.7 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

Release date: 12 Feb 2022

MariaDB 10.6 is the current long-term maintenance stable series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.7 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

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

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

InnoDB

  • Set innodb_change_buffering=none by default (MDEV-27734)

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 and bugfixes made in MariaDB 10.6.7, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.6.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.6.6 Release Notes

The most recent release of MariaDB 10.6 is: MariaDB 10.6.22 Stable (GA) Download Now Alternate download from mariadb.org

Download Release Notes Changelog Overview of 10.6

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.6 is the current long-term maintenance stable series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.6 is a Stable (GA) release.

For an overview of MariaDB 10.6 see theWhat is MariaDB 10.6? 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)

  • insert-intention lock conflicts with waiting ORDINARY lock (MDEV-27025)

  • Crash recovery improvements (MDEV-26784, MDEV-27022, MDEV-27183, MDEV-27610)

  • mariadb-backup skips valid .ibd file (MDEV-26326)

  • Allow seamless upgrade despite ROW_FORMAT=COMPRESSED (MDEV-27736)

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)

  • Galera cluster node consider old server_id value even after modification of server_id [wsrep_gtid_mode=ON] (MDEV-26223)

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.6 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)

  • MariaDB names of executable programs and scripts used instead of historical mysql ones

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 and bugfixes made in MariaDB 10.6.6, with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.6.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.6.5 Release Notes

The most recent release of MariaDB 10.6 is:MariaDB 10.6.21 Stable (GA) Download NowAlternate download from mariadb.org

Download 10.6.5Release NotesChangelogOverview of 10.6

Release date: 8 Nov 2021

MariaDB 10.6 is the current stable series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.5 is a Stable (GA) release.

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

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • Linux after kernel version 5.10 has a io-uring regression causing a write to storage to be lost, or not acknowledged. As such innodb_use_native_aio will default to 0 (off) until 5.16. If innodb_use_native_aio is enabled in your configuration, a warning will be logged, however it will continue with the io-uring enabled, potentially resulting in a hang, or an assertion later. The long term support kernel 5.14.14 we haven't observed failures, and 5.15.0-rc7 failures have been observed, though less frequently. If you have innodb_use_native_aio explicitly enabled, and are using watch out for a lack of InnoDB updates followed by a 10 minute timeout. See MDEV-26674 for details.

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

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

  • Page I/O performance fixes (MDEV-25215, MDEV-26547, MDEV-26626, MDEV-26819)

  • Replication timeouts with XA PREPARE (MDEV-26682)

  • Improved DDL and data dictionary (MDEV-25919)

  • Performance fixes (MDEV-26356, MDEV-26467, MDEV-26826)

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

    • CVE-2021-46662

    • CVE-2022-27385

    • CVE-2022-27385

    • CVE-2022-31624

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.4 Release Notes

The most recent release of MariaDB 10.6 is:MariaDB 10.6.21 Stable (GA) Download NowAlternate download from mariadb.org

Download 10.6.4Release NotesChangelogOverview of 10.6

Release date: 6 Aug 2021

Warning: This version can cause InnoDB file corruption on FreeBSD and on AIX. Stick to an earlier release, or upgrade to a more recent release, if you are running either of these environments. See MDEV-26537.

MariaDB 10.6 is the current stable series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.4 is a Stable (GA) release.

For an overview of MariaDB 10.6 see theWhat is MariaDB 10.6? 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)

  • Fixed scrubbing on AIX (MDEV-26110)

  • buf_pool.flush_list corrupted by buffer pool resizing or ROW_FORMAT=COMPRESSED (MDEV-26200)

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)

  • Fixed the issue fixed in MySQL Bug #76803: DML or locking SELECT statements that use outer joins could produce this warning in the error log: [ERROR] InnoDB: Unlock row could not find a 3 mode lock on the record. (MDEV-26106)

Packaging & Misc

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

  • Debian 11 Bullseye repositories added

  • Galera updated to 26.4.9

  • Linux on IBM Z (s390x) architecture added with releases on Ubuntu-20.04 Focal

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-2372

    • CVE-2021-2389

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.3 Release Notes

The most recent release of MariaDB 10.6 is:MariaDB 10.6.21 Stable (GA) Download NowAlternate download from mariadb.org

Download 10.6.3Release NotesChangelogOverview of 10.6

Release date: 6 Jul 2021

MariaDB 10.6 is the current stable series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.3 is a Stable (GA) release.

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

Thanks, and enjoy MariaDB!

Notable Changes

InnoDB

  • Maximum value of innodb_lock_wait_timeout is now 100000000, which means infinite timeout (MDEV-26067)

  • Write performance improvements: MDEV-25954, MDEV-25948, MDEV-25113, MDEV-26004, MDEV-25801

  • Atomic DDL rewrite (MDEV-25506)

  • Thinly provisioned SSD support for page_compressed tables (MDEV-26029)

Replication

  • Fix binlog background thread hang at shutdown (MDEV-26031)

General

  • The views INFORMATION_SCHEMA.KEYWORDS and INFORMATION_SCHEMA.SQL_FUNCTIONS have been added to the information schema (MDEV-25129)

  • Assertion ``thd->locked_tables_mode == LTM_NONE'failed inLocked_tables_list::init_locked_tables` (MDEV-25837)

Security

  • Fixes for the following security vulnerabilities:

    • CVE-2021-35604

    • CVE-2021-46658

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.2 Release Notes

The most recent release of MariaDB 10.6 is:MariaDB 10.6.21 Stable (GA) Download NowAlternate download from mariadb.org

Download 10.6.2Release NotesChangelogOverview of 10.6

Release date: 18 Jun 2021

MariaDB 10.6 is the current development series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.2 is a Release Candidate (RC) release.

Do not use non-stable (non-GA) releases in production!

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

Register now for our MariaDB Community Server 10.6 webinar to be held 2021-06-29 and be one of the first to see the biggest features coming in MariaDB Community Server 10.6, with an exclusive opportunity to have your questions answered by MariaDB engineering and product leads.

Thanks, and enjoy MariaDB!

Notable Changes

InnoDB

  • When innodb_adaptive_hash_index=OFF (the default), the following counters (which reflect btr_cur_n_non_sea) will no longer be updated (MDEV-25882):

    • adaptive_hash_index in INFORMATION_SCHEMA.INNODB_METRICS

    • Innodb_adaptive_hash_non_hash_searches in INFORMATION_SCHEMA.GLOBAL_STATUS

Replication

  • Semisync replica recovery is introduced. rpl-semi-sync-slave-enabled = ON server executes a special recovery branch to guarantee its consistency with a primary server (MDEV-21117)

General

  • Error messages now use "MariaDB" instead of "MySQL" (MDEV-22189)

  • Implement FLUSH TABLES tbl_name [, tbl_name] ... WITH READ LOCK for views (MDEV-15888)

  • All statements can be prepared, except PREPARE, EXECUTE, and DEALLOCATE / DROP PREPARE (MDEV-16708)

Changelog

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

Contributors

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

Do not use non-stable (non-GA) 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.6.1 Release Notes

The most recent release of MariaDB 10.6 is:MariaDB 10.6.21 Stable (GA) Download NowAlternate download from mariadb.org

Download 10.6.1Release NotesChangelogOverview of 10.6

Release date: 21 May 2021

MariaDB 10.6 is the current development series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.1 is a Beta release.

Do not use beta releases in production!

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

Register now for our MariaDB Community Server 10.6 webinar to be held 2021-06-29 and be one of the first to see the biggest features coming in MariaDB Community Server 10.6, with an exclusive opportunity to have your questions answered by MariaDB engineering and product leads.

Thanks, and enjoy MariaDB!

Notable Changes

Notable changes of this release include:

Atomic DDL

  • CREATE TABLE, ALTER TABLE, RENAME TABLE, DROP TABLE, DROP DATABASE and related DDL statements are now atomic. Either the statement is fully completed, or everything is reverted to it's original state. Note that when deleting multiple tables with DROP TABLE, only each individual drop is atomic, not the full list of tables). (MDEV-23842).

Replication, Galera and Binlog

  • Galera updated to 26.4.8

  • The delay between binary log purges can now be specified with much greater precision. The system variable binlog_expire_logs_seconds is introduced as a form of alias for expire_logs_days, which now accepts a precision of 1/1000000 days (MDEV-19371)

  • Allow transition from unencrypted to TLS Galera cluster communication without cluster downtime (MDEV-22131)

  • DDL information logged on all Galera cluster nodes if wsrep_debug is set to SERVER and wsrep_OSU_method is 'TOI' (MDEV-9609)

  • For the mysqlbinlog / mariadb-binlog --base64-output option, removed the deprecated always option, and changed the default to auto (MDEV-25222)

Oracle Compatibility

  • ADD_MONTHS() added (MDEV-20025)

  • TO_CHAR() added (MDEV-20017)

  • SYS_GUID() added (MDEV-24285)

  • MINUS is mapped to EXCEPT in UNION (MDEV-20021)

  • ROWNUM function returns the current number of accepted rows in the current context (MDEV-24089)

Character Sets

  • The utf8 character set (and related collations) is now by default an alias for utf8mb3 rather than the other way around. It can be set to imply utf8mb4 by changing the value of the old_mode system variable (MDEV-8334)

Clients

  • For clients such as mysql / mariadb, the connection property specified via the command line (e.g. --port=3306) will now force its type (MDEV-14974)

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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.6.0 Release Notes

The most recent release of MariaDB 10.6 is:MariaDB 10.6.21 Stable (GA) Download NowAlternate download from mariadb.org

Download 10.6.0Release NotesChangelogOverview of 10.6

Release date: 26 Apr 2021

MariaDB 10.6 is the current development series of MariaDB. It is an evolution of MariaDB 10.5 with several entirely new features.

MariaDB 10.6.0 is an Alpha release.

Do not use alpha releases in production!

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

Thanks, and enjoy MariaDB!

Notable Changes

This is the first alpha release in the MariaDB 10.6 series.

Notable changes of this release include:

SQL Syntax

  • Indexes can be ignored (MDEV-7317)

  • Implement SQL-standard SELECT ... OFFSET ... FETCH (MDEV-23908)

  • Add SELECT ... SKIP LOCKED syntax (InnoDB only) (MDEV-13115)

  • JSON_TABLE, used to extract JSON data based on a JSON path expression and to return it as a relational table (MDEV-17399)

Oracle Compatibility

  • Anonymous subqueries in a FROM clause (no AS clause) are permitted in ORACLE mode

Storage Engines

  • TokuDB has been removed (MDEV-19780)

  • CassandraSE has been removed (MDEV-23024)

InnoDB

  • Optimization to speed up inserts into an empty table (MDEV-515)

  • Make InnoDB's COMPRESSED row format read-only by default (MDEV-23497)

  • Information Schema SYS_TABLESPACES now directly reflects the filesystem, and SYS_DATAFILES has been removed (MDEV-22343)

  • innodb_flush_method=O_DIRECT is enabled by default (MDEV-24854), and liburing replaces libaio on recent Linux kernels (MDEV-24883).

  • The InnoDB transaction deadlock reporter was improved (MDEV-24738).

  • The old MariaDB 5.5-compatible innodb checksum is no longer supported, only crc32 and full_crc32. Removed the *innodb and *none options from innodb_checksum_algorithm, and the --strict-check/-C and --write/-w options from innochecksum (MDEV-25105)

Replication, Galera and Binlog

  • Increase master_host limit to 255, user to 128 (MDEV-24312)

  • The wsrep_mode system variable, for turning on WSREP features which are not part of default behavior (including the experimental Aria replication) (MDEV-20008, MDEV-20715, MDEV-24946)

Sys Schema

  • Bundle sys-schema, a collection of views, functions and procedures to help administrators get insight into database usage. (MDEV-9077)

Performance Schema

  • Merged replication instrumentation and tables (MDEV-16437, MDEV-20220)

General

  • Do not resend unchanged resultset metadata for prepared statements (MDEV-19237)

  • --bind-address=hostname now listens on both IPv6 and IPv4 addresses (MDEV-6536)

  • Support systemd socket activation (MDEV-5536)

  • For the GSSAPI plugin, support AD or local group name, and SIDs on Windows (MDEV-23959)

  • Check for $MARIADB_HOME/my.cnf (MDEV-21365)

  • max_recursive_iterations has been reduced to 1000 (MDEV-17239)

  • Setting system variables to negative values will no longer set them to the maximum value (MDEV-22219)

Galera

  • wsrep_mode variable for turning on WSREP features which are not part of default behavior.

  • wsrep_strict_ddl has been deprecated. Use wsrep_mode=STRICT_REPLICATION instead.

InnoDB Variables

The following deprecated variables have been removed (MDEV-23397):

  • innodb_adaptive_max_sleep_delay

  • innodb_background_scrub_data_check_interval

  • innodb_background_scrub_data_compressed

  • innodb_background_scrub_data_interval

  • innodb_background_scrub_data_uncompressed

  • innodb_buffer_pool_instances

  • innodb_commit_concurrency

  • innodb_concurrency_tickets

  • innodb_file_format

  • innodb_large_prefix

  • innodb_log_checksums

  • innodb_log_compressed_pages

  • innodb_log_files_in_group

  • innodb_log_optimize_ddl

  • innodb_page_cleaners

  • innodb_replication_delay

  • innodb_scrub_log

  • innodb_scrub_log_speed

  • innodb_thread_concurrency

  • innodb_thread_sleep_delay

  • innodb_undo_logs

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.6.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