trouble with restore

[mrksjs]

hello.

i am running 3.4.10 enterprise on windows server 2008  and mysql and i am facing problems when i restore one of my backups.

what the cold backup scritp does:

1. stop alfresco
2. dump db to an external directory (mysqldump -uroot -p123 > backup.sql)
3. copy dir.root to an external directory
4. start alfresco again.


i created a new test site with some documents. for me. to test if the restore worked.


i then started the restore:

1. stop alfresco again
2. copy dir root from external directory into alfresco installation folder
3 restore the dump (mysqldump -uroot -p123 alfresco < backup.sql)
4. start alfresco


after startup i see the state of the repository from after the backup. test site still exists.
when i browse content i receive several error messages

10210021 Wrapped Exception (with status template): 10210047 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 10210046 Failed to open stream onto channel: accessor: ContentAccessor[ contentUrl=store://2012/11/21/17/5/1ad9dade-28b6-4390-9283-21f29a2969f2.bin, mimetype=text/plain, size=0, encoding=UTF-8, locale=de_DE]


full log: http://tny.cz/904857cc

Caused by: org.alfresco.scripts.ScriptException: 10210047 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 10210046 Failed to open stream onto channel: 
   accessor: ContentAccessor[ contentUrl=store://2012/11/21/17/5/1ad9dade-28b6-4390-9283-21f29a2969f2.bin, mimetype=text/plain, size=0, encoding=UTF-8, locale=de_DE]
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:202)
   at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:282)
   at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)
   at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1285)
   at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)
   … 25 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 10210046 Failed to open stream onto channel: 
   accessor: ContentAccessor[ contentUrl=store://2012/11/21/17/5/1ad9dade-28b6-4390-9283-21f29a2969f2.bin, mimetype=text/plain, size=0, encoding=UTF-8, locale=de_DE]
   at org.alfresco.repo.content.AbstractContentReader.getContentInputStream(AbstractContentReader.java:401)
   at org.alfresco.repo.content.AbstractContentReader.getContentString(AbstractContentReader.java:502)
   at org.alfresco.repo.preference.PreferenceServiceImpl.getPreferences(PreferenceServiceImpl.java:151)
   at org.alfresco.repo.preference.script.ScriptPreferenceService.getPreferences(ScriptPreferenceService.java:58)
   at sun.reflect.GeneratedMethodAccessor489.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
   at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
   at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
   at org.mozilla.javascript.gen.c9._c11(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js:668)
   at org.mozilla.javascript.gen.c9.call(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
   at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119)
   at org.mozilla.javascript.gen.c9._c19(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js:1085)
   at org.mozilla.javascript.gen.c9.call(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
   at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
   at org.mozilla.javascript.gen.c9._c0(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js:1317)
   at org.mozilla.javascript.gen.c9.call(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
   at org.mozilla.javascript.gen.c9.call(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
   at org.mozilla.javascript.gen.c9.exec(file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js)
   at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:492)
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:198)
   … 29 more
Caused by: java.lang.UnsupportedOperationException: The content never exists
   at org.alfresco.repo.content.EmptyContentReader.getDirectReadableChannel(EmptyContentReader.java:53)
   at org.alfresco.repo.content.AbstractContentReader.getReadableChannel(AbstractContentReader.java:271)
   at org.alfresco.repo.content.AbstractContentReader.getContentInputStream(AbstractContentReader.java:375)
   … 52 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

what am i missing?


index.recovery.mode is set to AUTO
character set of db is utf8

[sharifu]

When doing a restore remove the following dir and perform full re-index. make sure you have full backup before you do it


remove /opt/alfresco-x/alf_data/solr/archive/SpacesStore  and /opt/alfresco-x/alf_data/solr/workspace/SpacesStore/

move lucene-indexes to lucene-indexes.old and same with backup-lucene-indexes

set index.recovery.mode=FULL in global properties file

make sure the contentstore  directory is newer than the db dump.

start server, post any errors