Plesk is not accessible: Unable to find service node for web service on domain

[mahesh]

Question:
Plesk is not accessible: Unable to find service node for web service on domain with id=xxx
Symptoms

• When trying to log into Plesk or when trying to open a domain in dashboard, Plesk shows the following error:

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

• The command "plesk repair db" reports the following error message:

Code Select Expand

#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
Inconsistency in the Plesk database.

Resolution
Note: Steps below are the same for both Linux and Windows. 

1.Connect to the Plesk server via SSH/RDP.

2.Create a dump of the Plesk database.

3.Connect to the Plesk database with the command (On Windows Server use a command prompt):

Code Select Expand

#plesk db
4.Find the domain's "ip_address_id" using dom_id value from the error message (for example  dom_id = 111):

Code Select Expand

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

Code Select Expand

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

Code Select Expand

mysql> select * from IpAddressesCollections where ipCollectionId=25;
+----------------+-------------+
| ipCollectionId | ipAddressId |
+----------------+-------------+
| 25             | 1           |
+----------------+-------------+
7.Find the next free value for the "id" field in the DomainServices table:

Code Select Expand

mysql> select max(id)+1 from DomainServices;
-------+
| max(id)+1 |
+----------
+-----+
| 1447      |
+-----------+
8.Create the missing records using id from step 7 (in this example id=1447) and ipCollectionId as 1 + the value from step 6 (in this example ipCollectionId=26 [25+1]):

• In the DomainServices table:

Code Select Expand

mysql> insert into DomainServices (id, dom_id, type, status, parameters_id, ipCollectionId) values ('1447', '111', 'web', '0', '0', '26');

• In the IpAddressesCollections table:

Code Select Expand

mysql> insert into IpAddressesCollections (ipCollectionId, ipAddressId) values ('26', '1');


• In the IpCollections table:

Code Select Expand

mysql> insert into IpCollections (id) values ('26');