Issue still exists after adding patch.
SET statement_timeout = 0; should execute first before pg_start_backup(); I
guess as of now it is executed after pg_stop_backup();
Here i have copied logs of wal-e as well postgresql logs.
WAL-E logs:
INFO MSG: starting WAL-E
DETAIL: The subcommand is "backup-push".
STRUCTURED: time=2016-02-25T12:01:51.117770-00 pid=25625
*ERROR: canceling statement due to statement timeout*wal_e.operator.backup
WARNING MSG: blocking on sending WAL segments
DETAIL: The backup was not completed successfully, but we have to
wait anyway. See README: TODO about pg_cancel_backup
STRUCTURED: time=2016-02-25T12:06:51.149955-00 pid=25625
*ERROR: a backup is not in progresswal_e.main ERROR MSG: Could not
stop hot backup* STRUCTURED: time=2016-02-25T12:06:51.155812-00
pid=25625
===============
PostgreSQL logs:
*postgres ERROR: canceling statement due to statement timeout* postgres
STATEMENT: SET statement_timeout = 0; COPY (SELECT file_name,
lpad(file_offset::text, 8, '0') AS file_offset FROM
pg_xlogfile_name_offset(
pg_start_backup('freeze_start_2016-02-25T12:01:51.145672+00:00'))) TO
STDOUT WITH CSV HEADER
postgres ERROR: a backup is not in progress
*postgres STATEMENT: SET statement_timeout = 0; COPY (SELECT file_name,
lpad(file_offset::text, 8, '0') AS file_offset FROM
pg_xlogfile_name_offset( pg_stop_backup())) TO STDOUT WITH CSV HEADER*
On Thu, Feb 25, 2016 at 1:54 AM, Daniel Farina <[email protected]> wrote:
> On Tue, Feb 23, 2016 at 11:27 PM DHAVAL JAISWAL <[email protected]>
> wrote:
>
>> Backup canceled due to following error.
>>
>> We have set the statement_timeout to 2 minutes.
>>
>> However, while taking dump in pg_dump we can define explicitly to
>> statement_timeout=0;
>>
>> How to achieve the same while running backup-push
>>
>
> A patch was submitted to fix this, but I hadn't backported it to v0.8.
>
> I went ahead and did this, but before I merge it officially, can you give
> this branch a try and let me know if it solves your problem?
>
> https://github.com/wal-e/wal-e/tree/for-DHAVAL-JAISWAL
>
>
--
Thanks & Regards
Dhaval Jaiswal
--
You received this message because you are subscribed to the Google Groups
"wal-e" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
