Re: Vacuumdb message: AbortTransaction and not in-progress ... - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuumdb message: AbortTransaction and not in-progress ...
Date
Msg-id 14967.990634260@sss.pgh.pa.us
Whole thread Raw
In response to Vacuumdb message: AbortTransaction and not in-progress ...  (Gabriel Fernandez <gabi@unica.edu>)
List pgsql-general
Gabriel Fernandez <gabi@unica.edu> writes:
> We have some db's in our server. When executing a vacuumdb, ONLY FOR
> SOME of them, the following message is shown:

> AbortTransaction and not in in-progress state

What postgres version?

> After this, the vacuum process is aborted, so we cannot vacuum these
> 'problematic' db's.

The above notice is a consequence of a problem, not its cause.  What
other messages show up in the postmaster log?

            regards, tom lane

pgsql-general by date:

Previous
From: "Ian Harding"
Date:
Subject: Re: Incrementing a date type.
Next
From: Tom Lane
Date:
Subject: Re: Re: ZeroFill(.../pg_xlog/xlogtemp.20148) failed: No such file or directory