Transferring alf_data and database to a new instance

togmolodon — Wed, 10 Oct 2012 00:01:25 GMT

Hi,We currently have Alfresco version 4d installed, unfortunately for some reason or another, the search function stopped working (lucene?). What I plan to do is install a new instance and copy alf_data and and make a pg_dump of PostgreSQL database, then transfer both to the new instance. Is the bes

Re: Transferring alf_data and database to a new instance

sujaypillai — Wed, 10 Oct 2012 08:35:53 GMT

Hi,

I would recommend you first do a full index rebuild by setting the property

index.recovery.mode=FULL

The best way would be to build your alfresco server back from existing ALF_DATA content & DB backup.

Can you post the error encountered by you?

Thanks,

Re: Transferring alf_data and database to a new instance

togmolodon — Thu, 11 Oct 2012 03:11:38 GMT

Thanks for the prompt response Sujay!

Before I set index.recovery.mode=FULL, I need to stop Alfresco from running, right? Also, I have read from other blogs that I need to delete the contents of of /alf_data/lucene-indexes and /alf_data/backup-lucene-indexes directories respectively, unfortunately, I can't seem to find the said directories. Both the production server and the test server I am doing this does not have those directories.

Please advise.

Re: Transferring alf_data and database to a new instance

togmolodon — Thu, 11 Oct 2012 04:01:16 GMT

I've changed index.recovery.mode from VALIDATE to FULL. Stopped and Re-started Alfresco. Snippet of the logs relevant to Lucene below.

Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 09110101
   at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:364)
   at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:49)
   at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:348)
   at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:152)
   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:67)
   at org.alfresco.repo.search.AbstractSearcherComponent.query(AbstractSearcherComponent.java:53)
   at sun.reflect.GeneratedMethodAccessor603.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:65)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy13.query(Unknown Source)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.FeedbackProcessor$1$1.execute(FeedbackProcessor.java:88)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.FeedbackProcessor$1.doWork(FeedbackProcessor.java:82)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.FeedbackProcessor.run(FeedbackProcessor.java:77)
   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:597)
   at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
   at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)
   … 3 more
Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path validation failed: java.security.cert.CertPathValidatorException: timestamp check failed
   at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Alerts.java:174)
   at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1649)
   at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Handshaker.java:241)
   at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Handshaker.java:235)
   at com.sun.net.ssl.internal.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1206)
   at com.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:136)
   at com.sun.net.ssl.internal.ssl.Handshaker.processLoop(Handshaker.java:593)
   at com.sun.net.ssl.internal.ssl.Handshaker.process_record(Handshaker.java:529)
   at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:893)
   at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1138)
   at com.sun.net.ssl.internal.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:632)
   at com.sun.net.ssl.internal.ssl.AppOutputStream.write(AppOutputStream.java:59)
   at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
   at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
   at org.apache.commons.httpclient.methods.EntityEnclosingMethod.writeRequestBody(EntityEnclosingMethod.java:506)
   at org.apache.commons.httpclient.HttpMethodBase.writeRequest(HttpMethodBase.java:2114)
   at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1096)
   at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
   at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
   at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
   at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
   at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:318)
   … 27 more

Re: Transferring alf_data and database to a new instance

sujaypillai — Thu, 11 Oct 2012 05:56:37 GMT

I think you hit the same problem what I had faced 2 weeks before i.e. your SSL certificates used by Alfresco got expired and you need to regenerate it.

Please go through this thread @ https://forums.alfresco.com/en/viewtopic.php?f=48&t=46407

Thanks,
Sujay Pillai

Re: Transferring alf_data and database to a new instance

togmolodon — Fri, 12 Oct 2012 00:06:51 GMT

Worked perfectly, you saved my day!

Thanks Sujay!

topic Re: Transferring alf_data and database to a new instance in Alfresco Archive

Transferring alf_data and database to a new instance

Re: Transferring alf_data and database to a new instance

Re: Transferring alf_data and database to a new instance

Re: Transferring alf_data and database to a new instance

Re: Transferring alf_data and database to a new instance

Re: Transferring alf_data and database to a new instance