Changelog for MariaDB Enterprise Server 10.5.27-21

MariaDB Enterprise Server 10.5.27-21 is a maintenance release of MariaDB Enterprise Server 10.5. For the categorized highlights and other details of this release, see the release notes.

MariaDB Enterprise Server 10.5.27-21 was released on 2024-12-09.

Changes

• (MDEV-35030) Q4 2024 release merge

• (MDEV-28894) Spider: remove #ifdef HA_EXTRA_HAS_STARTING_ORDERED_INDEX_SCAN

• (MDEV-28895) Spider: remove #ifdef HANDLER_HAS_CAN_USE_FOR_AUTO_INC_INIT

• (MDEV-28896) Spider: remove #ifdef SPIDER_UPDATE_ROW_HAS_CONST_NEW_DATA

• (MDEV-28892) Spider: remove #ifdef SPIDER_Item_args_arg_count_IS_PROTECTED

• (MDEV-28893) Spider: remove #ifdef SPIDER_NET_HAS_THD

• (MDEV-34100) backport MDEV-26912 Spider: Remove dead code related to Oracle OCI

• (MDEV-27650) Spider: remove #ifdef SPIDER_HAS_GROUP_BY_HANDLER

• (MDEV-34828) Fix-up on MDEV-26858 by removing some remnant obsolete code related to spider handlersocket support

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

• (MDEV-31788) Factor out code repeat in functions calling spider_check_and_init_casual_read()

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

Issues Fixed

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

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

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

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

• (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-34647) INSERT...SELECT' on MyISAM table suddenly replicated by Galera

• (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-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-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-29546) spider group by handler wrong result on order by aggregate

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

• (MDEV-33106) innodb.innodb-lock-inherit-read_commited fails with timeout

• (MENT-2167) galera_nbo_drop_table_concurrent test failed

• (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-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-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-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-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-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-8578) Wrong error code/message with enforce_storage_engine and NO_ENGINE_SUBSTITUTION

• (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-35183) ADD FULLTEXT INDEX unnecessarily DROPS FTS COMMON TABLES

• (MENT-2118) MENT-1555 fails on optimized builds due to debug_dbug use

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

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

• (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-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-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-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-34823) Invalid arguments in ib_push_warning()

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

• (MENT-1403) plugins.server_audit2_client fails with an extra line in output

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

• (MDEV-34734) Windows build crashes (OpenSSL)

• (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-14231) MATCH() AGAINST( IN BOOLEAN MODE), results mismatch

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

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