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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
-----------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Guerin | 2006-03-15 17:57:25 | Re: ESTERROR |
Previous Message | Tom Lane | 2006-03-15 16:42:40 | Re: ESTERROR |