Hi all,
While performing some archive recovery tests I found the following
assertion failure once standby gets out of archive recovery (HEAD at
a5eb85e):
(lldb)
* thread #1: tid = 0x0000, 0x00007fff8faaf282
libsystem_kernel.dylib`__pthread_kill + 10, stop reason = signal
SIGSTOP * frame #0: 0x00007fff8faaf282 libsystem_kernel.dylib`__pthread_kill + 10 frame #1: 0x00007fff888774c3
libsystem_pthread.dylib`pthread_kill+ 90 frame #2: 0x00007fff898acb73 libsystem_c.dylib`abort + 129 frame #3:
0x0000000107106029
postgres`ExceptionalCondition(conditionName=0x000000010725770b,
errorType=0x0000000107219b83, fileName=0x00000001072c4c84,
lineNumber=555) + 137 at assert.c:54 frame #4: 0x0000000107140ec5
postgres`MemoryContextCreate(tag=T_AllocSetContext, size=192,
methods=0x00000001072fc7b0, parent=0x00007fca6a405710,
name=0x0000000107257e1b) + 117 at mcxt.c:555 frame #5: 0x000000010713e6c7
postgres`AllocSetContextCreate(parent=0x00007fca6a405710,
name=0x0000000107257e1b, minContextSize=0, initBlockSize=8192,
maxBlockSize=8388608) + 71 at aset.c:444 frame #6: 0x0000000106c51449 postgres`InitXLogInsert + 73 at
xloginsert.c:869 frame #7: 0x0000000106c450ee postgres`InitXLOGAccess + 190 at xlog.c:7281 frame #8:
0x0000000106c43e7cpostgres`LocalSetXLogInsertAllowed +
76 at xlog.c:7133 frame #9: 0x0000000106c445dd postgres`CreateCheckPoint(flags=38) +
1165 at xlog.c:7693 frame #10: 0x0000000106ebf935 postgres`CheckpointerMain + 1989 at
checkpointer.c:502 frame #11: 0x0000000106c5a0c3
postgres`AuxiliaryProcessMain(argc=2, argv=0x00007fff5909bb30) + 1907
at bootstrap.c:426 frame #12: 0x0000000106ecf696
postgres`StartChildProcess(type=CheckpointerProcess) + 358 at
postmaster.c:5109 frame #13: 0x0000000106ece229
postgres`sigusr1_handler(postgres_signal_arg=30) + 265 at
postmaster.c:4795 frame #14: 0x00007fff91468f1a libsystem_platform.dylib`_sigtramp + 26 frame #15:
0x00007fff8faaf3f7libsystem_kernel.dylib`__select + 11 frame #16: 0x0000000106ecd717 postgres`PostmasterMain(argc=3,
argv=0x00007fca6a4056a0) + 5479 at postmaster.c:1220 frame #17: 0x0000000106e11fc5 postgres`main(argc=3,
argv=0x00007fca6a4056a0) + 773 at main.c:220
Logs:
2014-11-28 15:28:20.733 JST: LOG: selected new timeline ID: 2
cp: /Users/ioltas/archive/5432/00000001.history: No such file or
directory
2014-11-28 15:28:20.776 JST: LOG: archive recovery complete
TRAP: FailedAssertion("!(CritSectionCount == 0)", File: "mcxt.c", Line: 555)
This area of the code has been changed recently by the WAL API patch.
Note that I haven't looked yet at implementing a fix.
Regards,
--
Michael
