Re: 9.1.1 hot standby startup gets sigbus

On Wed, Nov 30, 2011 at 10:50 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Josh Kupershmidt <schmiddy(at)gmail(dot)com> writes:
>> On Wed, Nov 30, 2011 at 9:17 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> It might be worth recompiling at -O0, first to see if that changes the
> behavior and second to see if it changes the reported stack trace.

Here's a backtrace from 9.1 tip with CFLAGS="-O0", server logs are as before:

Program received signal SIGBUS, Bus error.
0x00c9716b in ?? () from /lib/i386-linux-gnu/libc.so.6
(gdb) bt
#0 0x00c9716b in ?? () from /lib/i386-linux-gnu/libc.so.6
#1 0x082b3b2f in ReadBuffer_common (smgr=0x9ef68d0, relpersistence=112 'p',
forkNum=MAIN_FORKNUM, blockNum=86781, mode=RBM_ZERO, strategy=0x0,
hit=0xbfc5eeff "") at bufmgr.c:435
#2 0x082b3722 in ReadBufferWithoutRelcache (rnode=..., forkNum=MAIN_FORKNUM,
blockNum=86781, mode=RBM_ZERO, strategy=0x0) at bufmgr.c:272
#3 0x080df3a0 in XLogReadBufferExtended (rnode=..., forknum=MAIN_FORKNUM,
blkno=86781, mode=RBM_ZERO) at xlogutils.c:296
#4 0x080d0bab in RestoreBkpBlocks (lsn=..., record=0x9eed480,
cleanup=0 '\000') at xlog.c:3589
#5 0x080eb1b8 in gin_redo (lsn=..., record=0x9eed480) at ginxlog.c:678
#6 0x080d7d91 in StartupXLOG () at xlog.c:6601
#7 0x080de215 in StartupProcessMain () at xlog.c:10043
#8 0x080fa737 in AuxiliaryProcessMain (argc=2, argv=0xbfc5f188)
at bootstrap.c:417
#9 0x082941a2 in StartChildProcess (type=StartupProcess) at postmaster.c:4499
#10 0x0828fcf5 in PostmasterMain (argc=3, argv=0x9ebb8e0) at postmaster.c:1112
#11 0x08218b64 in main (argc=3, argv=0x9ebb8e0) at main.c:199

Josh