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

Created:

2017-06-07 19:45:42 UTC

Modified:

2017-08-16 16:15:31 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 for Linux

Symptoms

  • Reconfiguration failed with the following error:
    Unable to find service node for ip address with id=
  • The query below return a domain name:

    
       mysql> select d.id,h.dom_id from domains as d left join hosting as h on d.id=h.dom_id where d.htype='vrt_hst' and h.dom_id IS NULL;
    +----+--------+
    | id | dom_id |
    +----+--------+
    | 1 | NULL |
    +----+--------+
    1 row in set (0.00 sec)

Cause

Database inconsistency. Domain has 'vrt_hst' hosting type, but there is no record for this domain in hosting table.

Resolution

Create psa database backup


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

    mysql> select d.id,d.name,h.dom_id from domains as d left join hosting as h on d.id=h.dom_id where d.htype='vrt_hst' and h.dom_id IS NULL;
    +----+------------+--------+
    | id | name | dom_id |
    +----+------------+--------+
    | 1 | example.com | NULL |
    +----+------------+--------+
    1 row in set (0.00 sec)
  2. Find the record from `hosting` table in plesk's backups:
    # zcat /var/lib/psa/dumps/*.gz | grep example | grep "INSERT INTO \`hosting\`" 
    INSERT INTO `hosting` VALUES (1,1,0,'false','false','true','false','plesk-php70-fpm','true','false','false','false','false','false','1.1','false','true','awstats','false',NULL,'/var/www/vhosts/example.com/httpdocs','false','false',3,-1,-1,'true','true')

    If the record exists in previously created dumps, insert it into hosting table. For example:
    mysql> begin;
    mysql> INSERT INTO `hosting` VALUES (1,1,0,'false','false','true','false','plesk-php70-fpm','true','false','false','false','false','false','1.1','false','true','awstats','false',NULL,'/var/www/vhosts/example.com/httpdocs','false','false',3,-1,-1,'true','true');
    mysql> commit;
  3. If the record could not be found in dumps, recreate the record for the domain in hosting table:
    mysql> insert into hosting (dom_id) values (1); #id of domain from point 1. 

Have more questions? Submit a request
Please sign in to leave a comment.