Re: postgresql9.1.6 core dump

Adrian Klaver escribió:
> On 10/11/2013 03:51 AM, hiroyuki shiga wrote:
> >Thank you for reply.
> >
> >but .... I can't provide a self-contained test case.
> >
>
> So what are you doing when you get the core dump?

The query is in the backtrace:

SELECT PATH, COUNT(SITE_ID)
FROM ACCESS_LOG_05
WHERE SITE_ID = $1
GROUP BY PATH
ORDER BY PATH

And it also suggests that the crash is happening during cache lookup of
the "count" function.

Since this seems to work for pretty much everybody, I would wonder about
corrupt catalogs and/or corrupt cache; if neither, perhaps some race
condition on cache invalidation/reload. Speculating much without any
further evidence or test case appears pointless.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services