Toby Murray writes:
> On Fri, Feb 1, 2013 at 3:58 PM, Tom Lane wrote:
>> It's conceivable that this was a software glitch not a hardware glitch,
>> ie Postgres forgetting the dirty-bits for a batch of pages, but we've
>> not seen any similar reports elsewhere. So I'm leaning to the hardware
>> e
On Fri, Feb 1, 2013 at 3:58 PM, Tom Lane wrote:
> Toby Murray writes:
>> On Thu, Jan 31, 2013 at 5:43 PM, Tom Lane wrote:
>>> Could we see the full results of heap_page_items(get_raw_page()) for
>>> each of the pages where any of these tuples live, viz
>
>> Seems awkward to put inline so I made
Toby Murray writes:
> On Thu, Jan 31, 2013 at 5:43 PM, Tom Lane wrote:
>> Could we see the full results of heap_page_items(get_raw_page()) for
>> each of the pages where any of these tuples live, viz
> Seems awkward to put inline so I made a text file with these results
> and am attaching it. Ho
On Thu, Jan 31, 2013 at 11:21 PM, Toby Murray wrote:
> Also, the node change happened on January 28th. To be precise, the
> timestamp of the node is 2013-01-28 02:38:29. So it is looking like
> something may have gone wrong, possibly in a single minutely update,
> on January 28th. I'll do a little
On Thu, Jan 31, 2013 at 10:57 PM, Toby Murray wrote:
> On Thu, Jan 31, 2013 at 5:43 PM, Tom Lane wrote:
>> Toby Murray writes:
>>> I just had some interaction with RhodiumToad on IRC about a duplicated
>>> primary key problem I ran into today. After some poking around he
>>> suggested that I sen
On Thu, Jan 31, 2013 at 5:43 PM, Tom Lane wrote:
> Toby Murray writes:
>> I just had some interaction with RhodiumToad on IRC about a duplicated
>> primary key problem I ran into today. After some poking around he
>> suggested that I send this to -bugs since it seems like an interesting
>> error.
Toby Murray writes:
> I just had some interaction with RhodiumToad on IRC about a duplicated
> primary key problem I ran into today. After some poking around he
> suggested that I send this to -bugs since it seems like an interesting
> error.
I poked around in the PK index file (thanks for sendin
I just had some interaction with RhodiumToad on IRC about a duplicated
primary key problem I ran into today. After some poking around he
suggested that I send this to -bugs since it seems like an interesting
error.
The short version is that I have a table ("ways") which has a primary
key ("id") th
