All pages
Powered by GitBook
1 of 1

Loading...

MariaDB 10.4.33 Release Notes

The most recent release of MariaDB 10.4 is:MariaDB 10.4.34 Stable (GA) Download Now

Download 10.4.33 | Release Notes | Changelog | Overview of 10.4

Release date: 7 Feb 2024

MariaDB 10.4 is a previous stable series of MariaDB, maintained until June 2024. It is an evolution of MariaDB 10.3 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.4.33 is a Stable (GA) release.

For an overview of MariaDB 10.4 see theWhat is MariaDB 10.4? page.

Thanks, and enjoy MariaDB!

Notable Items

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

InnoDB

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

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

  • Assertion ``0'failed in

Backup

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

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

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

JSON

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

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

  • ASAN errors in Item_func_json_contains_path::val_int

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

  • SIGSEGV in spider_db_mbase::append_lock_tables on LOCK TABLES ()

  • ASAN

Optimizer

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

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

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

Data Definition, Data Manipulation

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

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

Character Sets, Data Types

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

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

Plugins

  • Backport SQL service, introduced by ()

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

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

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

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

Replication

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

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

  • multi source replication filters breaking GTID semantic ()

  • SHOW SLAVE STATUS

General

  • As per the , this will be the last release of for Windows Server 2019

  • Upgrade to 12.6.

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

  • REGEXP_REPLACE

Security

  • Fixes for the following :

    • CVE--``#

Changelog

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

Contributors

For a full list of contributors to , see the .

row_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 (MDEV-31574)

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

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

  • Inplace alter rebuild increases file size (MDEV-26740)

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

  • GNU libc posix_fallocate() may be extremely slow (MDEV-32268)

  • InnoDB wrong error message (MDEV-32833)

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

  • upon PS execution (
    )
    heap-use-after-free
    in
    spider_link_get_key
    on
    LOCK TABLES
    (
    )
  • Crash when lateral derived is guaranteed to return no rows (MDEV-31279)

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

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

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

  • Spider tests failing in asan/valgrind builds (MDEV-32849)

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

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

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

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

  • Spider doesn't recognize semi JOIN (MDEV-31645)

  • MariaDB, SPIDER engine, usage of REGEXP (MDEV-32986)

  • Spider: variable spider_same_server_link not functioning correctly (MDEV-29718)

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

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

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

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

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

  • 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` (MDEV-18322)

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

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

  • Invalid expr in cleanup_session_expr() upon INSERT DELAYED (MDEV-29932)

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

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

  • Server crashes in rpl_sql_thread_info::cached_charset_compare / wsrep_apply_events (MDEV-22232)

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

  • Can Deadlock an Errored Slave (
    )
  • main.rpl_mysqldump_slave Fails with "Master binlog wasn't deleted" Assertion (MDEV-32953)

  • rpl_seconds_behind_master_spike Sensitive to IO Thread Stop Position (MDEV-33327)

  • treats empty strings different than
    REPLACE
    in ORACLE mode (
    )
  • CREATE UNIQUE INDEX fails with "ERROR 1286 (42000): Unknown storage engine 'partition'" (MDEV-21618)

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

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

  • Assertion failures (MDEV-32965)

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

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

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

  • Unreliable autocommit flag on connection creation (MDEV-32875)

  • A connection can control RAND() in following connection (MDEV-33148)

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

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

  • Server crash in find_field_in_table (MDEV-32082)

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

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

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

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

  • MDEV-29954
    MDEV-28613
    MDEV-29110
    MDEV-20286
    MDEV-28367
    MDEV-24541
    MDEV-32587
    MDEV-29421
    MDEV-29963
    MDEV-28615
    MDEV-31657
    MDEV-29362
    MDEV-32795
    MDEV-22230
    MDEV-26743
    MDEV-32645
    MDEV-19275
    MDEV-27595
    MDEV-32041
    MDEV-32043
    MDEV-31413
    MDEV-32938
    MDEV-28971
    MDEV-33045
    MDEV-27436
    MDEV-26632
    MariaDB Deprecation Policy
    MariaDB 10.4
    MDEV-31523
    MariaDB 10.4.33
    changelog
    MariaDB 10.4.33
    MariaDB Foundation release announcement
    MDEV-21245
    MDEV-32867
    MDEV-31357
    MDEV-29092
    MDEV-10653
    MDEV-29095

    Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

    MariaDB may already be included in your favorite OS distribution. More information can be found on the page.

    Distributions which Include MariaDB
    BACKUP LOCKS
    database LOCK TABLES
    HeidiSQL
    security vulnerabilities
    spider_table_crd_thread_count
    spider_table_sts_thread_count

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