Re: Function Issue

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