From this version, the tool adds a new command to the top of every dump file. This command cannot be interpreted by MariaDB command line client versions that do not have the sandbox command, or by MySQL command line clients, and an error will be generated in these clients. Other methods of importing the dump will work not have this issue.

Storage Engines

InnoDB

• Introduce the system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) (MDEV-33515)

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

• Fix adaptive hash index corruption after (MDEV-33400)

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

• Fix LeakSanitizer errors in rec_copy_prefix_to_buf ()

• Fix InnoDB fatal error: Clustered record field for column x not found ()

• Fix InnoDB hang when temporarily running out of buffer pool ()

• Fix alter operation hang when encryption thread works on the same tablespace ()

• Fix MariaDB segfault on rowid filter query involving generated column ()

• Fix discard/import tablespace, restart, index corruption ()

• Fix server hang on DROP INDEX or RENAME INDEX ()

• Fix mariadb-backup --backup hang ()

• Fix server hang caused by InnoDB change buffer ()

• Fix assertion failures upon adding a too long key to table with COMPRESSED row format ()

• IMPORT TABLESPACE no longer fails with column count or index count mismatch ()

• Fix alter table corruption while applying the modification log ()

• Fix inconsistent behaviors of UPDATE under RU & RC isolation level ()

• Fix weird SELECT view when a record is modified to the same value by two transactions ()

• Fix inconsistent read and write, which use the same predicate (WHERE clause) ()

• Fix inconsistent SELECT view when modifying a record added by another transaction ()

• Fix weird read view after ROLLBACK of other transactions ()

• Read only server no longer throws error when running a create temporary table as select statement ()

• Change buffer index no longer fails to delete the records ()

• Fix InnoDB include OS error information when failing to write to iblogfile0 ()

• Fix phantom rows caused by UPDATE of PRIMARY KEY ()

  • New system variable,

• In-place migration from MySQL 5.7 no longer causes invalid AUTO_INCREMENT values ()

• Fix InnoDB log corruption before upgrading it on startup ()

• Table no longer gets rebuilt with ALTER TABLE ADD COLUMN ()

• Fixed that internal temporary tables did not wait for freed disk space, and related issues (MDEV-33813)

• Fix wrong result on 2nd execution of prepared statement for query with derived table (MDEV-31361)

• Improve Spider performance by pushing down function (MDEV-28992) and statement (MDEV-28993) to data nodes

• Fix server crash when deleting partitions from a table with spider engine (MDEV-33731)

• SPIDER plugin initialization no longer fails 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)

• Fix spider plugin init failure with no_zero_date sql_mode ()

• Fix sql plugin init failure with traditional sql_mode ()

• Fix parsing failure on valid left join select by translating the on expression to () ()

• Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using local and remote ()

• Fix bug where were not available if Spider was loaded upon server startup ()

Backup

• Port backup features from Enterprise Server. This adds support for to MariaDB Backup, and obsoletes the no-backup-locks and rysnc options (MDEV-32932)

• MariaDB Backup now preserves (MDEV-33334)

• Fix MariaDB Backup problem on older mariadb (opendir(NULL)) caused by MDEV-30968 (MDEV-31251)

• Fix FATAL ERROR: ... Can't open datafile cool_down/t3 ()

• now includes retry logic for undo tablespaces ()

• Fix crash recovery in mariadb-backup --prepare due to insufficient ()

• Fix crash in mariadb-backup --prepare --export after --prepare ()

• now considers O/S user when --user option is omitted ()

,

• Fixed improper application of COLLATE to non-character columns (MDEV-33318)

• Default charset now works with PHP MySQLi extension (MDEV-32975)

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

• Fixed out of range error in (()) due to a wrong data type (MDEV-33496)

• Fixed and problems with ()

JSON

• View created via now returns correct json object (MDEV-30646)

• now detects the type of String Values and correctly returns Date/DateTime values (MDEV-19487)

• no longer returns NULL on valid arguments (MDEV-22141)

• no longer returns multiple values for same path (MDEV-32287)

Encryption, TLS, SSL

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

Optimization & Tuning

• 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)

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

• Aggregation functions fail to leverage uniqueness property ()

• Partitioning is broken on big endian architectures ()

Plugins

