• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

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

W

Wolfgang Reidlinger

Basic Pleskian
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?

1701381263611.png

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

Code: 
<?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.

Code: 
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.

1701381106826.png

Many thanks,
Cheers!
 
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.
 
Thanks @Peter Debik for this hint. Looks like a bunch of services stopped just seconds before the backup error occurred.


Bash: 
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.
 
You must log in or register to reply here.

Similar threads

B
Issue Remote Backup to Microsoft OneDrive Error
2 3
Replies
51
Views
5K
Pandur2000
Pandur2000
M
Issue File dump-header not found on first position in archive.
Replies
0
Views
1K
massin
M
H
Issue Backup failing to connect to remote FTP server
Replies
5
Views
3K
Peter Debik
P
C
Resolved Mariadb not working - DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
7
Views
3K
Crash79797
C
S
Resolved Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
10
Views
3K
Shasam
S
Back
Top