Adding detail Exception trace
at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:657)
at
org.apache.drill.exec.store.druid.schema.DruidSchemaFactory$DruidDataSources.getTableNames(DruidSchemaFactory.java:128)
at
org.apache.drill.exec.store.druid.schema.DruidSchemaFactory$DruidDataSources.<init>(DruidSchemaFactory.java:69)
at
org.apache.drill.exec.store.druid.schema.DruidSchemaFactory.registerSchemas(DruidSchemaFactory.java:56)
at
org.apache.drill.exec.store.druid.DruidStoragePlugin.registerSchemas(DruidStoragePlugin.java:73)
at
org.apache.calcite.jdbc.DynamicRootSchema.loadSchemaFactory(DynamicRootSchema.java:109)
at
org.apache.calcite.jdbc.DynamicRootSchema.getSchema(DynamicRootSchema.java:87)
at
org.apache.calcite.jdbc.DynamicRootSchema.getImplicitSubSchema(DynamicRootSchema.java:73)
at
org.apache.calcite.jdbc.CalciteSchema.getSubSchema(CalciteSchema.java:265)
at
org.apache.calcite.sql.validate.SqlValidatorUtil.getSchema(SqlValidatorUtil.java:1050)
at
org.apache.drill.exec.planner.sql.conversion.DrillCalciteCatalogReader.isValidSchema(DrillCalciteCatalogReader.java:171)
at
org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFrom(DrillValidator.java:66)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3383)
at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1009)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:969)
at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:216)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:944)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:651)
at
org.apache.drill.exec.planner.sql.conversion.SqlConverter.validate(SqlConverter.java:190)
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:647)
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:195)
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:169)
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:283)
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163)
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:128)
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:93)
at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:593)
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:274)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
On Thu, Sep 15, 2022 at 5:52 PM James Turton <dz...@apache.org> wrote:
> Good idea, thanks.
>
> On 2022/09/15 14:17, Charles Givre wrote:
> > Hey James,
> > Would it make sense to use OkHttp since it is in use elsewhere?
> >
> > Sent from my iPhone
> >
> >> On Sep 15, 2022, at 08:16, James Turton <dz...@apache.org> wrote:
> >>
> >> Sorry about that, that's a bug. Please watch the following Jira issue
> I just created. This looks like a simple fix so we'll try to have this
> fixed in 1.20.3 and out within a few weeks.
> >>
> >> https://issues.apache.org/jira/browse/DRILL-8307
> >>
> >> Regards
> >> James
> >>
> >>> On 2022/09/15 13:22, jagadeesh maddi wrote:
> >>> Hi Team,
> >>>
> >>> we have created a cluster of apache drill , and by using Druid storage
> >>> plugin we are firing multiple queries on the cluster using same
> >>> connection we are getting exception like this
> >>>
> >>> [1cdd2b75-1310-xxxx-xxxx-5a638567ed07:foreman] INFO
> >>> o.a.d.e.s.d.s.DruidSchemaFactory
> >>> - User Error Occurred: Failure while loading druid datasources for
> database
> >>> 'druid-egsmd300'. (Invalid use of BasicClientConnManager: connection
> still
> >>> allocated.
> >>> Make sure to release the connection before allocating another one.)
> >>> org.apache.drill.common.exceptions.UserException: DATA_READ ERROR:
> Failure
> >>> while loading druid datasources for database '<connection name>'.
> >>>
> >>> please help
> >>>
> >>> Thanks and Regards
> >>> Jagadeesh Maddi
> >>>
>
>
