Changelog for MariaDB Enterprise Server 10.6.20-16

(MENT-2095) Backport MDEV-33856 New definition for Seconds_Behind_Master

(MENT-2145) Backport MDEV-23729 - INFORMATION_SCHEMA Table info. about user locked due to max_password_errors

(MDEV-35030) Q4 2024 release merge

(MDEV-27650) Spider: remove #ifdef SPIDER_HAS_GROUP_BY_HANDLER

(MDEV-34973) Annotate various methods with noexcept

(MDEV-14959) Control over memory allocated for SP/PS

(MDEV-34704) Quick mode produces the bug for mariadb client

(MDEV-34453) Trying to read 16384 bytes at 70368744161280 outside the bounds of the file: ./ibdata1

(MDEV-16699) heap-use-after-free in group_concat with compressed or GIS columns

(MDEV-34836) TOI (ALTER) hangs on a parent table if SR transaction is in progress on a child table

(MDEV-23983) Crash caused by query containing constant having clause

(MDEV-34682) Server crashes when calling spider UDF after aria_encrypt_tables is enabled

(MDEV-34690) lock_rec_unlock_unmodified() causes deadlock

(MDEV-34938) Under Windows Subsystem for Linux, InnoDB crashes on ALTER TABLE or OPTIMIZE TABLE

(MDEV-31173) Server crashes when setting wsrep_cluster_address after adding invalid value to wsrep_allowlist table

(MDEV-34814) mysqld hangs on startup when --init-file target does not exists

(MDEV-35276) Assertion failure in find_producing_item upon a query from a view

(MENT-2162) Cherry-pick MDEV-35109 fix into ES 10.6.20

(MENT-2152) Cherry-pick MDEV-35110 fix into ES 10.6.20

(MDEV-33470) Unique hash index is broken on DML for system-versioned table

(MDEV-32363) when InnoDB gets an assertion failure, WSREP layer is not handled gracefully

(MENT-2108) Assertion !(sql_mode & ~full_sql_mode) failed in spider_conn_queue_sql_mode after setting sql_mode

(MDEV-27037) Mysqlbinlog should output a warning if EOF is found before its stop condition

(MDEV-34207) Can't write; duplicate key in table 'mysql.innodb_table_stats'

(MDEV-34392) modification of the column fails to check foreign key constraint

(MDEV-29537) Creation of view with UNION and SELECT ... FOR UPDATE in definition is failed with error

(MDEV-34123) CONCAT Function Returns Unexpected Empty Set in Query

(MDEV-34647) INSERT...SELECT' on MyISAM table suddenly replicated by Galera

(MDEV-34867) engine S3 cause 500 error for huawei buckets

(MDEV-27412) JSON_TABLE doesn't properly unquote strings

(MDEV-26345) SELECT MIN on Spider table returns more rows than expected

(MDEV-32350) Can't selectively restore sequences using innodb tables from backup

(MDEV-34883) LOAD DATA INFILE with geometry data fails

(MDEV-34718) Trigger doesn't work correctly with bulk update

(MDEV-34802) Recovery fails to note some log corruption

(MDEV-35059) ALTER TABLE...IMPORT TABLESPACE with FULLTEXT SEARCH may corrupt the adaptive hash index

(MDEV-34879) InnoDB fails to merge the change buffer to ROW_FORMAT=COMPRESSED tables

(MDEV-30653) With wsrep_mode=REPLICATE_ARIA only part of mixed-engine transactions is replicated

(MDEV-35122) Incorrect NULL value handling for instantly dropped BLOB columns

(MENT-2164) Cherry-pick MDEV-35157 "wrong binlog timestamps on secondary nodes of a galera cluster", which will be in 10.6.21 CS

(MENT-2148) Backport MDEV-34529 and MDEV-35398 - Shrink the system tablespace when there are leaked undo pages

(MENT-2181) Cherry pick MDEV-35507 for server_auditv2 - ed25519 authentication plugin create user statement trigger plain text password in audit log

(MENT-2188) cherry-pick and change for audit v2 MDEV-35522

