Bug 31093 - MariaDB: 10.5.18 fixes issues
Summary: MariaDB: 10.5.18 fixes issues
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 8
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: QA Team
QA Contact:
URL:
Whiteboard: MGA8-64-OK
Keywords: advisory, validated_update
Depends on:
Blocks:
 
Reported: 2022-11-08 14:44 CET by Marc Krämer
Modified: 2022-11-13 03:26 CET (History)
5 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Marc Krämer 2022-11-08 14:44:14 CET 
a new release fixes some errors:
https://mariadb.com/kb/en/mariadb-10-5-18-release-notes/
Comment 1 Marc Krämer 2022-11-08 20:23:03 CET 
Updated mariadb package:
This is an update to the latest releas of mariadb in 10.5. branch.
Noteable changes are in

mariabackup
 - fixed hangs in combination with --compress

InnoDB
 - Virtual columns
 - crashes
 - race condtions

JSON
 - null handling in parse

Replication
 - fixed triggers
 - fixed false replication error-stop

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

Updated packages in core/updates_testing:
========================
mariadb-spider-10.5.18-1.mga8
mariadb-connect-10.5.18-1.mga8
mariadb-sphinx-debuginfo-10.5.18-1.mga8
lib64mariadb3-debuginfo-10.5.18-1.mga8
mariadb-feedback-debuginfo-10.5.18-1.mga8
mariadb-obsolete-debuginfo-10.5.18-1.mga8
mariadb-10.5.18-1.mga8
mariadb-extra-debuginfo-10.5.18-1.mga8
lib64mariadb3-10.5.18-1.mga8
mariadb-common-core-10.5.18-1.mga8
mariadb-extra-10.5.18-1.mga8
mariadb-sequence-debuginfo-10.5.18-1.mga8
mariadb-sphinx-10.5.18-1.mga8
mariadb-pam-10.5.18-1.mga8
mariadb-obsolete-10.5.18-1.mga8
mariadb-pam-debuginfo-10.5.18-1.mga8
mariadb-feedback-10.5.18-1.mga8
mariadb-sequence-10.5.18-1.mga8
lib64mariadb-devel-debuginfo-10.5.18-1.mga8
mysql-MariaDB-10.5.18-1.mga8
mariadb-spider-debuginfo-10.5.18-1.mga8
mariadb-connect-debuginfo-10.5.18-1.mga8
mariadb-bench-debuginfo-10.5.18-1.mga8
lib64mariadb-devel-10.5.18-1.mga8
mariadb-mroonga-10.5.18-1.mga8
mariadb-client-10.5.18-1.mga8
mariadb-mroonga-debuginfo-10.5.18-1.mga8
mariadb-rocks-10.5.18-1.mga8
lib64mariadbd19-10.5.18-1.mga8
mariadb-core-10.5.18-1.mga8
mariadb-client-debuginfo-10.5.18-1.mga8
lib64mariadb-embedded-devel-10.5.18-1.mga8
mariadb-common-10.5.18-1.mga8
mariadb-debuginfo-10.5.18-1.mga8
mariadb-debugsource-10.5.18-1.mga8
lib64mariadbd19-debuginfo-10.5.18-1.mga8
mariadb-core-debuginfo-10.5.18-1.mga8
mariadb-common-debuginfo-10.5.18-1.mga8
mariadb-bench-10.5.18-1.mga8
lib64mariadb-embedded-devel-debuginfo-10.5.18-1.mga8
mariadb-rocks-debuginfo-10.5.18-1.mga8

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

Assignee: mageia => qa-bugs