• The now reports the user and host in all cases (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 ()

• Rpl_semi_sync_slave_status is ON When Replication Is Not Configured ()

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

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

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

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

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

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

Galera

• Galera updated to 26.4.18

  • NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated

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

SQL, Data Definition, and Data Manipulation

• Transportable Tablespaces no longer leave in a mismatched state (MDEV-18288)

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

• Fix incorrect DEFAULT expression evaluated in (MDEV-33790)

• Fix server crash when UPDATE statement with duplicate key is run after setting a low thread_stack (MDEV-33622)

• Fix incorrect handling of in PS mode when a table's column declared as NOT NULL ()

• Fix crash in EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a INT DEFAULT ?)' USING DEFAULT ()

• Fix wrong result on 2nd execution of PS to select from view using derived ()

• Fix wrong warnings on 2nd execution of PS for query with GROUP_CONCAT ()

• value of '1970-01-01 00:00:00' can no longer be indirectly inserted in ()

• Fix out of range error in (()) due to a wrong data type ()

• Fix zero datetime reinterpreting as '1970-01-01 00:00:00' on field_datetime=field_timestamp ()

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

• Fix crash using UDF in WHERE clause of VIEW ()

• Fix update for portion changes autoincrement key in period table ()

• Fix SIGABRT resulting from CREATE TABLE with generated column and RLIKE ()

Platforms & Packaging

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

General

Scripts & Clients

• It's now possible to disable system commands with the option. (MDEV-21778)

• now exports the data with sandbox mode enable, so that the mariadb client will not execute potentially dangerous cli commands.(MDEV-33727)

• commands such as mariadb-dump --dump-slave=2 --master-data=2 now record both positions (MDEV-4827)

• Loading now works with INPLACE ()

Server

• 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)

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

• 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 ()

• Slowdown when running nested statement with many partitions ()

Security

• Fixes for the following :

  • CVE-2024-21096

Changelog

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

Contributors

For a full list of contributors to MariaDB 11.2.4, see the MariaDB Foundation release announcement.

• Windows packages were delayed but have now been added to the downloads site

InnoDB

• Unique hash key on column prefix is computed incorrectly (MDEV-29954)

• Query from I_S.INNODB_SYS_INDEXES exceeding LIMIT ROWS EXAMINED causes ER_UNKNOWN_ERROR and LeakSanitizer errors in rec_copy_prefix_to_buf_old (MDEV-28613)

• Assertion ``0'failed inrow_sel_convert_mysql_key_to_innobase upon UPDATE` using a partial-field key prefix in search ()

• Assertion failure on REPLACE on ROW_FORMAT=COMPRESSED table ()

• Crash emitting "Unsupported meta-data version number" error message ()

• LeakSanitizer errors in mem_heap_create_block_func upon query from I_S.INNODB_SYS_TABLES with LIMIT ROWS EXAMINED ()

• Inplace alter rebuild increases file size ()

• BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY ()

• GNU libc posix_fallocate() may be extremely slow ()

• InnoDB wrong error message ()

• Assertion failure on ALTER TABLE…PAGE_COMPRESSED=1 ()

• InnoDB after ALTER TABLE…IMPORT TABLESPACE may not be crash safe ()

• InnoDB fails to restore tablespace first page from doublewrite buffer when page is empty ()

• innodb_fast_shutdown=0 hang after incomplete startup ()

• innodb_undo_log_truncate=ON prevents fast shutdown ()

• Adaptive flush recommendation ignores dirty ratio and checkpoint age ()

• gcol.gcol_purge contaminates further execution of innodb.gap_locks ()

• LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()

• Adaptive flushing is still not getting invoked in 10.5.11 ()

• History list is not shrunk unless there is a pause in the workload ()

• path separator near ib_buffer_pool incorrect ()

• Deadlock between buf_page_get_zip() and buf_pool_t::corrupted_evict() on InnoDB ROW_FORMAT=COMPRESSED table corruption ()

• Empty INSERT crashes with innodb_force_recovery=6 or innodb_read_only=ON ()

• Assertion ``end_lsn == page_lsn'failed inrecv_recover_page` ()

• Some calls to buf_read_ahead_linear() seem to be useless ()

• Opening all .ibd files on InnoDB startup can be slow ()

• InnoDB LRU flushing does not run before running out of buffer pool ()

• innodb_undo_log_truncate=ON is blocking page writes ()

Backup

• mariadb-backup has wrong or missing plugin-dir default? (MDEV-29110)

• mariadb-backup fails when innodb_max_dirty_pages_pct contains a fraction (is not an integer) (MDEV-20286)

• Missing required privilege CONNECTION ADMIN (MDEV-33006)

