Jdbc connection issue / after update 4.1.4

geertschneider · February 25, 2020, 9:47pm

Hi,

after updating to dremio 4.1.4 our clients using an JDBC connector are failing.

I’ve downloaded the driver from the server (dremio/jars/jdbc-driver/dremio-jdbc-driver-4.1.4-202001240912140359-a90eb503.jar).
After connecting with DBeaver I get following error :

[USER]: Channel closed null <–> null (user client)
Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <–> null (user client)
HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <–> null (user client)
HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <–> null (user client)
[USER]: Channel closed null <–> null (user client)
[USER]: Channel closed null <–> null (user client)

Connection URL : jdbc:dremio:direct=server-address:31010
username and password looks correct.

We also have errors when connecting from MicroStrategy clients.

Kind regards,
Geert

balaji.ramaswamy · March 4, 2020, 3:08pm

@geertschneider

Is your JDBC connection SSL based?

Thanks
@balaji.ramaswamy

dacopan · March 5, 2020, 1:42pm

I’ve the same issue,
Try use driver version 3 even if Dremio server is 4.1.4 and work fine.

eellsworth · December 1, 2020, 9:06pm

Same here.
FYI, I’ve had the same problem with 4.X and 3.3.x drivers. I fell back to 3.0.6 and that solved the problem for me.

Kyle_Porter · December 2, 2020, 11:10pm

Hi everyone, see https://docs.dremio.com/client-applications/tableau-sdk.html#tableau-20203 as this may help resolve the issue for you.

jlcornejo · August 5, 2021, 4:21pm

I have the same problem.
did they find a solution?

sauku · July 25, 2022, 9:56am

Hi ,

i am getting below error:

Caused by: cdjd.com.dremio.exec.rpc.ChannelClosedException: [USER]: Channel closed null <–> null (user client)
at cdjd.com.dremio.exec.rpc.RpcBus$ChannelClosedHandler.operationComplete(RpcBus.java:211) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.com.dremio.exec.rpc.RpcBus$ChannelClosedHandler.operationComplete(RpcBus.java:199) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:551) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:490) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:615) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.util.concurrent.DefaultPromise.setSuccess0(DefaultPromise.java:604) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:104) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:84) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannel$CloseFuture.setClosed(AbstractChannel.java:1158) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.doClose0(AbstractChannel.java:760) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:736) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:607) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext.close(DefaultChannelPipeline.java:1352) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:622) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:606) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:472) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.com.dremio.exec.rpc.RpcExceptionHandler.exceptionCaught(RpcExceptionHandler.java:37) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:302) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:281) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.fireExceptionCaught(AbstractChannelHandlerContext.java:273) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext.exceptionCaught(DefaultChannelPipeline.java:1377) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:302) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:281) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.DefaultChannelPipeline.fireExceptionCaught(DefaultChannelPipeline.java:907) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.handleReadException(AbstractNioByteChannel.java:125) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:174) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:714) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:650) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:576) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at cdjd.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar:20.1.0-202202061055110045-36733c65]
at java.lang.Thread.run(Thread.java:833) ~[?:?]

any soltuion

geertschneider · July 25, 2022, 10:28am

Long time ago

I remember it got fixed - and was a matter of the wrong driver or something like that.
But I can’t remember the details and emails were on my corporate account and as I switch companies…

Geert

sauku · July 25, 2022, 11:09am

Hi @balaji.ramaswamy ,

struggling with this issue since long any help will be appreciated .

My Dremio version is latest : Build
22.0.0-202206221430090603-1fa4049f

jdbc driver version : dremio-jdbc-driver-20.1.0-202202061055110045-36733c65.jar

trying to connect it with spring boot application with hikari CP as DS.

Thanks,
Saurabh

balaji.ramaswamy · July 31, 2022, 4:12am

@what version of java is the client on?

sauku · August 4, 2022, 9:24am

HI @balaji.ramaswamy ,

Java8

Thanks,
Saurabh

balaji.ramaswamy · August 9, 2022, 10:10pm

@sauku The stack looks very similar to an issue when JDK 8 is not used, what is the server JDK version?

Topic		Replies	Views
JDBC connections with latest driver	4	1436	October 30, 2022
Jdbc connection user rpc.ChannelClosedException	3	2772	December 1, 2020
AWS dremio jdbc connection failed	1	885	June 24, 2022
V3.3.2 JDBC connection error	19	8237	September 13, 2022
JDBC support for JDK 17	20	2977	March 18, 2024

Jdbc connection issue / after update 4.1.4

Related Topics