Re: tracking commit timestamps

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Petr Jelinek <petr(at)2ndquadrant(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Steve Singer <steve(at)ssinger(dot)info>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Anssi Kääriäinen <anssi(dot)kaariainen(at)thl(dot)fi>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Subject: Re: tracking commit timestamps
Date: 2015-03-09 20:46:28
Message-ID: 20150309204628.GS3291@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

Petr Jelinek wrote:

> >>On Thu, Dec 4, 2014 at 12:08 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
> >>wrote:

> >>>I got the following assertion failure when I executed
> >>>pg_xact_commit_timestamp()
> >>>in the standby server.
> >>>
> >>>=# select pg_xact_commit_timestamp('1000'::xid);
> >>>TRAP: FailedAssertion("!(((oldestCommitTs) != ((TransactionId) 0)) ==
> >>>((newestCommitTs) != ((TransactionId) 0)))", File: "commit_ts.c",
> >>>Line: 315)

> >Attached patch fixes it, I am not sure how happy I am with the way I did
> >it though.

Pushed, thanks.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2015-03-09 22:12:22 Re: Question about lazy_space_alloc() / linux over-commit
Previous Message Andrew Gierth 2015-03-09 20:26:54 Re: Calling for a replacement committer for GROUPING SETS

Browse pgsql-www by date

  From Date Subject
Next Message Gilberto Castillo 2015-03-11 15:46:28 Re: New Book PGPLSQL(In Spanish)
Previous Message Magnus Hagander 2015-03-08 15:32:22 Re: git.postgresql.org commit hooks?