staging restore fail - slonik

[Steve McInerney]

The most recent staging restore failed at this point:

        make build LPCONFIG=staging
        make -C database/replication stagingsetup STAGING_DUMP=${DUMPFILE} PGUSER=postgres

Error:
.....
COMMENT ON COLUMN FlatPackagesetInclusion.child IS 'The package set that is being included as a subset.';]
DDL Statement 557: (65519,65522) [

]
Complete DDL Event...
DDL submission to initial node - PGRES_TUPLES_OK
2009-08-19 09:38:06 INFO New stuff needs replicating: public.bugnotificationarchive, public.bugnotificationrecipientarchive
/tmp/slonikNzGRvC.sk:32: Adding public.bugnotificationrecipientarchive to holding set for lpmain merge.
/tmp/slonikNzGRvC.sk:39: Adding public.bugnotificationarchive to holding set for lpmain merge.
/tmp/slonikNzGRvC.sk:51: Subscribing holding set to @node2_node.
/tmp/slonikNzGRvC.sk:55: Waiting for sync
/tmp/slonikNzGRvC.sk:57: timeout exceeded while waiting for event confirmation
2009-08-19 09:48:09 ERROR slonik script failed
make[1]: *** [_replicate] Error 1
make[1]: Leaving directory `/srv/staging.launchpad.net/staging/launchpad/database/replication'
make: *** [stagingsetup] Error 2
make: Leaving directory `/srv/staging.launchpad.net/staging/launchpad/database/replication'
Wed Aug 19 10:48:09 BST 2009 There was a problem running the stagingsetup target

[Stuart Bishop (stub)]

The default timeout of 10 minutes waiting for subscription to complete was not enough. I've turned off the timeout, and fixed the slow db patch too to avoid unnecessary downtime during rollout.