> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/old-releases/10.2/10.2.24.md).

# MariaDB 10.2.24 Release Notes

The most recent release of [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) is:[**MariaDB 10.2.44**](/docs/release-notes/community-server/old-releases/10.2/10.2.44.md) Stable (GA) [Download Now](https://downloads.mariadb.org/mariadb/10.2.44/)

[Download](https://downloads.mariadb.org/mariadb/10.2.24) | [Release Notes](/docs/release-notes/community-server/old-releases/10.2/10.2.24.md) | [Changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-102-series/mariadb-10224-changelog.md) | [Overview of 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md)

**Release date:** 9 May 2019

[MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) is the previous stable series of MariaDB. It is an evolution of [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6 and 5.7.

[MariaDB 10.2.24](/docs/release-notes/community-server/old-releases/10.2/10.2.24.md) is a [***Stable (GA)***](/docs/release-notes/community-server/about/release-criteria.md) release.

**For an overview of** [**MariaDB 10.2**](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) **see the**[**What is MariaDB 10.2?**](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) **page.**

Upgrading from earlier 10.2.x versions is **highly recommended** for all**Galera** users due to bug [MDEV-12837](https://jira.mariadb.org/browse/MDEV-12837) which caused serious stability issues with earlier versions. See the bug issue page for more information.

Thanks, and enjoy MariaDB!

## Notable Changes

### General server

* [MDEV-18968](https://jira.mariadb.org/browse/MDEV-18968) - Both `(WHERE 0.1)` and `(WHERE NOT 0.1)` return empty set
* [MDEV-18466](https://jira.mariadb.org/browse/MDEV-18466) - Unsafe to log updates on tables referenced by foreign keys with triggers in statement format
* [MDEV-18899](https://jira.mariadb.org/browse/MDEV-18899) - Server crashes in `Field::set_warning_truncated_wrong_value`
* [MDEV-18298](https://jira.mariadb.org/browse/MDEV-18298) - Crashes server with segfault during role grants
* [MDEV-17610](https://jira.mariadb.org/browse/MDEV-17610) - Unexpected connection abort after certain operations from within stored procedure
* [MDEV-19112](https://jira.mariadb.org/browse/MDEV-19112) - WITH clause does not work with information\_schema as default database
* [MDEV-17830](https://jira.mariadb.org/browse/MDEV-17830) - Server crashes in `Item_null_result::field_type` upon `SELECT with CHARSET(date)` and `ROLLUP`
* [MDEV-14041](https://jira.mariadb.org/browse/MDEV-14041) - Server crashes in `String::length` on queries with functions and `ROLLUP`
* [MDEV-18920](https://jira.mariadb.org/browse/MDEV-18920) - Prepared statements with `st_convexhull` hang and eat 100% cpu.
* [MDEV-15837](https://jira.mariadb.org/browse/MDEV-15837) - Assertion `item1->type() == Item::FIELD_ITEM && item2->type() == Item::FIELD_ITEM`
* [MDEV-9531](https://jira.mariadb.org/browse/MDEV-9531) - GROUP\_CONCAT with ORDER BY inside takes a lot of memory while it's executed
* [MDEV-17036](https://jira.mariadb.org/browse/MDEV-17036) - BULK with replace doesn't take the first parameter in account
* Bug#28986737 - RENAMING AND REPLACING MYSQL.USER TABLE CAN LEAD TO A SERVER CRASH
* [MDEV-19350](https://jira.mariadb.org/browse/MDEV-19350) - Server crashes in `delete_tree_element / ... / Item_func_group_concat::repack_tree`
* [MDEV-19188](https://jira.mariadb.org/browse/MDEV-19188) - Server Crash When Using a Trigger With A Number of Virtual Columns on INSERT/UPDATE
* [MDEV-19352](https://jira.mariadb.org/browse/MDEV-19352) - Server crash in `alloc_histograms_for_table_share` upon query from information schema

### InnoDB

* Merge InnoDB changes from MySQL 5.6.44 and 5.7.26
* InnoDB persistent corruption fixes: [MDEV-19426](https://jira.mariadb.org/browse/MDEV-19426), [MDEV-19022](https://jira.mariadb.org/browse/MDEV-19022), [MDEV-19241](https://jira.mariadb.org/browse/MDEV-19241), [MDEV-13942](https://jira.mariadb.org/browse/MDEV-13942)
* InnoDB recovery fixes and speedup: [MDEV-18733](https://jira.mariadb.org/browse/MDEV-18733), [MDEV-12699](https://jira.mariadb.org/browse/MDEV-12699), [MDEV-19356](https://jira.mariadb.org/browse/MDEV-19356), [MDEV-19426](https://jira.mariadb.org/browse/MDEV-19426)

### Encryption

* [MDEV-14398](https://jira.mariadb.org/browse/MDEV-14398) - `innodb_encrypt_tables` will work even with `innodb_encryption_rotate_key_age=0`

### Protocol

* [MDEV-17036](https://jira.mariadb.org/browse/MDEV-17036) - BULK with replace doesn't take the first parameter in account

### Replication

* [MDEV-14784](https://jira.mariadb.org/browse/MDEV-14784) - Slave crashes in show\_status\_array upon running a trigger with select from I\_S

### mariadb-backup

* [MDEV-19060](https://jira.mariadb.org/browse/MDEV-19060) - mariadb-backup continues, despite failing to open a tablespace

### Packaging & Misc

* [MDEV-19054](https://jira.mariadb.org/browse/MDEV-19054) - `mysql_upgrade_service` now allows MySQL 5.7 to [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) upgrade
* Starting with this release, we are now providing src.rpm packages for [some platforms](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/why-source-rpms-srpms-arent-packaged-for-some-platforms.md) ([MDEV-7066](https://jira.mariadb.org/browse/MDEV-7066))
* As per the [MariaDB Deprecation Policy](/docs/release-notes/community-server/about/platform-deprecation-policy.md), this will be the last release of [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) for Fedora 28

### Security

* [MDEV-18686](https://jira.mariadb.org/browse/MDEV-18686) - Add option to PAM authentication plugin to allow case insensitive username matching
* bugfix - multi-update checked privileges on views incorrectly (commit 5057d4637525eadad438d25ee6a4870a4e6b384c)
* [MDEV-19276](https://jira.mariadb.org/browse/MDEV-19276) - during connect, write error log warning for `ER_DBACCESS_DENIED_ERROR`, if `log_warnings > 1`
* [MDEV-17456](https://jira.mariadb.org/browse/MDEV-17456) - Malicious SUPER user can possibly change audit log configuration without leaving traces.
* Fixes for the following [security vulnerabilities](/docs/server/security/cve.md):
  * [CVE-2019-2614](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-2614)
  * [CVE-2019-2627](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-2627)
  * [CVE-2019-2628](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-2628)

When upgrading from [MariaDB 10.2.16](/docs/release-notes/community-server/old-releases/10.2/10.2.16.md) or earlier to [MariaDB 10.2.17](/docs/release-notes/community-server/old-releases/10.2/10.2.17.md) or higher, running mysql\_upgrade is **required** due to changes introduced in[MDEV-14637](https://jira.mariadb.org/browse/MDEV-14637).

## Changelog

For a complete list of changes made in [MariaDB 10.2.24](/docs/release-notes/community-server/old-releases/10.2/10.2.24.md) with links to detailed information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-102-series/mariadb-10224-changelog.md).

## Contributors

For a full list of contributors to [MariaDB 10.2.24](/docs/release-notes/community-server/old-releases/10.2/10.2.24.md), see the [MariaDB Foundation release announcement](https://mariadb.org/mariadb-10-2-24).

{% 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](/docs/general-resources/distributions-including-mariadb.md) page.
{% endhint %}

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

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