Articles in this section

See more

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

Avatar
Alexander Davydov
Updated
Follow
Plesk for Linux kb: technical

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:

    CONFIG_TEXT: 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:

MYSQL_LIN: 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"

Comments

1 comment

Sort by Date Votes
  • Avatar
    METANET Support

    If several databases on the server are affected, the following query shows an overview:

    SELECT id,name,dom_id FROM data_bases where dom_id NOT IN (select id from domains);

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles