Re: BUG #8436: Heisenbug: random: relation "XXX" does not exist on 3 tables/views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: qwerty(at)hi(dot)is
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8436: Heisenbug: random: relation "XXX" does not exist on 3 tables/views
Date: 2013-09-04 20:45:23
Message-ID: 12291.1378327523@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

qwerty(at)hi(dot)is writes:
> Just a few days ago we started randomly getting:
> relation "th_thjoderni" does not exist

You haven't really provided any information about what changed around the
time this started happening. What I'd wonder about is concurrent DDL on
these tables --- perhaps you added some kind of background maintenance
task that wasn't there before?

You might try enabling query logging (log_statement = all) to see exactly
what's happening at the time you get one of these errors.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2013-09-04 21:04:40 Re: BUG #7754: Contrib start scipt comment refers to dead URL
Previous Message Bruce Momjian 2013-09-04 19:01:50 Re: BUG #7730: intarray representation of empty arrays