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 ()
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"
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
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.
This page is licensed: CC BY-SA / Gnu FDL
Assertion ``0'failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search ()
Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table ()
Crash emitting "Unsupported meta-data version number" error message ()
LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED ()
Inplace alter rebuild increases file size ()
BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY ()
GNU libc posix_fallocate() may be extremely slow ()
InnoDB wrong error message ()
Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 ()
InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe ()
InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty ()
innodb_fast_shutdown=0 hang after incomplete startup ()
innodb_undo_log_truncate=ON prevents fast shutdown ()
Adaptive flush recommendation ignores dirty ratio and checkpoint age ()
gcol.gcol_purge contaminates further execution of innodb.gap_locks ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Adaptive flushing is still not getting invoked in 10.5.11 ()
History list is not shrunk unless there is a pause in the workload ()
path separator near ib_buffer_pool incorrect ()
Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption ()
Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON ()
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 ()
ASAN 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 ()