Changelog for MariaDB Enterprise Server 10.6.21-17

Changes

• (MENT-2228) cherry-pick the fix for MDEV-36138
• (MDEV-35789) Q1 2025 release merge
• (MDEV-35854) Clean up some DDL code around FOREIGN KEY constraints
• (MDEV-35478) Correction for table->space_id in dict_load_tablespace() was mistakenly applied on an earlier branch
• (MDEV-35430) my_snprintf fixes for 10.6+
• (MDEV-28526) Spider: remove conn_kind member variables
• (MENT-2145) Backport MDEV-23729 - INFORMATION_SCHEMA Table info. about user locked due to max_password_errors
• (MENT-2234) Starting with this release we generate a Software Builds of Materials(SBOM) JSON file provided in the downloads archive, which can be reached from the "All Files" link on the MariaDB Enterprise Server downloads page
• (MDEV-32576) InnoDB deadlock output query length increased to improve visibility of deadlocked statements.
• (MENT-2200) Starting with this release we generate a Software Builds of Materials(SBOM) JSON file provided in the downloads archive, which can be reached from the "All Files" link on the MariaDB Enterprise Server downloads page

Issues Fixed

• (MDEV-31761) Fix incorrect writing of timestamp into binary logy, causing discrepancy upon binlog replaying
• (MDEV-34958) Fix trigger created with "CREATE TRIGGER `table1_after_insert` AFTER INSERT" which is adding rows to another table using "FOR EACH ROW insert into table2(`id`, `name`) values (NEW.`id`, NEW.`name`);" that did not work correctly when if bulk inserts are used by the application. Only the first row of the bulk insert would be added to the table
• (MDEV-35096) History is now stored on the same partitions on different Galera nodes when system versioning is enabled
• (MDEV-30111) Fix assertion falilure and possible index corruption with unique key and nopad collation without DESC or HASH keys
• (MDEV-34090) Fix client crash the command after client sets character set to utf32
• (MDEV-33987) Fix possible crash where server could not construct a geomery object from the input
• (MDEV-35409) Fix possible InnoDB hang while running out of buffer pool
• (MDEV-35064) Fix possible Spider thread hang in 'Update' state on 2nd INSERT
• (MDEV-33783) After changing the table definition for the system table 'mysql.servers', a following execution of CREATE SERVER would previously lead to a server crash.
  • NOTE: System tables should never be modified by a user anyhow
