Re: Error creating gin index on jsonb columns - Mailing list pgsql-hackers

From Glenn Zhu
Subject Re: Error creating gin index on jsonb columns
Date
Msg-id CAG3jo=gMV57G58hrsiZdYfLNzfUxf2L_Dnrq2xe8EyqBGhfwBQ@mail.gmail.com
Whole thread Raw
In response to Re: Error creating gin index on jsonb columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
We will follow your instructions and get back to you.

Thank you Tom.  Much appreciated!
-glenn

On Fri, Oct 16, 2015 at 7:16 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Glenn Zhu <gzhu@medallia.com> writes:
> Is this categorized as a bug specific to GIN indexes or a PostgreSQL bug in
> general?

My gut says it's GIN-specific, but that's really only an educated guess;
we have too little info.

What I would recommend is that you get the data onto a non-production
machine where you can play around a bit more.  One thing you could do
then is run a build with debug symbols, attach to the backend process
with gdb, and set a breakpoint at "errfinish".  Then provoke the error,
and capture a backtrace from the call to errfinish.  That would greatly
narrow things down, though it might not be enough to isolate the bug
immediately.  (If I had a test case in hand, that's exactly the first
step I would take with it, but maybe you can do it for me.)

                        regards, tom lane



--
Glenn Zhu
SaaS Operations | ❖ Medallia, Inc.
  

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error creating gin index on jsonb columns
Next
From: Michael Paquier
Date:
Subject: Re: [RFC] overflow checks optimized away