Issue Database server (and sites) hanging during backup

[zed2007]

Server operating system version

Ubuntu 18.04.6 LTS

Plesk version and microupdate number

Version 18.0.49 Update #2

During the backup, the database server hangs. And, accordingly my sites too ( 504 ). Only restarting the database server helps. after one-two days, everything repeats.

OS: Ubuntu 18.04.6 LTS
DB Server: MariaDB 10.3.38
Plesk Obsidian: Version 18.0.49 Update #2

 

[Peter Debik]

Does this happen on every single backup, e.g. when you try to backup your server manually?
What is the server load during a backup?
How do you know that the database server hangs, e.g. did you check transactions with strace on the MariaDB (or MySQL) processes?

 

[zed2007]

Thank you very much for your response.
1. No. This is a scheduled backup. After restarting MariaDB for a next few days everything is fine. With manually backup too.
2. looks in order. nothing unusual.
3. I think so because after restarting the database server, my websites come back online. And also the protocol in Plesk indicates a problem with the database. ( screenshot in attachment)

 

[Peter Debik]

I think this could be a resource issue with disk space. How much disk space is left on the device and how big is the backup?

 

[mow]

Is there anything in the mysql error log?

 

[zed2007]

This is unlikely. On the server itself 645 Gb (75%) is free. And on the FTP server is also 1.5 Tb free.
Incremental Backup size ~ 6.9 Gb. Full-Backup ~ 53 Gb.

 

[zed2007]

And here is log.

 

[Peter Debik]

Why is your system attempting an upgrade of the database server? This is not initiated by the Plesk backup routine, neither by any Plesk maintenance script.

 

[zed2007]

Hmm...That´s a good question...
I´ll try to upgrade MariaDB to version 10.5.19 and see what happens.
Thanks for the feedback.