Re: [HACKERS] Aborted Transaction During Vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
Cc: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Aborted Transaction During Vacuum
Date: 1999-08-13 01:28:24
Message-ID: 27858.934507704@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"G. Anthony Reina" <reina(at)nsi(dot)edu> writes:
> I've been getting a strange error from the vacuum command. When I try
> 'vacuum verbose analyze' the vacuum goes through the tables fine until
> just after finishing one particular table. Then I get the error:

> NOTICE: AbortTransaction and not in in-progress state
> pqReadData() -- backend closed the channel unexpectedly.

Interesting. Is there any additional message appearing in the
postmaster log? Is a core file being generated? (look in the
data/base/ subdirectory for the database in question) If there
is a corefile, a debugger backtrace from it would be helpful.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Theo Kramer 1999-08-13 04:11:48 Single row fetch from backend
Previous Message Vadim Mikheev 1999-08-13 00:34:30 Re: [HACKERS] Re: We won!