cancel
Showing results for 
Search instead for 
Did you mean: 

How to implement Clustring of repository

bhavishya_soni
Champ in-the-making
Champ in-the-making
Hi All,

I am quite new to alfresco, I am using alfresco 3.2 version. I want to implement clustring of a repository.
Can anyone, give me the proper details and implementation steps to implement the clustering in alfresco 3.2  ?

Please do the needful,
Thanks in advance.


Regards,
Bhavishya
2 REPLIES 2

viv
Champ in-the-making
Champ in-the-making
Hi,

You may find all required steps on the Alfresco wiki: http://wiki.alfresco.com/wiki/Cluster_Configuration_V2.1.3_and_Later

Hope this helps.

manu
Champ in-the-making
Champ in-the-making
Hi,

I want to use alfresco web client(alfresco 3.0 labs ) for administration purpose and having another j2ee application providing UI for all the DMS operations to users.And I m using alfresco jcr api for interacting with repository for all the operation and my database is mysql.

Issue is i m sharing my alf_Data and alfresco database with alfresco web client and weblogic 10 app server.if any of 1 is get started after cleaning repository(alf_data) and database get started successfully but when another server is get started it is thrws errors for ref. logger is pasted below.
Is there is and configuration issue or what ? :?


Plz. any kind related to this is highly appreciated….

here is my loggers  Smiley Sad

####<Nov 20, 2009 4:49:12 PM GMT+05:30> <Warning> <HTTP> <01HW072800> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1258715952061> <BEA-101162> <User defined listener org.springframework.web.context.ContextLoaderListener failed: org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed.
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:815)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   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 weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:465)
   at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
   at weblogic.security.service.SecurityManager.runAs(Unknown Source)
   at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:175)
   at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1784)
   at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:2999)
   at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1371)
   at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:468)
   at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
   at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
   at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
   at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
   at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
   at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
   at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:16)
   at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:162)
   at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
   at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
   at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
   at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:51)
   at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:196)
   at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
   at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
   at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
   at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
   at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:173)
   at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:89)
   at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
   at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
   at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
java.sql.SQLException: Can't create table '.\alfresco\#sql-82c_282.frm' (errno: 150)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.execute(Statement.java:692)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:700)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:675)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:485)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:767)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   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 weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:465)
   at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
   at weblogic.security.service.SecurityManager.runAs(Unknown Source)
   at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:175)
   at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1784)
   at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:2999)
   at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1371)
   at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:468)
   at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
   at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
   at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
   at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
   at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
   at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
   at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:16)
   at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:162)
   at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
   at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
   at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
   at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:51)
   at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:196)
   at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
   at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
   at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
   at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
   at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:173)
   at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:89)
   at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
   at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
   at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
>
####<Nov 20, 2009 4:49:12 PM GMT+05:30> <Error> <Deployer> <01HW072800> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1258715952155> <BEA-149231> <Unable to set the activation state to true for the application 'IWAS1_3_2_301205'.
weblogic.application.ModuleException:
   at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1373)
   at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:468)
   at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
   at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
   at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
   at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
   at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
   at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
   at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:16)
   at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:162)
   at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
   at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
   at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
   at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:51)
   at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:196)
   at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
   at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
   at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
   at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
   at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:173)
   at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:89)
   at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
   at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
   at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
java.sql.SQLException: Can't create table '.\alfresco\#sql-82c_282.frm' (errno: 150)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.execute(Statement.java:692)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:700)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:675)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:485)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:767)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   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 weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:465)
   at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
   at weblogic.security.service.SecurityManager.runAs(Unknown Source)
   at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:175)
   at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1784)
   at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:2999)
   at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1371)
   at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:468)
   at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
   at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
   at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
   at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
   at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
   at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
   at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
   at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
   at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:16)
   at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:162)
   at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
   at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
   at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
   at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:51)
   at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:196)
   at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
   at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
   at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
   at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
   at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:173)
   at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:89)
   at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
   at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
   at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)



Thanks,
Manu