[RELEASE] MariaDB 10.4.32 Release Notes

[puertoblack2003]

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)

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)

Data Definition

• MariaDB crash on calling function (MDEV-23902)
• ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations (MDEV-31970)

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)

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)

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)

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