【偶发错误】Unknown ProtocolEntity class null

版本2.5.7, 项目偶尔会出现java.lang.RuntimeException: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.sql.SQLException: Unknown ProtocolEntity class null这个错误,看了mysql 8.0的驱动包代码是返回的信息为空就会出现这个错误,同时查了fe的日志出现一些

但是这个错误是接收包的错误,不知道有没有关联。

详细的客户端报错日志:
java.lang.RuntimeException: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.sql.SQLException: Unknown ProtocolEntity class null

at com.haier.bigdata.automat.service.api.impl.InterfaceServiceImpl.doExc(InterfaceServiceImpl.java:303)

at com.haier.bigdata.automat.service.api.impl.InterfaceServiceImpl.exc(InterfaceServiceImpl.java:237)

at com.haier.bigdata.automat.service.api.impl.InterfaceServiceImpl.getReturnResultByDbUpdateCache(InterfaceServiceImpl.java:220)

at com.haier.bigdata.automat.service.api.impl.InterfaceServiceImpl.getReturnResultByCache(InterfaceServiceImpl.java:186)

at com.haier.bigdata.automat.service.api.impl.InterfaceServiceImpl.executeApiReturnResultImpl(InterfaceServiceImpl.java:163)

at com.haier.bigdata.automat.service.api.impl.InterfaceServiceImpl.executeApiReturnResult(InterfaceServiceImpl.java:75)

at com.haier.bigdata.automat.api.endpoint.SimpleApiController.getData$original$jqsyZscO(SimpleApiController.java:82)

at com.haier.bigdata.automat.api.endpoint.SimpleApiController.getData$original$jqsyZscO$accessor$I8aaod0A(SimpleApiController.java)

at com.haier.bigdata.automat.api.endpoint.SimpleApiController$auxiliary$H29Lw0hw.call(Unknown Source)

at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)

at com.haier.bigdata.automat.api.endpoint.SimpleApiController.getData(SimpleApiController.java)

at com.haier.bigdata.automat.api.endpoint.SimpleApiController$$FastClassBySpringCGLIB$$b011f17e.invoke()

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:58)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)

at com.haier.bigdata.automat.api.endpoint.SimpleApiController$$EnhancerBySpringCGLIB$$8e6dd6d5.getData()

at sun.reflect.GeneratedMethodAccessor357.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at com.github.xiaoymin.swaggerbootstrapui.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:84)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at com.github.xiaoymin.swaggerbootstrapui.filter.ProductionSecurityFilter.doFilter(ProductionSecurityFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)

at org.apache.catalina.core.StandardHostValve.invoke$original$SeusTw1W(StandardHostValve.java:143)

at org.apache.catalina.core.StandardHostValve.invoke$original$SeusTw1W$accessor$FzRkYEJM(StandardHostValve.java)

at org.apache.catalina.core.StandardHostValve$auxiliary$vIRjPsge.call(Unknown Source)

at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)

at org.apache.catalina.core.StandardHostValve.invoke$original$O7JB6gOl(StandardHostValve.java)

at org.apache.catalina.core.StandardHostValve.invoke$original$O7JB6gOl$accessor$XgaY4ncN(StandardHostValve.java)

at org.apache.catalina.core.StandardHostValve$auxiliary$qpZh4AP8.call(Unknown Source)

at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)

at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:764)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.sql.SQLException: Unknown ProtocolEntity class null

at com.haier.bigdata.automat.executor.jdbc.query.PreparedQueryExecutor.execPrepareImpl(PreparedQueryExecutor.java:98)

at com.haier.bigdata.automat.executor.jdbc.query.PreparedQueryExecutor.execPrepare(PreparedQueryExecutor.java:60)

at com.haier.bigdata.automat.executor.jdbc.query.PreparedQueryExecutor.exec(PreparedQueryExecutor.java:50)

at com.haier.bigdata.automat.executor.jdbc.query.PreparedQueryExecutor$$FastClassBySpringCGLIB$$893ab081.invoke()

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)

at com.haier.bigdata.automat.executor.jdbc.query.PreparedQueryExecutor$$EnhancerBySpringCGLIB$$d06313c.exec()

at com.haier.bigdata.automat.service.api.impl.InterfaceServiceImpl.doExc(InterfaceServiceImpl.java:301)

… 91 common frames omitted

Caused by: java.util.concurrent.ExecutionException: java.sql.SQLException: Unknown ProtocolEntity class null

at java.util.concurrent.FutureTask.report(FutureTask.java:122)

at java.util.concurrent.FutureTask.get(FutureTask.java:206)

at com.haier.bigdata.automat.executor.jdbc.query.PreparedQueryExecutor.executeSql(PreparedQueryExecutor.java:110)

at com.haier.bigdata.automat.executor.jdbc.query.PreparedQueryExecutor.execPrepareImpl(PreparedQueryExecutor.java:95)

… 104 common frames omitted

Caused by: java.sql.SQLException: Unknown ProtocolEntity class null

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:85)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery$original$P2dGPs8V(ClientPreparedStatement.java:1003)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery$original$P2dGPs8V$accessor$LqSeaS9w(ClientPreparedStatement.java)

at com.mysql.cj.jdbc.ClientPreparedStatement$auxiliary$XvM8CDtE.call(Unknown Source)

at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery$original$ugvDvs2M(ClientPreparedStatement.java)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery$original$ugvDvs2M$accessor$BiRnW4Gz(ClientPreparedStatement.java)

at com.mysql.cj.jdbc.ClientPreparedStatement$auxiliary$z9FA50IB.call(Unknown Source)

at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java)

at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

… 1 common frames omitted

Caused by: com.mysql.cj.exceptions.WrongArgumentException: Unknown ProtocolEntity class null

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)

at com.mysql.cj.jdbc.result.ResultSetFactory.createFromProtocolEntity(ResultSetFactory.java:98)

at com.mysql.cj.jdbc.result.ResultSetFactory.createFromProtocolEntity(ResultSetFactory.java:48)

at com.mysql.cj.protocol.a.TextResultsetReader.read(TextResultsetReader.java:117)

at com.mysql.cj.protocol.a.TextResultsetReader.read(TextResultsetReader.java:48)

at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1598)

at com.mysql.cj.protocol.a.NativeProtocol.readAllResults(NativeProtocol.java:1652)

at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:961)

at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1075)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:930)

… 14 common frames omitted

有后续么,大佬,蹲

没有,完全没有排查思路,你也遇到这个问题了吗

遇到了,但是我们这边影响面很小暂且忽略吧

3.0.8版本的starocks 也会报错,mysql 8.0.29驱动包