Changelog for MariaDB Enterprise Server 10.6.20-16

MariaDB Enterprise Server 10.6.20-16 is a maintenance release of MariaDB Enterprise Server 10.6. For the categorized highlights and other details of this release, see the release notes.

MariaDB Enterprise Server 10.6.20-16 was released on 2024-12-09.

Changes

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

Issues Fixed

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