-
Type:
Service Pack Request
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 2.2.7
-
Fix Version/s: 2.2.8
-
Component/s: Repository
-
Labels:None
-
Bug Priority:
-
ACT Numbers:
UPG
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).
- is related to by
-
MNT-7744 2.2 SP8 retests
- Closed