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) > > >