Question Error after Backup - Broken referencial integrity

[Dirk]

Details zur Backup-Aufgabe 17. Mai 2018 04:42:07
Warning: hosting "liesenfeld.de"
Broken referencial integrity: Database id is not found in data_bases

Hmmm - what should I check next? plesk repair doesn't find any mistakes and the backup.log doesn't give any more information...

 

[IgorG]

Please check this KB article Backup finishes with the warning: Database id is not found in data_bases
I hope it will help.

 

[Dirk]

Thank you Igor for your help.
But I already tried this, and it didn't work, because, there ist no information in the error message about which database is in question.

Warning: hosting "liesenfeld.de"

Liesenfeld.de is the domain on which the database is hosted

Database id is not found in data_bases

No id-number either.
In the article you mentioned, one needs to find the id as a starting point. Since I don't have it, I find no point to start.

I also checked the backup.log and there aren't any error messages.

So, what could I do next do resolve the issue?

 

[Dirk]

This is the content of my "data_bases"

(1, 'bi_xxx', 'mysql', 2, 1, NULL, NULL),
(2, 'AL-xxx', 'mysql', 4, 1, NULL, NULL),
(5, 'li_xxx', 'mysql', 5, 1, NULL, NULL),
(6, 'li_xxx', 'mysql', 5, 1, NULL, NULL),
(7, 'li_xxx', 'mysql', 5, 1, NULL, NULL),
(8, 'li_xxx', 'mysql', 5, 1, NULL, NULL),
(9, 'tm_xxx', 'mysql', 5, 1, NULL, NULL),
(10, 'spixxx', 'mysql', 5, 1, NULL, NULL),
(11, 'tm_xxx', 'mysql', 5, 1, 14, NULL),
(13, 'WP-xxx', 'mysql', 12, 1, NULL, NULL),
(14, 'WP-xxx', 'mysql', 11, 1, NULL, NULL),
(16, 'WP-xxx', 'mysql', 13, 1, NULL, NULL),
(17, 'noaxxx', 'mysql', 17, 1, NULL, NULL);

And this is the content of my apsResources

(1, 'd1f953e2-82d6-442a-xxx-f38022efcaff', 'hosting', 4),
(2, 'd1f953e2-82d6-442a-xxx-f38022efcaff', 'urlMapping', 4),
(3, 'ca08a101-a524-45b4-xxx-5b4cdd29be3f', 'db', 2),
(4, 'ca08a101-a524-45b4-xxx-5b4cdd29be3f', 'db-user', 2),
(9, '35e4a547-c629-4efe-xxx-b75703ded8a8', 'hosting', 5),
(10, '35e4a547-c629-4efe-xxx-b75703ded8a8', 'urlMapping', 5),
(12, 'd78a1b59-4225-4038-xxx-e6e1f97482cf', 'db-user', 6),
(17, '3b0596e4-7234-43b4-xxx-97033773fe46', 'hosting', 12),
(18, '3b0596e4-7234-43b4-xxx-97033773fe46', 'urlMapping', 12),
(19, '99304dd3-ea27-48c0-xxx-a0861b29309b', 'db', 13),
(20, '99304dd3-ea27-48c0-xxx-a0861b29309b', 'db-user', 16);

(changed it a bit with xxx to protect my data)

 

[Dirk]

Anyone an idea?

 

[IgorG]

I think it would be better to ask Plesk Support Team assistance.