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

Enforced sequence does not work with concurrent access

    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

        1. OFBIZ-3557-1.patch
          5 kB
          Adrian Crum
        2. OFBIZ-3557-2.patch
          8 kB
          Aleksey Fedorchenko

        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

            People

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

              Dates

                Created:
                Updated:
                Resolved: