lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Barnett <oand...@gmail.com>
Subject Re: solr 7.x sql query returns null
Date Thu, 18 Apr 2019 14:19:55 GMT
Hi Joel

Yes it was always setup as cloud.

On Thu, 18 Apr 2019, 15:17 Joel Bernstein, <joelsolr@gmail.com> wrote:

> Was the original index a Solr Cloud index?
>
>
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
>
> On Thu, Apr 18, 2019 at 7:48 AM David Barnett <dave.b@bahwancybertek.com>
> wrote:
>
> > I have a large solr 7.3 collection 400m + documents.
> >
> > I’m trying to use the Solr JDBC driver to query the data but I get a
> >
> >
> > java.io.IOException: Failed to execute sqlQuery 'select id from document
> > limit 10' against JDBC connection 'jdbc:calcitesolr:'.
> > Error while executing SQL "select id from document limit 10": null
> >
> >
> >
> >
> > If I export the documents to JSON and reimport (after a full delete it
> > works without issue but obviously this is not a fix or understanding the
> > issue)
> >
> >
> >
> > Several things I’ve tried try to eliminate the issue but with no success:
> >
> > I’ve tried upgrading to Solr 7.7
> >
> > I’ve run the UpgradeTool on the index
> >
> > I’ve tried replicating the collection to a new instance
> >
> >
> > I am unable to understand what it is within the collection causing the
> > issue, can you suggest a way for me to get more details about the fault
> >
> >
> > Here is the full stack trace from the Logging interface Admin UI:
> >
> >
> > java.io.IOException: Failed to execute sqlQuery 'select id from document
> > limit 10' against JDBC connection 'jdbc:calcitesolr:'.
> > Error while executing SQL "select id from document limit 10": null
> >         at
> >
> org.apache.solr.client.solrj.io.stream.JDBCStream.open(JDBCStream.java:271)
> >         at
> >
> org.apache.solr.client.solrj.io.stream.ExceptionStream.open(ExceptionStream.java:54)
> >         at
> >
> org.apache.solr.handler.StreamHandler$TimerStream.open(StreamHandler.java:394)
> >         at
> >
> org.apache.solr.client.solrj.io.stream.TupleStream.writeMap(TupleStream.java:78)
> >         at
> >
> org.apache.solr.common.util.JsonTextWriter.writeMap(JsonTextWriter.java:164)
> >         at
> > org.apache.solr.common.util.TextWriter.writeVal(TextWriter.java:69)
> >         at
> >
> org.apache.solr.response.TextResponseWriter.writeVal(TextResponseWriter.java:152)
> >         at
> >
> org.apache.solr.common.util.JsonTextWriter.writeNamedListAsMapWithDups(JsonTextWriter.java:386)
> >         at
> >
> org.apache.solr.common.util.JsonTextWriter.writeNamedList(JsonTextWriter.java:292)
> >         at
> > org.apache.solr.response.JSONWriter.writeResponse(JSONWriter.java:73)
> >         at
> >
> org.apache.solr.response.JSONResponseWriter.write(JSONResponseWriter.java:66)
> >         at
> >
> org.apache.solr.response.QueryResponseWriterUtil.writeQueryResponse(QueryResponseWriterUtil.java:65)
> >         at
> > org.apache.solr.servlet.HttpSolrCall.writeResponse(HttpSolrCall.java:788)
> >         at
> org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:525)
> >         at
> >
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:395)
> >         at
> >
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:341)
> >         at
> >
> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1602)
> >         at
> >
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
> >         at
> >
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
> >         at
> >
> org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
> >         at
> >
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
> >         at
> >
> org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
> >         at
> >
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1588)
> >         at
> >
> org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
> >         at
> >
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
> >         at
> >
> org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
> >         at
> > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
> >         at
> >
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1557)
> >         at
> >
> org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
> >         at
> >
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
> >         at
> >
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
> >         at
> >
> org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
> >         at
> >
> org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
> >         at
> >
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
> >         at
> >
> org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:335)
> >         at
> >
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
> >         at org.eclipse.jetty.server.Server.handle(Server.java:502)
> >         at
> > org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
> >         at
> >
> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
> >         at org.eclipse.jetty.io
> > .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
> >         at org.eclipse.jetty.io
> > .FillInterest.fillable(FillInterest.java:103)
> >         at org.eclipse.jetty.io
> > .ChannelEndPoint$2.run(ChannelEndPoint.java:118)
> >         at
> >
> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
> >         at
> >
> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
> >         at
> >
> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
> >         at
> >
> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
> >         at
> >
> org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
> >         at
> >
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
> >         at
> >
> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
> >         at java.lang.Thread.run(Unknown Source)
> > Caused by: java.sql.SQLException: Error while executing SQL "select id
> > from document limit 10": null
> >         at
> > org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> >         at
> > org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> >         at
> >
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
> >         at
> >
> org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218)
> >         at
> >
> org.apache.solr.client.solrj.io.stream.JDBCStream.open(JDBCStream.java:269)
> >         ... 49 more
> > Caused by: java.lang.NullPointerException
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.validate(VolcanoPlanner.java:891)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:866)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:883)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:101)
> >         at
> >
> org.apache.calcite.rel.AbstractRelNode.onRegister(AbstractRelNode.java:336)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1496)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:863)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:883)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:101)
> >         at
> >
> org.apache.calcite.rel.AbstractRelNode.onRegister(AbstractRelNode.java:336)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1496)
> >         at
> >
> org.apache.calcite.plan.volcano.VolcanoPlanner.setRoot(VolcanoPlanner.java:308)
> >         at org.apache.calcite.tools.Programs$5.run(Programs.java:309)
> >         at
> > org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:387)
> >         at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:186)
> >         at
> org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:319)
> >         at
> org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:228)
> >         at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:784)
> >         at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:639)
> >         at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:609)
> >         at
> >
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
> >         at
> >
> org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:603)
> >         at
> >
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:638)
> >         at
> >
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:149)
> >
> >
> >
> > Thanks Dave
> >
> >
> -----------------------------------------------------------------------------------------------------------------------
> > The information contained in this communication is intended solely for
> the
> > use of the individual or entity to whom it is addressed and others
> > authorized to receive it. It may contain confidential or legally
> privileged
> > information. If you are not the intended recipient you are hereby
> notified
> > that any disclosure, copying, distribution or taking any action in
> reliance
> > on the contents of this information is strictly prohibited and may be
> > unlawful. If you are not the intended recipient, please notify us
> > immediately by responding to this email and then delete it from your
> > system. Bahwan Cybertek is neither liable for the proper and complete
> > transmission of the information contained in this communication nor for
> any
> > delay in its receipt.
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message