Changelog for MariaDB Enterprise Server 11.8.5-2

MariaDB Enterprise Server 11.8.5-2 is a Stable (GA) maintenance release of MariaDB Enterprise Server 11.8, released on

Download Release Notes Changelog Overview of Enterprise Server 11.8

Release date:

Changes

• Change several Plugin Maturity Levels (MDEV-37858)

• Hashicorp Plugin: enable key version caching by default (MDEV-30849)

• Backport MDEV-9804 "Implement a caching_sha2_password plugin" to MariaDB Community Server 11.4/11.8 (MDEV-37600)

• Introduce @@new_mode variable (MDEV-37784)

• UCA: Change "skip equal simple prefix" to "compare simple prefix" (MDEV-37849)

• Two new fields are available via SHOW REPLICA STATUS:

  • Connects_Tried, which provides the number of attempts the replica has made to connect to the primary, and

  • Master_Retry_Count, which provides the number of times the replica will attempt to connect to a primary before giving up. (MENT-2129)

• Remove some markers that variable is not going to be used uninitalized in clang (MDEV-36542)

Issues Fixed

• InnoDB could potentially crash if there is any lock conflict on an internal FTS_%_CONFIG table of a FULLTEXT INDEX while one of the INFORMATION_SCHEMA views INNODB_TRX, INNODB_LOCKS, or INNODB_LOCK_WAITS are being accessed. (MDEV-36545)

• Query does not recognize advantage of using primary key index (MDEV-36761)

• Remove the error codes added to 10.11 by the MDEV-36032 patch (MDEV-36856)

• Inconsistency detected - create sequence (MDEV-37366)

• InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON (MDEV-37404)

• InnoDB could crash during the crash recovery of a corrupted database. (MDEV-37412)

• client packages depend on liburing and libaio (MDEV-37463)

• An overly aggressive debug assertion was relaxed. (MDEV-37553)

• MariaDB auth protocol differs from MySQL (MDEV-37554)

• Galera-26.4.24 fails buid package due to galera_check timeout on some s390x platforms (MDEV-37691)

• ASAN errors in find_type2 upon executing a procedure from sys schema (MDEV-37710)

• upgrade from MySQL 5.7 regression, mysql.servers invalid structure (MDEV-37777)

• Assertion `buf < end' failed in mtr_t::encrypt() (MDEV-37782)

• Assertion `!waiting' failed in TP_connection_generic::wait_begin (MDEV-37860)

• mysql-test/mtr --cursor main.func_json fails (MDEV-37864)

• disable_index_merge_plans causes SELECT data loss when more than 100 ORs (MDEV-37913)

• Merge applicable changes from InnoDB 8.4.7 (MDEV-37922)

• very long query cannot be killed quickly (MDEV-37938)

• Item_func_hex doesn't check for max_allowed_packet (MDEV-37947)

• MDL conflict between XA and DDL in Galera cluster (MENT-2405)

• Cherry Pick MDEV-37541 - Race of rolling back and committing transaction to binlog (MENT-2448)

• For large transactions (i.e. those whose data exceeds the binlog_cache_size limit and spills into tmp files), provides a general performance improvement and fixes a bug that would lead to binlog corruption where the large transaction would have its GTID written into the binary log, without any additional transaction data, if the server's --tmp-dir was full. (MENT-2451)

• Cherry-pick MDEV-38212 into 11.4 and 11.8 ES releases (MENT-2481)

• The InnoDB purge subsystem will no longer reset transaction identifiers in freshly inserted records, because it did severely hurt performance in some workloads. (MDEV-16168)

• DDL in procedure propagates no locking to tables locked by DML (MDEV-16686)

• Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type == 1' failed upon REBUILD PARTITION (MDEV-20498)

• On Fedora, RHEL, and derivatives, depend on the mysql-selinux-1.0.14 package that provides the correct selinux rules for the /usr/sbin/mariadbd that is installed. (MDEV-24941)

• Crash when calling stored function in FOR loop argument (MDEV-26115)

