Skip site navigation (1) Skip section navigation (2)

HELP

From: "Brendon Matthews" <brendonm(at)bbtechltd(dot)com>
To: "PostgreSQL Bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: HELP
Date: 2002-09-12 05:13:48
Message-ID: ENELLKLMINPNBFCCIFMDCEFECBAA.brendonm@bbtechltd.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

I have been using PostgreSQL 7.2.2 for a while now on one of our live
machines, however all of a sudden with no warning, we are no longer able to
run any UPDATE statements on one of our databases. SELECT and INSERT
statements have no issues.

The error we are getting is:
"The backend has broken the connection. Possibly the action you have
attempted has caused it to close."
Immediately after this call the database system restarts itself.

We are using:
Red Hat Linux
Apache 1.3.26
PostgreSQL 7.2.2
Java 1.4 + the latest PostgreSQL jdbc driver from jdbc.postgresql.org

Configuration:
We are running postmaster -i listening on localhost only.

We have 3 PostgreSQL databases on the same machine, and the other two have
no problems at all (yet). They are all using the same software mentioned
above.

Things i have tried:
Restarting JVM and Apache (problem still occurs)
Restarting postmaster -i (problem still occurs)
Vaccuming all databases (problem still occurs)
Rebooting entire machine (problem still occurs)
Dropping the database and creating another (worked for a while, but after
processing SQL calls for about a day and a half the problem started up
again)

Is there anything i can do to fix this? Has anyone else seen this before?
We need our database system back up and running ASAP.

Regards,

Brendon Matthews
Analyst Programmer
BBTech Ltd
Ph: (03) 381 1127
Fax: (03) 381 1185


Responses

  • Re: HELP at 2002-09-12 12:12:05 from Rod Taylor
  • Re: HELP at 2002-09-12 12:19:36 from Rod Taylor
  • Re: HELP at 2002-09-12 13:13:24 from Tom Lane
  • Re: HELP at 2002-09-12 17:06:17 from junk

pgsql-bugs by date

Next:From: Mats LofkvistDate: 2002-09-12 08:40:25
Subject: Re: _bt_check_unique checks every row in table when doing update??
Previous:From: Bruce MomjianDate: 2002-09-12 00:24:05
Subject: Re: Schemas not available for pl/pgsql %TYPE....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group