Re: Snapshot too old logging - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Snapshot too old logging
Date
Msg-id CA+Tgmob=mL2aHgYpBWJtOi_jLyXdLt8PQrhb1Mm_L7rOTvu3Kg@mail.gmail.com
Whole thread Raw
In response to Re: Snapshot too old logging  (Brad DeJong <Brad.Dejong@infor.com>)
List pgsql-hackers
On Fri, Nov 18, 2016 at 11:49 AM, Brad DeJong <Brad.Dejong@infor.com> wrote:
> On Wed, Nov 16, 2016 at 6:43 AM, Robert Haas wrote:
>> I think I was suggesting: One or more rows required by this query may
>> already have been removed from "%s".
>
> I keep reading that as "you have data corruption because something removed rows that your query needs" rather than
"thisquery took too long to complete but may succeed if you resubmit it".
 

I see your point, but remember that this would only the detail line.
The error would still be "snapshot too old".

ERROR:  snapshot too old
DETAIL: One or more rows required by this query may already have been
removed from "%s".

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Declarative partitioning - another take
Next
From: Robert Haas
Date:
Subject: Re: Patch: Implement failover on libpq connect level.