ERROR c.d.exec.rpc.RpcExceptionHandler - Exception in RPC communication

Does anyone know what this means?

2021-05-27 16:29:36,308 [UserServer-1] INFO c.d.sabot.rpc.user.UserRPCServer - [USER]: Channel closed /10.244.44.95:31010 <–> /10.244.2.0:19041 (user client)
2021-05-27 16:29:36,308 [UserServer-1] WARN c.d.e.s.o.SessionOptionManagerFactoryImpl - Could not find session with sessionId 9550b01e-a28a-463b-ac86-828a8487016b.
2021-05-27 16:29:36,308 [UserServer-1] INFO com.dremio.ConnectionLog - [9550b01e-a28a-463b-ac86-828a8487016b] Connection Closed
2021-05-27 16:29:36,308 [UserServer-1] INFO c.d.s.r.u.UserProtobufLengthDecoder - Channel is closed, discarding remaining 709 byte(s) in buffer.
2021-05-27 16:29:36,309 [UserServer-1] ERROR c.d.exec.rpc.RpcExceptionHandler - Exception in RPC communication. Connection: /10.244.44.95:31010 <–> /10.244.2.0:7449 (user client). Closing connection.
io.netty.handler.codec.CorruptedFrameException: Expected to read a tag of 10 but actually received a value of 3. Happened after reading 0 message.
at com.dremio.exec.rpc.MessageDecoder.checkTag(MessageDecoder.java:212)
at com.dremio.exec.rpc.MessageDecoder.decodeMessage(MessageDecoder.java:132)
at com.dremio.exec.rpc.MessageDecoder.decode(MessageDecoder.java:105)
at com.dremio.sabot.rpc.user.UserProtobufLengthDecoder.decode(UserProtobufLengthDecoder.java:35)
at io.netty.handler.codec.ByteToMessageDecoder.decodeRemovalReentryProtection(ByteToMessageDecoder.java:498)
at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:437)
at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:276)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357)
at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365)
at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163)
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:714)
at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:650)
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:576)
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493)
at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
at java.lang.Thread.run(Thread.java:748)
2021-05-27 16:29:36,309 [UserServer-1] INFO c.d.sabot.rpc.user.UserRPCServer - [USER]: Channel closed /10.244.44.95:31010 <–> /10.244.2.0:7449 (user client)
2021-05-27 16:29:36,314 [UserServer-1] WARN c.d.e.s.o.SessionOptionManagerFactoryImpl - Could not find session with sessionId 3a80d037-99d8-4993-a206-29df5b0f6f2b.
2021-05-27 16:29:36,314 [UserServer-1] INFO com.dremio.ConnectionLog - [3a80d037-99d8-4993-a206-29df5b0f6f2b] Connection Closed

@Shirisha This means that client like Tableau Desktop (10.244.2.0) was connected to either a Dremio coordinator or executor (10.244.44.95). For some reason the client dropped the connection, send us logs from 10.244.44.95 and we can check what happened. If possible send us logs from 10.244.2.0, both logs when the problem happened “2021-05-27 16:29”

Hello I got same issue, Can I have any help here?
I installed in docker( latest windows version)
and tried dremio(latest version && 15.7.0)
Any time when I clicked “Open In Browser” I got this issue.

Logs In Docker.zip (8.7 KB)

@Hao It seems like the 172.17.0.1 is closing the connection, is this your laptop’s IP address?

2021-07-22 01:12:23,797 [UserServer-1] INFO c.d.sabot.rpc.user.UserRPCServer - [USER]: Channel closed /172.17.0.3:31010 <--> /172.17.0.1:48246 (user client)

Hi, I have the same issue with dremio 19.1 on EKS deployed by helm chart_v2.
On UI i see a lot of exceptions like

Could not connect to the Dremio server.

Also every time when I try to connect to big table with a lot of files. I got error and server log show:

 An I/O error has occurred while writing a response message entity to the container output stream.
org.glassfish.jersey.server.internal.process.MappableException: org.eclipse.jetty.io.EofException

May it be somehow related to ALB controller configuration?
Maybe I need to add session affinity?
I use absolutely default config, except reduced CPU to 7.

@GrigorievNick What are your heap and direct memory settings on your coordinator? Do you see a Full GC pause when this issue happens?

@balaji.ramaswamy I have 64Gb per node, 48 I think is a heap(chart compute it).
No, I don’t see top big Stop the world pause or too frequent GC call. And my current installation is used only by me, and there are only 3-5 tables for now.

@GrigorievNick If you are able to upload logs, I can take a look and see what happened

@balaji.ramaswamy yes, please
deremio-coordinator-log.zip (600.8 КБ)

@GrigorievNick Dremio started at starting dremio 2021-12-11T12:31:10.635+0000: [GC pause (G1 Evacuation Pause) (young), 0.0059140 secs] and that is the first line in the log, any chance you have the previous log?

@balaji.ramaswamy I am sorry I don’t understand, your question.

starting dremio

is the first log which Dremio Coordinator writes after JVM start.
At least during deployment to EKS with default log configuration from dremio chart_v2.
And it looks reasonable, later in logs appeared classpath and configurations.

