MariaDB 11.0.6 Release Notes

MariaDB 11.0 is a current short-term stable series of MariaDB and will be maintained until June 2024. It is an evolution of MariaDB 10.11 with several entirely new features.

MariaDB 11.0.6 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

• Auto increment deadlock error causes ASSERT in subsequent save point (MDEV-33593)
• SIGSEGV in buf_read_ahead_linear() when bpage is in buf_pool.watch (MDEV-33332)
• fts query crashes in fts_query_calculate_ranking() (MDEV-33383)
• InnoDB is holding shared dict_sys.latch while waiting for FOREIGN KEY child table lock on DDL (MDEV-32899)
• Adaptive hash index corruption after ALTER TABLE…DISCARD TABLESPACE (MDEV-33400)
• Server aborts while altering an InnoDB statistics table (MDEV-33462)
• LeakSanitizer errors in rec_copy_prefix_to_buf (MDEV-33230)
• Fatal error InnoDB: Clustered record field for column x not found (MDEV-33558)
• InnoDB may still hang when temporarily running out of buffer pool (MDEV-33613)
• Alter operation hangs when encryption thread works on the same tablespace (MDEV-33770)
• MariaDB segfault on rowid filter query involving generated column (MDEV-33795)
• Crash in flst_read_addr on corrupted data (MDEV-33325)
• Discard/Import Tablespace, Restart, Index Corruption (MDEV-33512)
• Possible server hang on DROP INDEX or RENAME INDEX (MDEV-33993)
• mariabackup --backup hangs (MDEV-33669)
• Server hang caused by InnoDB change buffer (MDEV-33543)
• Assertion failures upon adding a too long key to table with COMPRESSED row format (MDEV-31161)
• IMPORT TABLESPACE fails with column count or index count mismatch (MDEV-30655)
• Alter table corrupts while applying the modification log (MDEV-19044)
• Inconsistent behaviors of UPDATE under RU & RC isolation level (MDEV-26643)
• Weird SELECT view when a record is modified to the same value by two transactions (MDEV-26642)
• Inconsistent read and write, which use the same predicate (WHERE clause) (MDEV-29565)
• Inconsistent SELECT View when modify a record added by another transaction (MDEV-26671)
• MONITOR_INC_VALUE_CUMULATIVE is executed regardless of "if" condition (MDEV-33591)
• The purge of committed history is mis-parsing some log (MDEV-33819)
• Weird read view after ROLLBACK of other transactions (MDEV-33802)
• Read only server throws error when running a create temporary table as select statement (MDEV-33889)
• Change buffer index fails to delete the records (MDEV-32489)
• Innodb include OS error information when failing to write to iblogfile0 (MDEV-33397)
• Phantom rows caused by UPDATE of PRIMARY KEY (MDEV-32898)
• fsp_alloc_free_extent() fails to flag DB_OUT_OF_FILE_SPACE (MDEV-34118)
• Performance regression due to frequent scan of full buf_pool.flush_list (MDEV-33508)
• MariaDB-client community can't be installed in red hat ubi9 (MDEV-32791)
• In-place migration from MySQL 5.7 causes invalid AUTO_INCREMENT values (MDEV-33277)
• InnoDB may corrupt its log before upgrading it on startup (MDEV-32445)
• Implement AVX512BW and VPCLMULQDQ based CRC-32 algorithms (MDEV-33817)
• matched_rec::block should be allocated from the buffer pool (MDEV-33559)
• Table is getting rebuild with ALTER TABLE ADD COLUMN (MDEV-33214)

Aria

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

Connect

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

Federated

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

Mroonga

• mroonga ignores WITHOUT_DYNAMIC_PLUGINS (MDEV-33723)

RocksDB

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

Spider

• Server crashes when deleting partitions from a table with spider engine (MDEV-33731)
• 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-30727)
• Trying to lock uninitialized mutex at storage/spider/spd_i_s.cc after failure upon startup (MDEV-33538)
• UBSAN null pointer passed as argument 2, which is declared to never be null in spider_udf_direct_sql_create_conn (MDEV-33434)
• 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-33242)
• spider plugin init failure with no_zero_date sql_mode (MDEV-33494)
• sql plugin init failure with traditional sql_mode (MDEV-33584)
• spider returns parsing failure on valid left join select by translating the on expression to () (MDEV-33679)
• Spider: ERROR 12710 (HY000): Invalid information from remote table when using MariaDB 10.5 local and MariaDB 10.6 remote (MDEV-33777)
• ASAN: heap-use-after-free in memcpy from sql/protocol.cc on SELECT (MDEV-34003)
• spider/bugfix.mdev_30727 failing in ASAN builds (MDEV-34036)
• SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' (MDEV-32487)
• No spider variables available is Spider is loaded upon server startup (MDEV-33441)

