From: Albert REINER <areiner@tph.tuwien.ac.at>
To: PostgreSQL-SQL <pgsql-sql@postgreSQL.org>
Subject: Can VACUUM, but cannot do VACUUM ANALYZE
Date: Sat, 23 Oct 1999 09:18:19 +0200
Message-ID: <19991023091819.C833@frithjof> (raw)
Hi!
Every couple of days I run "vacuum analyze" on every db on my system
(from a shell script). Now there is one small database (two tables,
one SQL-function) where I get the following (in psql):
> albert@frithjof:/home/albert > psql
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> [PostgreSQL 6.5.1 on i586-pc-linux-gnulibc1, compiled by gcc 2.7.2.1]
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: albert
>
> albert=> vacuum;
> VACUUM
> albert=> vacuum analyze;
> NOTICE: AbortTransaction and not in in-progress state
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> We have lost the connection to the backend, so further processing is impossible. Terminating.
>
I.e., I can VACUUM, but I cannot do VACUUM ANALYZE. Why should analyze
do an ABORT? By the way, I do not notice any strange behavior with
this database, and pg_dump works fine on it.
Any ideas what might be at fault and how to fix this?
Thanks in advance,
Albert.
--
--------------------------------------------------------------------------
Albert Reiner <areiner@tph.tuwien.ac.at>
Deutsch * English * Esperanto * Latine
--------------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: areiner@tph.tuwien.ac.at
Subject: Re: Can VACUUM, but cannot do VACUUM ANALYZE
In-Reply-To: <19991023091819.C833@frithjof>
References: <19991023091819.C833@frithjof>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox