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 #