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
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 22.214.171.124.0
• MySQL 5.1.41
Upgrade data template used for upgrade test with data is avaialble here on svn:
All the upgrade logs attached (please see attach and screen with tested configurations).