[pgpool-general: 1781] Re: [PGPOOL] online recovery fails due to "WAL ends before end of online backup"
ishii at postgresql.org
Tue May 28 08:21:41 JST 2013
Does the problem happen even if you disable watchdog?
SRA OSS, Inc. Japan
> 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.”
> OS: Ubuntu 12.04.2 LTS/Server/precise
> pgpool version: pgpool-II-3.2.3
> postgresql version: postgresql_9.2.2
> 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.
More information about the pgpool-general