Re: [BUGS] BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker
Дата
Msg-id 29113.1488910563@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker  (stepya@ukr.net)
Ответы Re: [BUGS] BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker
Список pgsql-bugs
Stepan Yankevych <Stepan_Yankevych@epam.com> writes:
> It quite difficult to reproduce.
> The only observation. Usually it crashes with parallelism only on quite big tables  with inheritance .

If you can't extract a test case, one thing that would be quite helpful is
to get a stack trace from the point of the error.  There are only four
occurrences of

        elog(ERROR, "invalid cache ID: %d", cacheId);

and they're all in src/backend/utils/cache/syscache.c.  If you could
change those to elog(PANIC, ...) in a debug-enabled build, run till
you get the failure, and then use gdb to get a backtrace from the
ensuing core dump, that might be enough info to fix it.

            regards, tom lane


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Stepan Yankevych
Дата:
Сообщение: Re: [BUGS] BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker
Следующее
От: mdudley@gryphonsensors.com
Дата:
Сообщение: [BUGS] BUG #14582: ecpg crashes on SQL input