Thread: FATAL 2: RelationPutHeapTuple: failed to add tuple

FATAL 2: RelationPutHeapTuple: failed to add tuple

From
"Andrew Bartley"
Date:
Hi,
 
I'm having trouble creating temp tables.
 
Can anyone help me with this?
 
Short of Dumping, dropping, creating and restoring the DB, I'm not sure what to do from here.
 
We have been running this particular function for months.  Today it just does't want to play the game.
 
2002-03-05 14:09:02 [1014]   DEBUG:  query: create temp table request_transnumbers ( transnumber int8 )
2002-03-05 14:09:02 [1014]   FATAL 2:  RelationPutHeapTuple: failed to add tuple
2002-03-05 14:09:02 [1014]   DEBUG:  proc_exit(2)
2002-03-05 14:09:02 [1014]   DEBUG:  shmem_exit(2)
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling reading 5
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling reading 5
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling reading 5
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling reading 5
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling writing 5
/usr/lib/postgresql/bin/postmaster: BackendStartup: pid 1016 user postgres db evolvo socket 5
/usr/lib/postgresql/bin/postmaster child[1016]: starting with (postgres -d2 -v131072 -p evolvo )
FindExec: found "/usr/lib/postgresql/bin/postgres" using argv[0]
2002-03-05 14:09:02 [1016]   DEBUG:  connection: host=[local] user=postgres database=evolvo
2002-03-05 14:09:02 [1016]   DEBUG:  InitPostgres
2002-03-05 14:09:02 [1016]   DEBUG:  StartTransactionCommand
Thanks
 
Andrew Bartley

Re: FATAL 2: RelationPutHeapTuple: failed to add tuple

From
Tom Lane
Date:
"Andrew Bartley" <abartley@evolvosystems.com> writes:
> We have been running this particular function for months.  Today it just do=
> es't want to play the game.

> 2002-03-05 14:09:02 [1014]   DEBUG:  query: create temp table request_trans=
> numbers ( transnumber int8 )
> 2002-03-05 14:09:02 [1014]   FATAL 2:  RelationPutHeapTuple: failed to add =
> tuple

Yipes, that's not supposed to happen.  What PG version is this?  If it's
recent (7.1 or 7.2) I would be interested in poking into the problem
with a debugger.

            regards, tom lane

Re: FATAL 2: RelationPutHeapTuple: failed to add tuple

From
"Andrew Bartley"
Date:
Hi Tom,

The version is Postgres 7.1.3.

The problem is no longer there at the moment.  I had to get our application
up and running...  I ran a vacuum and found one particlar transaction table
in trouble...  Sorry I did not keep the error messages.  I ended up
truncating the table and vacuuming it again.  Then rebuilt the table data.
It seems fine now.  It happened again yesterday on our development box.  The
table in trouble was PG_ATTRIBUTES this time, as I do not have time to try
and rebuild this table in a development environment,  I ended up dropping
and re-creating the DB and loading a production backup.

Thanks

Andrew

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Andrew Bartley" <abartley@evolvosystems.com>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, March 05, 2002 4:49 PM
Subject: Re: [GENERAL] FATAL 2: RelationPutHeapTuple: failed to add tuple


> "Andrew Bartley" <abartley@evolvosystems.com> writes:
> > We have been running this particular function for months.  Today it just
do=
> > es't want to play the game.
>
> > 2002-03-05 14:09:02 [1014]   DEBUG:  query: create temp table
request_trans=
> > numbers ( transnumber int8 )
> > 2002-03-05 14:09:02 [1014]   FATAL 2:  RelationPutHeapTuple: failed to
add =
> > tuple
>
> Yipes, that's not supposed to happen.  What PG version is this?  If it's
> recent (7.1 or 7.2) I would be interested in poking into the problem
> with a debugger.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>