(MDEV-29265) Assertion mode_ == m_local || transaction_.is_streaming() during SST

(MENT-1213) intermediate files operations are not protected by backup locks

(MDEV-35135) Assertion !is_cond() failed in Item_bool_func::val_int / do_select

(MDEV-35072) Assertion with optimizer_join_limit_pref_ratio and 1-table select

(MDEV-29546) spider group by handler wrong result on order by aggregate

(MDEV-34937) S3 engine no longer functional on non-gcc builds

(MDEV-34808) Update HeidiSQL to v12.8

(MDEV-35040) A std::unique_ptr declaration is incompatible with clang++-20 -stdlib=libc++

(MDEV-28288) System versioning doesn't support correct work for engine=connect and doesn't always give any warnings/errors

(MDEV-34943) Disable Automatic Replication start in Docker Official Image docker-entrypoint/initdb.d

(MDEV-32778) galera_ssl_reload failed with warning message

(MDEV-34515) Contention between secondary index UPDATE and purge due to large innodb_purge_batch_size

(MDEV-34696) do_gco_wait() completes too early on InnoDB dict stats updates

(MDEV-34565) MariaDB crashes with SIGILL because the OS does not support AVX512

(MENT-1717) galera_sr.MENT-1278 test fails

(MENT-1908) galera_sr.galera_xa_* tests fails

(MENT-2159) Galera tests fail due to read_handler(): Unknown error 397 ()

(MDEV-34861) Generic Linux build (.tar.gz) still depends on openssl1.0.0 for galera support, ncurses5 for client

(MDEV-34987) Upgrade from Ubuntu 22.04 to 24.04 breaks MariaDB client (from tarball)

(MENT-2173) Timeouts in the galera_as_slave_ctas test

(MDEV-27944) View-protocol fails if database was changed

(MDEV-33997) Assertion ((WSREP_PROVIDER_EXISTS_ && this->variables.wsrep_on) && wsrep_emulate_bin_log) || mysql_bin_log.is_open() failed in int THD::binlog_write_row(TABLE*, bool, const uchar*)

(MDEV-34841) Enable working Galera tests

(MDEV-30536) no expected deadlock in galera_insert_bulk test

(MDEV-25614) Galera test failure on GCF-354

(MDEV-34234) Delayed SST when running on unprivileged containers on RHEL9

(MDEV-34976) Server crash report broken if Galera is not loaded

(MDEV-33373) Unexpected ER_FILE_NOT_FOUND upon reading from logging table after crash recovery

(MDEV-24193) UBSAN: sql/sql_acl.cc:9985:29: runtime error: member access within null pointer of type 'struct TABLE' , ASAN: use-after-poison in handle_grant_table

(MDEV-35050) Found wrong usage of mutex upon setting plugin session variables

(MDEV-35074) main.selectivity_notembedded and main.selectivity_innodb_notembedded fail with view protocol

(MDEV-31297) Create table as select on system versioned tables do not work consistently on replication

(MDEV-25060) Freeing overrun buffer, various crashes, ASAN heap-buffer-overflow in _mi_put_key_in_record

(MDEV-35086) Trying to lock mutex when the mutex was already locked (session_tracker.cc), server hangs

(MDEV-35082) HANDLER with FULLTEXT keys is not always rejected

(MDEV-18151) Skipped error returning for GRANT/SET PASSWORD

(MDEV-34340) mariadb-backup immediately dumps core

(MDEV-29351) SIGSEGV when doing forward reference of item in select list

(MDEV-35144) CREATE TABLE ... LIKE uses current innodb_compression_default instead of the create value

(MDEV-25199) galera.galera_pc_recovery fails to start up

(MDEV-34859) Failed to initialize non-blocking API

(MDEV-35236) Assertion (mem_root->flags & 4) == 0 failed in safe_lexcstrdup_root

(MDEV-32022) ERROR 1054 (42S22): Unknown column 'X' in 'NEW' in trigger

