topic Lucene over SOLR in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23402#M10225 <HTML><HEAD></HEAD><BODY><P>I'm running an older version of Alfresco CE and I wanted to ask what the difference between specifying the <STRONG>'index.subsystem.name' property</STRONG> as <STRONG>'lucene'</STRONG> over <STRONG>'solr'.&nbsp;</STRONG>Some <A _jive_internal="true" href="https://community.alfresco.com/thread/179254-sorry-there-seems-to-be-a-problem-with-this-part-of-the-pag" rel="nofollow noopener noreferrer">instructions</A> I found from an error message I had mentioned at the end to perform a full index recovery and set the following variable:</P><P></P><P><SPAN style="color: #727174; background-color: #ffffff; border: 0px;">#index.subsystem.name=solr</SPAN><BR style="color: #727174; background-color: #ffffff;" /><SPAN style="color: #727174; background-color: #ffffff; border: 0px;">index.subsystem.name=lucene</SPAN></P><P><SPAN style="color: #727174; background-color: #ffffff; border: 0px;">&nbsp;</SPAN></P><P><SPAN style="color: #727174; background-color: #ffffff; border: 0px;">I know with 4.2f, SOLR1 is still being used and I'm wondering what advantage changing to Lucene would have if any. The command didn't work and gave me the following repeated errors after the full indexing completed:</SPAN></P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><SPAN style="color: #727174; background-color: #ffffff; border: 0px;">alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Search' subsystem, ID: [Search, managed, lucene] failed<BR />org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:<BR />### Error querying database. Cause: java.lang.NullPointerException<BR />### The error may involve alfresco.node.select_NodeProperties-Inline<BR />### The error occurred while setting parameters<BR />### Cause: java.lang.NullPointerException<BR /> at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)<BR /> at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)<BR /> at com.sun.proxy.$Proxy11.selectList(Unknown Source)<BR /> at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:189)<BR /> at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectNodeProperties(NodeDAOImpl.java:508)<BR /> at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.cacheNodesNoBatch(AbstractNodeDAOImpl.java:4672)<BR /> at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.cacheNodes(AbstractNodeDAOImpl.java:4587)<BR /> at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.cacheNodes(AbstractNodeDAOImpl.java:4562)<BR /> at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$ChildAssocRefBatchingQueryCallback.done(AbstractNodeDAOImpl.java:3385)<BR /> at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectChildAssocs(NodeDAOImpl.java:1108)<BR /> at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getChildAssocs(AbstractNodeDAOImpl.java:3417)<BR /> at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1871)<BR /> at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1815)<BR /> at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1803)<BR /> at org.alfresco.repo.node.AbstractNodeServiceImpl.getChildAssocs(AbstractNodeServiceImpl.java:794)<BR /> at sun.reflect.GeneratedMethodAccessor397.invoke(Unknown Source)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:606)<BR /> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<BR /> at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:104)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<BR /> at com.sun.proxy.$Proxy14.getChildAssocs(Unknown Source)<BR /> at sun.reflect.GeneratedMethodAccessor397.invoke(Unknown Source)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:606)<BR /> at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)<BR /> at com.sun.proxy.$Proxy33.getChildAssocs(Unknown Source)<BR /> at sun.reflect.GeneratedMethodAccessor397.invoke(Unknown Source)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:606)<BR /> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<BR /> at org.alfresco.repo.tagging.TagScopePropertyMethodInterceptor.invoke(TagScopePropertyMethodInterceptor.java:152)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.alfresco.repo.lock.mem.LockableAspectInterceptor.invoke(LockableAspectInterceptor.java:200)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:269)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<BR /> at com.sun.proxy.$Proxy14.getChildAssocs(Unknown Source)<BR /> at sun.reflect.GeneratedMethodAccessor397.invoke(Unknown Source)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:606)<BR /> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)<BR /> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)<BR /> at com.sun.proxy.$Proxy14.getChildAssocs(Unknown Source)<BR /> at org.alfresco.repo.admin.IndexConfigurationCheckerImpl.checkIndexConfiguration(IndexConfigurationCheckerImpl.java:120)<BR /> at org.alfresco.repo.admin.IndexConfigurationCheckerBootstrapBean.check(IndexConfigurationCheckerBootstrapBean.java:81)<BR /> at org.alfresco.repo.admin.IndexConfigurationCheckerBootstrapBean.access$100(IndexConfigurationCheckerBootstrapBean.java:37)<BR /> at org.alfresco.repo.admin.IndexConfigurationCheckerBootstrapBean$1.execute(IndexConfigurationCheckerBootstrapBean.java:59)<BR /> at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)<BR /> at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:342)<BR /> at org.alfresco.repo.admin.IndexConfigurationCheckerBootstrapBean.onBootstrap(IndexConfigurationCheckerBootstrapBean.java:64)<BR /> at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)<BR /> at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)<BR /> at org.alfresco.repo.management.subsystems.ChildApplicationContextFactory$ChildApplicationContext.publishEvent(ChildApplicationContextFactory.java:554)<BR /> at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)<BR /> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)<BR /> at org.alfresco.repo.management.subsystems.ChildApplicationContextFactory$ApplicationContextState.start(ChildApplicationContextFactory.java:803)<BR /> at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.start(AbstractPropertyBackedBean.java:991)<BR /> at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.start(AbstractPropertyBackedBean.java:957)<BR /> at org.alfresco.repo.management.subsystems.SwitchableApplicationContextFactory$SwitchableState.start(SwitchableApplicationContextFactory.java:118)<BR /> at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.start(AbstractPropertyBackedBean.java:991)<BR /> at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.getState(AbstractPropertyBackedBean.java:274)<BR /> at org.alfresco.repo.management.subsystems.SwitchableApplicationContextFactory.getApplicationContext(SwitchableApplicationContextFactory.java:67)<BR /> at org.alfresco.repo.management.subsystems.SubsystemProxyFactory.locateBean(SubsystemProxyFactory.java:174)<BR /> at org.alfresco.repo.management.subsystems.SubsystemProxyFactory.access$000(SubsystemProxyFactory.java:41)<BR /> at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<BR /> at com.sun.proxy.$Proxy35.selectNodes(Unknown Source)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:606)<BR /> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<BR /> at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:161)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)<BR /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR /> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<BR /> at com.sun.proxy.$Proxy35.selectNodes(Unknown Source)<BR /> at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:318)<BR /> at org.alfresco.repo.workflow.WorkflowDeployer$1$1.doWork(WorkflowDeployer.java:469)<BR /> at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)<BR /> at org.alfresco.repo.workflow.WorkflowDeployer$1.execute(WorkflowDeployer.java:465)<BR /> at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)<BR /> at org.alfresco.repo.workflow.WorkflowDeployer.onBootstrap(WorkflowDeployer.java:460)<BR /> at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)<BR /> at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)<BR /> at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)<BR /> at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)<BR /> at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)<BR /> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)<BR /> at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)<BR /> at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)<BR /> at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)<BR /> at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)<BR /> at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)<BR /> at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)<BR /> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)<BR /> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)<BR /> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)<BR /> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)<BR /> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)<BR /> at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)<BR /> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)<BR /> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)<BR /> at java.util.concurrent.FutureTask.run(FutureTask.java:166)<BR /> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<BR /> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<BR /> at java.lang.Thread.run(Thread.java:724)<BR />Caused by: org.apache.ibatis.exceptions.PersistenceException:<BR /></SPAN></BLOCKQUOTE></BODY></HTML> Tue, 19 Dec 2017 15:41:01 GMT espressobeanies 2017-12-19T15:41:01Z Lucene over SOLR https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23402#M10225 I'm running an older version of Alfresco CE and I wanted to ask what the difference between specifying the 'index.subsystem.name' property as 'lucene' over 'solr'.&nbsp;Some instructions I found from an error message I had mentioned at the end to perform a full index recovery and set the following variab Tue, 19 Dec 2017 15:41:01 GMT https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23402#M10225 espressobeanies 2017-12-19T15:41:01Z Re: Lucene over SOLR https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23403#M10226 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Changing to lucene has no advantage - it was deprecated/replaced for good reasons. The main thing it gave was transactional queries in a non-clustered set up - which you can now do with transactional metadata query. There is only an advantage if you already have a lucene index from previous versions and you want to migrate.</P><P></P><P>Some developers like lucene as they can spin up everything via spring for testing etc., as there is no dependency on a SOLR web app.<BR /><BR />Andy</P></BODY></HTML> Fri, 05 Jan 2018 11:09:08 GMT https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23403#M10226 andy1 2018-01-05T11:09:08Z Re: Lucene over SOLR https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23404#M10227 <HTML><HEAD></HEAD><BODY><P>Thanks Andy. I didn't realize Solr was built atop Lucene (Apache) and just processes the data differently. Both systems have separate restore methods.&nbsp;</P></BODY></HTML> Fri, 12 Jan 2018 18:41:37 GMT https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23404#M10227 espressobeanies 2018-01-12T18:41:37Z Re: Lucene over SOLR https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23405#M10228 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>The SOLR and lucene search sub-systems are very different beasts - even though SOLR is built on lucene.</P><P>SOLR is an external web (SOLR 1 &amp; SOLR 4) or stand alone application (SOLR 6). Lucene is embedded in the repository for ACS 4 and before. Lucene in ACS was deprecated and only supported for upgrade in ACS 5.</P><P></P><P>Andy</P></BODY></HTML> Mon, 15 Jan 2018 10:35:10 GMT https://connect.hyland.com/t5/alfresco-forum/lucene-over-solr/m-p/23405#M10228 andy1 2018-01-15T10:35:10Z