Bug 32180

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-5-22-release-notes/
========================

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

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


SRPM:
mariadb-10.5.22-1.mga8.src.rpm

Assignee: mageia => qa-bugs

Installed and tested without issue.

Tested for a week. No issues or regressions found.

Tested:
- mysql CLI;
- phpMyAdmin, nextcloud, wordpress;
- MySQL Workbench;
- PHP scripts using PDO/mysql;
- Qt6 apps using mysql plugin.
- systemd unix and TCP/IP sockets activation.
- systemd restricted execution for improved security.


System: Mageia 8, x86_64, Intel CPU.

$ uname -a
Linux marte 6.1.45-desktop-1.mga8 #1 SMP PREEMPT_DYNAMIC Fri Aug 11 22:01:56 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
$ rpm -qa | grep mariadb | sort
lib64mariadb3-10.5.22-1.mga8
mariadb-10.5.22-1.mga8
mariadb-client-10.5.22-1.mga8
mariadb-common-10.5.22-1.mga8
mariadb-common-core-10.5.22-1.mga8
mariadb-core-10.5.22-1.mga8
mariadb-extra-10.5.22-1.mga8
# systemctl status mysqld.socket mysqld.service
● mysqld.socket - mysqld Server Socket
     Loaded: loaded (/usr/local/lib/systemd/system/mysqld.socket; enabled; vendor preset: disabled)
     Active: inactive (dead) since Fri 2023-08-25 14:57:11 WEST; 8s ago
   Triggers: ● mysqld.service
     Listen: /run/mysqld/mysqld.socket (Stream)

ago 20 14:49:19 marte systemd[1]: Listening on mysqld Server Socket.
ago 25 14:57:11 marte systemd[1]: mysqld.socket: Succeeded.
ago 25 14:57:11 marte systemd[1]: Closed mysqld Server Socket.

● mysqld.service - MySQL database server
     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mysqld.service.d
             └─override.conf
     Active: active (running) since Fri 2023-08-25 14:57:11 WEST; 7s ago
TriggeredBy: ● mysqld.socket
    Process: 176886 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
   Main PID: 176900 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 28 (limit: 19046)
     Memory: 133.4M
        CPU: 305ms
     CGroup: /system.slice/mysqld.service
             └─176900 /usr/sbin/mysqld

ago 25 14:57:11 marte mysqld[176900]: 2023-08-25 14:57:11 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
ago 25 14:57:11 marte mysqld[176900]: 2023-08-25 14:57:11 0 [Note] InnoDB: 10.5.22 started; log sequence number 62234025; transaction id 6186324
ago 25 14:57:11 marte mysqld[176900]: 2023-08-25 14:57:11 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
ago 25 14:57:11 marte mysqld[176900]: 230825 14:57:11 server_audit: MariaDB Audit Plugin version 1.4.14 STARTED.
ago 25 14:57:11 marte mysqld[176900]: 230825 14:57:11 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2023-08-25 14:57:11 0 [Note] Reading of all Master_info entries succeeded
ago 25 14:57:11 marte mysqld[176900]: 2023-08-25 14:57:11 0 [Note] Added new Master_info '' to hash table
ago 25 14:57:11 marte mysqld[176900]: 2023-08-25 14:57:11 0 [Note] /usr/sbin/mysqld: ready for connections.
ago 25 14:57:11 marte mysqld[176900]: Version: '10.5.22-MariaDB-log'  socket: '/run/mysqld/mysqld.socket'  port: 0  Mageia MariaDB Server
ago 25 14:57:11 marte systemd[1]: Started MySQL database server.
ago 25 14:57:12 marte mysqld[176900]: 2023-08-25 14:57:12 0 [Note] InnoDB: Buffer pool(s) load completed at 230825 14:57:12
$ cat /etc/systemd/system/mysqld.service.d/override.conf
# If "skip-networking" is set in the configuration then "AF_INET AF_INET6"
# should be removed from RestrictAddressFamilies and PrivateNetwork=should
# be set to "yes".

[Service]

PrivateNetwork=yes
PrivateUsers=yes
PrivateTmp=yes
PrivateDevices=yes
DevicePolicy=closed

UMask=0077
NoNewPrivileges=yes
LockPersonality=yes
MemoryDenyWriteExecute=yes
RemoveIPC=yes

RestrictRealtime=yes
RestrictSUIDSGID=yes
RestrictNamespaces=yes
RestrictAddressFamilies=AF_UNIX
#RestrictAddressFamilies=AF_UNIX AF_INET AF_INET6

SystemCallArchitectures=native
SystemCallFilter=@system-service
SystemCallFilter=~ @privileged @resources

ProtectHome=yes
ProtectHostname=yes
ProtectKernelLogs=yes
ProtectClock=yes
ProtectControlGroups=yes
ProtectKernelModules=yes
ProtectKernelTunables=yes
ProtectKernelLogs=yes
ProtectSystem=strict

AmbientCapabilities=
CapabilityBoundingSet=

StateDirectory=mysql
RuntimeDirectory=mysqld
LogsDirectory=mysqld

This update has been going strong for 10 days without issues. I'm giving it an OK. Please undo if appropriate.

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

Validating. Advisory in comment 1.

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

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

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

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