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,

http://forum.parallels.com/showthread.php?t=112475
http://forum.parallels.com/showthread.php?t=112437