• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved Backup job cannot find domain?

raytracy

Basic Pleskian
My scheduled backup job report it cannot find my domain as following error:

upload_2017-8-16_23-43-32.png

I have ran it manually and got the same error. The Onyx hosted one domain only.
I trace the backup.log and found this:

[10279]: 2017-08-16 23:25:22.459 DEBUG Execute: df -P -k /var/lib/psa/dumps
[10279]: 2017-08-16 23:25:22.463 DEBUG Reserve disk space at /var/lib/psa/dumps/.fs_NaN_0
[10279]: 2017-08-16 23:25:22.463 DEBUG Exec: dd if=/dev/zero of=/var/lib/psa/dumps/.fs_NaN_0 bs=31457
280 count=1
[10279]: 2017-08-16 23:25:22.489 DEBUG Set backup file name 'backup' (profile 'backup', id='')

[10279]: 2017-08-16 23:25:22.490 DEBUG Unix Archive content transport has been initialized
[10279]: 2017-08-16 23:25:23.502 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:24.502 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:25.502 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:26.503 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:27.503 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:28.503 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:29.504 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:30.504 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:31.504 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:32.505 DEBUG Connection to mysql database failed. Try again...
[10279]: 2017-08-16 23:25:32.532 DEBUG New connection: mysql shell connection. db psa, user admin, ho
st localhost
[10279]: 2017-08-16 23:25:32.532 TRACE SQL: SELECT ip_address, id FROM IP_Addresses: Params:
[10279]: 2017-08-16 23:25:32.539 TRACE SQL: SELECT c.id, c.login, p.ip_address, c.type, c.parent_id, pl.type, c.guid FROM clients c LEFT JOIN ip_pool pl ON c.pool_id = pl.id LEFT JOIN IP_Addresses p ON pl.ip_address_id = p.id: Params:
[10279]: 2017-08-16 23:25:32.546 TRACE SQL: SELECT DISTINCT BINARY domains.displayName, IP_Addresses.ip_address FROM DomainServices, IpAddressesCollections, IP_Addresses, domains WHERE DomainServices.dom_id = domains.id AND DomainServices.ipCollectionId = IpAddressesCollections.ipCollectionId AND IpAddressesCollections.ipAddressId = IP_Addresses.id AND domains.webspace_id = 0 : Params:
[10279]: 2017-08-16 23:25:32.553 TRACE SQL: SELECT d.displayName FROM domains d WHERE htype = 'none' AND webspace_id = 0: Params:
[10279]: 2017-08-16 23:25:32.561 TRACE SQL: SELECT d.displayName, d.name, c.login, c.id, d.id dom_id FROM clients c LEFT JOIN domains d ON d.cl_id = c.id WHERE d.webspace_id = 0: Params:
[10279]: 2017-08-16 23:25:32.571 TRACE SQL: SELECT smb_users.login, clients.login FROM smb_users, clients WHERE smb_users.ownerId = clients.id: Params:
[10279]: 2017-08-16 23:25:32.579 TRACE SQL: SELECT smb_roles.id, clients.login FROM smb_roles, clients WHERE smb_roles.ownerId = clients.id: Params:
[10279]: 2017-08-16 23:25:32.586 TRACE SQL: SELECT a.displayName, b.displayName FROM domains a INNER JOIN (SELECT id, displayName FROM domains) b WHERE a.webspace_id = b.id: Params:
[10279]: 2017-08-16 23:25:32.593 TRACE SQL: SELECT s.object_id, t.id FROM Subscriptions AS s INNER JOIN PlansSubscriptions AS p ON s.id = p.subscription_id INNER JOIN Templates AS t ON t.id = p.plan_id WHERE s.object_type = 'client' AND t.owner_id = (SELECT id FROM clients WHERE type = 'admin' LIMIT 0,1) AND t.type = 'reseller': Params:
[10279]: 2017-08-16 23:25:32.600 DEBUG Exec: /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/api-cli/service_node.php --describe-for-pmm-deployer
[10279]: 2017-08-16 23:25:32.796 DEBUG Output: <?xml version="1.0"?>
<service-nodes>
<service-node communication-ip-address="local" local="true" database-id="1" type="plesk">
<properties>
<property>
<name>OS_WIN</name>
<value>false</value>
</property>
<property>
<name>AWSTATS_BIN_D</name>
<value>/usr/share/awstats/wwwroot/cgi-bin</value>
</property>
<property>
<name>AWSTATS_DOC_D</name>
<value>/var/www/html/awstats</value>
</property>
<property>
<name>AWSTATS_ETC_D</name>
<value>/etc/awstats</value>
</property>
<property>
<name>AWSTATS_TOOLS_D</name>
<value>/usr/share/awstats/tools</value>
</property>
<property>
<name>CATALINA_HOME</name>
<value>/usr/share/tomcat</value>
</property>
<property>
<name>CGI_GIT_BIN</name>
<value>/var/www/cgi-bin/cgi_wrapper/git_wrapper</value>
</property>
<property>
<name>CGI_PHP_BIN</name>
<value>/var/www/cgi-bin/cgi_wrapper/cgi_wrapper</value>
</property>
<property>
<name>ENV_TYPE</name>
<value>HW</value>
</property>
<property>
<name>FULLHOSTNAME</name>
<value>psa-fbb.mori.cloud</value>
</property>
<property>
<name>HTTPD_BIN</name>
<value>/usr/sbin/httpd</value>
</property>
<property>
<name>HTTPD_CONF_D</name>
<value>/etc/httpd/conf</value>
</property>
<property>
<name>HTTPD_INCLUDE_D</name>
<value>/etc/httpd/conf.d</value>
</property>
<property>
<name>HTTPD_LOG_D</name>
<value>/var/log/httpd</value>
</property>
<property>
<name>HTTPD_SERVICE</name>
<value>httpd</value>
</property>
<property>
<name>HTTPD_VHOSTS_D</name>
<value>/var/www/vhosts</value>
</property>
<property>
<name>LIB_CRYPTO_PATH</name>
<value>/lib/libcrypto.so</value>
</property>
<property>
<name>LIB_SSL_PATH</name>
<value>/lib/libssl.so</value>
</property>
<property>
<name>MYSQL_BIN_D</name>
<value>/usr/bin</value>
</property>
<property>
<name>MYSQL_VAR_D</name>
<value>/var/lib/mysql</value>
</property>
<property>
<name>NGINX_CONF_DIR</name>
<value>/etc/nginx</value>
</property>
<property>
<name>NGINX_INCLUDE_D</name>
<value>/etc/nginx/conf.d</value>
</property>
<property>
<name>OPENSSL_BIN</name>
<value>/usr/bin/openssl</value>
</property>
<property>
<name>PRODUCT_RC_D</name>
<value>/etc/init.d</value>
</property>
<property>
<name>PRODUCT_ROOT_D</name>
<value>/usr/local/psa</value>
</property>
<property>
<name>PYTHON_BIN</name>
<value>/usr/bin/python</value>
</property>
<property>
<name>SNI_SUPPORT</name>
<value>true</value>
</property>
<property>
<name>synced</name>
<value>1501690502</value>
</property>
<property>
<name>TAR_BIN</name>
<value>/bin/tar</value>
</property>
<property>
<name>TOMCAT_MANAGER_URL</name>
<value>/manager/text/</value>
</property>
<property>
</property>
<property>
<name>TOMCAT_MANAGER_URL</name>
<value>/manager/text/</value>
</property>
<property>
<name>WEB_STAT</name>
<value>/usr/bin/webalizer</value>
</property>
</properties>
<ip-address>10.250.1.2</ip-address>
</service-node>
</property>
<property>
<name>TOMCAT_MANAGER_URL</name>
<value>/manager/text/</value>
</property>
<property>
<name>WEB_STAT</name>
<value>/usr/bin/webalizer</value>
</property>
</properties>
<ip-address>10.250.1.2</ip-address>
</service-node>
</service-nodes>


