Backup error

[IgorG]

Broken referencial integrity: DNS zone id 108 is not found in dns_zone<

Did you check and fix it in database?

 

[DirkPoper]

Yes - I checked the table "dns_zone" - there is an entry for ID 108 ( I guess in that table the coulum ID means the Zone_id)

SELECT * FROM `dns_zone` where id = 108

-> one row returned

id name displayName status email type ttl ttl_unit refresh refresh_unit retry retry_unit expire expire_unit minimum minimum_unit serial_format serial syncSoa syncRecords
Bearbeiten Direkt bearbeiten Kopieren Löschen 108 presseberatung.de presseberatung.de 1 [email protected] master 86400 86400 10800 3600 3600 3600 604800 86400 10800 3600 UNIXTIMESTAMP 1334179436 true true

I checked the table "domains" too. There I can find for "dns_zone_id" 108 the domain "presseberatung.de" - so that looks for me to be corrected.
Isn't it?

In addtion may be usefull in the future: Is there a way to fix it using one of the Plesk tools?

 

[DirkPoper]

Today the error changed:

<description>Broken referencial integrity: DNS zone id 89 is not found in dns_zone</description>

Is there any way to rebuild the database integrity?

May be a hint:

I fI use the Control Panel to create an ondemand backup - it will end with success. The only difference: No blocking of the domains during backup.
The automatic backup has set this option to yes.

 

[DirkPoper]

New results

I changed the settings of the automatic backup to not block the domains during backup.

After this, the autmatic backup works for few days.

- But how to fix the DNS Integratiy?

The new error is now: ( The solution discriped here in the forum didn't solve my issue)

<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2012-04-16-230605.361/migration.result">
<message id="eb51a555-82e7-4366-8b2b-5c6bb76840f4" severity="error" code="fatal">
<description>Runtime error</description>
</message>
<message id="56990dfb-91eb-413e-8532-8da92144682b" severity="error" code="CheckDump">
<description>The dump have been invalidated by check-dump operation</description>
</message>
<object name="DiPopDefWeb" type="client">
<object name="i-webtec.de" type="domain">
<object name="i-webtec.de" type="hosting">
<object name="geitznase.de" type="domain">
<message id="238f3cb0-296b-4939-80e8-e670b9e70604" severity="error" code="UtilityError">
<description>Unable to get APS instances on webspace id 21 (ErrorCode: 1, STDOUT.</description>
</message>
</object>
</object>
</object>
</object>
</execution-result>

 

[KristianW]

Similar issue with CentOS

My log file is attached, any ideas for fixes?

 

[IgorG]

My log file is attached, any ideas for fixes?

<message id="f49878a1-381c-4c59-8b01-463317125830" severity="warning" code="msgtext">
<description>Timeout occured during mysql query. Reconnecting.</description>
</message>
<message id="2bf22015-e173-4765-8f59-f9d7911704bf" severity="error" code="msgtext">
<description>Unable to execute SQL: Lost connection to MySQL server during query</description>

Try to increase wait_timeout value in /etc/my.cnf and restart MySQL.

 

[nutmix]

I get the same error: backup notification email says "Task status is: error", and it only saves about 300MB of a 3.9GB backup. The server has a virus, but I cant re-image as I cant backup. Any ideas?

plesk 9.5.4, centos 5.?

Which XML file are people pasting in here?

I found some files in /usr/local/psa/PMM/sessions/2012... but the files in there have no errors.

However the many files in /var/lib/psa/dumps only contain a fraction of the data. Previous dumps were all 3.9GB. in the plesk control panel, it says the backup size is 3.9GB, but there are only about 300MB of files with the corresponding prefix.

 

[xeomueller]

Plesk 11.0.9 Backup Error

I have the same error on plesk 11:

<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2012-07-12-091836.135/migration.result">
<object name="4gamer.org" type="domain">
<message id="4a14f0c4-9e39-4b7a-847f-8250dc285e2e" severity="error" code="CheckDump">
<description>Unable to check dump: Could not check dump. Invalid xml response:
at /usr/local/psa/PMM/agents/PleskX/PmmCli.pm line 177
PmmCli:arseCheckDumpResult('Error: adjacent parameter is empty in \'dump-file-specificati...') called at /usr/local/psa/admin/bin/plesk_agent_manager line 1205
main::checkDump('/var/lib/psa/dumps', '', '/usr/local/psa/PMM/sessions/2012-07-12-091836.135') called at /usr/local/psa/admin/bin/plesk_agent_manager line 672
main::__ANON__() called at /usr/local/psa/PMM/agents/shared/Error.pm line 405
eval {...} called at /usr/local/psa/PMM/agents/shared/Error.pm line 397
Error::subs::try('CODE(0x31aa778)', 'HASH(0x31a9f68)') called at /usr/local/psa/admin/bin/plesk_agent_manager line 681
main:erform('verbose', 4, 'owner-type', 'server', 'split-size', undef, 'session-path', '/usr/local/psa/PMM/sessions/2012-07-12-091836.135', 'description', ...) called at /usr/local/psa/admin/bin/plesk_agent_manager line 1279
main::__ANON__() called at /usr/local/psa/PMM/agents/shared/Error.pm line 398
eval {...} called at /usr/local/psa/PMM/agents/shared/Error.pm line 397
Error::subs::try('CODE(0x1eef8e0)', 'HASH(0x1eef9b8)') called at /usr/local/psa/admin/bin/plesk_agent_manager line 1288
main::main() called at /usr/local/psa/admin/bin/plesk_agent_manager line 1290.
</description>
</message>
<message id="3d8720a9-2c5d-4f17-8df7-3e6c55d70e03" severity="error" code="fatal">
<description>Unable to create dump</description>
</message>
</object>
</execution-result>

I use cloudlinux 6.3. Any Idea?

 

[IgorG]

http://kb.parallels.com/en/113474

 

[xeomueller]

I already tried this.

but in my conf file is this:

# Backups directory
DUMP_D /var/lib/psa/dumps
DUMP_TMP_D /tmp

there are no "". So i guess everything is right. The /tmp folder exists.

 

[IgorG]

Are you sure that free space of /tmp is enough?

 

[xeomueller]

I guess yes. its a new system:


filesystem Size Used Avail Use% mount
/dev/md0 915G 4,6G 864G 1% /
tmpfs 7,8G 0 7,8G 0% /dev/shm

 

[xeomueller]

Some information:

I tried backup just email configuration + emails = works

I migrated the domains from plesk 9. I also disabled the ssl legacy mode in plesk 11...

Ok, I also get the error, when i backup just the domain configuration!

I started a new thread, course its a plesk 11 problem: http://forum.parallels.com/showthread.php?p=631126

 

[xeomueller]

The backup works since the Parallels Plesk Panel 11.0.9 Update #6

 

[EmilioO]

Same problem resolved

Unable to get Global settings for APS Applications (ErrorCode: 3, STDOUT.

Resolved by going: Tools > Application Vault > Clear Cache