Skip site navigation (1) Skip section navigation (2)

Re: Error: No one parent tuple was found

From: Sergio Pili <sergio(dot)pili(at)spm(dot)com(dot)ar>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error: No one parent tuple was found
Date: 2003-04-29 13:45:19
Message-ID: 069B887B914BD51180420004AC33E2E80A47842C@MAILSVR_A (view raw or flat)
Thread:
Lists: pgsql-general
Please, somebody can help me?

Regards,
Sergio

> -----Mensaje original-----
> De:	Sergio Pili [SMTP:sergio(dot)pili(at)spm(dot)com(dot)ar]
> Enviado el:	Lunes 28 de Abril de 2003 16:08
> Para:	'pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly


Responses

pgsql-general by date

Next:From: Oliver ElphickDate: 2003-04-29 13:46:29
Subject: Re: Importing from Access 2000?
Previous:From: Jose Manuel SanchezDate: 2003-04-29 13:44:16
Subject: create gist index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group