[ 
https://issues.apache.org/jira/browse/SOLR-16131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17515347#comment-17515347
 ] 

Joel Bernstein commented on SOLR-16131:
---------------------------------------

This is from the solr log on the ClassNotFoundException


{code:java}
2022-03-31 00:46:59.442 INFO  (qtp1016633682-25) [c:test s:shard2 r:core_node3 
x:test_shard2_replica_n1] o.a.s.c.S.Request webapp=/solr path=/sql 
params={stmt=select+id+from+test+limit+10&_=1648687013709} status=0 QTime=0
2022-03-31 00:46:59.442 ERROR (qtp1016633682-25) [c:test s:shard2 r:core_node3 
x:test_shard2_replica_n1] o.a.s.c.s.i.s.ExceptionStream java.io.IOException: 
Failed to load JDBC driver for 'org.apache.solr.handler.sql.CalciteSolrDriver' 
=> java.io.IOException: Failed to load JDBC driver for 
'org.apache.solr.handler.sql.CalciteSolrDriver'
        at 
org.apache.solr.client.solrj.io.stream.JDBCStream.open(JDBCStream.java:287)
java.io.IOException: Failed to load JDBC driver for 
'org.apache.solr.handler.sql.CalciteSolrDriver'
        at 
org.apache.solr.client.solrj.io.stream.JDBCStream.open(JDBCStream.java:287) 
~[?:?]
        at 
org.apache.solr.client.solrj.io.stream.ExceptionStream.open(ExceptionStream.java:49)
 ~[?:?]
        at 
org.apache.solr.handler.StreamHandler$TimerStream.open(StreamHandler.java:486) 
~[?:?]
        at 
org.apache.solr.client.solrj.io.stream.TupleStream.writeMap(TupleStream.java:77)
 ~[?:?]
        at 
org.apache.solr.common.util.JsonTextWriter.writeMap(JsonTextWriter.java:168) 
~[?:?]
        at org.apache.solr.common.util.TextWriter.writeMap(TextWriter.java:241) 
~[?:?]
        at org.apache.solr.common.util.TextWriter.writeVal(TextWriter.java:85) 
~[?:?]
        at 
org.apache.solr.response.TextResponseWriter.writeVal(TextResponseWriter.java:205)
 ~[?:?]
        at org.apache.solr.common.util.TextWriter.writeVal(TextWriter.java:45) 
~[?:?]
        at 
org.apache.solr.common.util.JsonTextWriter.writeNamedListAsMapWithDups(JsonTextWriter.java:387)
 ~[?:?]
        at 
org.apache.solr.common.util.JsonTextWriter.writeNamedList(JsonTextWriter.java:295)
 ~[?:?]
        at 
org.apache.solr.response.JSONWriter.writeResponse(JSONWriter.java:77) ~[?:?]
        at 
org.apache.solr.response.JSONResponseWriter.write(JSONResponseWriter.java:63) 
~[?:?]
        at 
org.apache.solr.response.QueryResponseWriterUtil.writeQueryResponse(QueryResponseWriterUtil.java:71)
 ~[?:?]
        at 
org.apache.solr.servlet.HttpSolrCall.writeResponse(HttpSolrCall.java:993) ~[?:?]
        at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:625) 
~[?:?]
        at 
org.apache.solr.servlet.SolrDispatchFilter.dispatch(SolrDispatchFilter.java:234)
 ~[?:?]
        at 
org.apache.solr.servlet.SolrDispatchFilter.lambda$doFilter$0(SolrDispatchFilter.java:202)
 ~[?:?]
        at 
org.apache.solr.servlet.ServletUtils.traceHttpRequestExecution2(ServletUtils.java:257)
 ~[?:?]
        at 
org.apache.solr.servlet.ServletUtils.rateLimitRequest(ServletUtils.java:227) 
~[?:?]
        at 
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:197)
 ~[?:?]
        at 
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:179)
 ~[?:?]
        at 
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:201) 
~[jetty-servlet-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
 ~[jetty-servlet-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) 
~[jetty-servlet-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600) 
~[jetty-security-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) 
~[jetty-servlet-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:191)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.InetAccessHandler.handle(InetAccessHandler.java:177)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
 ~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:322)
 ~[jetty-rewrite-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:763) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at org.eclipse.jetty.server.Server.handle(Server.java:516) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:400) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:645) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:392) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) 
~[jetty-server-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
 ~[jetty-io-9.4.44.v20210927.jar:9.4.44.v20210927]
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) 
~[jetty-io-9.4.44.v20210927.jar:9.4.44.v20210927]
        at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) 
~[jetty-io-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
 ~[jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
 ~[jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
 ~[jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
 ~[jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
 ~[jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
 ~[jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
 ~[jetty-util-9.4.44.v20210927.jar:9.4.44.v20210927]
        at java.lang.Thread.run(Thread.java:834) [?:?]
Caused by: java.lang.ClassNotFoundException: 
org.apache.solr.handler.sql.CalciteSolrDriver
        at java.net.URLClassLoader.findClass(URLClassLoader.java:471) ~[?:?]
        at java.lang.ClassLoader.loadClass(ClassLoader.java:588) ~[?:?]
        at java.lang.ClassLoader.loadClass(ClassLoader.java:521) ~[?:?]
        at 
org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:538)
 ~[jetty-webapp-9.4.44.v20210927.jar:9.4.44.v20210927]
        at java.lang.ClassLoader.loadClass(ClassLoader.java:521) ~[?:?]
        at java.lang.Class.forName0(Native Method) ~[?:?]
        at java.lang.Class.forName(Class.java:315) ~[?:?]
        at 
org.apache.solr.client.solrj.io.stream.JDBCStream.open(JDBCStream.java:283) 
~[?:?]
        ... 60 more

{code}


> sql module cannot load Calcite driver
> -------------------------------------
>
>                 Key: SOLR-16131
>                 URL: https://issues.apache.org/jira/browse/SOLR-16131
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>            Reporter: Joel Bernstein
>            Priority: Blocker
>             Fix For: 9.0
>
>
> After adding the sql module, using -Dsolr.modules=sql from the command line 
> on startup, sql queries throw the following error:
>  Failed to load JDBC driver for 
> 'org.apache.solr.handler.sql.CalciteSolrDriver'
> This makes the sql module inoperable.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org

Reply via email to