2021-12-11 12:31:11,597 [main] INFO  com.dremio.common.config.SabotConfig - Configuration and plugin file(s) identified in 169ms.
Base Configuration:
	- jar:file:/opt/dremio/jars/dremio-common-19.1.0-202111160130570172-0ee00450.jar!/sabot-default.conf

Intermediate Configuration and Plugin files, in order of precedence:
	- jar:file:/opt/dremio/jars/dremio-adls-plugin-19.1.0-202111160130570172-0ee00450.jar!/sabot-module.conf
	- jar:file:/opt/dremio/jars/
....

@GrigorievNick You are right, Dremio has started on 9047, if UI is not opening up then is there a load balancer or proxy?

2021-12-11 12:31:28,660 [main] INFO com.dremio.dac.server.DremioServer - Started on http://localhost:9047

Yes @balaji.ramaswamy, by default in EKS dremio use Service with LoadBalancer type. Which actually means it uses NLB.

ср, 22 дек. 2021 г., 23:59 Balaji Ramswamy via Dremio <dremio@discoursemail.com>:

@GrigorievNick Can we make sure, there are no issues there? Can you try JDBC/ODBC queries?

Hi @balaji.ramaswamy Sorry for the delay in response.
The problem was in l4 ELB load Balancer.
With ALB all good. I believe it’s somehow related to default socket timeout and no session affinity.

Hi @balaji.ramaswamy ,

I am facing below error while connecting to my local dremio throgh my Spring boot application which used Hikaricp Data source.
can i get any help here?

Error:


2022-07-22 18:17:21.846 ERROR 13240 — [ Client-1] c.c.dremio.exec.rpc.RpcExceptionHandler : Exception in RPC communication. Connection: null <–> null (user client). Closing connection.

java.lang.UnsupportedOperationException: sun.misc.Unsafe or java.nio.DirectByteBuffer.(long, int) not available
at cdjd.io.netty.util.internal.PlatformDependent.directBuffer(PlatformDependent.java:495) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.buffer.NettyArrowBuf.getDirectBuffer(NettyArrowBuf.java:260) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.buffer.NettyArrowBuf.nioBuffer(NettyArrowBuf.java:238) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.buffer.NettyArrowBuf.nioBuffers(NettyArrowBuf.java:222) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.buffer.NettyArrowBuf.setBytes(NettyArrowBuf.java:382) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.buffer.MutableWrappedByteBuf.setBytes(MutableWrappedByteBuf.java:373) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.buffer.ExpandableByteBuf.setBytes(ExpandableByteBuf.java:27) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.buffer.AbstractByteBuf.writeBytes(AbstractByteBuf.java:1132) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.socket.nio.NioSocketChannel.doReadBytes(NioSocketChannel.java:350) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:151) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:719) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:655) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:581) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:986) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at java.base/java.lang.Thread.run(Thread.java:833) ~[na:na]

2022-07-22 18:17:21.857 INFO 13240 — [ Client-1] c.com.dremio.sabot.rpc.user.UserClient : [USER]: Channel closed null <–> null (user client)
2022-07-22 18:17:22.865 ERROR 13240 — [nio-8080-exec-1] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.

