MariaDB 10.2.24 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

DownloadRelease NotesChangelogOverview of 10.2

Release date: 9 May 2019

MariaDB 10.2 is the previous stable series of MariaDB. It is an evolution of MariaDB 10.1 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 is a Stable (GA) release.

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

Upgrading from earlier 10.2.x versions is highly recommended for allGalera users due to bug 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 - Both (WHERE 0.1) and (WHERE NOT 0.1) return empty set

• MDEV-18466 - Unsafe to log updates on tables referenced by foreign keys with triggers in statement format

• MDEV-18899 - Server crashes in Field::set_warning_truncated_wrong_value

• MDEV-18298 - Crashes server with segfault during role grants

• MDEV-17610 - Unexpected connection abort after certain operations from within stored procedure

• MDEV-19112 - WITH clause does not work with information_schema as default database

• MDEV-17830 - Server crashes in Item_null_result::field_type upon SELECT with CHARSET(date) and ROLLUP

• MDEV-14041 - Server crashes in String::length on queries with functions and ROLLUP

• MDEV-18920 - Prepared statements with st_convexhull hang and eat 100% cpu.

• MDEV-15837 - Assertion item1->type() == Item::FIELD_ITEM && item2->type() == Item::FIELD_ITEM

• MDEV-9531 - GROUP_CONCAT with ORDER BY inside takes a lot of memory while it's executed

• 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 - Server crashes in delete_tree_element / ... / Item_func_group_concat::repack_tree

• MDEV-19188 - Server Crash When Using a Trigger With A Number of Virtual Columns on INSERT/UPDATE

• 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, MDEV-19022, MDEV-19241, MDEV-13942

• InnoDB recovery fixes and speedup: MDEV-18733, MDEV-12699, MDEV-19356, MDEV-19426

Encryption

• MDEV-14398 - innodb_encrypt_tables will work even with innodb_encryption_rotate_key_age=0

Protocol

• MDEV-17036 - BULK with replace doesn't take the first parameter in account

Replication

• MDEV-14784 - Slave crashes in show_status_array upon running a trigger with select from I_S

mariadb-backup

• MDEV-19060 - mariadb-backup continues, despite failing to open a tablespace

Packaging & Misc

• MDEV-19054 - mysql_upgrade_service now allows MySQL 5.7 to MariaDB 10.2 upgrade

• Starting with this release, we are now providing src.rpm packages for some platforms (MDEV-7066)

• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 28

Security

• 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 - during connect, write error log warning for ER_DBACCESS_DENIED_ERROR, if log_warnings > 1

• MDEV-17456 - Malicious SUPER user can possibly change audit log configuration without leaving traces.

• Fixes for the following security vulnerabilities:

  • CVE-2019-2614

  • CVE-2019-2627

  • CVE-2019-2628

When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running mysql_upgrade is required due to changes introduced inMDEV-14637.

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.2.24, 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 theDistributions which Include MariaDB page.