Troubleshooting
Problem
During the nzhostbackup the user receives a warning of a state change time out.
Cause
The nzhostbackup will try to pause the system, and as such, waits for any running SQL to finish before it pauses. If this does not happen within 60 seconds, it will fail.
Diagnosing The Problem
/nz/kit/log/postgres/pg.log file will issue the following error message:
2015-01-16 17:16:12.945384 MST Error: Host Backup failed.
2015-01-16 17:16:12.950729 MST Error: System could not be paused in given time.
2015-01-16 17:16:12.955868 MST Error: Resuming the system.
Resolving The Problem
This is expected from time to time if you have a longer running query. Your option is to increase the grace period that it will wait for running SQL to finish, using the -g option, and giving it a reasonable value, like 300 or 600 seconds:
-g GRACE_PERIOD time to wait (in seconds) for current work to finish [default: 60]
Eg.: To specify a timeout period of 5 minutes, rather than the default 60 seconds, enter:
nzhostbackup -g 300 /home/host/backup.tar.gz
Related Information
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21695174