• If tables are frequently created, renamed, dropped, a backup cannot be restored ()

• on table to be accessible to those with privileges ()

JSON

• Wrong function name in ER_JSON_PATH_NO_WILDCARD error message for JSON_REPLACE (MDEV-24541)

• JSON_VALID fail to validate integer zero in scientific notation (MDEV-32587)

• ASAN errors in Item_func_json_contains_path::val_int upon PS execution ()

• mysql_json cannot be used on newly created table ()

• Problems with a stored function EMPTY() on upgrade to 10.6 ()

Spider

• Thread (10.6+) and server hangs (10.4/10.5) in 'Opening tables' (on optimized builds) and SIGABRT in safe_mutex_lock (on debug) on I_S read when using Spider (MDEV-29421)

• SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES (MDEV-29963)

• ASAN heap-use-after-free in spider_link_get_key on LOCK TABLES ()

• Crash when lateral derived is guaranteed to return no rows ()

• Bogus error executing PS for query using CTE with renaming of columns ()

• Spider: Valid LEFT JOIN results in ERROR 1064 ()

• Trying to lock uninitialized mutex or hang upon shutdown after using Spider with query_cache ()

• Spider tests failing in asan/valgrind builds ()

• Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service ()

• Server crash with SIGSEGV or dynamic-stack-buffer-overflow in spider_db_mbase_util::append_table ()

• heap-use-after-free in ha_spider::lock_tables(), highly sporadic SIGSEGV in intern_close_table ()

• Syntax error upon query with subquery from Spider table ()

• Spider doesn't recognize semi JOIN ()

• MariaDB, SPIDER engine, usage of REGEXP ()

• Spider: variable spider_same_server_link not functioning correctly ()

• Spider fails to autodiscover structure (did in <=10.5) and reports ERROR 12500 (HY000): unknown ()

• Spider spawns unnecessarily many system threads for stats synchronization ()

  • Defaults for and changed from 10 to 1

• SIGSEGV in spider_db_delete_all_rows on TRUNCATE, UBSAN: member call on null pointer of type 'struct spider_db_handler' in spider_db_delete_all_rows ()

• mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema' ()

• Spider: SIGSEGV in spider_db_direct_delete, SIGSEGV in spider_db_connect, ASAN: heap-use-after-free in spider_db_direct_delete ()

• No error for DROP TABLE and no warning for DROP TABLE IF EXISTS with absent table when Spider plugin is included ()

• ASAN errors in spider_conn_queue_and_merge_loop_check ()

Optimizer

• Crash caused by multi-table UPDATE over derived with hanging CTE (MDEV-28615)

• Crash on query using CTE with the same name as a base table (MDEV-31657)

• Crash with query using constant subquery as left part of IN subquery (MDEV-29362)

• Incorrect result interceptor passed to mysql_explain_union() (MDEV-33165)

• Add variable to influence how costs for secondary keys are calculated. ()

• INSERT ... SELECT Does not produce an optimizer trace ()

• Unusable key notes do not get reported for some operations ()

• Unusable key notes report wrong predicates for > and >= ()

Data Definition, Data Manipulation

• ALTER SEQUENCE IF NOT EXISTS non_existing_seq Errors rather than note (MDEV-32795)

• Unexpected ER_ERROR_ON_RENAME upon DROP non-existing FOREIGN KEY with ALGORITHM=COPY (MDEV-22230)

• FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure ()

• Assertion !"wrong page type"'` or Assertion "wrong page type" == 0'failed ininnobase_instant_tryonALTER` ()

• Assertion (col.vers_sys_end()) upon inplace ALTER with virtual columns ()

• DELETE with ORDER BY and semijoin optimization causing crash ()

• Invalid expr in cleanup_session_expr() upon INSERT DELAYED ()

• SIGSEGV in my_decimal::operator= and Assertion 0'failed inItem_type_holder::val_decimal` on SELECT ()

• LONG UNIQUE does not work like unique key when using replace ()

• LONG UNIQUE gives error when used with REPLACE ()

• Backport to 10.6 ()

• Assertion ``0' failed in Item_type_holder::val_int` ()

Character Sets, Data Types

• InnoDB: CHAR+nopad does not work well (MDEV-26743)

• CAST(AS UNSIGNED) fails with --view-protocol (MDEV-32645)

• JSON_ARRAYAGG charset issue (MDEV-24784)