• Spider: Assertion `inited==RND' failed in handler::ha_rnd_end on DELETE (MDEV-26540)

• Several bugs in SPATIAL INDEX page splitting logic could crash InnoDB if the PRIMARY KEY or the SPATIAL data is variable-length. (MDEV-27675)

• Corrected the creation of views on JSON_TABLEs to require no special privileges. (MDEV-27898)

• Hashicorp Plugin: Key rotation creates infinity request loop to vault (dos) (MDEV-29238)

• Setting wsrep_slave_threads causes thread hang (MDEV-30418)

• Tested on 10.6.24, the issue is not reproducible anymore. (MDEV-30456)

• InnoDB could crash if the definition of the InnoDB persistent statistics tables were incorrect. (MDEV-31740)

• SIGSEGV in maria_rtree_split_page | maria_rtree_add_key (MDEV-31766)

• Wrong result when split optimization is used for grouping with order by and limit (MDEV-31887)

• Correlated derived table query merges can cause crashes, especially with prepared statements. (MDEV-32294)

• Server crash on cleanup of non-fully-constructed-due-to-an-error CTE (MDEV-32308)

• JSON_ARRAY_INTERSECT function crashes the server when called with empty json arrays, UBSAN runtime error: member access within null pointer of type 'struct String' in Item_func_json_array_intersect::prepare_json_and_create_hash (MDEV-33149)

• Errors or assertion failure upon REPAIR on partitioned Aria table with misplaced rows (MDEV-33190)

• Assertion `0' failed in void wsrep::transaction::state(wsrep::unique_lockwsrep::mutex&, wsrep::transaction::state) (MDEV-33250)

• View containing JSON_TABLE does not return JSON (MDEV-34081)

• Assertion `! thd->in_sub_stmt' failed in bool trans_rollback_stmt(THD*) (MDEV-34117)

• server cannot load client plugins on Debian (MDEV-34744)

• Workloads that are bound by innodb_log_file_size would write out unnecessarily many data pages in an attempt to advance the log checkpoint. (MDEV-35155)

• [build issue] selected processor does not support `retaa' (MDEV-35566)

• Complete freeze during MW-329 test (MDEV-35951)

• Assertion `ist_seqno >= cc_seqno' failed in galera_vote_rejoin_dml (MDEV-35964)

• Mariadb server crashed during insert (MDEV-36134)

• Some lock elision code that was detrimental to performance was removed. (MDEV-36190)

• Wrong result json_table (MDEV-36319)

• Test failure on galera.mdev-22543 (MDEV-36528)

• MariaDB upgrade fails when using innodb_encrypt_tables=ON and innodb_checksum_algorithm=crc32, which is not the default. innodb_checksum_algorithm=crc32 is used only if explicitly specified or if the table has been created which MariaDB 10.4 or a prior version (MDEV-36556)

• Assertion `bulk_insert == TRX_NO_BULK' failed in trx_t::assert_freed from innodb_shutdown (MDEV-36771)

• json_array_intersect previously crashed when there was an unused table reference in the SQL query. (MDEV-36809)

• Galera tests fail if wsrep_provider_options is too long (> 2k) (MDEV-36843)

