Message-ID: <5315EDF0.1020600@aklaver.com>
Date: Tue, 04 Mar 2014 07:14:56 -0800
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:24.0) Gecko/20100101 Thunderbird/24.3.0
MIME-Version: 1.0
To: ALMA TAHIR <almaheena2003@yahoo.co.in>, Tom Lane <tgl@sss.pgh.pa.us>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Function Issue
References: <1393503792.47079.YahooMailNeo@web192706.mail.sg3.yahoo.com>
 <30402.1393511579@sss.pgh.pa.us>
 <1393593190.2407.YahooMailNeo@web192706.mail.sg3.yahoo.com>
 <1393846322.42246.YahooMailNeo@web192703.mail.sg3.yahoo.com>
In-Reply-To: <1393846322.42246.YahooMailNeo@web192703.mail.sg3.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 03/03/2014 03:32 AM, ALMA TAHIR wrote:
> Hi,
>
> I am using below code in multi threaded environment, but when multiple
> threads are accessing then i get : "org.postgresql.util.PSQLException:
> ERROR: tuple concurrently updated" exception. But my concern is I need
> to use it in multi threaded env, for the same reason I am using FOR
> UPDATE with cursor. Then where is the issue??? Am I missing
> something????? Please help me with the same.....


I will say up front I am wandering out of my depth, but here it goes.

I researched the above error message and it always seems to lead back to 
issue with a system catalog tuple getting concurrent updates.

So, are we seeing all the queries that are happening when you run the 
function?
In other words is there anything that touches a system catalog, say an 
ANALYZE?

Are you sure your threads are using separate transactions and are not 
tromping over each other?

What does the Postgres log show around the error message?

>
>
>
>
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql