Bug 33718 - MariaDB: 10.11.10
Summary: MariaDB: 10.11.10
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 9
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: QA Team
QA Contact:
URL:
Whiteboard: MGA9-64-OK
Keywords: advisory, validated_update
Depends on:
Blocks:
 
Reported: 2024-11-04 21:20 CET by Marc Krämer
Modified: 2024-11-12 21:26 CET (History)
5 users (show)

See Also:
Source RPM: mariadb
CVE:
Status comment:


Attachments

Comment 1 Marc Krämer 2024-11-04 21:24:53 CET
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

katnatek 2024-11-05 18:23:34 CET

Keywords: (none) => advisory

PC LX 2024-11-07 00:04:20 CET

CC: (none) => mageia

Comment 2 PC LX 2024-11-09 01:14:43 CET
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
Comment 3 Herman Viaene 2024-11-11 15:35:26 CET
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.viaene
Whiteboard: (none) => MGA9-64-OK

Comment 4 Thomas Andrews 2024-11-11 19:31:27 CET
Validating.

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

Comment 5 Dan Fandrich 2024-11-12 07:18:27 CET
This package was pushed today but for some reason this bug wasn't automatically closed.

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

Comment 6 Mageia Robot 2024-11-12 21:26:58 CET
An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2024-0227.html

Note You need to log in before you can comment on or make changes to this bug.