topic Re: More than one root node idex:2 in Alfresco Archive

More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 10:42:49 GMT

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

Re: More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 10:47:33 GMT

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‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 10:51:57 GMT

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

Re: More than one root node idex:2

davidc — Fri, 27 Jul 2007 11:04:38 GMT

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

Re: More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 11:24:10 GMT

Check my cmd to create dump:

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

Thanks
Naveen

Re: More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 11:26:31 GMT

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

Re: More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 11:28:09 GMT

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

Thanks
Naveen

Re: More than one root node idex:2

derek — Fri, 27 Jul 2007 11:58:36 GMT

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

Re: More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 12:39:28 GMT

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.

Re: More than one root node idex:2

derek — Fri, 27 Jul 2007 12:44:21 GMT

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

Re: More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 13:05:18 GMT

i got alfresco.sql using this command:

mysqldump –user=username –password=password alfresco > alfresco.sql‍

when i use mysql>source alfresco.sql will create the alfresco database??

Re: More than one root node idex:2

naveenkumar — Fri, 27 Jul 2007 13:50:56 GMT

Cool man i got it

Here is the details:

To create mydump.sql

mysqldump –user=username –password=password dbname > MyDatabaseBackup.sql‍

Then create database by running db_setup.bat..
to select alfresco database with dump file data:

mysql> use alfresco;
mysql> source alfresco.sql;
 ‍‍‍

thats it created..

Thanks
Naveen