Re: Warm standby stall -- what debug info would help? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Warm standby stall -- what debug info would help?
Date
Msg-id 23173.1183999016@sss.pgh.pa.us
Whole thread Raw
In response to Warm standby stall -- what debug info would help?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Warm standby stall -- what debug info would help?  ("Simon Riggs" <simon@2ndquadrant.com>)
Re: Warm standby stall -- what debug info would help?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> [2007-07-07 18:24:27.692 CDT] 5962 LOG:  restored log file "000000010000000=
> C000000DA" from archive
> [2007-07-07 18:24:28.051 CDT] 5962 LOG:  restored log file "000000010000000=
> C000000DB" from archive
> [2007-07-09 08:21:50.200 CDT] 5904 LOG:  received fast shutdown request
> [2007-07-09 08:21:50.201 CDT] 5962 FATAL:  could not restore file "00000001=
> 0000000C000000DC" from archive: return code 15

Evidently it was waiting for the restore_command script to give it back
a file.  So the problem is within your restore script.  Eyeing the
script, the only obvious thing that could block it is existence of
/var/pgsql/data/county/$countyName/wal-files/rsync-in-progress 
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Idea: Comments on system catalogs?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Warm standby stall -- what debug info would help?