Home > Plesk > resource of type aps.database with id not found by brokers

resource of type aps.database with id not found by brokers

Recently I encountered the following error while trying to delete a domain from Parallels plesk panel(v10.3) .

[root@vps-1072749-5826 backup]# /usr/local/psa/bin/subscription -r domain.com
resource of type aps.database with id b67b9fe5-a016-4d5f-ba6e-b26ef378b068 not found by brokers
[root@vps-1072749-5826 backup]#

I found the below error in sw-cpsever error logs:

~]# tail -f /var/log/sw-cp-server/error_log
all children busy, launch additional (total 3, limit 30)
2011-11-12T11:18:06-05:00 CRIT (2): Exception: resource of type aps.database with id b67b9fe5-a016-4d5f-ba6e-b26ef378b068 not found by brokers
file: /usr/share/aps_php/aps_php.php
line: 10129
code: 0
all children busy, launch additional (total 3, limit 30)
2011-11-12T11:26:52-05:00 CRIT (2): Exception: resource of type aps.database with id b67b9fe5-a016-4d5f-ba6e-b26ef378b068 not found by brokers
file: /usr/share/aps_php/aps_php.php
line: 10129
code: 0

SOLUTION

Take a backup of psa and apsc databases.

#mysqldump -u admin -p`cat /etc/psa/.psa.shadow` psa > ~/psa.`date +%F_%H:%M`.sql
#mysqldump -u admin -p`cat /etc/psa/.psa.shadow` apsc > ~/apsc.`date +%F_%H:%M`.sql

From the apsc database I found the corresponding entries for uid “b67b9fe5-a016-4d5f-ba6e-b26ef378b068” :

mysql> select * from aps_resource_requirement where uid=’b67b9fe5-a016-4d5f-ba6e-b26ef378b068′;
+————————————–+————–+————-+—————-+—-+——–+
| uid | type | resource_id | requirement_id | id | branch |
+————————————–+————–+————-+—————-+—-+——–+
| b67b9fe5-a016-4d5f-ba6e-b26ef378b068 | aps.database | 10 | main | 43 | NULL |
+————————————–+————–+————-+—————-+—-+——–+
1 row in set (0.00 sec)

By using ‘resource_id’ I found the corresponding entries from “aps_resource” table:

mysql> select * from aps_resource where id=10;
+—-+——————–+——————–+————+———————————————-+
| id | registry_object_id | parent_resource_id | service_id | resource_type |
+—-+——————–+——————–+————+———————————————-+
| 10 | 297 | NULL | wordpress | aps::aps12::http://wordpress.org/::wordpress |
+—-+——————–+——————–+————+———————————————-+
1 row in set (0.00 sec)

From the “registry_object_id” I found the corresponding entries from “aps_registry_object” table:

mysql> select * from aps_registry_object where id=297;
+—–+————————————–+————–+———————+———+
| id | uid | type | creation_time | enabled |
+—–+————————————–+————–+———————+———+
| 297 | 5ccb8435-0489-4267-8760-ff2325a5719a | aps.resource | 2011-11-10 03:23:47 | y |
+—–+————————————–+————–+———————+———+
1 row in set (0.00 sec)

There I could see the difference value for ‘uid’. This was the cause for the issue.

Then I updated the ‘uid’ to proper value by following query:

mysql> update aps_registry_object set uid=’b67b9fe5-a016-4d5f-ba6e-b26ef378b068′ where id=297;
Query OK, 1 row affected (0.08 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Verified the updated entry:

mysql> select * from aps_registry_object where id=297;
+—–+————————————–+————–+———————+———+
| id | uid | type | creation_time | enabled |
+—–+————————————–+————–+———————+———+
| 297 | b67b9fe5-a016-4d5f-ba6e-b26ef378b068 | aps.resource | 2011-11-10 03:23:47 | y |
+—–+————————————–+————–+———————+———+
1 row in set (0.00 sec)

After that I was able to successfully delete the domain. Hope this helps someone:)

REFERENCES:
Same issue reported in the parallels forum url’s are provided below,

Advertisements
Categories: Plesk
  1. November 18, 2011 at 11:21 pm

    Worked awesome. Thanks! Now if only we can have Parallels produce a product that is not shit.

  2. January 14, 2013 at 11:28 am

    Excellent. Helped me solve an urgent similar Parallels problem.

  3. August 12, 2013 at 8:37 pm

    Thanks Reynold 🙂

  4. January 23, 2014 at 3:55 pm

    An outstanding share! I have just forwarded this onto a co-worker who was conducting a
    little research on this. And he actually bought me breakfast simply because I found it
    for him… lol. So let me reword this…. Thanks for the meal!!
    But yeah, thanx for spending time to discuss this issue here on your website.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: