*****SPAM***** [OFBiz] Users - Postgres deadlocks?

[J. Eckard]

Yes, I have been seeing this more and more lately, but I haven't had 
much time to devote to investigation. In my case the deadlock errors 
always occur during payment processing, when messages are stored in the 
PaymentGatewayResponse table. I think it is because I am running 4 
ofbiz instances against one postgres database. (I'm running postgres 
7.4.5 on freebsd)

-Joe

On Mar 3, 2005, at 5:45 PM, Chris Schneider wrote:

> Hi,
>
>  
>
> I have a situation where lots of scheduled jobs accumulate if ofbiz is 
> down, when it comes up they all seem to run at the same time.
>
> What then seems to happen is I get deadlocks on postgres.
>
>  
>
> ERROR: could not open relation 1663/20208/20762: Invalid argument
>
> On Postgres 8 running on XP
>
>  
>
> And something like DEADLOCK DETECTED when connected to postgres 7.4.3 
> on linux.
>
>  
>
> Anyone had this happen ?
>
>  
>
> Thanks for any comments.
>
> Chris.
>
>  
>
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 2160 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/users/attachments/20050303/60676f5d/attachment-0001.bin