HTTP Status 500 - Request processing failed；消费者访问获取数据库内容调用findAll()方法请求时。已解决

问题描述：

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&register.ip=192.168.93.1&remote.timestamp=1648293428232&revision=1.0&side=consumer&timestamp=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&register.ip=192.168.93.1&remote.timestamp=1648293428232&revision=1.0&side=consumer&timestamp=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&register.ip=192.168.93.1&remote.timestamp=1648293428232&revision=1.0&side=consumer&timestamp=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&register.ip=192.168.93.1&remote.timestamp=1648293428232&revision=1.0&side=consumer&timestamp=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中的内容。

1. mysql5.0——jdbc.driver = com.mysql.jdbc.Driver
mysql8.0——jdbc.driver=com.mysql.cj.jdbc.Driver
2. 检查数据库username与password是否正确
3. 检查url中的数据库名是否一致
4. 如果你安装了两个版本的mysql,5.0和8.0。记得回忆一下你是不是把端口给改了，想清楚你现在用的版本对应的端口号，url中的端口号也要修改！是的，我就是忘记改端口号了，呜呜呜。

数据访问层dao层出现问题，检查你的每一个dao对应的impl里面的相关字段以及方法是否写的正确。

这篇好文章是转载于：学新通技术网