[jira] [Commented] (OFBIZ-3557) Enforced sequence does not work with concurrent access

["Jacques Le Roux (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-3557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14204855#comment-14204855 ] 

Jacques Le Roux commented on OFBIZ-3557:
----------------------------------------

I thought about that a bit these last times. I did not find any clear strategy. Even in Postgres this is not a trivial case (see "Can There Be "Gaps" In The Values Generated By A Sequence" section at http://www.neilconway.org/docs/sequences/).

> Enforced sequence does not work with concurrent access
> ------------------------------------------------------
>
>                 Key: OFBIZ-3557
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3557
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: Release Branch 09.04, Trunk
>            Reporter: Wickersheimer Jeremy
>         Attachments: OFBIZ-3557-1.patch, OFBIZ-3557-2.patch
>
>
> There is a fundamental issue with enforced sequences (for orders, invoices, etc ..) and concurrency.
> For example if two users are creating an order at the same time one of them will see the creation fail with a PK error. The problem is that the "getNextXXXId" rely on the party accounting preference entity, but there is absolutely no guarantee that the last number in the sequence gets updated before another service can read it.
> This is at best very annoying when used only internally but may be unpractical for e-commerce sites.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)