Database Servers page redirects to Plesk main page: Dependent row(s) isn’t found

Symptoms

• Unable to list database servers at Tools & Settings > Database servers page and instead it redirects to the main Plesk page.

• Error below can be found in /var/log/plesk/panel.log:

  ERR [panel] Dependent row(s) 'Domains.id = 1029' isn't found for 'data_bases.dom_id = 1029'.

Cause

Database inconsistency. ID from the error is missing from psa.domains table:

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

Resolution

Warning: Make sure the databases are not required in future and domain is removed on purpose.

1. Connect to the server via SSH.

2. Create Plesk database dump:

   # plesk db dump psa > psa`date +%F-%s`.sql

3. Obtain database names for the missing domain:

   # plesk db -Ne "select name from data_bases where dom_id=1029"
   example_db
   example_db2

4. Drop the databases:

   # plesk db "drop database example_db"

   # plesk db "drop database example_db2"

5. Cleanup the referencing entries:

   # plesk db "delete from data_bases where dom_id=1029"