Re: tuple concurrently updated

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus" <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tuple concurrently updated
Date: 2007-05-04 02:16:41
Message-ID: 9179.1178245001@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus" <kobruleht2(at)hot(dot)ee> writes:
> My application receives the folllowing error sometimes.
> 7/XX000:Error while executing the query;ERROR: tuple concurrently updated
> CONTEXT: SQL statement "DROP TABLE templsabi"PL/pgSQL function "drop_table"
> line 2 at execute statement

That's a bit interesting ... what PG version is this exactly? What else
might be touching that table at the same time? Do you have autovacuum
enabled?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-04 02:30:12 Re: Dangers of fsync = off
Previous Message Tom Lane 2007-05-04 02:12:50 Re: Help tracking down error in postgres log