• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

[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