Lists: | pgsql-sql |
---|
From: | Mark Kirkwood <markir(at)i4free(dot)co(dot)nz> |
---|---|
To: | "J(dot)Fernando Moyano" <txinete(at)wanadoo(dot)es> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | RE:Table corrupted and data lost (second time in one month!!) |
Date: | 2001-04-25 05:01:44 |
Message-ID: | 01042517014400.00613@spikey.slithery.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
Previously...
>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 ;-(
>
I have never used 7.0.2 for any length of time....but I would recommend
upgrading to 7.1 - many bugs have been fixed in this release - and hopefully
not too many more introduced :)
also adding more RAM would be a good idea, as 64Mb is not much these days ( I
use apache 1.3.19 + mod perl 1.25 and regularly see 150Mb RSS when I run gtop
)
This may be a Red Herring, but check to see you are not exhausing your swap
space, as all sorts of odd errors can be encouraged by this...
Cheers
Mark
From: | Antti Linno <alligator(at)all(dot)ee> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: RE:Table corrupted and data lost (second time in one month!!) |
Date: | 2001-04-25 07:05:24 |
Message-ID: | Pine.LNX.4.04.10104250856290.2341-100000@all.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
Hm, about memory exhausting I don't know, but the other day I tested the
limits of the text field in Postgres 6.5.(2 or 3). When ppl inserted text
in windows environment through html forms, then they got no more than
5000+a bit more symbols. Ok, I decided to test and inserted 8000+bit more
from linux and html form. What I got was corrupted table and no way to restore
data. And I am interested in parser or something too so I can see table
fields etc. to restore data if something so shitty happens. And yes I
didn't have backup, and yes it was important data :P Oh, about upgrading,
I don't maintain that machine, and half of its software should be upgraded
:P At least some little proggie to convert binary data to text would be of
some help in the future.
Just my idle thoughts though.
Greetings,
Antti
On Wed, 25 Apr 2001, Mark Kirkwood wrote:
>
> Previously...
> >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 ;-(
> >