• Assertion `client_state.transaction().active()' failed in int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type) (MDEV-36909)

• Fix for unstable mtr test (MDEV-36949)

• innochecksum misinterprets doublewrite buffer pages (MDEV-37138)

• The performance of ANALYZE FORMAT=JSON as well as the counter innodb_buffer_pool_read_requests was improved. (MDEV-37152)

• Fixed crashing bug when inserting into a tables with several nextval(sequence) default values. (MDEV-37172)

• Crash recovery after bulk load data reports corruption (MDEV-37192)

• Fix spider view protocol failures for higher versions (MDEV-37204)

• When a page needs to be read into the InnoDB buffer pool, concurrent access to the page will avoid some hash table lookup and busy waiting. (MDEV-37244)

• ALTER TABLE allows adding unique hash key with duplicate values (MDEV-37296)

• When the server was started in read-only mode with encryption enabled, the fix ensures that InnoDB avoids creating any encryption thread. Testing: encryption.innodb-read-only(MTR Test) contains scenario that can be used to test this change. (MDEV-37299)

• Item_func_nextval::val_int() crash on INSERT...SELECT with subqueries (MDEV-37345)

• InnoDB partition table disallow local GTIDs in galera (MDEV-37373)

• The minimum value of the parameter innodb_ft_min_token_size was increased to 1, similar to the parameter ft_min_word_len. (MDEV-37423)

• Correct return value of JSON_VALUE which in the previous release, incorrectly converted a valid empty string return value to a NULL. This has been reverted to correct behaviour. (MDEV-37428)

• Wrong query_ids in server_audit plugin not reflecting reality (MDEV-37434)

• Parallel slave worker crashes During Backup at retrying (MDEV-37453)

• decimal_digits_t trips GCC -Wconversion (MDEV-37477)

• The performance of innodb_adaptive_hash_index=ON was improved further. We introduce the parameter innodb_adaptive_hash_index_cells that can be configured with SET GLOBAL. The specified value will be effectively multiplied by innodb_adaptive_hash_index_parts, because each partition will contain its own hash table. (MDEV-37482)

• mariadb-dump -T did not encode table names like the server did for frm files, so some tables can be created in the server, but not dumped with mariadb-dump -T, for example, a table con on Windows. (MDEV-37483)

• Fix crash by correctly updating SP instruction state after instruction re-parsing , preventing dangling reference. (MDEV-37489)

• Failure to detect corruption during backups of Aria table (MDEV-37520)

• Fix server_audit rwlock Performance Schema instrumentation (MDEV-37555)

• main.vector sporadic failures (MDEV-37559)

• trx_deadlock sporadic failure on MDEV-37141 test case (MDEV-37560)

• spider: inconsistent treatment of descending index between usual and group by handlers (MDEV-37568)

• Assertion failure sql_base.cc:3927: bool open_and_process_routine (MDEV-37581)

• The forced use of THD accessor functions hurts InnoDB performance (MDEV-37619)

• The parameter innodb_trx_rseg_n_slots_debug was removed. (MDEV-37672)

• Fedora MariaDB depends on mysql-selinux (MDEV-37680)

• Frequent timeouts of the test innodb.innodb_bug38231 (MDEV-37743)

• MDL conflict between CREATE TRIGGER and INSERT (MDEV-37965)

• Galera cluster crashes when granting permission to non existing user after setting max_error_count and wsrep_ignore_apply_errors to zero (MDEV-37991)

• Windows : WITH_ZLIB=bundled produces errors if hashicorp_key_management is compiled (MDEV-37997)

• Assertion `level != Sql_condition::WARN_LEVEL_ERROR' failed in void push_warning(THD*, Sql_state_errno_level::enum_warning_level, uint, const char*) (MDEV-38201)

• Most of server Audit v2 tests are disabled and never run (MENT-1223)

• Wrong hardcoded default for GIT_REMOTE_ORIGIN_URL in ES (MENT-2393)

• The locking in the audit plugin was simplified in order to remove some scalability bottlenecks. (MENT-2460)

• With --encrypt-binlog=ON if a node fails to apply a writeset it will crash the whole cluster due to a bug in Galera library encryption handling. Fixed in Galera library. Concerns only Enterprise Server as only it enables Galera encryption, all versions: 10.5, 10.6, 11.4, 11.8 (MENT-2474)

• A tmpfiles file will now create /run/mysqld path on Debian/Ubuntu packaged distributions. (MDEV-15502)

• REPLACE on a precise-versioned table returns duplicate key error (ER_DUP_ENTRY) (MDEV-15990)

• A misplaced debug assertion could fail due to a race condition. In MariaDB Server 11.8.1, this bug had already been fixed as part of MDEV-35049. (MDEV-20203)

• LIMIT ROWS EXAMINED prematurely triggers during optimization (MDEV-22241)

• SIGSEGV in replace_user_table when changing mysql db tables (MDEV-23731)

• SIGSEGV in replace_db_table on GRANT (MDEV-24206)

