trouble with restore

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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