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
    • 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

        1. ALF-2628.png
          ALF-2628.png
          20 kB
        2. ALF-2628-2.2.8.png
          ALF-2628-2.2.8.png
          29 kB
        3. alfresco-qa-team_results_2010-04-28.zip
          48 kB
        4. alfresco-qa-team_results_2010-06-09.zip
          61 kB
        5. ORA-00955.log
          11 kB

          Issue Links

            Structure

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel