Re: [GENERAL] cache lookup of relation 165058647 failed

Sean Chittenden wrote:
>> I'v find out that this error occurs in:
>>  dependency.c file
>>
>> 2004-04-26 11:09:34 ERROR:  dependency.c 1621: cache lookup of relation
>> 149064743 failed
>> 2004-04-26 11:09:34 ERROR:  Relation "tmp_table1" does not exist
>> 2004-04-26 11:09:34 ERROR:  Relation "tmp_table1" does not exist
>>
>> in getRelationDescription(StringInfo buffer, Oid relid) function.
>>
>> Any ideas what can cause this errors.
>
> <aol>Me too.</aol>
>
> But, I am suspecting that it's a race condition with the new background
> writer code.  I've started testing a new database design and was able
> to reproduce this on my laptop nearly 90% of the time, but could only
> reproduce it about 10% of the time on my production databases until I
> figured out what the difference was, fsync.

temp tables don't use the shared buffer cache, how can this be related
to the BG writer?


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #