Bug 29168 - MariaDB: new version 10.5.11 fixes some bugs
Summary: MariaDB: new version 10.5.11 fixes some bugs
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: 29065
  Show dependency treegraph
 
Reported: 2021-06-24 11:30 CEST by Marc Krämer
Modified: 2021-07-09 00:44 CEST (History)
5 users (show)

See Also:
Source RPM: mariadb-10.5.10-1.mga8.src.rpm
CVE:
Status comment:


Attachments
List of installed and available packages, test logs (9.59 KB, text/plain)
2021-06-25 22:50 CEST, Ulrich Beckmann
Details
Log of dnf install $(cat mga8_29168.list) # mariadb (59.45 KB, text/plain)
2021-07-02 14:10 CEST, Ulrich Beckmann
Details
List of installed packages, test logs (12.59 KB, text/plain)
2021-07-04 19:24 CEST, Ulrich Beckmann
Details

Description Marc Krämer 2021-06-24 11:30:33 CEST
Version 10.5.11 fixes some bugs in replication and corruptions in innodb tables

https://mariadb.com/kb/en/mariadb-10511-release-notes/
Marc Krämer 2021-06-24 11:30:43 CEST

Version: Cauldron => 8

Comment 1 Thomas Backlund 2021-06-24 11:48:18 CEST
please always add version to your "new version" bugs as it makes it easier to search / filter on

Summary: MariaDB: new version fixes some bugs => MariaDB: new version 10.5.11 fixes some bugs

Comment 2 Marc Krämer 2021-06-24 11:49:26 CEST
ok, sorry.
Comment 3 Marc Krämer 2021-06-24 11:55:48 CEST
Updated mariadb packages fix some bugs:

- InnoDB recovery fails
- Potential hang in purge for virtual columns
- Change buffer records are lost under heavy load
- Replication: Fix optistic parallel applier to not deadlock on admin commands


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

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

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

Assignee: mageia => qa-bugs

Comment 4 Ulrich Beckmann 2021-06-25 22:50:31 CEST
Created attachment 12822 [details]
List of installed and available packages, test logs

Tested in KDE Plasma with Kontact/Kmail x86_64

Tests so far
mysql_upgrade
akonadiconsole
Kontact/KMail
No regression found.

Best regards,
Ulrich

CC: (none) => bequimao.de

Comment 5 Marc Krämer 2021-06-30 13:53:03 CEST
updated rel to -2
this fixes #29065 too.

Updated mariadb packages fix some bugs:

- InnoDB recovery fails
- Potential hang in purge for virtual columns
- Change buffer records are lost under heavy load
- Replication: Fix optistic parallel applier to not deadlock on admin commands

This update also fixes mysqlhotcopy, which was not working before this update (mga#29065).

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

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

SRPM:
mariadb-10.5.11-2.mga8.src.rpm
Aurelien Oudelet 2021-07-01 21:25:22 CEST

Blocks: (none) => 29065

Comment 6 Ulrich Beckmann 2021-07-02 14:10:46 CEST
Created attachment 12838 [details]
Log of dnf install $(cat mga8_29168.list) # mariadb

Installed the new package list with dnf.

Caveat: 2 packages, binutils and perl-DBD-MariaDB, were selected from updates_testing, but not contained in the package list.

A subsequent try to downgrade perl-DBD-MariaDB failed, see also attached Bug https://bugs.mageia.org/show_bug.cgi?id=29065. binutils is downgraded successfully.

Ulrich
Comment 7 Marc Krämer 2021-07-02 17:33:43 CEST
perl-DBD-MariaDB can't be "downgraded" it is "new" but required to fix #29065 - so I pushed it to updates and not as "backport".
binutils is not an required update from this - so it should work without updating this package.
Comment 8 Ulrich Beckmann 2021-07-03 20:39:47 CEST
Please include perl-DBD-MariaDB in the package list, else testing with qarepo would fail.

https://wiki.mageia.org/en/QA_Repo

Ulrich
Comment 9 Dave Hodgins 2021-07-03 22:26:04 CEST
Confirming comment 8.

# urpmq --requires mariadb-common-10.5.11-2.mga8.x86_64 2>/dev/null|grep DBD 
perl(DBD::MariaDB))

