Skip site navigation (1) Skip section navigation (2)

Re: ESTERROR

From: "Guido Barosio" <gbarosio(at)gmail(dot)com>
To: "Michael Guerin" <guerin(at)rentec(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ESTERROR
Date: 2006-03-15 16:43:39
Message-ID: f7f6b4c70603150843i61e0828awdcc564b8dbe3722e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Is the autovacuum running?
Prolly related tho.

g.-

On 3/15/06, Michael Guerin <guerin(at)rentec(dot)com> wrote:
> Looks like my problem is back again today:
>
> ERROR:  relation with OID 76511 does not exist
>
> What's the best way to track down this issue? Also, when I see these
> errors there's usually no active query, maybe stat's collector or some
> other internal process is looking for a table that doesn't exist anymore?
>
> -Mike
>
>
>
> Michael Guerin wrote:
> >
> >> "EST" looks suspiciously like "Eastern Standard Time," considering
> >> that the timezone in your email is -0500.  Does a timestamp immediately
> >> precede the above string?  Have you set log_line_prefix without a
> >> trailing space?
> >>
> >
> > Yep, its East Std. Time.. I've already awarded myself the DA award for
> > today... :(
> >
> >> As for "relation with OID X does not exist," see if the FAQ's
> >> explanation fits your situation:
> >>
> >> http://www.postgresql.org/docs/faqs.FAQ.html#item4.19
> >>
> > No, no temp tables are used in any of our functions.  It seems to have
> > gone away after I stopped and restarted the database.
> > Here's a little background on the db that was having this problem.
> > The database is not typical, its created using files and tables are
> > basically dropped and recreated every time one of the source files
> > change.  Temp tables are created and populated then within a
> > transaction the live table is dropped and the tmp table is renamed to
> > be the live table.
> > thanks
> > -mike
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


--
Guido Barosio
-----------------------

In response to

Responses

pgsql-novice by date

Next:From: Michael GuerinDate: 2006-03-15 17:57:25
Subject: Re: ESTERROR
Previous:From: Tom LaneDate: 2006-03-15 16:42:40
Subject: Re: ESTERROR

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group