Changelog for MariaDB Enterprise Server 10.4.34-24

Issues Fixed

• (MDEV-33549) Incorrect handling of UPDATE in PS mode in case a table's column declared as NOT NULL

• (MDEV-33475) --gtid-ignore-duplicate can double-apply event in case of parallel replication retry

• (MDEV-33334) mariadb-backup fails to preserve innodb_encrypt_tables

• (MDEV-18590) galera.versioning_trx_id: Test failure: mysqltest: Result content mismatch

• (MDEV-31251) MDEV-30968 breaks running mariabackup on older mariadb (opendir(NULL))

• (MDEV-33770) Alter operation hangs when encryption thread works on the same tablespace

• (MDEV-21102) Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables

• (MDEV-33540) mariabackup --prepare: [ERROR] InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size

• (MENT-958) Spider/ODBC passed double quotes for names, in ANSI style

• (MDEV-32975) Default charset doesn't work with PHP MySQLi extension

• (MDEV-33679) spider returns parsing failure on valid left join select by translating the on expression to ()

• (MDEV-33506) Original IP not shown in network related error messages when proxy_protocol is in use

• (MDEV-33790) Incorrect DEFAULT expression evaluated in UPDATE

• (MDEV-33400) Adaptive hash index corruption after ALTER TABLE…DISCARD TABLESPACE

• (MDEV-30528) Assertion !mbmaxlen || !(prefix_len % mbmaxlen) failed in dtype_get_at_most_n_mbchars

• (MDEV-32346) InnoDB: Failing assertion: sym_node->table != NULL in pars_retrieve_table_def on UPDATE

• (MDEV-33218) Assertion active_arena->is_stmt_prepare_or_first_stmt_execute() || active_arena->state == Query_arena::STMT_SP_QUERY_ARGUMENTS failed. in st_select_lex::fix_prepare_information

• (MDEV-31154) Fatal InnoDB error or assertion !is_v failure upon multi-update with indexed virtual column

• (MDEV-33558) Fatal error InnoDB: Clustered record field for column x not found

• (MDEV-33795) MariaDB segfault on rowid filter query involving generated column

• (MDEV-33512) Discard/Import Tablespace, Restart, Index Corruption

• (MDEV-22855) Assertion !field->prefix_len || field->fixed_len == field->prefix_len failed in btr_node_ptr_max_size and in dict_index_node_ptr_max_size

• (MDEV-26499) galera_3nodes.galera_ipv6_mysqldump MTR failed: mysql_shutdown failed

• (MDEV-22063) Assertion 0 failed in wsrep::transaction::before_rollback

• (MDEV-25089) Assertion error.len > 0 failed in wsrep_status_t galera::ReplicatorSMM::handle_apply_error(galera::TrxHandleSlave&, const wsrep_buf_t&, const string&)

• (MDEV-25731) Assertion mode_ == m_local failed in void wsrep::client_state::streaming_params(wsrep::streaming_context::fragment_unit, size_t)

• (MDEV-33928) Assertion failure on wsrep_thd_is_aborting

• (MDEV-19044) Alter table corrupts while applying the modification log

• (MDEV-33584) sql plugin init failure with traditional sql_mode

• (MDEV-33802) Weird read view after ROLLBACK of other transactions.

• (MDEV-33777) Spider: ERROR 12710 (HY000): Invalid information from remote table when using MariaDB 10.5 local and MariaDB 10.6 remote

• (MDEV-32454) JSON test has problem in view protocol

• (MENT-1555) Spider: Set proper remote isolation based on information obtained by SQLGetInfo

• (MDEV-34003) ASAN: heap-use-after-free in memcpy from sql/protocol.cc on SELECT

• (MDEV-33980) mariadb-backup --backup is missing retry logic for undo tablespaces

• (MDEV-33216) ASAN reports "stack use after return" in Wsrep_schema_impl::open_table

• (MDEV-33861) main.query_cache fails with embedded after enabling WITH_PROTECT_STATEMENT_MEMROOT

• (MDEV-15703) Crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT, UBSAN runtime error: member call on null pointer of type 'struct TABLE_LIST' in Item_param::save_in_field

• (MDEV-33443) Unsafe use of LOCK_thd_kill in my_malloc_size_cb_func()

• (MDEV-33468) Sig11 due to stack overflow in Item_cond::remove_eq_conds

• (MDEV-28430) lf_alloc isn't safe on aarch64 (or ppc64le)

• (MDEV-33441) No spider variables available is Spider is loaded upon server startup

• (MENT-2064) Backport MDEV-33420 to MariaDB Enterprise

• (MENT-2010) plugins.server_audit2 fails with ps2 protocol

• (MDEV-21864) Commands start-all-slaves and stop-all-slaves are not listed in mysqladmin help

• (MDEV-32635) galera_shutdown_nonprim: mysql_shutdown failed

• (MDEV-33036) Galera test case galera_3nodes.galera_ist_gcache_rollover has warning

• (MDEV-33138) Galera test case MW-336 unstable

• (MDEV-33173) Galera test case galera_sr_kill_slave_before_apply unstable

• (MDEV-33172) Galera test case galera_mdl_race unstable

• (MDEV-33895) Galera test failure on galera_sr.MDEV-25718

• (MDEV-33898) Galera test failure on galera.MW-369

• (MDEV-33706) backport some spider fixes to 10.4 which was unlocked

• (MDEV-33742) do not create spider group by handler when all tables are constant

• (MDEV-33728) remove use of MYSQL_VERSION_ID and MARIADB_BASE_VERSION in spider

• (MDEV-21007) Assertion auto_increment_value failed in ha_partition::info upon UPDATE with partition pruning

• (MDEV-33661) LeakSanitizer: detected memory leaks on spider/odbc/pg suite

• (MDEV-33220) Fix g++-13 -Wmaybe-uninitialized warnings

• (MDEV-33747) Optimization of (SELECT) IN (SELECT ...) executes subquery at prepare stage

• (MDEV-10793) main.kill_processlist-6619 fails sporadically in buildbot with wrong result

• (MDEV-33292) main.kill_processlist-6619 occasionally fails due to different SHOW PROCESSLIST output

• (MDEV-33209) Stack overflow in main.json_debug_nonembedded due to incorrect debug injection

• (MDEV-33251) Redundant check on prebuilt::n_rows_fetched overflow

• (MDEV-13765) encryption.encrypt_and_grep failed in buildbot with wrong result (sporadic)

• (MDEV-32926) mysql_install_db_win fails on Buildbot

• (MDEV-28993) Spider: Push down CASE statement

• (MDEV-20094) InnoDB blob allocation allocates extra extents

• (MDEV-28992) Spider: Push down TIMESTAMPDIFF function

• (MDEV-33214) Table is getting rebuild with ALTER TABLE ADD COLUMN