# MariaDB 10.11.3 Release Notes

{% hint style="info" %}

<p align="center">The most recent release of MariaDB 10.11 is:</p>

<h4 align="center"><a href="mariadb-10.11.14-release-notes"><strong>MariaDB 10.11.14</strong></a> Stable (GA) <a href="https://mariadb.com/downloads/" class="button primary">Download Now</a></h4>

<p align="center"><a href="https://downloads.mariadb.org/mariadb/10.11.14/"><sub><em>Alternate download from mariadb.org</em></sub></a></p>
{% endhint %}

<a href="https://downloads.mariadb.org/mariadb/10.11.3/" class="button primary">Download</a> <a href="mariadb-10-11-3-release-notes" class="button secondary">Release Notes</a> <a href="../changelogs/changelogs-mariadb-10-11-series/mariadb-10-11-3-changelog" class="button secondary">Changelog</a> <a href="what-is-mariadb-1011" class="button secondary">Overview of 10.11</a>

**Release date:** 10 May 2023

[MariaDB 10.11](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/mariadb-10-11-series/what-is-mariadb-1011) is the current long term maintenance development series of MariaDB, [maintained until](https://mariadb.org/about/#maintenance-policy) February 2028. It is an evolution of [MariaDB 10.10](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/old-releases/release-notes-mariadb-10-10-series/what-is-mariadb-1010) with several entirely new features.

[MariaDB 10.11.3](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/mariadb-10-11-series/mariadb-10-11-3-release-notes) is a [***Stable (GA)***](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/about/release-criteria) release.

**For an overview of** [**MariaDB 10.11**](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/mariadb-10-11-series/what-is-mariadb-1011) **see the** [**What is MariaDB 10.11?**](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/mariadb-10-11-series/what-is-mariadb-1011) **page.**

Thanks, and enjoy MariaDB!

## Notable Items

### InnoDB

* Crash on [ROLLBACK](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/transactions/rollback) in a [ROW\_FORMAT=COMPRESSED](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb/innodb-row-formats/innodb-compressed-row-format) table ([MDEV-30882](https://jira.mariadb.org/browse/MDEV-30882))
* UNIQUE USING HASH accepts duplicate entries for tricky collations ([MDEV-30034](https://jira.mariadb.org/browse/MDEV-30034))
* rec\_get\_offsets() is not optimal ([MDEV-30567](https://jira.mariadb.org/browse/MDEV-30567))
* Performance regression in fil\_space\_t::try\_to\_close() introduced in [MDEV-23855](https://jira.mariadb.org/browse/MDEV-23855) ([MDEV-30775](https://jira.mariadb.org/browse/MDEV-30775))
* InnoDB recovery hangs when buffer pool ran out of memory ([MDEV-30551](https://jira.mariadb.org/browse/MDEV-30551))
* InnoDB undo log truncation fails to wait for purge of history ([MDEV-30671](https://jira.mariadb.org/browse/MDEV-30671)
* MariaDB crash due to DB\_FAIL reported for a corrupted page ([MDEV-30397](https://jira.mariadb.org/browse/MDEV-30397))
* Deadlock between INSERT and InnoDB non-persistent statistics update ([MDEV-30638](https://jira.mariadb.org/browse/MDEV-30638))
* InnoDB hang on B-tree split or merge ([MDEV-29835](https://jira.mariadb.org/browse/MDEV-29835))
* Performance regression in locking reads from secondary indexes ([MDEV-30357](https://jira.mariadb.org/browse/MDEV-30357))
* Improve adaptive flushing ([MDEV-26055](https://jira.mariadb.org/browse/MDEV-26055))
* Make page flushing even faster ([MDEV-26827](https://jira.mariadb.org/browse/MDEV-26827))
* Purge misses a chance to free not-yet-reused undo pages ([MDEV-29593](https://jira.mariadb.org/browse/MDEV-29593))
* InnoDB temporary tablespace: reclaiming of free space does not work ([MDEV-26782](https://jira.mariadb.org/browse/MDEV-26782))
* Deadlock between CHECK TABLE and bulk insert ([MDEV-30798](https://jira.mariadb.org/browse/MDEV-30798))
* [UPPER()](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/string-functions/upper) returns an empty string for U+0251 in uca1400 collations for utf8 ([MDEV-30661](https://jira.mariadb.org/browse/MDEV-30661))
* System-wide max transaction id corrupted after changing the undo tablespaces ([MDEV-30311](https://jira.mariadb.org/browse/MDEV-30311))
* Fix miscount of doublewrites by [Innodb\_data\_written](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/system-variables/innodb-status-variables#innodb_data_written) ([MDEV-31124](https://jira.mariadb.org/browse/MDEV-31124))

### Backup

* mariadb-backup doesn't utilise innodb-undo-log-directory (if specified as a relative path) during copy-back operation ([MDEV-28187](https://jira.mariadb.org/browse/MDEV-28187))
* mariadb-backup issues error messages during InnoDB tablespaces export on partial backup preparing ([MDEV-29050](https://jira.mariadb.org/browse/MDEV-29050))
* mariadb-backup does not copy Aria logs if aria\_log\_dir\_path is used ([MDEV-30968](https://jira.mariadb.org/browse/MDEV-30968))
* Race condition between buffer pool flush and log file deletion in mariadb-backup --prepare ([MDEV-30860](https://jira.mariadb.org/browse/MDEV-30860))

### Replication

* Fixed a deadlock on parallel slave involving full image Write event on the sequence engine ([MDEV-29621](https://jira.mariadb.org/browse/MDEV-29621))
* Fixed an attempted out-of-order binlogging error on slave involving ALTER on the sequence engine ([MDEV-31077](https://jira.mariadb.org/browse/MDEV-31077))
* Corrected non-versioned master to versioned slave replication on no-unique attribute table ([MDEV-30430](https://jira.mariadb.org/browse/MDEV-30430))
* Mended encrypted binlog master to error out to gtid-mode slave when master could not decrypt a binlog file ([MDEV-28798](https://jira.mariadb.org/browse/MDEV-28798))
* Refined optimistic parallel slave to error-exit without any hang ([MDEV-30780](https://jira.mariadb.org/browse/MDEV-30780))
* Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always intialized ([MDEV-30620](https://jira.mariadb.org/browse/MDEV-30620))
* Fixed the slave applier to report a correct error when gtid\_slave\_pos insert fails for some (engine) reasons ([MDEV-31038](https://jira.mariadb.org/browse/MDEV-31038))
* Made parallel slave reports in performance schema consistent with that of show-slave-status ([MDEV-26071](https://jira.mariadb.org/browse/MDEV-26071))

### Optimizer

* [Split Materialized](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/lateral-derived-optimization) optimization is improved to re-fill the materialized table only if necessary. The fewer number of table refills is taken into account when choosing query plan, too ([MDEV-26301](https://jira.mariadb.org/browse/MDEV-26301))
* New optimizer\_switch option, [hash\_join\_cardinality](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/hash_join_cardinality-optimizer_switch-flag), is added. It is off by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. ([MDEV-30812](https://jira.mariadb.org/browse/MDEV-30812))
* Queries using `SELECT DISTINCT some_expression(aggregate_function())` could produce wrong query result. ([MDEV-20057](https://jira.mariadb.org/browse/MDEV-20057))
* [ANALYZE FORMAT=JSON](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-format-json) now prints more information about [Block Nested Loop joins](https://github.com/mariadb-corporation/docs-server/blob/test/release-notes/mariadb-community-server-release-notes/mariadb-10-11-series/broken-reference/README.md): `block-nl-join` element now has `r_loops`, `r_effective_rows` and `r_other_time_ms` fields ([MDEV-30806](https://jira.mariadb.org/browse/MDEV-30806), [MDEV-30972](https://jira.mariadb.org/browse/MDEV-30972)).
* A GROUP BY query with `MIN(primary_key)` in select list and `primary_key<>const` in the WHERE could produce wrong result when executed with "Using index for group-by" strategy ([MDEV-30605](https://jira.mariadb.org/browse/MDEV-30605))
* EXPLAIN could erroneously report that [Rowid Filter optimization](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/rowid-filtering-optimization) is used for partitioned tables. Partitioned tables do not support it. ([MDEV-30596](https://jira.mariadb.org/browse/MDEV-30596))
* A bug in selectivity computations for SINGLE/DOUBLE\_PREC\_HB histograms could cause wrong estimates to be produced. This could cause the optimizer to pick sub-optimal query plans ([MDEV-31067](https://jira.mariadb.org/browse/MDEV-31067)).

### Docker Official Image

* Add replication setup to containers contributed by Md Sahil ([MDEV-29762](https://jira.mariadb.org/browse/MDEV-29762))
* Added LTS tags for easier identification of LTS releases:
  * lts-jammy
  * lts

### General

* As per the [MariaDB Deprecation Policy](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/about/platform-deprecation-policy), this will be the last release of [MariaDB 10.11](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/mariadb-10-11-series/what-is-mariadb-1011) for Fedora 36.
* In this release repositories for Fedora 38 and Ubuntu 23.04 Lunar have been added.

### Security

* Fixes for the following [security vulnerabilities](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/securing-mariadb/security):
  * [CVE-2022-47015](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-47015)

## Changelog

For a complete list of changes made in [MariaDB 10.11.3](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/mariadb-10-11-series/mariadb-10-11-3-release-notes), with links to detailed\
information on each push, see the [changelog](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/changelogs/changelogs-mariadb-10-11-series/mariadb-10-11-3-changelog).

## Contributors

For a full list of contributors to [MariaDB 10.11.3](https://gitbook-v2-q3lwp8faq-gitbook.vercel.app/url/mariadb.com/docs/release-notes/community-server/mariadb-10-11-series/mariadb-10-11-3-release-notes), see the [MariaDB Foundation release announcement](https://mariadb.org/mariadb-10-11-3-10-10-4-10-9-6-10-8-8-10-6-13-10-5-20-10-4-29-and-10-3-39-now-available/).

{% hint style="info" %}
Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) 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](https://app.gitbook.com/s/WCInJQ9cmGjq1lsTG91E/distributions-including-mariadb) page.
{% endhint %}

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formid="4316" formId="4316" %}
