Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-22421

Database-level integrity constraints for PostgreSQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 9.2
    • Component/s: Core VCS
    • Tags:
    • Backlog priority:
      500
    • Impact type:
      Configuration Change
    • Upgrade notes:
      Hide

      On VCS the repository configuration can now contain
      <childNameUniqueConstraintEnabled>true</childNameUniqueConstraintEnabled>
      This is available for PostgreSQL, and enabled by default.

      Show
      On VCS the repository configuration can now contain <childNameUniqueConstraintEnabled>true</childNameUniqueConstraintEnabled> This is available for PostgreSQL, and enabled by default.
    • Sprint:
      nxFG 9.2.6
    • Story Points:
      5

      Description

      In scenarios where it's not possible to have an application-level lock to ensure uniqueness of document name creation in a parent, or uniqueness of a complex property list element, or non-parallelism of list extension, in some SQL databases it's possible to have additional database-level constraints that would raise a ConcurrentUpdateException if this situation arises.

      This comes with a performance impact, so must be conditioned by a flag that can be removed for users that don't need it.

      When using PostgreSQL, stricter database-level checks are now enabled to prevent rare document name collisions due to concurrent writes.

        Attachments

          Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. NXP-22724 Database-level integrity constraints on simple lists for PostgreSQL

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-28406 Handle duplicates with MongoDB

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

          New Feature - A new feature of the product, which has yet to be developed. NXP-22959 Add a mode to prevent duplicate documents

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-26825 Handle soft-delete enablement with child name unique constraint

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-23236 AgendaOperationsTest failure on PostgreSQL

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. NXP-22826 Better concurrency for FileManagerService name creation

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. NXDRIVE-926 Automatically retry on 409 (Conflict)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 2 hours
                  1d 2h