Re: could not open relation - why?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: could not open relation - why?
Date: 2006-08-07 12:46:09
Message-ID: 19590.1154954769@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> writes:
> within my log there is the following snippet:

> 2006-08-07 13:20:27 LOG: autovacuum: processing database "template1"
> 2006-08-07 13:20:47 ERROR: could not open relation with OID 311438
> 2006-08-07 13:21:52 LOG: autovacuum: processing database "postgres"

The easiest explanation is that someone dropped a table just as
autovacuum was trying to open it. The above trace suggests that
you're actively changing template1, which is probably not good
practice ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thor Tall 2006-08-07 12:56:25 psql internal variables
Previous Message Harald Armin Massa 2006-08-07 11:38:51 could not open relation - why?