MariaDB 10.5.14 Release Notes

Download 10.5.14 Release Notes Changelog Overview of 10.5

Release date: 9 Feb 2022

MariaDB 10.5 is a previous stable series of MariaDB. It is an evolution of MariaDB 10.4 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

MariaDB 10.5.14 is a Stable (GA) release.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

• --skip-symbolic-links does not disallow .isl file creation (MDEV-26870)
• Indexed CHAR columns are broken with NO_PAD collations (MDEV-25440)
• insert-intention lock conflicts with waiting ORDINARY lock (MDEV-27025)
• Crash recovery improvements (MDEV-26784, MDEV-27022, MDEV-27183, MDEV-27610)

Galera

• Galera updated to 26.4.11
• Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory (MDEV-27181)
• Alter Sequence do not replicate to another nodes with in Galera Cluster (MDEV-19353)
• Galera crash - Assertion. Possible parallel writeset problem (MDEV-26803)
• CREATE TABLE with FOREIGN KEY constraint fails to apply in parallel (MDEV-27276)
• Galera cluster node consider old server_id value even after modification of server_id [wsrep_gtid_mode=ON] (MDEV-26223)

Replication

• Seconds behind master corrected from artificial spikes at relay-log rotation (MDEV-16091)
• Statement rollback in binlog when transaction creates or drop temporary table is set right (MDEV-26833)
• CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to stabilize its parallel execution on slave (MDEV-27365)

Packaging & Misc

• prohibition running two upgrades in parallel (MDEV-27068, MDEV-27107, MDEV-27279)
• As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.5 for Ubuntu 21.04 Hirsute, CentOS 8, and Fedora 33
• mariadb_repo_setup script updated to version 2022-02-08, with the following fixes and enhancements:
  • Default location of the script has been moved to: https://r.mariadb.com/downloads/mariadb_repo_setup (old location is deprecated, but still works)
  • The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: https://supplychain.mariadb.com/mariadb-keyring-2019.gpg and the checksum for the file can be found at: https://supplychain.mariadb.com/mariadb-keyring-2019.gpg.sha256
  • Support for RHEL and SLES aarch64 repositories added
  • New function added to verify that the MariaDB Server version, if specified on the command line, follows the correct naming and that a corresponding repository actually exists.
  • Fixed repository pinning for Ubuntu and Debian repositories
  • MariaDB Server 10.7 is now the default server version

Docker Library

• Faster initialization by disabling binary logging during initialization (MDEV-27074)
• mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 (MDEV-25670)
• A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options (MDEV-25434)
• mysql@localhost user is created with the environment variable MARIADB_MYSQL_LOCALHOST_USER=1 and additional grants (beyond USAGE) with MARIADB_MYSQL_LOCALHOST_GRANTS={global grant list} (MDEV-27732)
• skip innodb buffer pool loads/dumps on temporary startup/shutdown for faster startup/initialization, and accurate "healthcheck.sh --innodb_buffer_pool_loaded"
• change group ownership on datadir/socket dir (issue #401)
• log note about note on Securing system users, mysql_secure_installation not required (reddit suggestion)
• speed up Docker Library initialization of timezones (MDEV-27608, MDEV-23326)

Security

• Fixes for the following security vulnerabilities:
  • CVE-2022-24052
  • CVE-2022-24051
  • CVE-2022-24050
  • CVE-2022-24048
  • CVE-2021-46659
  • CVE-2022-0778
  • CVE-2022-21595

Changelog

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

Contributors

For a full list of contributors to MariaDB 10.5.14, see the MariaDB Foundation release announcement.