Re: 8.5alpha3 hot standby crash report (DatabasePath related?)

On Jan 7, 2010, at 4:15 PM, Simon Riggs wrote:

> On Thu, 2010-01-07 at 14:41 -0500, Robert Treat wrote:
>
>> Doing some testing with 8.5alpha3, my standby crashed this morning  
>> whilst
>> doing some testing. Seems I have a core file, so thought I would  
>> send a report.
>>
>> Version: PostgreSQL 8.5alpha3 on i386-pc-solaris2.10, compiled by  
>> GCC gcc
>> (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath), 32-bit
>>
>> Error in the log was simply this:
>> LOG:  restored log file "000000010000000300000032" from archive
>> LOG:  startup process (PID 385) was terminated by signal 11
>> LOG:  terminating any other active server processes
>
> Please send some more of the prior log, so we can tell the
> initialization state at that point.
>

Not much more to send really. It's just "restored log file" lines  
going back to the startup (as expected)

> If you can reproduce it, that would help also. Thanks.
>

Not sure about reproducing, but if I restart the database, it crashes  
again during log replay (stack trace info looks the same).

LOG:  database system was interrupted while in recovery at log time  
2010-01-07 12:01:57 EST
HINT:  If this has occurred more than once some data might be  
corrupted and you might need to choose an earlier recovery target.
LOG:  starting archive recovery
LOG:  restore_command = '/export/home/postgres/pgwork/inst/slave/bin/ 
pg_standby /export/home/postgres/pgwork/data/.hot_standby %f %p %r'
cp: cannot access /export/home/postgres/pgwork/data/.hot_standby/ 
00000001.history
cp: cannot access /export/home/postgres/pgwork/data/.hot_standby/ 
00000001.history
cp: cannot access /export/home/postgres/pgwork/data/.hot_standby/ 
00000001.history
cp: cannot access /export/home/postgres/pgwork/data/.hot_standby/ 
00000001.history
LOG:  restored log file "00000001000000030000002A" from archive
LOG:  automatic recovery in progress
LOG:  initializing recovery connections
LOG:  redo starts at 3/2A000020, consistency will be reached at  
3/2D000120
LOG:  restored log file "00000001000000030000002B" from archive
LOG:  restored log file "00000001000000030000002C" from archive
LOG:  restored log file "00000001000000030000002D" from archive
LOG:  consistent recovery state reached at 3/2D000120
LOG:  database system is ready to accept read only connections
LOG:  restored log file "00000001000000030000002E" from archive
LOG:  restored log file "00000001000000030000002F" from archive
LOG:  restored log file "000000010000000300000030" from archive
LOG:  restored log file "000000010000000300000031" from archive
LOG:  restored log file "000000010000000300000032" from archive
LOG:  startup process (PID 4397) was terminated by signal 11
LOG:  terminating any other active server processes

--
Robert Treat
http://www.omniti.com/