All pages
Powered by GitBook
1 of 1

Loading...

MariaDB 11.5.2 Release Notes

Download Release Notes Changelog Overview of 11.5

Release date: 14 Aug 2024

MariaDB 11.5.2 is a Stable (GA) release. It is an evolution of MariaDB 11.4 with several entirely new features.

MariaDB 11.5 is a rolling release. One is expected to upgrade to MariaDB 11.6.2, there will be no 11.5.3.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

  • now builds indexes more efficiently ()

    • Unsetting the system variable restores the old behavior.

  • Fix unexpected storage read IO for the redo log, reintroduce ()

  • Correctly terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing (

Aria

  • Fix index corruption when doing a REPAIR TABLE that has a size of over 4G ()

Spider

  • UBSAN: runtime error: applying non-zero offset in spider_free_mem and SIGSEGV in spider_free_mem on SELECT ()

  • SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' ()

  • SIGSEGV in spider_db_conn::fin_loop_check, and ASAN: heap-use-after-free in

Partitioning

  • SIGSEGV in parse_engine_part_options on INSERT, SELECT or ALTER ()

  • Assertion ``auto_increment_value'failed inha_partition::info` on INSERT into MEMORY table ()

Character Sets

  • On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb from strings/ctype-mb.c and other locations ()

  • On startup: UBSAN: runtime error: applying zero offset to null pointer in skip_trailing_space and my_hash_sort_utf8mb3_general1400_nopad_as_ci ()

  • SHOW CREATE DATABASE statement crashes the server when db name contains some unicode characters, ASAN stack-buffer-overflow (

Optimizer

  • On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info in sql/sql_select.cc ()

  • Crash after killing query while it is processed by test_quick_select ()

  • Extend condition normalization to include 'NOT a' ()

  • Auto-generated from table no longer breaks replication ()

  • Fix replication failure when are used where the replica has set and the client has touched a different database when running DML such as inserts. ()

  • Fix replication error when is used in conjunction with a password longer than 41 ascii characters ()

Backup

  • Hide password passed on commandline from xtrabackup_info ()

Galera

  • updated to 26.4.19

  • galera_gtid_2_cluster: Assertion ``thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'` ()

  • table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0 ()

Error Log

  • system variable added, and value added to the at startup ()

General

  • As per the , this will be the last release of for Debian 10 "Buster", RHEL/CentOS 7, Ubuntu 23.10 "Mantic", and Fedora 38

  • Repositories for Ubuntu 24.04 "Noble" have been added

  • no longer unnecessarily traverses tablespaces list ()

  • Fix unknown variable defaults-group-suffix=

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 .

)
  • Alter operation on redundant table no longer aborts the server (MDEV-34222)

  • Fix MariaDB crash with SIGILL because the OS does not support AVX512 (MDEV-34565)

  • Fix InnoDB: Failing assertion: stat_n_leaf_pages > 0 in ha_innobase::estimate_rows_upper_bound (MDEV-34474)

  • wait_for_read in buf_page_get_low no longer hurts performance (MDEV-34458)

  • Fix InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211 (MDEV-34357)

  • spider_db_mbase::fin_loop_check
    on SHOW TABLE STATUS (
    )
  • SIGSEGV in ha_spider::lock_tables on BEGIN after table lock (MDEV-29962)

  • SIGSEGV in spider_conn_first_link_idx and others on DELETE, INSERT and SELECT (MDEV-32492)

  • Spider: Crashes, asserts, hangs, memory corruptions and ASAN heap-use-after-free's (MDEV-27902)

  • Spider: @@insert_id 128 to TINYINT: Assertion ``!is_set() || (m_status == DA_OK_BULK && is_bulk_op())'` failed. (MDEV-28105)

  • ASAN errors in spider_db_free_result after partition DDL (MDEV-29027)

  • Server crashes when calling spider UDF after aria_encrypt_tables is enabled (MDEV-34682)

  • )
  • Wrong result set with utf8mb4_danish_ci and BNLH join (MDEV-34417)

  • Constant subquery causing a crash in pushdown optimization (MDEV-29363)

  • Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table (MDEV-33010)

  • 2nd execution name resolution problem with pushdown into unions (MDEV-34506)

  • Assertion ``(key_part->key_part_flag & 4) == 0'` failed key_hashnr (MDEV-34580)

  • Crash caused by query containing constant having clause (MDEV-23983)

  • Using NAME_CONST() (or executing query from the stored procedure and referring to a local variable) changes the plan and may make execution slower (MDEV-33971)

  • ORDER BY DESC causes ROWID Filter optimization performance degradation (MDEV-33875)

  • The option is utilized to avoid a possible error state in (MDEV-33465)

    Deadlock found when trying to get lock during applying (MDEV-31658)

  • Change error code for Galera unkillable threads (MDEV-12008)

  • 10.11.8 cluster becomes inconsistent when using composite primary key and partitioning (MDEV-34269)

  • wsrep_sst_mariadb-backup use /tmp dir during SST rather then user defined tmpdir (MDEV-32158)

  • with
    (
    )
  • no longer hangs on macOS (MDEV-34129)

  • Fix transaction termination with ER_LOCK_TABLE_FULL when lock memory is growing (MDEV-34167)

  • Disable new connections in case of fatal signal (MDEV-34475)

  • Control over memory allocated for SP/PS (MDEV-14959)

  • now work correctly with bulk insert (MDEV-24411)

  • Fix assertion ``table->field[0]->ptr >= table->record[0] && table->field[0]->ptr <= table->record[0] + table->s->reclength'failed invoid handler::assert_icp_limitations(uchar*)` (MDEV-34632)

  • - now compatible with (MDEV-34203)

  • MDEV-33087
    MDEV-33894
    MDEV-34522
    MDEV-31475
    MDEV-32487
    MDEV-34421
    MDEV-24610
    MDEV-34226
    MDEV-34187
    MDEV-34227
    MDEV-30651
    MDEV-19520
    MDEV-25607
    MDEV-33921
    MDEV-23857
    MDEV-34434
    MDEV-32633
    MDEV-34170
    MDEV-34494
    MariaDB Deprecation Policy
    MariaDB 11.5
    MDEV-34670
    MariaDB 11.5.2
    changelog
    MariaDB 11.5.2
    MariaDB Foundation release announcement
    Galera
    MDEV-34167
    MDEV-34541
    MDEV-32376
    MDEV-33265

    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.

    ALTER TABLE...ALGORITHM=COPY
    innodb_alter_copy_bulk
    innodb_log_write_ahead_size
    Aria
    Replication
    DELETE
    HEAP
    XA transactions
    replicate_do_db
    CHANGE MASTER TO
    server_uid
    error log
    IMPORT TABLESPACE
    --init-rpl-role
    semisync recovery
    mariadb-secure-installation
    mariadb-install-db
    Triggers
    sandbox mode
    --binary-mode

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

    Distributions which Include MariaDB