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

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


SAY GOODBYE TO SLEEPLESS NIGHTS

dedicated support night work

Remote techs work exclusively for your company, and take care of your customers & servers overnight.

As low as

$12.99/hour

SEE SERVICE DETAILS