Postgres Pro
Downloads
Home   >   mailing lists

Table corrupted and data lost (second time in one month!!) - Mailing list pgsql-sql

From J.Fernando Moyano
Subject Table corrupted and data lost (second time in one month!!)
Date
Msg-id 01042418180605.01609@txino.mikasa.eh
Whole thread Raw
Responses Re: Table corrupted and data lost (second time in one month!!)  ("Josh Berkus" <josh@agliodbs.com>)
Re: Table corrupted and data lost (second time in one month!!)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
This is the second time in this month !!!!

FATAL 1: Memory exhausted in AllocSetAlloc()
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.


A table has been corrupted and i don't know why...
It's really hard to recover the table, and last time i lost some data ;-(

Someone can help me to solve this problem ??? I don't want this table 
corrupted anymore ....

The postgres version is 7.0.2 ...
The aplication is CGI-Perl based, using DBI.
The system is Mandrake 7.0, and the hardware a  K6-2, 64Mb, 10Gb, etc...
It runs without X.

Thanks !!

-- 
Fernando Moyano

Frase del día:
--------------
Este tagline es shareware. Envia 1000 pts para registrarlo.

(*) SymeX ==> http://symex.lantik.com
(*) WDBIL ==> http://wdbil.sourceforge.net
(*) Informate sobre LINUX en http://www.linux.org

pgsql-sql by date:

Previous
From: "Francis Solomon"
Date:
Subject: RE: Timezone conversion
Next
From: "Josh Berkus"
Date:
Subject: Re: Table corrupted and data lost (second time in one month!!)