Bug 27081

Summary: mariadb 10.3.24
Product: Mageia Reporter: Marc Krämer <mageia>
Component: RPM PackagesAssignee: QA Team <qa-bugs>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: Normal CC: mageia, ouaurelien, sysadmin-bugs
Version: 7Keywords: advisory, validated_update
Target Milestone: ---   
Hardware: All   
OS: Linux   
Whiteboard: MGA7-64-OK
Source RPM: mariadb CVE:
Status comment:

Description Marc Krämer 2020-08-11 10:32:24 CEST 
https://mariadb.com/kb/en/mariadb-10324-release-notes/

Fixes some crashes.
Comment 1 Marc Krämer 2020-08-11 11:25:20 CEST 
Updated mariadb:

InnoDB:
- Fixed corruption in delete buffering (MDEV-22497)
- Fixed a deadlock in FLUSH TABLES…FOR EXPORT (MDEV-22890)
- InnoDB data file extension is not crash-safe (MDEV-23190)
- Minor fixes related to encryption and FULLTEXT INDEX Dropping the adaptive hash index may cause DDL to lock up InnoDB (MDEV-22456)
innodb_log_optimize_ddl=OFF is not crash safe (MDEV-21347)
- Mariadb service won't shutdown when it's running and the OS datetime updated backwards (MDEV-17481)
-Doublewrite recovery can corrupt data pages (MDEV-11799)
-Fixed race conditions related to buffer pool resizing ALTER TABLE fixes (MDEV-22637, MDEV-23244)
-Crash recovery fixes (MDEV-21347, MDEV-23190, MDEV-11799)

Other:
- MariaDB could crash after changing the query_cache size (MDEV-5924)
- Errors and SIGSEGV on CREATE TABLE w/ various charsets (MDEV-22111)

References:
https://mariadb.com/kb/en/mariadb-10324-release-notes/
========================

Updated packages in core/updates_testing:
========================
mariadb-10.3.24-1.mga7
mysql-MariaDB-10.3.24-1.mga7
mariadb-feedback-10.3.24-1.mga7
mariadb-connect-10.3.24-1.mga7
mariadb-sphinx-10.3.24-1.mga7
mariadb-mroonga-10.3.24-1.mga7
mariadb-sequence-10.3.24-1.mga7
mariadb-spider-10.3.24-1.mga7
mariadb-extra-10.3.24-1.mga7
mariadb-obsolete-10.3.24-1.mga7
mariadb-core-10.3.24-1.mga7
mariadb-common-core-10.3.24-1.mga7
mariadb-common-10.3.24-1.mga7
mariadb-client-10.3.24-1.mga7
mariadb-bench-10.3.24-1.mga7
mariadb-pam-10.3.24-1.mga7
libmariadb3-10.3.24-1.mga7
libmariadb-devel-10.3.24-1.mga7
libmariadbd19-10.3.24-1.mga7
libmariadb-embedded-devel-10.3.24-1.mga7
mariadb-debugsource-10.3.24-1.mga7
mariadb-debuginfo-10.3.24-1.mga7
mariadb-feedback-debuginfo-10.3.24-1.mga7
mariadb-connect-debuginfo-10.3.24-1.mga7
mariadb-sphinx-debuginfo-10.3.24-1.mga7
mariadb-mroonga-debuginfo-10.3.24-1.mga7
mariadb-sequence-debuginfo-10.3.24-1.mga7
mariadb-spider-debuginfo-10.3.24-1.mga7
mariadb-extra-debuginfo-10.3.24-1.mga7
mariadb-obsolete-debuginfo-10.3.24-1.mga7
mariadb-core-debuginfo-10.3.24-1.mga7
mariadb-common-debuginfo-10.3.24-1.mga7
mariadb-client-debuginfo-10.3.24-1.mga7
mariadb-bench-debuginfo-10.3.24-1.mga7
mariadb-pam-debuginfo-10.3.24-1.mga7
libmariadb3-debuginfo-10.3.24-1.mga7
libmariadbd19-debuginfo-10.3.24-1.mga7
libmariadb-embedded-devel-debuginfo-10.3.24-1.mga7


Source RPMs: 
mariadb-10.3.24-1.mga7.src.rpm

Assignee: mageia => qa-bugs

Comment 2 PC LX 2020-08-11 21:19:09 CEST 
Installed and tested without issues.


System: Mageia 7, x86_64, Intel CPU.


Tested using:
- mysql CLI;
- MySQL Workbench;
- Qt5 apps using the mysql plugin;
- phpMyAdmin PHP script;
- PHP scripts using PDO/mysql.


No regressions noticed.


$ uname -a
Linux marte 5.6.14-desktop-2.mga7 #1 SMP Wed May 20 23:14:20 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
$ rpm -qa | grep -i mariadb | sort
lib64mariadb3-10.3.24-1.mga7
mariadb-10.3.24-1.mga7
mariadb-client-10.3.24-1.mga7
mariadb-common-10.3.24-1.mga7
mariadb-common-core-10.3.24-1.mga7
mariadb-core-10.3.24-1.mga7
mariadb-extra-10.3.24-1.mga7
$ systemctl status mysqld
● mysqld.service - MySQL database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: active (running) since Tue 2020-08-11 13:17:13 WEST; 6h ago
 Main PID: 25835 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 34 (limit: 4697)
   Memory: 74.6M
   CGroup: /system.slice/mysqld.service
           └─25835 /usr/sbin/mysqld

ago 11 13:17:13 marte mysqld[25835]: 200811 13:17:13 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED.
ago 11 13:17:13 marte mysqld[25835]: 200811 13:17:13 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2020-08-11 13:17:13 0 [Note] Reading of all Master_info entries s>
ago 11 13:17:13 marte mysqld[25835]: 2020-08-11 13:17:13 0 [Note] Added new Master_info '' to hash table
ago 11 13:17:13 marte mysqld[25835]: 2020-08-11 13:17:13 0 [Note] /usr/sbin/mysqld: ready for connections.
ago 11 13:17:13 marte mysqld[25835]: Version: '10.3.24-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Mageia MariaDB Server
ago 11 13:17:13 marte systemd[1]: Started MySQL database server.
ago 11 13:17:13 marte mysqld[25835]: 2020-08-11 13:17:13 0 [Note] InnoDB: Buffer pool(s) load completed at 200811 13:17:13
ago 11 13:17:27 marte mysqld[25835]: 2020-08-11 13:17:27 8 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
ago 11 13:17:27 marte mysqld[25835]: 2020-08-11 13:17:27 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
ago 11 20:02:41 marte mysqld[25835]: 2020-08-11 20:02:41 64 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

CC: (none) => mageia

David Walser 2020-08-16 16:00:48 CEST

Summary: mariadb: update to fix common errors => mariadb 10.3.24
Whiteboard: (none) => MGA7-64-OK

David Walser 2020-08-16 16:10:16 CEST

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

Comment 3 David Walser 2020-08-16 16:21:55 CEST 
Advisory and package list in Comment 1.
Aurelien Oudelet 2020-08-18 22:08:56 CEST

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

Comment 4 Mageia Robot 2020-08-18 22:44:39 CEST 
An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2020-0174.html

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