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

Oracle 10g specific: schema update failure during upgrade from 2.1.7 to 2.2.7 with generated upgrade data

    Details

    • Type: Service Pack Request
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 2.2.7
    • Fix Version/s: 2.2.8
    • Component/s: Repository
    • Labels:
      None
    • Bug Priority:
      Category 1
    • Escalated:
      Yes
    • ACT Numbers:

      UPG

      Description

      Schema upgrade fails during upgrade from 2.1.7 (dev 449) to 2.2.7 (.1 6) on with Oracle 10g both on Windows Server 2003 32-bit and Windows Server 2008 64-bit with generated upgrade data:

      20:08:26,994 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
      SQL: CREATE INDEX idx_avm_hl_revpk ON avm_history_links (descendent, ancestor)
      Error: ORA-00955: name is already used by an existing object

      File: G:\ALF-2351_upg\227\tomcat\temp\Alfresco\AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-59229892731105266.sql
      Line: 1,291
      20:08:26,994 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
      java.sql.SQLException: ORA-00955: name is already used by an existing object
      . . .
      20:08:26,994 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
      org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
      . . .
      Caused by: java.sql.SQLException: ORA-00955: name is already used by an existing object

      (please find full log in attach)

      • Clean upgrades are performed successfully with both with Oracle 10g and Oracle 11g (Windows Server 2003 32-bit, Windows Server 2008 64-bit, Solaris 10).
      • Works fine with MySQL 5.1: both clean upgrade and with generated data one.
      • FULL index recovery (index.recovery.mode=FULL) enabled during upgrade doesn't solve the issue as well.

      DB versions used:
      • Oracle 10.2.0.3.0
      • Oracle 11.1.0.7.0
      • MySQL 5.1.41

      Upgrade data template used for upgrade test with data is avaialble here on svn:
      https://svn.alfresco.com/repos/qa/Other/Alfresco_Upgrade/template.properties

      All the upgrade logs attached (please see attach and screen with tested configurations).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                closedbugs Closed Bugs
                Reporter:
                alfrescoqa Alfresco QA Team
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: