From: | Michael Guerin <guerin(at)rentec(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:30:07 |
Message-ID: | 4418410F.9060807@rentec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-15 16:42:40 | Re: ESTERROR |
Previous Message | Michael Guerin | 2006-03-14 22:54:26 | Re: ESTERROR |