new (bugfix) version of mariadb available https://mariadb.com/kb/en/mariadb-10-5-22-release-notes/
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
CC: (none) => mageia
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-bugsKeywords: (none) => validated_update
CC: (none) => davidwhodginsKeywords: (none) => advisory
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2023-0059.html
Status: NEW => RESOLVEDResolution: (none) => FIXED