Changelog for MariaDB Enterprise Server 10.5.28-22

Changes

• (MENT-2228) cherry-pick the fix for MDEV-36138
• (MDEV-27691) make working view-protocol
• (MDEV-35789) Q1 2025 release merge
• (MDEV-35429) my_snprintf fixes for 10.5+
• (MDEV-35574) remove pthread_exit calls that caused msan/libc++ clang19 problems
• (MDEV-35350) Consolidate MTR wait_for_pattern_in_file.inc and SEARCH_WAIT in search_pattern_in_file.inc
• (MDEV-35682) Create MTR to catch changes to the GCS Protocol Version
• (MDEV-22441) implement a generic way to change a value of a variable in a scope
• (MDEV-28526) Spider: remove conn_kind member variables
• (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

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-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-35465) Fix sporadic failure of async replication on Galera async replica nodes with parallel replication enabled
• (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-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-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-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-35651) sql_mode='NO_UNSIGNED_SUBTRACTION' now works for multiple unsigned integers
• (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-2204) For a SPIDER engine based table a SELECT from the spider table and INSERT into a local table fails with 'Out of Range Value for Column XX_YY' Causes ERROR 1264 (22003)
• (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-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-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-35470) Internal temporary Aria tables writes blocks to disk at end of query
• (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-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-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-31881) Fix crash in SELECT ... FROM ... PROCEDURE ANALYSE()
• (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-32667) dict_stats_save_index_stat() reads uninitialized index->stats_error_printed
• (MDEV-35115) Inconsistent REPLACE behaviors
• (MDEV-33075) Sending TERM to mariadb no longer gracefully terminates the process
• (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-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-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-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-35583) explicitly initialize THR_KEY_mysys calling MY_INIT and my_end
• (MDEV-35514) Too much mtr output from analyze: sync_with_master
• (MDEV-31366) Assertion `thd->start_time' failed in bool LOGGER::slow_log_print(THD*, const char*, size_t, ulonglong)
• (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-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-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-35808) Test case to handle undo tablespace truncation in Mariabackup
• (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-35891) mtr - Backport workaround for perl bug https://github.com/Perl/perl5/issues/17570 from MySQL
• (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-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
• (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-35505) Galera protocol versions are now shown by show status - change available with installation of galera library 26.4.21+
• (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-35443) During an online table rebuild of an InnoDB statistics table, opt_search_plan_for_table() no longer sometimes degrades to full table scan