psa-apsc database inconsistency. Can not import package ID '1' into APS controller: Failed to find images/icon.png in archive

Refers to:

  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux

Created:

2016-11-16 13:24:13 UTC

Modified:

2016-12-21 20:38:23 UTC

0

Was this article helpful?


Have more questions?

Submit a request

psa-apsc database inconsistency. Can not import package ID '1' into APS controller: Failed to find images/icon.png in archive

Symptoms

Upgrade operation failed. '/tmp/plesk_*_installation.log' or '/tmp/autoinstaller3.log' contain the alike errors:

2013-11-13T15:30:50+01:00 ERR (3): Can not import package ID '1' into APS controller: Failed to find images/icon.png in archive /usr/local/psa/var/apspackages/7f747f83-8d8d-430a-a87a-bffcea5a8453.zip. (Empty error message)
2013-11-13T15:30:50+01:00 ERR (3): Can not import package ID '2' into APS controller: Failed to find images/icon.png in archive /usr/local/psa/var/apspackages/8317bfa0-9ac4-4223-ae6e-afad598d020e.zip. (Empty error message)

Cause

The issue is caused by the database inconsistency, which blocks successful import of APS packages into apsc database.

The following SQL query will help to identify the inconsistency:

    mysql> select id, name from smb_apsPackages where registryUid is NULL;
+----+------------+
| id | name |
+----+------------+
| 1 | Coppermine |
| 2 | WordPress |
| 4 | osCommerce |
| 22 | joomla |
+----+------------+
4 rows in set (0.05 sec)

In the above example 'registryUid' records for these application packages are missed.

Resolution

The missed 'uid' records could be found with the following MySQL query (this query selects 'uid' records from 'psa.aps_registry_object' table):

    mysql> select p_pack.id, a_regob.uid as ApsPackage_uid, a_pack.name from psa.smb_apsPackages p_pack inner join apsc.aps_package a_pack on (p_pack.id = a_pack.id) inner join apsc.aps_registry_object a_regob on (a_pack.registry_object_id = a_regob.id) where p_pack.registryUid is NULL;
+----+--------------------------------------+------------+
| id | ApsPackage_uid | name |
+----+--------------------------------------+------------+
| 1 | 2f20fe1d-fb88-458c-a7c6-7c44c0f99c31 | Coppermine |
| 2 | 95f20770-30c4-4f99-b056-53ae0b7751b4 | WordPress |
| 4 | 2e3ddbc0-f21d-46b7-b41d-ab295f9a1c93 | osCommerce |
| 22 | b30a1bf3-c820-4036-87f1-3f2cd04678a4 | joomla |
+----+--------------------------------------+------------+
4 rows in set (0.00 sec)

In order to resolve the issue it is needed to insert obtained 'uid' records in the 'psa.smb_apsPackages' table:

mysql> update smb_apsPackages set registryUid="2f20fe1d-fb88-458c-a7c6-7c44c0f99c31" where id=1;
mysql> update smb_apsPackages set registryUid="95f20770-30c4-4f99-b056-53ae0b7751b4" where id=2;
mysql> update smb_apsPackages set registryUid="2e3ddbc0-f21d-46b7-b41d-ab295f9a1c93" where id=4;
mysql> update smb_apsPackages set registryUid="b30a1bf3-c820-4036-87f1-3f2cd04678a4" where id=22;
Have more questions? Submit a request
Please sign in to leave a comment.