• (MDEV-35281) FIx streaming replication transaction crash with innodb_snapshot_isolation
• (MDEV-35465) Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled
• (MDEV-24035) Fix failing assertion causing disruption and replication failure
• (MDEV-35387) Fix possible failure of wsrep_sst_rsync SST script if user specified aria_log_dir_path different from default data directory
• (MDEV-35571) Fix connection hang after query on a partitioned table with UNION and LIMIT ROWS EXAMINED
• (MDEV-29935) Fix server crash in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY
• (MDEV-35647) Fix possible hang during CREATE TABLE…SELECT error handling, especially with innodb_snapshot_isolation enabled
• (MDEV-29744) Fix incorrect locking order of LOCK_log/LOCK_commit_ordered and LOCK_global_system_variables
• (MDEV-35326) Fix possible memory leak on SHUTDOWN
• (MDEV-35575) Fix possible memory leak while shutting down server after installing the auth_gssapi plugin
• (MDEV-22695) Fix possible crash on DELETE from a HEAP table
• (MDEV-26891) Fix possible server crash when using INSERT DELAYED on tables with virtual columns.
• (MDEV-28130) Fix possible crash during index traversal using `tree_search_next`.
• (MDEV-25654) Fix possible hang or crash during InnoDB purge with HASH indexes during ALTER TABLE
• (MDEV-35864) Fix possible hang or crash where zero offset applied to null pointer
• (MDEV-34925) Fix possible crash on bootup in spider_sys_open_table «ext-issue»«MDEV-32822», «ext-issue»«MDEV-34302»
• (MDEV-34849) Fix possible Spider crash or hang when the first byte of a connection key is changed
• (MDEV-35549) Fix possible runtime error caused by XA RECOVER applying a zero offset to a null pointer
• (MDEV-29182) Fix assertion failure on cascading foreign key update of table with vcol index in parent
• (MDEV-35090) FIx assertion failure where CURRENT_USER was not correctly copied during condition pushdown
• (MDEV-35710) Fix cluster node hang during shutdown if threadpool is used
• (MDEV-24935) Calling a stored routine that executes a join on three or more tables and referencing not-existent column name in the USING clause could previously result in a crash on its second invocation.
• (MENT-2175) Fix possible assertion failure when Galera cluster is in 'split-brain' state due to loss of communication between nodes (fix requires Galera library 26.4.21+)
• (MENT-2212) Fix assertion failure when executing XA PREPARE (and possibly other XA statements) on Galera cluster nodes
• (MENT-2214) Fix assertion failure when executing XA statements on Galera cluster nodes
• (MENT-2215) In rare cases, an ALTER TABLE or other operation could previously hang when using NBO mode on a cluster with very low network latencies (for example, when both nodes are running on the same physical machine)
• (MDEV-33064) MariaDB Cluster and ALTER INPLACE running in Total Order Isolation (wsrep_OSU_method=TOI) now correctly abort a DML INSERT operation in InnoDB
• (MDEV-33245) Fix possible crash in wsrep_check_sequence
• (MDEV-35446) Fix sporadic reporting of success when a deadlock error occurs under --ps-protocol BF aborted transaction
• (MDEV-35157) Fix rare cases where binlog entries could receive incorrect timestamps on secondary nodes of a Galera cluster, potentially impacting replication accuracy
• (MDEV-35507) For an authentication with the ed25519 authentication plugin the password of the CREATE USER statement is now masked in the audit log
• (MDEV-35522) MariaDB Audit now detects all DCLs forms for masking a password
• (MDEV-35679) Fix potential issue in secondary Index with ROW_FORMAT=COMPRESSED and Change buffering enabled
• (MDEV-35651) sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers
• (MDEV-34898) Fix doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages
• (MDEV-35335) START TRANSACTION, when triggering an implicit commit as a COMMIT or ROLLBACK has not been executed before, now resets optional characteristics added to the last START TRANSACTION command
• (MDEV-35528) mariadb-binlog can now correctly process more than one logfile when --stop-datetime is specified
• (MDEV-34924) Rows in table mysql.gtid_slave_pos are now correctly deleted on Galera nodes when wsrep_gtid_mode = 1 is used, which previously lead to wrong information about replica delays
• (MDEV-35612) EXCHANGE PARTITION now works for tables with unique blobs
• (MDEV-29968) Fix issue where functions in default values in tables with certain character sets could break SHOW CREATE and mariadb-dump
• (MDEV-35646) Setting `pseudo_thread_id` to a value exceeding 4 bytes previously resulted in truncation when written to the binary log
• (MDEV-19761) A BEFORE INSERT Trigger previously returned with error ""Field 'xxx' doesn't have a default value", if a NULL value is added for a column defined NOT NULL without explicit value and no DEFAULT specified
• (MDEV-35852) Undefined behavior could occur when attempting to perform INSERT DELAYED on a Galera cluster node.
• (MDEV-35445) Fix issue where ON UPDATE SET NULL could not be specified on a NOT NULL column
• (MDEV-34813) algorithm = instant can now correctly be used if a table has partitions and one tries to change a column with an index which is not the partitions key. This previously gave error "ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY"
• (MDEV-35018) Fix issue where DROP TABLE on child and UPDATE of parent table can cause a metadata lock BF-BF conflict when applied concurrently.
• (MDEV-33658) Can now correctly add a foreign key on a table with a long UNIQUE multi-column index that contains a foreign key as a prefix
• (MDEV-35869) Fix possibly wrong result using a degenerated subquery (SELECT <expr>) with window function
• (MDEV-20281) The "Failed to write to mysql.slow_log" error no longer shown without a detailed reason for the error
• (MDEV-35907) Fix debian-start script failure when using non-standard socket path
• (MDEV-35749) wsrep_sst_mariabackup.sh no longer uses --use-memory default (100MB) resulting in prepare stage which could take hours
• (MENT-2238) Replicate_* fields in Show-Slave-Status may be truncated, impacting replication monitoring.
• (MENT-2243) Cherry-Pick MDEV-35813 - Performance regression in INSERT...SELECT due to unnecessarily making InnoDB log durable
• (MENT-2245) Galera SSL errors after wolfSSL upgrade
• (MENT-2226) Cherry-pick MDEV-36026 - Problem with INSERT SELECT on NOT NULL columns while having BEFORE UPDATE trigger
• (MDEV-35098) rpl.rpl_mysqldump_gtid_slave_pos fails in buildbot
• (MDEV-35153) backport the MDEV-34716 fix of socket length in mysql.servers
• (MDEV-35110) Fix deadlock on oeplica during BACKUP STAGE BLOCK_COMMIT on XA transactions
• (MDEV-35109) Fix semi-sync replication stall on primary using wait point=AFTER_SYNC
• (MDEV-35422) Fix possible crash after SELECT DISTINCT
• (MDEV-26266) Assertion `state() == s_preparing || (is_xa() && state() == s_replaying) || (ret && (state() == s_must_abort || state() == s_must_replay || state() == s_cert_failed || state() == s_aborted))' failed
• (MDEV-32411) Item_sum arguments incorrectly reset to temp table fields which causes crash
• (MDEV-35508) Race condition between purge and secondary index INSERT or UPDATE
• (MDEV-26516) In some rare situations, a failure occurs with the diagnostic 'WSREP: record locking is disabled in this thread, but the table being modified is not mysql/wsrep_streaming_log: mysql/innodb_table_stats.'
• (MDEV-35648) Update lc2 tests
• (MDEV-35604) SIGSEGV in filter_query_type | log_statement_ex / auditing
• (MDEV-33472) Assertion `0' failed in Item_row::illegal_method_call on CREATE EVENT
• (MDEV-29462) ASAN: heap-use-after-free in Binary_string::copy on DO CONVERT
• (MDEV-29184) Assertion `0' in Item_row::illegal_method_call, Type_handler_row::Item_update_null_value, Item::update_null_value
• (MDEV-23895) Server crash, ASAN heap-buffer-overflow or Valgrind Invalid write in Item_func_rpad::val_str
• (MDEV-35393) ASAN unknown-crash in Field_varstring::reset when inserting NULL value to a table with filename charset
• (MDEV-28686) Assertion `0' in Type_handler_string_result::make_sort_key or unexpected result
• (MDEV-20944) Wrong result of LEAST() and ASAN heap-use-after-free in my_strnncollsp_simple / Item::temporal_precision on TIME()
• (MDEV-24337) Server crash in DTCollation::set_repertoire_from_charset
• (MDEV-25593) Assertion `0' failed in Type_handler_temporal_result::Item_get_date on double EXECUTE
• (MDEV-35273) thread_pool_generic::m_thread_data_cache alignment violation
• (MDEV-32755) Stack-Buffer-Overflow at /mariadb-11.3.0/strings/int2str.c:122 @ralf, this issue is not for release notes. It shows up in debug builds only. No any negative effect in release builds.
• (MDEV-21589) AddressSanitizer: memcpy-param-overlap in Static_binary_string::q_append or String::append
• (MDEV-25174) DOUBLE columns now accept large hex hybrids when previously these failed in some cases
• (MDEV-23687) Assertion `is_valid_value_slow()' failed in Datetime::Datetime upon EXTRACT under mode ZERO_DATE_TIME_CAST
• (MDEV-35416) CONV(1<<63, 10, -2) fails with --view-protocol
• (MDEV-31910) ASAN memcpy-param-overlap upon CONCAT in ORACLE mode
• (MDEV-31881) Fix crash in SELECT ... FROM ... PROCEDURE ANALYSE()
• (MDEV-33942) View cuts off the end of string with the utf8 character set in INSERT function
• (MDEV-29552) FIx issue where LEFT and RIGHT with large value for parameter 'len' >0 returned empty value in view
• (MDEV-28652) SUBSTRING(str,pos,len) returns incorrect result in view (returns an empty string)
• (MDEV-28001) greatest/least with bigint unsigned maxium has unexpected results compared to 0
• (MDEV-21029) Incorrect result for expression with the <=> operator and IS NULL
• (MDEV-23138) Odd behavior of character_set variables set to utf16 (when allowed)
• (MDEV-34348) MariaDB is violating clang-16 -Wcast-function-type-strict
• (MDEV-24959) ER_BINLOG_ROW_LOGGING_FAILED (1534: Writing one row to the row-based binary log failed)
• (MDEV-5798) Unexpected change in error code on INSERT .. PARTITION causes replication abort
• (MDEV-35525) Index corruption when using innodb_change_buffering; incorrect results in reverse index scans
• (MDEV-35413) InnoDB: Cannot load compressed BLOB (ROW_FORMAT=COMPRESSED table)
• (MDEV-35115) Inconsistent REPLACE behaviors
• (MDEV-33075) Sending TERM to mariadb no longer gracefully terminates the process
• (MDEV-35619) Assertion failure in row_purge_del_mark_error
• (MDEV-31219) Assertion fixed failed in Item_func_hybrid_field_type / Frame_positional_cursor
• (MDEV-30263) Assertion failure in Protocol::end_statement upon HANDLER READ with invalid timestamp
• (MDEV-35641) foreign server "disappears" after ALTERing the servers system table to use innodb and FLUSH PRIVILEGES
• (MDEV-35343) unexpected replace behaviour when long unique index on system versioned table
• (MDEV-35828) Assertion fails in alloc_root() after max_session_mem_used is hit
• (MDEV-16698) ASAN: heap-use-after-free in field_longstr::uncompress
• (MDEV-34049) InnoDB: Failing assertion: table->get_ref_count() == 0 in dict_sys_t::remove on DROP
• (MDEV-35407) Suppress STDERR while determining rpm package vendor and version in %prein scriptlet
• (MDEV-34534) main.plugin_load - AddressSanitizer: Joining already joined thread, aborting.
• (MDEV-35088) main.timezone started failing in Debian on MEST vs CET time zone difference
• (MDEV-34408) Facilitate the addition of warnings into the build system
• (MDEV-34847) Unquoted argument in logger call leads to invalid argument warnings
• (MDEV-35421) main.mysql_upgrade fails without unix_socket plugin
• (MDEV-35536) UBSAN: runtime error: call to function end_simple_key_cache through pointer to incorrect function type
• (MDEV-35534) UBSAN: runtime error: call to function thd_decrement_pending_ops through pointer to incorrect function type
• (MDEV-35533) UBSAN: runtime error: call to function sort_keys(st_key*, st_key*) through pointer to incorrect function type
• (MDEV-35532) UBSAN: runtime error: call to function FT_STOPWORD_cmp through pointer to incorrect function
• (MDEV-35530) UBSAN: runtime error: call to function get_sys_var_length on server startup or version query
• (MDEV-35531) UBSAN: runtime error: call to function init_simple_key_cache through pointer to incorrect function type
• (MDEV-34669) ER_NEED_REPREPARE on SELECT DEFAULT(name) FROM table1_containing_sequence
• (MDEV-22964) main.mysqlbinlog_row_compressed fails with wrong result
• (MDEV-35695) mtr failure suggest reading documentation at http://dev.mysql.com
• (MDEV-35735) runtime error: call to function spider_direct_sql, spider_flush_table_mon_cache, spider_copy_tables through pointer to incorrect function type in udf_handler::val_in
• (MDEV-33158) The macro MYSQL_THDVAR_ULONG leads to undefined behaviour, calling mysql_sys_var_long
• (MDEV-35687) Various UBSAN function-type-mismatch errors when using MTR in maria_open, mi_open, _ma_open_datafile, mi_open_datafile and thr_multi_lock
• (MDEV-35554) runtime error: call to function show_cached_thread_count()/show_binlog_space_total() through pointer to incorrect function type
• (MDEV-35838) libressl support differences in CRYPTO_set_mem_functions
• (MDEV-32686) crash information to include Distro information
• (MDEV-35344) Galera test failure on galera_sync_wait_upto
• (MDEV-28378) galera.galera_as_slave_ctas test fails with a timeout due to a possible issue with the server state - actually fixed by MDEV-32633
• (MDEV-35471) Failures in the galera_pc_recovery mtr test in configurations where innodb engine is not enabled by default
• (MDEV-35467) Extra warnings about failures in read_completion_condition() and read_handler() functions during execution of the galera_wan test
• (MDEV-35440) A flaw in the galera_wsrep_schema_detached test resulted in unnecessary protocol error warnings
• (MDEV-35481) A flaw in the galera_var_ignore_apply_errors test resulted in an incorrect error code ER_LOCK_DEADLOCK instead of ER_NO_SUCH_TABLE
• (MDEV-35486) In some (rare) situations, statements (e.g. DROP TABLE) could fail with a spurious timeout message in RSU mode due to an incorrect variable assignment in the server code that changed the timeout value used during statement execution.
• (MDEV-35355) A galera cluster node could crash or behave incorrectly in rate situations due to improper use of mutexes in situations where transactions are rolled back.
• (MDEV-32779) Fixed a bug in the galera_concurrent_ctas test, but the work remains in another task (MDEV-34891)
• (MDEV-35473) Periodic freezes of the galera_3nodes.galera_evs_suspect_timeout test due to flaws in the test itself
• (MDEV-35345) Test failure on MW-402 due to a flaw in the test itself
• (MDEV-35045) Fixed galera library compilation errors on some platforms (Fedora 41 and may be other)
• (MDEV-32329) When exectuting a query using ORDER BY on SELECT ... HAVING, the server can crash
• (MDEV-34770) UBSAN: runtime error: load of address 0x... with insufficient space for an object of type 'uchar' in sys_vars.inl
• (MDEV-31030) Assertion `!error' failed in ha_partition::update_row on UPDATE
• (MDEV-35489) Assertion `!ldate->neg' or unexpected result upon extracting unit from invalid value
• (MDEV-34700) Connect SQLite3 MTR test fails due to various charset/collation related output changes
• (MDEV-35477) rpl_semi_sync_no_missed_ack_after_add_slave fails after MDEV-35109
• (MDEV-35583) explicitly initialize THR_KEY_mysys calling MY_INIT and my_end
• (MDEV-35587) unit.innodb_sync leaks memory on mac
• (MDEV-35514) Too much mtr output from analyze: sync_with_master
• (MDEV-35501) innodb.log_file_name fails with "Could not measure size of ..."
• (MDEV-35618) Bogus assertion failure 'recv_sys.scanned_lsn < max_lsn + 32 * 512U' during recovery
• (MDEV-35494) fil_space_t::fil_space_t() is potentially unsafe with GCC -flifetime-dse
• (MDEV-35535) UBSAN: runtime error: call to function free_user_var through pointer to incorrect function type
• (MDEV-35457) Remove btr_cur_t::path_arr
• (MDEV-31366) Assertion `thd->start_time' failed in bool LOGGER::slow_log_print(THD*, const char*, size_t, ulonglong)
• (MDEV-35181) Assertion 'state < buf_page_t::READ_FIX' in buf_page_create_low()
• (MDEV-35626) Race condition between buf_page_create_low() and read completion
• (MDEV-34820) wsrep_sst_mariabackup SST script could incorrectly calculate the actual file size on ZFS under FreeBSD, which could lead to progress reporting errors
• (MDEV-35578) innodb_gis.rtree_debug fails on mac
• (MDEV-35660) Internal failure in wsrep-recover test which was observed during work on MDEV-24035
• (MDEV-35657) MSAN errors in os_file_readdir_next_file (xtrabackup)
• (MDEV-35680) Table number > MAX_TABLES causes overflow of table_map at main.join test
• (MDEV-29533) Crash when MariaDB is replica of MySQL 8.0
• (MDEV-35607) Compile error with gcc-15 (signal returns)
• (MDEV-35663) Sporadic connection failures during FLUSH PRIVILEGES
• (MDEV-34733) main.mysqld--help-aria test failure: feedback plugin: failed to retrieve the MAC address
• (MDEV-35704) Error message mispelled when altering table engine to MEMORY
• (MDEV-35239) Mariabackup incorrectly thinks we are on a multithreaded slave if slave_parallel_workers > 0
• (MDEV-35659) Internal failure in wsrep-recover test which was observed during work on MDEV-24035
• (MDEV-35438) Annotate InnoDB I/O functions with noexcept
• (MDEV-35384) Table performance_schema.session_status and other two tables are not shown in information_schema.tables for normal users
• (MDEV-35550) main.log_slow test failure: expects count(*) 5 got 4
• (MDEV-32919) Cannot select particular field from IS.tables in case table needs upgrade from MySQL 5.7
• (MDEV-35598) foreign key error is unnecessary truncated
• (MDEV-35808) Test case to handle undo tablespace truncation in Mariabackup
• (MDEV-35701) trx_t::autoinc_locks causes unnecessary dynamic memory allocation
• (MDEV-35840) gcc 12/13: -Warray-bounds when dereferencing value returned from TABLE_SHARE::db_type()
• (MDEV-35632) HandlerSocket uses deprecated C++98 auto_ptr
• (MDEV-35723) UBSAN: applying non-zero offset to null pointer in my_charpos_mb/my_uca_scanner_next_utf8mb4, applying zero offset to null pointer in my_strnncollsp_simple, my_uca_strnncollsp_onelevel_utf8mb4/my_uca_scanner_init_any/my_uca_scanner_next_utf8mb4 on INSERT
• (MDEV-35708) lock_rec_get_prev() returns only the first record lock
• (MDEV-35891) mtr - Backport workaround for perl bug https://github.com/Perl/perl5/issues/17570 from MySQL
• (MDEV-32822) Crash signal 11 in spider_sys_open_table from spider_internal_xa_rollback_by_xid during recovery after crash
• (MDEV-34302) Crash with RocksDB
• (MDEV-33285) Assertion `m_table' failed in ha_perfschema::rnd_end on CHECKSUM TABLE
• (MDEV-35938) rpl.rpl_parallel_gco_wait_kill fails - "Can't initialize replace ..."
• (MDEV-32780) Crash while running galera_as_slave_replay test (previously was a consequence of real bugs, but they have already been fixed in the latest versions of the server)
• (MDEV-35806) Error in read_log_event() corrupts relay log writer, crashes server
• (MDEV-35911) Assertion `marked_for_write_or_computed()' failed in bool Field_new_decimal::store_value(const my_decimal*, int*)
• (MDEV-35954) mysql_file.h cast warnings
• (MENT-2213) Test failure on MENT-1733
• (MDEV-35804) galera_ddl_fk_conflict test failed due to timeout
• (MDEV-34218) Mariadb Galera cluster fails when replicating from Mysql 5.7 on use of DDL
• (MDEV-33978) P_S.THREADS is not showing all server threads
• (MDEV-35966) galera.galera_as_master crashes in debug builds
• (MDEV-32175) page_align() or page_offset() may cost some performance
• (MDEV-35247) ut_fold_ull() and ut_hash_ulint() are a waste
• (MDEV-35190) HASH_SEARCH() is duplicating effort before HASH_INSERT() or HASH_DELETE()
• (MDEV-35189) Updating cache for INFORMATION_SCHEMA.INNODB_LOCKS et al is suboptimal
• (MDEV-35827) The generic MY_RELAX_CPU is expensive
• (MDEV-35394) New parameter --skip-freed-pages for Innochecksum. Use this parameter to not get freed undo logs reported as existing undo log pages.
• (MDEV-35505) Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+
• (MDEV-35643) MariaDB now supports MySQL 8.0 binlog events, including PARTIAL_UPDATE_ROWS_EVENT, TRANSACTION_PAYLOAD_EVENT, and HEARTBEAT_LOG_EVENT_V2.
• (MDEV-35526) Fix possible crash in wsrep_sst_mariabackup script when upgrading node in cluster from 10.11.9 to 10.11.10.
• (MDEV-35910) Conditions with SP local variables are now pushed into derived table. Previous behaviour caused slow performance and table scans instead of using the pushed down condition
• (MDEV-34665) NULL-aware materialization with IN predicate and single column no longer skips building sorted Ordered_key structures
• (MDEV-35363) Cloning of table statistics while saving the InnoDB table stats is now avoided