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

Symptoms

• 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)

Cause

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

Resolution

Click on a section to expand

Additional information

How to access the Plesk psa database in MySQL/MariaDB

Diagnose & Repair tool detected issues with the database: Checking the Plesk database using the native database server tools

Plesk Repair Utility | Plesk Obsidian documentation