Applicable to:
- Plesk for Linux
- Plesk for Windows
Symptoms
-
Cannot create subscription or domain in Plesk::
PLESK_ERROR: Error: Unable to find service node for ip address with id=2
PLESK_ERROR: Error: Failed domain creation: Unable to update domain data: IP address with ID '2' does not exist
PLESK_ERROR: ERR [panel] Unable to load object of type BsDomain with id=XX: Domain does not exist.
-
Cannot manage Domains > example.com > Web Hosting Access settings:
PLESK_ERROR: Error: Unable to find service node for ip address with id=2
-
Cannot select "Send from domain IP addresses and use domain names in SMTP greeting" in Mail Server Settings:
PLESK_ERROR: Error: PleskException IP address with ID '2' does not exist
Cause
Database inconsistency: the
IP_Addresses
table has a record(s) with an IP address that does not exist in the
ip_pool
and
dom_param
tables.
Resolution
Note: below steps require advanced technical expertise. Consider contacting Plesk Technical support if you find them too complex.
- Log in to Plesk via SSH or RDP
-
Create Plesk database backup
-
Identify the problematic IP address:
# plesk db "select * from ip_pool where ip_address_id not in (select id from IP_Addresses);"
+----+---------------+--------+
| id | ip_address_id | type |
+----+---------------+--------+
| 1 | 2 | shared |
+----+---------------+--------+
1 row in set (0.00 sec)# plesk db "select * from dom_param where param='ip_addr_id' and val not in (select id from IP_Addresses);"
+--------+------------+------+
| dom_id | param | val |
+--------+------------+------+
| 6 | ip_addr_id | 2 |
+--------+------------+------+
1 row in set (0.00 sec)# plesk db "select * from IP_Addresses where id =2;"
Empty set (0.00 sec)# plesk db "select id, serviceNodeId, ip_address from IP_Addresses;"
+----+---------------+--------------+
| id | serviceNodeId | ip_address |
+----+---------------+--------------+
| 1 | 1 | x.x.x.x |
+----+---------------+--------------+
1 rows in set (0.00 sec)In this example, the
ip_pool
anddom_param
tables include an entry regarding a non-existent IP address (ip_address_id = 2
); -
Delete this record from the
ip_pool
table:# plesk db "delete from ip_pool where ip_address_id not in (select id from IP_Addresses);"
Query OK, 1 row affected (0.00 sec) -
If non-empty output was received during
dom_param
table check on the step 3, contact Plesk Technical support.
Comments
0 comments
Please sign in to leave a comment.