can now do most operations with ALGORITHM=COPY, LOCK=NONE, that is, in most cases, unless the algorithm and lock level are explicitly specified, ALTER TABLE will be performed using the algorithm while simultaneously allowing concurrent on the altered table.
For more information, refer to, .
InnoDB
The is now shrunk by reclaiming unused space at startup (MDEV-14795)
JSON
now allows retrieval of the key when iterating on JSON objects (MDEV-30145)
New functions , and to check for JSON intersection (MDEV-26182)
extracts key/value pairs from a JSON object (MDEV-30145)
Miscellaneous
All binlog* variables are now visible as system variables, specifically , , (MDEV-30188)
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 page.
MariaDB 11.2 is a short-term stable series of MariaDB and will be maintained until October 2024. It is an evolution of MariaDB 11.1 with several entirely new features.
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 page.
MariaDB 11.2 is a current short-term stable series of MariaDB and will be maintained until October 2024. It is an evolution of MariaDB 11.1 with several entirely new features.
From this version, the tool adds a new 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
Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) (MDEV-33515)
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 (MDEV-33400)
Server no longer aborts while altering an InnoDB statistics table ()
Fix LeakSanitizer errors in rec_copy_prefix_to_buf ()
Fix InnoDB fatal error: Clustered record field for column x not found ()
Fix InnoDB hang when temporarily running out of buffer pool ()
Fix alter operation hang when encryption thread works on the same tablespace ()
Fix discard/import tablespace, restart, index corruption ()
Fix server hang on DROP INDEX or RENAME INDEX ()
Fix mariadb-backup --backup hang ()
Fix server hang caused by InnoDB change buffer ()
Fix assertion failures upon adding a too long key to table with COMPRESSED row format ()
IMPORT TABLESPACE no longer fails with column count or index count mismatch ()
Fix alter table corruption while applying the modification log ()
Fix inconsistent behaviors of UPDATE under RU & RC isolation level ()
Fix weird SELECT view when a record is modified to the same value by two transactions ()
Fix inconsistent read and write, which use the same predicate (WHERE clause) ()
Fix inconsistent SELECT view when modifying a record added by another transaction ()
Fix weird read view after ROLLBACK of other transactions ()
Read only server no longer throws error when running a create temporary table as select statement ()
Change buffer index no longer fails to delete the records ()
Fix InnoDB include OS error information when failing to write to iblogfile0 ()
Fix phantom rows caused by UPDATE of PRIMARY KEY ()
New system variable,
In-place migration from MySQL 5.7 no longer causes invalid AUTO_INCREMENT values ()
Fix InnoDB log corruption before upgrading it on startup ()
Table no longer gets rebuilt with ALTER TABLE ADD COLUMN ()
Fixed that internal temporary tables did not wait for freed disk space, and related issues (MDEV-33813)
Fix wrong result on 2nd execution of prepared statement for query with derived table (MDEV-31361)
Improve Spider performance by pushing down function (MDEV-28992) and 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 ()
Fix sql plugin init failure with traditional sql_mode ()
Fix parsing failure on valid left join select by translating the on expression to () ()
Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using local and remote ()
Fix bug where were not available if Spider was loaded upon server startup ()
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 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 (MDEV-33790)
Fix server crash when UPDATE statement with duplicate key is run after setting a low thread_stack ()
Fix incorrect handling of in PS mode when a table's column declared as NOT NULL ()
Fix crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT ()
Fix wrong result on 2nd execution of PS to select from view using derived ()
Fix wrong warnings on 2nd execution of PS for query with GROUP_CONCAT ()
value of '1970-01-01 00:00:00' can no longer be indirectly inserted in ()
Fix out of range error in (()) due to a wrong data type ()
Fix zero datetime reinterpreting as '1970-01-01 00:00:00' on field_datetime=field_timestamp ()
unix_timestamp(coalesce(timestamp_column)) no longer returns NULL on '1970-01-01 00:00:00.000001' ()
Fix crash using UDF in WHERE clause of VIEW ()
Fix update for portion changes autoincrement key in period table ()
Fix SIGABRT resulting from CREATE TABLE with generated column and RLIKE ()
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 option. (MDEV-21778)
now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.(MDEV-33727)
commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions (MDEV-4827)
Loading now works with INPLACE ()
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 ()
MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params ()
Slowdown when running nested statement with many partitions ()
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 page.
MariaDB 11.2 is a current short-term stable series of MariaDB, maintained until October 2024. It is an evolution of MariaDB 11.1 with several entirely new features.
Windows packages were delayed but have now been added to the downloads site
InnoDB
Unique hash key on column prefix is computed incorrectly ()
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 ()
Backup
mariadb-backup has wrong or missing plugin-dir default? ()
mariadb-backup fails when innodb_max_dirty_pages_pct contains a fraction (is not an integer) ()
Missing required privilege CONNECTION ADMIN ()
JSON
Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE ()
JSON_VALID fail to validate integer zero in scientific notation ()
ASAN
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 ()
SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES ()
Optimizer
Crash caused by multi-table UPDATE over derived with hanging CTE ()
Crash on query using CTE with the same name as a base table ()
Crash with query using constant subquery as left part of IN subquery ()
Data Definition, Data Manipulation
ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note ()
Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY ()
Character Sets, Data Types
InnoDB: CHAR+nopad does not work well ()
CAST(AS UNSIGNED) fails with --view-protocol ()
JSON_ARRAYAGG charset issue ()
Plugins
The can optionally (when is enabled) include the thread ID and database / table in its log (). NULL is displayed if there is no database ()
Backport SQL service, introduced by ()
"plugin already loaded" should be a Warning, not an Error (
Galera
Node has been dropped from the cluster on Startup / Shutdown with async replica ()
Inconsistency in Galera caused by ALTER being aborted before entering TOI mode ()
Server crashes in Item_func_binlog_gtid_pos::val_str / Binary_string::c_ptr_safe ()
binlog corruption (/tmp no space left on device at the same moment) ()
multi source replication filters breaking GTID semantic ()
General
As per the , this will be the last release of for Fedora 37, Ubuntu 23.04 "Lunar", and Windows Server 2019
is now dynamic, and contains new options, and old options have been deprecated ()
New value, NO_NULL_COLLATION_IDS, a compatibility setting to support connectors (in particular MySQL Connector/NET) that give an exception when collation ids returned by are NULL. It is automatically set when a MySQL Connector/NET connection is determined.
Security
Fixes for the following :
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
Be notified of new MariaDB Server releases automatically by 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 page.
MariaDB 11.2 is a current short-term stable series of MariaDB, maintained until November 2024. It is an evolution of MariaDB 11.1 with several entirely new features.
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 ()
(mysql_install_db) doesn't properly grant to all default root user accounts ()
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) ()
UBSAN shift exponent X is too large for 64-bit type 'long long int' in sql/field.cc ()
Wrong bit encoding using COALESCE ()
utf8mb3_key_col=utf8mb4_value cannot be used for ref access ()
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 ()
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 page.
This page is licensed: CC BY-SA / Gnu FDL
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, should be a much lighter operation because it will not involve any log checkpoint. ()
Some calls to buf_read_ahead_linear() seem to be useless ()
Opening all .ibd files on InnoDB startup can be slow ()
InnoDB LRU flushing does not run before running out of buffer pool ()
innodb_undo_log_truncate=ON is blocking page writes ()
If tables are frequently created, renamed, dropped, a backup cannot be restored ()
on table to be accessible to those with privileges ()
errors in
Item_func_json_contains_path::val_int
upon PS execution (
)
mysql_json cannot be used on newly created table ()
Problems with a stored function EMPTY() on upgrade to 10.6 ()
ASANheap-use-after-free in spider_link_get_key on LOCK TABLES ()
Crash when lateral derived is guaranteed to return no rows ()
Bogus error executing PS for query using CTE with renaming of columns ()
Spider: Valid LEFT JOIN results in ERROR 1064 ()
Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()
Spider tests failing in asan/valgrind builds ()
Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()
Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()
heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()
Syntax error upon query with subquery from Spider table ()
Spider doesn't recognize semi JOIN ()
MariaDB, SPIDER engine, usage of REGEXP ()
Spider: variable spider_same_server_link not functioning correctly ()
Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()
Spider spawns unnecessarily many system threads for stats synchronization ()
Defaults for and 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 ()
mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()
Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()
No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()
ASAN errors in spider_conn_queue_and_merge_loop_check ()
Incorrect result interceptor passed to mysql_explain_union() ()
Add variable to influence how costs for secondary keys are calculated. ()
INSERT ... SELECT Does not produce an optimizer trace ()
Unusable key notes do not get reported for some operations ()
Unusable key notes report wrong predicates for > and >= ()
FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure ()
MariaDB 11.2 is a short-term development series of MariaDB, and will be maintained for one year after its Generally Available release. It is an evolution of MariaDB 11.1 with several entirely new features.
MariaDB 11.2.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.2.
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.2-preview.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
InnoDB
The is now shrunk by reclaiming unused space at startup ()
JSON
now allows retrieval of the key when iterating on JSON objects ()
New functions , and to check for JSON intersection ()
extracts key/value pairs from a JSON object ()
Miscellaneous
All binlog* variables are now visible as system variables, specifically , , ()
enhancement ()
Temporary tables are now displayed in the , and ()
Be notified of new MariaDB Server releases automatically by 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 page.
This page is licensed: CC BY-SA / Gnu FDL
: validation of stored program statements ()
Remove the deprecated variable ()
Extend and to support an initialization vector and algorithm ()
MariaDB 11.2 is a current short-term stable series of MariaDB and will be maintained until October 2024. It is an evolution of MariaDB 11.1 with several entirely new features.
Unsetting the system variable restores the old behavior.
Fix unexpected storage read IO for the redo log, reintroduce ()
Aria
Fix index corruption when doing a REPAIR TABLE that has a size of over 4G ()
Spider
UBSAN: runtime error: applying non-zero offset in spider_free_mem and SIGSEGV in spider_free_mem on SELECT ()
SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' ()
Partitioning
MariaDB Server crashes with ill-formed partitions ()
SIGSEGV in parse_engine_part_options on INSERT, SELECT or ALTER ()
Assertion ``auto_increment_value'failed inha_partition::info` on INSERT into MEMORY table ()
Character Sets
On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb from strings/ctype-mb.c and other locations ()
On startup: UBSAN: runtime error: applying zero offset to null pointer in skip_trailing_space and my_hash_sort_utf8mb3_general1400_nopad_as_ci ()
Optimizer
On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info in sql/sql_select.cc ()
Crash after killing query while it is processed by test_quick_select ()
Extend condition normalization to include 'NOT a'
Auto-generated from table no longer breaks replication ()
Fix replication failure when are used where the replica has set and the client has touched a different database when running DML such as inserts. ()
Fix replication error when is used in conjunction with a password longer than 41 ascii characters ()
Backup
Hide password passed on commandline from xtrabackup_info ()
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
system variable added, and value added to the at startup ()
General
As per the , this will be the last release of for Debian 10 "Buster", RHEL/CentOS 7, Ubuntu 23.10 "Mantic", and Fedora 38
Repositories for Ubuntu 24.04 "Noble" have been added
no longer unnecessarily traverses tablespaces list ()
Security
Fixes for the following :
CVE-`-```
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
Be notified of new MariaDB Server releases automatically by 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 page.
This page is licensed: CC BY-SA / Gnu FDL
Correctly terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing ()
Alter operation on redundant table no longer aborts the server ()
Fix MariaDB crash with SIGILL because the OS does not support AVX512 ()
Fix InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound ()
wait_for_read in buf_page_get_low no longer hurts performance ()
Fix InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211 ()
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 ()
SIGSEGV in ha_spider::lock_tables on BEGIN after table lock ()
SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT and SELECT ()
Spider: Crashes, asserts, hangs, memory corruptions and ASAN heap-use-after-free's ()
As per the , this will be the last release of for Ubuntu 18.04 LTS "Bionic" and Ubuntu 22.10 "Kinetic"
In this release repositories for Debian 12 "Bookworm" have been added.
doesn't ignore error as it should ()
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 ()
Possibly wrong result or Assertion 0' failed in Item_func_round::native_op` ()
InnoDB
Crashing on I/O error is unhelpful ()
SIGSEGV in log_sort_flush_list() in InnoDB crash recovery ()
InnoDB tables are being flagged as corrupted on an I/O bound server ()
Aria
Various crashes upon INSERT/UPDATE after changing settings ()
Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded ()
Spider
SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT ()
that double as table params overriding mechanism is buggy ()
Optimizer
InnoDB engine statistics for each table ()
Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` ()
Problem with open ranges on prefix blobs keys ()
Replication
Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers ()
ends up in optimistic parallel slave binlog out-of-order ()
takes very long time on a busy system ()
Galera
Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_mariadb-backup ()
Node has been dropped from the cluster on Startup / Shutdown with async replica ()
KILL QUERY maintains nodes data consistency but breaks GTID sequence ()
Security
Fixes for the following :
CVE-`-```
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
Do not use non-stable (non-GA) releases in production!
Be notified of new MariaDB Server releases automatically by 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 page.
This page is licensed: CC BY-SA / Gnu FDL
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 ()
SQL/PL package body does not appear in ()
Unexpected result when combining , subselect and ()
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 ()
Assorted assertion failures in json_find_path with certain collations ()
Duplicate entry allowed into a ()
Server Status is reported in seconds ()
dies with Floating point exception ()
Add InnoDB engine information to the ()
Deadlock with 3 concurrent by ()
innodb protection against dual processes accessing data insufficient ()