连接mysql服务器报错，fail to create conn because of timeout: 30000 , url:jdbc:mysql://xx.xxx.xxx.xx:xxxx/
本人排查，驱动没问题上传到 同Mysql数据库版本一致的8019、永洪服务器与Mysql数据库服务器telnet能连通，防火墙已关，但是还连不上
日志
- [2023-01-11 10:56:42.229] |-[ERROR] |-[cdb7ba4038394e4baa01697df4dbdd99] |-[admin] |-[g5.sv.qry.QueryProc.procReq(QueryProc.java:197)] |-[QUERY: [xxxx20230111105334-13014<___CONNECTION___/xxx/xxxx>][ErrCode: 8192] fail to create conn because of timeout: 30000 , url:jdbc:mysql://xx.xxx.xxx.xx:xxxx/]
- g5.util.GRTException: fail to create conn because of timeout: 30000 , url:jdbc:mysql://xx.xxx.xxx.xx:xxxx/
- at g5.sv.qry.req.TestQryReq.process0(TestQryReq.java:162) ~[product-20220823.jar:?]
- at g5.sv.Req.process(Req.java:41) ~[product-20220823.jar:?]
- at g5.sv.qry.impl.QueryServiceImpl.process(QueryServiceImpl.java:181) ~[product-20220823.jar:?]
- at g5.sv.qry.QueryProc.procReq(QueryProc.java:141) [product-20220823.jar:?]
- at g5.sv.qry.QueryProc.service(QueryProc.java:61) [product-20220823.jar:?]
- at g5.sv.ServletHelper.service(ServletHelper.java:101) [product-20220823.jar:?]
- at g5.sv.PortalServlet.service(PortalServlet.java:536) [product-20220823.jar:?]
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:4.0.FR]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:9.0.37]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
- at g5.sv.standardsso.SSOLoginFilter.doFilter(SSOLoginFilter.java:117) [product-20220823.jar:?]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
- at com.yonghongtech.filter.PortalLoginFilter.doFilter(PortalLoginFilter.java:34) [PortalLogin.jar:?]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.37]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.37]
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.37]
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:666) [catalina.jar:9.0.37]
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.37]
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.37]
- at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:9.0.37]
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.37]
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.37]
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote.jar:9.0.37]
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.37]
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.37]
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote.jar:9.0.37]
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.37]
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.37]
- at java.lang.Thread.run(Thread.java:834) [?:?]
- [2023-01-11 10:56:48.233] |-[INFO] |-[df21c86198fb4eeda3a69050345b3cce] |-[SYSTEM] |-[g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:105)] |-[OTHER: Succeed to get connection, classloader: Def Class loader.]
- [2023-01-11 10:56:48.405] |-[INFO] |-[d65063ce0df6424481055d799b279dae] |-[SYSTEM] |-[g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:105)] |-[OTHER: Succeed to get connection, classloader: Def Class loader.]
- [2023-01-11 10:56:48.406] |-[INFO] |-[f6740e2a5d8f4194866de0075a96cb21] |-[SYSTEM] |-[g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:105)] |-[OTHER: Succeed to get connection, classloader: Def Class loader.]
- [2023-01-11 10:56:49.465] |-[INFO] |-[475ca99daaf642e4a778fc0bef5da745] |-[SYSTEM] |-[g5.sched.SchedulerEngine.updateJobs(SchedulerEngine.java:943)] |-[OTHER: Start to sync/update job status.]
- [2023-01-11 10:56:49.554] |-[INFO] |-[043d251724f74cbe9a0c3248f9e59b6c] |-[SYSTEM] |-[g5.sched.SchedulerEngine.updateJobs(SchedulerEngine.java:1092)] |-[OTHER: Begin to process reboot error.]
- [2023-01-11 10:56:49.555] |-[INFO] |-[7b3a8b4e488842f8941b9f11cc08193f] |-[SYSTEM] |-[g5.sched.SchedulerEngine.updateJobs(SchedulerEngine.java:1122)] |-[OTHER: End of sync/update job status.]
- [2023-01-11 10:56:51.199] |-[INFO] |-[c177fbf30ccf443eb3ba18a33eaf5b0d] |-[SYSTEM] |-[g5.qry.sql.impl.SQLConnPool.get0(SQLConnPool.java:232)] |-[OTHER: g5.qry.sql.impl.SQLConnPool@225ffcc7 Get one connection 'g5.qry.sql.impl.GConn@2ca06442' url: jdbc:derby:/app/yh904/Yonghong/derby/defAuditDb, Pool size: 30, Pool occupied: 1, cost: 0ms, use conn pool: true]
- [2023-01-11 10:56:51.297] |-[INFO] |-[7a855275947e4422b5d61ce52d8fc0ec] |-[SYSTEM] |-[g5.qry.sql.impl.SQLConnPool.set0(SQLConnPool.java:254)] |-[OTHER: g5.qry.sql.impl.SQLConnPool@225ffcc7 Return back connection 'g5.qry.sql.impl.GConn@2ca06442' url: jdbc:derby:/app/yh904/Yonghong/derby/defAuditDb, Pool size: 30, Pool occupied: 0, cost: 0ms]
|
显示全部楼层
发表于 2023-1-11 11:33:28
