Re: database vacuum from cron hanging

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: database vacuum from cron hanging
Date: 2005-10-12 15:02:41
Message-ID: 20051012150241.GA2467@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-10-12 15:10:01 Re: database vacuum from cron hanging
Previous Message Kevin Grittner 2005-10-12 14:57:39 Re: database vacuum from cron hanging