[jboss-jira] [JBoss JIRA] Closed: (JBMESSAGING-832) UpdateWithRetry issue with postgresql

Wed Jul 4 08:43:51 EDT 2007

     [ http://jira.jboss.com/jira/browse/JBMESSAGING-832?page=all ]

Sergey Koshcheyev closed JBMESSAGING-832.
-----------------------------------------

    Resolution: Cannot Reproduce Bug

It's not clear whether this deadlock can actually happen in practice on PostgreSQL since it uses multiversion concurrency control (optimistic locking).

> UpdateWithRetry issue with postgresql
> -------------------------------------
>
>                 Key: JBMESSAGING-832
>                 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-832
>             Project: JBoss Messaging
>          Issue Type: Bug
>    Affects Versions: 1.2.0.Beta2
>            Reporter: Tim Fox
>         Assigned To: Sergey Koshcheyev
>             Fix For: 1.4.0.CR1
>
>
> Postgresql does not allow any other statements to be executed on a connection if an earlier statement failed.
> Therefore when retrying updates we should explicitly rollback the transaction on each retry.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira