More than one root node idex:2

[naveenkumar]

I created my database dump, i copied complete alf_data folder. For new installation i planned to use the dump and the alf_data. when i start my server i am getting "More than one root node index".

For Kind information:
I am working in web projects folder, when i work out of web project able to reuse.

1.alfresco 2.1 community edition.
2. Mysql

here is my log.

16:04:40,359 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: Failed to start modules
   at org.alfresco.repo.module.ModuleComponentHelper.startModules(ModuleComponentHelper.java:240)
   at org.alfresco.repo.module.ModuleServiceImpl.startModules(ModuleServiceImpl.java:132)
   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:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy45.startModules(Unknown Source)
   at org.alfresco.repo.module.ModuleStarter.onBootstrap(ModuleStarter.java:54)
   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:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:448)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
   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:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2
   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.initialise(LeafScorer.java:252)
   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.<init>(LeafScorer.java:164)
   at org.alfresco.repo.search.impl.lucene.query.PathScorer.createPathScorer(PathScorer.java:167)
   at org.alfresco.repo.search.impl.lucene.query.PathQuery$StructuredFieldWeight.scorer(PathQuery.java:258)
   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:130)
   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:100)
   at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:66)
   at org.apache.lucene.search.Hits.<init>(Hits.java:45)
   at org.apache.lucene.search.Searcher.search(Searcher.java:45)
   at org.apache.lucene.search.Searcher.search(Searcher.java:37)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:314)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:188)
   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:68)
   at org.alfresco.repo.search.AbstractSearcherComponent.query(AbstractSearcherComponent.java:59)
   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:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
   at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentImpl.java:256)
   at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:191)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy17.query(Unknown Source)
   at org.alfresco.repo.admin.registry.RegistryServiceImpl.getRegistryRootNodeRef(RegistryServiceImpl.java:134)
   at org.alfresco.repo.admin.registry.RegistryServiceImpl.getPath(RegistryServiceImpl.java:184)
   at org.alfresco.repo.admin.registry.RegistryServiceImpl.getChildElements(RegistryServiceImpl.java:326)
   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:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy41.getChildElements(Unknown Source)
   at org.alfresco.repo.module.ModuleComponentHelper.checkForMissingModules(ModuleComponentHelper.java:296)
   at org.alfresco.repo.module.ModuleComponentHelper.startModules(ModuleComponentHelper.java:230)
   … 47 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks
Naveen

[naveenkumar]

16:16:21,671 DEBUG [org.alfresco.repo.workflow.jbpm.JBPMTransactionTemplate] jBPM persistence service present
16:16:21,671 DEBUG [org.alfresco.repo.workflow.jbpm.JBPMTransactionTemplate] creating hibernateTemplate based on jBPM SessionFactory
16:16:22,953 WARN  [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
16:16:25,578 WARN  [org.alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
16:16:28,828 INFO  [org.alfresco.repo.workflow] Registered Workflow Component 'jbpm' (class org.alfresco.repo.workflow.jbpm.JBPMEngine)
16:16:28,828 INFO  [org.alfresco.repo.workflow] Registered Task Component 'jbpm' (class org.alfresco.repo.workflow.jbpm.JBPMEngine)
16:16:30,828 ERROR [org.alfresco.jcr.repository.JcrRmiBindingUtil] "error occured while binding JCR to RMI [java.rmi.ConnectException: Connection refused to host: PC021328; nested exception is: 
   java.net.ConnectException: Connection refused: connect]
16:16:32,140 ERROR [org.alfresco.jcr.repository.JcrRmiBindingUtil] "error occured while binding JCR to RMI [java.rmi.ConnectException: Connection refused to host: PC021328; nested exception is: 
   java.net.ConnectException: Connection refused: connect]
16:16:33,234 ERROR [org.alfresco.jcr.repository.JcrRmiBindingUtil] "error occured while binding JCR to RMI [java.rmi.ConnectException: Connection refused to host: PC021328; nested exception is: 
   java.net.ConnectException: Connection refused: connect]
16:16:37,343 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
16:16:42,234 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
   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:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:448)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
   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:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2
   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.initialise(LeafScorer.java:252)
   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.<init>(LeafScorer.java:164)
   at org.alfresco.repo.search.impl.lucene.query.PathScorer.createPathScorer(PathScorer.java:167)
   at org.alfresco.repo.search.impl.lucene.query.PathQuery$StructuredFieldWeight.scorer(PathQuery.java:258)
   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:130)
   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:100)
   at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:66)
   at org.apache.lucene.search.Hits.<init>(Hits.java:45)
   at org.apache.lucene.search.Searcher.search(Searcher.java:45)
   at org.apache.lucene.search.Searcher.search(Searcher.java:37)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:272)
   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:85)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.resolveImportedNodeRef(ImporterComponent.java:1026)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.end(ImporterComponent.java:746)
   at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:361)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:224)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)
   … 35 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[naveenkumar]

Copied alf_data folder and used that one in my new installation, when i point to my old database it works fine. I create dump and created new database using the dump, when i use this database i am getting above error.

sure the problem is due to my dump…..


Thanks
Naveen

[davidc]

How are you performing your mysql dump & load?  We do this kind of thing all the time with mysql.

[naveenkumar]

Check my cmd to create dump:

C:\ProgramFiles\mysql\bin>mysqldump -u root  -p –databases alfresco>>alfresco.dump‍

Thanks
Naveen

[naveenkumar]

To load:

@echo off
rem set path to mysql bin folder
SET MYSQL_HOME=C:\Program Files\MySQL\MySQL Server 5.0

SET PATH=%PATH%;%MYSQL_HOME%\bin

ECHO %PATH%

rem —————————————
rem MySQL create DB command
rem —————————————

echo Creating Alfresco database and user…
mysql -u root -p < db_setup.sql

echo Database and users were created

mysql -u root -p < alfresco.dump‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

In db_setup.sql:

create database alfresco;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;‍‍‍

Thanks
Naveen

[naveenkumar]

Its works fine with non- web projects and alfresco 2.0… Facing problem while creating content inside web projects..

Thanks
Naveen

[derek]

Hi,

During startup, the bootstrap process determines that the database schema is correct.  However, it goes on to load data (at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)).  This should not happen unless the database is structurally correct but devoid of any data.

Normally, we use the source command within the MySQL commandline client to load the data:

MySQL> source mydump.sql‍‍

Could you double check, before starting the server that you have data in the database.

Regards

[naveenkumar]

When i ran my db_setup.sql i am not able to see the data in the database, i think thats the problem.

Can you tell me tghe steps to load the data.. provide some details about mydump.sql?? what i have to keep inside the file.

thanks
Naveen.

[derek]

The dump command is fine.  Check the dump file to verify.  Then, as I said, use the source command.