BUG #1745: Unable to delete data from the database

From: "K(dot)G(dot)Sivaraman" <ksivaram(at)ssd(dot)usa(dot)alcatel(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1745: Unable to delete data from the database
Date: 2005-07-01 14:30:02
Message-ID: 20050701143002.4B8CEF0B09@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


The following bug has been logged online:

Bug reference: 1745
Logged by: K.G.Sivaraman
Email address: ksivaram(at)ssd(dot)usa(dot)alcatel(dot)com
PostgreSQL version: 8.0
Operating system: Solaris
Description: Unable to delete data from the database
Details:

When try to delete the existing name in the database (having ID and Name as
the table parameters and both are indexed), it returns success.
But when queried again, then the deleted name appeared.
When we analysed the problem, the basic delete
command itself not working.
Normally DELETE command will return the number of records deleted (ex)
DELETE 1 for 1 record.
But now, it returns DELETE 0, even though the
record is there and it is not got deleted.

The error in the log file is as follows :

ERROR : xlog flush request 0/D17B00 is not satisfied --- flushed only to
0/C31ED0
CONTEXT : writing block 0 of relation 17231/17232/17249
WARNING : could not write block 0 of 17231/17232/17249
DETAIL : Multiple failures --- write error may be
permanent.

But when I add a new record, it is getting added and
I am able to delete the newly added record.

Why this error coming ?. Can some one can help ?.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2005-07-01 14:34:15 Re: BUG #1741: %i missing in snprintf implementation
Previous Message K.G.Sivaraman 2005-07-01 14:18:48 BUG #1744: Directory Missing

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-07-01 14:51:56 Re: TODO item done
Previous Message Andreas Pflug 2005-07-01 14:22:10 Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)