Re: Hot Standby and prepared transactions - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Hot Standby and prepared transactions
Date
Msg-id 4B288802.5000804@enterprisedb.com
Whole thread Raw
In response to Re: Hot Standby and prepared transactions  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Hot Standby and prepared transactions
List pgsql-hackers
Simon Riggs wrote:
> Investigating how that could come about, it looks like there is some
> fairly strange stuff going on here. StandbyRecoverPreparedTransactions()
> is never called at all.

I told you so:
http://archives.postgresql.org/message-id/4B260B5E.3010401@enterprisedb.com

StandbyRecoverPreparedTransactions() is only needed to pick up the stateof prepared transactions when starting standby
froma shutdown
 
checkpoint. At online checkpoints. they are included in the
running-xacts record like all other transactions.

> * Skip assert when doing SubTransSetParent in
> RecoverPreparedTransactions() when in Hot Standby mode because some
> subxids will have been marked already

Seems reasonable. Let's still Assert that the parent is the same as last
time.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: KaiGai Kohei
Date:
Subject: [PATCH] Remove obscure permission checks in FindConversion()
Next
From: Kurt Harriman
Date:
Subject: Re: Patch: Remove gcc dependency in definition of inline functions