pcallahan-r7 opened a new issue #11855:
URL: https://github.com/apache/druid/issues/11855


   Please provide a detailed title (e.g. "Broker crashes when using TopN query 
with Bound filter" instead of just "Broker crashes").
   
   ### Affected Version
   
   0.22.0
   
   ### Description
   
   Running a druid micro instance.   I'm using the avatica jdbc driver (1.18.0) 
on the client side to make SQL queries to druid.  
   
   About 50% of the calls result in an "UncategorizedSQLException" on the 
client.  On the druid side, there is this exception:
   
   ```
   [org.apache.calcite.avatica.NoSuchConnectionException
        at 
org.apache.druid.sql.avatica.DruidMeta.getDruidConnection(DruidMeta.java:590)
        at 
org.apache.druid.sql.avatica.DruidMeta.createStatement(DruidMeta.java:139)
        at org.apache.druid.sql.avatica.DruidMeta.prepare(DruidMeta.java:150)
        at 
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:195)
        at 
org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1215)
        at 
org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1186)
        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.calcite.avatica.server.AvaticaJsonHandler.handle(AvaticaJsonHandler.java:133)
        at 
org.apache.druid.sql.avatica.DruidAvaticaJsonHandler.handle(DruidAvaticaJsonHandler.java:59)
        at 
org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59)
        at 
org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:179)
        at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
        at org.eclipse.jetty.server.Server.handle(Server.java:516)
        at 
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
        at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
        at 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
        at 
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
        at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
        at 
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:383)
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:882)
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1036)
        at java.lang.Thread.run(Thread.java:748)
   ]
   ```
   
   The SQL queries are simple and they work about 50% of the time.    Also 
using Spring Hikari connection pool, if that matters.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to