Обсуждение: HELP!!!

Hi,

I am using a Live PostgreSQL database system for multiple web applications.
Everything was all working fine until completely at random the database
engine came up with a JDBC error:
"The backend has broken the connection. Possibly the action you have
attempted has caused it to close."

Now every time i attempt an UPDATE on the database it comes back with the
same error.
I can still do SELECT statements on the database with no problems.

The software i am using:
PostgreSQL 7.2.2
Java 1.4
Red Hat Linux 7.2

I have tried restarting the JVM
I have tried restarting PostgreSQL
I have tried rebooting the machine completely

The same error keeps occuring.

Please Help,

-- Brendon

Brendon,

> Now every time i attempt an UPDATE on the database it comes back with
> the
> same error.
> I can still do SELECT statements on the database with no problems.

Sounds to me like you're out of disk space on the partition which
contains the transaction logs, database, and/or the WAL files.

1) Check your available disk space on all partitions.
2) If you have disk space available, check your permissions; if someone
set the pgsql/data/logs/ directory to root-only, you're going to see
problems.
3) if that doesn't do it, watch the postgresql error log (you do have
one, yes?) carefully when the error happens.   It may give you more
data, especially if you raise the debug level and restart the database.

-Josh Berkus