The Ultimate Guide to High Availability with MariaDB

MariaDB 10.5.23 Release Notes

You are viewing an old version of this article. View the current version here.

Download Release Notes Changelog Overview of 10.5

Alternate download from mariadb.org

Release date: 13 Nov 2023

MariaDB 10.5 is a previous stable series of MariaDB, maintained until June 2025. It is an evolution of MariaDB 10.4 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.5.23 is a Stable (GA) release.

For an overview of MariaDB 10.5 see the What is MariaDB 10.5? page.

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)

Optimizer

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

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)

Galera

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

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)

Scripts and Clients

  • mariadb-binlog -T/--table (mysqlbinlog) option (MDEV-25369)
  • 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)
  • 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)

MariaBackup

  • MariaBackup 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<FbtImpl>::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)

Security

Changelog

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

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.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.