• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

[SOLVED] Backup task notification - Broken referencial integrity: Database id

xxx

Basic Pleskian
Hello guys.

I need your help and hope you have an idea to solve the following issue:
I'm running Plesk 12.5 Update 10 on a Ubuntu Server since some weeks. I updated this server before from Plesk 12. Everything seems to run well - until three days ago.
Since then I get a "Backup task notification" from the system for each backup process I set up in the past.

Each notification tells me "Broken referencial integrity: Database id x is not found in data_bases". Where x is a different database id. An example of an entire XML document is:

Code:
<execution-result status="warnings" log-location="/opt/psa/PMM/sessions/2016-02-16-043102.230/migration.result">
<object name="server" type="server">
<object type="domain" name="calamillorhotels.com" uuid="domain#domain.tld">
<message code="BrokenDbIntegrity" id="4a54b801-7613-4fe9-8e24-98f50541e2d0" severity="warning">
<description>
Broken referencial integrity: Database id 11 is not found in data_bases
</description>
</message>
<message severity="warning" code="msgtext" id="3ff8c881-9a73-46e0-8c42-12bf4ef21d01">
<description>
Unable to execute SQL: Table 'psa.DatabaseCustomHosts' doesn't exist. SQL query: SELECT name, type, external_id, host FROM data_bases AS d LEFT JOIN DatabaseCustomHosts AS h ON d.id=h.id WHERE d.id = ?
</description>
</message>
<message severity="warning" id="21968e9b-1640-4c03-81cb-9a0022afdaeb" code="msgtext">
<description>
Unable to execute SQL: Table 'psa.DatabaseCustomHosts' doesn't exist. SQL query: SELECT name, type, external_id, host FROM data_bases AS d LEFT JOIN DatabaseCustomHosts AS h ON d.id=h.id WHERE d.id = ?
</description>
</message>
</object>
</object>
</execution-result>
Is there somebody who has an idea what could be the reason for this message and who can point me to the right direction to solve it?
Much appreciated to get your help!
Thanks in advance!
 
Thank you Igor, for your comment. Unfortunately I did a wrong search but happy to get your link.
I run the repair command and got the message "The table DatabaseCustomHosts is absent". It was recreated and I hope my next backup tonight will run without errors.
But allow me one more question about this: Why do I need this table? Can it be I lost some important information?
 
Why do I need this table? Can it be I lost some important information?
As I wrote in the mentioned thread this table is used in case additional custom database servers. There is no any "important information" if you haven't additional custom database servers.
 
Back
Top