Andres Freund wrote: > On 2014-02-26 18:18:05 -0300, Alvaro Herrera wrote: > > Andres Freund wrote: > > > > > static void > > > heap_xlog_lock(XLogRecPtr lsn, XLogRecord *record) > > > { > > > ... > > > HeapTupleHeaderClearHotUpdated(htup); > > > HeapTupleHeaderSetXmax(htup, xlrec->locking_xid); > > > HeapTupleHeaderSetCmax(htup, FirstCommandId, false); > > > /* Make sure there is no forward chain link in t_ctid */ > > > htup->t_ctid = xlrec->target.tid; > > > ... > > > } > > > > I think the fix is to reset HOT_UPDATED and t_ctid only if the infomask > > says the tuple is LOCKED_ONLY, per the attached patch. > > Looks good to me.
Thanks, pushed. Greg, Peter, if you could update your standbys to the current HEAD of REL9_3_STABLE for the affected apps and verify the problem no longer shows up in a reasonable timeframe, it would be great. (I'm assuming you saw this happen repeatedly.) -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers