MariaDB 10.2.19 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: 13 Nov 2018

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.19 will be 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 all Galera 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

• innodb_safe_truncate system variable for a backup-safe TRUNCATE TABLE implementation that is based on RENAME, CREATE, DROP (MDEV-14717, MDEV-14585, MDEV-13564)

  • Default value for this variable is ON

  • If you absolutely must use XtraBackup instead ofmariadb-backup, you can set it to OFF and restart the server

• MDEV-17289: Multi-pass recovery fails to apply some redo log records

• MDEV-17073: INSERT…ON DUPLICATE KEY UPDATE became more deadlock-prone

• MDEV-17491: micro optimize page_id_t

• MDEV-13671: InnoDB should use case-insensitive column name comparisons like the rest of the server

• Fixes for indexed virtual columns: MDEV-17215, MDEV-16980

• MDEV-17433: Allow InnoDB start up with empty ib_logfile0 from mariabackup --prepare

• MDEV-12547: InnoDB FULLTEXT index has too strict innodb_ft_result_cache_limit max limit

• MDEV-17541: KILL QUERY during lock wait in FOREIGN KEY check causes hang

• MDEV-17531: Crash in RENAME TABLE with FOREIGN KEY and FULLTEXT INDEX

• MDEV-17532: Performance_schema reports wrong directory for the temporary files of ALTER TABLE…ALGORITHM=INPLACE

• MDEV-17545: Predicate lock for SPATIAL INDEX should lock non-matching record

• MDEV-17546: SPATIAL INDEX should not be allowed for FOREIGN KEY

• MDEV-17548: Incorrect access to off-page column for indexed virtual column

• MDEV-12023: Assertion failure sym_node->table != NULL on startup

• MDEV-17230: encryption_key_id from alter is ignored by encryption threads

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

• Fixes for the following security vulnerabilities:

  • CVE-2018-3282

  • CVE-2016-9843

  • CVE-2018-3174

  • CVE-2018-3143

  • CVE-2018-3156

  • CVE-2018-3251

  • CVE-2018-3185

  • CVE-2018-3277

  • CVE-2018-3162

  • CVE-2018-3173

  • CVE-2018-3200

  • CVE-2018-3284

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.19 with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.2.19, 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.