Plesk provides error on opening database list in Tools & Settings > Database servers: Dependent row(s) ‘Domains.id = 783’ isn’t found for ‘data_bases.dom_id = 783’. – Plesk

Symptoms

• The database list cannot be opened in Tools & Settings > Database servers. Plesk provides error like below:

  Type GraphQL Error
  Message Dependent row(s) 'Domains.id = 783' isn't found for 'data_bases.dom_id = 783'.

• Plesk psa database contains the rows about the databases that are related to the domain with id from the error message:

  MariaDB [psa]> select * from data_bases where dom_id = 783 ;
  +-----+----------+-------+--------+--------------+-----------------+-------------+
  | id | name | type | dom_id | db_server_id | default_user_id | external_id |
  +-----+----------+-------+--------+--------------+-----------------+-------------+
  | 337 | example1 | mysql | 783 | 1 | NULL | NULL |
  | 338 | example2 | mysql | 783 | 1 | NULL | NULL |
  +-----+----------+-------+--------+--------------+-----------------+-------------+
  2 rows in set (0.001 sec)

• But the "domains" table does not contain the record with this ID:

  MariaDB [psa]> select name from domains where id = 783;
  Empty set (0.000 sec)

Cause

Inconsistency in the Plesk database.

Resolution

1. Connect to the server via SSH.

2. Connect to the Plesk psa database:

   # plesk db

3. Remove the records from the data_bases table (using the dom_id from the error):

   delete from data_bases where dom_id = 783;