Re: Please help with this error message

From: "Chris Smith" <cdsmith(at)twu(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Please help with this error message
Date: 2003-03-26 21:20:46
Message-ID: 033801c2f3dd$91dac1f0$6700000a@KYA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Okay,

After the suggestion of possible hardware problems, we've decided to move
the database to yet another server in the hopes that this will cause the
problem to go away. Trouble is, we've still a corrupted record. I
successfully deleted one of the corrupted records; the other, when I attempt
to delete it, responds with:

PANIC: open of /data/dac/pg_clog/09C5 failed: No such file or directory
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

I then get a psql prompt of "!>", and am no longer connected to the
database. Any suggestions on how to delete this record? Does this mean
that the data is corrupted more than I think?

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-03-26 22:04:50 Re: Please help with this error message
Previous Message Dennis Gearon 2003-03-26 19:50:46 Re: transaction blocking inserts in postgresql 7.3