Connection Pool error (jdbc:drill:drillbit=IP address)


#1

Hi There , I am using dremio drill connector in my external service as a datasource, Up To now its working properly , But 2 days back on word i am facing Connection pool timeout error in my external service , I look in the log file in my service i got its a connection pool Timeout , Right now my Dremio deployed in Kubernetes docker container. So i need to Change anything in dremio config while deploy.And how to Increase connection pool as well as timeout in drill,We need to enable any policy in admin support side?


#2

Dremio JDBC url is of the form jdbc:dremio:direct=... or jdbc:dremio:zk=... (see https://docs.dremio.com/drivers/dremio-jdbc-driver.html). Apache Drill JDBC driver is not supported.

If you make sure to use the correct driver and the problem persists, make sure you specified the correct host and port and that you have proper connectivity between your service and your Dremio containers. If the problem still persists, you can try to provide your application logs along with dremio logs.


#3

@laurent you are correct , But in our service we don’t have dremio connector , So we are using drill as a connector to connect the dremio.

this many connector are available to connect my service , so i choose in Drill as connector to connect with Dremio.


#4

@laurent @doron @balaji.ramaswamy any Update for this connector side, How to archive in my Case, Could you tell me.


#5

@Richard-biz

Did you try the steps I mentioned in my previous post?


#6

@laurent we don’t have that connector , for my external service. for your reference i attached screen shot of my external service connector.


#7

I was referring to those instructions:

Without any extra details, I’m afraid we cannot help you resolve the issue.


#8

@laurent thanks for the Response, We Increased our DB dtu and pool configuration , Now we are not facing this issue.


#9

@laurent , if we want to use Drill bit like below

jdbc:drill:drillbit=,as i am using Dremio on analytics world and the Frontend which will display charts ,dashboards having Connector Call Drill …so i have used above url to connect analytics Appication with dremio…

But case is like Our Application dont have option to create custome connector which will accept url as jdbc:dremio:direct ,may i know if connection pool issue is because we have used drillbit in protocol


#10

I will guess it would not, but you would ask to whoever is developing the application (as it might check whatever logs they have)


#11

Glad you figured it out.