The most recent release of MariaDB 11.0 is:MariaDB 11.0.6 Stable (GA) Download Now
Download 11.0.4 | Release Notes | Changelog | Overview of 11.0
Release date: 13 Nov 2023
MariaDB 11.0 is a current short-term stable series of MariaDB and will be maintained until June 2024. It is an evolution of MariaDB 10.11 with several entirely new features.
MariaDB 11.0.4 is a Stable (GA) release.
For an overview of MariaDB 11.0 see theWhat is MariaDB 11.0? page.
Thanks, and enjoy MariaDB!
followed by may corrupt data ()
ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. ()
Server aborts during alter operation when table doesn't have foreign index ()
row_merge_fts_doc_tokenize() handles FTS plugin parser inconsistently ()
New setting, cset_narrowing, to enable the ()
Crash when HAVING in a correlated subquery references columns in the outer query ()
Server crashes at TABLE::add_tmp_key ()
Server crashes inside filesort at my_decimal::to_binary (
rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables ()
Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication ()
strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT ()
Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE ()
updated to 26.4.16
Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed. ()
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 ()
wsrep_sst_mariadb-backup not working on FreeBSD (
MariaDB crash on calling function ()
ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations ()
vcol circular references lead to stack overflow ()
OPTIMIZE TABLE crash ()
(mysqlbinlog) option ()
(mysqladmin) wrong error with ()
shows warning on missing directory $pamtooldir/auth_pam_tool_dir ()
main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 ()
main.events_stress or events.events_stress fails with view-protocol ()
main.delete_use_source fails (hangs) with view-protocol ()
main.sum_distinct-big and main.merge-big fail with timeout with view-protocol ()
main.secure_file_priv_win fails with 2nd execution PS protocol ()
mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 ()
mbstream breaks page compression on XFS ()
Prefix keys for CHAR work differently for MyISAM vs InnoDB ()
Inconsistent results of DISTINCT with NOPAD ()
Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT ()
Compressed varchar values lost on joins when sorting on columns from joined table(s) ()
Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims ()
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 ()
ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler ()
ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str
option breaks importing sql dumps ()
Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 ()
getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO ()
Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT ()
Invert single and double quotes for sql command definitions in due to failure under - contribution by Dominik Häckel
--no-defaults behaviour was corrected - reported by Dominik Häckel
Added /docker-entrypoint-init.d for tar{,compression} from -
Refactor docker_mariadb_init
Added the system variable to manage [notes when an index cannot be used](https://mariadb.com/docs/general-resources/development-articles/mariadb-internals/mariadb-internals-documentation-query-optimizer/notes-when-an-index-cannot-be-used
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 .
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 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)
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)
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 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, 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)
Server crashes in Alter_info::add_stat_drop_index upon CREATE TABLE (MDEV-32449)
(mysql_install_db) doesn't properly grant to all default root user accounts (MDEV-21194)
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)
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)
memmove_avx_unaligned_ermsBinary_string::q_appendStatic_binary_string::q_appendmy_strntoull10rnd_8bitmain.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)
CIS failure due to world-writable directory /var/run/mysqld, added sticky bit - reported by @ollie1
Add for root@MARIADB_ROOT_HOST - reported by Matthieu Gusmini
added --galera_online test, to match what the mariadb-operator does.
This page is licensed: CC BY-SA / Gnu FDL