Re: database vacuum from cron hanging

Kevin Grittner wrote:

> I'm not sure what you mean regarding pg_config -- could you clarify?

The output of pg_config --configure

> Your email came through as I was trying to figure out where to find
> the core dump.  We restarted the server with cassert, and I find this
> in the log prior to my attempt to vacuum:

It should be in $PGDATA/core (maybe with some other name depending on
settings)

> TRAP: FailedAssertion("!(buf->refcount > 0)", File: "bufmgr.c", Line: 812)
> [2005-10-12 09:10:05.695 CDT] 16602 LOG:  server process (PID 16619) was terminated by signal 6
> [2005-10-12 09:10:05.695 CDT] 16602 LOG:  terminating any other active server processes

Here is the culprit.

-- 
Alvaro Herrera                                http://www.PlanetPostgreSQL.org
"Always assume the user will do much worse than the stupidest thing
you can imagine."                                (Julien PUYDT)