Re: Error creating gin index on jsonb columns

Поиск
Список
Период
Сортировка
От Glenn Zhu
Тема Re: Error creating gin index on jsonb columns
Дата
Msg-id CAG3jo=gMV57G58hrsiZdYfLNzfUxf2L_Dnrq2xe8EyqBGhfwBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Error creating gin index on jsonb columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error creating gin index on jsonb columns
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [RFC] overflow checks optimized away