Alfresco not working after database restore

[tortiz96]

I had a working Alfresco setup at one point.
I had to restore mysql database. The repository is the same and did not change. I only restored db 
But I get this error when trying to start Alfresco. Am I missing some steps.

01:47:20,265 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: The store 'archive://SpacesStore' has a duplicate root node entry.

[gunjanagarwal]

hi
I am facing the same problem as mentioned by by tortiz96.i dint get as to hw to do the restoration of data…someone please help.

[pmonks]

Have you taken a look at the Backup / Restore process described on the wiki (http://wiki.alfresco.com/wiki/Backup_and_Restore)?  It's pretty detailed and most importantly describes the invariants that must be preserved in order for a backup set to be valid.

Cheers,
Peter

[lucille_arkenst]

@Peter:
Really?  Don't you think we've been through http://wiki.alfresco.com/wiki/Backup_and_Restore a thousand times?  If we are asking for help, it's really not polite of you to blow us off!

Things happen.  Backup fails.  Restore fails.  Sometimes people need advice.  And another thing… the wiki is not all that clear… especially when you follow the directions several times and it still doesn't work.

[pmonks]

Lucille, I'm not sure which reply you're referring to - my last response on this thread was almost 2 years ago and was directed to Gunjan.

Regardless, failure of the repository to start after a restore is usually (but not always) caused by an invalid backup set, and the most common cause of that is not following the process to create backups correctly.  Specifically, the database must be backed up in its entirety first, before the filesystem backup is started, and the database backup must be transactionally consistent (either by performing a cold backup, or by using a backup tool that captures a snapshot of the database in between transactions - the backup must not span transactions).

Note also that the Records Management (DOD 5015.02) functionality changes the backup equation somewhat - it effectively requires that Alfresco only be backed up via the cold backup procedure described at http://wiki.alfresco.com/wiki/Backup_and_Restore.  I notice that this caveat is not mentioned on that wiki page yet - I'll add it shortly.

Cheers,
Peter

[inishant12]

I performed these steps please help
1)i copied the whole folder of alf_data from the previous one to new one
2) then i copied the whole folder of postgre
3)then the shared folder in the tomcat and paralelly the web app folder
after these i did change the index.recovery.mode to full in alfresco-global.properties file
now all data is coming but if i try to retrieve it like to see or to download it is throwing error 404
the previous version one and the new are in the same directory…
please help
the error is shown like this
The Web Script /alfresco/s/api/node/workspace/SpacesStore/fe7fd516-2ee4-4d7b-92ad-facce5e250ca/content/424px-Office-ms-excel.svg.png has responded with a status of 404 - Not Found.

404 Description: Requested resource is not available.

Message: 10100004 Unable to locate content for node ref workspace://SpacesStore/fe7fd516-2ee4-4d7b-92ad-facce5e250ca (property: {http://www.alfresco.org/model/content/1.0}content)

Exception: org.springframework.extensions.webscripts.WebScriptException - 10100004 Unable to locate content for node ref workspace://SpacesStore/fe7fd516-2ee4-4d7b-92ad-facce5e250ca (property: {http://www.alfresco.org/model/content/1.0}content)

org.alfresco.repo.web.scripts.content.ContentStreamer.streamContent(ContentStreamer.java:371)
org.alfresco.repo.web.scripts.content.StreamContent.streamContent(StreamContent.java:253)
org.alfresco.repo.web.scripts.content.ContentGet.streamContentLocal(ContentGet.java:184)
org.alfresco.repo.web.scripts.content.ContentGet.execute(ContentGet.java:167)
org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:439)
org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:447)
org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:508)
org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:546)
org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:358)
org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:376)
org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.alfresco.web.scripts.servlet.StaticAssetCacheFilter.doFilter(StaticAssetCacheFilter.java:69)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:724)

[rjohnson]

You do not go into great detail on your configuration, but I have sucesfully copied Alfresco around between servers before doing the following:-

1. Shutdown alfresco completely.
2. Backup alf_data using tar
3. Copy the tar to the new server
4. Make sure Alfresco is completely shutdown.
5. Delete the existing alf_data
6. Restore my tar file
7. Start Alfresco

This does rely on the fact that you have a default install where all the data is in alf_data if your install differs then the above procedure would need modifying.

From your error message it looks as if there are pointers in postgres that do not exist in the content store which infers that the postgres database backup was taken at a later time than the content store backup. I guess it is also just possible this could be a permissions problem on the content store, (although I would have expected a 403 error for that). Does user id running Alfresco have the necessary permissions on alf_data?

[inishant12]

Thanks Bob Johnson, I did the same, all is right like
1)If I log in alfresco using the previous one password it is authenticated to log in Alfresco.
2)If i try to see previous folder they are there and file too containing in it they are shown as same.
but if i try to download the same file it is not downloading and throwing the exception.

[inishant12]

Bob Johnson,Thanks a lot Man
it is very helpful for me but i cannot mark your post as useful because you haven't posted your content in my reply…!!,So please post it in my reply i will mark it useful.

[mrogers]

I don't see a problem there.   The server is reporting successful start up.