Cannot remove subscription: resource of type aps.database with id <id> not found by brokers

Created:

2016-11-16 13:17:05 UTC

Modified:

2017-08-16 17:17:35 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot remove subscription: resource of type aps.database with id <id> not found by brokers

Applicable to:

  • Plesk Onyx for Linux
  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows

Symptoms

Cannot remove subscription, error is shown:

resource of type aps.database with id c283f909-ffa8-4b4a-a67c-58ee924f3ce2 not found by brokers

Cause

This issue caused by inconsistency in apsc database.

Resolution

  1. Backup psa database using article #213904125

  2. Login to psa database and find IDs to remove. Use uid from error:

    mysql> select * from apsc.aps_registry_object where uid='c283f909-ffa8-4b4a-a67c-58ee924f3ce2';
    +------+--------------------------------------+--------------+---------------------+---------+
    | id | uid | type | creation_time | enabled |
    +------+--------------------------------------+--------------+---------------------+---------+
    | 2522 | bb5d51e0-4f09-44f1-a072-2bc3ca959b7c | aps.resource | 2014-05-15 23:52:17 | y |
    +------+--------------------------------------+--------------+---------------------+---------+

    mysql> select * from apsc.aps_resource where registry_object_id=2522;
    +------+--------------------+--------------------+------------+---------------+--------+
    | id | registry_object_id | parent_resource_id | service_id | resource_type | app_id |
    +------+--------------------+--------------------+------------+---------------+--------+
    | 2085 | 2522 | NULL | | aps.database | NULL |
    +------+--------------------+--------------------+------------+---------------+--------+

    mysql> select * from apsc.aps_resource_adjacency_list where base_resource_id=2085;
    +------+------------------+-----------------------+----------+------------------+--------+----------------+
    | id | base_resource_id | dependent_resource_id | relation | uniqueness_scope | branch | requirement_id |
    +------+------------------+-----------------------+----------+------------------+--------+----------------+
    | 1531 | 2085 | 2083 | e | | NULL | main |
    +------+------------------+-----------------------+----------+------------------+--------+----------------+
  3. Remove the data using IDs above:

    mysql> delete from aps_resource_adjacency_list where base_resource_id=2085;
    mysql> delete from aps_resource where registry_object_id=2522;
    mysql> delete from aps_registry_object where id=2522;
  4. Try to remove subscription again.

Have more questions? Submit a request
Please sign in to leave a comment.