Issue Can't restore specific database from backup

[mediengestalter]

Server operating system version

Ubuntu 22.04.4 LTS

Plesk version and microupdate number

18.0.66 #2 Web Host Edition

I've accidently deleted a database and need to restore it from a (full) backup in the plesk backup-manager.
After I select the one specific database I need to restore, it's acting as if it's doing something for a while until the progress-notification changes to (in German)

Die Wiederherstellung des Backups 10. Febr. 2025 02:15:00 ist fehlgeschlagen.

Showing/Downloading the protocol gives a empty .txt file.
What's the problem with Plesk Backup-Manager?

 

[scsa20]

You would need to look at the logs and see what's happening. A generic failure error isn't enough to go off by. You can find the log files for the backup and restore over at https://support.plesk.com/hc/en-us/...ere-are-Plesk-backup-restoration-logs-located

 

[mediengestalter]

For everyone:

%plesk_dir%

in Ubuntu is

/usr/local/psa/

Why is there a empty log file view, if theres actually log files?!

So this is the last view lines:

[2025-02-12 17:54:32.496|1092758] INFO: Repository '/var/lib/psa/dumps/': Import content from ext://s3-backup/server//backup_2502100215.tar
[2025-02-12 17:54:32.496|1092758] INFO: Repository '/var/lib/psa/dumps/pmm-repo-icon-content-YtWfg6': Initializing...
[2025-02-12 17:54:32.496|1092758] INFO: Repository '/var/lib/psa/dumps/pmm-repo-icon-content-YtWfg6': Initialized
[2025-02-12 17:54:32.496|1092758] INFO: ENV[LANG]=en_US.UTF-8
[2025-02-12 17:54:32.496|1092758] INFO: Executing utility: /opt/psa/admin/bin/backup_restore_helper --extension-transport ext://s3-backup/server/ -operation list -path ''
[2025-02-12 17:54:33.099|1092758] INFO: The utility succesfully executed.
[2025-02-12 17:54:33.102|1092758] INFO: Load settings from /opt/psa/admin/conf/panel.ini
[2025-02-12 17:54:33.105|1092758] INFO: Read 10485760 bytes from the end of the dump
[2025-02-12 17:54:33.106|1092758] INFO: ENV[LANG]=en_US.UTF-8
[2025-02-12 17:54:33.106|1092758] INFO: Executing utility: /opt/psa/admin/bin/backup_restore_helper --extension-transport ext://s3-backup/server/ -operation get-read-buffer-size
[2025-02-12 17:54:33.232|1092758] INFO: The utility succesfully executed.
[2025-02-12 17:54:34.453|1092758] INFO: Found archive meta
[2025-02-12 17:54:34.459|1092758] INFO: Found blocks signatures
[2025-02-12 17:54:36.536|1092758] INFO: Import subdump files.
[2025-02-12 17:59:57.882|1092758] INFO: Failed to parse the utility output: <unspecified file>(1): expected value
[2025-02-12 17:59:59.195|1092758] INFO: TransportError Transport error: Failed to read a file from an external repository, see the log files [common/plesk-utils/PMM/repository-transport/repository_transport_external.cpp:TransportError]
size_t plesk::RepositoryTransportExternal::ReadFileFromBuf(void*, size_t)
[2025-02-12 17:59:59.196|1092758] INFO: pmm-ras finished. Exit code: 1

Searched the whole filesystem for the mentioned

repository_transport_external.cpp

. Can't find it... Why is there a relative filepath mentioned, targeted from another directory?

 

[mediengestalter]

Okay, Problem resolved. To restore a ~5MB Database from Remote Backups (not inkremental) you have to free up huge amounts of space on your server.
With the issue, I had 50GB of free space. That wasn't enough to restore 5MB. And maybe the disk space is also the reason, why the logs were empty in the "User"-Interface.
After deleting another 30GB (that I have to restore manually now I guess) it "works".
Don't know why I'm still paying for this... Plesk was ment to help with server management. But all the time it takes to find out about the reasons why Plesk does things the way it does, takes more time than doing the things without it...

edit: Looks like the space taken for restoring the backup is not deleted after restoring is done... One more thing...

 

[mediengestalter]

edit: Looks like the space taken for restoring the backup is not deleted after restoring is done... One more thing...

So to free up disk space after restoring a backup you have to SSH to your server and dig through your filesystem to find heaps of backup_*.tzst files.

du -ah . | sort -rh | head -n 10

 

[Kaspar]

Okay, Problem resolved. To restore a ~5MB Database from Remote Backups (not inkremental) you have to free up huge amounts of space on your server.
With the issue, I had 50GB of free space. That wasn't enough to restore 5MB. And maybe the disk space is also the reason, why the logs were empty in the "User"-Interface. After deleting another 30GB (that I have to restore manually now I guess) it "works".

Any database (or file for that matter) is nested within the complete backup archive. To restore just a single file or database a sizable part of the backup archive has to be extracted in order to get to that file or database. That perhaps could be conceded a draw back of the comprehensive backup approche Plesk uses. (The upside being that server wide backups are much easier to restore, especially on another server).

edit: Looks like the space taken for restoring the backup is not deleted after restoring is done... One more thing...

That is unfortunate indeed.