This is a regular bugfix update of mariadb which fixes various (severe) errors:

General:
- Unexpected result when combining DISTINCT, subselect and LIMIT

InnoDB:
- innochecksum dies with Floating point exception (MDEV-31641)
- Deadlock with 3 concurrent DELETEs by unique key (MDEV-10962)

Aria:
- Various crashes upon INSERT/UPDATE after changing Aria settings (MDEV-28054)
- Various crashes/asserts/corruptions when Aria encryption is enabled/used, but the encryption plugin is not loaded (MDEV-26258)

Optimizer:
- Equal on two RANK window functions create wrong result (MDEV-20010)
- Segfault on select query using index for group-by and filesort (MDEV-30143)



References:
https://mariadb.com/kb/en/mariadb-10-11-5-release-notes/
========================

Updated packages in core/updates_testing:
========================

mariadb-client-10.11.5-1.mga9
mariadb-client-debuginfo-10.11.5-1.mga9
lib64mariadbd19-10.11.5-1.mga9
mariadb-core-10.11.5-1.mga9
lib64mariadb-embedded-devel-10.11.5-1.mga9
mariadb-mroonga-debuginfo-10.11.5-1.mga9
mariadb-mroonga-10.11.5-1.mga9
mariadb-common-10.11.5-1.mga9
lib64mariadb-devel-10.11.5-1.mga9
mariadb-rocks-10.11.5-1.mga9
mariadb-spider-debuginfo-10.11.5-1.mga9
mariadb-connect-debuginfo-10.11.5-1.mga9
mariadb-s3-engine-10.11.5-1.mga9
mariadb-bench-debuginfo-10.11.5-1.mga9
mariadb-debuginfo-10.11.5-1.mga9
mariadb-spider-10.11.5-1.mga9
mariadb-extra-debuginfo-10.11.5-1.mga9
mariadb-connect-10.11.5-1.mga9
mariadb-feedback-debuginfo-10.11.5-1.mga9
lib64mariadb3-debuginfo-10.11.5-1.mga9
mariadb-obsolete-debuginfo-10.11.5-1.mga9
mariadb-10.11.5-1.mga9
mariadb-sphinx-debuginfo-10.11.5-1.mga9
mariadb-s3-engine-debuginfo-10.11.5-1.mga9
mariadb-sequence-debuginfo-10.11.5-1.mga9
mariadb-extra-10.11.5-1.mga9
lib64mariadb3-10.11.5-1.mga9
mariadb-common-core-10.11.5-1.mga9
mariadb-sphinx-10.11.5-1.mga9
mariadb-feedback-10.11.5-1.mga9
mariadb-sequence-10.11.5-1.mga9
mariadb-pam-10.11.5-1.mga9
mariadb-obsolete-10.11.5-1.mga9
mariadb-pam-debuginfo-10.11.5-1.mga9
mysql-MariaDB-10.11.5-1.mga9
lib64mariadb-devel-debuginfo-10.11.5-1.mga9
mariadb-debugsource-10.11.5-1.mga9
lib64mariadbd19-debuginfo-10.11.5-1.mga9
mariadb-core-debuginfo-10.11.5-1.mga9
mariadb-bench-10.11.5-1.mga9
mariadb-common-debuginfo-10.11.5-1.mga9
mariadb-rocks-debuginfo-10.11.5-1.mga9
lib64mariadb-embedded-devel-debuginfo-10.11.5-1.mga9

SRPM:
mariadb-10.11.5-1.mga9.src.rpm

Assignee: mageia => qa-bugs

The package will have to be resubmitted for m9 as it's not in updates testing
for m9.

The update is not in a fully up-to-date mirror such as princeton.

CC: (none) => davidwhodgins

missed the info - rebuild is in progress... should be on the mirrors shortly

now it is uploaded to the mirror-server.

Tested in KDE Plasma with Kontact/Kmail x86_64

Tests so far
mysql_upgrade
akonadiconsole
Kontact/KMail
No regression found.

Best regards,
Ulrich

CC: (none) => bequimao.de

@ulrich will you ok it?

As there are no other takers, I'll set it to ok.

Ulrich

Whiteboard: (none) => MGA9-64-OK

Thank you, Ulrich.

Validating. Advisory in comment 1.

Keywords: (none) => validated_update
CC: (none) => andrewsfarm, sysadmin-bugs

An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2023-0078.html

Resolution: (none) => FIXED
Status: NEW => RESOLVED