https://mariadb.com/kb/en/mariadb-10-11-10-release-notes/
A new release of MariaDB fixes many crashes, e.g. in InnoDB, optimizer and galera. For details see the changelog. References: https://mariadb.com/kb/en/mariadb-10-11-10-release-notes/ ======================== Updated packages in core/updates_testing: ======================== mariadb-extra-debuginfo-10.11.10-1.mga9 mariadb-s3-engine-10.11.10-1.mga9 mariadb-s3-engine-debuginfo-10.11.10-1.mga9 mariadb-connect-10.11.10-1.mga9 mariadb-feedback-debuginfo-10.11.10-1.mga9 mariadb-bench-debuginfo-10.11.10-1.mga9 mariadb-spider-10.11.10-1.mga9 mariadb-sphinx-debuginfo-10.11.10-1.mga9 mariadb-connect-debuginfo-10.11.10-1.mga9 mariadb-10.11.10-1.mga9 mariadb-obsolete-debuginfo-10.11.10-1.mga9 lib64mariadb3-debuginfo-10.11.10-1.mga9 mariadb-sequence-debuginfo-10.11.10-1.mga9 mariadb-common-core-10.11.10-1.mga9 lib64mariadb3-10.11.10-1.mga9 mariadb-spider-debuginfo-10.11.10-1.mga9 mariadb-sphinx-10.11.10-1.mga9 mariadb-extra-10.11.10-1.mga9 mariadb-pam-10.11.10-1.mga9 mariadb-obsolete-10.11.10-1.mga9 mariadb-sequence-10.11.10-1.mga9 mariadb-pam-debuginfo-10.11.10-1.mga9 lib64mariadb-devel-debuginfo-10.11.10-1.mga9 mariadb-feedback-10.11.10-1.mga9 mysql-MariaDB-10.11.10-1.mga9 lib64mariadb-devel-10.11.10-1.mga9 mariadb-mroonga-debuginfo-10.11.10-1.mga9 mariadb-mroonga-10.11.10-1.mga9 mariadb-client-10.11.10-1.mga9 mariadb-client-debuginfo-10.11.10-1.mga9 mariadb-rocks-10.11.10-1.mga9 lib64mariadbd19-10.11.10-1.mga9 mariadb-core-10.11.10-1.mga9 lib64mariadb-embedded-devel-10.11.10-1.mga9 mariadb-common-10.11.10-1.mga9 mariadb-debuginfo-10.11.10-1.mga9 mariadb-debugsource-10.11.10-1.mga9 lib64mariadbd19-debuginfo-10.11.10-1.mga9 mariadb-core-debuginfo-10.11.10-1.mga9 mariadb-bench-10.11.10-1.mga9 mariadb-common-debuginfo-10.11.10-1.mga9 mariadb-rocks-debuginfo-10.11.10-1.mga9 lib64mariadb-embedded-devel-debuginfo-10.11.10-1.mga9 SRPM: mariadb-10.11.10-1.mga9.src.rpm
Assignee: mageia => qa-bugs
Keywords: (none) => advisory
CC: (none) => mageia
Installed and tested for 3 days without issues. Tested with: - mysql CLI; - dbeaver-ce; - mysql workstation; - PHP scripts (e.g. wordpress, drupal, roundcubemail, nextcloud, phpmyadmin); - Qt6 applications using the QSqlMySql plugin driver; - network access disabled, only using unix socket. - systemd restricted service for improved security (see override.conf file below). All OK. System: Mageia 9, x86_64, Intel(R) Core(TM) i5-4590 CPU @ 3.30GHz. $ uname -a Linux marte 6.6.58-server-2.mga9 #1 SMP PREEMPT_DYNAMIC Sat Oct 26 08:51:28 UTC 2024 x86_64 GNU/Linux $ rpm -qa | grep mariadb | sort lib64mariadb3-10.11.10-1.mga9 mariadb-10.11.10-1.mga9 mariadb-client-10.11.10-1.mga9 mariadb-common-10.11.10-1.mga9 mariadb-common-core-10.11.10-1.mga9 mariadb-core-10.11.10-1.mga9 mariadb-extra-10.11.10-1.mga9 $ systemctl status mysqld.service ● mysqld.service - MySQL database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; preset: disabled) Drop-In: /etc/systemd/system/mysqld.service.d └─override.conf Active: active (running) since Fri 2024-11-08 22:55:01 WET; 1h 16min ago Process: 1377733 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS) Main PID: 1377747 (mysqld) Status: "Taking your SQL requests now..." Tasks: 14 (limit: 19018) Memory: 83.3M CPU: 3.159s CGroup: /system.slice/mysqld.service └─1377747 /usr/sbin/mysqld $ 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
MGA9-64 Plasma Wayland on HP-Pavillion No installation issues. # systemctl start mysqld [root@mach4 ~]# systemctl -l status mysqld ● mysqld.service - MySQL database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; preset: disabled) Active: active (running) since Mon 2024-11-11 14:29:32 CET; 13s ago Process: 99690 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS) Main PID: 105251 (mysqld) Status: "Taking your SQL requests now..." Tasks: 21 (limit: 4473) Memory: 87.2M CPU: 3.271s CGroup: /system.slice/mysqld.service └─105251 /usr/sbin/mysqld Nov 11 14:29:15 mach4.hviaene.thuis mysqld[105251]: 2024-11-11 14:29:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file f> Nov 11 14:29:15 mach4.hviaene.thuis mysqld[105251]: 2024-11-11 14:29:15 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. Nov 11 14:29:15 mach4.hviaene.thuis mysqld[105251]: 2024-11-11 14:29:15 0 [Note] InnoDB: log sequence number 46846; transaction id 14 Nov 11 14:29:15 mach4.hviaene.thuis mysqld[105251]: 2024-11-11 14:29:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Nov 11 14:29:15 mach4.hviaene.thuis mysqld[105251]: 2024-11-11 14:29:15 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 Nov 11 14:29:15 mach4.hviaene.thuis mysqld[105251]: 241111 14:29:15 server_audit: MariaDB Audit Plugin version 1.4.14 STARTED. Nov 11 14:29:15 mach4.hviaene.thuis mysqld[105251]: 241111 14:29:15 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.20> Nov 11 14:29:32 mach4.hviaene.thuis mysqld[105251]: 2024-11-11 14:29:32 0 [Note] /usr/sbin/mysqld: ready for connections. Nov 11 14:29:32 mach4.hviaene.thuis mysqld[105251]: Version: '10.11.10-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 Mageia MariaDB Server Nov 11 14:29:32 mach4.hviaene.thuis systemd[1]: Started mysqld.service. # mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and haven't set the root password yet, you should just press enter here. Enter current password for root (enter for none): OK, successfully used password, moving on... etc .... completed succesfully Used phpmyadmin to create a new database, new table with PK, unique index and timestamp. Populated a few records, all works OK. In view of othere tests above, let's go.
CC: (none) => herman.viaeneWhiteboard: (none) => MGA9-64-OK
Validating.
CC: (none) => andrewsfarm, sysadmin-bugsKeywords: (none) => validated_update
This package was pushed today but for some reason this bug wasn't automatically closed.
Status: NEW => RESOLVEDResolution: (none) => FIXEDCC: (none) => dan
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2024-0227.html