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

Last updated 1 month ago

Was this helpful?