Re: Error creating gin index on jsonb columns

From: Glenn Zhu <gzhu(at)medallia(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Error creating gin index on jsonb columns
Date: 2015-10-16 14:20:24
Message-ID: CAG3jo=gMV57G58hrsiZdYfLNzfUxf2L_Dnrq2xe8EyqBGhfwBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Glenn Zhu <gzhu(at)medallia(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-10-16 14:29:48 Re: [RFC] overflow checks optimized away
Previous Message Tom Lane 2015-10-16 14:16:39 Re: Error creating gin index on jsonb columns