Hot Standby and prepared transactions - Mailing list pgsql-hackers

From Simon Riggs
Subject Hot Standby and prepared transactions
Date
Msg-id 1260902950.1955.5332.camel@ebony
Whole thread Raw
Responses Re: Hot Standby and prepared transactions
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Closing out CommitFest 2009-11
Next
From: "Kevin Grittner"
Date:
Subject: Update on true serializable techniques in MVCC