MariaDB 10.5.23 Release Notes

Download 10.5.23 Release Notes Changelog Overview of 10.5

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.

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

• Galera updated to 26.4.16
• 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)
• mariadb-admin (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)
• mariadb-install-db (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)

Docker Official Images

• Invert single and double quotes for sql command definitions in healthcheck.sh due to failure under sql_mode=ANSI_QUOTES - contribution by Dominik Häckel
• healthcheck.sh --no-defaults behaviour was corrected - reported by Dominik Häckel
• Added /docker-entrypoint-init.d for tar{,compression} from mariadb-backup - instructions
• Refactor docker_mariadb_init in the entrypoint for extending the MariaDB image
• CIS failure due to world-writable directory /var/run/mysqld, added sticky bit - reported by @ollie1
• Add PROXY privileges for root@MARIADB_ROOT_HOST - reported by Matthieu Gusmini
• healthcheck.sh added --galera_online test, to match what the mariadb-operator does.

Security

• Fixes for the following security vulnerabilities:
  • CVE-2023-22084

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.5.23, see the MariaDB Foundation release announcement.