autovacuum: found orphan temp

From: "francescoboccacci(at)libero(dot)it" <francescoboccacci(at)libero(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: autovacuum: found orphan temp
Date: 2012-07-19 15:38:50
Message-ID: 25486882.2125931342712330597.JavaMail.defaultUser@defaultHost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,
in postgresql log file i found a lots of rows like:

autovacuum: found orphan temp table "pg_temp_32"."test11" in database "Test"

I tried to select this table:

select * from "pg_temp_32"."test11"

but i received the follow error:

ERROR: could not open file "base/16385/t32_13288115": No such file or
directory

How i can solve this problem?

Thanks

Francesco

Browse pgsql-admin by date

  From Date Subject
Next Message Sergey Konoplev 2012-07-19 15:52:10 Re: Measurin the lag between a master and a replica
Previous Message Ali Pouya 2012-07-19 15:17:42 Measurin the lag between a master and a replica