Re[2]: [GENERAL] DELETE statement KILL backend <AGAIN>

Hello David,

Thanks to reply to my answer.

DBY> I've had this problem a number of times. Before I tell you what I did to
DBY> solve this problem, let me warn you that I am a novice at DBs (PostgreSQL is
DBY> my first database).

DBY> In my experience, the problem seems to be caused by a lot of data being put
DBY> into the database.
Unfortunately this isn't my case.
DBY> We are using the database to ingest real-time data 24
DBY> hours a day/7 days a week. The data comes in about every three minutes.
DBY> While I was not able to identify what the exact cause has been, I have
DBY> noticed that before the problem becomes critical (before the backend
DBY> terminates abnormally), the (number of) indexes do not correspond to the
DBY> actual table. That leads me to believe that the indexes do not get created
DBY> on all occasions. After some time, the table's internal indexes may be come
DBY> corrupted, and vacuuming does no good.
I have this problem on every table, those with index and those
without.

Right now, if I create a table without indexes and then I "DELETE FROM
table" the backend dies immediately.

DBY> When trying to fix this, I first delete the index, then recreate it., then
DBY> vacuum. If that doesn't work, then I drop the table, create the index,
DBY> reload the data, and then vacuum the table.

DBY> I would be curious to see if anyone else has had this type of problem and
DBY> what their solutions were.
Me too.

DBY> I can provide the scripts to check the database to the newsgroup or to you
DBY> directly, if desired.
I'm not sure if this can solve my problem, anyway send me it.
Thanks for all,
Jose'

DBY> -----Original Message-----
DBY> From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
DBY> To: pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)org>
DBY> Date: Friday, August 21, 1998 10:57 AM
DBY> Subject: [GENERAL] DELETE statement KILL backend <AGAIN>

>>
>> Hello all,
>>
>> I have a strange problem that I can't understand.
>> I have been my PostgreSQL-6.3.2 on Linux-ELF-2.0.34 working without any
DBY> problem for many
>> months. This morning I can't DELETE anymore.
>> If I try to delete a row from any table I have this message:
>>
>> PGexec() -- Request has sent to backend, but backend closed the
>> channel before responding.
>> This probably means the backend terminated abnormally before or while
>> processing the request.
>>
>> and then the backend dies.
>>
>> I tried every statement as:
>> INSERT
>> UPDATE
>> SELECT
>> DROP TABLE
>> and all of them works but DELETE,
>>
>> I tried also VACUUM without success.
>>
>> PLEASE help me !!
>>
>> Best regards,
>> Jose' mailto:sferac(at)bo(dot)nettuno(dot)it
>>
>>
>>

Best regards,
Sferacarta mailto:sferac(at)bo(dot)nettuno(dot)it