Re: Error: No one parent tuple was found

Try

select loid, pageno from pg_largeobject for update

or even

select loid, pageno, substr(data from 1 for 1)

I don't see why the second version would do anything different to the first but
it might be worth a try.


--
Nigel J. Andrews


On Tue, 29 Apr 2003, Sergio Pili wrote:

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