Re: Error: No one parent tuple was found - Mailing list pgsql-general

From Sergio Pili
Subject Re: Error: No one parent tuple was found
Date
Msg-id 069B887B914BD51180420004AC33E2E80A47842C@MAILSVR_A
Whole thread Raw
In response to Error: No one parent tuple was found  (Sergio Pili <sergio.pili@spm.com.ar>)
Responses Re: Error: No one parent tuple was found  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: Error: No one parent tuple was found  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Please, somebody can help me?

Regards,
Sergio

> -----Mensaje original-----
> De:    Sergio Pili [SMTP:sergio.pili@spm.com.ar]
> Enviado el:    Lunes 28 de Abril de 2003 16:08
> Para:    'pgsql-general@postgresql.org'
> CC:    'Marcos Suarez'
> Asunto:    [GENERAL] Error: No one parent tuple was found
>
> Hi!
>
> This is my problem:
>
>  uname -a
> Linux mail 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i686 unknown
>
> xxx=# select version();
>                            version
> -------------------------------------------------------------
>  PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
> (1 row)
>
>
>
> psql -d colabo -c "vacuum full verbose analyze"
>
> NOTICE:  --Relation pg_largeobject--
> NOTICE:  Pages 84730: Changed 68898, reaped 83003, Empty 0, New 0; Tup
> 948705: Vac 46341, Keep/VTL 0/0, UnUsed 533451, MinLen 44, MaxLen 2092;
> Re-using: Free/Avail. Space 52105268/52023388; EndEmpty/Avail. Pages
> 0/78465.
>         CPU 3.56s/1.98u sec elapsed 60.15 sec.
> NOTICE:  Index pg_largeobject_loid_pn_index: Pages 5947; Tuples 948705:
> Deleted 3.
>         CPU 0.17s/0.79u sec elapsed 9.57 sec.
> ERROR:  No one parent tuple was found
>
> In a mail of the 12 of August Tom Lane say that this problem is solved in
> version 7.3 but so far I cannot make the update.
> In that same mail, Tom proposes to do
>
> psql -d colabo -c "select * from pg_largeobject for update;"
>
> But...
>
> "Apr 28 11:16:45 mail kernel: Out of Memory: Killed process 12168 (psql)."
>
>
> So wath can i do?
>
>
> Thanks!!!
>
> Sergio
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Importing from Access 2000?
Next
From: Tom Lane
Date:
Subject: Re: timestamps and dates