pg_autovacuum bug with temp tables?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_autovacuum bug with temp tables?
Date: 2004-02-17 15:26:20
Message-ID: 4032329C.5010703@nexcerpt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Recently I installed and started pg_autovacuum against my new Pg 7.4.1
installation. We use a fairly large number of temporary tables within an
application (that is, several copies of this application may be running,
and each creates and drops several temp tables as they cycle through
their workload). Here's what I think happened, based on the log
(pg_autovacuum's and the postmaster's):

pg_autovacuum.log:
[2004-02-15 08:10:01 AM] Performing: ANALYZE "pg_temp_13"."tmp_targs"
[2004-02-15 08:10:01 AM] Can not refresh statistics information from the
database nexcerpt.
[2004-02-15 08:10:01 AM] The error is [ERROR: relation
"pg_temp_13.tmp_targs" does not exist

postmaster.log:
2004-02-15 08:10:01 [31563] ERROR: relation "pg_temp_13.tmp_targs" does
not exist
2004-02-15 08:10:01 [31563] LOG: unexpected EOF on client connection

It appears that pg_autovacuum collected the name of a temp table, and
later tried to analyze it. The table was gone by then, and this caused
the daemon to exit. As this happened on a Sunday morning, my weekend
experiment to see how pg_autovacuum would maintain our test database was
rather spoiled ... 8-(

--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Adler 2004-02-17 15:31:01 how to recover corrupt data
Previous Message Bruce Momjian 2004-02-17 15:21:46 Re: SSH connection timing out

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-02-17 15:37:46 Re: Renaming tables to other schemas
Previous Message Tom Lane 2004-02-17 14:40:52 Re: DROP TABLE and concurrent modifications