java.sql.SQLException: Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <–> null (user client)
at com.dremio.jdbc.impl.DremioExceptionMapper.map(DremioExceptionMapper.java:80) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at com.dremio.jdbc.impl.DremioConnectionImpl.(DremioConnectionImpl.java:104) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at com.dremio.jdbc.impl.DremioJdbc41Factory.newConnection(DremioJdbc41Factory.java:72) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at com.dremio.jdbc.impl.DremioFactory.newConnection(DremioFactory.java:67) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at com.dremio.jdbc.Driver.connect(Driver.java:84) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-4.0.3.jar:na]
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159) ~[spring-jdbc-5.3.13.jar:5.3.13]
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117) ~[spring-jdbc-5.3.13.jar:5.3.13]
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) ~[spring-jdbc-5.3.13.jar:5.3.13]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376) ~[spring-jdbc-5.3.13.jar:5.3.13]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) ~[spring-jdbc-5.3.13.jar:5.3.13]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) ~[spring-jdbc-5.3.13.jar:5.3.13]
at com.softwareag.b2b.bi.archive.query.ArchiveTransactionDAOImpl.testConnection(ArchiveTransactionDAOImpl.java:23) ~[classes/:na]
at com.softwareag.b2b.bi.archive.query.ArchiveTransactionDAOImpl$$FastClassBySpringCGLIB$$91d96dcd.invoke() ~[classes/:na]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.13.jar:5.3.13]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783) ~[spring-aop-5.3.13.jar:5.3.13]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.13.jar:5.3.13]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753) ~[spring-aop-5.3.13.jar:5.3.13]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.13.jar:5.3.13]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.13.jar:5.3.13]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753) ~[spring-aop-5.3.13.jar:5.3.13]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698) ~[spring-aop-5.3.13.jar:5.3.13]
at com.softwareag.b2b.bi.archive.query.ArchiveTransactionDAOImpl$$EnhancerBySpringCGLIB$$d3b32f46.testConnection() ~[classes/:na]
at com.softwareag.b2b.bi.archive.query.ArchiveTransactionController.getTransactionSummary(ArchiveTransactionController.java:25) ~[classes/:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.13.jar:5.3.13]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.13.jar:5.3.13]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.13.jar:5.3.13]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.13.jar:5.3.13]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.13.jar:5.3.13]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.13.jar:5.3.13]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067) ~[spring-webmvc-5.3.13.jar:5.3.13]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) ~[spring-webmvc-5.3.13.jar:5.3.13]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.13.jar:5.3.13]
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.3.13.jar:5.3.13]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:655) ~[tomcat-embed-core-9.0.55.jar:4.0.FR]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.13.jar:5.3.13]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) ~[tomcat-embed-core-9.0.55.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.55.jar:9.0.55]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.3.13.jar:5.3.13]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.13.jar:5.3.13]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.3.13.jar:5.3.13]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.13.jar:5.3.13]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96) ~[spring-boot-actuator-2.5.7.jar:2.5.7]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.13.jar:5.3.13]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.13.jar:5.3.13]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.13.jar:5.3.13]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.55.jar:9.0.55]
at java.base/java.lang.Thread.run(Thread.java:833) ~[na:na]
Caused by: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <–> null (user client)
at cdjd.com.dremio.exec.client.DremioClient$FutureHandler.connectionFailed(DremioClient.java:825) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.sabot.rpc.user.QueryResultHandler$ChannelClosedHandler.connectionFailed(QueryResultHandler.java:387) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$HandshakeSendListener.failed(BasicClient.java:401) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RequestIdMap$RpcListener.setException(RequestIdMap.java:193) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RequestIdMap$SetExceptionProcedure.apply(RequestIdMap.java:118) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RequestIdMap$SetExceptionProcedure.apply(RequestIdMap.java:108) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.carrotsearch.hppc.IntObjectHashMap.forEach(IntObjectHashMap.java:692) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RequestIdMap.doNotify(RequestIdMap.java:104) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RequestIdMap.channelClosed(RequestIdMap.java:71) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RemoteConnection.channelClosed(RemoteConnection.java:208) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RpcBus$ChannelClosedHandler.operationComplete(RpcBus.java:211) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RpcBus$ChannelClosedHandler.operationComplete(RpcBus.java:197) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:578) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:552) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:491) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:616) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.setSuccess0(DefaultPromise.java:605) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:104) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:84) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannel$CloseFuture.setClosed(AbstractChannel.java:1182) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.doClose0(AbstractChannel.java:773) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:749) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:620) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext.close(DefaultChannelPipeline.java:1352) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:622) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:606) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:472) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RpcExceptionHandler.exceptionCaught(RpcExceptionHandler.java:37) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:302) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:281) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.fireExceptionCaught(AbstractChannelHandlerContext.java:273) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext.exceptionCaught(DefaultChannelPipeline.java:1377) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:302) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:281) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.DefaultChannelPipeline.fireExceptionCaught(DefaultChannelPipeline.java:907) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.handleReadException(AbstractNioByteChannel.java:125) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:177) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:719) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:655) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:581) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:986) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
… 1 common frames omitted
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:209) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
… 33 common frames omitted

2022-07-22 18:17:22.883 ERROR 13240 — [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path threw exception [Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.RpcException: HANDSHAKE_COMMUNICATION : [USER]: Channel closed null <–> null (user client)] with root cause

cdjd.com.dremio.exec.rpc.ChannelClosedException: [USER]: Channel closed null <–> null (user client)
at cdjd.com.dremio.exec.rpc.RpcBus$ChannelClosedHandler.operationComplete(RpcBus.java:209) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RpcBus$ChannelClosedHandler.operationComplete(RpcBus.java:197) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:578) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:552) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:491) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:616) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.setSuccess0(DefaultPromise.java:605) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:104) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:84) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannel$CloseFuture.setClosed(AbstractChannel.java:1182) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.doClose0(AbstractChannel.java:773) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:749) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:620) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext.close(DefaultChannelPipeline.java:1352) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:622) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:606) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:472) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.com.dremio.exec.rpc.RpcExceptionHandler.exceptionCaught(RpcExceptionHandler.java:37) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:302) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:281) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.fireExceptionCaught(AbstractChannelHandlerContext.java:273) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext.exceptionCaught(DefaultChannelPipeline.java:1377) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:302) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeExceptionCaught(AbstractChannelHandlerContext.java:281) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.DefaultChannelPipeline.fireExceptionCaught(DefaultChannelPipeline.java:907) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.handleReadException(AbstractNioByteChannel.java:125) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:177) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:719) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:655) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:581) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:986) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at cdjd.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[dremio-jdbc-driver-22.0.0-202206221430090603-1fa4049f.jar:22.0.0-202206221430090603-1fa4049f]
at java.base/java.lang.Thread.run(Thread.java:833) ~[na:na]

tried with multiple version of dremio driver.
i am using jdk8 for this.

Thanks,
Saurabh

@sauku

what version of Java is on the client?

Hi @balaji.ramaswamy ,

Its java 8.

Thanks,
Saurabh