Re: Postgres server goes in recovery mode repeteadly

On Fri, Oct 02, 2009 at 10:41:07AM -0400, Alvaro Herrera wrote:
> daveg escribió:
>
> > I work with Kunal and have been looking into this. It appears to be the same
> > as the bug described in:
> >
> > http://archives.postgresql.org/pgsql-bugs/2009-09/msg00355.php
> >
> > as I have localized it to a NULL pointer deference in
> > RelationCacheInitializePhase2() as well. Tom speculates in:
> >
> > http://archives.postgresql.org/pgsql-bugs/2009-09/msg00372.php
> >
> > that large numbers of table drops might trigger this. The system in question
> > creates and drops temp tables at a high rate which tends to confirm this.
>
> Did you test the patch posted by Tom?

We are testing it since last night in our test environment. If it does not
break anything (unlikely) we will deploy it next week. However, since the
problem is only occasional, only happens every few days on one of 50+ hosts,
it will take some extended time without further segfaults to say anything
confident about the patches effectiveness.

-dg

--
David Gould daveg(at)sonic(dot)net 510 536 1443 510 282 0869
If simplicity worked, the world would be overrun with insects.