weixin_54531264 2023-08-11 12:19 采纳率: 62.5%
浏览 9

在虚拟机的centos下的docker启动了服务集群,用外部浏览器访问报500错误

在虚拟机的centos下的docker启动了服务集群,用外部浏览器访问报500错误,报错内容是:


08-11 04:12:46:843 ERROR 1 --- [nio-8081-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.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
userservice_1_c0b0089c19e5 | ### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
userservice_1_c0b0089c19e5 | 
userservice_1_c0b0089c19e5 | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
userservice_1_c0b0089c19e5 | ### The error may exist in cn/itcast/user/mapper/UserMapper.java (best guess)
userservice_1_c0b0089c19e5 | ### The error may involve cn.itcast.user.mapper.UserMapper.findById
userservice_1_c0b0089c19e5 | ### The error occurred while executing a query
userservice_1_c0b0089c19e5 | ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
userservice_1_c0b0089c19e5 | 
userservice_1_c0b0089c19e5 | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.] with root cause
userservice_1_c0b0089c19e5 | 
userservice_1_c0b0089c19e5 | java.net.UnknownHostException: mysql: Name does not resolve
userservice_1_c0b0089c19e5 |    at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:929) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1324) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at java.net.InetAddress.getAllByName0(InetAddress.java:1277) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at java.net.InetAddress.getAllByName(InetAddress.java:1193) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at java.net.InetAddress.getAllByName(InetAddress.java:1127) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:130) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
userservice_1_c0b0089c19e5 |    at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
userservice_1_c0b0089c19e5 |    at com.mysql.cj.NativeSession.connect(NativeSession.java:121) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
userservice_1_c0b0089c19e5 |    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:945) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
userservice_1_c0b0089c19e5 |    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:815) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
userservice_1_c0b0089c19e5 |    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
userservice_1_c0b0089c19e5 |    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
userservice_1_c0b0089c19e5 |    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
userservice_1_c0b0089c19e5 |    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-3.4.5.jar!/:na]
userservice_1_c0b0089c19e5 |    at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[HikariCP-3.4.5.jar!/:na]
userservice_1_c0b0089c19e5 |    at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-3.4.5.jar!/:na]
userservice_1_c0b0089c19e5 |    at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) ~[HikariCP-3.4.5.jar!/:na]
userservice_1_c0b0089c19e5 |    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) ~[HikariCP-3.4.5.jar!/:na]
userservice_1_c0b0089c19e5 |    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-3.4.5.jar!/:na]
userservice_1_c0b0089c19e5 |    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-3.4.5.jar!/:na]
userservice_1_c0b0089c19e5 |    at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) ~[mybatis-spring-2.0.3.jar!/:2.0.3]
userservice_1_c0b0089c19e5 |    at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) ~[mybatis-spring-2.0.3.jar!/:2.0.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.3.jar!/:2.0.3]
userservice_1_c0b0089c19e5 |    at com.sun.proxy.$Proxy57.selectOne(Unknown Source) ~[na:na]
userservice_1_c0b0089c19e5 |    at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) ~[mybatis-spring-2.0.3.jar!/:2.0.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93) ~[mybatis-3.5.3.jar!/:3.5.3]
userservice_1_c0b0089c19e5 |    at com.sun.proxy.$Proxy59.findById(Unknown Source) ~[na:na]
userservice_1_c0b0089c19e5 |    at cn.itcast.user.service.UserService.queryById(UserService.java:15) ~[classes!/:1.0]
userservice_1_c0b0089c19e5 |    at cn.itcast.user.web.UserController.queryById(UserController.java:49) ~[classes!/:1.0]
userservice_1_c0b0089c19e5 |    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) ~[tomcat-embed-core-9.0.43.jar!/:4.0.FR]
userservice_1_c0b0089c19e5 |    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.43.jar!/:4.0.FR]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_212]
userservice_1_c0b0089c19e5 |    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.43.jar!/:9.0.43]
userservice_1_c0b0089c19e5 |    at java.lang.Thread.run(Thread.java:748) [na:1.8.0_212]
userservice_1_c0b0089c19e5 | 

请问是什么问题,应该怎么解决

  • 写回答

2条回答 默认 最新

  • 专家-郭老师 Java领域新星创作者 2023-08-11 13:57
    关注

    查看下你的数据库是不是挂了,或者查看下你代码中数据库链接url是不是写的有问题。账号密码是不是对的。如果都不是,那就有可能是你连接池线程不够。快速解决就重启mysql(最后万不得已)

    评论 编辑记录

报告相同问题?

问题事件

  • 创建了问题 8月11日

悬赏问题

  • ¥100 我想找人帮我写Python 的股票分析代码,有意请加mathtao
  • ¥20 Vite 打包的 Vue3 组件库,图标无法显示
  • ¥15 php 同步电商平台多个店铺增量订单和订单状态
  • ¥15 关于logstash转发日志时发生的部分内容丢失问题
  • ¥17 pro*C预编译“闪回查询”报错SCN不能识别
  • ¥15 微信会员卡接入微信支付商户号收款
  • ¥15 如何获取烟草零售终端数据
  • ¥15 数学建模招标中位数问题
  • ¥15 phython路径名过长报错 不知道什么问题
  • ¥15 深度学习中模型转换该怎么实现