Issue backup task error | Unable to save statistics. Error: DB query failed: SQLSTATE[HY000] [2002] No such file or directory

[Wolfgang Reidlinger]

Server operating system version

Ubuntu 20.04.6 LTS

Plesk version and microupdate number

18.0.57.2

Hi there,

recently I got an error from the scheduled backup task. Somebody did see something similar before?



This is the content of the migration.result file attacked on the backup task notification email.

<?xml version="1.0"?>
<execution-result log-location="/opt/psa/PMM/sessions/2023-11-26-013319.597/migration.result" local-dump-created="true" export-dump-created="false" local-dump-name="backup_info_2311260133.xml" export-dump-name="backup_2311260133.tar" custom-log-file="/var/log/plesk/PMM/backup-2023-11-26-01-33-19-596/backup.log" status="error">
  <message severity="error">
    <description>Unable to create the remote backup: Transport error: Extension transport: ext://sftp-backup/server/:</description>
  </message>
  <message severity="warning">
    <description>Unable to save statistics. Error: DB query failed: SQLSTATE[HY000] [2002] No such file or directory</description>
  </message>
</execution-result>

Here you can see the content of the refered log file.

superadmin@server:~$ sudo cat /var/log/plesk/PMM/backup-2023-11-26-01-33-19-596/backup.log | grep error

[2023-11-26 04:30:06.272|576328] INFO: TransportError Transport error: Extension transport: ext://sftp-backup/server:  [common/plesk-utils/PMM/repository-transport/repository_transport_external.cpp:TransportError]
[2023-11-26 04:30:06.381|576328] INFO: TransportError Transport error: Extension transport: ext://sftp-backup/server:  [common/plesk-utils/PMM/repository-transport/repository_transport_external.cpp:TransportError]
[2023-11-26 04:30:06.381|576328] INFO: RepositoryError Repository error: file backup_2311260133.tar not exists [common/plesk-utils/PMM/repository-transport/repository.cpp:RepositoryError]
[2023-11-26 04:30:05.861|504399] INFO: TransportError Transport error: Extension transport: ext://sftp-backup/server/:  [common/plesk-utils/PMM/repository-transport/repository_transport_external.cpp:TransportError]
[2023-11-26 04:30:05.864|504310] ERR [panel] Unable to create the remote backup: Transport error: Extension transport: ext://sftp-backup/server/:

The is how the backup task is configured. Its only stored via SFTP (SSH) not locally.



Many thanks,
Cheers!

 

[Peter Debik]

The database error "DB query failed: SQLSTATE[HY000] [2002] No such file or directory" normally means that at that time the database server was not online. This can happen for a number of reasons. I suggest you check /var/log/messages (/var/log/syslog et. al.) what happened at the server at the time when the error was logged.

 

[Wolfgang Reidlinger]

Thanks @Peter Debik for this hint. Looks like a bunch of services stopped just seconds before the backup error occurred.

Nov 26 04:30:01 hosting systemd[1]: Condition check resulted in Network Time Synchronization being skipped.
Nov 26 04:30:01 hosting systemd[1]: Removed slice system-modprobe.slice.
Nov 26 04:30:01 hosting systemd[1]: Stopped target Graphical Interface.
Nov 26 04:30:01 hosting systemd[1]: Stopped target Multi-User System.
Nov 26 04:30:01 hosting systemd[1]: Stopped target Login Prompts.
Nov 26 04:30:01 hosting systemd[1]: Stopped target Remote Encrypted Volumes.
Nov 26 04:30:01 hosting systemd[1]: Stopped target Timers.
Nov 26 04:30:01 hosting systemd[1]: apt-daily-upgrade.timer: Succeeded.
Nov 26 04:30:01 hosting systemd[1]: Stopped Daily apt upgrade and clean activities.
Nov 26 04:30:01 hosting systemd[1]: e2scrub_all.timer: Succeeded.
Nov 26 04:30:01 hosting systemd[1]: Stopped Periodic ext4 Online Metadata Check for All Filesystems.
Nov 26 04:30:01 hosting systemd[1]: logrotate.timer: Succeeded.
Nov 26 04:30:01 hosting systemd[1]: Stopped Daily rotation of log files.
Nov 26 04:30:01 hosting systemd[1]: man-db.timer: Succeeded.
Nov 26 04:30:01 hosting systemd[1]: Stopped Daily man-db regeneration.
Nov 26 04:30:01 hosting systemd[1]: motd-news.timer: Succeeded.
Nov 26 04:30:01 hosting systemd[1]: Stopped Message of the Day.
Nov 26 04:30:01 hosting systemd[1]: systemd-tmpfiles-clean.timer: Succeeded.
Nov 26 04:30:01 hosting systemd[1]: Stopped Daily Cleanup of Temporary Directories.
Nov 26 04:30:01 hosting systemd[1]: Stopped target System Time Synchronized.
Nov 26 04:30:01 hosting systemd[1]: Stopped target System Time Set.
Nov 26 04:30:01 hosting systemd[1]: Stopping agent360...
Nov 26 04:30:01 hosting systemd[1]: Stopping The Apache HTTP Server...
Nov 26 04:30:01 hosting systemd[1]: Stopping Checkmk agent - Asynchronous background tasks...
Nov 26 04:30:01 hosting systemd[1]: Stopping Checkmk agent (PID 383/UID 985)...
Nov 26 04:30:01 hosting systemd[1]: Stopping Checkmk agent controller daemon...
Nov 26 04:30:01 hosting systemd[1]: Stopping Console Getty...
Nov 26 04:30:01 hosting systemd[1]: Stopping Regular background program processing daemon...
Nov 26 04:30:01 hosting systemd[1]: Stopping D-Bus System Message Bus...
Nov 26 04:30:01 hosting systemd[1]: Stopping Dovecot IMAP/POP3 email server...
Nov 26 04:30:01 hosting systemd[1]: Stopping Fail2Ban Service...
Nov 26 04:30:01 hosting systemd[1]: Stopping Getty on tty2...
Nov 26 04:30:01 hosting systemd[1]: Stopping Grafana instance...
Nov 26 04:30:01 hosting systemd[1]: Stopping LSB: modules.dep creation....
Nov 26 04:30:01 hosting systemd[1]: Stopping Startup script for nginx service...
Nov 26 04:30:01 hosting systemd[1]: Stopping Plesk mail filter service for Postfix...
Nov 26 04:30:01 hosting systemd[1]: Stopping The PHP 8.0.30 FastCGI Process Manager...
Nov 26 04:30:01 hosting systemd[1]: Stopping plesk-php80-fpm_subdomain.domain.com_2.service...
Nov 26 04:30:01 hosting systemd[1]: Stopping Plesk SSH Terminal Backend Service...
Nov 26 04:30:01 hosting systemd[1]: Stopping Plesk Task Manager Service...
Nov 26 04:30:01 hosting systemd[1]: Stopping Plesk Web Socket Service...
Nov 26 04:30:01 hosting systemd[1]: postfix.service: Succeeded.
Nov 26 04:30:01 hosting systemd[1]: Stopped Postfix Mail Transport Agent.
Nov 26 04:30:01 hosting dovecot: master: Warning: Killed with signal 15 (by pid=576270 uid=0 code=kill)
Nov 26 04:30:01 hosting systemd[1]: Stopping Postfix Mail Transport Agent (instance -)...
Nov 26 04:30:01 hosting systemd[1]: psa.service: Succeeded.
Nov 26 04:30:01 hosting systemd[1]: Stopped Plesk Panel.

Seconds after all the services started again. Why this happened - I can't tell. Did not find anything in the logs.