Backup finishes with the warning: Database id is not found in data_bases

Symptoms

• A backup for a particular domain finishes with the following warning:

  Warning: Hosting "example.com"
  Broken referential integrity: Database id is not found in data_bases

• There is dbexample database for the subscription.
  The database presents in psa.data_bases :

  MYSQL_LIN: MariaDB [psa]> select * from data_bases where name="dbexample";
  +-----+---------------+-------+---------+---------------+------------------+--------------+
  | id | name | type | dom_id | db_server_id | default_user_id | external_id |
  +-----+---------------+-------+---------+---------------+------------------+--------------+
  | 5 | dbexample | mysql | 37 | 1 | 6 | NULL |
  +-----+---------------+-------+---------+---------------+------------------+--------------+

• In /var/log/plesk/PMM/backup-<date>/backup.log following records might be found:

  CONFIG_TEXT: TRACE SQL: SELECT name, type, external_id, host FROM data_bases AS d LEFT JOIN DatabaseCustomHosts AS h ON d.id=h.id WHERE d.id = ?: Params:
  WARN 78d4efc5-57f3-4370-89cd-4bf16e6e7d34 Broken referencial integrity: Database id is not found in data_bases

Cause

Database inconsistency.

Resolution

1. Connect to the server using SSH .

2. Run the command for the affected domain (in this case, dom_id=37):

   # /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/api-cli/aps.php --get-web-space-instances 37
   ..
   '_name' => 'database',
   '_attrs' => {
   'id' => '5',
   'aps-registry-id' => '380dc3b0-e358-4ecf-a069-bf60eabad408',
   'user' => 'dbuser',
   'prefix' => '',
   },
   ..

3. Back up and log in to psa database.

4. Make sure that the table below contains proper values:

   MYSQL_LIN: MariaDB [psa]> select * from apsResources where registryId='380dc3b0-e358-4ecf-a069-bf60eabad408';
   +----+--------------------------------------+-----------+---------+
   | id | registryId | pleskType | pleskId |
   +----+--------------------------------------+-----------+---------+
   | 8 | 380dc3b0-e358-4ecf-a069-bf60eabad408 | db-user | 7 |
   +----+--------------------------------------+-----------+---------+

   There should be two records for the database and the database user with equal registryId values.

5. Find the appropriate values:

   MYSQL_LIN: MariaDB [psa]> select id, default_user_id from data_bases where name="dbexample";
   +-----+
   | id |
   +-----+
   | 5 |
   +-----+
   1 row in set (0.00 sec)
   
   MariaDB [psa]> select id from db_users where db_id=5;
   +----+
   | id |
   +----+
   | 6 |
   +----+
   1 row in set (0.00 sec)

6. Update psa.apsResources table with correct values:

   MYSQL_LIN: MariaDB [psa]> update apsResources set pleskId = 6 where id = 8;
   MariaDB [psa]> insert into apsResources values (NULL, '380dc3b0-e358-4ecf-a069-bf60eabad408', 'db', 5);