All pages
Powered by GitBook
1 of 9

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Release Notes - MariaDB 11.1 Series

MariaDB 11.1 was a short-term maintenance series of MariaDB maintained until August 2024

MariaDB 11.1 Changes & Improvements

MariaDB 11.1 is no longer maintained. Please use a more recent release.

The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download NowAlternate download from mariadb.org

MariaDB 11.1 is a short-term release series, and was maintained until August 2024.

Upgrading

  • See and .

New Features & Improvements

JSON

  • function for validating a JSON schema ()

Optimizer

  • for single-table / statements. Update and delete statements that use subqueries can now use all subquery optimization strategies that MariaDB offers, so now if you use subqueries in UPDATE or DELETE, these statements will likely be much faster ()

  • Queries with the or functions comparing against a constant can now make use of indexes, so these will be noticeably quicker in certain instances. For example SELECT * FROM t2 WHERE YEAR(a) = 2019 or SELECT * FROM t2 WHERE DATE(a) <= '2017-01-01'. See ()

Transactions

  • The option is now a system variable, and the tx_isolation system variable is deprecated ()

InnoDB

  • Remove and related parameters ()

mariadb-backup

  • Rename xtrabackup_* files to mariadb_backup_* ()

Variables

  • For a list of all new variables, see .

Security Vulnerabilities Fixed in

For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.

  • :

  • :

List of All Releases

Date
Release
Status
Release Notes
Changelog

Stable (GA)

13 Nov 2023

Stable (GA)

21 Aug 2023

Stable (GA)

6 Jun 2023

RC

27 Mar 2023

Alpha

8 Aug 2024

MariaDB 11.1.6

Stable (GA)

Release Notes

Changelog

16 May 2024

MariaDB 11.1.5

Stable (GA)

Release Notes

Changelog

MDEV-27128
MDEV-7487
MDEV-8320
MDEV-21921
MDEV-30545
mariadb-backup’s
MDEV-18931
MariaDB 11.1
CVE-2024-21096
MariaDB 11.1.5
CVE-2023-22084
MariaDB 11.1.3
MariaDB 11.1

7 Feb 2024

MariaDB 11.1.4
Release Notes
Changelog
MariaDB 11.1.3
Release Notes
Changelog
MariaDB 11.1.2
Release Notes
Changelog
MariaDB 11.1.1
Release Notes
Changelog
MariaDB 11.1.0
Release Notes

MariaDB 11.1.1 Release Notes

The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download NowAlternate download from mariadb.org

Download 11.1.1 | Release Notes | Changelog | Overview of 11.1

Release date: 6 Jun 2023

Do not use non-stable (non-GA) releases in production!

MariaDB 11.1 is the current short-term development series of MariaDB, which will be maintained for one year after the Stable (GA) release. It is an evolution of MariaDB 11.0 with several entirely new features.

MariaDB 11.1.1 is a Release Candidate (RC) release.

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

Thanks, and enjoy MariaDB!

Notable Items

  • The option is now a system variable, and the tx_isolation system variable is deprecated ()

InnoDB

  • Server crashes in st_join_table::choose_best_splitting ()

  • Crash with condition pushable into derived and containing outer reference ()

  • InnoDB does not free UNDO after the fix of ()

  • InnoDB hang fixes (, , )

Optimizer

  • Crash with condition pushable into derived and containing outer reference ( )

  • Crash with for multi-table update of system table ()

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 .

Do not use non-stable (non-GA) releases in production!

