Re: psql: FATAL: the database system is in recovery mode - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: psql: FATAL: the database system is in recovery mode
Date
Msg-id 4A41C452.9090501@enterprisedb.com
Whole thread Raw
In response to psql: FATAL: the database system is in recovery mode  (Bhushan Verma <verma.bhushan@gmail.com>)
Responses Re: psql: FATAL: the database system is in recovery mode
List pgsql-bugs
Bhushan Verma wrote:
> I am doing some database related queries and this is working fine at fedora
> core 4.
> But the same database queries giving the FATAL error on fedora 9.
>
> If I restarts the database on fedora core 9 then this is perfectlry working
> without giving any error.
>
> My postgres version is
> On Fedora core-9[FC9] Machine:
> $ rpm -qa|grep postgres
> postgresql-server-8.3.1-1.fc9.i386
> postgresql-devel-8.3.1-1.fc9.i386
> postgresql-python-8.3.1-1.fc9.i386
> postgresql-8.3.1-1.fc9.i386
> postgresql-libs-8.3.1-1.fc9.i386

It probably won't solve this problem, but you need to upgrade. The
latest 8.3 release is 8.3.7. See
http://www.postgresql.org/support/versioning

> On Fedora core-4[FC49] Machine:
> $ rpm -qa|grep postgres
> postgresql-server-8.0.3-1
> ...

Same here. Latest 8.0 minor release is 8.0.21

> Problem is:
> ----------------
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> connection to server was lost
>
> psql: FATAL:  the database system is in recovery mode
> ...
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> connection to server was lost
> psql: FATAL:  the database system is in recovery mode
>
> --------------
>
> Is this database bug or there is any versioning incopatability.

You'll have to give more details or no-one will be able to help you.
Please share the query that caused the crash, and CREATE statements of
all the tables involved in the query. Is there any triggers or anything
else involved?

Can you get a core dump and post stack trace from it? Something along
the lines of:
1. ulimit -c unlimited
2. pg_ctl start
3. <induce crash>
4. gdb /usr/bin/postgres <datadir>/core
5. bt

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: Bhushan Verma
Date:
Subject: psql: FATAL: the database system is in recovery mode
Next
From: Craig Ringer
Date:
Subject: Re: psql: FATAL: the database system is in recovery mode