Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 7D8C42004C8 for ; Mon, 9 May 2016 10:25:42 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 7C22716098A; Mon, 9 May 2016 08:25:42 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 7A2401601D4 for ; Mon, 9 May 2016 10:25:41 +0200 (CEST) Received: (qmail 83393 invoked by uid 500); 9 May 2016 08:25:40 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 83383 invoked by uid 99); 9 May 2016 08:25:40 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 May 2016 08:25:40 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 9ADF0180547 for ; Mon, 9 May 2016 08:25:39 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id pHGNCX9BuWxL for ; Mon, 9 May 2016 08:25:37 +0000 (UTC) Received: from mail-yw0-f169.google.com (mail-yw0-f169.google.com [209.85.161.169]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 370375F299 for ; Mon, 9 May 2016 08:25:37 +0000 (UTC) Received: by mail-yw0-f169.google.com with SMTP id g133so243138187ywb.2 for ; Mon, 09 May 2016 01:25:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=TEzTRYMDkqmFNScXsxHw1E0coJgjy/K9mWjR3E+8SPc=; b=bBjXfL60o5YFg5Fo7HqENuEIzG893uzNjBsHas7egj7D1VOLA2mnNnJvw+jivGXe4v 2iZV2i0cW8lQ2yI+wOkVj+SCGs0qD//HKI/YNpdSw8FBprJIoI5Y8lQVGSdw0NyitIL6 ezWCWNXyrumejLL3vJD5tsr3yRBemMawG9Al2uBJcNixenth6pd4ynFOgd/zMzIg/ioT dfc1/u7Of+jmbjlH3gMjE6xaLAxyNFa8F38AVbKPUxm7K68/jf9QPY6u5s8dDFm1CVcQ 4wzlmIS7MDJ2VBxXqYeQ0gmIbVgyuwUuMyJuH0bsCLrNr1pZt5qfLhWSWRYi++pNb+qt OOuQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=TEzTRYMDkqmFNScXsxHw1E0coJgjy/K9mWjR3E+8SPc=; b=eKQQ9WOUcGn1j37t3thj7yfK/OS9FFkdc66sZg+ZGXKr6YGL4HQNV+uKcWjcyY1oIv vpyB9s8DJMud9MvIYtI7uqHSAC22VD6tRn8kHgn2wBjoed7c95fuE1KjUhYzeUk3YKvF oN7wuoxHxVqJskNect0v90EWYOuL8XIiK0eikFORDoQpqz5fnGDFfrMdhKPVQchAfckW nOiZ+2zTVU2CanwqddJ9zQTo59WBci/1dqubtZLO5jBx08PTpmN76wUdPnILzihA4qBZ xcjDsXPj6eYLJ4VvC5WAtaxWkoUL4+vC6v0+qwIvjJ6TBzSQjoP4HF+530bIQ4XCiY2K +BAA== X-Gm-Message-State: AOPr4FXzIrZaiMxgOF+u4X5hVVMHE11aEw2pQ/w/T8/ohrqJkV3Xp5ks8AbIX5P0lu7eh7ECsbwpGkbeX3taOg== MIME-Version: 1.0 X-Received: by 10.129.51.140 with SMTP id z134mr18621273ywz.322.1462782330676; Mon, 09 May 2016 01:25:30 -0700 (PDT) Received: by 10.129.160.2 with HTTP; Mon, 9 May 2016 01:25:30 -0700 (PDT) In-Reply-To: References: Date: Mon, 9 May 2016 13:55:30 +0530 Message-ID: Subject: Re: DSE Search : NPE when executing Solr CQL queries using solr_query From: Joseph Tech To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001a1140746e342f400532648d2b archived-at: Mon, 09 May 2016 08:25:42 -0000 --001a1140746e342f400532648d2b Content-Type: text/plain; charset=UTF-8 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 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 > 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) >> >> >> > --001a1140746e342f400532648d2b Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
hi,

I have posted this as the latest "an= swer" (though it isn't really) with all details on stackoverflow= =C2=A0http://stac= koverflow.com/questions/27966440/normal-query-on-cassandra-using-datastax-e= nterprise-works-but-not-solr-query . Hope someone from DS can help.

Thanks,
Joseph

On Tue, Apr 12, 2016 at 9:0= 9 PM, Jack Krupansky <jack.krupansky@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 proce= ssing that occurs there - try removing this FOT and see if the NPE still oc= curs. For example, maybe the FOT is setting an output column value to NULL.=

Also, see if there is a "Caused By" ent= ry elsewhere in the Java stack trace.

-- Jack Krupansky

On Tue, Apr 12, 2016 at 6:07 AM, Joseph Tech= <jaalex.tech@gmail.com> wrote:
hi,

I am facing an issue wher= e Solr queries executed from cqlsh using the solr_query field is throwing a= n NPE in system.log, while cqlsh shows the following error:=C2=A0

Unable to complete request: one or more nodes were unavaila= ble.

These queries work fine thru the Solr adm= in console UI.=C2=A0

Below is the stacktrace when = executing the wildcard query :=C2=A0

select * from= user where solr_query=3D'user_id:ABCD-*';
The line in bold (from custom Output FT) shows that the key cor= responding to ABCD-* was identified, but results are not returned. I notice= d some JIRAs like=C2=A0SOLR-7254 with similar stacktraces, but doesnt menti= on a fix. Please suggest if there's anything on the Cassandra side to b= e checked for this.

=C2=A0INFO [http-8983-exe= c-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
=C2=A0INFO [http-8983-exec-1] 2016-04-12 04:46:13,= 065 SolrCoreResourceManager.java (line 563) Successfully loaded resource sc= hema.xml for core XYZ.user by querying from local node.
=C2=A0INF= O [LocalShardServer query worker - 0] 2016-04-12 04:46:32,127 UserFieldO= utputTransformer.java (line 28) name: user_id, value: ABCD-a552-47c0-b4c1-6= 6ce3db11496
ERROR [Thrift:5] 2016-04-12 04:46:32,130 SolrExce= ption.java (line 124) java.lang.NullPointerException
at org.apach= e.solr.handler.component.QueryComponent.mergeIds(QueryComponent.java:896)
at org.apache.solr.handler.component.QueryComponent.handleRegularR= esponses(QueryComponent.java:642)
at org.apache.solr.handler.comp= onent.QueryComponent.handleResponses(QueryComponent.java:621)
at = org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHan= dler.java:319)
at org.apache.solr.handler.RequestHandlerBase.hand= leRequest(RequestHandlerBase.java:140)
at org.apache.solr.core.So= lrCore.execute(SolrCore.java:1891)
at com.datastax.bdp.search.sol= r.cql.CqlSolrQueryExecutor.executeSolrQuery(CqlSolrQueryExecutor.java:174)<= /div>
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.executeOperation= WithTiming(DseQueryHandler.java:190)
at com.datastax.bdp.cassandr= a.cql3.DseQueryHandler.executeOperationWithAuditLogging(DseQueryHandler.jav= a:223)
at com.datastax.bdp.cassandra.cql3.DseQueryHandler.process= (DseQueryHandler.java:103)
at org.apache.cassandra.thrift.Cassand= raServer.execute_cql3_query(CassandraServer.java:1958)
at com.dat= astax.bdp.server.DseServer.execute_cql3_query(DseServer.java:543)
at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getR= esult(Cassandra.java:4486)
at org.apache.cassandra.thrift.Cassand= ra$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.Thr= eadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.u= til.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)




--001a1140746e342f400532648d2b--