Hello
I've decided to upgrade our alfresco 2.1 installation to 3.0 due to I hope fixed a few severe bugs and because new version store implemenation. Our database has grown so fast that we've problem to manage it
Because Oracle database is not supported in community edition I've ported mysql scripts
- AlfrescoSchemaUpdate-2.2-ACL.sql
- upgrade-0-create-missing-tables.sql
- upgrade-from-2.1.sql
Alfresco is an open source project so I belive it's legal
BTW I don't know how mysql scripts work because IMHO there were some minor bugs that stop upgrade process i.e.
- scripts creates tables like avm_aspects, avm_aspects_new etc but they had been already created
- there is no table alt_usage_delta
- there are errors due to missing indexes
In the log I can find
Is it look well ? It's a bit strange for me that old scripts like AlfrescoSchemaUpdate-1.4-TxnCommitTimeIndex.sql has been applied and the log lies a bit i.e.
Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoSchemaUpdate-Person.sql
but there's no such script
Can you give some hints if I made an error in the sql scripts ?
I've installed fresh alresco 2.1 and 3.0 final. I see these web scripts were added in 3.0 and propably should be deployed somehow during startup
I can create them in 2.1just before the upgrade but not sure if it's right solution
Edit:
1. I see I was partially wrong about errors in the scripts. The comment – (optional) is not just a comment
2. I've even downloaded Enterprise trial to check how it's working and got exactly the same error
Edit 2: I've upgraded to alfresco community 3.2 but still got the same error. It seems I've to connect with debugger :evil:
Addinionally new sort of error occured
I've decided to upgrade our alfresco 2.1 installation to 3.0 due to I hope fixed a few severe bugs and because new version store implemenation. Our database has grown so fast that we've problem to manage it
Because Oracle database is not supported in community edition I've ported mysql scripts
- AlfrescoSchemaUpdate-2.2-ACL.sql
- upgrade-0-create-missing-tables.sql
- upgrade-from-2.1.sql
Alfresco is an open source project so I belive it's legal
BTW I don't know how mysql scripts work because IMHO there were some minor bugs that stop upgrade process i.e.
- scripts creates tables like avm_aspects, avm_aspects_new etc but they had been already created
- there is no table alt_usage_delta
- there are errors due to missing indexes
In the log I can find
13:40:46,048 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.
13:40:48,295 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-6661817662740506915.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoSchemaUpdate-2.2-ACL.sql).
13:40:49,816 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-884379181739753616.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/upgrade-0-create-missing-tables.sql).
13:40:49,846 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-5712572419904959336.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/upgrade-from-2.1.sql).
13:40:54,635 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-450527216492820978.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoSchemaUpdate-Person.sql).
13:41:14,458 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-96921935848877916.sql (Generated).
13:41:15,256 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-3847677196743493255.sql (Copied from classpath:alfresco/dbscripts/upgrade/1.4/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoSchemaUpdate-1.4-TxnCommitTimeIndex.sql).
13:41:15,270 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-6428928684330286819.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.0/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoSchemaUpdate-2.0-ContentUrls.sql).
13:41:15,294 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-3605176174582893526.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoSchemaUpdate-2.1-RemoveWcmSubmittedAspect.sql).
13:41:15,315 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-152866005860312089.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoSchemaUpdate-2.1-AuditPathIndex.sql).
13:41:15,332 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect-1886511983672655275.sql (Copied from classpath:alfresco/dbscripts/create/3.0/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/create-activities-extras.sql).
13:41:15,380 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements written to file /opt/web/alfresco-arek/apache-tomcat-6.0.20/temp/Alfresco/AlfrescoSchemaUpdate-All_Statements-3419719545130951523.sql.
Is it look well ? It's a bit strange for me that old scripts like AlfrescoSchemaUpdate-1.4-TxnCommitTimeIndex.sql has been applied and the log lies a bit i.e.
Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoSchemaUpdate-Person.sql
but there's no such script
13:41:21,209 INFO [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/xxx
13:41:21,268 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
13:41:21,453 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.webscripts2' (Adds Web Scripts (second set) to Data Dictionary.).
13:41:22,236 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.customModels' (Adds 'Models' folder to Data Dictionary).
13:41:24,167 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.customMessages' (Adds 'Messages' folder to Data Dictionary).
13:41:24,707 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.customWebClientExtension' (Adds 'Web Client Extension' folder to Data Dictionary).
13:41:24,942 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.webscripts3' (Update Web Scripts ReadMe.).
13:41:25,014 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.customWorkflowDefs' (Adds 'Workflow Definitions' folder to Data Dictionary.).
13:41:25,336 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.emailContributorGroup' (Adds the 'GROUP_EMAIL_CONTRIBUTORS' group.).
13:41:25,465 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.avmStoreAsIdentifier' (Reindex wca:webfolder to make wca:avmstore an identifier).
13:41:25,493 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.avmFormPropertyIdentifier' (Reindex wca:webform to make wca:formname an identifier).
13:41:25,499 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.formsFolder' (Adds 'Forms' folder to Data Dictionary.).
13:41:25,586 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.tagRootCategory' (Adds 'Tags' as new top-level category root.).
13:41:25,721 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.deploymentMigration' (Migrates deployment data to the new model.).
13:41:25,729 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.updateAvmPermissionData' (Update avm permissions from 'webfolder' to 'cmobject'.).
13:41:25,743 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.updateAvmPermissions' (Update ACLs on all avm objects to the new 2.2 permission model).
13:41:25,801 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.db-V2.2-2-MoveQNames' (A placeholder patch; usually marks a superceded patch.).
13:41:25,805 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.wcmPermissionPatch' (Fix ACLs so they are only set on the staging area store.).
13:41:26,476 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.wcmPostPermissionSnapshotPatch' (Snapshot stores (after fixing ACLs so they are only set on the staging area store).).
13:41:26,674 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.avmWebProjectInheritPermissions02' (Break inheritance of permissions on wca:webfolder object to hide access by default.).
13:41:26,679 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.updateDmPermissions' (Update ACLs on all DM node objects to the new 3.0 permission model).
13:41:28,715 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.createSiteStore' (Create the AVM store for site data structure for 3.0 web-tier clients.).
13:41:28,721 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.sitesFolder' (Adds 'Sites' folder to Company Home.).
13:41:28,834 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.sitePermissionRefactorPatch' (Create permission groups for sites.).
13:41:28,863 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.migrateVersionStore' (Migrate from lightWeightVersionStore to version2Store).
13:41:28,869 INFO [org.alfresco.repo.version.VersionMigrator] Nothing to do (no version histories found in old version store)
13:41:28,876 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.inviteEmailTemplate' (Adds invite email template to invite space).
13:41:28,982 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.calendarNamespaceUri' (Update the Calendar model namespace URI and reindex all calendar objects.).
13:41:29,008 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.spacesStoreGuestPermission' (Sets READ permissions for GUEST on root node of the SpacesStore.).
13:41:29,139 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.redeploySubmitProcess4' (Re-deploy WCM Submit Process Definition.).
13:41:29,360 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.administratorGroup' (Adds the 'ALFRESCO_ADMINISTRATORS' group.).
13:41:29,469 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.webscripts2
RESULT:
Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,469 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.customModels
RESULT:
Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,469 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.customMessages
RESULT:
Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,469 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.customWebClientExtension
RESULT:
Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,469 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.webscripts3
RESULT:
Imported view into bootstrap location: / (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,469 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.customWorkflowDefs
RESULT:
Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.emailContributorGroup
RESULT:
Imported view into bootstrap location: /sys:system/sys:authorities (user://alfrescoUserStore/c11fcbf3-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.avmStoreAsIdentifier
RESULT:
Reindexed wca:webfolder to make wca:avmstore an identifier
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.avmFormPropertyIdentifier
RESULT:
Reindexed wca:webform to make wca:formname an identifier
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.formsFolder
RESULT:
Imported view into bootstrap location: /app:company_home/app:dictionary (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.tagRootCategory
RESULT:
Imported view into bootstrap location: /cm:categoryRoot (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.deploymentMigration
RESULT:
Deployment data has been migrated.
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.updateAvmPermissionData
RESULT:
Changed 4 webfolder access control entries to cmobject.
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.updateAvmPermissions
RESULT:
Updated ACLs. Created 0 defining and 0 layered ACLs.
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.2-2-MoveQNames
RESULT:
No-op patch
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.wcmPermissionPatch
RESULT:
Updated ACLs: ACLS are moved to the staging area store and removed from all other stores. They are now applied via layering.
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.wcmPostPermissionSnapshotPatch
RESULT:
Snapshot complete after WCM ACL changes.
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.avmWebProjectInheritPermissions02
RESULT:
Removed inheritance of permissions on all wca:webfolder objects.
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.updateDmPermissions
RESULT:
Updated ACLs. Created 15 defining ACLs.
=====================================
13:41:29,470 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.createSiteStore
RESULT:
Created the AVM site data store.
=====================================
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.sitesFolder
RESULT:
Imported view into bootstrap location: /app:company_home (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.sitePermissionRefactorPatch
RESULT:
Groups have been created for all sites and user's allocated accordingly.
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.migrateVersionStore
RESULT:
Migrated version store. Created 0 version histories
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.inviteEmailTemplate
RESULT:
Imported view into bootstrap location: /app:company_home/app:dictionary/app:email_templates (workspace://SpacesStore/c20215d7-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.calendarNamespaceUri
RESULT:
Updated the Calendar model namespace URI to http://www.alfresco.org/model/calendar and reindexed 0 calendar objects.
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.spacesStoreGuestPermission
RESULT:
Granted READ permissions for GUEST on root node of the SpacesStore.
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.2-Upgrade-From-2.2SP1
RESULT:
Preceeded by alternative patch 'patch.db-V2.2-Upgrade-From-2.1'.
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.redeploySubmitProcess4
RESULT:
Re-deployed 1 workflows.
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.administratorGroup
RESULT:
Imported view into bootstrap location: /sys:system/sys:authorities (user://alfrescoUserStore/c11fcbf3-9232-11de-99df-57201afa39d1)
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.2-ACL
RESULT:
Script completed
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.2-0-CreateMissingTables
RESULT:
Script completed
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.2-Upgrade-From-2.1
RESULT:
Script completed
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.2-Person
RESULT:
Script completed
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V1.4-TxnCommitTimeIndex
RESULT:
Script completed
=====================================
13:41:29,471 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.0-ContentUrls
RESULT:
Script completed
=====================================
13:41:29,472 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.1-RemoveWcmSubmittedAspect
RESULT:
Script completed
=====================================
13:41:29,472 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V2.1-AuditPathIndex
RESULT:
Script completed
=====================================
13:41:29,472 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch ===
ID: patch.db-V3.0-0-CreateActivitiesExtras
RESULT:
Script completed
=====================================
13:41:29,474 INFO [org.alfresco.repo.module.ModuleServiceImpl] Found 0 module(s).
13:41:34,573 ERROR [org.alfresco.smb.protocol] Failed to get local domain/workgroup name, using default of WORKGROUP
13:41:34,573 ERROR [org.alfresco.smb.protocol] (This may be due to firewall settings or incorrect <broadcast> setting)
13:41:34,946 INFO [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_14-b08; maximum heap size 1820.500MB
13:41:34,946 INFO [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (Stable 1526) schema 1002 -[b] Installed version 2.1.0 (482) schema 64[/b]
13:41:35,327 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Exception in Transaction.
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:404)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)
at org.alfresco.repo.web.scripts.RepoStore$7.doWork(RepoStore.java:560)
at org.alfresco.repo.web.scripts.RepoStore$7.doWork(RepoStore.java:558)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)
at org.alfresco.repo.web.scripts.RepoStore.getDocument(RepoStore.java:556)
at org.alfresco.web.scripts.DeclarativeRegistry.initWebScripts(DeclarativeRegistry.java:218)
at org.alfresco.web.scripts.DeclarativeRegistry.reset(DeclarativeRegistry.java:174)
at org.alfresco.web.scripts.AbstractRuntimeContainer.reset(AbstractRuntimeContainer.java:231)
at org.alfresco.repo.web.scripts.RepositoryContainer.init(RepositoryContainer.java:458)
at org.alfresco.repo.web.scripts.RepositoryContainer.reset(RepositoryContainer.java:429)
at org.alfresco.web.scripts.AbstractRuntimeContainer.onApplicationEvent(AbstractRuntimeContainer.java:254)
at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.io.IOException: Document org/alfresco/sample/upload.get.desc.xml does not exist.
at org.alfresco.repo.web.scripts.RepoStore$7$1.execute(RepoStore.java:567)
at org.alfresco.repo.web.scripts.RepoStore$7$1.execute(RepoStore.java:562)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
Can you give some hints if I made an error in the sql scripts ?
I've installed fresh alresco 2.1 and 3.0 final. I see these web scripts were added in 3.0 and propably should be deployed somehow during startup
I can create them in 2.1just before the upgrade but not sure if it's right solution
Edit:
1. I see I was partially wrong about errors in the scripts. The comment – (optional) is not just a comment
2. I've even downloaded Enterprise trial to check how it's working and got exactly the same error
Edit 2: I've upgraded to alfresco community 3.2 but still got the same error. It seems I've to connect with debugger :evil:
Addinionally new sort of error occured
14:58:56,962 ERROR [org.alfresco.repo.version.VersionMigrator] Skipping deletion of: workspace://lightWeightVersionStore/1aea8afd-93d1-11de-a069-2982c3ed4cc3
org.springframework.orm.hibernate3.HibernateSystemException: java.lang.IllegalStateException: The org.hibernate.cache.UpdateTimestampsCache Cache is not alive.; nested exception is org.hibernate.cache.CacheException: java.lang.IllegalStateException: The org.hibernate.cache.UpdateTimestampsCache Cache is not alive.
Caused by: org.hibernate.cache.CacheException: java.lang.IllegalStateException: The org.hibernate.cache.UpdateTimestampsCache Cache is not alive.
at org.hibernate.cache.EhCache.put(EhCache.java:125)
at org.hibernate.cache.UpdateTimestampsCache.preinvalidate(UpdateTimestampsCache.java:54)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:318)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:306)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at sun.reflect.GeneratedMethodAccessor385.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1202)
at $Proxy74.flush(Unknown Source)
at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.setQueryFlushMode(DirtySessionMethodInterceptor.java:257)
at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$23.doInHibernate(HibernateNodeDaoServiceImpl.java:2650)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
So what I've found.
The problem comes from method HibernateNodeDaoServiceImpl.getChildAssoc(final Long parentNodeId, final QName assocTypeQName, final String childName)
The following query is executed to find "org" child, parent is "Web Scripts"
But values in the database in the table alf_child_assoc for the "org" child are:
child_node_name_crc = -1
child_node_name is an uuid
qname_localname is org so it's correct
I see there's a patch FixNameCrcValuesPatch but it touches rows where qname localname is "name". Afterwards childNodeName is wrong
Everything seems clear - there is no patch to fix child_node_name. But it's working on mysql
and I've performed upgrade at my home without any problems on the oracle express
Edit: At home I've fresh alfresco 2.1 installation: child_node_name is just the node name i.e. org, at work child_node_name value is an uuid string but as I remeber it's not real (frozen) uuid of this node
Any idea why it's happen ?
Edit 2: I've the found the reason. There're some customization in our alfresco and in the file contentModel.xml property 'duplicate' for the type cm:folder has been changed to 'true'
The problem comes from method HibernateNodeDaoServiceImpl.getChildAssoc(final Long parentNodeId, final QName assocTypeQName, final String childName)
The following query is executed to find "org" child, parent is "Web Scripts"
select
assoc
from
org.alfresco.repo.domain.hibernate.ChildAssocImpl as assoc
where
assoc.parent.id = :parentId and
assoc.typeQNameId = :typeQNameId and
assoc.childNodeNameCrc = :childNodeNameCrc and
assoc.childNodeName = :childNodeName
order by
assoc.index,
assoc.id
But values in the database in the table alf_child_assoc for the "org" child are:
child_node_name_crc = -1
child_node_name is an uuid
qname_localname is org so it's correct
I see there's a patch FixNameCrcValuesPatch but it touches rows where qname localname is "name". Afterwards childNodeName is wrong
Everything seems clear - there is no patch to fix child_node_name. But it's working on mysql
and I've performed upgrade at my home without any problems on the oracle expressEdit: At home I've fresh alfresco 2.1 installation: child_node_name is just the node name i.e. org, at work child_node_name value is an uuid string but as I remeber it's not real (frozen) uuid of this node
Any idea why it's happen ?
Edit 2: I've the found the reason. There're some customization in our alfresco and in the file contentModel.xml property 'duplicate' for the type cm:folder has been changed to 'true'
