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, .
The is now shrunk by reclaiming unused space at startup ()
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 ()
All binlog* variables are now visible as system variables, specifically , , ()
enhancement ()
Temporary tables are now displayed in the , and ()
For a list of all new variables, see .
For a complete list of security vulnerabilities (CVEs) fixed across all
versions of MariaDB, see the
page.
:
: ,
Date
Release
Status
Release Notes
Changelog
This page is licensed: CC BY-SA / Gnu FDL
: validation of stored program statements (MDEV-5816)
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 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!
The is now shrunk by reclaiming unused space at startup ()
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 ()
All binlog* variables are now visible as system variables, specifically , , ()
enhancement ()
Temporary tables are now displayed in the , and ()
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 ()
InnoDB
JSON
Miscellaneous
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 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.
Fix attempt to read outside the bounds of the file: ./ibdata1 ()
Fix MariaDB crash with SIGILL because the OS does not support AVX512 ()
Fix deadlock caused by lock_rec_unlock_unmodified() ()
Fix server crash when calling after is enabled ()
SELECT MIN on Spider table no longer returns more rows than expected ()
Fix Spider group by handler wrong result on order by aggregate ()
Fix Storage Engine S3 that caused 500 error when using Huawai Cloud S3 and possibly other S3 providers ()
A new option has been added. s3-provider=Huawai needs to be set for Huawai Cloud S3
New option , if true, SSL certificate verification for the S3 endpoint is disabled
Fix crash caused by query containing constant having clause ()
Fix assertion with optimizer_join_limit_pref_ratio and 1-table select ()
Fix InnoDB crash under Windows Subsystem for Linux on ALTER TABLE or OPTIMIZE TABLE ()
Modification of the column now correctly checks foreign key constraint ()
Fix incorrect NULL value handling for instantly dropped BLOB columns ()
Galera updated to 26.4.20
Fix server crash when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table ()
TOI (ALTER) no longer hangs on a parent table if SR transaction is in progress on a child table ()
Recovery now correctly notes some log corruption ()
InnoDB now correctly merges the change buffer to ROW_FORMAT=COMPRESSED tables ()
Can now selectively restore sequences using innodb tables from backup ()
now properly unquotes strings ()
default values now allows non-string literals ()
no longer hangs on startup when --init-file target does not exist ()
LOAD DATA INFILE with geometry data no longer fails ()
Fix heap-use-after-free in group_concat with compressed or GIS columns ()
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed
information on each push, see the .
For a full list of contributors to , see the .
This page is licensed: CC BY-SA / Gnu FDL
Fix duplicate key error in table 'mysql.innodb_table_stats' ()
Fix possible adaptive hash index corruption with ALTER TABLE...IMPORT TABLESPACE and FULLTEXT SEARCH ()
XA prepare now correctly releases unmodified records in non-blocking mode ()
Fix contention between secondary index UPDATE and purge due to large innodb_purge_batch_size ()
New default of 127 for (previously 1000).
Fix redundant page lookups that hurt performance ()
Implement on 64-bit systems for improving ib_logfile0 reads ()
Fix INSERT...SELECT' on MyISAM table suddenly replicated by alera ()
Fix case where with wsrep_mode=REPLICATE_ARIA, only part of the mixed-engine transactions was replicated ()
Fix galera_ssl_reload failure with warning message ()
When InnoDB gets an assertion failure, WSREP layer is now handled gracefully ()
Fix assertion `!is_cond()' failed in Item_bool_func::val_int / do_select ()
Trigger now works correctly with bulk update ()
Fix assertion failure in find_producing_item upon a query from a view ()
Add new setting, to the mariadb client for use in --quick mode ()
Notable Items
Storage Engines
InnoDB
Optimizer
Data Definition - Alter Table
Backup
JSON
General
Security
Changelog
Contributors
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 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 ()
Fix index corruption when doing a REPAIR TABLE that has a size of over 4G ()
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]' ()
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 ()
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 ()
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 ()
Hide password passed on commandline from xtrabackup_info ()
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
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.
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 ()
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` ()
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 ()
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 ()
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 ()
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 ()
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 ()
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 ()
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed
information on each push, see the .
For a full list of contributors to , see the .
Do not use non-stable (non-GA) releases in production!
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 ()
Server crashes when wsrep_sst_donor and wsrep_cluster_address set to NULL ()
Create temporary sequence can cause inconsistency ()
Galera 4 unable to query cluster state if not primary component ()
Notable Items
General
Character Sets, Data Types
InnoDB
Aria
Spider
Optimizer
Replication
Galera
Security
Changelog
Contributors
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 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.
Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) ()
Fix InnoDB holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL ()
Fix adaptive hash index corruption after ()
Fixed that internal temporary tables did not wait for freed disk space, and related issues ()
Fix wrong result on 2nd execution of prepared statement for query with derived table ()
Improve Spider performance by pushing down function () and statement () to data nodes
Fix server crash when deleting partitions from a table with spider engine ()
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 ()
Port backup features from Enterprise Server. This adds support for to , and obsoletes the and options ()
now preserves ()
Fix problem on older mariadb (opendir(NULL)) caused by ()
Fixed improper application of COLLATE to non-character columns ()
Default charset now works with PHP MySQLi extension ()
Fixed Bad SEPARATOR value in on character set conversion ()
View created via now returns correct json object ()
now detects the type of String Values and correctly returns Date/DateTime values ()
no longer returns NULL on valid arguments ()
WolfSSL's math is unnecessarily slow ()
Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables ()
Wrong result with cross Join given join order ()
Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT ()
The now reports the user and host in all cases ()
--gtid-ignore-duplicate can double-apply event in case of parallel replication retry ()
Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure ()
mysql_manager_submit Segfault at Startup Still Possible During Recovery ()
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 ()
Transportable Tablespaces no longer leave in a mismatched state ()
Fix wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption ()
Fix incorrect DEFAULT expression evaluated in ()
MariaDB-client community can't be installed in red hat ubi9 ()
It's now possible to disable system commands with the option. ()
now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.()
commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions ()
Moving from to 10.6 mysql_upgrade is not updating some system tables ()
Original IP not shown in network related error messages when proxy_protocol is in use ()
Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup ()
Fixes for the following :
For a complete list of changes made in , with links to detailed
information on each push, see the .
For a full list of contributors to , see the .
This page is licensed: CC BY-SA / Gnu FDL
Server no longer aborts while altering an InnoDB statistics table (MDEV-33462)
Fix LeakSanitizer errors in rec_copy_prefix_to_buf (MDEV-33230)
Fix InnoDB fatal error: 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)
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)
Notable Items
Storage Engines
InnoDB
Backup
,
JSON
Encryption, TLS, SSL
Optimization & Tuning
Plugins
Replication
Galera
SQL, Data Definition, and Data Manipulation
Platforms & Packaging
General
Scripts & Clients
Server
Security
Changelog
Contributors
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
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 ()
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 ()
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
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 ()
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 ()
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 ()
InnoDB: CHAR+nopad does not work well ()
CAST(AS UNSIGNED) fails with --view-protocol ()
JSON_ARRAYAGG charset issue ()
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 (
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 ()
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.
Fixes for the following :
For a complete list of changes made in , with links to detailed
information on each push, see the .
For a full list of contributors to , see the .
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 ()
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 ()
Assertion (col.vers_sys_end()) upon inplace ALTER with virtual columns ()
DELETE with ORDER BY and semijoin optimization causing crash ()
Invalid expr in cleanup_session_expr() upon INSERT DELAYED ()
SIGSEGV in my_decimal::operator= and Assertion 0'failed inItem_type_holder::val_decimal` on SELECT ()
LONG UNIQUE does not work like unique key when using replace ()
LONG UNIQUE gives error when used with REPLACE ()
Backport to 10.6 ()
Assertion ``0' failed in Item_type_holder::val_int` ()
Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types ()
)
mariadb-upgrade should remove mysql.plugin entries for plugins that became bundled ()
wsrep_provider_options can be truncated on deep and long directory paths ()
Server crashes in rpl_sql_thread_info::cached_charset_compare / wsrep_apply_events ()
Galera crash when "create a table as select" ()
Cluster is inconsistent after SAVEPOINT statement is rolled back ()
WSREP GTID MODE is inconsistent ()
IST "Donor does not know my secret" with ssl-mode=VERIFY_CA ()
SHOW SLAVE STATUS Can Deadlock an Errored Slave ()
main.rpl_mysqldump_slave Fails with "Master binlog wasn't deleted" Assertion ()
rpl_seconds_behind_master_spike Sensitive to IO Thread Stop Position ()
Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty ()
"Read semi-sync reply magic number error" warnings on master ()
Second Semi-sync Replica Can Hang at Connect Time ()
Semi-sync ACKed Transaction can Timeout and Switch Off Semi-sync with Multiple Replicas ()
Semi-Sync Ack_Receiver Thread Should Allow COM_QUIT Command ()
Upgrade to 12.6.
Using two temporary tables in OPTIMIZE TABLE lead to crash ()
REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode ()
CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" ()
Failure when executing PS for query using IN subquery ()
Potential memory leak on execuing of create view statement ()
Assertion failures ()
Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES ()
Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds ()
Set TaskMax=inifinity in the MariaDB systemd unit ()
Unreliable autocommit flag on connection creation ()
A connection can control RAND() in following connection ()
THD::rli_fake/rgi_fake not cleared on new connection ()
Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> ()
Server crash in find_field_in_table ()
LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()
Failure to call SP invoking another SP with parameter requiring type conversion ()
The database part is not case sensitive in SP names ()
EXCHANGE PARTITION with non-matching vcol expression segfault ()
Wrong user in SET DEFAULT ROLE error ()
quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') ()
mysql.slow_log reports incorrect start time ()
Update federated table and column privileges ()
Disable transparent huge pages after page buffers have been allocated ()
Deprecate ()
sys schema view session_ssl_status is empty ()
Memory pressure ()
Notable Items
InnoDB
Backup
JSON
Spider
Optimizer
Data Definition, Data Manipulation
Character Sets, Data Types
Plugins
Galera
Replication
General
Security
Changelog
Contributors
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.
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 from 300 to 1000 (MDEV-32050)
Deprecate .
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. ()
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)
Wrong result of: WHERE inet6_column IN ('','::1') (MDEV-31719)
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)
Raise notes when an index cannot be used on data type mismatch (MDEV-32203)
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)
utf8mb3_key_col=utf8mb4_value cannot be used for ref access (MDEV-32113)
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)
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)
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.