Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-3557

Enforced sequence does not work with concurrent access

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Won't Fix
    • Release Branch 09.04, Trunk
    • None
    • framework
    • None
    • Bug Crush Event - 21/2/2015

    Description

      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.

      Attachments

        Issue Links

        depends upon

        Bug - A problem which impairs or prevents the functions of the product. OFBIZ-2353 SequenceUtil may generate duplicate IDs in Load Balancing mode

        • Critical - Crashes, loss of data, severe memory leak.
        • Closed

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            jwickers Wickersheimer Jeremy
            Votes:
            3 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Agile

                Completed Sprint:
                Bug Crush Event - 21/2/2015 ended 26/Feb/15
                View on Board

                Slack

                  Issue deployment