AbortTransaction and not in in-progress state

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: AbortTransaction and not in in-progress state
Date: 1998-09-12 19:23:28
Message-ID: Pine.GSO.3.96.SK.980912225950.1691A-100000@ra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I checked latest cvs and notice when I do 'vacuum analyze'
I got:

flats=> vacuum analyze;
NOTICE: AbortTransaction and not in in-progress state
NOTICE: AbortTransaction and not in in-progress state

23:09[om]:~/mian/flats/sql>psql flats
Connection to database 'flats' failed.
FATAL 1: Database 'flats' does not exist.
We know this because the directory '/usr/local/pgsql/data/base/flats' does not exist.
You can create a database with the SQL command CREATE DATABASE.
To see what databases exist, look at the subdirectories of '/usr/local/pgsql/data/base/'.

23:09[om]:~/mian/flats/sql>psql -l
NOTICE: AbortTransaction and not in in-progress state
NOTICE: AbortTransaction and not in in-progress state

23:10[om]:~/mian/flats/sql>psg post
431 p4 S 0:00 rlogin om -l postgres
6201 ? S 0:00 postmaster -i -B 1024 -S -D/usr/local/pgsql/data/ -o -Fe

Does this is a known problem ? I'm running linux 2.1.117, egcs 1.1.b,
pgsql was compiled with -O2 -mpentium options and --enable-locale.

After restoring database I tried again 'vacuum analyze' and it
produces the same result but I was able to do psql flats.
Nothing could do there though - on any commands I got
flats=> \dt
NOTICE: AbortTransaction and not in in-progress state
NOTICE: AbortTransaction and not in in-progress state
flats=> \q

Restarting postmaster helps a little bit, but after several operations
I got
flats=> \d work_flats
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or while processing the request.

Regards,

Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Keith Parks 1998-09-12 20:52:24 Re: [HACKERS] Exception in select IN with index
Previous Message Tom Ivar Helbekkmo 1998-09-12 16:38:39 Re: [HACKERS] Names that suddenly include an OID