search

chef / chef_backup

A library to backup an Chef server
Other
7 stars 15 forks source link

Timeout on pg_dumpall #19

Open coderanger opened 8 years ago

coderanger commented 8 years ago

The tar strategy uses the default 10 minute timeout for pg_dumpall. With lots of reporting data it is easy to blow past this. Should either be set higher or made overridable.

ryancragun commented 8 years ago

This should be resolved by https://github.com/chef/chef_backup/commit/bd29c56a0adb93c1443201088024b09f42b508a2.

Postgresql DB operations are now run with a default timeout of 60 minutes. If you wish to change it (or any other PG option) you can use the pg_options switch, eg:

chef-server-ctl restore my_backup.tgz --pg-options '-c statement_timeout=66666666666666'

You can track the upstream PR that bundles this fix in the Chef Server here https://github.com/chef/chef-server/pull/770

coderanger commented 8 years ago

@ryancragun I don't think that is correct. You set a postgres-level timeout, but the root problem was the shellout timeout.

coderanger commented 8 years ago

Also the default value of statement_timeout is 0 meaning it is disabled so actually you just made things worse.

coderanger commented 8 years ago

Pinging again to re-open this as it was not fixed.

pburkholder commented 8 years ago

@coderanger Reopening....