The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-14. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB 11.1.6 Release Notes

Download Release Notes Changelog Overview of 11.1

Alternate download from mariadb.org

Release date: 8 Aug 2024

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

MariaDB 11.1.6 is a Stable (GA) release.

MariaDB 11.1.6 is the last release of the MariaDB 11.1 release series.

For an overview of MariaDB 11.1 see the What is MariaDB 11.1? page.

Thanks, and enjoy MariaDB!

Notable Items

Storage Engines

InnoDB

  • ALTER TABLE...ALGORITHM=COPY now builds indexes more efficiently (MDEV-33087)
  • Fix unexpected storage read IO for the redo log, reintroduce innodb_log_write_ahead_size (MDEV-33894)
  • Correctly terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing (MDEV-34167)
  • 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)

Aria

Spider

  • UBSAN: runtime error: applying non-zero offset in spider_free_mem and SIGSEGV in spider_free_mem on SELECT (MDEV-31475)
  • SIGSEGV in ha_resolve_storage_engine_name, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' (MDEV-32487)
  • SIGSEGV in spider_db_conn::fin_loop_check, and ASAN: heap-use-after-free in spider_db_mbase::fin_loop_check on SHOW TABLE STATUS (MDEV-34541)
  • 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)

Partitioning

  • MariaDB Server crashes with ill-formed partitions (MDEV-32155)
  • SIGSEGV in parse_engine_part_options on INSERT, SELECT or ALTER (MDEV-34421)
  • Assertion `auto_increment_value' failed in ha_partition::info on INSERT into MEMORY table (MDEV-24610)

Character Sets

  • On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb from strings/ctype-mb.c and other locations (MDEV-34226)
  • On startup: UBSAN: runtime error: applying zero offset to null pointer in skip_trailing_space and my_hash_sort_utf8mb3_general1400_nopad_as_ci (MDEV-34187)
  • SHOW CREATE DATABASE statement crashes the server when db name contains some unicode characters, ASAN stack-buffer-overflow (MDEV-32376)
  • Wrong result set with utf8mb4_danish_ci and BNLH join (MDEV-34417)

Optimizer

  • On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info in sql/sql_select.cc (MDEV-34227)
  • Crash after killing query while it is processed by test_quick_select (MDEV-30651)
  • Extend condition normalization to include 'NOT a' (MDEV-19520)
  • 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)

Replication

Backup

  • Hide password passed on commandline from xtrabackup_info (MDEV-34434)

Galera

  • Galera updated to 26.4.19
    • NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes nodes have been updated
  • galera_gtid_2_cluster: Assertion `thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)' (MDEV-32633)
  • table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0 (MDEV-34170)
  • 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_mariabackup use /tmp dir during SST rather then user defined tmpdir (MDEV-32158)

Error Log

General

Changelog

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

Contributors

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

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 Distributions which Include MariaDB page.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.