[jira] [Commented] (SOLR-9963) Add Apache Calcite Avatica handler to Solr

["Kevin Risden (JIRA)" <ji...@apache.org>]

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

Kevin Risden commented on SOLR-9963:
------------------------------------

Switched this over to SolrCloudTestCase and found an interesting error that reproduces. I haven't tracked down why yet but it has something to do with multiple shards/replicas on the same node.
{code:java}
NOTE: reproduce with: ant test -Dtestcase=TestAvaticaHandler -Dtests.method=doTest -Dtests.seed=EADB93F28F2F3CA7 -Dtests.slow=true -Dtests.badapples=true -Dtests.locale=ar-QA -Dtests.timezone=HST -Dtests.asserts=true -Dtests.file.encoding=UTF-8

AvaticaClientRuntimeException: Remote driver error: RuntimeException: Connection already exists: bb2eefbb-9f71-4594-894e-5265dd1b72b8
. Error -1 (00000) UNKNOWN

java.lang.RuntimeException: Connection already exists: bb2eefbb-9f71-4594-894e-5265dd1b72b8
at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:621)
at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:285)
at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1770)
at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1750)
at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:94)
at org.apache.calcite.avatica.remote.JsonHandler.apply(JsonHandler.java:52)
at org.apache.solr.handler.AvaticaHandler.handleRequestBody(AvaticaHandler.java:76)
at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:199)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:2566)
at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:711)
at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:516)
at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:394)
at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:340)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
at org.apache.solr.client.solrj.embedded.JettySolrRunner$DebugFilter.doFilter(JettySolrRunner.java:165)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
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.gzip.GzipHandler.handle(GzipHandler.java:703)
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.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
at java.lang.Thread.run(Thread.java:748)
{code}

> Add Apache Calcite Avatica handler to Solr
> ------------------------------------------
>
>                 Key: SOLR-9963
>                 URL: https://issues.apache.org/jira/browse/SOLR-9963
>             Project: Solr
>          Issue Type: Improvement
>          Components: Parallel SQL
>            Reporter: Kevin Risden
>            Assignee: Kevin Risden
>            Priority: Major
>         Attachments: SOLR-9963.patch, SOLR-9963.patch, SOLR-9963.patch, SOLR-9963.patch, test_avatica_solr.sh
>
>
> Apache Calcite Avatica has an http endpoint which allows Avatica drivers to connect to the server. This can be wired in as a handler to Solr. This would allow Solr to be used by any Avatica JDBC/ODBC driver. This depends on the Calcite work from SOLR-8593.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org