On 10/30/2017 10:56 AM, Peter Geoghegan wrote:
On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent wrote:
Peter, you beat me to the punch. I was just about to say "Having read the
referenced message I thought I would add that we never delete from this
table." In this particular case it was written
On 10/30/2017 10:56 AM, Peter Geoghegan wrote:
On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent wrote:
Peter, you beat me to the punch. I was just about to say "Having read the
referenced message I thought I would add that we never delete from this
table." In this particular case it was written
On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent wrote:
> Peter, you beat me to the punch. I was just about to say "Having read the
> referenced message I thought I would add that we never delete from this
> table." In this particular case it was written to record by record, in a
> previous executio
On 10/30/2017 10:32 AM, Peter Geoghegan wrote:
On Fri, Oct 27, 2017 at 3:15 PM, Rob Sargent wrote:
I’ve hit this same message
Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN
page is of different type
in a couple of contexts and I’m starting to get worried.
I’ve re
On Fri, Oct 27, 2017 at 3:15 PM, Rob Sargent wrote:
> I’ve hit this same message
>
> Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN
> page is of different type
>
> in a couple of contexts and I’m starting to get worried.
>
> I’ve rebuilt the index, but will that help?
>
Rob Sargent writes:
>> If you can make a test case that (eventually) hits that, we'd be
>> interested to see it ...
> Any hint(s) on what might trigger this sort of thing? I could duplicate
> the upload, but I doubt you want the 800K records, 200M input file even
> if it did regenerate the pro
On Mon, Oct 30, 2017 at 7:35 AM, Tom Lane wrote:
> Rob Sargent writes:
>> I’ve hit this same message
>> Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN
>> page is of different type
>> in a couple of contexts and I’m starting to get worried.
>
> If you can make a test ca
If you can make a test case that (eventually) hits that, we'd be
interested to see it ...
Any hint(s) on what might trigger this sort of thing? I could duplicate
the upload, but I doubt you want the 800K records, 200M input file even
if it did regenerate the problem.
Would select * from
Rob Sargent writes:
> I’ve hit this same message
> Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN
> page is of different type
> in a couple of contexts and I’m starting to get worried.
If you can make a test case that (eventually) hits that, we'd be
interested to see