Backup

• mariadb-backup fails to preserve innodb_encrypt_tables (MDEV-33334)
• MDEV-30968 breaks running mariabackup on older mariadb (opendir(NULL)) (MDEV-31251)
• mariabackup --backup: FATAL ERROR: ... Can't open datafile cool_down/t3 (MDEV-33011)
• mariadb-backup --backup is missing retry logic for undo tablespaces (MDEV-33980)
• mariabackup --prepare: [ERROR] InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size (MDEV-33540)
• Crash in mariadb-backup --prepare --export after --prepare (MDEV-33023)
• mariadb-backup is not considering O/S user when --user option is omitted (MDEV-32893)

Character Sets, Data Types

• ORDER BY COLLATE improperly applied to non-character columns (MDEV-33318)
• Default charset doesn't work with PHP MySQLi extension (MDEV-32975)
• Bad SEPARATOR value in GROUP_CONCAT on character set conversion (MDEV-33772)
• ASAN unknown-crash in Inet6::ascii_to_fbt when casting character string to inet6 (MDEV-32458)
• Out of range error in AVG(YEAR(datetime)) due to a wrong data type (MDEV-33496)
• GREATEST() and LEAST() malfunction for NULL (MDEV-21034)

JSON

• JSON test has problem in view protocol (MDEV-32454)
• View created via JSON_ARRAYAGG returns incorrect json object (MDEV-30646)
• SIGSEGV in json_get_path_next | Item_func_json_extract::read_json (MDEV-31402)
• JSON_TYPE doesnt detect the type of String Values (returns NULL) and for Date/DateTime returns "INTEGER" (MDEV-19487)
• JSON_REMOVE returns NULL on valid arguments (MDEV-22141)
• JSON_EXTRACT not returning multiple values for same path (MDEV-32287)

Encryption, TLS, SSL

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

Optimization & Tuning

• LeakSanitizer errors in rec_copy_prefix_to_buf (MDEV-33230)
• Sig11 due to stack overflow in Item_cond::remove_eq_conds (MDEV-33468)
• Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables (MDEV-21102)
• Wrong result with cross Join given join order (MDEV-30975)
• Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT (MDEV-31276)
• Wrong result with semi-join and splittable derived table (MDEV-23878)
• Crash inside calculate_cond_selectivity_for_table() with many columns (MDEV-33314)
• Optimizer choosing incorrect index in 10.6, 10.5 but not in 10.4 (MDEV-33306)
• Aggregation functions fail to leverage uniqueness property (MDEV-30660)
• Partitioning is broken on big endian architectures (MDEV-33623)

Plugins

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

Replication

• --gtid-ignore-duplicate can double-apply event in case of parallel replication retry (MDEV-33475)
• Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure (MDEV-34042)
• mysql_manager_submit Segfault at Startup Still Possible During Recovery (MDEV-33799)
• Server crash in Rows_log_event::update_sequence upon replaying binary log (MDEV-31779)
• Slave crashed:reload_acl_and_cache during shutdown (MDEV-30260)
• Rpl_semi_sync_slave_status is ON When Replication Is Not Configured (MDEV-33546)
• When binlog_annotate_row_events on , event of binlog file is truncated (MDEV-9179)
• Add more warnings to be able to better diagnose network issues (MDEV-33582)
• Improve times and states in show processlist for replication (MDEV-33620)
• Adapt parallel slave's round-robin scheduling to XA events (MDEV-33668)
• release row locks for non-modified rows at XA PREPARE (MDEV-33454)
• Semi-sync Wait Point AFTER_COMMIT Slow on Workloads with Heavy Concurrency (MDEV-33551)

Galera

• Disallow bulk insert operation during partition update statement (MDEV-33979)
• galera_shutdown_nonprim: mysql_shutdown failed (MDEV-32635)
• Failed to apply write set with flags = (rollback | pa_unsafe) (MDEV-33509)
• GCF-1060 test hangs when BF-abort logic mistreats transactions with explicit MDL locks (MDEV-33136)
• galera_3nodes.galera_ipv6_mysqldump MTR failed: mysql_shutdown failed (MDEV-26499)
• ASAN reports "stack use after return" in Wsrep_schema_impl::open_table (MDEV-33216)
• Transactional commit not supported by involved engine(s) (MDEV-33828)
• galera.versioning_trx_id: Test failure: mysqltest: Result content mismatch (MDEV-18590)
• Failure during the galera_3nodes_sr.GCF-336 test (MDEV-34071)
• Graceful node shutdown can crash Garbd and Cluster can go non-Primary when SSL is used (MDEV-33495)

