[pgpool-general: 1781] Re: [PGPOOL] online recovery fails due to "WAL ends before end of online backup"
Tatsuo Ishii
ishii at postgresql.org
Tue May 28 08:21:41 JST 2013
Does the problem happen even if you disable watchdog?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> Dear pgpool developers,
>
> I encounter an issue while doing online recovery. I try to solve the problem but still have no idea about it. Recovery usually fails in the step: remote restart database server. It displays “FATAL: WAL ends before end of online backup. HINT: Online backup started with pg_start_backup() must be ended with pg_stop_backup(), and all WAL up to that point must be available at recovery.”
>
> Software:
> OS: Ubuntu 12.04.2 LTS/Server/precise
> pgpool version: pgpool-II-3.2.3
> postgresql version: postgresql_9.2.2
>
> Environment:
> 2 pgpools: PG0 and PG1 (with watchdog on)
> 2 databases: DB0 and DB1
>
> Reproduce steps:
>
> 1. Update data via VIP. (23.7kB size JPEG pictures were kept being updated to the database via VIP. And there are 10 requests in one second.)
>
> 2. Stop DB1 service.
>
> 3. Use pcp_recovery_node to do recovery on PG1.
>
> 4. Recovery done.
>
> Note that recovery usually fails at remote restart. It is interesting that the success rate of online recovery is higher when updating DB with only text than with pictures.
>
> Regards,
> Tina
More information about the pgpool-general
mailing list