• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    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. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

[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