Bobcares

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

PDF Header PDF Footer

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

0 Comments

Get featured on the Bobcares blog and share your expertise with a global tech audience.

WRITE FOR US

GET UP TO 25% OFF

Plesk Support

Spend time on your business, not on your servers.

Managing a server is time consuming. Whether you are an expert or a newbie, that is time you could use to focus on your product or service. Leave your server management & end-user tech support to us, and use that time to focus on the growth and success of your business.

TALK TO USOr click here to learn more.

Speed issues driving customers away?
We’ve got your back!