Bug 27598

Emergency release of mariadb fixes problems with buggy mysql-connectors (PHP,Python and Java)

References:
https://mariadb.org/mariadb-10-5-8-10-4-17-10-3-27-and-10-2-36-now-available/
========================

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

SRPM:
mariadb-10.3.27-1.mga7.src.rpm

Assignee: mageia => qa-bugs

Installed and tested without issues.


System: Mageia 7, x86_64, Intel CPU.


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


No issues found BUT note that it has only been running for about an hour and it only been minimally tested.



$ uname -a
Linux marte 5.7.19-desktop-3.mga7 #1 SMP Sun Oct 18 15:46:00 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
$ rpm -qa | grep -i mariadb | sort
lib64mariadb3-10.3.27-1.mga7
mariadb-10.3.27-1.mga7
mariadb-client-10.3.27-1.mga7
mariadb-common-10.3.27-1.mga7
mariadb-common-core-10.3.27-1.mga7
mariadb-core-10.3.27-1.mga7
mariadb-extra-10.3.27-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 Wed 2020-11-11 22:40:26 WET; 21min ago
  Process: 17526 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
 Main PID: 17543 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 34 (limit: 4684)
   Memory: 94.1M
   CGroup: /system.slice/mysqld.service
           └─17543 /usr/sbin/mysqld

nov 11 22:40:26 marte mysqld[17543]: 2020-11-11 22:40:26 0 [Note] InnoDB: 10.3.27 started; log sequence number 300801905; transaction id 897372
nov 11 22:40:26 marte mysqld[17543]: 2020-11-11 22:40:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
nov 11 22:40:27 marte mysqld[17543]: 201111 22:40:26 server_audit: MariaDB Audit Plugin version 1.4.10 STARTED.
nov 11 22:40:27 marte mysqld[17543]: 201111 22:40:26 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2020-11-11 22:40:26 0 [Note] Reading of all Master_info entries s>
nov 11 22:40:27 marte mysqld[17543]: 2020-11-11 22:40:26 0 [Note] Added new Master_info '' to hash table
nov 11 22:40:27 marte mysqld[17543]: 2020-11-11 22:40:26 0 [Note] /usr/sbin/mysqld: ready for connections.
nov 11 22:40:27 marte mysqld[17543]: Version: '10.3.27-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Mageia MariaDB Server
nov 11 22:40:26 marte systemd[1]: Started MySQL database server.
nov 11 22:40:27 marte mysqld[17543]: 2020-11-11 22:40:27 0 [Note] InnoDB: Buffer pool(s) load completed at 201111 22:40:27
nov 11 22:41:37 marte mysqld[17543]: 2020-11-11 22:41:37 21 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

CC: (none) => mageia
Summary: MariaDB: Emergency Release 10.3.27 => MariaDB: Emergency Release

Mageia 7 already has php 7.3 so is not affected. That's why phpmyadmin was
not impacted.

Looking into mariadb-connect and kdeconnect-kde, I've never used either before,
as I use a land line, not a smartphone.
See https://userbase.kde.org/KDEConnect#What_is_KDE_Connect.3F

I'm going to go ahead and validate this one just on the basis of those packages
installing cleanly, as well as the above testing.

Keywords: (none) => validated_update
CC: (none) => davidwhodgins, sysadmin-bugs
Whiteboard: (none) => MGA7-64-OK

according to release notes mysql-connector for C is not affected.
I assume most users will not have problems, but you could have a server (mga7) where old clients (mga6, other distris) connect.

Advisory pushed to SVN.

Keywords: (none) => advisory
Source RPM: mariadb => mariadb-10.3.26-1.mga7.src.rpm

An update for this issue has been pushed to the Mageia Updates repository.

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

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