Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group