| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Warm standby stall -- what debug info would help? |
| Date: | 2007-07-09 16:36:56 |
| Message-ID: | 23173.1183999016@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2007-07-09 16:37:11 | Re: Warm standby stall -- what debug info would help? |
| Previous Message | Jim C. Nasby | 2007-07-09 16:28:16 | Re: Idea: Comments on system catalogs? |