is not updated correctly (MDEV-31309)

  • InnoDB monitor trx_rseg_history_len was accidentally disabled by default (MDEV-31308)

  • Revert "MDEV-30473 : Do not allow GET_LOCK() / RELEASE_LOCK() in cluster"

  • MDEV-21921
    MDEV-31403
    MDEV-31240
    MDEV-30671
    MDEV-31234
    MDEV-31158
    MDEV-31343
    MDEV-31350
    MDEV-31403
    MDEV-31240
    MDEV-31224
    MariaDB 11.1.1
    changelog
    MariaDB 11.1.1
    MariaDB Foundation release announcement

    MariaDB 11.1.0 Release Notes

    The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download NowAlternate download from mariadb.org

    Download | Release Notes | Changelog | Overview of 11.1

    Release date: 27 Mar 2023

    Do not use alpha releases in production!

    MariaDB 11.1 is a current development series of MariaDB, and will be maintained for one year after its Generally Available release. It is an evolution of MariaDB 11.0 with several entirely new features.

    MariaDB 11.1.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.1.

    The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.1-preview.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    InnoDB

    • Remove and related parameters ()

    Optimizer

    • for single-table / statements. Update and delete statements that use subqueries can now use all subquery optimization strategies that MariaDB offers, so now if you use subqueries in UPDATE or DELETE, these statements will likely be much faster ()

    • Queries with the or functions comparing against a constant can now make use of indexes, so these will be noticeably quicker in certain instances. For example SELECT * FROM t2 WHERE YEAR(a) = 2019 or SELECT * FROM t2 WHERE DATE(a) <= '2017-01-01' ()

    General

    • ALTER ONLINE TABLE - not released in the final ()

    JSON

    • function for validating a JSON schema ()

    mariadb-backup

    • Rename xtrabackup_* files to mariadb_backup_* ()

    MariaDB 11.1
    What is MariaDB 11.1?
    MDEV-30545
    MDEV-7487
    MDEV-8320
    MariaDB 11.1
    MDEV-16329
    MDEV-27128
    mariadb-backup’s
    MDEV-18931

    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.

    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.

    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.

    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 theWhat is MariaDB 11.1? page.

    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

    • MariaDB Server crashes with ill-formed partitions ()

    • 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

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

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

    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=

    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 .

    )
  • 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)
    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_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-32155
    MDEV-34421
    MDEV-24610
    MDEV-34226
    MDEV-34187
    MDEV-34227
    MDEV-30651
    MDEV-19520
    MDEV-25607
    MDEV-33921
    MDEV-23857
    MDEV-34434
    Galera
    MDEV-32633
    MDEV-34494
    MariaDB Deprecation Policy
    MariaDB 11.1
    IMPORT TABLESPACE
    MDEV-34670
    MariaDB 11.1.6
    changelog
    MariaDB 11.1.6
    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 page.

    MDEV-34167
    MDEV-34541
    MDEV-32376
    MDEV-33265

    MariaDB 11.1.5 Release Notes

    The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download NowAlternate download from mariadb.org

    Download 11.1.5 | Release Notes | Changelog | Overview of 11.1

    Release date: 16 May 2024

    MariaDB 11.1 is a current 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.5 is a Stable (GA) release.

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

    Thanks, and enjoy MariaDB!

    Notable Items

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

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

    • Fix adaptive hash index corruption after ()

    • Server no longer aborts while altering an InnoDB statistics table (

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

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

    • Improve Spider performance by pushing down function () and statement () to data nodes

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

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

    Backup

    • Port backup features from Enterprise Server. This adds support for to , and obsoletes the and options ()

    • now preserves ()

    • Fix problem on older mariadb (opendir(NULL)) caused by ()

    ,

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

    • Default charset now works with PHP MySQLi extension ()

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

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

    JSON

    • View created via now returns correct json object ()

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

    • no longer returns NULL on valid arguments ()

    • no longer returns multiple values for same path ()

    Encryption, TLS, SSL

    • WolfSSL's math is unnecessarily slow ()

    Optimization & Tuning

    • Server crashes in JOIN_CACHE::write_record_data upon EXPLAIN with subqueries and constant tables ()

    • Wrong result with cross Join given join order ()

    • Wrong warnings on 2-nd execution of PS for query with GROUP_CONCAT ()

    • Wrong result with semi-join and splittable derived table ()

    Plugins

    • The now reports the user and host in all cases ()

    Replication

    • --gtid-ignore-duplicate can double-apply event in case of parallel replication retry ()

    • Deadlock kill of XA PREPARE can break replication / rpl.rpl_parallel_multi_domain_xa sporadic failure ()

    • mysql_manager_submit Segfault at Startup Still Possible During Recovery ()

    • Server crash in Rows_log_event::update_sequence upon replaying binary log ()

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

    SQL, Data Definition, and Data Manipulation

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

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

    • Fix incorrect DEFAULT expression evaluated in ()

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

    Platforms & Packaging

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

    General

    Scripts & Clients

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

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

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

    Server

    • Moving from to 10.6 mysql_upgrade is not updating some system tables ()

    • Original IP not shown in network related error messages when proxy_protocol is in use ()

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

    • update case insensitive (large) unique key with insensitive change of value - duplicate key ()

    Security

    • Fixes for the following :

    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 .

    )
  • Fix LeakSanitizer errors in rec_copy_prefix_to_buf (MDEV-33230)

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

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

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

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

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

  • Fix server hang on DROP INDEX or RENAME INDEX (MDEV-33993)

  • Fix mariadb-backup --backup hang (MDEV-33669)

  • Fix server hang caused by InnoDB change buffer (MDEV-33543)

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

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

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

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

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

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

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

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

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

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

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

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

    • New system variable,

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

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

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

  • Fix spider plugin init failure with no_zero_date sql_mode (MDEV-33494)
  • Fix sql plugin init failure with traditional sql_mode (MDEV-33584)

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

  • Fix Spider: ERROR 12710 (HY000): Invalid information from remote table when using MariaDB 10.5 local and MariaDB 10.6 remote (MDEV-33777)

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

  • Fix mariadb-backup --backup FATAL ERROR: ... Can't open datafile cool_down/t3 (MDEV-33011)
  • mariadb-backup --backup now includes retry logic for undo tablespaces (MDEV-33980)

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

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

  • MariaDB Backup now considers O/S user when --user option is omitted (MDEV-32893)

  • )
  • Fixed and problems with (MDEV-21034)

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Loading now works with INPLACE (MDEV-33044)

    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)

  • MDEV-33515
    MDEV-32899
    MDEV-33400
    MDEV-33813
    MDEV-31361
    MDEV-28992
    MDEV-28993
    MDEV-33731
    MDEV-33242
    MariaDB Backup
    no-backup-locks
    rysnc
    MDEV-32932
    MariaDB Backup
    MDEV-33334
    MariaDB Backup
    MDEV-30968
    MDEV-31251
    MDEV-33318
    MDEV-32975
    MDEV-33772
    MDEV-33496
    MDEV-30646
    MDEV-19487
    MDEV-22141
    MDEV-32287
    MDEV-33482
    MDEV-21102
    MDEV-30975
    MDEV-31276
    MDEV-23878
    MDEV-33393
    MDEV-33475
    MDEV-34042
    MDEV-33799
    MDEV-31779
    Galera
    MDEV-33979
    MDEV-18288
    MDEV-30046
    MDEV-33790
    MDEV-33622
    MDEV-32791
    MDEV-21778
    MDEV-33727
    MDEV-4827
    MariaDB 10.5
    MDEV-33726
    MDEV-33506
    MDEV-33469
    MDEV-29345
    CVE-2024-21096
    MariaDB 11.1.5
    changelog
    MariaDB 11.1.5
    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 page.

    MDEV-33462

    MariaDB 11.1.4 Release Notes

    The most recent release of MariaDB 11.1 is:MariaDB 11.1.6 Stable (GA) Download NowAlternate download from mariadb.org

    Download 11.1.4 | Release Notes | Changelog | Overview of 11.1

    Release date: 7 Feb 2024

    MariaDB 11.1 is a current short-term stable series of MariaDB, maintained until August 2024. It is an evolution of MariaDB 11.1 with several entirely new features.

    MariaDB 11.1.4 is a Stable (GA) release.

    For an overview of MariaDB 11.1 see theWhat is MariaDB 11.1? 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) ()

    • Missing required privilege CONNECTION ADMIN ()

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

    • Incorrect result interceptor passed to mysql_explain_union()

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

    • JSON_ARRAYAGG charset issue ()

    Plugins

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

    • Backport SQL service, introduced by ()

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

    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 Fedora 37, Ubuntu 23.04 "Lunar", and Windows Server 2019

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

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

    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 .

    MariaDB 11.1.3 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 13 Nov 2023

    is a current short-term stable series of MariaDB, August 2024. It is an evolution of with several entirely new features.

    is a release.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    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)

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

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

  • innodb_fast_shutdown=0 hang after incomplete startup (MDEV-32798)

  • innodb_undo_log_truncate=ON prevents fast shutdown (MDEV-33062)

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

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

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

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

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

  • path separator near ib_buffer_pool incorrect (MDEV-32983)

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

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

  • Assertion ``end_lsn == page_lsn'failed inrecv_recover_page` (MDEV-33137)

  • Some calls to buf_read_ahead_linear() seem to be useless (MDEV-32068)

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

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

  • innodb_undo_log_truncate=ON is blocking page writes (MDEV-33112)

  • If tables are frequently created, renamed, dropped, a backup cannot be restored (MDEV-32939)
  • on table to be accessible to those with privileges (MDEV-28367)

  • upon PS execution (
    )
  • mysql_json cannot be used on newly created table (MDEV-32235)

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

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

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

  • ASAN errors in spider_conn_queue_and_merge_loop_check (MDEV-29002)

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

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

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

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

  • FOREIGN_KEY_CHECKS does not prevent non-copy alter from creating invalid FK structure (MDEV-29092)
  • 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)

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

  • LONG UNIQUE gives error when used with REPLACE (MDEV-32839)

  • Backport MDEV-32532 to 10.6 (MDEV-32903)

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

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

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

    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)

  • Cluster is inconsistent after SAVEPOINT statement is rolled back (MDEV-32549)

  • WSREP GTID MODE is inconsistent (MDEV-31905)

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

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

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

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

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

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

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

  • Upgrade to 12.6.

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

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

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

  • Wrong user in SET DEFAULT ROLE error (MDEV-26875)

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

  • mysql.slow_log reports incorrect start time (MDEV-11628)

  • Update federated table and column privileges (MDEV-32984)

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

  • Deprecate (MDEV-32617)

  • sys schema view session_ssl_status is empty (MDEV-32751)

  • Memory pressure (MDEV-24670)

  • MDEV-29954
    MDEV-28613
    MDEV-29110
    MDEV-20286
    MDEV-33006
    MDEV-24541
    MDEV-32587
    MDEV-29421
    MDEV-29963
    MDEV-28615
    MDEV-31657
    MDEV-29362
    MDEV-32795
    MDEV-22230
    MDEV-26743
    MDEV-32645
    MDEV-24784
    MDEV-27087
    MDEV-32906
    MDEV-19275
    MDEV-27595
    MDEV-32041
    MDEV-31413
    MDEV-32938
    MDEV-28971
    MDEV-33045
    MDEV-27436
    MDEV-26632
    MariaDB Deprecation Policy
    MariaDB 11.1
    MDEV-32884
    MariaDB 11.1.4
    changelog
    MariaDB 11.1.4
    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 page.

    MDEV-21245
    MDEV-32867
    MDEV-31357
    MDEV-33165
    MDEV-10653
    Notable Items

    InnoDB

    • followed by may corrupt data (MDEV-32132)

    • ROW_FORMAT=COMPRESSED table: InnoDB: 2048 bytes should have been read. Only 0 bytes read. (MDEV-31875)

    • Server aborts during alter operation when table doesn't have foreign index (MDEV-32527)

    • row_merge_fts_doc_tokenize() handles FTS plugin parser inconsistently (MDEV-32578)

    • InnoDB: tried to purge non-delete-marked record of an index on a virtual column prefix ()

    • lock_row_lock_current_waits counter in information_schema.innodb_metrics may become negative ()

    • SET GLOBAL innodb_max_purge_lag_wait=… hangs if innodb_read_only=ON ()

    • Auto-increment no longer works for explicit FTS_DOC_ID ()

    • Assertion `pos < table->n_def' failed in dict_table_get_nth_col ()

    • innochecksum man pages seem to be inconsistent with the binary (10.2.25) ()

    • innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error ()

    • wrong table name in innodb's "row too big" errors ()

    • Optimize is_file_on_ssd() to speedup opening tablespaces on Windows ()

    • Race condition between page write completion and log checkpoint ()

    • After crash recovery, Checksum mismatch + Failing assertion: !i || prev_id + 1 == space_id, ()

    • Deadlock due to log_free_check(), involving trx_purge_truncate_rseg_history() and trx_undo_assign_low() ()

    • Write-ahead logging is broken for freed pages ()

    • X-lock on supremum for prepared transaction for RR ()

    • Assertion failures in log_sort_flush_list upon crash recovery ()

    • Race condition between page write completion and log checkpoint ()

    • Assertion `purge_sys.tail.trx_no <= purge_sys.rseg->last_trx_no()' ()

    • Assertion `index->is_btree() || index->is_ibuf()' failed in btr_search_guess_on_hash ()

    • InnoDB hang in buf_flush_wait_LRU_batch_end() ()

    • InnoDB may hang when running out of buffer pool ()

    • Corrupt index(es) on busy table when using FOREIGN KEY ()

    • InnoDB Recovery doesn't display encryption message when no encryption configuration passed ()

    • Wrong information about innodb_checksum_algorithm in the information_schema.SYSTEM_VARIABLES ()

    • InnoDB may fail to recover after being killed in fil_delete_tablespace() ()

    • Create separate tpool thread for async aio ()

    • UNDO logs still growing for write-intensive workloads ()

      • Increase the default for from 300 to 1000 ()

      • Deprecate .

      • The motivation for introducing this in MySQL seems to have been to avoid stalls due to freeing undo log pages or truncating undo log tablespaces. In MariaDB, should be a much lighter operation because it will not involve any log checkpoint. (

    • Slow full index scan in 10.6 vs 10.5 for the (slow) I/O-bound case ()

    • LOAD DATA into InnoDB w/partitions: huge performance loss, affected 10.6+ ()

    • Disable read-ahead for temporary tablespace ()

    Optimizer

    • New setting, cset_narrowing, to enable the (MDEV-32113)

    • Crash when HAVING in a correlated subquery references columns in the outer query (MDEV-29731)

    • Server crashes at TABLE::add_tmp_key (MDEV-32320)

    • Server crashes inside filesort at my_decimal::to_binary ()

    • Assertion `bitmap_is_set(&m_part_info->read_partitions, m_part_spec.start_part)' failed in ha_partition::handle_ordered_index_scan ()

    • Crash when searching for the best split of derived table ()

    • Test case from opt_tvc.test fails with statement memory protection ()

    • Significant slowdown for query with many outer joins ()

    • test_if_skip_sort_order() should catch the join types JT_EQ_REF, JT_CONST and JT_SYSTEM and skip sort order for these ()

    • jointable materialization subquery optimization ignoring errors, then failing ASSERT. ()

    • Server crashes in JOIN::cleanup after erroneous query with view ()

    • Prepared statement return wrong result (missing row) ()

    • Assertion `range->rows >= s->found_records' failed in best_access_path ()

    Replication

    • rpl.rpl_parallel_temptable failure due to incorrect commit optimization of temptables (MDEV-10356)

    • Lock wait timeout with INSERT-SELECT, autoinc, and statement-based replication (MDEV-31482)

    • strings/ctype-ucs2.c:2336: my_vsnprintf_utf32: Assertion `(n % 4) == 0' failed in my_vsnprintf_utf32 on INSERT (MDEV-32249)

    • Assertion fails in MDL_context::acquire_lock upon parallel replication of CREATE SEQUENCE (MDEV-31792)

    • SHOW SLAVE STATUS Last_SQL_Errno Race Condition on Errored Slave Restart ()

    • seconds_behind_master is inaccurate for Delayed replication ()

    • detailize the semisync replication magic number error ()

    • Parallel replication deadlock victim preference code errorneously removed ()

    • Parallel replication lags because innobase_kill_query() may fail to interrupt a lock wait ()

    Galera

    • Galera updated to 26.4.16

    • Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed. (MDEV-24912)

    • Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failed (MDEV-31285)

    • wsrep_sst_mariadb-backup not working on FreeBSD (MDEV-31467)

    • Galera library 26.4.16 fails with every server version ()

    • Galera node remains paused after interleaving FTWRLs ()

    • Failed to insert streaming client ()

    • When set at runtime, accepts any value ()

    • galera needs packaging script changes to successfully build ()

    • replication breaks when using optimistic replication and replica is a galera node ()

    • McAfee database vulnerability scan caused MariaDB crash with signal 6 (system abort) ()

    • Assertion `mode_ == m_local || transaction_.is_streaming()' failed in int wsrep::client_state::bf_abort(wsrep::seqno) ()

    Data Definition

    • MariaDB crash on calling function (MDEV-23902)

    • ASAN errors in grn_obj_unlink / ha_mroonga::clear_indexes upon index operations (MDEV-31970)

    • vcol circular references lead to stack overflow (MDEV-31112)

    • OPTIMIZE TABLE crash (MDEV-28122)

    • Server crashes in Alter_info::add_stat_drop_index upon CREATE TABLE ()

    Scripts and Clients

    • (mysqlbinlog) option (MDEV-25369)

    • (mysqladmin) wrong error with (MDEV-22418)

    • shows warning on missing directory $pamtooldir/auth_pam_tool_dir (MDEV-32142)

    • main.mysql_client_test, main.mysql_client_test_comp failed on ASAN build with error: 5888, status: 23, errno: 2 (MDEV-19369)

    • (mysql_install_db) doesn't properly grant to all default root user accounts ()

    Tests

    • main.events_stress or events.events_stress fails with view-protocol (MDEV-31455)

    • main.delete_use_source fails (hangs) with view-protocol (MDEV-31457)

    • main.sum_distinct-big and main.merge-big fail with timeout with view-protocol (MDEV-31465)

    • main.secure_file_priv_win fails with 2nd execution PS protocol (MDEV-32023)

    • Windows : mtr output on is messed up with large MTR_PARALLEL ()

    • main.mysql_client_test_comp failed in buildbot, error on exec ()

    • main.order_by_pack_big fails with view-protocol ()

    • mysql_install_db_win.test fails on second execution ()

    mariadb-backup

    • mariadb-backup full backup failed with InnoDB: Failing assertion: success in storage/innobase/fil/fil0fil.cc line 657 (MDEV-18200)

    • mbstream breaks page compression on XFS (MDEV-25734)

    Character Sets, Data Types, Collations

    • Prefix keys for CHAR work differently for MyISAM vs InnoDB (MDEV-30048)

    • Inconsistent results of DISTINCT with NOPAD (MDEV-30050)

    • Assertion `(length % 4) == 0' failed in my_lengthsp_utf32 on INSERT (MDEV-28835)

    • Compressed varchar values lost on joins when sorting on columns from joined table(s) (MDEV-31724)

    • UBSAN shift exponent X is too large for 64-bit type 'long long int' in sql/field.cc ()

    • Wrong bit encoding using COALESCE ()

    Spider

    • Spider UBSAN runtime error: applying non-zero offset x to null pointer in st_spider_param_string_parse::restore_delims (MDEV-31117)

    • Segfault when setting spider_delete_all_rows to 0 and delete all rows of a spider table, ASAN heap-use-after-free in spider_db_delete_all_rows (MDEV-31996)

    • ASAN errors in spider_fields::free_conn_holder or spider_create_group_by_handler (MDEV-28998)

    • ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801 ()

    General

    • option breaks importing sql dumps (MDEV-29989)

    • Crashes in MDL_key::mdl_key_init with lower-case-table-names=2 (MDEV-32025)

    • getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO (MDEV-32275)

    • Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT (MDEV-17711)

    • main.mysqlcheck fails on ARM with ASAN use-after-poison in my_mb_wc_filename ()

    • main.delayed fails with wrong error code or timeout when executed after main.deadlock_ftwrl ()

    • Assertion failed: !pfs->m_idle || (state == PSI_SOCKET_STATE_ACTIVE) ()

    • MyISAM wrong server status flags ()

    • Server crashes in check_sequence_fields upon CREATE TABLE .. SEQUENCE=1 AS SELECT .. ()

    • slow log Rows_examined out of range ()

    • "rpm --setugids" breaks PAM authentication ()

    • incorrect examined rows in case of stored function usage ()

    • Compilation failing on MacOS (unknown warning option -Wno-unused-but-set-variable) ()

    • Server crash upon inserting into Mroonga table with compressed column ()

    • hash unique corrupts index on virtual blobs ()

    • insert into an empty table fails with hash unique ()

    • Valgrind/MSAN warnings in dynamic_column_update_move_left ()

    • Memory leak showed in test suite ()

    • Test from subselect.test fails with statement memory protection ()

    • Memory leak when executing PS for query with IN subquery ()

    • Allow the setting of Auto_increment on FK referenced columns ()

    • mariadb-upgrade fails with sql_safe_updates = on ()

    • Assertion `!(thd->server_status & (1U | 8192U))' failed in MDL_context::release_transactional_locks ()

    • Information schema leaks table names and structure to unauthorized users ()

    • Missing CHACHA20-POLY1305 support in WolfSSL ()

    • incorrect error about cyclic reference about JSON type virtual column ()

    • Disable TLS v1.0 and 1.1 for MariaDB ()

    • Better indication of refusing to start because of ProtectHome ()

    • Database upgrade fails: slow_log table ()

    • myrocks_hotbackup.1 and test suite files installed when engine is disabled ()

    • client_ed25519.dll isn't inluded for HeidiSQL. ()

    • Assertion `!m_null_value' failed in int FixedBinTypeBundle::cmp_item_fbt::compare or in cmp_item_inet6::compare ()

    • type_test.type_test_double fails with 'NUMERIC_SCALE NULL' ()

    • LeakSanitizer errors in get_quick_select or Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed ()

    • Update signal hander user info more compassion and correct url ()

    • maria-install-db fails on MacOS ()

    • MSAN / Valgrind errors in Item_func_like::get_mm_leaf upon query from partitioned table ()

    • MSAN / Valgrind errors in Item_func_like::get_mm_leaf with temporal field ()

    • ASAN errors in base_list_iterator::next / setup_table_map upon 2nd execution of PS ()

    • safe_mutex: Found wrong usage of mutex 'LOCK_thd_data' and 'wait_mutex' ()

    Docker Official Images

    • Invert single and double quotes for sql command definitions in due to failure under - contribution by Dominik Häckel

    • --no-defaults behaviour was corrected - reported by Dominik Häckel

    • Added /docker-entrypoint-init.d for tar{,compression} from MariaDB Backup -

    • Refactor docker_mariadb_init in the entrypoint for extending the MariaDB image

    • CIS failure due to world-writable directory /var/run/mysqld, added sticky bit - reported by @ollie1

    • Add for root@MARIADB_ROOT_HOST - reported by Matthieu Gusmini

    • added --galera_online test, to match what the does.

    Variables

    • Added the system variable to manage notes when an index cannot be used.

    Security

    • Fixes for the following :

      • CVE-2023-22084

    Changelog

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

    Contributors

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

    MariaDB 11.1
    MariaDB 11.1.6
    Download Now
    Alternate download from mariadb.org
    Download 11.1.3
    Release Notes
    Changelog
    Overview of 11.1
    MariaDB 11.1
    maintained until
    MariaDB 11.1
    MariaDB 11.1.3
    Stable (GA)
    MariaDB 11.1
    What is MariaDB 11.1?

    Be notified of new MariaDB Server releases automatically by 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.

    MariaDB 11.1.2 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 21 Aug 2023

    is a current short-term stable series of MariaDB, August 2024. It is an evolution of with several entirely new features.

    is a release.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    )
    MDEV-30024
    MDEV-30658
    MDEV-31813
    MDEV-32017
    MDEV-32337
    MDEV-20583
    MDEV-30825
    MDEV-32128
    MDEV-32228
    MDEV-32511
    MDEV-31851
    MDEV-32049
    MDEV-32552
    MDEV-30165
    MDEV-32029
    MDEV-32511
    MDEV-30100
    MDEV-30802
    MDEV-32134
    MDEV-32588
    MDEV-30531
    MDEV-31098
    MDEV-31473
    MDEV-31826
    MDEV-31095
    MDEV-32050
    MDEV-32050
    MDEV-30986
    MDEV-31835
    MDEV-32145
    MDEV-32324
    MDEV-24283
    MDEV-32064
    MDEV-32225
    MDEV-32351
    MDEV-32475
    MDEV-31983
    MDEV-32164
    MDEV-9938
    MDEV-32682
    MDEV-31177
    MDEV-32265
    MDEV-32365
    MDEV-31655
    MDEV-32096
    MDEV-32024
    MDEV-32282
    MDEV-32051
    MDEV-31470
    MDEV-32642
    MDEV-31833
    MDEV-27004
    MDEV-30217
    MDEV-32449
    MDEV-21194
    MDEV-32387
    MDEV-16641
    MDEV-31460
    MDEV-32232
    MDEV-32226
    MDEV-32244
    MDEV-29502
    MDEV-26494
    MDEV-27523
    MDEV-28561
    MDEV-28820
    MDEV-29771
    MDEV-30820
    MDEV-30904
    MDEV-31742
    MDEV-31890
    MDEV-31966
    MDEV-32012
    MDEV-32015
    MDEV-32140
    MDEV-6146
    MDEV-32223
    MDEV-32245
    MDEV-32369
    MDEV-32018
    MDEV-29914
    MDEV-32541
    MDEV-32500
    MDEV-31653
    MDEV-32586
    MDEV-31369
    MDEV-25177
    MDEV-27757
    MDEV-29993
    MDEV-31315
    MDEV-27207
    MDEV-22243
    MDEV-32476
    MDEV-32535
    MDEV-31871
    MDEV-32388
    MDEV-32531
    MDEV-32656
    MDEV-32728
    mariadb-operator
    subscribing
    MDEV-32050
    Notable Items

    Localization

    • Create Swahili (MDEV-31530)

    Upgrading from MySQL

    • MariaDB now detects and converts previously incompatible MySQL partition schemes (MDEV-29253)

    General

    • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 11.1 for Ubuntu 18.04 LTS "Bionic" and Ubuntu 22.10 "Kinetic"

    • In this release repositories for Debian 12 "Bookworm" have been added.

    • doesn't ignore error as it should (MDEV-31092)

    • 280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode (MDEV-26186)

    • SQL/PL package body does not appear in I_S.ROUTINES.ROUTINE_DEFINITION ()

    • Unexpected result when combining , subselect and ()

    • variables do not get assigned from subselects ()

    • Crash after setting global session_track_system_variables to an invalid value ()

    • ODKU of non-versioning column inserts history row ()

    • UPDATE not working properly on transaction precise system versioned table ()

    • Assertion ``const_item_cache == true'failed inItem_func::fix_fields` ()

    • ANALYZE doesn't work with pushed derived tables ()

    • get_partition_set is never executed in ha_partition::multi_range_key_create_key due to bitwise & with 0 constant ()

    • Client can crash the server with a mysql_list_fields("view") call ()

    • not immediately changed updated after procedure change ()

    • bzero wipes more bytes than necessary in set_global_from_ddl_log_entry ()

    • Assertion ``0'failed inType_handler_row::field_typeuponTO_CHAR` with wrong argument ()

    • fails due to old_mode="", with "Cannot load from mysql.proc. The table is probably corrupted" ()

    Character Sets, Data Types

    • UBSAN: null pointer passed as argument 1, which is declared to never be null in my_strnncoll_binary on SELECT ... COUNT or GROUP_CONCAT (MDEV-28384)

    • Possibly wrong result or Assertion 0' failed in Item_func_round::native_op` (MDEV-23838)

    • Assertion ``(length % 4) == 0'failed inmy_lengthsp_utf32onSELECT` ()

    • UBSAN: negation of -X cannot be represented in type 'long long int'; cast to an unsigned type to negate this value to itself in Item_func_mul::int_op and Item_func_round::int_op ()

    • Assorted assertion failures in json_find_path with certain collations ()

    InnoDB

    • Crashing on I/O error is unhelpful (MDEV-27593)

    • SIGSEGV in log_sort_flush_list() in InnoDB crash recovery (MDEV-31354)

    • InnoDB tables are being flagged as corrupted on an I/O bound server (MDEV-31767)

    • Duplicate entry allowed into a ()

    • Server Status is reported in seconds ()

    • dies with Floating point exception ()

    • Add InnoDB engine information to the ()

    • Deadlock with 3 concurrent by ()

    • innodb protection against dual processes accessing data insufficient ()

    • ER_DUP_KEY in upon on ()

    • Assertion ``!strcmp(index->table->name.m_name, "SYS_FOREIGN") || !strcmp(index->table->name.m_name, "SYS_FOREIGN_COLS")'failed inbtr_node_ptr_max_size` ()

    • InnoDB: Failing assertion: page_type == i_s_page_type[page_type].type_value ()

    • btr_estimate_n_rows_in_range() accesses unfixed, unlatched page ()

    • MODIFY COLUMN can break FK constraints, and lead to unrestorable dumps ()

    • Recovery or backup failure after ()

    • Assertion 'n & PENDING' failed in fil_space_t::set_needs_flush() ()

    • fil_node_open_file() releases fil_system.mutex allowing other thread to open its file node ()

    • ASAN errors in dict_v_col_t::detach upon adding key to virtual column ()

    • Purge trying to access freed secondary index page ()

    • Freed data pages are not always being scrubbed ()

    • InnoDB recovery hangs after reporting corruption ()

    • !cursor->index->is_committed() in row0ins.cc after update to 10.4.13 from 10.3.21 ()

    • fails to wait for purge of enough transaction history ()

    • SET GLOBAL does not free space when no undo logs exist ()

    • (linear read-ahead) does not work ()

    • InnoDB recovery and mariadb-backup --prepare fail to report detailed progress ()

    • fil_ibd_create() may hijack the file handle of an old file ()

    • recovery results in a corrupted undo log ()

    • Server freeze due to and ()

    • entries are left behind when freeing a page, causing secondary index corruption when the page is later reused ()

    • Foreign Key Constraint actions don't affect ()

    Aria

    • Various crashes upon INSERT/UPDATE after changing settings (MDEV-28054)

    • Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded (MDEV-26258)

    Spider

    • SIGSEGV in spider_db_open_item_field and SIGSEGV in spider_db_print_item_type, on SELECT (MDEV-29447)

    • that double as table params overriding mechanism is buggy (MDEV-31524)

    Optimizer

    • InnoDB engine statistics for each table (MDEV-31577)

    • Assertion ``last_key_entry >= end_pos'failed in virtual boolJOIN_CACHE_HASHED::put_record()` (MDEV-31348)

    • Problem with open ranges on prefix blobs keys (MDEV-31800)

    • Equal on two create wrong result ()

    • Recursive CTE execution is interrupted without errors or warnings ()

    • Assertion ``s->table->opt_range_condition_rows <= s->found_records'failed inapply_selectivity_for_table` ()

    • Inconsistency between MRR and SQL layer costs can cause poor query plan ()

    • MAX_SEL_ARG memory exhaustion is not visible in the optimizer trace ()

    • not working properly with ()

    • Segfault on select query using index for group-by and filesort ()

    • Server crash in store_length, assertion failure in Type_handler_string_result::sort_length ()

    Replication

    • Parallel Slave SQL Thread Can Update Seconds_Behind_Master with Active Workers (MDEV-30619)

    • ends up in optimistic parallel slave binlog out-of-order (MDEV-31503)

    • takes very long time on a busy system (MDEV-13915)

    • On slave fail to return an error in read-only mode (MDEV-30978)

    • Calling a function from a different database in a slave side trigger crashes ()

    • rpl.rpl_manual_change_index_file occasionally fails in BB with Result length mismatch ()

    Galera

    • Node never returns from Donor/Desynced to Synced when wsrep_mode = BF_ABORT_mariadb-backup (MDEV-31737)

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

    • KILL QUERY maintains nodes data consistency but breaks GTID sequence (MDEV-31075)

    • Assertion failure !lock.was_chosen_as_deadlock_victim in trx0trx.h:1065 ()

    • MariaDB stuck on starting commit state (waiting on commit order critical section) ()

    • Assertion state() == s_aborting || state() == s_must_replay failed in int wsrep::transaction::after_rollback() ()

    • Assertion !wsrep_has_changes(thd) || (thd->lex->sql_command == SQLCOM_CREATE_TABLE && !thd->is_current_stmt_binlog_format_row()) || thd->wsrep_cs().transaction().state() == wsrep::transaction::s_aborted failed ()

    • Server crashes when wsrep_sst_donor and wsrep_cluster_address set to NULL ()

    • Create temporary sequence can cause inconsistency ()

    • Galera 4 unable to query cluster state if not primary component ()

    Security

    • Fixes for the following :

      • CVE--``#

    Changelog

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

    Contributors

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

    MariaDB 11.1
    MariaDB 11.1.6
    Download Now
    Alternate download from mariadb.org
    Download 11.1.2
    Release Notes
    Changelog
    Overview of 11.1
    MariaDB 11.1
    maintained until
    MariaDB 11.0
    MariaDB 11.1.2
    Stable (GA)
    MariaDB 11.1
    What is MariaDB 11.1?

    Be notified of new MariaDB Server releases automatically by 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.

    MDEV-30662
    MDEV-28285
    MDEV-31250
    MDEV-25237
    MDEV-23100
    MDEV-25644
    MDEV-31319
    MDEV-29284
    MDEV-24712
    MDEV-30159
    MDEV-31064
    MDEV-31521
    MDEV-29152
    MDEV-28915
    MDEV-29019
    MDEV-30932
    MDEV-23187
    MDEV-31120
    MDEV-29311
    MDEV-31641
    MDEV-31558
    MDEV-10962
    MDEV-31568
    MDEV-31607
    MDEV-19216
    MDEV-31386
    MDEV-30648
    MDEV-31086
    MDEV-31487
    MDEV-31442
    MDEV-31256
    MDEV-31416
    MDEV-31264
    MDEV-31253
    MDEV-31353
    MDEV-22739
    MDEV-31355
    MDEV-31382
    MDEV-29967
    MDEV-29911
    MDEV-31347
    MDEV-31373
    MDEV-31088
    MDEV-31385
    MDEV-18114
    MDEV-20010
    MDEV-31214
    MDEV-31449
    MDEV-31479
    MDEV-30964
    MDEV-30765
    MDEV-30143
    MDEV-31743
    MDEV-29894
    MDEV-30214
    MDEV-30963
    MDEV-29293
    MDEV-30013
    MDEV-30388
    MDEV-28433
    MDEV-31335
    MDEV-21479
    subscribing
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    wsrep_sst_method
    Upgrading Between Major MariaDB Versions
    Upgrading from MariaDB 11.0 to MariaDB 11.1
    JSON_SCHEMA_VALID
    Semi-join optimization
    UPDATE
    DELETE
    DATE
    YEAR
    Sargable DATE and YEAR
    transaction_isolation
    innodb_defragment
    System Variables Added in MariaDB 11.1
    Security Vulnerabilities Fixed in MariaDB
    transaction_isolation
    EXPLAIN EXTENDED
    security vulnerabilities
    Innodb_buffer_pool_read_requests
    innodb_defragment
    Semi-join optimization
    UPDATE
    DELETE
    DATE
    YEAR
    JSON_SCHEMA_VALID
    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
    security vulnerabilities
    --init-rpl-role
    semisync recovery
    mariadb-secure-installation
    mariadb-install-db
    Triggers
    sandbox mode
    --binary-mode
    mariadb-dump
    sandbox
    innodb_log_spin_wait_delay
    ALTER TABLE…DISCARD TABLESPACE
    Aria
    Federated
    Spider
    TIMESTAMPDIFF
    CASE
    BACKUP STAGE
    innodb_encrypt_tables
    Character Sets
    Data Types
    ORDER BY
    GROUP_CONCAT
    AVG
    YEAR
    datetime
    JSON_ARRAYAGG
    JSON_TYPE
    JSON_REMOVE
    JSON_EXTRACT
    audit plugin
    AUTO_INCREMENT
    UPDATE
    mariadb --sandbox
    mariadb-dump
    mariadb-dump
    security vulnerabilities
    innodb_snapshot_isolation
    Spider variables
    innodb_log_file_size
    GREATEST()
    LEAST()
    NULLs
    UPDATE
    TIMESTAMP
    strict mode
    AVG
    YEAR
    datetime
    time zones
    alter_algorithm
    SQL Error Log Plugin
    sql_error_log_with_db_and_thread_info
    s3_debug
    s3_protocol_version
    OLD_MODE
    SHOW COLLATION
    security vulnerabilities
    BACKUP LOCKS
    database LOCK TABLES
    spider_table_crd_thread_count
    spider_table_sts_thread_count
    optimizer_adjust_secondary_key_costs
    HeidiSQL
    secure_auth=0
    DROP INDEX
    CREATE INDEX
    optimizer_switch
    Charset Narrowing Optimization
    mariadb-binlog -T/--table
    mariadb-admin
    simple_password_check
    mariadb-install-db
    binlog_do_db
    healthcheck.sh
    sql_mode=ANSI_QUOTES
    healthcheck.sh
    instructions
    note_verbosity
    security vulnerabilities
    innodb_purge_batch_size
    innodb_purge_rseg_truncate_frequency
    innodb_undo_log_truncate=ON
    mariadb-install-db
    proxy privileges
    PROXY privileges
    healthcheck.sh
    localization
    mariadb-dump --force
    UNIQUE column
    Aria
    Spider variables
    ANALYZE FORMAT=JSON now includes
    ALTER SEQUENCE
    STOP SLAVE
    XA COMMIT/XA ROLLBACK
    security vulnerabilities
    DISTINCT
    LIMIT
    ROW
    I_S.parameters
    mariadb-upgrade
    Innodb_row_lock_time%
    innochecksum
    slow query log
    DELETEs
    unique key
    mysql.innodb_table_stats
    RENAME
    sequence
    innodb_undo_log_truncate=ON
    innodb_undo_log_truncate=ON
    innodb_undo_log_truncate=ON
    innodb_read_ahead_threshold
    innodb_undo_log_truncate=ON
    innodb_change_buffering
    innodb_file_per_table=0
    Change buffer
    Virtual Column
    RANK
    window functions
    SHOW TABLES
    lower_case_table_names=2

    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