Re: BUG #11032: Prepared transactions do not update pg_last_xact_replay_timestamp() anymore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: s(dot)zuban(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #11032: Prepared transactions do not update pg_last_xact_replay_timestamp() anymore
Date: 2014-07-24 21:46:13
Message-ID: 20429.1406238373@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

s(dot)zuban(at)gmail(dot)com writes:
> After upgrade from 9.3.4 to 9.3.5 pg_last_xact_replay_timestamp() returns
> outdated timestamp.

> It stopped working properly after commit
> d19bd29f07aef9e508ff047d128a4046cc8bc1e2

Really?

It looks to me like this never worked: the code around recoveryStopsHere
has never paid any attention to COMMIT_PREPARED (or ABORT_PREPARED).
Certainly that patch had zip to do with the replay-timestamp behavior.

If you think it worked before, I'd like to see what your test case was.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2014-07-24 21:57:43 Re: BUG #11032: Prepared transactions do not update pg_last_xact_replay_timestamp() anymore
Previous Message David Leverton 2014-07-24 19:42:55 Re: BUG #10533: 9.4 beta1 assertion failure in autovacuum process