SQL, Data Definition, and Data Manipulation

• Transportable Tablespaces leave AUTO_INCREMENT in mismatched state, causing INSERT errors in newly imported tables when .cfg is not used (MDEV-18288)
• wrong row targeted with "insert ... on duplicate" and "replace", leading to data corruption (MDEV-30046)
• Incorrect DEFAULT expression evaluated in UPDATE (MDEV-33790)
• Server crashes when the UPDATE statement (which has duplicate key) is run after setting a low thread_stack (MDEV-33622)
• Incorrect handling of UPDATE in PS mode in case a table's colum declared as NOT NULL (MDEV-33549)
• 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-15703)
• Wrong result on 2-nd execution of PS to select from view using derived (MDEV-31277)
• Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT (MDEV-31276)
• Memory leaks found in some tests run with --ps-protocol against a server built with the option -DWITH_PROTECT_STATEMENT_MEMROOT (MDEV-33767)
• Memory leak found in the test main.constraints run with --ps-protocol against a server built with the option -DWITH_PROTECT_STATEMENT_MEMROOT (MDEV-33768)
• Memory leak found in the test main.rownum run with --ps-protocol against a server built with the option -DWITH_PROTECT_STATEMENT_MEMROOT (MDEV-33769)
• The TIMESTAMP value of '1970-01-01 00:00:00' can be indirectly inserted in strict mode (MDEV-34088)
• Out of range error in AVG(YEAR(datetime)) due to a wrong data type (MDEV-33496)
• Zero datetime reinterprets as '1970-01-01 00:00:00' on field_datetime=field_timestamp (MDEV-34069)
• unix_timestamp(coalesce(timestamp_column)) returns NULL on '1970-01-01 00:00:00.000001' (MDEV-34061)
• Server Crash using UDF in WHERE clause of VIEW (MDEV-24507)
• Update for portion changes autoincrement key in period table (MDEV-25370)
• CREATE TABLE with generated column and RLIKE results in sigabrt (MDEV-21058)

Platforms & Packaging

• memlock with systemd still not working even with MDEV-9095 fix (MDEV-33301)
• Ubuntu/Debian MYSQL_SERVER_SUFFIX is version+suffix on MariaDB packaged versions (MDEV-33631)
• Parameter 'CMAKE_SYSTEM_PROCESSOR=$(DEB_HOST_ARCH)' is not needed anymore to crosscompile Debian packages (MDEV-32935)

General

Compiling

• CentOS 7 MariaDB 10.5 build jobs failing "Invalid capability: cap "%caps(cap_ipc_lock=pe" (MDEV-33636)
• CMake : use documented variable ZLIB_LIBRARIES, rather than ZLIB_LIBRARY (MDEV-33876)
• MariaDB does not make full use of pkgconfig (MDEV-29955)

Information Schema

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

Scripts & Clients

• Commands start-all-slaves and stop-all-slaves are not listed in mysqladmin help (MDEV-21864)
• [PATCH] mysqldump --dump-slave=2 --master-data=2 doesn't record both (MDEV-4827)
• Loading time zones does not work with alter_algorithm INPLACE (MDEV-33044)
• mariadb-dump trusts the server and does not validate the data (MDEV-33727)
• Disable system commands in mysql/mariadb client (MDEV-21778)

Server

• lf_alloc isn't safe on aarch64 (or ppc64le) (MDEV-28430)
• 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-33534)
• Windows: Opt-out of Win11 automatic CPU throttling (LowQOS) (MDEV-33488)
• Moving from MariaDB 10.5 to 10.6 mysql_upgrade is not updating some system tables (MDEV-33726)
• Original IP not shown in network related error messages when proxy_protocol is in use (MDEV-33506)
• Error 4162 "Operator does not exists" is incorrectly-worded (MDEV-33803)
• tpool - switch off maintenance timer when not needed (MDEV-33840)
• Server incorrectly describes known variables as UNKNOWN if invalid values are specified at startup (MDEV-33469)
• UBSAN: runtime error: signed integer overflow: 2148 * 1000000 cannot be represented in type 'int' (MDEV-34063)
• update case insensitive (large) unique key with insensitive change of value - duplicate key (MDEV-29345)
• MariaDB will abort server startup if it finds an invalid parameter, but won't check for other invalid params (MDEV-26923)
• Slowdown when running nested statement with many partitions (MDEV-33502)
• main.query_cache fails with embedded after enabling WITH_PROTECT_STATEMENT_MEMROOT (MDEV-33861)

Security

• Fixes for the following security vulnerabilities:
  • CVE-2024-21096

Changelog

For a complete list of changes made in MariaDB 11.0.6, with links to detailed information on each push, see the changelog.