(MDEV-35249) Assertion (mem_root->flags & 4) == 0 failed in convert_subq_to_jtbm

(MDEV-34830) LSN in the future is not being treated as serious corruption

(MDEV-34447) Memory leakage is detected on running the test main.ps against the server 11.1

(MDEV-34833) Assertion failure in Item_float::do_build_clone (Item_static_float_func)

(MDEV-34776) Assertion failure in Item_string::do_build_clone

(MDEV-34636) SIGSEGV in ha_spider::update_create_info & SIGSEGV in my_hash_insert on ALTER

(MDEV-34376) Wrong data types when mixing an utf8 TEXT column and a short binary

(MDEV-33990) SHOW STATUS counts ER_CON_COUNT_ERROR as Connection_errors_internal

(MDEV-31636) Memory leak in Sys_var_gtid_binlog_state::do_check()

(MDEV-34869) ssl-cipher server system variable cannot configure both TLSv1.3 and TLSv1.2 ciphers at the same time

(MDEV-34589) Assertion !is_set() || (m_status == DA_EOF_BULK && is_bulk_op()) failed from mysql_admin_table on CHECK TABLE

(MDEV-35235) Assertion failure in diagnostics area upon overriding savepoint with innodb_snapshot_isolation

(MENT-2147) Assertion 'n & PENDING' failed during recovery

(MDEV-34996) Buildbot MSAN options in buildbot rather than server

(MDEV-33035) Galera test case MDEV-16509 unstable

(MDEV-32996) galera.galera_var_ignore_apply_errors -> [ERROR] WSREP: Inconsistency detected

(MDEV-30307) KILL command issued inside a transaction is problematic for galera replication

(MDEV-26314) ST_EQUALS listed twice in information_schema.SQL_FUNCTIONS

(MDEV-35007) mroonga modifies source files during build

(MDEV-34251) Conditional jump or move depends on uninitialized value in ha_handler_stats::has_stats

(MDEV-34993) Incorrect cardinality estimation causes poor query plan

(MDEV-34915) Out of order output in sys_vars.session_track_system_variables_basic in s390x builders

(MDEV-35116) InnoDB fails to set error index for HA_ERR_NULL_IN_SPATIAL

(MDEV-34659) SIGSEGV in __memcpy_evex_unaligned_erms from [Static_][Bb]inary_string::q_append on SELECT

(MDEV-30067) Assertion !error failed in ha_partition::delete_row on DELETE

(MDEV-34662) session_track_system_variables_basic test result (s390x only)

(MDEV-34533) ASAN error about stack overflow when writing record in Aria

(MDEV-35162) Error:

(MDEV-25633) MariaDB crashes when compiled with link time optimizations

(MDEV-34679) ER_BAD_FIELD uses non-localizable substrings

(MDEV-35125) Unnecessary buf_pool.page_hash lookups

(MDEV-8578) Wrong error code/message with enforce_storage_engine and NO_ENGINE_SUBSTITUTION

(MDEV-35180) ref_to_range rewrite causes poor query plan

(MDEV-35164) optimizer_join_limit_pref_ratio: assertion when the ORDER BY table becomes constant

(MDEV-34122) Assertion entry failed in Active_tranx::assert_thd_is_waiter

(MDEV-34929) Innodb page compression is not working at windows

(MDEV-31888) galera.galera_wan, galera.galera_vote_rejoin_* fail

(MDEV-29260) Server crashes when running migration queries inside Docker on Windows

(MDEV-35253) innodb.xa_prepare_unlock_unmodified fails in UBSAN

(MDEV-35149) Race condition around SET GLOBAL innodb_lru_scan_depth

(MDEV-35171) OS_FILE_NORMAL and OS_FILE_AIO are misleading

(MDEV-35183) ADD FULLTEXT INDEX unnecessarily DROPS FTS COMMON TABLES

(MDEV-35225) Bogus debug assertion failures in innodb.innodb-32k-crash

(MDEV-34755) GCC -Wstringop-truncation due to safe_strcpy()

(MDEV-34921) MemorySanitizer reports errors for non-debug builds

