Changelog for MariaDB Enterprise Server 10.6.18-14

MariaDB Enterprise Server 10.6.18-14 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.18-14 was released on 2024-06-11.

Issues Fixed

• (MDEV-33549) Incorrect handling of UPDATE in PS mode in case a table's column declared as NOT NULL

• (MDEV-25370) Update for portion changes autoincrement key in period table

• (MDEV-33475) --gtid-ignore-duplicate can double-apply event in case of parallel replication retry

• (MDEV-33334) mariadb-backup fails to preserve innodb_encrypt_tables

• (MDEV-34042) Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure

• (MDEV-34088) The TIMESTAMP value of '1970-01-01 00:00:00' can be indirectly inserted in strict mode

• (MDEV-18590) galera.versioning_trx_id: Test failure: mysqltest: Result content mismatch

• (MDEV-30046) wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption

• (MDEV-31251) MDEV-30968 breaks running mariabackup on older mariadb (opendir(NULL))

• (MDEV-33332) SIGSEGV in buf_read_ahead_linear() when bpage is in buf_pool.watch

• (MDEV-33383) fts query crashes in fts_query_calculate_ranking()

• (MDEV-32899) InnoDB is holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL

• (MDEV-33613) InnoDB may still hang when temporarily running out of buffer pool

• (MDEV-33770) Alter operation hangs when encryption thread works on the same tablespace

• (MDEV-21102) Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables

• (MDEV-33731) Server crashes when deleting partitions from a table with spider engine

