Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Valentine Gogichashvili <valgog(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids
Date: 2012-06-08 10:42:00
Message-ID: 201206081242.00890.andres@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Valentine,

On Friday, June 08, 2012 12:25:25 PM Valentine Gogichashvili wrote:
> unfortunately I did not manage to keep the snapshot of the database, that
> had this issue.
Too bad. Let me try if I can reproduce it manually.

> Can that be, that this issue only happens when the recovering from the WAL
> files and not over the steaming replication?
> On other standbys, having no WAL delay, we did not see this problem yet.
No, the delivery method is not relevant. The relevant part is when the standby
was started. A bit tricky to hit the right spot ;)

> Would it be possible to somehow generate a workload, that would lead to
> this a problem?
I think I can do that. Let me play for a bit.

Andres

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message mitzanu 2012-06-08 10:55:50 BUG #6679: Can't connect via JDBC Driver
Previous Message Valentine Gogichashvili 2012-06-08 10:25:25 Re: BUG #6661: out-of-order XID insertion in KnownAssignedXids