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

Avoid issues on concurrent writes with SQL Server

    XMLWordPrintable

    Details

      Description

      Microsoft SQL Server is currently used with SNAPSHOT isolation level.

      The problem with this isolation level is that it prevents concurrent writes. They result in:

      Snapshot isolation transaction aborted due to update conflict. You cannot use snapshot isolation to access table 'dbo.hierarchy' directly or indirectly in database 'nuxeo' to update, delete, or insert the row that has been modified or deleted by another transaction. Retry the transaction or change the isolation level for the update/delete statement.

      We should switch to the READ COMMITTED isolation level, which still using row-based versioning if the database is properly configured with ALTER DATABASE nuxeo SET READ_COMMITTED_SNAPSHOT ON (http://doc.nuxeo.com/x/EgI7).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: