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.
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.
@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 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?
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/
....
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.
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?
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]
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.