Reconfiguration failed: Unable to find service node for ip address with id=

Created:

2016-12-12 03:45:46 UTC

Modified:

2017-08-08 13:40:51 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Reconfiguration failed: Unable to find service node for ip address with id=

Applicable to:

  • Plesk

Symptoms

  • Reconfiguration failed with

    Unable to find service node for ip address with id=

  • The query below return a domain name:

    
       mysql> select d.name, d.id from psa.domains d, psa.DomainServices ds where ds.dom_id=d.id and ds.type='web' and d.htype='none';
    +----+------------+
    | id | domain.tld |
    +----+------------+
    | 8 | domain.tld |
    +----+------------+
    1 row in set (0.00 sec)

Cause

Database inconsistency

Resolution

  1. Create psa database backup

    
       plesk db dump > psa.dump.`date +%F.%s`.sql
      
  • Obtain affected domain name and id:

    mysql> select d.name, d.id from psa.domains d, psa.DomainServices ds where ds.dom_id=d.id and ds.type='web' and d.htype='none';
    +----+------------+
    | id | domain.tld |
    +----+------------+
    | 8 | domain.tld |
    +----+------------+
  • Remove invalid record from the psa database

    mysql> begin;
    mysql> delete from psa.DomainServices where dom_id = <ID> and type='web' # <ID> is domain id from the query above
    mysql> commit;
  • Have more questions? Submit a request
    Please sign in to leave a comment.