问题描述:
HTTP Status 500 - Request processing failed; nested exception is com.alibaba.dubbo.rpc.RpcException: Failed to invoke the method findAll in the service com.xxx.sellgoods.service.TbBrandService. Tried 3 times of the providers [192.168.93.1:20881] (1/1) from the registry 192.168.188.129:2181 on the consumer 192.168.93.1 using the dubbo version 2.6.4. Last error is: Invoke remote method timeout. method: findAll, provider: dubbo://192.168.93.1:20881/com.xxx.sellgoods.service.TbBrandService?anyhost=true&application=xxx_shop_web&check=false&dubbo=2.0.2&generic=false&interface=com.xxx.sellgoods.service.TbBrandService&methods=findAll&pid=5192®ister.ip=192.168.93.1&remote.timestamp=1648293428232&revision=1.0&side=consumer×tamp=1648293497282, cause: Waiting server-side response timeout. start time: 2022-03-26 19:18:29.390, end time: 2022-03-26 19:18:30.393, client elapsed: 0 ms, server elapsed: 1003 ms, timeout: 1000 ms, request: Request [id=2, version=2.0.2, twoway=true, event=false, broken=false, data=RpcInvocation [methodName=findAll, parameterTypes=[], arguments=[], attachments={path=com.xxx.sellgoods.service.TbBrandService, interface=com.xxx.sellgoods.service.TbBrandService, version=0.0.0}]], channel: /192.168.93.1:2495 -> /192.168.93.1:20881
type Exception report
message Request processing failed; nested exception is com.alibaba.dubbo.rpc.RpcException: Failed to invoke the method findAll in the service com.xxx.sellgoods.service.TbBrandService. Tried 3 times of the providers [192.168.93.1:20881] (1/1) from the registry 192.168.188.129:2181 on the consumer 192.168.93.1 using the dubbo version 2.6.4. Last error is: Invoke remote method timeout. method: findAll, provider: dubbo://192.168.93.1:20881/com.xxx.sellgoods.service.TbBrandService?anyhost=true&application=xxx_shop_web&check=false&dubbo=2.0.2&generic=false&interface=com.xxx.sellgoods.service.TbBrandService&methods=findAll&pid=5192®ister.ip=192.168.93.1&remote.timestamp=1648293428232&revision=1.0&side=consumer×tamp=1648293497282, cause: Waiting server-side response timeout. start time: 2022-03-26 19:18:29.390, end time: 2022-03-26 19:18:30.393, client elapsed: 0 ms, server elapsed: 1003 ms, timeout: 1000 ms, request: Request [id=2, version=2.0.2, twoway=true, event=false, broken=false, data=RpcInvocation [methodName=findAll, parameterTypes=[], arguments=[], attachments={path=com.xxx.sellgoods.service.TbBrandService, interface=com.xxx.sellgoods.service.TbBrandService, version=0.0.0}]], channel: /192.168.93.1:2495 -> /192.168.93.1:20881
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.alibaba.dubbo.rpc.RpcException: Failed to invoke the method findAll in the service com.xxx.sellgoods.service.TbBrandService. Tried 3 times of the providers [192.168.93.1:20881] (1/1) from the registry 192.168.188.129:2181 on the consumer 192.168.93.1 using the dubbo version 2.6.4. Last error is: Invoke remote method timeout. method: findAll, provider: dubbo://192.168.93.1:20881/com.xxx.sellgoods.service.TbBrandService?anyhost=true&application=xxx_shop_web&check=false&dubbo=2.0.2&generic=false&interface=com.xxx.sellgoods.service.TbBrandService&methods=findAll&pid=5192®ister.ip=192.168.93.1&remote.timestamp=1648293428232&revision=1.0&side=consumer×tamp=1648293497282, cause: Waiting server-side response timeout. start time: 2022-03-26 19:18:29.390, end time: 2022-03-26 19:18:30.393, client elapsed: 0 ms, server elapsed: 1003 ms, timeout: 1000 ms, request: Request [id=2, version=2.0.2, twoway=true, event=false, broken=false, data=RpcInvocation [methodName=findAll, parameterTypes=[], arguments=[], attachments={path=com.xxx.sellgoods.service.TbBrandService, interface=com.xxx.sellgoods.service.TbBrandService, version=0.0.0}]], channel: /192.168.93.1:2495 -> /192.168.93.1:20881
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:981)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:860)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause
com.alibaba.dubbo.rpc.RpcException: Failed to invoke the method findAll in the service com.xxx.sellgoods.service.TbBrandService. Tried 3 times of the providers [192.168.93.1:20881] (1/1) from the registry 192.168.188.129:2181 on the consumer 192.168.93.1 using the dubbo version 2.6.4. Last error is: Invoke remote method timeout. method: findAll, provider: dubbo://192.168.93.1:20881/com.xxx.sellgoods.service.TbBrandService?anyhost=true&application=xxx_shop_web&check=false&dubbo=2.0.2&generic=false&interface=com.xxx.sellgoods.service.TbBrandService&methods=findAll&pid=5192®ister.ip=192.168.93.1&remote.timestamp=1648293428232&revision=1.0&side=consumer×tamp=1648293497282, cause: Waiting server-side response timeout. start time: 2022-03-26 19:18:29.390, end time: 2022-03-26 19:18:30.393, client elapsed: 0 ms, server elapsed: 1003 ms, timeout: 1000 ms, request: Request [id=2, version=2.0.2, twoway=true, event=false, broken=false, data=RpcInvocation [methodName=findAll, parameterTypes=[], arguments=[], attachments={path=com.xxx.sellgoods.service.TbBrandService, interface=com.xxx.sellgoods.service.TbBrandService, version=0.0.0}]], channel: /192.168.93.1:2495 -> /192.168.93.1:20881
com.alibaba.dubbo.rpc.cluster.support.FailoverClusterInvoker.doInvoke(FailoverClusterInvoker.java:102)
com.alibaba.dubbo.rpc.cluster.support.AbstractClusterInvoker.invoke(AbstractClusterInvoker.java:244)
com.alibaba.dubbo.rpc.cluster.support.wrapper.MockClusterInvoker.invoke(MockClusterInvoker.java:75)
com.alibaba.dubbo.rpc.proxy.InvokerInvocationHandler.invoke(InvokerInvocationHandler.java:52)
com.alibaba.dubbo.common.bytecode.proxy0.findAll(proxy0.java)
com.xxx.sellgoods.controller.BrandController.findAll(BrandController.java:19)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:860)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause
com.alibaba.dubbo.remoting.TimeoutException: Waiting server-side response timeout. start time: 2022-03-26 19:18:29.390, end time: 2022-03-26 19:18:30.393, client elapsed: 0 ms, server elapsed: 1003 ms, timeout: 1000 ms, request: Request [id=2, version=2.0.2, twoway=true, event=false, broken=false, data=RpcInvocation [methodName=findAll, parameterTypes=[], arguments=[], attachments={path=com.xxx.sellgoods.service.TbBrandService, interface=com.xxx.sellgoods.service.TbBrandService, version=0.0.0}]], channel: /192.168.93.1:2495 -> /192.168.93.1:20881
com.alibaba.dubbo.remoting.exchange.support.DefaultFuture.get(DefaultFuture.java:159)
com.alibaba.dubbo.remoting.exchange.support.DefaultFuture.get(DefaultFuture.java:135)
com.alibaba.dubbo.rpc.protocol.dubbo.DubboInvoker.doInvoke(DubboInvoker.java:95)
com.alibaba.dubbo.rpc.protocol.AbstractInvoker.invoke(AbstractInvoker.java:154)
com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75)
com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:72)
com.alibaba.dubbo.rpc.protocol.dubbo.filter.FutureFilter.invoke(FutureFilter.java:54)
com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:72)
com.alibaba.dubbo.rpc.filter.ConsumerContextFilter.invoke(ConsumerContextFilter.java:49)
com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:72)
com.alibaba.dubbo.rpc.listener.ListenerInvokerWrapper.invoke(ListenerInvokerWrapper.java:77)
com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:56)
com.alibaba.dubbo.rpc.cluster.support.FailoverClusterInvoker.doInvoke(FailoverClusterInvoker.java:78)
com.alibaba.dubbo.rpc.cluster.support.AbstractClusterInvoker.invoke(AbstractClusterInvoker.java:244)
com.alibaba.dubbo.rpc.cluster.support.wrapper.MockClusterInvoker.invoke(MockClusterInvoker.java:75)
com.alibaba.dubbo.rpc.proxy.InvokerInvocationHandler.invoke(InvokerInvocationHandler.java:52)
com.alibaba.dubbo.common.bytecode.proxy0.findAll(proxy0.java)
com.xxx.sellgoods.controller.BrandController.findAll(BrandController.java:19)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:860)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.47 logs.
Apache Tomcat/7.0.47
出错原因:数据库链接出现问题。
还有一种可能就是,你的数据访问层出现问题了
解决办法:
检查dao包中db.properties中的内容。
mysql5.0——jdbc.driver = com.mysql.jdbc.Driver
mysql8.0——jdbc.driver=com.mysql.cj.jdbc.Driver
- 检查数据库username与password是否正确
- 检查
url
中的数据库名
是否一致 如果你安装了两个版本的mysql,5.0和8.0。记得回忆一下你是不是把端口给改了,想清楚你现在用的版本对应的端口号,url中的端口号也要修改
!是的,我就是忘记改端口号了,呜呜呜。
数据访问层dao层出现问题,检查你的每一个dao对应的impl里面的相关字段以及方法是否写的正确。