• Server crash in my_decimal::operator= or unexpected ER_DUP_ENTRY upon comparison with INET6 and similar types ()

Plugins

• The can optionally (when is enabled) include the thread ID and database / table in its log (MDEV-27087). NULL is displayed if there is no database (MDEV-32906)

• Backport SQL service, introduced by MDEV-19275 (MDEV-27595)

• "plugin already loaded" should be a Warning, not an Error (MDEV-32041)

• mariadb-upgrade should remove mysql.plugin entries for plugins that became bundled ()

Galera

• Node has been dropped from the cluster on Startup / Shutdown with async replica (MDEV-31413)

• Inconsistency in Galera caused by ALTER being aborted before entering TOI mode (MDEV-32938)

• Assertion ``total_length + thd->wsrep_sr().log_position() == saved_pos'failed in intwsrep_write_cache_inc(THD*, IO_CACHE*, size_t*)` (MDEV-28971)

• wsrep_provider_options can be truncated on deep and long directory paths ()

• Server crashes in rpl_sql_thread_info::cached_charset_compare / wsrep_apply_events ()

• Galera crash when "create a table as select" ()

• Cluster is inconsistent after SAVEPOINT statement is rolled back ()

• WSREP GTID MODE is inconsistent ()

• IST "Donor does not know my secret" with ssl-mode=VERIFY_CA ()

Replication

• Server crashes in Item_func_binlog_gtid_pos::val_str / Binary_string::c_ptr_safe (MDEV-33045)

• binlog corruption (/tmp no space left on device at the same moment) (MDEV-27436)

• multi source replication filters breaking GTID semantic (MDEV-26632)

• SHOW SLAVE STATUS Can Deadlock an Errored Slave ()

• main.rpl_mysqldump_slave Fails with "Master binlog wasn't deleted" Assertion ()

• rpl_seconds_behind_master_spike Sensitive to IO Thread Stop Position ()

• Binlog Checksum is Zeroed by Zlib if Part of Event Data is Empty ()

• "Read semi-sync reply magic number error" warnings on master ()

• Second Semi-sync Replica Can Hang at Connect Time ()

• Semi-sync ACKed Transaction can Timeout and Switch Off Semi-sync with Multiple Replicas ()

• Semi-Sync Ack_Receiver Thread Should Allow COM_QUIT Command ()

General

• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 11.2 for Fedora 37, Ubuntu 23.04 "Lunar", and Windows Server 2019

• is now dynamic, and contains new options, and old options have been deprecated (MDEV-32884)

• New value, NO_NULL_COLLATION_IDS, a compatibility setting to support connectors (in particular MySQL Connector/NET) that give an exception when collation ids returned by are NULL. It is automatically set when a MySQL Connector/NET connection is determined.

• Upgrade to 12.6.

• Using two temporary tables in OPTIMIZE TABLE lead to crash ()

• REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode ()

• CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" ()

• Failure when executing PS for query using IN subquery ()

• Potential memory leak on execuing of create view statement ()

• Assertion failures ()

• Two JSON related tests running in PS mode fail on server built with -DWITH_PROTECT_STATEMENT_MEMROOT=YES ()

• Alter sequence 2nd ps fails while alter sequence 2nd time (no ps) succeeds ()

• Set TaskMax=inifinity in the MariaDB systemd unit ()

• Unreliable autocommit flag on connection creation ()

• A connection can control RAND() in following connection ()

• THD::rli_fake/rgi_fake not cleared on new connection ()

• Assertion failures in tdc_remove_table upon interrupted CREATE TABLE LIKE <sequence> ()

• Server crash in find_field_in_table ()

• LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE ()

• Failure to call SP invoking another SP with parameter requiring type conversion ()

• The database part is not case sensitive in SP names ()

• EXCHANGE PARTITION with non-matching vcol expression segfault ()

• Wrong user in SET DEFAULT ROLE error ()

• quote(NULL) returns incorrect result in view ('NU' instead of 'NULL') ()

• mysql.slow_log reports incorrect start time ()

• Update federated table and column privileges ()

• Disable transparent huge pages after page buffers have been allocated ()

• Deprecate ()

• sys schema view session_ssl_status is empty ()

• Memory pressure ()

Security

• Fixes for the following :

Changelog

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

Contributors

For a full list of contributors to MariaDB 11.2.3, see the MariaDB Foundation release announcement.

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}

_{This page is licensed: CC BY-SA / Gnu FDL}