Comment 2 Herman Viaene 2022-11-09 15:18:53 CET 
MGA8-64 MATE on Acer Aspire 5253
No installation issues.
At CLI:
# systemctl start mysqld
# systemctl -l status mysqld
● mysqld.service - MySQL database server
     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
     Active: active (running) since Wed 2022-11-09 15:05:40 CET; 15s ago
    Process: 8826 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
   Main PID: 8841 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 43 (limit: 4364)
     Memory: 59.8M
        CPU: 914ms
     CGroup: /system.slice/mysqld.service
             └─8841 /usr/sbin/mysqld

Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: 2022-11-09 15:05:40 0 [Note] InnoDB: 10.5.18 started; log >
Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: 2022-11-09 15:05:40 0 [Note] InnoDB: Loading buffer pool(s>
Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: 2022-11-09 15:05:40 0 [Note] CONNECT: Version 1.07.0002 Ma>
Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: 221109 15:05:40 server_audit: MariaDB Audit Plugin version>
Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: 221109 15:05:40 server_audit: Query cache is enabled with >
Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: 2022-11-09 15:05:40 0 [Note] Reading of all Master_info en>
Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: 2022-11-09 15:05:40 0 [Note] Added new Master_info '' to h>
Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: 2022-11-09 15:05:40 0 [Note] /usr/sbin/mysqld: ready for c>
Nov 09 15:05:40 mach7.hviaene.thuis mysqld[8841]: Version: '10.5.18-MariaDB'  socket: '/var/lib/mysql/mysql.>
Nov 09 15:05:40 mach7.hviaene.thuis systemd[1]: Started MySQL database server.

Made sure httpd is running, use phpmyadmin to log in on existing database.
Removed some previous testing databases, created a new on and in that a table wit a PK, a unique index and a timestamp column. Populated the table with a few rows.
All works OK.

Whiteboard: (none) => MGA8-64-OK
CC: (none) => herman.viaene

Comment 3 PC LX 2022-11-09 20:21:29 CET 
Installed and tested without issues.

System: Mageia 8, x86_64, Intel CPU.

Tested using mysql CLI, phpMyAdmin, MySQL Workbench, PHP scripts using PDO/mysql, and Qt6 apps using mysql plugin.

One day of testing is not much but all worked without regressions.



$ uname -a
Linux jupiter 5.19.16-desktop-1.mga8 #1 SMP PREEMPT_DYNAMIC Sat Oct 15 18:19:46 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
$ rpm -qa | grep -i mariadb | sort
lib64mariadb3-10.5.18-1.mga8
mariadb-10.5.18-1.mga8
mariadb-client-10.5.18-1.mga8
mariadb-common-10.5.18-1.mga8
mariadb-common-core-10.5.18-1.mga8
mariadb-core-10.5.18-1.mga8
mariadb-extra-10.5.18-1.mga8
perl-DBD-MariaDB-1.210.0-6.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 Wed 2022-11-09 09:36:42 WET; 9h ago
   Triggers: ● mysqld.service
     Listen: /var/lib/mysql/mysql.sock (Stream)
             127.0.0.1:3306 (Stream)
        CPU: 735us

nov 09 09:36:37 jupiter systemd[1]: Listening on mysqld Server Socket.
nov 09 09:36:42 jupiter systemd[1]: mysqld.socket: Succeeded.
nov 09 09:36:42 jupiter systemd[1]: Closed mysqld Server Socket.

● mysqld.service - MySQL database server
     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
     Active: active (running) since Wed 2022-11-09 09:36:42 WET; 9h ago
TriggeredBy: ● mysqld.socket
   Main PID: 15024 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 8 (limit: 37626)
     Memory: 101.5M
        CPU: 6.032s
     CGroup: /system.slice/mysqld.service
             └─15024 /usr/sbin/mysqld

nov 09 09:36:42 jupiter mysqld[15024]: 2022-11-09  9:36:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
nov 09 09:36:42 jupiter mysqld[15024]: 2022-11-09  9:36:42 0 [Note] InnoDB: 10.5.18 started; log sequence number 3888454; transaction id 18066
nov 09 09:36:42 jupiter mysqld[15024]: 2022-11-09  9:36:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
nov 09 09:36:42 jupiter mysqld[15024]: 221109  9:36:42 server_audit: MariaDB Audit Plugin version 1.4.14 STARTED.
nov 09 09:36:42 jupiter mysqld[15024]: 221109  9:36:42 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2022-11-09  9:36:42 0 [Note] Reading of all Master_info entries succeeded
nov 09 09:36:42 jupiter mysqld[15024]: 2022-11-09  9:36:42 0 [Note] Added new Master_info '' to hash table
nov 09 09:36:42 jupiter mysqld[15024]: 2022-11-09  9:36:42 0 [Note] /usr/sbin/mysqld: ready for connections.
nov 09 09:36:42 jupiter mysqld[15024]: Version: '10.5.18-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Mageia MariaDB Server
nov 09 09:36:42 jupiter systemd[1]: Started MySQL database server.
nov 09 09:36:42 jupiter mysqld[15024]: 2022-11-09  9:36:42 0 [Note] InnoDB: Buffer pool(s) load completed at 221109  9:36:42

CC: (none) => mageia

Comment 4 Marc Krämer 2022-11-09 23:52:17 CET 
@PC LX: I assume we're testing here for installation/build issues. Database tests itself should have been passed before release. Thanks for testing :)
Comment 5 Thomas Andrews 2022-11-10 14:31:36 CET 
Validating. Advisory in comment 1.

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

Dave Hodgins 2022-11-13 00:25:26 CET

Keywords: (none) => advisory
CC: (none) => davidwhodgins

Comment 6 Mageia Robot 2022-11-13 03:26:46 CET 
An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2022-0143.html

Resolution: (none) => FIXED
Status: NEW => RESOLVED
Note You need to log in before you can comment on or make changes to this bug.