Table corrupted and data lost (second time in one

Table corrupted and data lost (second time in one

Post by Antti Lin » Thu, 26 Apr 2001 17:17:57



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


> 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 ;-(

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

 
 
 

1. Table corrupted and data lost (second time in one month!!)

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 da:
--------------
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

---------------------------(end of broadcast)---------------------------

2. Docking a control

3. Insert in 2 tables - Second insert fails then first, then second, then first...

4. Boot diskettes...

5. unable to insert data into two tables at same time

6. Sportster connecting to Couriers & Sportsters

7. Double Space file corrupt = data lost?

8. AmiPro Patch1.exe - ???

9. TWO Plug-ins at same time loading ERROR

10. Two SAS Openings/One Consulting One Full Time

11. Add-ins for pivot table data.....

12. Possible to extract zip data if table corrupt?

13. Sun servers routing table losing routes after running nestat -rn over a 20 second period