(MDEV-34983) Some std::atomic::fetch_or() or fetch_and() is being avoided unnecessarily

(MDEV-31221) UBSAN runtime error: negation of -9223372036854775808 cannot be represented in type 'long long int' in my_strtoll10_utf32

(MDEV-31302) Assertion mon > 0 && mon < 13 failed in my_time_t sec_since_epoch(int, int, int, int, int, int)

(MDEV-32891) Assertion value <= ((ulonglong) 0xFFFFFFFFL) * 10000ULL failed in str_to_DDhhmmssff_internal

(MDEV-28386) UBSAN: runtime error: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in my_strntoull_8bit on SELECT ... OCT

(MDEV-34894) Poor query plan, because range estimates are not reused for ref(const)

(MDEV-25900) Assertion octets < 1024 failed in Binlog_type_info_fixed_string::Binlog_type_info_fixed_string OR Assertion field_length < 1024 failed in Field_string::save_field_metadata

(MDEV-34799) "Could not write packet" err message args off by 1

(MDEV-33500) rpl.rpl_parallel_sbm can fail on slow machines, e.g., MSAN/Valgrind builders

(MDEV-34567) unit.my_apc always failing on FreeBSD-14

(MDEV-34864) SHOW INDEX FROM - SEQ_IN_INDEX - mysql-connector-net incompatibility

(MDEV-34825) FreeBSD fails to build under clang natively

(MDEV-34650) main.having_cond_pushdown test failure - crash server (s390x)

(MDEV-34952) main.log_slow test failure on opensuse builder

(MDEV-33858) Assertion (mem_root->flags & 4) == 0 fails on 2nd execution of PS with -DWITH_PROTECT_STATEMENT_MEMROOT=ON

(MDEV-33897) Galera test failure on galera_3nodes.galera_gtid_consistency

(MDEV-33133) GCF-1060 test causes a server crash

(MDEV-34640) galera_var_ignore_apply_errors test freezes

(MDEV-34594) Assertion client_state.transaction().active() failed in int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type)

(MDEV-30686) With wsrep_sst_rsync , Node goes into endless loop when trying to establish connection to donor for IST

(MDEV-34678) pthread_mutex_init() without pthread_mutex_destroy() if SUX_LOCK_GENERIC

(MDEV-34845) buf_flush_buffer_pool(): Assertion !os_aio_pending_reads() failed

(MDEV-34823) Invalid arguments in ib_push_warning()

(MDEV-34520) purge_sys_t::wait_FTS sleeps 10ms, even if it does not have to wait.

(MDEV-34803) innodb_lru_flush_size configuration is no longer used

(MDEV-34579) sp-no-valgrind fails when server is compiled with valgrind

(MDEV-34771) Types mismatch when cloning items causes debug assertion

(MDEV-34785) Assertion failure in Item_func_or_sum::do_build_clone (Item_func_not_all)

(MDEV-34831) MDEV-34704 introduces a typo, --qick

(MDEV-33091) PCRE2 headers aren't found on Solaris

(MDEV-34714) perror-win test error on localized Windows

(MDEV-34078) Memory leak in InnoDB purge when the PRIMARY KEY is defined on 32 columns

(MDEV-34994) Reduce CPU load due to unnecessary accept() calls

(MDEV-34757) assertion of (mem_root->flags & 4) == 0 fails in 2nd ps execution with partition pruning

(MENT-2174) MW-402 galera test fails sporadically

(MDEV-34783) SIGSEGV on SELECT query

(MDEV-25822) JSON_TABLE: default values should allow non-string literals

(MENT-2183) Cherry pick MDEV-35394 - Innochecksum misinterprets freed undo pages

(MDEV-34466) XA prepare don't release unmodified records in non-blocking mode

(MENT-2133) backport MDEV-34483 "Backup may copy unnecessarily much log"

(MDEV-34791) Redundant page lookups hurt performance

(MENT-2182) Cherry-pick MDEV-35470 - Internal temporary Aria tables writes blocks to disk at end of query