• Prevent MariaDB server crash when a query includes a derived table containing unnamed column. (MDEV-24588)

• SIGSEGV in replace_table_table on GRANT (MDEV-24814)

• InnoDB could crash after a DROP TABLE, TRUNCATE TABLE, OPTIMIZE TABLE or a table-rebuilding ALTER TABLE if innodb_adaptive_hash_index entries existed in the table. (MDEV-26599)

• SIGSEGV in replace_routine_table on GRANT (MDEV-27842)

• SIGSEGV in get_access_value_from_val_int (MDEV-28482)

• SIGSEGV in TABLE::use_all_columns, replace_roles_mapping_table (MDEV-28773)

• Crash when considering Split-Materialized plan (MDEV-29638)

• Assertion `strlen(Ptr) == str_length' failed in void Binary_string::chop() (MDEV-30691)

• Assertion `fixed()' failed in Item_cond_and::val_bool() with degenerate JTBM semi-join (MDEV-30721)

• wsrep_store_key_val_for_row() may invoke memcpy() on nullptr (MDEV-30732)

• Assertion `transaction.is_streaming()' failed in void wsrep::transaction::adopt(const wsrep::transaction&) (MDEV-30764)

• Wrong results for self-touching shapes. (MDEV-31499)

• Assertion `order_list->elements == 1' failed in Frame_range_n_bottom::Frame_range_n_bottom (MDEV-31744)

• Crash if subquery is a UNION of SELECT rand() and uncorrelated SELECT (MDEV-32403)

• UPDATE/DELETE of single table queries would now show r_table_time_ms, and r_other_time_ms during ANALYZE FORMAT=JSON (MDEV-33309)

• Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed after ALTER TABLE of versioned table (MDEV-33370)

• Exchange partition with virtual columns fails (MDEV-34033)

• Parameterized PS converts error to warning, causes replication problems (MDEV-34046)

• Assertion failure in online_alter_log_row or server hang upon replicating REPAIR on mysql.gtid_slave_pos (MDEV-34134)

• Recovery of Aria transactional tables did not work in big-endian machines like s390x and Sparc (MDEV-34914)

• Innodb did not handle case-sensitivity on Windows correctly prior to this fix in its data dictionary, converting all names to lowercase. This resulted in inconsistency, if data directory was in case-sensitive NTFS directory, as well as in situations when data directory was copied from Windows to Unix systems. This is fixed in this patch. (MDEV-34953)

• ALTER TABLE could fail to update InnoDB persistent statistics. (MDEV-35163)

