Unable to backup with mysql 8.0.36

[charlypa]

Description

While attempting to back up, I am getting the following error as shown in screenshot the

Expected Results

Backup works correctly while running as a command in the terminal. So it should ideally I should be able to backup

Actual Results

Please see screen shot

Version

PMM server latest ProjectName: pmm-admin Version: 2.41.1 PMMVersion: 2.41.1 Timestamp: 2024-01-30 13:27:05 (UTC) FullCommit: f4004eac5c03e97327ae235dbf40f91e31ba2208

Steps to reproduce

try to create full backup with latest PMM client and server

Relevant logs

No response

Code of Conduct

• [X] I agree to follow Percona Community Code of Conduct

[lamka02sk]

Is there any update or ETA on the issue?

[BupycHuk]

Hi, no update so far

[vishwas-sharma2480]

hi @BupycHuk can i replicate this issue in a local env ?

[vishwas-sharma2480]

Hi @lamka02sk are you tryingto start a backup or scheduling a backup ?

[lamka02sk]

Hi @vishwas-sharma2480 , both. We already had scheduled backup set up before the breaking update and it just stopped working after. Manually starting backup throws the same error.

[vishwas-sharma2480]

@lamka02sk Are you using it for mongodb as well if so are you facing the same issue ?

[lamka02sk]

@lamka02sk Are you using it for mongodb as well if so are you facing the same issue ?

@vishwas-sharma2480 No, just Percona for MySQL.

[TomokiMuto]

This issue seems to occur when using xtrabackup version 8.0.35 with MySQL version 8.0.36. While xtrabackup 8.0.35-30 has completed compatibility with MySQL version 8.0.36, it is possible that PMM is performing its own version check and comparing releases.

https://forums.percona.com/t/xtrabackup-for-mysql-8-0-36/29461

Here is a relevant code snippet from pmm/managed/services/backup/compatibility_helpers.go:

var (
    mysqlAndXtrabackupCompatibleVersions []compatibility
    // Starting from MySQL 8.0.22 if the Percona XtraBackup version is lower than the database version,
    // processing will be stopped and Percona XtraBackup will not be allowed to continue.
    // https://www.percona.com/blog/2020/08/18/aligning-percona-xtrabackup-versions-with-percona-server-for-mysql/
    alignedXtrabackupVersion = version.Must(version.NewVersion("8.0.22"))
    // Since there is no version 9 or greater let's limit aligning rule by this number.
    maxAlignedXtrabackupVersion = version.Must(version.NewVersion("9.0"))

    pbmMinSupportedVersion = version.Must(version.NewVersion("2.0.1"))
)

This might indicate that PMM has a hard-coded version check that needs to be updated to reflect the new compatibility.

[lutek]

the same "xtrabackup version "8.0.35-31" is not compatible with mysql version "8.0.37-29": incompatible xtrabackup"

[katsil]

Hi, is there any news when this issue will be resolved?

[BupycHuk]

Hello @katsil, backup related tasks are on hold right now, we are focused on PMM 3 related issues