Alfresco 3.2 community and Jboss 4.2.3 GA

[konsultex]

I have an Alfresco 2.1 installation (community) with no customizations working fine in JBoss 4.0.5GA with JDK 1.5.0_x on FC4 but I need to upgrade Alfresco 2.1 to 3.2. Alfresco is one of 4 applications in this JBoss. Here's what I did, following the instructions in the wiki (http://wiki.alfresco.com/wiki/Deploying_Alfresco_on_JBoss😞

a) Stopped Jboss
b) backed up alf_data and the Mysql alfresco database
c) upgarded JDK to 1.6.0_16 (I felt that a newer Java would be e good idea)
d) upgraded to JBoss 4.2.3GA
e) Copied the old conf/alfresco to the new JBoss and copied the new war to /deploy
f) When I first restarted I got the error about the avm_issuer_ids table and I solved it: http://forums.alfresco.com/en/viewtopic.php?f=8&t=20266&p=66496&hilit=create+table+avm_issuer_ids#p6...
g) I started again with a fresh restore of my SQL and alf_data backups (database with avm_issuer_ids) .
hI still get an error but I have no clue about the origin of the problem.

….
2009-10-25 22:22:23,938 INFO  [STDOUT] 22:22:23,938 User:System INFO  [admin.patch.PatchExecuter]       Applying patch 'patch.wcmPostPermissionSnapshotPatch3' (Snapshot stores (after fixing ACLs so they are only set on the staging area store).).                                           
2009-10-25 22:22:23,943 INFO  [STDOUT] 22:22:23,943 User:System ERROR [admin.patch.PatchExecuter] 09250001 com.ibatis.sqlmap.client.SqlMapException: There is no statement named select.AVMNodeEntitiesCountWhereNewInStore in this SqlMap.                                                     
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:231)                             
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:509)                                 
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)                                 
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)                                           
        at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:244)                                
        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)                                           
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:242)                                    
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:236)                                    
        at org.alfresco.repo.domain.patch.ibatis.PatchDAOImpl.getAVMNodeEntitiesCountWhereNewInStore(PatchDAOImpl.java:56)                      
        at org.alfresco.repo.domain.patch.AbstractPatchDAOImpl.getAVMNodesCountWhereNewInStore(AbstractPatchDAOImpl.java:44)                    
        at org.alfresco.repo.domain.hibernate.AclDaoComponentImpl.getNewInStore(AclDaoComponentImpl.java:2054)                                  
        at org.alfresco.repo.admin.patch.impl.WCMPostPermissionSnapshotPatch.applyInternal(WCMPostPermissionSnapshotPatch.java:75)   
…..           
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This happens about 40% into the completion of the "Patch".

Am I missing something else?

Thanks.

[kbonnet]

I'm upgrading from 3.0.0 CE to 3.2r and running into this same error. I dont have any extensions yet; all config coming from alfresco-global.properties.

Any clues?


Koen

[kbonnet]

Hey People,

A workaround for this bug has been posted on JIRA:

https://issues.alfresco.com/jira/browse/ALFCOM-3611

It worked for me at least, running on CentOS 5.3, JDK6, Tomcat6, Alfresco 3.2R.

Good luck!

Koen

[konsultex]

I tried it with the workaround in JIRA and that error went away. Thanks a lot!

I now have a different problem. My index recovery mode was set o VALIDATE and during deploymet of alfresco.war (3.2r) I go the

Context initialization failed java.lang.RuntimeException: Error during run with lock.

problem. I think I solved that one by setting -Xss1024k in my JAVA_OPTS by following some threads in the forum. I also set the reindex option to FULL. When I start again it seems to run pretty well and Alfresco is deployed. But I see this in the log:

8,907 INFO  [STDOUT] 00:56:18,907  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [default]
5,937 INFO  [STDOUT] 00:57:15,937 User:System INFO  [node.index.FullIndexRecoveryComponent]   50 % complete.
5,995 INFO  [STDOUT] 00:57:15,995 User:System INFO  [node.index.FullIndexRecoveryComponent]   60 % complete.
6,098 INFO  [STDOUT] 00:57:16,001 User:System INFO  [node.index.FullIndexRecoveryComponent]   70 % complete.
6,099 INFO  [STDOUT] 00:57:16,099 User:System INFO  [node.index.FullIndexRecoveryComponent]   80 % complete.
3,283 INFO  [STDOUT] 00:57:33,261  ERROR [index.AbstractReindexComponent.threads] Reindexer    17 failed with error: Error during run with lock.
3,350 INFO  [STDOUT] 00:57:33,318  ERROR [index.AbstractReindexComponent.threads] Reindexer    18 failed with error: Error during run with lock.
3,352 INFO  [STDOUT] 00:57:33,352  ERROR [index.AbstractReindexComponent.threads] Reindexer    19 failed with error: Error during run with lock.
3,353 INFO  [STDOUT] 00:57:33,353  ERROR [index.AbstractReindexComponent.threads] Reindexer    20 failed with error: Error during run with lock.
3,853 INFO  [STDOUT] 00:57:33,853 User:System INFO  [node.index.FullIndexRecoveryComponent]   90 % complete.
3,862 INFO  [STDOUT] 00:57:33,862 User:System INFO  [node.index.FullIndexRecoveryComponent]   100 % complete.
9,795 INFO  [STDOUT] 00:57:39,795  ERROR [index.AbstractReindexComponent.threads] Reindexer    23 failed with error: Error during run with lock.
9,863 INFO  [STDOUT] 00:57:39,863  ERROR [index.AbstractReindexComponent.threads] Reindexer    24 failed with error: Error during run with lock.
0,031 INFO  [STDOUT] 00:57:40,031 User:System INFO  [node.index.FullIndexRecoveryComponent] Index recovery completed.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

To me it looks like reindexing is still failing. I then tried it again with -Xss2048k just in case but there was no change.

Does anybody know how to correct that one?

Thanks.

[konsultex]

I finally solved the problem with the indexes together with another one I had. It's not really related to the original problem but I think all these threads should be closed, so in case anyone has a similar problem, here's what I did:

http://forums.alfresco.com/en/viewtopic.php?f=8&t=23755&p=78599#p78599