You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Ananda Verma (JIRA)" <ji...@apache.org> on 2014/05/20 09:11:38 UTC

[jira] [Created] (SOLR-6094) DIH deletedPkQuery doesn't allows placeholders in query

Ananda Verma created SOLR-6094:
----------------------------------

             Summary: DIH deletedPkQuery doesn't allows placeholders in query
                 Key: SOLR-6094
                 URL: https://issues.apache.org/jira/browse/SOLR-6094
             Project: Solr
          Issue Type: Bug
          Components: contrib - DataImportHandler
    Affects Versions: 4.3.1
            Reporter: Ananda Verma
            Priority: Blocker
             Fix For: 4.7.3


When using following deletedPkQuery in data-config.xml
{code}deletedPkQuery="SELECT id from ${schema.SCHEMA_NAME}.deleted_users where status = 'ACTIVE'"{code}

It throws following error
{code}20-May-2014 12:35:52 ERROR [org.apache.solr.handler.dataimport.DataImporter.doDeltaImport : 455] :: http-bio-8380-exec-6 :: Delta Import Failed
java.lang.AssertionError: Non-leaf nodes should be of type java.util.Map
	at org.apache.solr.handler.dataimport.VariableResolver.currentLevelMap(VariableResolver.java:235)
	at org.apache.solr.handler.dataimport.VariableResolver.resolve(VariableResolver.java:94)
	at org.apache.solr.handler.dataimport.VariableResolver.replaceTokens(VariableResolver.java:155)
	at org.apache.solr.handler.dataimport.ContextImpl.replaceTokens(ContextImpl.java:254)
	at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextModifiedRowKey(SqlEntityProcessor.java:84)
	at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextModifiedRowKey(EntityProcessorWrapper.java:267)
	at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:776)
	at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:764)
	at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:334)
	at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:219)
	at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:451)
	at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:489)
	at org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:179)
	at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135)
	at org.apache.solr.core.SolrCore.execute(SolrCore.java:1820)
	at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:656)
	at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:359)
	at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:155)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:219)
	at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
{code} 
whereas running {code}deletedPkQuery="SELECT id from schema2.deleted_users where status = 'ACTIVE'"{code} works well



--
This message was sent by Atlassian JIRA
(v6.2#6252)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org