• Assertion `nests_entered == cur_sj_inner_tables' failed in JOIN::dbug_verify_sj_inner_tables on SELECT (MDEV-35206)

• ASAN error in mariadb client with \c (MDEV-35224)

• SEGV, ASAN use-after-poison when reading system table with less than expected number of columns (MDEV-35622)

• UBSAN: runtime error: load of value 1341112147, which is not a valid value for type 'enum enum_schema_tables' in optimize_for_get_all_tables and get_all_tables and on SELECT from I_S geometry_columns (MDEV-35713)

• ASAN: use-after-poison in st_select_lex::print (MDEV-35816)

• Corrected python3 compatibility of myrocks_hotbackup thanks to contributor i18n.site (MDEV-36010)

• Explain format=json with a DML statement containing a derived table and some manner of execution abortion, a timeout or kill will lead to an assertion or crash. (MDEV-36034)

• Server may crash in spider bg mode if multiple queries are sent by spider bg threads consecutively (MDEV-36325)

• view-protocol: sys_vars.slave_parallel_threads_basic (MDEV-36385)

• only mtr test has been fixed (MDEV-36710)

• The PrivateDevices=false directive in the systemd service has been removed as it was an old kernel incompatibility that this directived worked around. With this, the MariaDB is restricted further. Those using InnoDB on raw devices will need to add an override for this. See https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/systemd#useful-systemd-options (MDEV-36721)

• ALTER TABLE tbl_a ADD PARTITION (PARTITION pt2) MSAN uninitalized read (MDEV-36723)

• Fix COALESCE and IFNULL functions to use - (i) argument nullness, (ii) type conversion safety of fallback values to decide nullability of result. (MDEV-36851)

• Fixed bug in maria-backup where maria-backup would crash during the 'maria_recovery' part. This could happen if server was doing repair or creating indexes while the backup was running. (MDEV-36860)

• Improve runtime dependency packaging on Windows (MDEV-36904)

• On Windows, when MSI package is installed, with ADDLOCAL parameter passed to msiexec.exe, and Visual C++ Redistributable package is not installed on the target machine, installation may fail during "create database" step. (MDEV-36938)

• MyRocks storage engine can no be built on aarch64 non-linux platforms (MDEV-37001)

• SIGSEGV in wsrep_check_sequence | mysql_alter_table (MDEV-37056)

• sql/wsrep_allowlist_service.cc:40:27: runtime error: member call on null pointer of type 'Wsrep_schema' (MDEV-37136)

• Killed query with side effects without error (MDEV-37198)

• galera.galera_sst_encrypted LeakSanitizer: detected memory leaks (MDEV-37206)

• mtr galera_3nodes.galera_garbd_backup test failures (MDEV-37209)

• Ensure that Annotate_rows is always written direct after GTID information, before any table_map events. Before this patch the event could be written in a random position in the binary log. This change make the place of the Annotate_rows event predictable. When mixing transactional and not transactional tables in the same transaction, the Annotate rows event was not always written in the case of a rollback. This is now fixed. (MDEV-37356)

• Downcast of address to Item_func_eq but of type Item_func_equal in opt_split.cc(add_ext_keyuse_for_splitting) found with UBSAN (MDEV-37438)

• There was a very small chance of InnoDB crashing or misbehaving after an attempt to reduce innodb_buffer_pool_size. (MDEV-37447)

• It appears that some error conditions don't store error information in the Diagnostics_area.

  • For example when table_def::compatible_with() check fails error message is stored in Relay_log_info instead.

  • This results in optimistically identical votes and zero error buffer size breaks wsrep-lib logic as it relies on error buffer size to decide whether voting took place.

  • To account for this, first try to obtain error info from Relay_log_info, then fallback to Diagnostics_area. If that fails use some random data to distinguish this condition from success.

  • This requires bumping of the application protocol to 8 since vote message generation algorithm has changed. (MDEV-37494)

• The galera_new_cluster script was installed into the scriptdir in the 2025 Q3 releases. It previously was in the bin dir. The difference is only noticeable on bintar releases. (MDEV-37497)

• Make Server Debug + Clang compile ready (MDEV-37502)

• MemorySanitizer: use-of-uninitialized-value myrocks::Rdb_key_def::pack_field (MDEV-37504)

• myisamchk -V crashes (MDEV-37505)

• Follow up fix to MDEV-36087 (MDEV-37518)

• wsrep_allowlist allows all connections during SST (MDEV-37548)

• UBSAN: nullptr-with-nonzero-offset/pointer-overflow in row_log_apply_ops (MDEV-37626)

• BsonGet_String and JsonGet_String with a NULL argument resulted in an empty string warning. This now has an "Argument is NULL" warning. (MDEV-37633)

• IS TRUE incorrectly converts outer join to inner (MDEV-37653)

• CHECK TABLE…EXTENDED could flag bogus corruption on a column prefix index. (MDEV-37659)

• innodb.sys_defragment fails sporadically in CI with wrong result (MDEV-37669)

• During workload after crash recovery, an incorrect (too large) innodb_buffer_pool_pages_dirty could be reported. (MDEV-37677)

• main.lotofstack /main.sp-error fails in MSAN+Debug (MDEV-37705)

• TPROC-H, no stats: Query4 much slower in 11.4 than in 10.11 (MDEV-37723)

• In rare cases, shutdown might hang (MDEV-37728)

• LOCATE(X,Y,NULL) is not NULL (MDEV-37740)

• Table Charset Mismatch (Primary/Replica) via Event (MDEV-37744)

• Lock checks for secondary indexes were unnecessarily accessing some history and could access freed BLOB pages that correspond to column prefixes. (MDEV-37753)

• connect engine Debian packaging shouldn't depend explictly on libxml2 (MDEV-37776)

• gcov doesn't work on macOS (MDEV-37791)

• main.information_schema_db fails sporadically (MDEV-37797)

• MSAN use-of-uninitialized-value in wsrep_xid_print (MDEV-37809)

• Spider: XA COMMIT ONE PHASE fails with "This xid does not exist" (MDEV-37829)

• mysqli silently trims each json_arrayagg result to modulo 64KB (MDEV-37835)

• main.repair_symlink-5543 broken on macOS (MDEV-37851)

• Using mytop with DBD-MariaDB and host=localhost specified resulted in an unexpected error because the driver did not expect a port 3306. Contribution thanks to Jean Weisbuch. (MDEV-37852)

• Galera replication does not preserve the character set and collation associated with views, etc. (MDEV-37857)

• sys_vars.thread_cache_size_func fails sporadically (MDEV-37890)

• main.public_privileges fails sporadically (MDEV-37893)

• main.show_check fails sporadically (MDEV-37894)

• Under selinux, the galera SST port checking resulted in excessive AVC notices. This has been simplified under selinux. (MDEV-37899)

• Wrong result with Loose Scan on QUICK_GROUP_MIN_MAX_SELECT WITH TIES (MDEV-37901)

• Threadpool - debug assertion thread_group->active_thread_count >=0, from TP_connection_generic::wait_begin (MDEV-37902)

• ALTER TABLE ... ENGINE=MRG_MyISAM is now properly logged as an DDL. This ensures that the changed MERGE table cannot be used by a slave thread until after the ALTER command has been executed. (MDEV-37903)

• Assertion `0' failed in int wsrep::transaction::before_rollback() (MDEV-37935)

