Article ID: 127630, created on Nov 30, 2015, last review on Nov 30, 2015

  • Applies to:
  • Plesk Automation 11.5

Symptoms

  1. Task Upgrade instances of APS package with UID d2547650-a093-4dfc-92dc-95a9139268ee failed after Plesk Automation update installation.

  2. Last execution output from failed task (Domain id could be different):

    Unable to execute the command "/usr/local/psa/bin/aps". An error occurred during mass package instances upgrade: Unable to load object of type Domain with id=87: Domain does not exist.
    

Cause

Database inconsistency.

Resolution

  1. Login to PA Management node via SSH.

  2. Create a backup of the psa database:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > psadump.`date +%F_%H.%M`.sql
    
  3. Check if there is domain with id 87:

    mysql> select * from domains where id=87;
    Empty set (0.00 sec)
    
    mysql> select * from DomainServices where dom_id=87;
    +-----+--------+------+--------+---------------+----------------+
    | id  | dom_id | type | status | parameters_id | ipCollectionId |
    +-----+--------+------+--------+---------------+----------------+
    | 22  |     87 | web  |      0 |             0 |            222 |
    +-----+--------+------+--------+---------------+----------------+
    1 row in set (0.00 sec)
    
  4. As domain is absent, delete orphaned records in DomainServices and hosting tables:

    mysql> delete from DomainServices where dom_id=87;
    Query OK, 1 row affected (0.03 sec)
    
    mysql> delete from hosting where dom_id=87;
    Query OK, 1 row affected (0.03 sec)
    
    mysql> select * from IpAddressesCollections where ipCollectionId=222;
    +----------------+-------------+
    | ipCollectionId | ipAddressId |
    +----------------+-------------+
    |            222 |           1 |
    +----------------+-------------+
    1 row in set (0.00 sec)
    
    mysql> delete from ipAddressesCollections where  ipcollectionid=222;
    Query OK, 1 row affected (0.06 sec)
    
  5. Make sure that there is no additional domains in subscription with dom_id=87:

    mysql> select id,name,cl_id,parentdomainid from domains where parentdomainid=87;
    
  6. Check if there are orphaned records in psa database:

    mysql> select hosting.dom_id,hosting.www_root,domains.name from hosting left join domains on hosting.dom_id=domains.id where domains.name is NULL;
    
  7. Remove these records.

  8. Restart failed task

Search Words

Unable to load object of type Domain with id

Upgrade instances of APS package failed

Unable to execute the command "/usr/local/psa/bin/aps". An error occurred during mass package instances upgrade: Unable to load object of type Domain with id=13: Domain does not exist.

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF