Internal error: Unable to find service node for web service on domain with id=xxx

Created:

2016-11-16 13:09:30 UTC

Modified:

2017-04-24 11:56:03 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Internal error: Unable to find service node for web service on domain with id=xxx

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

  1. When trying to log into Plesk or when trying to open the domain Plesk shows the following error:

    Internal error: Unable to find service node for web service on domain with id=111
  2. plesk repair utility with db option finds database inconsistency in PSA database, but does not suggest to fix it:

    # plesk repair db -n
    Inconsistency in the table 'domains' for the column id: No rows in the table 'DomainServices' with type = 'web', dom_id = 111 ........ [ERROR]

Cause

Database inconsistency.

Resolution

Recreate missing records in database:

  1. Find the domain's ip_address_id :

    mysql> select param, val from dom_param where dom_id=111 and param='ip_addr_id';
    +------------+------+
    | param | val |
    +------------+------+
    | ip_addr_id | 1 |
    +------------+------+
  2. Find the id in DomainServices for the type mail :

    mysql> select * from DomainServices where dom_id = 111;
    +------+--------+------+--------+---------------+----------------+
    | id | dom_id | type | status | parameters_id | ipCollectionId |
    +------+--------+------+--------+---------------+----------------+
    | 1416 | 111 | mail | 0 | 639 | 1416 |
  3. Find ID of IP address assigned to the domain:

    mysql> select * from IpAddressesCollections where ipCollectionId=1416;
    +----------------+-------------+
    | ipCollectionId | ipAddressId |
    +----------------+-------------+
    | 1416 | 1 |
    +----------------+-------------+
  4. Find unused value for ID field in DomainServices table:

    mysql> select max(id)+1 from DomainServices;
    +-----------+
    | max(id)+1 |
    +-----------+
    | 1447 |
    +-----------+
  5. Create the missing records using ID=1447:

    • In DomainServices :

      insert into DomainServices (id, dom_id, type, status, parameters_id, ipCollectionId) values ('1417', '111', 'web', '0', '0', '1417');
    • In IpAddressesCollections , note that value for ipAddressId field should be the same as founded in step 3:

      insert into IpAddressesCollections (ipCollectionId, ipAddressId) values ('1417', '1');
    • In IpCollections :

      insert into IpCollections (id) values ('1417');
Have more questions? Submit a request
Please sign in to leave a comment.