• Test failure on galera.galera_temporary_sequences (MDEV-37981)

• Test failure on galera.galera_provider_options_long (MDEV-37986)

• If the server was killed during an operation that creates a .ibd file, such as TRUNCATE TABLE, it could fail to recover. (MDEV-37994)

• main.grant_kill fails sporadically (MDEV-38008)

• Galera nodes should operate when transaction-read-only=ON (MDEV-38073)

• Some performance schema tests fail on builds without WSREP (MENT-1944)

• If the user specifies some tls-related parameters in spider table creation with odbc/mariadb backend (unlikely), these parameters could be ill-formatted in the odbc connection string, causing them to be ignored by the driver. (MENT-2407)

• main.kill-2 failed in buildbot (MDEV-13257)

• main.old-mode failed in buildbot with wrong result (MDEV-19373)

• The number of concurrent connections reported by userstats, when enabled, is updated. (MDEV-23283)

• SIGSEGV in replace_proxies_priv_table on GRANT PROXY (MDEV-27893)

• SIGSEGV in replace_column_table on GRANT (MDEV-28128)

• FederatedX error 10000 on multi-table UPDATE/DELETE (MDEV-29874)

• Previous systemd warnings in recent systemd versions about uninitialised environment variables have been corrected. (MDEV-35904)

• Fix --master-retry-count=0 not infinite as described (MDEV-36002)

• Sporadic main.vector_innodb test result mismatch on ppc64el, i386 (MDEV-36890)

• clear warnings for io_setup failure (MDEV-37411)

• galera.MDEV-26266 fails with ER_OPTION_PREVENTS_STATEMENT with PS protocol (MDEV-37618)

• Galera galera_new_cluster scipt and its systemd interactions was rewritten to avoid selinux errors. This will require the mysql-selinux-1.0.14+ version that is a dependency of the server in RPM+selinux distributions. (MDEV-37726)

• Remove InnoDB "optimizations" for debug_no_sync (MDEV-37843)

• Unformatted InnoDB messages in the error log (MDEV-36993)

• engines/iuds and engines/funcs suites fail with ps-protocol (MDEV-37375)

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}