• (MDEV-33813) ERROR 1021 (HY000): Disk full (./org/test1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

• (MDEV-31779) Server crash in Rows_log_event::update_sequence upon replaying binary log

• (MDEV-33540) mariabackup --prepare: [ERROR] InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size

• (MDEV-33278) Assertion failure in thd_get_thread_id at lock_wait_wsrep

• (MDEV-33509) Failed to apply write set with flags = (rollback | pa_unsafe)

• (MDEV-32787) Assertion
  !wsrep_has_changes(thd) || (thd->lex->sql_command == SQLCOM_CREATE_TABLE && !thd->is_current_stmt_binlog_format_row()) || thd->wsrep_cs().transaction().state() == wsrep::transaction::s_aborted failed in void wsrep_commit_empty(THD*, bool)

• (MDEV-33136) GCF-1060 test hangs when BF-abort logic mistreats transactions with explicit MDL locks

• (MDEV-33495) Graceful node shutdown can crash Garbd and Cluster can go non-Primary when SSL is used

• (MDEV-31361) Wrong result on 2nd execution of PS for query with derived table

• (MDEV-30655) IMPORT TABLESPACE fails with column count or index count mismatch

• (MDEV-30975) Wrong result with cross Join given join order

• (MDEV-33318) ORDER BY COLLATE improperly applied to non-character columns

• (MDEV-26643) Inconsistent behaviors of UPDATE under RU & RC isolation level

• (MDEV-26642) Weird SELECT view when a record is modified to the same value by two transactions

• (MENT-958) Spider/ODBC passed double quotes for names, in ANSI style

• (MDEV-32975) Default charset doesn't work with PHP MySQLi extension

• (MDEV-33772) Bad SEPARATOR value in GROUP_CONCAT on character set conversion

• (MDEV-33679) spider returns parsing failure on valid left join select by translating the on expression to ()

• (MDEV-33889) Read only server throws error when running a create temporary table as select statement

• (MDEV-32898) Phantom rows caused by UPDATE of PRIMARY KEY

• (MDEV-33727) mariadb-dump trusts the server and does not validate the data

• (MDEV-29345) update case insensitive (large) unique key with insensitive change of value - duplicate key

• (MDEV-9179) When binlog_annotate_row_events on , event of binlog file is truncated

• (MDEV-23878) Wrong result with semi-join and splittable derived table

• (MDEV-33828) Transactional commit not supported by involved engine(s)

• (MDEV-31277) Wrong result on 2-nd execution of PS to select from view using derived

• (MDEV-33506) Original IP not shown in network related error messages when proxy_protocol is in use

• (MDEV-33790) Incorrect DEFAULT expression evaluated in UPDATE

• (MDEV-28621) group by optimization incorrectly removing subquery where subject buried in a function

• (MENT-2084) cherry-pick MDEV-34203 fix

• (MDEV-27512) Assertion ! thd->transaction_rollback_request failed in rows_event_stmt_cleanup

• (MDEV-33397) Innodb include OS error information when failing to write to iblogfile0

• (MDEV-24507) Server Crash using UDF in WHERE clause of VIEW

• (MDEV-32935) Parameter 'CMAKE_SYSTEM_PROCESSOR=$(DEB_HOST_ARCH)' is not needed anymore to crosscompile Debian packages

• (MDEV-33301) memlock with systemd still not working even with MDEV-9095 fix

• (MDEV-33636) CentOS 7 MariaDB 10.5 build jobs failing "Invalid capability: cap "%caps(cap_ipc_lock=pe"

• (MDEV-33631) Ubuntu/Debian MYSQL_SERVER_SUFFIX is version+suffix on MariaDB packaged versions

• (MENT-1910) galera_sr.GCF-585 fails

• (MENT-1947) Audit plugin crash in load_filters()

• (MDEV-33400) Adaptive hash index corruption after ALTER TABLE…DISCARD TABLESPACE

• (MDEV-30528) Assertion !mbmaxlen || !(prefix_len % mbmaxlen) failed in dtype_get_at_most_n_mbchars

• (MDEV-33462) Server aborts while altering an InnoDB statistics table

• (MDEV-32346) InnoDB: Failing assertion: sym_node->table != NULL in pars_retrieve_table_def on UPDATE

• (MDEV-33218) Assertion
  active_arena->is_stmt_prepare_or_first_stmt_execute() || active_arena->state == Query_arena::STMT_SP_QUERY_ARGUMENTS failed. in st_select_lex::fix_prepare_information

• (MDEV-33230) LeakSanitizer errors in rec_copy_prefix_to_buf

• (MDEV-25923) Memory not freed or Assertion old_flags == ((my_flags & 0x10000U) ? 1 : 0) failed in my_realloc upon ALTER on Aria table with GIS column

• (MDEV-31154) Fatal InnoDB error or assertion !is_v failure upon multi-update with indexed virtual column

• (MDEV-33558) Fatal error InnoDB: Clustered record field for column x not found

• (MDEV-33795) MariaDB segfault on rowid filter query involving generated column

• (MDEV-33325) Crash in flst_read_addr on corrupted data

• (MDEV-33512) Discard/Import Tablespace, Restart, Index Corruption

• (MDEV-33799) mysql_manager_submit Segfault at Startup Still Possible During Recovery

• (MDEV-30260) Slave crashed:reload_acl_and_cache during shutdown

• (MDEV-19415) multi_source.MDEV-9544 , multi_source.info_logs failed in buildbot with AddressSanitizer: heap-use-after-free in strend / get_one_variable

• (MDEV-33993) Possible server hang on DROP INDEX or RENAME INDEX

• (MDEV-33669) mariabackup --backup hangs

• (MDEV-22855) Assertion !field->prefix_len || field->fixed_len == field->prefix_len failed in btr_node_ptr_max_size and in dict_index_node_ptr_max_size

• (MDEV-30727) SIGSEGV's in spider_direct_sql_init_body, spider_direct_sql_body, my_hash_insert, thd_ha_data, thd_get_ha_data, and safe_mutex_lock, heap-use-after-free in spider_direct_sql_body

• (MDEV-31161) Assertion failures upon adding a too long key to table with COMPRESSED row format

• (MDEV-32458) ASAN unknown-crash in Inet6::ascii_to_fbt when casting character string to inet6

• (MDEV-21058) CREATE TABLE with generated column and RLIKE results in sigabrt

• (MDEV-33538) Trying to lock uninitialized mutex at storage/spider/spd_i_s.cc after failure upon startup

• (MDEV-26499) galera_3nodes.galera_ipv6_mysqldump MTR failed: mysql_shutdown failed

• (MDEV-22063) Assertion 0 failed in wsrep::transaction::before_rollback

• (MDEV-25089) Assertion error.len > 0 failed in wsrep_status_t galera::ReplicatorSMM::handle_apply_error(galera::TrxHandleSlave&, const wsrep_buf_t&, const string&)

• (MDEV-25731) Assertion mode_ == m_local failed in void wsrep::client_state::streaming_params(wsrep::streaming_context::fragment_unit, size_t)

• (MDEV-33928) Assertion failure on wsrep_thd_is_aborting

• (MENT-2042) Assertion bf_aborted() failed in void wsrep::transaction::xa_replay_common(wsrep::unique_lock<wsrep::mutex>&)

• (MDEV-33769) Memory leak found in the test main.rownum run with --ps-protocol against a server built with the option -DWITH_PROTECT_STATEMENT_MEMROOT

• (MDEV-33546) Rpl_semi_sync_slave_status is ON When Replication Is Not Configured

• (MDEV-33011) mariabackup --backup: FATAL ERROR: ... Can't open datafile cool_down/t3

• (MDEV-18288) Transportable Tablespaces leave AUTO_INCREMENT in mismatched state, causing INSERT errors in newly imported tables when .cfg is not used.

• (MDEV-19044) Alter table corrupts while applying the modification log

• (MDEV-33434) UBSAN null pointer passed as argument 2, which is declared to never be null in spider_udf_direct_sql_create_conn

• (MDEV-33242) SPIDER plugin initialization failed at 'create table if not exists mysql.spider_tables ... with 'Specified key was too long; max key length is 1000 bytes', Warning: Memory not freed: 10720

• (MDEV-33494) spider plugin init failure with no_zero_date sql_mode

• (MDEV-33303) slave_parallel_mode=optimistic should not report the mode's specific temporary errors

• (MDEV-29565) Inconsistent read and write, which use the same predicate (WHERE clause)

• (MDEV-26671) Inconsistent SELECT View when modify a record added by another transaction

• (MDEV-32893) mariadb-backup is not considering O/S user when --user option is omitted

• (MDEV-33496) Out of range error in AVG(YEAR(datetime)) due to a wrong data type

• (MDEV-33584) sql plugin init failure with traditional sql_mode

• (MDEV-33819) The purge of committed history is mis-parsing some log

• (MDEV-33802) Weird read view after ROLLBACK of other transactions.

• (MDEV-32489) Change buffer index fails to delete the records

• (MDEV-33777) Spider: ERROR 12710 (HY000): Invalid information from remote table when using MariaDB 10.5 local and MariaDB 10.6 remote

• (MDEV-32454) JSON test has problem in view protocol

• (MENT-1555) Spider: Set proper remote isolation based on information obtained by SQLGetInfo

• (MDEV-33979) Disallow bulk insert operation during partition update statement

• (MDEV-34003) ASAN: heap-use-after-free in memcpy from sql/protocol.cc on SELECT

• (MDEV-33980) mariadb-backup --backup is missing retry logic for undo tablespaces

• (MDEV-21034) GREATEST() and LEAST() malfunction for NULL

• (MDEV-33534) UBSAN: Negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in my_double_round from sql/item_func.cc|

• (MDEV-34069) Zero datetime reinterprets as '1970-01-01 00:00:00' on field_datetime=field_timestamp

• (MDEV-34061) unix_timestamp(coalesce(timestamp_column)) returns NULL on '1970-01-01 00:00:00.000001'

• (MDEV-34118) fsp_alloc_free_extent() fails to flag DB_OUT_OF_FILE_SPACE

• (MDEV-33216) ASAN reports "stack use after return" in Wsrep_schema_impl::open_table

• (MDEV-33469) Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup

• (MDEV-31276) Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT

• (MDEV-33767) Memory leaks found in some tests run with --ps-protocol against a server built with the option -DWITH_PROTECT_STATEMENT_MEMROOT

• (MDEV-33768) Memory leak found in the test main.constraints run with --ps-protocol against a server built with the option -DWITH_PROTECT_STATEMENT_MEMROOT

• (MDEV-33861) main.query_cache fails with embedded after enabling WITH_PROTECT_STATEMENT_MEMROOT

• (MDEV-19487) JSON_TYPE doesn't detect the type of String Values (returns NULL) and for Date/DateTime returns "INTEGER"

• (MDEV-22141) JSON_REMOVE returns NULL on valid arguments.

• (MDEV-32287) JSON_EXTRACT not returning multiple values for same path

• (MDEV-34063) UBSAN: runtime error: signed integer overflow: 2148 * 1000000 cannot be represented in type 'int'

• (MDEV-33593) Auto increment deadlock error causes ASSERT in subsequent save point

• (MDEV-15703) Crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT, UBSAN runtime error: member call on null pointer of type 'struct TABLE_LIST' in Item_param::save_in_field

• (MDEV-33443) Unsafe use of LOCK_thd_kill in my_malloc_size_cb_func()

• (MDEV-33468) Sig11 due to stack overflow in Item_cond::remove_eq_conds

• (MDEV-28430) lf_alloc isn't safe on aarch64 (or ppc64le)

• (MDEV-33023) Crash in mariadb-backup --prepare --export after --prepare

• (MDEV-33622) Server crashes when the UPDATE statement (which has duplicate key) is run after setting a low thread_stack

• (MDEV-33623) Partitioning is broken on big endian architectures

• (MDEV-33393) audit plugin do not report user did the action

• (MDEV-33508) Performance regression due to frequent scan of full buf_pool.flush_list

• (MDEV-33582) Add more warnings to be able to better diagnose network issues

• (MDEV-33314) Crash inside calculate_cond_selectivity_for_table() with many columns

• (MDEV-33441) No spider variables available is Spider is loaded upon server startup

• (MDEV-33482) WolfSSL's math is unnecessarily slow

• (MDEV-33277) In-place migration from MySQL 5.7 causes invalid AUTO_INCREMENT values

• (MENT-2064) Backport MDEV-33420 to MariaDB Enterprise

• (MDEV-32791) MariaDB-client community can't be installed in red hat ubi9

• (MDEV-33488) Windows: Opt-out of Win11 automatic CPU throttling (LowQOS)

• (MDEV-33840) tpool - switch off maintenance timer when not needed

• (MDEV-33817) Implement AVX512BW and VPCLMULQDQ based CRC-32 algorithms

• (MDEV-33559) matched_rec::block should be allocated from the buffer pool

• (MDEV-33543) Server hang caused by InnoDB change buffer

• (MDEV-16944) Windows, mysqltest : The process echo.exe cannot access the file

• (MENT-2010) plugins.server_audit2 fails with ps2 protocol

• (MDEV-21864) Commands start-all-slaves and stop-all-slaves are not listed in mysqladmin help

• (MDEV-33591) MONITOR_INC_VALUE_CUMULATIVE is executed regardless of "if" condition

• (MDEV-33439) Clang won't compile MariaDB with libxml2 2.12

• (MDEV-28419) subsequent runs of debian/autobake-deb.sh are not idempotent

• (MDEV-4827) [PATCH] mysqldump --dump-slave=2 --master-data=2 doesn't record both

• (MDEV-32635) galera_shutdown_nonprim: mysql_shutdown failed

• (MDEV-33036) Galera test case galera_3nodes.galera_ist_gcache_rollover has warning

• (MDEV-33138) Galera test case MW-336 unstable

• (MDEV-33173) Galera test case galera_sr_kill_slave_before_apply unstable

• (MDEV-33172) Galera test case galera_mdl_race unstable

• (MDEV-33723) mroonga ignores WITHOUT_DYNAMIC_PLUGINS

• (MDEV-33039) Galera test failure on mysql-wsrep-features#165

• (MDEV-33044) Loading time zones does not work with alter_algorithm INPLACE

• (MDEV-33803) Error 4162 "Operator does not exists" is incorrectly-worded

• (MDEV-33895) Galera test failure on galera_sr.MDEV-25718

• (MDEV-33896) Galera test failure on galera_3nodes.MDEV-29171

• (MDEV-33876) CMake : use documented variable ZLIB_LIBRARIES, rather than ZLIB_LIBRARY

• (MDEV-34071) Failure during the galera_3nodes_sr.GCF-336 test

• (MDEV-33898) Galera test failure on galera.MW-369

• (MDEV-29955) MariaDB does not make full use of pkgconfig

• (MDEV-34077) scripts/mariadb-install-db: Error in my_thread_global_end(): 1 threads didn't exit

• (MDEV-25102) UNIQUE USING HASH error after ALTER ... DISABLE KEYS

• (MDEV-34055) Assertion readbytes != (size_t)-1 || (*errno_location ()) != 9 failure or corruption errors upon REPAIR on Aria tables

• (MDEV-34098) source start_slave.inc in spider suites

• (MDEV-33788) HEX(COLUMN_CREATE(.. AS CHAR ...)) fails with --view-protocol

• (MDEV-29149) Assertion
  !is_valid_datetime() || fraction_remainder(((item->decimals) < (6) ? (item->decimals) : (6))) == 0 failed in Datetime_truncation_not_needed::Datetime_truncation_not_needed

• (MDEV-28366) GLOBAL debug_dbug setting affected by collation_connection=utf16…

• (MDEV-33460) select '123' 'x'; unexpected result

• (MDEV-33706) backport some spider fixes to 10.4 which was unlocked

• (MDEV-33742) do not create spider group by handler when all tables are constant

• (MDEV-33855) MSAN use-of-uninitialized-value in rtr_pcur_getnext_from_path()

• (MDEV-20157) perfschema.stage_mdl_function failed in buildbot with wrong result

• (MDEV-33974) Enable GNU libstdc++ debugging

• (MDEV-30676) rpl.parallel_backup* tests sometimes fail with Result length mismatch

• (MDEV-30232) rpl.rpl_gtid_crash fails sporadically in BB with Timeout wait for SQL thread to catch up with IO thread

• (MDEV-33672) Gtid_log_event Construction from File Should Ensure Event Length When Using Extra Flags

• (MDEV-10684) rpl.rpl_domain_id_filter_restart fails in buildbot

• (MDEV-22949) perfschema.memory_aggregate_no_a_no_u fails sporadically in buildbot with wrong result

• (MDEV-25252) main.type_float fails in new buildbot

• (MDEV-31379) Undefined behavior in the reference Ed25519 implementation

• (MDEV-33728) remove use of MYSQL_VERSION_ID and MARIADB_BASE_VERSION in spider

• (MDEV-21007) Assertion auto_increment_value failed in ha_partition::info upon UPDATE with partition pruning

• (MDEV-33867) main.query_cache_debug fails with heap-use-after-free

• (MDEV-33661) LeakSanitizer: detected memory leaks on spider/odbc/pg suite

• (MDEV-33344) REGEXP empty string inconsistent

• (MDEV-33220) Fix g++-13 -Wmaybe-uninitialized warnings

• (MDEV-33747) Optimization of (SELECT) IN (SELECT ...) executes subquery at prepare stage

• (MDEV-33342) Add a replication MTR test cloning the slave with mariadb-backup

• (MDEV-33355) Add a Galera-2-node-to-MariaDB replication MTR test cloning the slave with mariadb-backup

• (MDEV-33313) Incorrect error message for "ALTER TABLE ... DROP CONSTRAINT ..., DROP col, DROP col"

• (MDEV-10793) main.kill_processlist-6619 fails sporadically in buildbot with wrong result

• (MDEV-33292) main.kill_processlist-6619 occasionally fails due to different SHOW PROCESSLIST output

• (MDEV-24622) Replication does not support bulk insert into empty table

• (MDEV-33478) Tests massively fail with clang-18 -fsanitize=memory

• (MDEV-33716) rpl.rpl_semi_sync_slave_enabled_consistent Fails with Error Condition Reached

• (MDEV-33665) main.pool_of_threads fails due to (spurious) uninitialized Item_func::not_null_tables_cache

• (MDEV-29369) rpl.rpl_semi_sync_shutdown_await_ack fails regularly with Result content mismatch

• (MDEV-14357) rpl.rpl_domain_id_filter_io_crash failed in buildbot with wrong result

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

• (MDEV-33274) The test encryption.innodb-redo-nokeys often fails

• (MDEV-33464) Crash when innodb_max_undo_log_size is set to innodb_page_size*4294967296

• (MDEV-33209) Stack overflow in main.json_debug_nonembedded due to incorrect debug injection

• (MDEV-18985) Remove support for XtraDB's changed page bitmap from Mariabackup in 10.2+

• (MDEV-33251) Redundant check on prebuilt::n_rows_fetched overflow

• (MDEV-33341) innodb.undo_space_dblwr test case fails with Unknown Storage Engine InnoDB

• (MDEV-14193) innodb.log_file_name failed in buildbot with exception

• (MDEV-13765) encryption.encrypt_and_grep failed in buildbot with wrong result (sporadic)

• (MDEV-33635) innodb.innodb-64k-crash - Found warnings/errors in server log file

• (MDEV-32926) mysql_install_db_win fails on Buildbot

• (MDEV-28993) Spider: Push down CASE statement

• (MDEV-33493) mariadb-*.tar.gz contains symbolic links and cannot be extracted in Windows

• (MDEV-33779) InnoDB row operations could be faster

• (MDEV-20094) InnoDB blob allocation allocates extra extents

• (MDEV-33757) Get rid of TrxUndoRsegs code

• (MDEV-28992) Spider: Push down TIMESTAMPDIFF function

• (MDEV-33588) buf::Block_hint is a performance hog

• (MDEV-33542) Avoid extending of tablespace frequently

• (MDEV-21778) Disable system commands in mysql/mariadb client

• (MDEV-33620) Improve times and states in show processlist for replication

• (MDEV-26923) MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params

• (MDEV-33726) Moving from MariaDB 10.5 to 10.6 mysql_upgrade is not updating some system tables

• (MDEV-32445) InnoDB may corrupt its log before upgrading it on startup

• (MDEV-33668) Adapt parallel slave's round-robin scheduling to XA events

• (MDEV-33454) release row locks for non-modified rows at XA PREPARE

• (MDEV-33502) Slowdown when running nested statement with many partitions

• (MDEV-33306) Optimizer choosing incorrect index in 10.6, 10.5 but not in 10.4

• (MDEV-33214) Table is getting rebuild with ALTER TABLE ADD COLUMN

• (MDEV-33551) Semi-sync Wait Point AFTER_COMMIT Slow on Workloads with Heavy Concurrency

• (MDEV-30660) Aggregation functions fail to leverage uniqueness property