Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error while restoring MySQL Backups #2509

Open
1 task done
DonMarv00 opened this issue Sep 28, 2023 · 2 comments
Open
1 task done

Error while restoring MySQL Backups #2509

DonMarv00 opened this issue Sep 28, 2023 · 2 comments
Assignees
Labels
bug Bug report

Comments

@DonMarv00
Copy link

Description

When I try to restore mysql backups it fails almost everytime - i followed every guide on the pmm site but it doesn't work. This error only happens after editing the database.

I read about a bug that didn't received the state of mysqld this caused the error warning even after a successful restore - maybe this is an similar error? Maybe the MySQL server started to slow which causes this issue? Because the restore was successful - everything was restored correctly. (The hardware of the mysql server isn't the best - because its not used in production, just for testing at the moment.)

I also saw an youtube video which showed a "log" button in the restore list, is this not available for mysql restores? where can I find the output from xtrabackup when restoring backups via pmm?

I also would like to restore it directly with xxtrabackup which command is used by pmm to restore the backup? I looked in the source code but it is too large...

The restores in the red rectangle are from a clean installed mysql server without any changes, the yellow rectangles contains the restores after import the employees. (This also happens with any other changes too not only with the employees test database)

restore_error

Expected Results

Backups should be able to restore correctly without strange errors.

Actual Results

The Dashboard says that the restore was not successful (error, not more informations are available) but when I look into the /var/lib/mysql folder all files where restored correctly. The MySQL server also started without any issues.

Version

2.39

Steps to reproduce

  1. Install pmm with Docker
  2. Install the latest xtrabackup, pmm-client and mysql on ubuntu
  3. Create a backup, I use min.io as a S3 server
  4. Try to restore the backup - this should work because the MySQL server is untouched
  5. Import a test database I used employees (really popular test database)
  6. now create a new backup and try to restore it - probably it will work for the first time but after this the restores will fail almost every time

Relevant logs

I dont have relevant logs, pmm-managed log doenst contain anything about it, mysql is also running without any errors.

Code of Conduct

  • I agree to follow Percona Community Code of Conduct
@DonMarv00 DonMarv00 added the bug Bug report label Sep 28, 2023
@BupycHuk
Copy link
Member

BupycHuk commented Oct 3, 2023

Hi @MarvinStelter, could you run pmm-admin summary and attach logs from pmm-agent right after the failure?

@DonMarv00
Copy link
Author

Sorry for the late reply, I was on vacation.

Here's the pmm-agent.log file from the zip file created by pmm-admin summary
pmm-agent.log

Do you need the log from the pmm-server too?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Bug report
Projects
None yet
Development

No branches or pull requests

3 participants