From: Simon Riggs on

I get this when testing prepared transactions, which looks like it is
unrelated to Hot Standby.

2009-12-15 17:28:08 GMT[10385]LOG: archive recovery complete
2009-12-15 17:28:08 GMT[10428]LOG: checkpoint starting: end-of-recovery
immediate wait
2009-12-15 17:28:08 GMT[10428]DEBUG: creating and filling new WAL file
2009-12-15 17:28:08 GMT[10428]DEBUG: done creating and filling new WAL
file
2009-12-15 17:28:08 GMT[10428]LOG: checkpoint complete: wrote 0 buffers
(0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=0.000 s, sync=0.000 s, total=0.790 s
2009-12-15 17:28:08 GMT[10385]LOG: recovering prepared transaction
122944
TRAP: FailedAssertion("!(*ptr == ((TransactionId) 0))", File:
"subtrans.c", Line: 87)
2009-12-15 17:28:09 GMT[10380]LOG: startup process (PID 10385) was
terminated by signal 6: Aborted

This looks like the code is setting the parent to be zero. That
assertion wasn't added by the patch.

2-phase state file attached, zipped. I think we need some tools to
inspect state files.

Can you look at this please?

--
Simon Riggs www.2ndQuadrant.com