hi, I have posted this as the latest "answer" (though it isn't really) with all details on stackoverflow http://stackoverflow.com/questions/27966440/normal-query-on-cassandra-using-datastax-enterprise-works-but-not-solr-query . Hope someone from DS can help.
Thanks, Joseph On Tue, Apr 12, 2016 at 9:09 PM, Jack Krupansky <jack.krupan...@gmail.com> wrote: > You'll have to use StackOverflow or DataStax for support on DSE Search. > > It looks like you have a Field Output Transformer ( > *UserFieldOutputTransformer.java*). The NPE might be related to > processing that occurs there - try removing this FOT and see if the NPE > still occurs. For example, maybe the FOT is setting an output column value > to NULL. > > Also, see if there is a "Caused By" entry elsewhere in the Java stack > trace. > > -- Jack Krupansky > > On Tue, Apr 12, 2016 at 6:07 AM, Joseph Tech <jaalex.t...@gmail.com> > wrote: > >> hi, >> >> I am facing an issue where Solr queries executed from cqlsh using the >> solr_query field is throwing an NPE in system.log, while cqlsh shows the >> following error: >> >> Unable to complete request: one or more nodes were unavailable. >> >> These queries work fine thru the Solr admin console UI. >> >> Below is the stacktrace when executing the wildcard query : >> >> select * from user where solr_query='user_id:*ABCD-**'; >> >> The line in bold (from custom Output FT) shows that the key corresponding >> to ABCD-* was identified, but results are not returned. I noticed some >> JIRAs like SOLR-7254 with similar stacktraces, but doesnt mention a fix. >> Please suggest if there's anything on the Cassandra side to be checked for >> this. >> >> INFO [http-8983-exec-1] 2016-04-12 04:46:13,061 >> SolrCoreResourceManager.java (line 553) Trying to load resource schema.xml >> for core XYZ.user by querying from local node with CL QUORUM >> INFO [http-8983-exec-1] 2016-04-12 04:46:13,065 >> SolrCoreResourceManager.java (line 563) Successfully loaded resource >> schema.xml for core XYZ.user by querying from local node. >> INFO [LocalShardServer query worker - 0] 2016-04-12 04:46:32,127 >> *UserFieldOutputTransformer.java >> (line 28) name: user_id, value: ABCD-a552-47c0-b4c1-66ce3db11496* >> ERROR [Thrift:5] 2016-04-12 04:46:32,130 SolrException.java (line 124) >> java.lang.NullPointerException >> at >> org.apache.solr.handler.component.QueryComponent.mergeIds(QueryComponent.java:896) >> at >> org.apache.solr.handler.component.QueryComponent.handleRegularResponses(QueryComponent.java:642) >> at >> org.apache.solr.handler.component.QueryComponent.handleResponses(QueryComponent.java:621) >> at >> org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:319) >> at >> org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:140) >> at org.apache.solr.core.SolrCore.execute(SolrCore.java:1891) >> at >> com.datastax.bdp.search.solr.cql.CqlSolrQueryExecutor.executeSolrQuery(CqlSolrQueryExecutor.java:174) >> at >> com.datastax.bdp.search.solr.cql.CqlSolrQueryExecutor.execute(CqlSolrQueryExecutor.java:96) >> at >> com.datastax.bdp.cassandra.cql3.DseQueryHandler$SolrStatementExecution.execute(DseQueryHandler.java:464) >> at >> com.datastax.bdp.cassandra.cql3.DseQueryHandler.executeOperationWithTiming(DseQueryHandler.java:190) >> at >> com.datastax.bdp.cassandra.cql3.DseQueryHandler.executeOperationWithAuditLogging(DseQueryHandler.java:223) >> at >> com.datastax.bdp.cassandra.cql3.DseQueryHandler.process(DseQueryHandler.java:103) >> at >> org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1958) >> at >> com.datastax.bdp.server.DseServer.execute_cql3_query(DseServer.java:543) >> at >> org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4486) >> at >> org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4470) >> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) >> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) >> at >> org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:204) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> at java.lang.Thread.run(Thread.java:745) >> >> >> >
