Symptoms
- Unable to access Plesk > Domains > example.com page with the error:
PLESK_ERROR: Error: Unable to find service node for ip address with id=
- The "plesk repair db" utility reports the following inconsistencies:
MYSQL_WIN: Inconsistency in the table 'DomainServices' for the column
ipCollectionId: Web service cannot operate: the IP address list with
ID 63 is empty .................................................... [ERROR]
Cause
Database inconsistency
Resolution
- Log into the server via RDP
- Start a command prompt as Administrator
- Create a backup for psa database in C:\ root:
MYSQL_WIN: plesk db dump psa > C:\psa.sql
- Find database inconsistency:
MYSQL_WIN: plesk repair db -n
The output will be similar to the following:
MYSQL_WIN: Inconsistency in the table 'DomainServices' for the column
ipCollectionId: Web service cannot operate: the IP address list with
ID 63 is empty .................................................... [ERROR] - Using the ID from the error above, findv ID of the affected domain:
MYSQL_WIN: plesk db " select * from DomainServices where ipCollectionId = 63;"
+------+--------+------+--------+---------------+----------------+
| id | dom_id | type | status | parameters_id | ipCollectionId |
+------+--------+------+--------+---------------+----------------+
| 2126 | 924 | web | 0 | 0 | 63 |
+------+--------+------+--------+---------------+----------------+ - Then find the name of the affected domain by executing the following command, using dom_id found on the previous step as id:
MYSQL_WIN: plesk db "select name from domains where id=924;"
+---------------+
| name |
+---------------+
| exampe.com |
+---------------+ -
Using the query below, determine that example.com domain is hosted on IP 203.0.13.2:
MYSQL_WIN: plesk db "select val,displayVal from dns_recs where host like '%example.com%';"
..................................................
+------------------------------+------------------------------+
| val | displayVal
+------------------------------+------------------------------+
| 203.0.13.2 | 203.0.13.2
| 203.0.13.2 | 203.0.13.2 | -
Find ID of the 203.0.13.2 IP:
MYSQL_WIN: plesk db "select id from IP_Addresses where ip_address='203.0.13.2';"
+----+
| id |
+----+
| 60 |
+----+ -
Run the following commands one by one to fix database inconsistency for example.com domain:
MYSQL_WIN: plesk db "insert into IpAddressesCollections values(63, 60)"
MYSQL_WIN: plesk db "insert into IpAddressesCollections values(63, 60)"
Comments
0 comments
Please sign in to leave a comment.