If it isn't included in the package list, perl-DBD-MariaDB-1.210.0-6.mga8.src.rpm
would stay in core updates testing after the rest of the packages were moved
to core updates, and then fail to install on regular systems.

CC: (none) => davidwhodgins

Comment 10 Marc Krämer 2021-07-04 10:12:22 CEST
Sorry, here is the changed advisory.

Updated mariadb packages fix some bugs:

- InnoDB recovery fails
- Potential hang in purge for virtual columns
- Change buffer records are lost under heavy load
- Replication: Fix optistic parallel applier to not deadlock on admin commands

This update also fixes mysqlhotcopy, which was not working before this update (mga#29065).

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

Updated packages in core/updates_testing:
========================
perl-DBD-MariaDB-1.210.0-6.mga8
mariadb-core-debuginfo-10.5.11-2.mga8
mariadb-bench-10.5.11-2.mga8
mariadb-common-debuginfo-10.5.11-2.mga8
mariadb-common-10.5.11-2.mga8
mariadb-client-10.5.11-2.mga8
libmariadb-embedded-devel-debuginfo-10.5.11-2.mga8
libmariadbd19-debuginfo-10.5.11-2.mga8
mariadb-client-debuginfo-10.5.11-2.mga8
libmariadb-embedded-devel-10.5.11-2.mga8
mariadb-core-10.5.11-2.mga8
libmariadb-devel-10.5.11-2.mga8
mariadb-mroonga-debuginfo-10.5.11-2.mga8
mariadb-spider-debuginfo-10.5.11-2.mga8
libmariadbd19-10.5.11-2.mga8
mariadb-bench-debuginfo-10.5.11-2.mga8
mariadb-mroonga-10.5.11-2.mga8
mariadb-connect-debuginfo-10.5.11-2.mga8
mariadb-debuginfo-10.5.11-2.mga8
mariadb-debugsource-10.5.11-2.mga8
mariadb-connect-10.5.11-2.mga8
mariadb-feedback-debuginfo-10.5.11-2.mga8
mariadb-spider-10.5.11-2.mga8
mariadb-10.5.11-2.mga8
mariadb-sphinx-debuginfo-10.5.11-2.mga8
mariadb-extra-debuginfo-10.5.11-2.mga8
libmariadb3-debuginfo-10.5.11-2.mga8
mariadb-obsolete-debuginfo-10.5.11-2.mga8
libmariadb3-10.5.11-2.mga8
mariadb-common-core-10.5.11-2.mga8
mariadb-sequence-debuginfo-10.5.11-2.mga8
mariadb-extra-10.5.11-2.mga8
mariadb-sphinx-10.5.11-2.mga8
mariadb-obsolete-10.5.11-2.mga8
mariadb-pam-debuginfo-10.5.11-2.mga8
mariadb-pam-10.5.11-2.mga8
mariadb-sequence-10.5.11-2.mga8
libmariadb-devel-debuginfo-10.5.11-2.mga8
mariadb-feedback-10.5.11-2.mga8
mysql-MariaDB-10.5.11-2.mga8

SRPM:
mariadb-10.5.11-2.mga8.src.rpm
perl-DBD-MariaDB-1.210.0-6.mga8.src.rpm
Comment 11 Ulrich Beckmann 2021-07-04 19:24:28 CEST
Created attachment 12844 [details]
List of installed packages, test logs

Repeated test of https://bugs.mageia.org/show_bug.cgi?id=29168#c4

Everything ok. No regression found.
Comment 12 Ulrich Beckmann 2021-07-04 19:26:12 CEST
Setting ok

Ulrich

Whiteboard: (none) => MGA8-64-OK

Comment 13 Thomas Andrews 2021-07-07 23:03:09 CEST
Regarding Comment 9, catching this sort of potential error is the very reason qarepo was created.

Thank you, Ulrich. Validating. Advisory in Comment 10.

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

Aurelien Oudelet 2021-07-08 22:56:50 CEST

Keywords: (none) => advisory
Source RPM: mariadb => mariadb-10.5.10-1.mga8.src.rpm
CC: (none) => ouaurelien

Comment 14 Mageia Robot 2021-07-09 00:44:35 CEST
An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2021-0144.html

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


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