2476 lines
224 KiB
Plaintext
2476 lines
224 KiB
Plaintext
|
13:44:05.939 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
|
||
|
|
13:44:06.008 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 9984 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
13:44:06.012 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
13:44:14.292 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
13:44:14.316 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
13:44:15.119 [main] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
13:44:15.155 [main] INFO o.s.b.a.l.ConditionEvaluationReportLogger -
|
||
|
|
|
||
|
|
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
|
||
|
|
13:44:15.191 [main] ERROR o.s.boot.SpringApplication - Application run failed
|
||
|
|
org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:164)
|
||
|
|
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
|
||
|
|
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
|
||
|
|
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:308)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291)
|
||
|
|
at com.bb.ApiServerApplication.main(ApiServerApplication.java:16)
|
||
|
|
Caused by: java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletResponse
|
||
|
|
at com.bb.config.LogConfig.lambda$1(LogConfig.java:24)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.configureContext(TomcatServletWebServerFactory.java:400)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.prepareContext(TomcatServletWebServerFactory.java:258)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:209)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:183)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:161)
|
||
|
|
... 8 common frames omitted
|
||
|
|
Caused by: java.lang.ClassNotFoundException: javax.servlet.http.HttpServletResponse
|
||
|
|
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
|
||
|
|
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
|
||
|
|
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
|
||
|
|
... 14 common frames omitted
|
||
|
|
13:48:08.534 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
|
||
|
|
13:48:08.673 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 6544 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
13:48:08.675 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
13:48:14.978 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
13:48:15.012 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
13:48:15.964 [main] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
13:48:15.988 [main] INFO o.s.b.a.l.ConditionEvaluationReportLogger -
|
||
|
|
|
||
|
|
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
|
||
|
|
13:48:16.022 [main] ERROR o.s.boot.SpringApplication - Application run failed
|
||
|
|
org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:164)
|
||
|
|
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
|
||
|
|
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
|
||
|
|
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:308)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291)
|
||
|
|
at com.bb.ApiServerApplication.main(ApiServerApplication.java:16)
|
||
|
|
Caused by: java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletResponse
|
||
|
|
at com.bb.config.LogConfig.lambda$1(LogConfig.java:24)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.configureContext(TomcatServletWebServerFactory.java:400)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.prepareContext(TomcatServletWebServerFactory.java:258)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:209)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:183)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:161)
|
||
|
|
... 8 common frames omitted
|
||
|
|
Caused by: java.lang.ClassNotFoundException: javax.servlet.http.HttpServletResponse
|
||
|
|
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
|
||
|
|
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
|
||
|
|
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
|
||
|
|
... 14 common frames omitted
|
||
|
|
14:35:42.845 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.1.Final
|
||
|
|
14:35:42.926 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 7008 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
14:35:42.927 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
14:35:48.923 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
14:35:48.973 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
14:35:50.211 [main] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
14:35:50.240 [main] INFO o.s.b.a.l.ConditionEvaluationReportLogger -
|
||
|
|
|
||
|
|
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
|
||
|
|
14:35:50.283 [main] ERROR o.s.boot.SpringApplication - Application run failed
|
||
|
|
org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:164)
|
||
|
|
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:602)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
|
||
|
|
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:737)
|
||
|
|
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1309)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1298)
|
||
|
|
at com.bb.ApiServerApplication.main(ApiServerApplication.java:16)
|
||
|
|
Caused by: java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletResponse
|
||
|
|
at com.bb.config.LogConfig.lambda$1(LogConfig.java:24)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.configureContext(TomcatServletWebServerFactory.java:403)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.prepareContext(TomcatServletWebServerFactory.java:259)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:210)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:183)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:161)
|
||
|
|
... 8 common frames omitted
|
||
|
|
Caused by: java.lang.ClassNotFoundException: javax.servlet.http.HttpServletResponse
|
||
|
|
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
|
||
|
|
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
|
||
|
|
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
|
||
|
|
... 14 common frames omitted
|
||
|
|
14:44:51.378 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
|
||
|
|
14:44:51.529 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 4132 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
14:44:51.530 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
14:44:57.278 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
14:44:57.304 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
14:44:58.138 [main] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
14:44:58.163 [main] INFO o.s.b.a.l.ConditionEvaluationReportLogger -
|
||
|
|
|
||
|
|
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
|
||
|
|
14:44:58.195 [main] ERROR o.s.boot.SpringApplication - Application run failed
|
||
|
|
org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:164)
|
||
|
|
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
|
||
|
|
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
|
||
|
|
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:308)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291)
|
||
|
|
at com.bb.ApiServerApplication.main(ApiServerApplication.java:16)
|
||
|
|
Caused by: java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletResponse
|
||
|
|
at com.bb.config.LogConfig.lambda$1(LogConfig.java:24)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.configureContext(TomcatServletWebServerFactory.java:400)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.prepareContext(TomcatServletWebServerFactory.java:258)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:209)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:183)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:161)
|
||
|
|
... 8 common frames omitted
|
||
|
|
Caused by: java.lang.ClassNotFoundException: javax.servlet.http.HttpServletResponse
|
||
|
|
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
|
||
|
|
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
|
||
|
|
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
|
||
|
|
... 14 common frames omitted
|
||
|
|
14:57:43.280 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
|
||
|
|
14:57:43.378 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 1924 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
14:57:43.379 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
14:57:45.932 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
14:57:45.960 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
14:57:46.845 [main] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
14:57:46.869 [main] INFO o.s.b.a.l.ConditionEvaluationReportLogger -
|
||
|
|
|
||
|
|
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
|
||
|
|
14:57:46.901 [main] ERROR o.s.boot.SpringApplication - Application run failed
|
||
|
|
org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:164)
|
||
|
|
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
|
||
|
|
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
|
||
|
|
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:308)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291)
|
||
|
|
at com.bb.ApiServerApplication.main(ApiServerApplication.java:16)
|
||
|
|
Caused by: java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletResponse
|
||
|
|
at com.bb.config.LogConfig.lambda$embeddedServletContainerCustomizer$0(LogConfig.java:24)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.configureContext(TomcatServletWebServerFactory.java:400)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.prepareContext(TomcatServletWebServerFactory.java:258)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:209)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:183)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:161)
|
||
|
|
... 8 common frames omitted
|
||
|
|
Caused by: java.lang.ClassNotFoundException: javax.servlet.http.HttpServletResponse
|
||
|
|
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
|
||
|
|
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
|
||
|
|
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
|
||
|
|
... 14 common frames omitted
|
||
|
|
15:01:56.546 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
|
||
|
|
15:01:56.651 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 5828 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
15:01:56.653 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
15:01:59.891 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
15:01:59.922 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
15:02:00.898 [main] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
15:02:00.926 [main] INFO o.s.b.a.l.ConditionEvaluationReportLogger -
|
||
|
|
|
||
|
|
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
|
||
|
|
15:02:00.967 [main] ERROR o.s.boot.SpringApplication - Application run failed
|
||
|
|
org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:164)
|
||
|
|
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
|
||
|
|
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
|
||
|
|
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:308)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302)
|
||
|
|
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291)
|
||
|
|
at com.bb.ApiServerApplication.main(ApiServerApplication.java:16)
|
||
|
|
Caused by: java.lang.NoClassDefFoundError: javax/servlet/http/HttpServletResponse
|
||
|
|
at com.bb.config.LogConfig.lambda$embeddedServletContainerCustomizer$0(LogConfig.java:24)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.configureContext(TomcatServletWebServerFactory.java:400)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.prepareContext(TomcatServletWebServerFactory.java:258)
|
||
|
|
at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:209)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:183)
|
||
|
|
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:161)
|
||
|
|
... 8 common frames omitted
|
||
|
|
Caused by: java.lang.ClassNotFoundException: javax.servlet.http.HttpServletResponse
|
||
|
|
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
|
||
|
|
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
|
||
|
|
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
|
||
|
|
... 14 common frames omitted
|
||
|
|
15:04:00.452 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
|
||
|
|
15:04:00.576 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 8328 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
15:04:00.578 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
15:04:08.763 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
15:04:08.789 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
15:04:09.636 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat initialized with port(s): 80 (http)
|
||
|
|
15:04:09.652 [main] INFO o.a.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-80"]
|
||
|
|
15:04:09.654 [main] INFO o.a.catalina.core.StandardService - Starting service [Tomcat]
|
||
|
|
15:04:09.655 [main] INFO o.a.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/10.1.1]
|
||
|
|
15:04:09.845 [main] INFO o.a.c.c.C.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
|
||
|
|
15:04:09.846 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 8245 ms
|
||
|
|
15:04:11.929 [main] ERROR o.s.b.w.e.tomcat.TomcatStarter - Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name 'securityConfig': Unsatisfied dependency expressed through field 'authProvider': Error creating bean with name 'authProvider': Unsatisfied dependency expressed through field 'passwordEncoder': Error creating bean with name 'securityConfig': Requested bean is currently in creation: Is there an unresolvable circular reference?
|
||
|
|
15:04:11.974 [main] INFO o.a.catalina.core.StandardService - Stopping service [Tomcat]
|
||
|
|
15:04:11.983 [main] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server
|
||
|
|
15:04:12.013 [main] INFO o.s.b.a.l.ConditionEvaluationReportLogger -
|
||
|
|
|
||
|
|
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
|
||
|
|
15:04:12.043 [main] ERROR o.s.b.d.LoggingFailureAnalysisReporter -
|
||
|
|
|
||
|
|
***************************
|
||
|
|
APPLICATION FAILED TO START
|
||
|
|
***************************
|
||
|
|
|
||
|
|
Description:
|
||
|
|
|
||
|
|
The dependencies of some of the beans in the application context form a cycle:
|
||
|
|
|
||
|
|
┌─────┐
|
||
|
|
| securityConfig (field com.bb.config.AuthProvider com.bb.config.SecurityConfig.authProvider)
|
||
|
|
↑ ↓
|
||
|
|
| authProvider (field private org.springframework.security.crypto.password.PasswordEncoder com.bb.config.AuthProvider.passwordEncoder)
|
||
|
|
└─────┘
|
||
|
|
|
||
|
|
|
||
|
|
Action:
|
||
|
|
|
||
|
|
Relying upon circular references is discouraged and they are prohibited by default. Update your application to remove the dependency cycle between beans. As a last resort, it may be possible to break the cycle automatically by setting spring.main.allow-circular-references to true.
|
||
|
|
|
||
|
|
15:07:27.903 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
|
||
|
|
15:07:28.002 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 9496 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
15:07:28.005 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
15:07:30.667 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
15:07:30.692 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
15:07:31.499 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat initialized with port(s): 80 (http)
|
||
|
|
15:07:31.515 [main] INFO o.a.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-80"]
|
||
|
|
15:07:31.517 [main] INFO o.a.catalina.core.StandardService - Starting service [Tomcat]
|
||
|
|
15:07:31.517 [main] INFO o.a.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/10.1.1]
|
||
|
|
15:07:31.717 [main] INFO o.a.c.c.C.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
|
||
|
|
15:07:31.717 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3233 ms
|
||
|
|
15:07:33.627 [main] INFO o.s.b.web.servlet.RegistrationBean - Filter apiKeyFilter was not registered (possibly already registered?)
|
||
|
|
15:07:36.212 [main] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
|
||
|
|
15:07:36.354 [main] INFO o.s.s.web.DefaultSecurityFilterChain - Will secure any request with [org.springframework.security.web.session.DisableEncodeUrlFilter@748aa7dc, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@31e84f10, org.springframework.security.web.context.SecurityContextHolderFilter@606f0f70, org.springframework.security.web.header.HeaderWriterFilter@2f8ab988, org.springframework.web.filter.CorsFilter@c4455b4, org.springframework.security.web.authentication.logout.LogoutFilter@1bd6638, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@1d4531fa, org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter@2d2afc39, org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter@747f0f34, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@7fdf7359, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@4a36a35d, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@556ae220, org.springframework.security.web.access.ExceptionTranslationFilter@60251ddb, org.springframework.security.web.access.intercept.AuthorizationFilter@7e36d508]
|
||
|
|
15:07:37.452 [main] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
|
||
|
|
15:07:37.453 [main] INFO o.s.i.c.PublishSubscribeChannel - Channel 'application.errorChannel' has 1 subscriber(s).
|
||
|
|
15:07:37.454 [main] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
|
||
|
|
15:07:37.454 [main] INFO o.a.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-80"]
|
||
|
|
15:07:37.496 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat started on port(s): 80 (http) with context path ''
|
||
|
|
15:07:37.500 [main] INFO o.s.m.s.b.SimpleBrokerMessageHandler - Starting...
|
||
|
|
15:07:37.501 [main] INFO o.s.m.s.b.SimpleBrokerMessageHandler - BrokerAvailabilityEvent[available=true, SimpleBrokerMessageHandler [org.springframework.messaging.simp.broker.DefaultSubscriptionRegistry@4a6d6308]]
|
||
|
|
15:07:37.501 [main] INFO o.s.m.s.b.SimpleBrokerMessageHandler - Started.
|
||
|
|
15:07:37.526 [my-scheduler-task-pool-3] INFO com.bb.service.CommonServiceImpl - ##- [OMS BATCH_REPORT STATUS] HostName: DESKTOP-2T3170R, HostAddress: 167.179.119.96
|
||
|
|
15:07:37.527 [my-scheduler-task-pool-1] INFO com.bb.service.CommonServiceImpl - ##- [OMS BATCH_INSURED_REPORT STATUS] HostName: DESKTOP-2T3170R, HostAddress: 167.179.119.96
|
||
|
|
15:07:37.528 [my-scheduler-task-pool-4] INFO com.bb.service.CommonServiceImpl - ##- [OMS BATCH_CREDIT_REPORT STATUS] HostName: DESKTOP-2T3170R, HostAddress: 167.179.119.96
|
||
|
|
15:07:37.555 [my-scheduler-task-pool-2] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:07:37.563 [main] INFO com.bb.ApiServerApplication - Started ApiServerApplication in 10.513 seconds (process running for 11.904)
|
||
|
|
15:07:38.172 [RMI TCP Connection(9)-127.0.0.1] INFO o.a.c.c.C.[Tomcat].[localhost].[/] - Initializing Spring DispatcherServlet 'dispatcherServlet'
|
||
|
|
15:07:38.173 [RMI TCP Connection(9)-127.0.0.1] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
|
||
|
|
15:07:38.176 [RMI TCP Connection(9)-127.0.0.1] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 3 ms
|
||
|
|
15:07:42.043 [RMI TCP Connection(7)-127.0.0.1] INFO o.s.b.a.SpringApplicationAdminMXBeanRegistrar$SpringApplicationAdmin - Application shutdown requested.
|
||
|
|
15:07:42.048 [RMI TCP Connection(7)-127.0.0.1] INFO o.s.m.s.b.SimpleBrokerMessageHandler - Stopping...
|
||
|
|
15:07:42.049 [RMI TCP Connection(7)-127.0.0.1] INFO o.s.m.s.b.SimpleBrokerMessageHandler - BrokerAvailabilityEvent[available=false, SimpleBrokerMessageHandler [org.springframework.messaging.simp.broker.DefaultSubscriptionRegistry@4a6d6308]]
|
||
|
|
15:07:42.049 [RMI TCP Connection(7)-127.0.0.1] INFO o.s.m.s.b.SimpleBrokerMessageHandler - Stopped.
|
||
|
|
15:07:42.079 [RMI TCP Connection(7)-127.0.0.1] INFO o.a.coyote.http11.Http11NioProtocol - Pausing ProtocolHandler ["http-nio-80"]
|
||
|
|
15:07:42.079 [RMI TCP Connection(7)-127.0.0.1] INFO o.a.catalina.core.StandardService - Stopping service [Tomcat]
|
||
|
|
15:07:42.083 [RMI TCP Connection(7)-127.0.0.1] INFO o.a.c.c.C.[Tomcat].[localhost].[/] - Destroying Spring FrameworkServlet 'dispatcherServlet'
|
||
|
|
15:07:42.089 [RMI TCP Connection(7)-127.0.0.1] INFO o.a.coyote.http11.Http11NioProtocol - Stopping ProtocolHandler ["http-nio-80"]
|
||
|
|
15:07:42.095 [RMI TCP Connection(7)-127.0.0.1] INFO o.a.coyote.http11.Http11NioProtocol - Destroying ProtocolHandler ["http-nio-80"]
|
||
|
|
15:07:42.096 [RMI TCP Connection(7)-127.0.0.1] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
|
||
|
|
15:07:42.097 [RMI TCP Connection(7)-127.0.0.1] INFO o.s.i.c.PublishSubscribeChannel - Channel 'application.errorChannel' has 0 subscriber(s).
|
||
|
|
15:07:42.098 [RMI TCP Connection(7)-127.0.0.1] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
|
||
|
|
15:07:42.123 [my-scheduler-task-pool-2] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CashCronController.cashProc(CashCronController.java:50)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:07:42.131 [my-scheduler-task-pool-5] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:07:42.142 [my-scheduler-task-pool-2] ERROR c.bb.controller.CashCronController - #-cashProc::Exception::org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:07:45.163 [my-scheduler-task-pool-5] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.creditBetProc(CreditCronController.java:67)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:07:45.166 [my-scheduler-task-pool-3] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:07:45.167 [my-scheduler-task-pool-5] ERROR c.bb.controller.CreditCronController - #-creditBetProc::ERROR::org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:07:48.176 [my-scheduler-task-pool-3] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.batchReport(CommonServiceImpl.java:80)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 61 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 63 common frames omitted
|
||
|
|
15:07:48.179 [my-scheduler-task-pool-3] ERROR com.bb.service.CommonServiceImpl - org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:07:48.178 [my-scheduler-task-pool-4] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:07:51.197 [my-scheduler-task-pool-4] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.creditReport(CommonServiceImpl.java:286)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 61 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 63 common frames omitted
|
||
|
|
15:07:51.200 [my-scheduler-task-pool-1] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:07:51.200 [my-scheduler-task-pool-4] ERROR com.bb.service.CommonServiceImpl - org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:07:54.210 [my-scheduler-task-pool-1] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.insuredReport(CommonServiceImpl.java:370)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 61 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 63 common frames omitted
|
||
|
|
15:07:54.212 [my-scheduler-task-pool-1] ERROR com.bb.service.CommonServiceImpl - org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:11:04.365 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
|
||
|
|
15:11:04.428 [main] INFO com.bb.ApiServerApplication - Starting ApiServerApplication using Java 17.0.5 with PID 7456 (C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes started by shandi in C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms)
|
||
|
|
15:11:04.430 [main] INFO com.bb.ApiServerApplication - The following 1 profile is active: "local"
|
||
|
|
15:11:07.453 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
|
||
|
|
15:11:07.483 [main] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
|
||
|
|
15:11:08.322 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat initialized with port(s): 80 (http)
|
||
|
|
15:11:08.336 [main] INFO o.a.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-80"]
|
||
|
|
15:11:08.338 [main] INFO o.a.catalina.core.StandardService - Starting service [Tomcat]
|
||
|
|
15:11:08.339 [main] INFO o.a.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/10.1.1]
|
||
|
|
15:11:08.524 [main] INFO o.a.c.c.C.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
|
||
|
|
15:11:08.525 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3434 ms
|
||
|
|
15:11:10.322 [main] INFO o.s.b.web.servlet.RegistrationBean - Filter apiKeyFilter was not registered (possibly already registered?)
|
||
|
|
15:11:13.035 [main] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
|
||
|
|
15:11:13.178 [main] INFO o.s.s.web.DefaultSecurityFilterChain - Will secure any request with [org.springframework.security.web.session.DisableEncodeUrlFilter@63e0057a, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@5b76b891, org.springframework.security.web.context.SecurityContextHolderFilter@14b4d90b, org.springframework.security.web.header.HeaderWriterFilter@6c537267, org.springframework.web.filter.CorsFilter@611a91df, org.springframework.security.web.authentication.logout.LogoutFilter@1a45e29f, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@10466c55, org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter@37a939bc, org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter@47f5ab58, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@7962c1d5, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@56226064, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@245dbd09, org.springframework.security.web.access.ExceptionTranslationFilter@1f2497d9, org.springframework.security.web.access.intercept.AuthorizationFilter@10e4ce98]
|
||
|
|
15:11:14.394 [main] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
|
||
|
|
15:11:14.396 [main] INFO o.s.i.c.PublishSubscribeChannel - Channel 'application.errorChannel' has 1 subscriber(s).
|
||
|
|
15:11:14.398 [main] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
|
||
|
|
15:11:14.399 [main] INFO o.a.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-80"]
|
||
|
|
15:11:14.445 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat started on port(s): 80 (http) with context path ''
|
||
|
|
15:11:14.449 [main] INFO o.s.m.s.b.SimpleBrokerMessageHandler - Starting...
|
||
|
|
15:11:14.450 [main] INFO o.s.m.s.b.SimpleBrokerMessageHandler - BrokerAvailabilityEvent[available=true, SimpleBrokerMessageHandler [org.springframework.messaging.simp.broker.DefaultSubscriptionRegistry@4b20a8e4]]
|
||
|
|
15:11:14.451 [main] INFO o.s.m.s.b.SimpleBrokerMessageHandler - Started.
|
||
|
|
15:11:14.478 [my-scheduler-task-pool-3] INFO com.bb.service.CommonServiceImpl - ##- [OMS BATCH_REPORT STATUS] HostName: DESKTOP-2T3170R, HostAddress: 167.179.119.96
|
||
|
|
15:11:14.479 [my-scheduler-task-pool-1] INFO com.bb.service.CommonServiceImpl - ##- [OMS BATCH_INSURED_REPORT STATUS] HostName: DESKTOP-2T3170R, HostAddress: 167.179.119.96
|
||
|
|
15:11:14.480 [my-scheduler-task-pool-4] INFO com.bb.service.CommonServiceImpl - ##- [OMS BATCH_CREDIT_REPORT STATUS] HostName: DESKTOP-2T3170R, HostAddress: 167.179.119.96
|
||
|
|
15:11:14.511 [my-scheduler-task-pool-4] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:14.520 [main] INFO com.bb.ApiServerApplication - Started ApiServerApplication in 11.037 seconds (process running for 12.688)
|
||
|
|
15:11:15.151 [RMI TCP Connection(9)-127.0.0.1] INFO o.a.c.c.C.[Tomcat].[localhost].[/] - Initializing Spring DispatcherServlet 'dispatcherServlet'
|
||
|
|
15:11:15.152 [RMI TCP Connection(9)-127.0.0.1] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
|
||
|
|
15:11:15.155 [RMI TCP Connection(9)-127.0.0.1] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 2 ms
|
||
|
|
15:11:19.697 [my-scheduler-task-pool-4] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.creditReport(CommonServiceImpl.java:286)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 61 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 63 common frames omitted
|
||
|
|
15:11:19.706 [my-scheduler-task-pool-2] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:19.719 [my-scheduler-task-pool-4] ERROR com.bb.service.CommonServiceImpl - org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:11:24.727 [my-scheduler-task-pool-2] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CashCronController.cashProc(CashCronController.java:50)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:11:24.730 [my-scheduler-task-pool-3] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:24.731 [my-scheduler-task-pool-2] ERROR c.bb.controller.CashCronController - #-cashProc::Exception::org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:11:29.778 [my-scheduler-task-pool-3] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.batchReport(CommonServiceImpl.java:80)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 61 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 63 common frames omitted
|
||
|
|
15:11:29.781 [my-scheduler-task-pool-5] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:29.781 [my-scheduler-task-pool-3] ERROR com.bb.service.CommonServiceImpl - org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:11:34.845 [my-scheduler-task-pool-5] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.creditBetProc(CreditCronController.java:67)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:11:34.848 [my-scheduler-task-pool-1] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:34.849 [my-scheduler-task-pool-5] ERROR c.bb.controller.CreditCronController - #-creditBetProc::ERROR::org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:11:39.912 [my-scheduler-task-pool-1] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.insuredReport(CommonServiceImpl.java:370)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 61 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 63 common frames omitted
|
||
|
|
15:11:39.915 [my-scheduler-task-pool-1] ERROR com.bb.service.CommonServiceImpl - org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:11:39.914 [my-scheduler-task-pool-5] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:44.930 [my-scheduler-task-pool-5] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_lion01(CreditCronController.java:716)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:11:44.932 [my-scheduler-task-pool-3] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:44.933 [my-scheduler-task-pool-5] ERROR c.bb.controller.CreditCronController - ##creditBetProc::lion01::- credit_lion01() => PT_BI_ERROR
|
||
|
|
15:11:44.935 [my-scheduler-task-pool-5] ERROR c.bb.controller.CreditCronController - ##creditBetProc::lion01org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:11:49.981 [my-scheduler-task-pool-3] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_dubai01(CreditCronController.java:542)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:11:49.983 [my-scheduler-task-pool-2] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:49.984 [my-scheduler-task-pool-3] ERROR c.bb.controller.CreditCronController - ##creditBetProc::dubai01::- credit_dubai01() => PT_BI_ERROR
|
||
|
|
15:11:49.984 [my-scheduler-task-pool-3] ERROR c.bb.controller.CreditCronController - ##creditBetProc::dubai01org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:11:55.022 [my-scheduler-task-pool-2] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_sclass01(CreditCronController.java:687)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:11:55.024 [my-scheduler-task-pool-4] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:11:55.024 [my-scheduler-task-pool-2] ERROR c.bb.controller.CreditCronController - ##creditBetProc::sclass01::- credit_sclass01() => PT_BI_ERROR
|
||
|
|
15:11:55.025 [my-scheduler-task-pool-2] ERROR c.bb.controller.CreditCronController - ##creditBetProc::sclass01org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:12:00.122 [my-scheduler-task-pool-4] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_vegas01(CreditCronController.java:455)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:12:00.124 [my-scheduler-task-pool-2] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:12:00.124 [my-scheduler-task-pool-4] ERROR c.bb.controller.CreditCronController - ##creditBetProc::vegas01::- credit_vegas01() => PT_BI_ERROR
|
||
|
|
15:12:00.124 [my-scheduler-task-pool-4] ERROR c.bb.controller.CreditCronController - ##creditBetProc::vegas01org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:12:05.171 [my-scheduler-task-pool-2] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_coco011(CreditCronController.java:513)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:12:05.173 [my-scheduler-task-pool-3] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:12:05.173 [my-scheduler-task-pool-2] ERROR c.bb.controller.CreditCronController - ##creditBetProc::coco011::- credit_coco011() => PT_BI_ERROR
|
||
|
|
15:12:05.174 [my-scheduler-task-pool-2] ERROR c.bb.controller.CreditCronController - ##creditBetProc::coco011org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:12:10.278 [my-scheduler-task-pool-3] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_theking01(CreditCronController.java:484)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:12:10.282 [my-scheduler-task-pool-5] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:12:10.283 [my-scheduler-task-pool-3] ERROR c.bb.controller.CreditCronController - ##creditBetProc::theking01::- credit_theking01() => PT_BI_ERROR
|
||
|
|
15:12:10.286 [my-scheduler-task-pool-3] ERROR c.bb.controller.CreditCronController - ##creditBetProc::theking01org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:12:13.041 [RMI TCP Connection(10)-127.0.0.1] INFO o.s.b.a.SpringApplicationAdminMXBeanRegistrar$SpringApplicationAdmin - Application shutdown requested.
|
||
|
|
15:12:13.058 [RMI TCP Connection(10)-127.0.0.1] INFO o.s.m.s.b.SimpleBrokerMessageHandler - Stopping...
|
||
|
|
15:12:13.059 [RMI TCP Connection(10)-127.0.0.1] INFO o.s.m.s.b.SimpleBrokerMessageHandler - BrokerAvailabilityEvent[available=false, SimpleBrokerMessageHandler [org.springframework.messaging.simp.broker.DefaultSubscriptionRegistry@4b20a8e4]]
|
||
|
|
15:12:13.059 [RMI TCP Connection(10)-127.0.0.1] INFO o.s.m.s.b.SimpleBrokerMessageHandler - Stopped.
|
||
|
|
15:12:13.074 [RMI TCP Connection(10)-127.0.0.1] INFO o.a.coyote.http11.Http11NioProtocol - Pausing ProtocolHandler ["http-nio-80"]
|
||
|
|
15:12:13.075 [RMI TCP Connection(10)-127.0.0.1] INFO o.a.catalina.core.StandardService - Stopping service [Tomcat]
|
||
|
|
15:12:13.079 [RMI TCP Connection(10)-127.0.0.1] INFO o.a.c.c.C.[Tomcat].[localhost].[/] - Destroying Spring FrameworkServlet 'dispatcherServlet'
|
||
|
|
15:12:13.106 [RMI TCP Connection(10)-127.0.0.1] INFO o.a.coyote.http11.Http11NioProtocol - Stopping ProtocolHandler ["http-nio-80"]
|
||
|
|
15:12:13.112 [RMI TCP Connection(10)-127.0.0.1] INFO o.a.coyote.http11.Http11NioProtocol - Destroying ProtocolHandler ["http-nio-80"]
|
||
|
|
15:12:13.114 [RMI TCP Connection(10)-127.0.0.1] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
|
||
|
|
15:12:13.114 [RMI TCP Connection(10)-127.0.0.1] INFO o.s.i.c.PublishSubscribeChannel - Channel 'application.errorChannel' has 0 subscriber(s).
|
||
|
|
15:12:13.116 [RMI TCP Connection(10)-127.0.0.1] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
|
||
|
|
15:12:13.156 [my-scheduler-task-pool-5] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_mario01(CreditCronController.java:629)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:12:13.158 [my-scheduler-task-pool-1] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:12:13.159 [my-scheduler-task-pool-5] ERROR c.bb.controller.CreditCronController - ##creditBetProc::mario01::- credit_mario01() => PT_BI_ERROR
|
||
|
|
15:12:13.161 [my-scheduler-task-pool-5] ERROR c.bb.controller.CreditCronController - ##creditBetProc::mario01org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:12:16.175 [my-scheduler-task-pool-1] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_salt01(CreditCronController.java:600)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:12:16.178 [my-scheduler-task-pool-3] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:12:16.179 [my-scheduler-task-pool-1] ERROR c.bb.controller.CreditCronController - ##creditBetProc::salt01::- credit_salt01() => PT_BI_ERROR
|
||
|
|
15:12:16.180 [my-scheduler-task-pool-1] ERROR c.bb.controller.CreditCronController - ##creditBetProc::salt01org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:12:19.188 [my-scheduler-task-pool-3] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_mvp001(CreditCronController.java:891)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:12:19.191 [my-scheduler-task-pool-2] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:12:19.191 [my-scheduler-task-pool-3] ERROR c.bb.controller.CreditCronController - ##creditBetProc::mvp001::- credit_mvp001() => PT_BI_ERROR
|
||
|
|
15:12:19.193 [my-scheduler-task-pool-3] ERROR c.bb.controller.CreditCronController - ##creditBetProc::mvp001org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:12:22.220 [my-scheduler-task-pool-2] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_pocari(CreditCronController.java:658)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:12:22.223 [my-scheduler-task-pool-2] ERROR c.bb.controller.CreditCronController - ##creditBetProc::pocari::- credit_pocari() => PT_BI_ERROR
|
||
|
|
15:12:22.223 [my-scheduler-task-pool-4] INFO com.zaxxer.hikari.HikariDataSource - hikari-cp - Starting...
|
||
|
|
15:12:22.224 [my-scheduler-task-pool-2] ERROR c.bb.controller.CreditCronController - ##creditBetProc::pocariorg.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
15:12:25.273 [my-scheduler-task-pool-4] ERROR com.zaxxer.hikari.pool.HikariPool - hikari-cp - Exception during pool initialization.
|
||
|
|
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:111)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
||
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:895)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:820)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
|
||
|
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
|
||
|
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
|
||
|
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
|
||
|
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
|
||
|
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
|
||
|
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:77)
|
||
|
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)
|
||
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
||
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
||
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
||
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
|
||
|
|
at jdk.proxy2/jdk.proxy2.$Proxy78.selectOne(Unknown Source)
|
||
|
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
|
||
|
|
at com.bb.dao.CommonDaoImpl.getServerCronStatus(CommonDaoImpl.java:533)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
|
||
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752)
|
||
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
|
||
|
|
at com.bb.dao.CommonDaoImpl$$SpringCGLIB$$0.getServerCronStatus(<generated>)
|
||
|
|
at com.bb.service.CommonServiceImpl.getServerCronStatus(CommonServiceImpl.java:834)
|
||
|
|
at com.bb.controller.CreditCronController.credit_tiger011(CreditCronController.java:571)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
||
|
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
||
|
|
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
|
||
|
|
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
|
||
|
|
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
|
||
|
|
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
|
||
|
|
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
|
||
|
|
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
|
||
|
|
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
|
||
|
|
at java.base/java.lang.Thread.run(Thread.java:833)
|
||
|
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
||
|
|
|
||
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
||
|
|
at jdk.internal.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
|
||
|
|
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
|
||
|
|
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
|
||
|
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
|
||
|
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:121)
|
||
|
|
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:839)
|
||
|
|
... 62 common frames omitted
|
||
|
|
Caused by: java.net.ConnectException: Connection refused: no further information
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
|
||
|
|
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
|
||
|
|
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
|
||
|
|
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
|
||
|
|
at java.base/java.net.Socket.connect(Socket.java:633)
|
||
|
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
|
||
|
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
|
||
|
|
... 64 common frames omitted
|
||
|
|
15:12:25.276 [my-scheduler-task-pool-4] ERROR c.bb.controller.CreditCronController - ##creditBetProc::tiger011::- credit_tiger011() => PT_BI_ERROR
|
||
|
|
15:12:25.277 [my-scheduler-task-pool-4] ERROR c.bb.controller.CreditCronController - ##creditBetProc::tiger011org.mybatis.spring.MyBatisSystemException:
|
||
|
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|
||
|
|
### The error may exist in file [C:\Users\shandi\Documents\workspace-spring-tool-suite-4-4.17.1.RELEASE\new_apiServer_oms\target\classes\db1\CODE.xml]
|
||
|
|
### The error may involve com.bb.dao.CommonDao.getServerCronStatus
|
||
|
|
### The error occurred while executing a query
|
||
|
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
|