The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-23. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB 10.3.31 Release Notes

The most recent release of MariaDB 10.3 is:
MariaDB 10.3.39 Stable (GA) Download Now

Download 10.3.31 Release Notes Changelog Overview of 10.3

Release date: 6 Aug 2021

Warning: This version can cause InnoDB file corruption on FreeBSD and on AIX. If you are using AIX, please, stick to an earlier release, or upgrade to a more recent release. If you are using FreeBSD, upgrade to the bugfix release (the version ends with _1) of the mariadb-server from the Ports Collection. See MDEV-26537.

MariaDB 10.3 is the previous stable series of MariaDB, and an evolution of MariaDB 10.2 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.3.31 is a Stable (GA) release.

For an overview of MariaDB Server 10.3 see the What is MariaDB 10.3? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • InnoDB no longer acquires advisory file locks by default (MDEV-24393)
  • Encryption: Automatically disable key rotation checks for file_key_management plugin (MDEV-14180)
  • Some fixes from MySQL 5.7.35 (MDEV-26205)

Optimizer

  • A query that uses ORDER BY .. LIMIT clause and "Range checked for each record optimization" could produce incorrect results under some circumstances (MDEV-25858)
  • Queries that have more than 32 equality conditions comparing columns of different tables ("tableX.colX=tableY.colY) could cause a stack overrun in the query optimizer (MDEV-17783, MDEV-23937)
  • "Condition pushdown into derived table" optimization cannot be applied if the expression being pushed refers to a derived table column which is computed from expression that has a stored function call, @session variable reference, or other similar construct. The fix for MDEV-25969 makes it so that only the problematic part of the condition is not pushed. The rest of the condition is now pushed. (MDEV-25969)
  • A query with window function on the left side of the subquery could cause a crash. (MDEV-25630)
  • Wrong result selecting from simple view with LIMIT and ORDER BY Queries with views/derived table/CTEs that have this form: "(SELECT ... LIMIT <n>) ORDER BY ...>" could produce wrong results (MDEV-25679)

Packaging & Misc

Security

When upgrading from MariaDB 10.3.8 or earlier to MariaDB 10.3.9 or higher,
running mysql_upgrade is required due to changes introduced in MDEV-14637.

MongoDB protocol support files for the CONNECT engine are missing in this release.
If you want to use CONNECT engine with MongoDB, you need to download
Mongo2.jar or Mongo3.jar and put a path to this file into the connect_class_path in the my.cnf.

Changelog

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

Contributors

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

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.