Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-9405

CLONE - When upgrading on Oracle RAC from version 3.2.2 to version 3.3 or higher, values returned by sequences are not ordered.

    Details

      Description

      If an Oracle sequence is created without clause “ORDERED” it can can have undesirable side effects when using ORCLE RAC.

      How to reproduce ?:

      Install a 3.2 out of te box on Oracle RAC.
      Create a rule adding versionable aspect to all documents.
      Create some documents with some versions
      Upgrade to 4.1.4
      Create additional versions util getting an error

      Observed result :
      You should get the error like « Unexpected: current version does not appear to be 1st version in the list
      [workspace://version2Store/d3f21c3c-af96-40b8-8c15-070a89a8a084, workspace://SpacesStore/a7540095-e9e5-42e2-a0e2-231014f09967] »

      Expected result :
      No error.

      Notes/Hints :

      • If an out of the box 4.1.4 version is installed on RAC and if it is not the result of an upgrade then it works fine because sequences are all created in “AlfrescoCreate-RepoTables.sql” with the ORDER clause.
      • If sequences are created during an upgrade from a version before 3.2.x then sequences are created without the “ORDER” clause in upgrade/3.3/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/fix-repo-seqs.sql

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs (Inactive)
                  Reporter:
                  pdubois Philippe Dubois [X] (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 day, 1 hour
                    1d 1h

                      Structure Helper Panel