[10279]: 2017-08-16 23:25:32.829 DEBUG Execute: /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/sbin/backup_restore_helper --get-extensions-hooks
[10279]: 2017-08-16 23:25:33.533 TRACE SQL: SELECT id, host, port, type, admin_login, admin_password, server_version FROM DatabaseServers: Params:
[10279]: 2017-08-16 23:25:33.544 DEBUG Set backup owner guid 'ff7598e4-8a7c-4c68-9387-febfe1f0fd80', type 'server'

[10279]: 2017-08-16 23:25:33.544 WARN e5e7928f-37f3-40d6-87a9-9c556d6f5321 The following domains were not found on the host: fbbuy.com.tw


I can run plesk db command without problem, and don't know why it logged db connection failed in beginning? (that been logged every time I execute backup)

And another error looks strange:
[10279]: 2017-08-16 23:25:33.548 DEBUG Execute: /usr/local/psa/admin/sbin/pmm-ras --get-incremental-base --dump-storage="ftp://[email protected]//fbbuy.com.tw/" --dump-prefix="backup" --type= --guid= --debug --verbose --session-path="/usr/local/psa/PMM/sessions/2017-08-16-232452.353"
[10279]: 2017-08-16 23:25:33.559 DEBUG Unable to find suitable full dump to create increment, so full dump will be created. Error: Error: the argument for option '--type' should follow immediately after the equal sign


What can I do for next step?
 
Back
Top