Deleting a domain in Odin Plesk giving you the error “Unable to find service node for web service”? Here’s how to fix it

In Odin Plesk Linux servers, deleting a domain sometimes results in the error “Internal error: Unable to find service node for web service on domain with id=XX“. It may also cause inability to access certain control panel features.

Plesk log file shows the following detail:

PleskDBException: Unable to find service node for web service on domain with id=XX
file: /usr/local/psa/admin/plib/PhDomain.php
line: 1404

This issue is caused by database inconsistency, and can be resolved by updating the domain directly in PSA database.

Take a backup of the PSA table using the below command:

# mysqldump -uadmin -p$(cat /etc/psa/.psa.shadow) psa > /root/psa_backup.sql

Update the hosting type of domain to “none” and try deleting the domain again.

mysql> update domains set htype='none' where id=XX;

If it still didnt help you, delete the DNS records manually by using the below commands:

mysql> delete from domains where id=XX;
mysql> delete from dns_zone where name='domain.tld';
mysql> delete from dns_recs where displayHost like '%domain.tld%';

This should get your database into consistent state.

This error can also be returned when performing actions like managing a domain, domain reconfiguration, domain listing, etc. All of these points to a database inconsistency, and need different solutions. If you are not sure which solution to choose, click below to send us a quick mail. We’d be happy to help.

FIX MY SERVER