Plesk repair db shows an error: There is no IP pool with ID 0

Daniel Yordanov

Updated February 05, 2024 11:57

Plesk for Windows Plesk for Linux kb: technical

Applicable to:

Running the repair database diagnostic command below leads to errors that are similar to the following:

# plesk repair db -n
Checking the consistency of the Plesk database
Inconsistency in the table 'clients' for the column pool_id: There
is no IP pool with ID 0 ........................................... [ERROR]
The following command shows the affected domains for which pool_id is 0 are without an assigned hosting type:

# plesk db "SELECT name,htype,cl_id FROM domains WHERE cl_id IN (SELECT id FROM clients WHERE pool_id = 0)"
+-------------------+-------+-------+
| name | htype | cl_id |
+-------------------+-------+-------+
| example.com | none | 118 |
+-------------------+-------+-------+
The following command shows that the affected domain is not associated with any IP address of the ones assigned to your Plesk server:
# plesk db "select distinct ip.id, ip.ip_address from domains d, clients c, dom_param dp, IP_Addresses ip where ip.id = dp.val and dp.param = 'ip_addr_id' and dp.dom_id = d.id and d.cl_id = c.id and c.id = 118"
(Empty Output)

Database inconsistency caused by invalid pool_id records in the clients table of the Plesk (psa) database.

Click on a section to expand

Via Plesk GUI

Log into Plesk
Go to Domains > example.com > Hosting Settings > Hosting Type > [Change] > Click OK to re-apply the settings

Via SSH

Connect to the server via SSH
Check that the affected domain doesn't have the web hosting enabled:

# plesk bin site -i example.com | grep "Hosting type"
Hosting type: none
If the previous command shows none, disable again the Hosting for the affected domain:

# plesk bin site -u example.com -hosting false