| Summary: | MariaDB: 10.5.18 fixes issues | ||
|---|---|---|---|
| Product: | Mageia | Reporter: | Marc Krämer <mageia> |
| Component: | RPM Packages | Assignee: | QA Team <qa-bugs> |
| Status: | RESOLVED FIXED | QA Contact: | |
| Severity: | normal | ||
| Priority: | Normal | CC: | andrewsfarm, davidwhodgins, herman.viaene, mageia, sysadmin-bugs |
| Version: | 8 | Keywords: | advisory, validated_update |
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | MGA8-64-OK | ||
| Source RPM: | mariadb | CVE: | |
| Status comment: | |||
|
Description
Marc Krämer
2022-11-08 14:44:14 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 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 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:42CC:
(none) =>
mageia @PC LX: I assume we're testing here for installation/build issues. Database tests itself should have been passed before release. Thanks for testing :) Validating. Advisory in comment 1. Keywords:
(none) =>
validated_update
Dave Hodgins
2022-11-13 00:25:26 CET
Keywords:
(none) =>
advisory An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2022-0143.html Resolution:
(none) =>
FIXED |