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.