在MySQL中字符串转成时间,29-NOV-12 20:40:25.2 这样的格式如何转?

在MySQL中字符串转成时间,‘29-NOV-12 20:40:25.2’ 这样的格式如何转?用什么函数?

2个回答

PigQuestions
PigQuestions 早试过了,不行。反回的是空
4 年多之前 回复

SELECT STR_TO_DATE('29-NOV-12 20:40:25.2','%d-%M-%y %H:%i:%s')

strutce
丵鹰 回复PigQuestions: 这个我也不知道,等你知道了,来这里回复下,我学习下
4 年多之前 回复
PigQuestions
PigQuestions 不错。但是后面的.2 也就是200毫秒,没有被转换。请教如何转换?
4 年多之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
Exception in thread "Thread-12" java.lang.RuntimeException: java.lang.NullPointerException
第一次着手项目,springboot+mybatis,项目搭建是跟着教程做的。项目搭建好之后项目能正常运行,但是启动后报: Exception in thread "Thread-12" java.lang.RuntimeException: java.lang.NullPointerException at com.mysql.jdbc.JDBC4Connection$1$1.run(JDBC4Connection.java:106) Caused by: java.lang.NullPointerException at com.mysql.jdbc.ConnectionImpl.abortInternal(ConnectionImpl.java:1240) at com.mysql.jdbc.JDBC4Connection$1$1.run(JDBC4Connection.java:104) 启动Console: 2019-08-05 10:29:12.921 INFO 7416 --- [ restartedMain] com.xintujiuzhang.aimanagement.App : Starting App on DESKTOP-J57CTN6 with PID 7416 (D:\JAVA\eclipse\TaxHandwritingRecognition\target\classes started by Administrator in D:\JAVA\eclipse\TaxHandwritingRecognition) 2019-08-05 10:29:12.921 INFO 7416 --- [ restartedMain] com.xintujiuzhang.aimanagement.App : No active profile set, falling back to default profiles: default 2019-08-05 10:29:12.958 INFO 7416 --- [ restartedMain] ConfigServletWebServerApplicationContext : Refreshing org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@6070b0bb: startup date [Mon Aug 05 10:29:12 CST 2019]; root of context hierarchy 2019-08-05 10:29:13.450 INFO 7416 --- [ restartedMain] o.s.b.f.xml.XmlBeanDefinitionReader : Loading XML bean definitions from class path resource [mybatis-config.xml] 2019-08-05 10:29:13.503 INFO 7416 --- [ restartedMain] o.s.b.f.s.DefaultListableBeanFactory : Overriding bean definition for bean 'sqlSessionFactory' with a different definition: replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=app; factoryMethodName=sqlSessionFactoryBean; initMethodName=null; destroyMethodName=(inferred); defined in com.xintujiuzhang.aimanagement.App] with [Generic bean: class [org.mybatis.spring.SqlSessionFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [mybatis-config.xml]] 2019-08-05 10:29:13.599 WARN 7416 --- [ restartedMain] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.xintujiuzhang.aimanagement]' package. Please check your configuration. 2019-08-05 10:29:13.958 INFO 7416 --- [ restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$b535b905] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-08-05 10:29:14.332 INFO 7416 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2019-08-05 10:29:14.348 INFO 7416 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2019-08-05 10:29:14.349 INFO 7416 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet Engine: Apache Tomcat/8.5.28 2019-08-05 10:29:14.355 INFO 7416 --- [ost-startStop-1] o.a.catalina.core.AprLifecycleListener : Loaded APR based Apache Tomcat Native library [1.2.21] using APR version [1.6.5]. 2019-08-05 10:29:14.355 INFO 7416 --- [ost-startStop-1] o.a.catalina.core.AprLifecycleListener : APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. 2019-08-05 10:29:14.355 INFO 7416 --- [ost-startStop-1] o.a.catalina.core.AprLifecycleListener : APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 2019-08-05 10:29:14.357 INFO 7416 --- [ost-startStop-1] o.a.catalina.core.AprLifecycleListener : OpenSSL successfully initialized [OpenSSL 1.1.1a 20 Nov 2018] 2019-08-05 10:29:14.418 INFO 7416 --- [ost-startStop-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2019-08-05 10:29:14.418 INFO 7416 --- [ost-startStop-1] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1462 ms 2019-08-05 10:29:14.514 INFO 7416 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean : Servlet dispatcherServlet mapped to [/] 2019-08-05 10:29:14.517 INFO 7416 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'characterEncodingFilter' to: [/*] 2019-08-05 10:29:14.517 INFO 7416 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'hiddenHttpMethodFilter' to: [/*] 2019-08-05 10:29:14.517 INFO 7416 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'httpPutFormContentFilter' to: [/*] 2019-08-05 10:29:14.517 INFO 7416 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'requestContextFilter' to: [/*] 2019-08-05 10:29:14.631 INFO 7416 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2019-08-05 10:29:19.625 INFO 7416 --- [ restartedMain] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Driver does not support get/set network timeout for connections. (com.mysql.jdbc.JDBC4Connection.getNetworkTimeout()I) 2019-08-05 10:29:19.629 INFO 7416 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2019-08-05 10:29:19.670 INFO 7416 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Building JPA container EntityManagerFactory for persistence unit 'default' 2019-08-05 10:29:19.684 INFO 7416 --- [ restartedMain] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [ name: default ...] 2019-08-05 10:29:19.738 INFO 7416 --- [ restartedMain] org.hibernate.Version : HHH000412: Hibernate Core {5.2.10.Final} 2019-08-05 10:29:19.739 INFO 7416 --- [ restartedMain] org.hibernate.cfg.Environment : HHH000206: hibernate.properties not found 2019-08-05 10:29:19.770 INFO 7416 --- [ restartedMain] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.1.Final} 2019-08-05 10:29:19.874 INFO 7416 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect 2019-08-05 10:29:19.897 INFO 7416 --- [ restartedMain] o.h.e.j.e.i.LobCreatorBuilderImpl : HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4 2019-08-05 10:29:20.037 INFO 7416 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 10:29:20,543 INFO App:32-org.springframework.orm.jpa.JpaTransactionManager 2019-08-05 10:29:20.796 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerAdapter : Looking for @ControllerAdvice: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@6070b0bb: startup date [Mon Aug 05 10:29:12 CST 2019]; root of context hierarchy 2019-08-05 10:29:20.824 WARN 7416 --- [ restartedMain] aWebConfiguration$JpaWebMvcConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning 2019-08-05 10:29:20.846 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/application/handwriting_authorization],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.ApplicationAuthorizationController.joinHWA(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.847 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/application/handwriting_information],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.ApplicationInformationController.joinHWI(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.847 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/log/background_management_login],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.BackgroundManagementLoginController.joinHWI(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.847 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/log/computer_login],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.ComputerLoginController.jumpDEM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.847 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/authority/department_management],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.DepartmentManagementController.jumpDEM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.848 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/authority/dictionary_management],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.DictionaryManagementController.jumpDM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.848 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/equipment/hardware_devices],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.EquipmentManagementController.jumpDM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.848 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/queryGetServerStatusInterface],methods=[GET]}" onto public java.util.Map<java.lang.String, java.lang.Object> com.xintujiuzhang.aimanagement.controller.GetServerStatusInterfaceController.queryGetServerStatus(java.lang.String,java.lang.String) 2019-08-05 10:29:20.848 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/queryHandwritingInterface],methods=[GET]}" onto public java.util.Map<java.lang.String, java.lang.Object> com.xintujiuzhang.aimanagement.controller.HandwritingInterfaceController.queryHandwriting(java.lang.String,java.lang.String,java.lang.Integer,java.util.Date) 2019-08-05 10:29:20.849 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/identity/identity_management],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.IdentityManagementController.jumpDM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.849 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/queryInstallationRequest],methods=[GET]}" onto public java.util.Map<java.lang.String, java.lang.Object> com.xintujiuzhang.aimanagement.controller.InstallationRequestInterfaceController.queryInstallationRequest(java.lang.String,java.lang.String,java.lang.String) 2019-08-05 10:29:20.849 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/queryLicenseInterface],methods=[GET]}" onto public java.util.Map<java.lang.String, java.lang.Object> com.xintujiuzhang.aimanagement.controller.LicenseInterfaceController.queryLicense(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.util.Date) 2019-08-05 10:29:20.851 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.MainController.main(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.851 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/login],methods=[GET]}" onto public org.springframework.web.servlet.ModelAndView com.xintujiuzhang.aimanagement.controller.MainController.login() 2019-08-05 10:29:20.851 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/login],methods=[POST]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.MainController.login(java.lang.String,java.lang.String,java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.851 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/main],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.MainController.jumpmain(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.852 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/authority/menu_management],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.MenuManagementController.jumpMM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.852 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/log/module_browsing],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.ModuleBrowsingController.jumpTM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.852 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/log/module_operation],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.ModuleOperationController.jumpMM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.852 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/deletehandwriting],methods=[POST]}" onto public void com.xintujiuzhang.aimanagement.controller.NotesController.deletehandwriting(java.lang.String) 2019-08-05 10:29:20.852 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/updatehandwriting],methods=[POST]}" onto public void com.xintujiuzhang.aimanagement.controller.NotesController.updatehandwriting(com.xintujiuzhang.aimanagement.pojo.Handwriting) 2019-08-05 10:29:20.852 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/addhandwriting],methods=[POST]}" onto public void com.xintujiuzhang.aimanagement.controller.NotesController.addhandwriting(com.xintujiuzhang.aimanagement.pojo.Handwriting) 2019-08-05 10:29:20.853 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/querynotes],methods=[GET]}" onto public com.xintujiuzhang.aimanagement.pojo.Handwriting com.xintujiuzhang.aimanagement.controller.NotesController.querynotes(java.lang.String) 2019-08-05 10:29:20.853 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/authority/parameter_settings],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.parameterSettingsController.jumpPS(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.853 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/authority/role_authorization],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.RoleAuthorizationController.jumpRA(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.853 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/log/service_call],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.ServiceCallController.jumpRA(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.853 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/authority/task_management],methods=[GET]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.TaskManagementController.jumpTM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.854 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/authority/user_management]}" onto public java.lang.String com.xintujiuzhang.aimanagement.controller.UserController.jnmpUM(java.util.Map<java.lang.String, java.lang.Object>) 2019-08-05 10:29:20.854 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/queryUserInterface],methods=[GET]}" onto public java.util.Map<java.lang.String, java.lang.Object> com.xintujiuzhang.aimanagement.controller.UserInterfaceController.queryLicense(java.lang.String,java.lang.String,java.lang.Integer,java.util.Date) 2019-08-05 10:29:20.854 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/queryVersionCheckingInterface],methods=[GET]}" onto public java.util.Map<java.lang.String, java.lang.Object> com.xintujiuzhang.aimanagement.controller.VersionCheckingInterfaceController.queryVersionChecking(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Integer,java.util.Date) 2019-08-05 10:29:20.854 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/queryVersionupdateInterface],methods=[GET]}" onto public java.util.Map<java.lang.String, java.lang.Object> com.xintujiuzhang.aimanagement.controller.VersionUpdateInterfaceController.queryVersionupdate(java.lang.String,java.lang.String,java.lang.String,java.util.Date) 2019-08-05 10:29:20.857 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/error]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController.error(javax.servlet.http.HttpServletRequest) 2019-08-05 10:29:20.857 INFO 7416 --- [ restartedMain] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/error],produces=[text/html]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) 2019-08-05 10:29:20.881 INFO 7416 --- [ restartedMain] o.s.w.s.handler.SimpleUrlHandlerMapping : Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] 2019-08-05 10:29:20.881 INFO 7416 --- [ restartedMain] o.s.w.s.handler.SimpleUrlHandlerMapping : Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] 2019-08-05 10:29:20.906 INFO 7416 --- [ restartedMain] o.s.w.s.handler.SimpleUrlHandlerMapping : Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] 2019-08-05 10:29:21.115 INFO 7416 --- [ restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729 2019-08-05 10:29:21.164 INFO 7416 --- [ restartedMain] o.s.j.e.a.AnnotationMBeanExporter : Registering beans for JMX exposure on startup 2019-08-05 10:29:21.165 INFO 7416 --- [ restartedMain] o.s.j.e.a.AnnotationMBeanExporter : Bean with name 'dataSource' has been autodetected for JMX exposure 2019-08-05 10:29:21.170 INFO 7416 --- [ restartedMain] o.s.j.e.a.AnnotationMBeanExporter : Located MBean 'dataSource': registering with JMX server as MBean [com.zaxxer.hikari:name=dataSource,type=HikariDataSource] 2019-08-05 10:29:21.196 INFO 7416 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path '' 2019-08-05 10:29:21.198 INFO 7416 --- [ restartedMain] com.xintujiuzhang.aimanagement.App : Started App in 8.458 seconds (JVM running for 8.828) Exception in thread "Thread-12" java.lang.RuntimeException: java.lang.NullPointerException at com.mysql.jdbc.JDBC4Connection$1$1.run(JDBC4Connection.java:106) Caused by: java.lang.NullPointerException at com.mysql.jdbc.ConnectionImpl.abortInternal(ConnectionImpl.java:1240) at com.mysql.jdbc.JDBC4Connection$1$1.run(JDBC4Connection.java:104) **在执行一些方法后“Thread-12”会不断增加** **ps:“Thread-668"**
No provider available from registry ip for service com.zys.store.service.api.HelloServiceApi:1.0.0 on consumer ip use dubbo version 2.6.2
springboot整合zookeeper和dubbo报错 linux上zk版本号是3.4.14 项目用的zk包是3.4.9 dubbo用的是2.6.2 springboot是2.1.6 用main方式先运行store的模块 再运行order的模块 这个时候用浏览器去访问http://localhost:8088/hello?name=zys这个时候控制台就报错No provider available from registry 启动的时候不报错 浏览器访问就报错了 看zk日志有说是HelloServiceApi这个类的节点已经存在 但是我觉得跟这个问题不大 因为运行一次就会创建一个节点 多次的话肯定报节点存在的错 我的linux是虚拟机 并且已经关闭了防火墙 不存在端口跑不通的情况 1. 项目架构是maven的聚合项目![图片说明](https://img-ask.csdn.net/upload/201911/20/1574220333_973372.png) 2. 在zys-store-api写接口 package com.zys.store.service.api; public interface HelloServiceApi { String sayHello(String name); } 3.在zys-store暴露接口 package com.zys.store.service.provider; import com.alibaba.dubbo.config.annotation.Service; import com.zys.store.service.api.HelloServiceApi; @Service( version = "1.0.0", application = "zys-store", protocol = "dubbo", registry = "zys-store-registry" ) public class HelloServiceProvider implements HelloServiceApi{ @Override public String sayHello(String name) { return "hello" + name; } } 下面是zys-store的yml的配置 dubbo: application: id: zys-store name: zys-store qos-port: 22212 qos-enable: true scan: base-packages: com.zys.store.* protocol: id: dubbo name: dubbo port: 12343 registry: id: zys-store-registry address: zookeeper://192.168.146.132:2181?backup=192.168.146.131:2181,192.168.146.133:2181 4.在zys-order调用接口 package com.zys.order.controller; import com.alibaba.dubbo.config.annotation.Reference; import com.zys.store.service.api.HelloServiceApi; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; @RestController public class HelloController { @Reference( version = "1.0.0", application = "zys-order", interfaceName = "com.zys.store.service.api.HelloServiceApi", check = false, timeout = 3000, retries = 0 //读请求3次 写请求不重复 ) private HelloServiceApi helloServiceApi; @RequestMapping("/hello") public String hello(@RequestParam("name") String name){ return helloServiceApi.sayHello(name); } } 下面是zys-order的yml的配置 ```dubbo: application: id: zys-order name: zys-order qos-port: 22211 qos-enable: true qos-accept-foreign-ip: false scan: base-packages: com.zys.order.* protocol: id: dubbo name: dubbo port: 12343 registry: id: zys-order-registry address: zookeeper://192.168.146.132:2181?backup=192.168.146.131:2181,192.168.146.133:2181 store端的启动日志 2019-11-20 10:18:35.426 INFO 50632 --- [ main] a.b.d.c.e.WelcomeLogoApplicationListener : :: Dubbo Spring Boot (v0.2.0) : https://github.com/apache/incubator-dubbo-spring-boot-project :: Dubbo (v2.6.2) : https://github.com/apache/incubator-dubbo :: Google group : dev@dubbo.incubator.apache.org 2019-11-20 10:18:35.430 INFO 50632 --- [ main] e.OverrideDubboConfigApplicationListener : Dubbo Config was overridden by externalized configuration {dubbo.application.id=zys-store, dubbo.application.name=zys-store, dubbo.application.qos-enable=true, dubbo.application.qos-port=22212, dubbo.protocol.id=dubbo, dubbo.protocol.name=dubbo, dubbo.protocol.port=12343, dubbo.registry.address=zookeeper://192.168.146.132:2181?backup=192.168.146.131:2181,192.168.146.133:2181, dubbo.registry.id=zys-store-registry, dubbo.scan.base-packages=com.zys.store.*} . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.1.6.RELEASE) 2019-11-20 10:18:35.488 INFO 50632 --- [ main] com.zys.store.ZysStoreApplication : Starting ZysStoreApplication on DESKTOP-O0S84K8 with PID 50632 (D:\ideaworkspace\zys-project\zys-store\target\classes started by Administrator in D:\ideaworkspace\zys-project) 2019-11-20 10:18:35.489 INFO 50632 --- [ main] com.zys.store.ZysStoreApplication : No active profile set, falling back to default profiles: default 2019-11-20 10:18:35.963 WARN 50632 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.zys.store.dao, com.zys.store.mapper]' package. Please check your configuration. 2019-11-20 10:18:36.030 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-configs' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.031 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-properties' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.031 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-references' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.031 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-services' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.031 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-shutdown' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : zys-store, class : com.alibaba.dubbo.config.ApplicationConfig] has been registered. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : zys-store] has been registered. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : zys-store-registry, class : com.alibaba.dubbo.config.RegistryConfig] has been registered. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : zys-store-registry] has been registered. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : dubbo, class : com.alibaba.dubbo.config.ProtocolConfig] has been registered. 2019-11-20 10:18:36.038 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : dubbo] has been registered. 2019-11-20 10:18:36.060 WARN 50632 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.zys.store]' package. Please check your configuration. 2019-11-20 10:18:36.307 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'com.alibaba.boot.dubbo.autoconfigure.DubboAutoConfiguration' of type [com.alibaba.boot.dubbo.autoconfigure.DubboAutoConfiguration$$EnhancerBySpringCGLIB$$437665e0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.357 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.364 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$3474c06e] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.382 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.383 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.657 INFO 50632 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8089 (http) 2019-11-20 10:18:36.675 INFO 50632 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2019-11-20 10:18:36.675 INFO 50632 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.21] 2019-11-20 10:18:36.770 INFO 50632 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2019-11-20 10:18:36.770 INFO 50632 --- [ main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1249 ms 2019-11-20 10:18:37.038 INFO 50632 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : dubbo] have been binding by prefix of configuration properties : dubbo.protocol 2019-11-20 10:18:37.568 INFO 50632 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2019-11-20 10:18:37.744 INFO 50632 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : zys-store] have been binding by prefix of configuration properties : dubbo.application 2019-11-20 10:18:37.747 INFO 50632 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : zys-store-registry] have been binding by prefix of configuration properties : dubbo.registry 2019-11-20 10:18:37.816 INFO 50632 --- [ main] com.zaxxer.hikari.HikariDataSource : MyHikariCP - Starting... 2019-11-20 10:18:37.993 INFO 50632 --- [ main] com.zaxxer.hikari.HikariDataSource : MyHikariCP - Start completed. order端的启动日志 ```2019-11-20 10:18:47.233 INFO 48096 --- [ main] a.b.d.c.e.WelcomeLogoApplicationListener : :: Dubbo Spring Boot (v0.2.0) : https://github.com/apache/incubator-dubbo-spring-boot-project :: Dubbo (v2.6.2) : https://github.com/apache/incubator-dubbo :: Google group : dev@dubbo.incubator.apache.org 2019-11-20 10:18:47.239 INFO 48096 --- [ main] e.OverrideDubboConfigApplicationListener : Dubbo Config was overridden by externalized configuration {dubbo.application.id=zys-order, dubbo.application.name=zys-order, dubbo.application.qos-accept-foreign-ip=false, dubbo.application.qos-enable=true, dubbo.application.qos-port=22211, dubbo.protocol.id=dubbo, dubbo.protocol.name=dubbo, dubbo.protocol.port=12343, dubbo.registry.address=zookeeper://192.168.146.132:2181?backup=192.168.146.131:2181,192.168.146.133:2181, dubbo.registry.id=zys-order-registry, dubbo.scan.base-packages=com.zys.order.*} . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.1.6.RELEASE) 2019-11-20 10:18:47.301 INFO 48096 --- [ main] com.zys.order.ZysOrderApplication : Starting ZysOrderApplication on DESKTOP-O0S84K8 with PID 48096 (D:\ideaworkspace\zys-project\zys-order\target\classes started by Administrator in D:\ideaworkspace\zys-project) 2019-11-20 10:18:47.302 INFO 48096 --- [ main] com.zys.order.ZysOrderApplication : No active profile set, falling back to default profiles: default 2019-11-20 10:18:47.803 WARN 48096 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.zys.order.dao, com.zys.order.mapper]' package. Please check your configuration. 2019-11-20 10:18:47.868 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-configs' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.869 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-properties' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.870 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-references' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.870 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-services' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.870 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-shutdown' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.875 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : zys-order, class : com.alibaba.dubbo.config.ApplicationConfig] has been registered. 2019-11-20 10:18:47.875 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : zys-order] has been registered. 2019-11-20 10:18:47.875 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : zys-order-registry, class : com.alibaba.dubbo.config.RegistryConfig] has been registered. 2019-11-20 10:18:47.875 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : zys-order-registry] has been registered. 2019-11-20 10:18:47.876 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : dubbo, class : com.alibaba.dubbo.config.ProtocolConfig] has been registered. 2019-11-20 10:18:47.876 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : dubbo] has been registered. 2019-11-20 10:18:47.894 WARN 48096 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.zys.order]' package. Please check your configuration. 2019-11-20 10:18:48.164 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'com.alibaba.boot.dubbo.autoconfigure.DubboAutoConfiguration' of type [com.alibaba.boot.dubbo.autoconfigure.DubboAutoConfiguration$$EnhancerBySpringCGLIB$$5fbcce96] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.239 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$50bb2924] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.261 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.263 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.264 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.482 INFO 48096 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8088 (http) 2019-11-20 10:18:48.496 INFO 48096 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2019-11-20 10:18:48.496 INFO 48096 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.21] 2019-11-20 10:18:48.596 INFO 48096 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2019-11-20 10:18:48.596 INFO 48096 --- [ main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1268 ms 2019-11-20 10:18:48.847 INFO 48096 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : dubbo] have been binding by prefix of configuration properties : dubbo.protocol 2019-11-20 10:18:49.338 INFO 48096 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : zys-order] have been binding by prefix of configuration properties : dubbo.application 2019-11-20 10:18:49.345 INFO 48096 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : zys-order-registry] have been binding by prefix of configuration properties : dubbo.registry 2019-11-20 10:18:49.919 INFO 48096 --- [ main] o.a.c.f.imps.CuratorFrameworkImpl : Starting 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:zookeeper.version=3.4.9-1757313, built on 08/23/2016 06:50 GMT 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:host.name=DESKTOP-O0S84K8 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.version=1.8.0_211 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.vendor=Oracle Corporation 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.home=C:\Program Files\Java\jdk1.8.0_211\jre 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.class.path=C:\Program Files\Java\jdk1.8.0_211\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\rt.jar;D:\ideaworkspace\zys-project\zys-order\target\classes;D:\repository\org\springframework\boot\spring-boot-starter-web\2.1.6.RELEASE\spring-boot-starter-web-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-starter-json\2.1.6.RELEASE\spring-boot-starter-json-2.1.6.RELEASE.jar;D:\repository\com\fasterxml\jackson\core\jackson-databind\2.9.9\jackson-databind-2.9.9.jar;D:\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.9.9\jackson-datatype-jdk8-2.9.9.jar;D:\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.9.9\jackson-datatype-jsr310-2.9.9.jar;D:\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.9.9\jackson-module-parameter-names-2.9.9.jar;D:\repository\org\springframework\boot\spring-boot-starter-tomcat\2.1.6.RELEASE\spring-boot-starter-tomcat-2.1.6.RELEASE.jar;D:\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.21\tomcat-embed-core-9.0.21.jar;D:\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.21\tomcat-embed-el-9.0.21.jar;D:\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.21\tomcat-embed-websocket-9.0.21.jar;D:\repository\org\hibernate\validator\hibernate-validator\6.0.17.Final\hibernate-validator-6.0.17.Final.jar;D:\repository\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;D:\repository\org\jboss\logging\jboss-logging\3.3.2.Final\jboss-logging-3.3.2.Final.jar;D:\repository\com\fasterxml\classmate\1.4.0\classmate-1.4.0.jar;D:\repository\org\springframework\spring-web\5.1.8.RELEASE\spring-web-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-beans\5.1.8.RELEASE\spring-beans-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-webmvc\5.1.8.RELEASE\spring-webmvc-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-aop\5.1.8.RELEASE\spring-aop-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-context\5.1.8.RELEASE\spring-context-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-expression\5.1.8.RELEASE\spring-expression-5.1.8.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-starter-actuator\2.1.6.RELEASE\spring-boot-starter-actuator-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-actuator-autoconfigure\2.1.6.RELEASE\spring-boot-actuator-autoconfigure-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-actuator\2.1.6.RELEASE\spring-boot-actuator-2.1.6.RELEASE.jar;D:\repository\io\micrometer\micrometer-core\1.1.5\micrometer-core-1.1.5.jar;D:\repository\org\latencyutils\LatencyUtils\2.0.3\LatencyUtils-2.0.3.jar;D:\repository\org\springframework\spring-core\5.1.8.RELEASE\spring-core-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-jcl\5.1.8.RELEASE\spring-jcl-5.1.8.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-starter-jdbc\2.1.6.RELEASE\spring-boot-starter-jdbc-2.1.6.RELEASE.jar;D:\repository\com\zaxxer\HikariCP\3.2.0\HikariCP-3.2.0.jar;D:\repository\org\springframework\spring-jdbc\5.1.8.RELEASE\spring-jdbc-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-tx\5.1.8.RELEASE\spring-tx-5.1.8.RELEASE.jar;D:\repository\com\baomidou\mybatis-plus-boot-starter\3.1.1\mybatis-plus-boot-starter-3.1.1.jar;D:\repository\com\baomidou\mybatis-plus\3.1.1\mybatis-plus-3.1.1.jar;D:\repository\com\baomidou\mybatis-plus-extension\3.1.1\mybatis-plus-extension-3.1.1.jar;D:\repository\com\baomidou\mybatis-plus-core\3.1.1\mybatis-plus-core-3.1.1.jar;D:\repository\com\baomidou\mybatis-plus-annotation\3.1.1\mybatis-plus-annotation-3.1.1.jar;D:\repository\com\github\jsqlparser\jsqlparser\1.2\jsqlparser-1.2.jar;D:\repository\org\mybatis\mybatis\3.5.1\mybatis-3.5.1.jar;D:\repository\org\mybatis\mybatis-spring\2.0.1\mybatis-spring-2.0.1.jar;D:\repository\org\springframework\boot\spring-boot-autoconfigure\2.1.6.RELEASE\spring-boot-autoconfigure-2.1.6.RELEASE.jar;D:\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;D:\repository\mysql\mysql-connector-java\6.0.6\mysql-connector-java-6.0.6.jar;D:\repository\com\alibaba\boot\dubbo-spring-boot-starter\0.2.0\dubbo-spring-boot-starter-0.2.0.jar;D:\repository\com\alibaba\dubbo\2.6.2\dubbo-2.6.2.jar;D:\repository\org\javassist\javassist\3.20.0-GA\javassist-3.20.0-GA.jar;D:\repository\org\jboss\netty\netty\3.2.5.Final\netty-3.2.5.Final.jar;D:\repository\org\apache\zookeeper\zookeeper\3.4.9\zookeeper-3.4.9.jar;D:\repository\jline\jline\0.9.94\jline-0.9.94.jar;D:\repository\io\netty\netty\3.10.5.Final\netty-3.10.5.Final.jar;D:\repository\org\apache\curator\curator-framework\2.12.0\curator-framework-2.12.0.jar;D:\repository\org\apache\curator\curator-client\2.12.0\curator-client-2.12.0.jar;D:\repository\com\alibaba\boot\dubbo-spring-boot-autoconfigure\0.2.0\dubbo-spring-boot-autoconfigure-0.2.0.jar;D:\repository\com\alibaba\boot\dubbo-spring-boot-actuator\0.2.0\dubbo-spring-boot-actuator-0.2.0.jar;D:\repository\com\netflix\hystrix\hystrix-core\1.5.12\hystrix-core-1.5.12.jar;D:\repository\org\slf4j\slf4j-api\1.7.26\slf4j-api-1.7.26.jar;D:\repository\com\netflix\archaius\archaius-core\0.4.1\archaius-core-0.4.1.jar;D:\repository\commons-configuration\commons-configuration\1.8\commons-configuration-1.8.jar;D:\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;D:\repository\io\reactivex\rxjava\1.3.8\rxjava-1.3.8.jar;D:\repository\org\hdrhistogram\HdrHistogram\2.1.9\HdrHistogram-2.1.9.jar;D:\repository\com\netflix\hystrix\hystrix-metrics-event-stream\1.5.12\hystrix-metrics-event-stream-1.5.12.jar;D:\repository\com\netflix\hystrix\hystrix-serialization\1.5.12\hystrix-serialization-1.5.12.jar;D:\repository\com\fasterxml\jackson\module\jackson-module-afterburner\2.9.9\jackson-module-afterburner-2.9.9.jar;D:\repository\com\fasterxml\jackson\core\jackson-core\2.9.9\jackson-core-2.9.9.jar;D:\repository\com\fasterxml\jackson\core\jackson-annotations\2.9.0\jackson-annotations-2.9.0.jar;D:\repository\com\netflix\hystrix\hystrix-javanica\1.5.12\hystrix-javanica-1.5.12.jar;D:\repository\org\aspectj\aspectjrt\1.9.4\aspectjrt-1.9.4.jar;D:\repository\org\apache\commons\commons-lang3\3.3.1\commons-lang3-3.3.1.jar;D:\repository\org\ow2\asm\asm\5.0.4\asm-5.0.4.jar;D:\repository\org\aspectj\aspectjweaver\1.9.4\aspectjweaver-1.9.4.jar;D:\repository\com\google\guava\guava\15.0\guava-15.0.jar;D:\repository\com\google\code\findbugs\jsr305\2.0.0\jsr305-2.0.0.jar;D:\repository\org\apache\rocketmq\rocketmq-client\4.3.0\rocketmq-client-4.3.0.jar;D:\repository\org\apache\rocketmq\rocketmq-common\4.3.0\rocketmq-common-4.3.0.jar;D:\repository\org\apache\rocketmq\rocketmq-remoting\4.3.0\rocketmq-remoting-4.3.0.jar;D:\repository\com\alibaba\fastjson\1.2.29\fastjson-1.2.29.jar;D:\repository\io\netty\netty-all\4.1.36.Final\netty-all-4.1.36.Final.jar;D:\repository\org\apache\rocketmq\rocketmq-logging\4.3.0\rocketmq-logging-4.3.0.jar;D:\repository\io\netty\netty-tcnative-boringssl-static\2.0.25.Final\netty-tcnative-boringssl-static-2.0.25.Final.jar;D:\repository\com\zys\zys-store-api\0.0.1-SNAPSHOT\zys-store-api-0.0.1-SNAPSHOT.jar;D:\repository\org\springframework\boot\spring-boot-starter\2.1.6.RELEASE\spring-boot-starter-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot\2.1.6.RELEASE\spring-boot-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-starter-logging\2.1.6.RELEASE\spring-boot-starter-logging-2.1.6.RELEASE.jar;D:\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\repository\org\apache\logging\log4j\log4j-to-slf4j\2.11.2\log4j-to-slf4j-2.11.2.jar;D:\repository\org\apache\logging\log4j\log4j-api\2.11.2\log4j-api-2.11.2.jar;D:\repository\org\slf4j\jul-to-slf4j\1.7.26\jul-to-slf4j-1.7.26.jar;D:\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;D:\repository\org\yaml\snakeyaml\1.23\snakeyaml-1.23.jar;D:\idea\IntelliJ IDEA 2019.2\lib\idea_rt.jar 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.library.path=C:\Program Files\Java\jdk1.8.0_211\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:\idea\IntelliJ IDEA 2019.2\jbr\\bin;D:\idea\IntelliJ IDEA 2019.2\jbr\\bin\server;D:\oracleClient\product\11.2.0\client_1\bin;D:\xshell\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Java\jdk1.8.0_211;D:\Git\cmd;C:\Program Files\MySQL\MySQL Server 5.7\bin;D:\TortoiseSVN1.10\bin;D:\apache-maven-idea\bin;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps;;. 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.io.tmpdir=C:\Users\ADMINI~1\AppData\Local\Temp\ 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.compiler=<NA> 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:os.name=Windows 10 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:os.arch=amd64 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:os.version=10.0 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:user.name=Administrator 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:user.home=C:\Users\Administrator 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:user.dir=D:\ideaworkspace\zys-project 2019-11-20 10:18:58.932 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Initiating client connection, connectString=192.168.146.132:2181,192.168.146.131:2181,192.168.146.133:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@5a3a1bf9 2019-11-20 10:18:58.942 INFO 48096 --- [8.146.132:2181)] org.apache.zookeeper.ClientCnxn : Opening socket connection to server 192.168.146.132/192.168.146.132:2181. Will not attempt to authenticate using SASL (unknown error) 2019-11-20 10:18:58.942 INFO 48096 --- [8.146.132:2181)] org.apache.zookeeper.ClientCnxn : Socket connection established to 192.168.146.132/192.168.146.132:2181, initiating session 2019-11-20 10:18:58.953 INFO 48096 --- [8.146.132:2181)] org.apache.zookeeper.ClientCnxn : Session establishment complete on server 192.168.146.132/192.168.146.132:2181, sessionid = 0x200000235350000, negotiated timeout = 40000 2019-11-20 10:18:58.957 INFO 48096 --- [ain-EventThread] o.a.c.f.state.ConnectionStateManager : State change: CONNECTED 2019-11-20 10:18:59.030 INFO 48096 --- [ main] c.a.d.c.s.b.f.a.ReferenceBeanBuilder : <dubbo:reference object="com.alibaba.dubbo.common.bytecode.proxy0@3b5c665c" singleton="true" interface="com.zys.store.service.api.HelloServiceApi" uniqueServiceName="com.zys.store.service.api.HelloServiceApi:1.0.0" generic="false" version="1.0.0" check="false" timeout="3000" id="com.zys.store.service.api.HelloServiceApi" /> has been built. 2019-11-20 10:18:59.242 INFO 48096 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2019-11-20 10:18:59.420 INFO 48096 --- [ main] com.zaxxer.hikari.HikariDataSource : MyHikariCP - Starting... 2019-11-20 10:18:59.592 INFO 48096 --- [ main] com.zaxxer.hikari.HikariDataSource : MyHikariCP - Start completed. _ _ |_ _ _|_. ___ _ | _ | | |\/|_)(_| | |_\ |_)||_|_\ / | 3.1.1 2019-11-20 10:18:59.836 INFO 48096 --- [ main] o.s.b.a.e.web.EndpointLinksResolver : Exposing 2 endpoint(s) beneath base path '/actuator' 2019-11-20 10:18:59.897 INFO 48096 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8088 (http) with context path '' 2019-11-20 10:18:59.899 INFO 48096 --- [ main] com.zys.order.ZysOrderApplication : Started ZysOrderApplication in 12.907 seconds (JVM running for 13.464) 2019-11-20 10:18:59.956 INFO 48096 --- [-192.168.255.54] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2019-11-20 10:18:59.956 INFO 48096 --- [-192.168.255.54] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2019-11-20 10:18:59.969 INFO 48096 --- [-192.168.255.54] o.s.web.servlet.DispatcherServlet : Completed initialization in 13 ms ```
java内存溢出问题,不确定哪里出的问题
项目运行的时候出现了内存溢出情况,复现方式无法确定,大概出现了五六次,每次复现的方式都不一样,下面是我用MAT工具分析的dump文件 ![图片说明](https://img-ask.csdn.net/upload/202001/20/1579508231_612899.png) ![图片说明](https://img-ask.csdn.net/upload/202001/20/1579508244_502327.png) 除了hibernate里的那两个对象,其他的1000多万个对象里全是integer类型的对象 这是当时出现的时候产生的异常 ``` 2020-01-17 13:32:55 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state 08S01 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 1 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3517) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3417) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3860) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor118.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2969) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427) ... 19 more 2020-01-17 13:33:03 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_preset_rlat failed: java.lang.OutOfMemoryError: GC overhead limit exceeded at net.sf.ehcache.util.MemoryEfficientByteArrayOutputStream.getBytes(MemoryEfficientByteArrayOutputStream.java:65) at net.sf.ehcache.util.MemoryEfficientByteArrayOutputStream.serialize(MemoryEfficientByteArrayOutputStream.java:99) at net.sf.ehcache.store.disk.DiskStorageFactory.serializeElement(DiskStorageFactory.java:405) at net.sf.ehcache.store.disk.DiskStorageFactory.write(DiskStorageFactory.java:384) at net.sf.ehcache.store.disk.DiskStorageFactory$DiskWriteTask.call(DiskStorageFactory.java:485) at net.sf.ehcache.store.disk.DiskStorageFactory$PersistentDiskWriteTask.call(DiskStorageFactory.java:1088) at net.sf.ehcache.store.disk.DiskStorageFactory$PersistentDiskWriteTask.call(DiskStorageFactory.java:1072) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) 2020-01-17 13:32:59 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:32:59 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:32:55 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:16 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:27 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-17 13:33:27 ERROR [SqlExceptionHelper.java:144] - wait millis 7401, active 16, maxActive 40, creating 1 2020-01-17 13:33:27 INFO [GetCWRCapHandler.java:114] - 解析录像服务器上报心跳协议过程中出现异常:org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection 2020-01-17 13:33:33 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:33 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:49 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:49 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:49 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:49 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:49 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:53 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:53 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:33:53 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:02 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-17 13:34:02 ERROR [SqlExceptionHelper.java:144] - wait millis 5503, active 18, maxActive 40, creating 1 2020-01-17 13:34:02 INFO [GetCWRCapHandler.java:114] - 解析录像服务器上报心跳协议过程中出现异常:org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection 2020-01-17 13:34:04 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:08 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:12 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:12 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:14 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:14 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:14 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:17 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-17 13:34:17 ERROR [SqlExceptionHelper.java:144] - wait millis 5485, active 19, maxActive 40, creating 1 2020-01-17 13:34:17 INFO [GetCWRCapHandler.java:114] - 解析录像服务器上报心跳协议过程中出现异常:org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection 2020-01-17 13:34:17 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:27 INFO [DeviceCache.java:249] - 设备状态及报警维护过程中出现异常 2020-01-17 13:34:35 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:35 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:42 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:42 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:44 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:44 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:34:52 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-17 13:34:52 ERROR [SqlExceptionHelper.java:144] - wait millis 7301, active 22, maxActive 40, creating 1 2020-01-17 13:34:52 INFO [GetCWRCapHandler.java:114] - 解析录像服务器上报心跳协议过程中出现异常:org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection 2020-01-17 13:34:53 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:35:05 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_roll_preset failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-17 13:35:18 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-17 13:35:18 ERROR [SqlExceptionHelper.java:144] - Error 2020-01-17 13:35:50 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-17 13:35:50 ERROR [SqlExceptionHelper.java:144] - Error 2020-01-17 13:36:13 WARN [SqlExceptionHelper.java:143] - SQL Error: 1205, SQLState: 40001 2020-01-17 13:36:13 ERROR [SqlExceptionHelper.java:144] - Lock wait timeout exceeded; try restarting transaction 2020-01-17 13:36:13 WARN [SqlExceptionHelper.java:143] - SQL Error: 1205, SQLState: 40001 2020-01-17 13:36:24 ERROR [SqlExceptionHelper.java:144] - Lock wait timeout exceeded; try restarting transaction 2020-01-17 13:36:13 WARN [SqlExceptionHelper.java:143] - SQL Error: 1205, SQLState: 40001 2020-01-17 13:37:01 ERROR [SqlExceptionHelper.java:144] - Lock wait timeout exceeded; try restarting transaction 2020-01-17 13:37:43 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-17 13:36:37 WARN [SqlExceptionHelper.java:143] - SQL Error: 1205, SQLState: 40001 2020-01-17 13:36:33 WARN [SqlExceptionHelper.java:143] - SQL Error: 1205, SQLState: 40001 2020-01-17 13:36:22 WARN [SqlExceptionHelper.java:143] - SQL Error: 1205, SQLState: 40001 ``` 现在就是无法确定到底哪里导致的内存溢出? 这个是上次出现的异常和代码 ``` 2020-01-13 13:21:44 WARN [SqlExceptionHelper.java:143] - SQL Error: 1205, SQLState: 40001 2020-01-13 13:21:44 ERROR [SqlExceptionHelper.java:144] - Lock wait timeout exceeded; try restarting transaction 2020-01-13 13:23:55 INFO [MQTTProtocolHandler.java:283] - 接收到设备接入协议:{"topic":"info/deviceBaseInfo/BHIP118-S/00:00:01:A6:00:A2","reportTime":"256573751","decodeCapacity":{"totalLevel":2,"totalBlock":36,"totalPixel":16588800},"outputList":[{"status":"start","ratio":"UHD","pixel":"3840*2160","type":"UDP","url":"udp://231.0.100.80:7001"},{"status":"start","ratio":"HD","pixel":"960*540","type":"UDP","url":"udp://231.0.101.80:7001"},{"status":"start","ratio":"SD","pixel":"352*288","type":"UDP","url":"udp://231.0.102.80:7001"},{"status":"stop","ratio":"UHD","pixel":"3840*2160","type":"RTMP","url":"rtmp://192.168.15.80:1935/live/100"},{"status":"stop","ratio":"HD","pixel":"960*540","type":"RTMP","url":"rtmp://192.168.15.124:1935/live/101"},{"status":"stop","ratio":"SD","pixel":"352*288","type":"RTMP","url":"rtmp://192.168.15.80:1935/live/102"}],"baseInfo":{"deviceType":"BHIP118-S","code":"00:00:01:A6:00:A2","version":"v1.0.0.11","ip":"192.168.16.80"},"online":true} 2020-01-13 13:23:59 INFO [DeviceCache.java:127] - 接收到新增/更新设备信息:00:00:01:A6:00:A2 :BaseInfo [type=0,name=BHIP118-S,ip=192.168.16.80,port=0,code=00:00:01:A6:00:A2,groupCode=null,groupIndex=0,online=true,multiCastTime=0,ver=v1.0.0.11,channel=0,reserve=0,lockStatus=null,workMode=null,videoPixerls=null,kvmMode=null,serialNumber=null,sdipPortInfo is null,hdIpPortInfo is null,audioIpPortInfo is null,outputList[SourceOutput [ratio=UHD, url=udp://231.0.100.80:7001, pixel=3840*2160, channel=0, SourceOutput [ratio=HD, url=udp://231.0.101.80:7001, pixel=960*540, channel=0, SourceOutput [ratio=SD, url=udp://231.0.102.80:7001, pixel=352*288, channel=0, SourceOutput [ratio=UHD, url=rtmp://192.168.15.80:1935/live/100, pixel=3840*2160, channel=0, SourceOutput [ratio=HD, url=rtmp://192.168.15.124:1935/live/101, pixel=960*540, channel=0, SourceOutput [ratio=SD, url=rtmp://192.168.15.80:1935/live/102, pixel=352*288, channel=0],callStatus=null] 2020-01-13 13:24:06 INFO [MultiCastDeviceInfoHandler.java:229] - 更新视频合成器设备信息: Device [id=ff8080816f694555016f6a4bf61e158c, code=00:00:01:A6:00:A2, name=192.168.16.80, ip=192.168.16.80, port=0, status=0, type=BHIP118, deviceType=BHIP118-S, stamp=2020-01-03 15:26:00, abilityInfo=null, netCardInfo=null] 2020-01-13 13:24:53 INFO [MultiCastDeviceInfoHandler.java:364] - 更新解码器信息:Decoder [IP=192.168.16.80, Port=0, Channel=0, totalBlocks=36, totalLevel=2, uRefWidth=1920, uRefHeight=1080, audioPort=0, totalPixel=16588800, deviceTypeName=BHIP118-S, pixelsWidth=null, pixelsHeight=null] 2020-01-13 13:25:17 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:25:17 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:25:17 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:25:19 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:25:28 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:25:42 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-13 13:25:42 ERROR [SqlExceptionHelper.java:144] - wait millis 14463, active 11, maxActive 40, creating 1 2020-01-13 13:25:46 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_playback_task failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:25:48 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-13 13:25:50 ERROR [SqlExceptionHelper.java:144] - wait millis 18056, active 11, maxActive 40, creating 1 2020-01-13 13:25:50 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_source_volume failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:25:51 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:25:51 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:25:51 INFO [GetCWRCapHandler.java:114] - 解析录像服务器上报心跳协议过程中出现异常:org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection 2020-01-13 13:25:51 INFO [GetCWRCapHandler.java:114] - 解析录像服务器上报心跳协议过程中出现异常:org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection 2020-01-13 13:25:58 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_kvm failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:25:56 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:25:56 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:03 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_video_terminal failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:05 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:05 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_template failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:05 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_multicast_address failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:08 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_mass_source failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:08 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_encoder_block failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:08 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_ipc_preset_group failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:08 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:13 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_video_terminal failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:17 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_record_layer_block failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:24 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_video_meeting failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:28 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_audio_preset_rlat failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:28 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_preset failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:28 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_layer_block failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:28 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:32 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-01-13 13:26:32 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:32 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:32 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_encoder failed: java.lang.OutOfMemoryError: GC overhead limit exceeded 2020-01-13 13:26:52 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:27:07 ERROR [SqlExceptionHelper.java:144] - wait millis 20150, active 12, maxActive 40, creating 1 2020-01-13 13:26:50 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:46 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:46 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:41 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:41 ERROR [SqlExceptionHelper.java:144] - wait millis 23244, active 12, maxActive 40, creating 1 2020-01-13 13:26:41 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:26:41 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:30:29 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:30:25 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:30:07 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:30:07 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-01-13 13:30:07 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 ``` 这个是组播上报的设备信息,因为组播是一秒钟上报了好几次,是不是这里一直占用着连接 ``` public void run() { try { ms = new MulticastSocket(multiCastPort);//建立组播套接字 ms.setReceiveBufferSize(65535); // ms.setNetworkInterface(NetworkInterface.getByInetAddress(localAddress)); ms.joinGroup(InetAddress.getByName(multiCastIP));//加入组播组 LogHome.getLog().info("正常启动监听" + localAddress.getHostAddress()); byte[] buffer = null; DatagramPacket dp = null; while (true) { try { if (IsStop) { break; } buffer = new byte[1400]; dp = new DatagramPacket(buffer, buffer.length); LogHome.getLog().debug("等待接受组播信息:"); ms.receive(dp); MultiCastInfoParser info = new MultiCastInfoParser(dp.getData()); DeviceCache.baseInfoOf1004Handler(info.parse()); } catch (Exception e) { if (IsStop) {// 如果换网卡可能会出问题 break; } else { if (ms.isClosed()) { ms = new MulticastSocket(multiCastPort); ms.setNetworkInterface(NetworkInterface.getByInetAddress(localAddress)); ms.joinGroup(InetAddress.getByName(multiCastIP)); } } LogHome.getLog().error("接受并设置组播信息失败",e); }finally{ Thread.sleep(1); } } } catch (Exception e) { e.printStackTrace(); try { if (listenerList.containsKey(localAddress.getHostAddress())) { listenerList.remove(localAddress.getHostAddress()); } } catch (Exception ex) { LogHome.getLog().error(ex); } } ```
mha安装manager ,Log::Dispatch ...missing
# perl Makefile.PL *** Module::AutoInstall version 1.03 *** Checking for Perl dependencies... [Core Features] - DBI ...loaded. (1.609) - DBD::mysql ...loaded. (4.013) - Time::HiRes ...loaded. (1.9721) - Config::Tiny ...loaded. (2.12) **- Log::Dispatch ...missing.** **- Parallel::ForkManager ...loaded. (0.7.9) - MHA::NodeConst ...loaded. (0.56) ==> Auto-install the 1 mandatory module(s) from CPAN? [y] y *** Dependencies will be installed the next time you type 'make'. *** Module::AutoInstall configuration finished. Writing Makefile for mha4mysql::manager** # rpm -qa perl-Log-Dispatch perl-Log-Dispatch-2.27-1.el6.noarch 这个perl-Log-Dispatch包已经存在了......为什么还会有missing呢?
java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Tomcat].StandardHost[localhost].TomcatEmbeddedContext[]]
"C:\idea\IntelliJ IDEA 2019.2.4\jbr\bin\java.exe" -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:56203,suspend=y,server=n -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -Dfile.encoding=UTF-8 -classpath "E:\java\develop\javacode\spring-boot\target\classes;E:\java\develop\javacode\spring-boot\lib\javaee.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\tyrus-container-servlet.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\javax.websocket-api.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\tyrus-container-glassfish-cdi.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\tyrus-server.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\tyrus-client.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\tyrus-spi.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\tyrus-container-grizzly.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\tyrus-core.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.27\tyrus-websocket-core.jar;E:\maven\maven_repository\org\springframework\boot\spring-boot-starter\2.0.1.RELEASE\spring-boot-starter-2.0.1.RELEASE.jar;E:\maven\maven_repository\org\springframework\boot\spring-boot\2.0.1.RELEASE\spring-boot-2.0.1.RELEASE.jar;E:\maven\maven_repository\org\springframework\spring-context\5.0.5.RELEASE\spring-context-5.0.5.RELEASE.jar;E:\maven\maven_repository\org\springframework\boot\spring-boot-autoconfigure\2.0.1.RELEASE\spring-boot-autoconfigure-2.0.1.RELEASE.jar;E:\maven\maven_repository\org\springframework\boot\spring-boot-starter-logging\2.0.1.RELEASE\spring-boot-starter-logging-2.0.1.RELEASE.jar;E:\maven\maven_repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;E:\maven\maven_repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;E:\maven\maven_repository\org\apache\logging\log4j\log4j-to-slf4j\2.10.0\log4j-to-slf4j-2.10.0.jar;E:\maven\maven_repository\org\apache\logging\log4j\log4j-api\2.10.0\log4j-api-2.10.0.jar;E:\maven\maven_repository\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;E:\maven\maven_repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;E:\maven\maven_repository\org\springframework\spring-core\5.0.5.RELEASE\spring-core-5.0.5.RELEASE.jar;E:\maven\maven_repository\org\springframework\spring-jcl\5.0.5.RELEASE\spring-jcl-5.0.5.RELEASE.jar;E:\maven\maven_repository\org\yaml\snakeyaml\1.19\snakeyaml-1.19.jar;E:\maven\maven_repository\org\springframework\boot\spring-boot-starter-web\2.0.1.RELEASE\spring-boot-starter-web-2.0.1.RELEASE.jar;E:\maven\maven_repository\org\springframework\boot\spring-boot-starter-json\2.0.1.RELEASE\spring-boot-starter-json-2.0.1.RELEASE.jar;E:\maven\maven_repository\com\fasterxml\jackson\core\jackson-databind\2.9.5\jackson-databind-2.9.5.jar;E:\maven\maven_repository\com\fasterxml\jackson\core\jackson-annotations\2.9.0\jackson-annotations-2.9.0.jar;E:\maven\maven_repository\com\fasterxml\jackson\core\jackson-core\2.9.5\jackson-core-2.9.5.jar;E:\maven\maven_repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.9.5\jackson-datatype-jdk8-2.9.5.jar;E:\maven\maven_repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.9.5\jackson-datatype-jsr310-2.9.5.jar;E:\maven\maven_repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.9.5\jackson-module-parameter-names-2.9.5.jar;E:\maven\maven_repository\org\springframework\boot\spring-boot-starter-tomcat\2.0.1.RELEASE\spring-boot-starter-tomcat-2.0.1.RELEASE.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-core\8.5.29\tomcat-embed-core-8.5.29.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-el\8.5.29\tomcat-embed-el-8.5.29.jar;E:\maven\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.29\tomcat-embed-websocket-8.5.29.jar;E:\maven\maven_repository\org\hibernate\validator\hibernate-validator\6.0.9.Final\hibernate-validator-6.0.9.Final.jar;E:\maven\maven_repository\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;E:\maven\maven_repository\org\jboss\logging\jboss-logging\3.3.2.Final\jboss-logging-3.3.2.Final.jar;E:\maven\maven_repository\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;E:\maven\maven_repository\org\springframework\spring-web\5.0.5.RELEASE\spring-web-5.0.5.RELEASE.jar;E:\maven\maven_repository\org\springframework\spring-beans\5.0.5.RELEASE\spring-beans-5.0.5.RELEASE.jar;E:\maven\maven_repository\org\springframework\spring-webmvc\5.0.5.RELEASE\spring-webmvc-5.0.5.RELEASE.jar;E:\maven\maven_repository\org\springframework\spring-aop\5.0.5.RELEASE\spring-aop-5.0.5.RELEASE.jar;E:\maven\maven_repository\org\springframework\spring-expression\5.0.5.RELEASE\spring-expression-5.0.5.RELEASE.jar;E:\maven\maven_repository\org\mybatis\generator\mybatis-generator-core\1.3.5\mybatis-generator-core-1.3.5.jar;E:\maven\maven_repository\mysql\mysql-connector-java\8.0.11\mysql-connector-java-8.0.11.jar;E:\maven\maven_repository\com\google\protobuf\protobuf-java\2.6.0\protobuf-java-2.6.0.jar;E:\maven\maven_repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;C:\idea\IntelliJ IDEA 2019.2.4\lib\idea_rt.jar" com.aipuer.springboot.Application Connected to the target VM, address: '127.0.0.1:56203', transport: 'socket' . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.0.1.RELEASE) 2019-12-02 11:09:39.252 INFO 8852 --- [ main] com.aipuer.springboot.Application : Starting Application on PC-20191121IKBV with PID 8852 (E:\java\develop\javacode\spring-boot\target\classes started by Administrator in E:\java\develop\javacode\spring-boot) 2019-12-02 11:09:39.254 INFO 8852 --- [ main] com.aipuer.springboot.Application : No active profile set, falling back to default profiles: default 2019-12-02 11:09:39.281 INFO 8852 --- [ main] ConfigServletWebServerApplicationContext : Refreshing org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@78641d23: startup date [Mon Dec 02 11:09:39 CST 2019]; root of context hierarchy WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.springframework.cglib.core.ReflectUtils$1 (file:/E:/maven/maven_repository/org/springframework/spring-core/5.0.5.RELEASE/spring-core-5.0.5.RELEASE.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain) WARNING: Please consider reporting this to the maintainers of org.springframework.cglib.core.ReflectUtils$1 WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release 2019-12-02 11:09:39.917 INFO 8852 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2019-12-02 11:09:39.932 INFO 8852 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2019-12-02 11:09:39.932 INFO 8852 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet Engine: Apache Tomcat/8.5.29 2019-12-02 11:09:39.936 INFO 8852 --- [ost-startStop-1] o.a.catalina.core.AprLifecycleListener : The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [C:\idea\IntelliJ IDEA 2019.2.4\jbr\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;E:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;E:\java\development\jdk8\bin;E:\java\development\jdk8\jre\bin;E:\java\development\apache-maven-3.3.9-bin\bin;C:\Program Files\MySQL\MySQL Server 8.0\bin\;C:\Program Files\nodejs\;E:\java\svn\bin;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Users\Administrator\AppData\Roaming\npm;.] 2019-12-02 11:09:39.981 ERROR 8852 --- [cat-startStop-1] org.apache.catalina.core.ContainerBase : A child container failed during start java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Tomcat].StandardHost[localhost].TomcatEmbeddedContext[]] at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[na:na] at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191) ~[na:na] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:941) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:872) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1421) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1411) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na] at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na] Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Tomcat].StandardHost[localhost].TomcatEmbeddedContext[]] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167) ~[tomcat-embed-core-8.5.29.jar:8.5.29] ... 6 common frames omitted Caused by: org.apache.catalina.LifecycleException: Failed to start component [Pipeline[StandardEngine[Tomcat].StandardHost[localhost].TomcatEmbeddedContext[]]] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5125) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] ... 6 common frames omitted Caused by: org.apache.catalina.LifecycleException: Failed to start component [org.apache.catalina.authenticator.NonLoginAuthenticator[]] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardPipeline.startInternal(StandardPipeline.java:182) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] ... 8 common frames omitted Caused by: java.lang.NoSuchMethodError: 'java.lang.String javax.servlet.ServletContext.getVirtualServerName()' at org.apache.catalina.authenticator.AuthenticatorBase.startInternal(AuthenticatorBase.java:1186) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] ... 10 common frames omitted 2019-12-02 11:09:39.982 ERROR 8852 --- [ main] org.apache.catalina.core.ContainerBase : A child container failed during start java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Tomcat].StandardHost[localhost]] at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[na:na] at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191) ~[na:na] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:941) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:793) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.startup.Tomcat.start(Tomcat.java:367) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:107) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:86) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:409) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:174) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:179) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:152) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:544) ~[spring-context-5.0.5.RELEASE.jar:5.0.5.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at com.aipuer.springboot.Application.main(Application.java:9) ~[classes/:na] Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Tomcat].StandardHost[localhost]] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1421) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1411) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na] at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na] Caused by: org.apache.catalina.LifecycleException: A child container failed during start at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:949) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:872) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] ... 6 common frames omitted 2019-12-02 11:09:39.982 INFO 8852 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] 2019-12-02 11:09:39.983 WARN 8852 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat 2019-12-02 11:09:39.987 INFO 8852 --- [ main] ConditionEvaluationReportLoggingListener : Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2019-12-02 11:09:39.990 ERROR 8852 --- [ main] o.s.boot.SpringApplication : Application run failed org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:155) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:544) ~[spring-context-5.0.5.RELEASE.jar:5.0.5.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at com.aipuer.springboot.Application.main(Application.java:9) ~[classes/:na] Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:126) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:86) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:409) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:174) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:179) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:152) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] ... 8 common frames omitted Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardServer[-1]] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.startup.Tomcat.start(Tomcat.java:367) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:107) ~[spring-boot-2.0.1.RELEASE.jar:2.0.1.RELEASE] ... 13 common frames omitted Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardService[Tomcat]] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:793) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] ... 15 common frames omitted Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Tomcat]] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] ... 17 common frames omitted Caused by: org.apache.catalina.LifecycleException: A child container failed during start at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:949) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) ~[tomcat-embed-core-8.5.29.jar:8.5.29] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) ~[tomcat-embed-core-8.5.29.jar:8.5.29] ... 19 common frames omitted Disconnected from the target VM, address: '127.0.0.1:56203', transport: 'socket' Process finished with exit code 1
web项目运行一段时间就宕掉了,警告: processCallbacks status 2
以下是日志信息,请大家帮忙看下: 2014-05-07 20:03:57 Commons Daemon procrun stderr initialized 2014-5-7 20:03:59 org.apache.catalina.core.AprLifecycleListener init 信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: E:\search_online\standard-tomcat-6.0.29\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;c:\Ora10InstantClient\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Java\jdk1.6.0_21\lib;C:\Java\jdk1.6.0_21\bin;C:\Program Files\Dell\SysMgt\oma\bin;C:\Program Files\Dell\SysMgt\idrac;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ 2014-5-7 20:03:59 org.apache.catalina.startup.Catalina load 信息: Initialization processed in 761 ms 2014-5-7 20:03:59 org.apache.catalina.core.StandardService start 信息: Starting service EmpSearchPro 2014-5-7 20:03:59 org.apache.catalina.core.StandardEngine start 信息: Starting Servlet Engine: Apache Tomcat/6.0.29 2014-5-7 20:04:00 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring root WebApplicationContext 2014-5-7 20:04:02 org.apache.catalina.startup.HostConfig deployDescriptor 信息: Deploying configuration descriptor host-manager.xml 2014-5-7 20:04:02 org.apache.catalina.startup.HostConfig deployDescriptor 信息: Deploying configuration descriptor manager.xml 2014-5-7 20:04:02 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory docs 2014-5-7 20:04:02 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory examples 2014-5-7 20:04:02 org.apache.catalina.core.ApplicationContext log 信息: ContextListener: contextInitialized() 2014-5-7 20:04:02 org.apache.catalina.core.ApplicationContext log 信息: SessionListener: contextInitialized() 2014-5-7 20:04:02 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory WebQuery 2014-5-7 20:04:03 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring root WebApplicationContext 2014-5-7 20:04:04 org.apache.jk.common.ChannelSocket init 信息: JK: ajp13 listening on /0.0.0.0:8009 2014-5-7 20:04:04 org.apache.jk.server.JkMain start 信息: Jk running ID=0 time=0/78 config=null 2014-5-7 20:04:04 org.apache.catalina.startup.Catalina start 信息: Server startup in 4629 ms 2014-5-8 9:59:06 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 9:59:08 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 9:59:30 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 10:24:51 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 10:24:53 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 10:24:56 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 10:25:11 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 17:43:01 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 17:44:40 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:18:41 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:19:02 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:19:14 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:20:06 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:22:07 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:22:46 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:23:06 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:34:39 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 18:35:24 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 20:00:44 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 20:01:29 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 20:01:57 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 20:02:25 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-8 20:02:52 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 9:35:57 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 10:44:22 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 11:38:34 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 11:38:39 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 12:48:51 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 13:29:28 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 13:30:33 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 13:30:43 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 16:07:07 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 16:07:07 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 16:15:35 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-9 18:22:24 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-10 12:35:22 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-10 13:45:59 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-10 13:48:08 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-10 13:48:38 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-10 13:48:49 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-10 13:49:08 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 13:07:58 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 13:09:47 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 14:32:39 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 14:33:11 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 14:34:14 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 14:34:32 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 14:40:08 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 14:42:42 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 14:43:31 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 14:46:53 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 16:04:39 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 16:06:31 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 16:47:14 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 16:48:04 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 16:49:08 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 16:50:33 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 17:04:46 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 17:05:49 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 17:23:43 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 17:24:52 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 19:01:26 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 19:04:00 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 19:04:01 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 19:04:01 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 19:10:35 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-11 19:11:05 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 10:38:58 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 12:02:52 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 12:03:17 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 15:11:51 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 15:55:16 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 15:55:54 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 15:55:55 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 15:56:20 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 16:29:55 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-12 17:09:33 org.apache.jk.common.ChannelSocket processConnection 警告: processCallbacks status 2 2014-5-13 8:59:49 org.apache.catalina.core.StandardService stop 信息: Stopping service EmpSearchPro 2014-5-13 8:59:49 org.apache.catalina.core.ApplicationContext log 信息: SessionListener: contextDestroyed() 2014-5-13 8:59:49 org.apache.catalina.core.ApplicationContext log 信息: ContextListener: contextDestroyed() 2014-5-13 8:59:50 org.apache.catalina.core.ApplicationContext log 信息: Closing Spring root WebApplicationContext 2014-5-13 8:59:50 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc 严重: The web application [/WebQuery] registered the JBDC driver [oracle.jdbc.driver.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 2014-5-13 8:59:50 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap 严重: The web application [/WebQuery] created a ThreadLocal with key of type [null] (value [com.opensymphony.xwork2.inject.ContainerImpl$10@1ab1379]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@8b8c90]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak. 2014-5-13 8:59:51 org.apache.catalina.core.StandardWrapper unload 信息: Waiting for 538 instance(s) to be deallocated 2014-5-13 8:59:52 org.apache.catalina.core.StandardWrapper unload 信息: Waiting for 538 instance(s) to be deallocated 2014-5-13 8:59:53 org.apache.catalina.core.StandardWrapper unload 信息: Waiting for 538 instance(s) to be deallocated 2014-5-13 8:59:54 org.apache.catalina.core.ApplicationContext log 信息: Closing Spring root WebApplicationContext 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc 严重: The web application [] registered the JBDC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc 严重: The web application [] registered the JBDC driver [oracle.jdbc.driver.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] appears to have started a thread named [AWT-Windows] but has failed to stop it. This is very likely to create a memory leak. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] appears to have started a thread named [Timer-0] but has failed to stop it. This is very likely to create a memory leak. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] but has failed to stop it. This is very likely to create a memory leak. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] but has failed to stop it. This is very likely to create a memory leak. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] but has failed to stop it. This is very likely to create a memory leak. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation. 2014-5-13 8:59:54 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads 严重: The web application [] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation.
MYSQL GROUP BY 获取最小条目
这是表内容 我想要按rq分组,获取每组中mint最小的那一条数据,该如何做? 以下是实验数据:: INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-24 08:30:00', 1349.04, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-16 08:30:00', 1034.16, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-19 08:30:00', 1149.84, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-20 08:30:00', 1190.13, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-23 08:30:00', 1308.88, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-17 08:30:00', 1073.98, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-12 08:30:00', 899.31, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-13 08:30:00', 916.79, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-22 08:30:00', 1269.3, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-21 08:30:00', 1230.12, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-18 08:30:00', 1113.18, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-21 08:25:00', 1229.98, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-17 08:35:00', 1074.12, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-19 08:35:00', 1149.97, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-21 08:35:00', 1230.26, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-13 08:35:00', 916.93, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-13 08:25:00', 916.65, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-23 08:35:00', 1309.03, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-23 08:25:00', 1308.75, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-24 08:25:00', 1348.91, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-20 08:35:00', 1190.26, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-18 08:35:00', 1113.31, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-22 08:25:00', 1269.16, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-12 08:25:00', 899.3, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-12 08:35:00', 899.32, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-18 08:25:00', 1113.06, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-14 08:25:00', 955.3, '2019-12-14'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-17 08:25:00', 1073.84, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-20 08:25:00', 1189.99, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-16 08:25:00', 1034.02, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-15 08:35:00', 995.01, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-19 08:25:00', 1149.7, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-22 08:35:00', 1269.44, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-24 08:35:00', 1349.17, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-19 08:20:00', 1149.57, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-20 08:40:00', 1190.39, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-17 08:40:00', 1074.25, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-23 08:20:00', 1308.61, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-13 08:40:00', 917.08, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-22 08:20:00', 1269.03, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-16 08:20:00', 1033.87, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-19 08:40:00', 1150.12, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-21 08:40:00', 1230.4, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-20 08:20:00', 1189.85, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-18 08:40:00', 1113.43, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-22 08:40:00', 1269.59, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-21 08:20:00', 1229.84, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-12 08:20:00', 899.29, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-12 08:40:00', 899.33, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-17 08:20:00', 1073.83, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-18 08:20:00', 1112.91, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-24 08:20:00', 1348.78, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-23 08:40:00', 1309.18, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-13 08:20:00', 916.52, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-24 08:40:00', 1349.3, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-17 08:15:00', 1073.56, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-22 08:45:00', 1269.73, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-24 08:45:00', 1349.45, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-21 08:45:00', 1230.55, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-13 08:15:00', 916.38, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-20 08:15:00', 1189.72, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-19 08:45:00', 1150.27, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-17 08:45:00', 1074.39, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-21 08:15:00', 1229.71, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-16 08:45:00', 1034.56, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-16 08:15:00', 1033.74, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-15 08:15:00', 994.46, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-18 08:15:00', 1112.77, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-19 08:15:00', 1149.43, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-20 08:45:00', 1190.53, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-23 08:15:00', 1308.47, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-12 08:15:00', 899.28, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-12 08:45:00', 899.34, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-22 08:15:00', 1268.91, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-23 08:45:00', 1309.33, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-13 08:45:00', 917.21, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-18 08:45:00', 1113.56, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-24 08:15:00', 1348.65, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-13 08:50:00', 917.33, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-24 08:50:00', 1349.59, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-16 08:10:00', 1033.59, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-20 08:10:00', 1189.6, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-18 08:10:00', 1112.62, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-22 08:10:00', 1268.79, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-21 08:50:00', 1230.7, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-23 08:10:00', 1308.32, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-19 08:50:00', 1150.42, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-22 08:50:00', 1269.89, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-15 08:10:00', 994.3, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-17 08:50:00', 1074.54, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-21 08:10:00', 1229.58, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-16 08:50:00', 1034.7, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-17 08:10:00', 1073.43, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-24 08:10:00', 1348.52, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-12 08:10:00', 899.27, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-12 08:50:00', 899.35, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-20 08:50:00', 1190.68, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-13 08:10:00', 916.25, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-23 08:50:00', 1309.48, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-18 08:50:00', 1113.71, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-14 08:10:00', 954.84, '2019-12-14'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-19 08:10:00', 1149.29, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-20 08:55:00', 1190.82, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-15 08:05:00', 994.17, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-18 08:55:00', 1113.85, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-22 08:55:00', 1270.03, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-19 08:05:00', 1149.16, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-17 08:55:00', 1074.69, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-20 08:05:00', 1189.47, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-22 08:05:00', 1268.66, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-13 08:05:00', 916.14, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-21 08:55:00', 1230.83, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-24 08:05:00', 1348.39, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-23 08:55:00', 1309.64, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-19 08:55:00', 1150.57, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-16 08:05:00', 1033.45, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-24 08:55:00', 1349.73, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-12 08:05:00', 899.26, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-12 08:55:00', 899.36, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-18 08:05:00', 1112.49, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-13 08:55:00', 917.45, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-17 08:05:00', 1073.29, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-21 08:05:00', 1229.44, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-16 08:55:00', 1034.83, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-23 08:05:00', 1308.17, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-16 08:00:00', 1033.33, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-23 08:00:00', 1308.01, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-17 09:00:00', 1074.83, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-20 09:00:00', 1190.98, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-21 08:00:00', 1229.3, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-15 08:00:00', 994.04, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-21 09:00:00', 1230.96, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-18 08:00:00', 1112.37, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-23 09:00:00', 1309.8, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-19 09:00:00', 1150.71, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-22 08:00:00', 1268.54, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-18 09:00:00', 1114, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-20 08:00:00', 1189.33, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-24 09:00:00', 1349.86, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-12 08:00:00', 899.25, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-22 09:00:00', 1270.16, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-24 08:00:00', 1348.25, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-13 09:00:00', 917.58, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-13 08:00:00', 916.02, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-16 09:00:00', 1034.98, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-19 08:00:00', 1149.02, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-17 08:00:00', 1073.16, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-18 07:55:00', 1112.25, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-18 09:05:00', 1114.14, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-24 09:05:00', 1349.99, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-13 09:05:00', 917.72, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-17 07:55:00', 1073.03, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-15 07:55:00', 993.91, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-20 07:55:00', 1189.2, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-21 07:55:00', 1229.16, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-23 07:55:00', 1307.86, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-22 09:05:00', 1270.29, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-16 09:05:00', 1035.11, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-17 09:05:00', 1074.97, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-20 09:05:00', 1191.13, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-19 09:05:00', 1150.85, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-24 07:55:00', 1348.12, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-12 07:55:00', 899.24, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-22 07:55:00', 1268.4, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-13 07:55:00', 915.9, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-21 09:05:00', 1231.08, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-19 07:55:00', 1148.88, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-23 09:05:00', 1309.96, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-16 07:55:00', 1033.21, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-15 09:10:00', 996.03, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-24 07:50:00', 1347.99, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-23 07:50:00', 1307.71, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-17 07:50:00', 1072.89, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-13 09:10:00', 917.87, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-13 07:50:00', 915.77, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-18 09:10:00', 1114.29, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-20 09:10:00', 1191.26, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-16 09:10:00', 1035.26, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-24 09:10:00', 1350.11, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-19 07:50:00', 1148.74, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-17 09:10:00', 1075.11, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-18 07:50:00', 1112.13, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-15 07:50:00', 993.79, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-22 07:50:00', 1268.26, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-23 09:10:00', 1310.12, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-16 07:50:00', 1033.09, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-21 07:50:00', 1229.03, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-12 07:50:00', 899.22, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-22 09:10:00', 1270.42, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-19 09:10:00', 1151, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-21 09:10:00', 1231.22, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-20 07:50:00', 1189.06, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-17 09:15:00', 1075.24, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-17 07:45:00', 1072.75, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-15 07:45:00', 993.66, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-19 07:45:00', 1148.6, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-21 09:15:00', 1231.36, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-23 07:45:00', 1307.57, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-18 07:45:00', 1111.99, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-18 09:15:00', 1114.43, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-15 09:15:00', 996.08, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-19 09:15:00', 1151.12, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-20 07:45:00', 1188.92, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-21 07:45:00', 1228.9, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-22 07:45:00', 1268.14, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-22 09:15:00', 1270.55, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-12 07:45:00', 899.2, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-24 09:15:00', 1350.23, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-13 09:15:00', 918, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-13 07:45:00', 915.65, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-16 07:45:00', 1032.96, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-20 09:15:00', 1191.39, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-24 07:45:00', 1347.88, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-23 09:15:00', 1310.28, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-23 07:40:00', 1307.42, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-23 09:20:00', 1310.43, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-17 09:20:00', 1075.36, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-13 09:20:00', 918.13, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-13 07:40:00', 915.51, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-17 07:40:00', 1072.61, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-19 09:20:00', 1151.25, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-18 09:20:00', 1114.55, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-20 07:40:00', 1188.78, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-12 07:40:00', 899.15, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-18 07:40:00', 1111.84, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-22 09:20:00', 1270.68, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-24 09:20:00', 1350.37, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-24 07:40:00', 1347.75, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-21 09:20:00', 1231.49, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-22 07:40:00', 1268.01, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-21 07:40:00', 1228.78, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-20 09:20:00', 1191.52, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-15 07:40:00', 993.52, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-16 07:40:00', 1032.83, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-19 07:40:00', 1148.46, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-20 07:35:00', 1188.63, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-23 09:25:00', 1310.57, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-20 09:25:00', 1191.66, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-21 07:35:00', 1228.65, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-18 07:35:00', 1111.7, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-24 07:35:00', 1347.64, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-21 09:25:00', 1231.64, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-14 07:35:00', 953.93, '2019-12-14'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-19 07:35:00', 1148.32, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-23 07:35:00', 1307.27, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-17 07:35:00', 1072.47, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-22 09:25:00', 1270.82, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-12 07:35:00', 899.06, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-19 09:25:00', 1151.39, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-17 09:25:00', 1075.5, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-13 09:25:00', 918.24, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-13 07:35:00', 915.37, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-18 09:25:00', 1114.67, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-16 07:35:00', 1032.69, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-15 07:35:00', 993.39, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-24 09:25:00', 1350.5, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-22 07:35:00', 1267.88, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-24 07:30:00', 1347.51, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-20 07:30:00', 1188.48, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-14 07:30:00', 953.79, '2019-12-14'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-22 09:30:00', 1270.96, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-13 09:30:00', 918.36, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-13 07:30:00', 915.24, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-24 09:30:00', 1350.64, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-21 07:30:00', 1228.52, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-20 09:30:00', 1191.8, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-17 07:30:00', 1072.33, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-23 07:30:00', 1307.11, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-21 09:30:00', 1231.78, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-16 07:30:00', 1032.54, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-15 07:30:00', 993.24, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-18 07:30:00', 1111.56, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-23 09:30:00', 1310.71, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-19 07:30:00', 1148.18, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-12 07:30:00', 898.95, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-22 07:30:00', 1267.74, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-19 09:30:00', 1151.54, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-17 09:30:00', 1075.65, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-18 09:30:00', 1114.8, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-17 07:25:00', 1072.19, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-22 09:35:00', 1271.11, '2019-12-22'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-20 09:35:00', 1191.94, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-17 09:35:00', 1075.8, '2019-12-17'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-14 07:25:00', 953.63, '2019-12-14'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-15 07:25:00', 993.09, '2019-12-15'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-16 07:25:00', 1032.41, '2019-12-16'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-20 07:25:00', 1188.34, '2019-12-20'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-18 07:25:00', 1111.41, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-24 07:25:00', 1347.37, '2019-12-24'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-21 09:35:00', 1231.93, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-23 09:35:00', 1310.85, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-12 07:25:00', 898.84, '2019-12-12'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-19 09:35:00', 1151.69, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-19 07:25:00', 1148.03, '2019-12-19'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-21 07:25:00', 1228.38, '2019-12-21'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-13 09:35:00', 918.5, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-13 07:25:00', 915.11, '2019-12-13'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-18 09:35:00', 1114.94, '2019-12-18'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-23 07:25:00', 1306.96, '2019-12-23'); INSERT INTO ``(`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-22 07:25:00', 1267.6, '2019-12-22');
Ubuntu安装Mysql启动出错
小弟刚刚接触Linux,想安装一个mysql,按照这个步骤尝试安装[http://jingyan.baidu.com/article/4f7d5712d5f8181a2019270e.html](http://jingyan.baidu.com/article/4f7d5712d5f8181a2019270e.html ""),结果最后服务启动不了。 输入systemctl status mysql.service命令查看的时候显示 mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: enabled) Active: deactivating (final-sigterm) (Result: exit-code) Process: 17564 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE) CGroup: /system.slice/mysql.service └─17566 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/my... Nov 20 06:51:35 ubuntu mysqld[17564]: 2016-11-20T14:51:35.520393Z 0 [Note] ...d. Nov 20 06:51:35 ubuntu mysqld[17564]: mysqld: Table 'mysql.plugin' doesn't exist Nov 20 06:51:35 ubuntu mysqld[17564]: 2016-11-20T14:51:35.520736Z 0 [ERROR]...t. Nov 20 06:51:35 ubuntu mysqld[17564]: 2016-11-20T14:51:35.521871Z 0 [Warnin...d. Nov 20 06:51:35 ubuntu mysqld[17564]: 2016-11-20T14:51:35.522009Z 0 [Warnin...ey Nov 20 06:51:35 ubuntu mysqld[17564]: 2016-11-20T14:51:35.523079Z 0 [Note] ...06 Nov 20 06:51:35 ubuntu mysqld[17564]: 2016-11-20T14:51:35.523154Z 0 [Note] ...e. Nov 20 06:51:35 ubuntu mysqld[17564]: 2016-11-20T14:51:35.523182Z 0 [Note] ...'; Nov 20 06:51:35 ubuntu mysqld[17564]: 2016-11-20T14:51:35.523352Z 0 [Note] ...'. Nov 20 06:51:35 ubuntu systemd[1]: mysql.service: Control process exited, c...=1 Hint: Some lines were ellipsized, use -l to show in full. 输入journalctl -xe命令显示 -- Subject: Unit mysql.service has finished shutting down -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has finished shutting down. Nov 20 07:10:32 ubuntu systemd[1]: Starting MySQL Community Server... -- Subject: Unit mysql.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has begun starting up. Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.122479Z 0 [Warning] TI Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.124201Z 0 [Note] /usr/ Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.127834Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.127858Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.127864Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.127869Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.127874Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.127879Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.128131Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.128221Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.129445Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.139914Z 0 [Note] InnoD Nov 20 07:10:33 ubuntu mysqld[32270]: 2016-11-20T15:10:33.141532Z 0 [Note] InnoD 请各位大牛帮忙看看怎么回事,不胜感激!
linux执行jar包报Caused by: com.mysql.cj.exceptions.CJException: Access denied for user 'root'@'root' (using password: YES)错误
我用idea创建一个spring boot项目本地执行application可以运行程序。 但是项目打成jar包后放入linux中用 java -jar执行报错,报错情况如下: [ERROR] 2019-09-28 13:10:36,293 method:com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1846) create connection error 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:110) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:897) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1375) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1431) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1844) Caused by: com.mysql.cj.exceptions.CJException: Access denied for user 'root'@'root' (using password: YES) at sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:129) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:795) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:720) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:688) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:130) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:540) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202) at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1348) at com.mysql.cj.NativeSession.connect(NativeSession.java:163) at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:841) ... 7 more [ERROR] 2019-09-28 13:10:40,298 method:com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1846) create connection error 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:110) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:897) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1375) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1431) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1844) Caused by: com.mysql.cj.exceptions.CJException: Access denied for user 'root'@'root' (using password: YES) at sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:129) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:795) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:720) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:688) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:130) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:540) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202) at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1348) at com.mysql.cj.NativeSession.connect(NativeSession.java:163) at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:841) ... 7 more
怎么查看maven的pom.xml是否成功下载了所需jar包
## 如题,pom.xml动不动就要报错,不知道是不是因为没有成功下载jar的原因? ![图片说明](https://img-ask.csdn.net/upload/201606/23/1466666764_888875.jpg) Multiple annotations found at this line: - Missing artifact org.apache.maven:maven-artifact:jar:2.0.6:compile - Missing artifact org.apache.maven.shared:maven-filtering:jar:1.0-beta-4:compile - Missing artifact org.apache.maven:maven-profile:jar:2.0.6:compile - Missing artifact org.apache.maven.reporting:maven-reporting-api:jar: 2.0.6:compile - Missing artifact org.apache.maven:maven-plugin-descriptor:jar:2.0.6:compile - Missing artifact org.apache.maven.wagon:wagon-ssh:jar:1.0-beta-2:runtime - Missing artifact org.apache.maven.wagon:wagon-ssh-external:jar:1.0- beta-2:runtime - Missing artifact org.apache.maven:maven-artifact-manager:jar:2.0.6:compile - Missing artifact org.apache.maven:maven-plugin-registry:jar:2.0.6:compile - Missing artifact org.apache.maven:maven-project:jar:2.0.6:compile - Missing artifact org.apache.maven:maven-plugin-api:jar:2.0.6:compile - Missing artifact org.codehaus.plexus:plexus-utils:jar:2.0.5:compile - Missing artifact com.jcraft:jsch:jar:0.1.27:runtime - Missing artifact commons-cli:commons-cli:jar:1.0:compile - Missing artifact org.apache.maven.wagon:wagon-ssh-common:jar:1.0- beta-2:runtime - Missing artifact org.codehaus.plexus:plexus-interactivity-api:jar:1.0- alpha-4:compile - Missing artifact org.wisdom-framework:mysql-connector-java:jar:5.1.34_1:compile - Failed to read artifact descriptor for org.wisdom-framework:abstract-jdbc- driver:jar:0.5 - Missing artifact org.apache.maven.wagon:wagon-file:jar:1.0-beta-2:runtime - Missing artifact org.sonatype.plexus:plexus-build-api:jar:0.0.4:compile - Missing artifact classworlds:classworlds:jar:1.1:compile - Missing artifact org.apache.maven.plugins:maven-resources-plugin:jar: 2.4.3:compile - Missing artifact org.apache.felix:org.apache.felix.ipojo.annotations:jar: 1.12.1:compile - Missing artifact org.codehaus.plexus:plexus-interpolation:jar:1.13:compile - Missing artifact org.apache.maven.wagon:wagon-provider-api:jar:1.0- beta-2:compile - Missing artifact org.apache.maven:maven-monitor:jar:2.0.6:compile - Missing artifact xml-apis:xml-apis:jar:1.0.b2:runtime - Missing artifact org.apache.maven.wagon:wagon-http-shared:jar:1.0- beta-2:runtime - Missing artifact jtidy:jtidy:jar:4aug2000r7-dev:runtime - Missing artifact org.apache.maven:maven-core:jar:2.0.6:compile - Missing artifact org.apache.maven:maven-settings:jar:2.0.6:compile - Missing artifact org.apache.maven:maven-model:jar:2.0.6:compile - Missing artifact org.apache.maven.doxia:doxia-sink-api:jar:1.0-alpha-7:compile - Missing artifact org.apache.maven.wagon:wagon-http-lightweight:jar:1.0- beta-2:runtime - Missing artifact org.apache.maven:maven-repository-metadata:jar:2.0.6:compile - Missing artifact org.apache.maven:maven-error-diagnostics:jar:2.0.6:compile - Missing artifact org.codehaus.plexus:plexus-container-default:jar:1.0-alpha-9- stable-1:compile - Missing artifact junit:junit:jar:3.8.1:test - Missing artifact org.apache.maven:maven-plugin-parameter-documenter:jar: 2.0.6:compile
java项目在本地上运行无问题,打war包到服务器上,部分功能有问题
tomcat日志: 23-Nov-2017 00:49:07.772 INFO [main] org.apache.catalina.core.StandardServer.await A valid shutdown command was received via the shutdown port. Stopping the Server instance. 23-Nov-2017 00:49:07.773 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-8080"] 23-Nov-2017 00:49:07.824 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["ajp-nio-8009"] 23-Nov-2017 00:49:07.874 INFO [main] org.apache.catalina.core.StandardService.stopInternal Stopping service Catalina 23-Nov-2017 00:49:08.461 WARNING [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [MaintainSystem] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 23-Nov-2017 00:49:08.462 WARNING [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [MaintainSystem] appears to have started a thread named [FileWatchdog] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.lang.Thread.sleep(Native Method) org.apache.log4j.helpers.FileWatchdog.run(FileWatchdog.java:104) 23-Nov-2017 00:49:08.462 WARNING [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [MaintainSystem] appears to have started a thread named [cluster-ClusterId{value='5a1593f852e92b26c5f5d86c', description='null'}-192.168.7.178:27017] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.net.PlainSocketImpl.socketConnect(Native Method) java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) java.net.Socket.connect(Socket.java:589) com.mongodb.connection.SocketStreamHelper.initialize(SocketStreamHelper.java:50) com.mongodb.connection.SocketStream.open(SocketStream.java:58) com.mongodb.connection.InternalStreamConnection.open(InternalStreamConnection.java:114) com.mongodb.connection.DefaultServerMonitor$ServerMonitorRunnable.run(DefaultServerMonitor.java:128) java.lang.Thread.run(Thread.java:745) 23-Nov-2017 00:49:08.463 WARNING [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [MaintainSystem] appears to have started a thread named [Thread-5] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.lang.Thread.sleep(Native Method) com.xd.util.DatabaseCleaner.run(DatabaseCleaner.java:50) 23-Nov-2017 00:49:08.480 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["http-nio-8080"] 23-Nov-2017 00:49:08.490 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["ajp-nio-8009"] 23-Nov-2017 00:49:08.589 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-8080"] 23-Nov-2017 00:49:08.591 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["ajp-nio-8009"] 23-Nov-2017 00:49:21.473 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.0.20 23-Nov-2017 00:49:21.475 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Feb 15 2015 18:10:42 UTC 23-Nov-2017 00:49:21.475 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.0.20.0 23-Nov-2017 00:49:21.475 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux 23-Nov-2017 00:49:21.475 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 2.6.32-573.el6.x86_64 23-Nov-2017 00:49:21.475 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 23-Nov-2017 00:49:21.475 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /home/dabai/jdk1.8.0_91/jre 23-Nov-2017 00:49:21.475 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_91-b14 23-Nov-2017 00:49:21.476 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation 23-Nov-2017 00:49:21.476 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /home/dabai/apache-tomcat-8.0.20 23-Nov-2017 00:49:21.476 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /home/dabai/apache-tomcat-8.0.20 23-Nov-2017 00:49:21.476 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/home/dabai/apache-tomcat-8.0.20/conf/logging.properties 23-Nov-2017 00:49:21.477 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 23-Nov-2017 00:49:21.477 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=/home/dabai/apache-tomcat-8.0.20/endorsed 23-Nov-2017 00:49:21.477 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/home/dabai/apache-tomcat-8.0.20 23-Nov-2017 00:49:21.477 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/home/dabai/apache-tomcat-8.0.20 23-Nov-2017 00:49:21.478 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/home/dabai/apache-tomcat-8.0.20/temp 23-Nov-2017 00:49:21.478 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib 23-Nov-2017 00:49:21.607 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"] 23-Nov-2017 00:49:21.621 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 23-Nov-2017 00:49:21.624 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"] 23-Nov-2017 00:49:21.625 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 23-Nov-2017 00:49:21.626 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 632 ms 23-Nov-2017 00:49:21.658 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina 23-Nov-2017 00:49:21.658 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.20 23-Nov-2017 00:49:21.681 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive /home/dabai/apache-tomcat-8.0.20/webapps/MaintainSystem.war 23-Nov-2017 00:50:06.881 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive /home/dabai/apache-tomcat-8.0.20/webapps/MaintainSystem.war has finished in 45,198 ms 23-Nov-2017 00:50:06.882 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /home/dabai/apache-tomcat-8.0.20/webapps/examples 23-Nov-2017 00:50:07.077 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /home/dabai/apache-tomcat-8.0.20/webapps/examples has finished in 195 ms 23-Nov-2017 00:50:07.078 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /home/dabai/apache-tomcat-8.0.20/webapps/manager 23-Nov-2017 00:50:07.103 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /home/dabai/apache-tomcat-8.0.20/webapps/manager has finished in 25 ms 23-Nov-2017 00:50:07.104 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /home/dabai/apache-tomcat-8.0.20/webapps/host-manager 23-Nov-2017 00:50:07.132 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /home/dabai/apache-tomcat-8.0.20/webapps/host-manager has finished in 28 ms 23-Nov-2017 00:50:07.133 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /home/dabai/apache-tomcat-8.0.20/webapps/docs 23-Nov-2017 00:50:07.156 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /home/dabai/apache-tomcat-8.0.20/webapps/docs has finished in 23 ms 23-Nov-2017 00:50:07.157 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory /home/dabai/apache-tomcat-8.0.20/webapps/ROOT 23-Nov-2017 00:50:07.177 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory /home/dabai/apache-tomcat-8.0.20/webapps/ROOT has finished in 19 ms 23-Nov-2017 00:50:07.185 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"] 23-Nov-2017 00:50:07.198 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"] 23-Nov-2017 00:50:07.201 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 45574 ms web项目运行后,报错提示: Failed to load resource: the server responded with a status of 500 (Internal Server Error) saveOpMiInfo.do?urlCode=49D4:75 Uncaught ReferenceError: maxlengthBind is not defined at saveOpMiInfo.do?urlCode=49D4:75 saveOpMiInfo.do Failed to load resource: the server responded with a status of 500 (Internal Server Error)
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
问题描述: 应用程序部署后运行正常,运行一段时间后,调用某个服务后,就出现如下的报错,重启后又正常 ``` 2019-09-25 17:11:17.686 ERROR 2072 --- [http-nio-801-exec-12] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 20, maxActive 20, creating 0 ### The error may exist in cn/stylefeng/guns/modular/mall/mapper/SetHskLevelMapper.java (best guess) ### The error may involve cn.stylefeng.guns.modular.mall.mapper.SetHskLevelMapper.selectOne ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 20, maxActive 20, creating 0] with root cause com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 20, maxActive 20, creating 0 at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1536) at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1272) at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5007) at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:680) at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5003) at com.alibaba.druid.filter.FilterAdapter.dataSource_getConnection(FilterAdapter.java:2745) at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5003) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1250) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1242) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:89) at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at com.alibaba.druid.support.spring.stat.DruidStatInterceptor.invoke(DruidStatInterceptor.java:72) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) at com.sun.proxy.$Proxy93.getConnection(Unknown Source) at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82) at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68) at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:338) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:84) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy180.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) at com.sun.proxy.$Proxy97.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166) at com.baomidou.mybatisplus.core.override.PageMapperMethod.execute(PageMapperMethod.java:101) at com.baomidou.mybatisplus.core.override.PageMapperProxy.invoke(PageMapperProxy.java:64) at com.sun.proxy.$Proxy129.selectOne(Unknown Source) at cn.stylefeng.guns.modular.mall.service.SetHskLevelService.model(SetHskLevelService.java:25) at cn.stylefeng.guns.modular.mall.service.SetHskLevelService$$FastClassBySpringCGLIB$$5431aaeb.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at com.alibaba.druid.support.spring.stat.DruidStatInterceptor.invoke(DruidStatInterceptor.java:72) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) at cn.stylefeng.guns.modular.mall.service.SetHskLevelService$$EnhancerBySpringCGLIB$$ead2cf8a.model(<generated>) at cn.stylefeng.guns.modular.mall.api.HskController.getHskLevel(HskController.java:1039) at cn.stylefeng.guns.modular.mall.api.HskController.getListenTotalReport(HskController.java:711) at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at cn.stylefeng.roses.core.xss.XssFilter.doFilter(XssFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:791) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) ```
在做一个淘淘商城的项目,出现了子项目pom.xml报错的问题
子项目pom.xml区 ``` <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>cn.itcast.parent</groupId> <artifactId>itcast-parent</artifactId> <version>0.0.1-SNAPSHOT</version> </parent> <groupId>cn.itcast.usermanage</groupId> <artifactId>itcast-usermanage</artifactId> <version>1.0.0-SNAPSHOT</version> <packaging>war</packaging> <dependencies> <!-- 单元测试 --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aspects</artifactId> </dependency> <!-- Mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> </dependency> <!-- MySql --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> </dependency> <!-- Jackson Json处理工具包 --> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> </dependency> <!-- 连接池 --> <dependency> <groupId>com.jolbox</groupId> <artifactId>bonecp-spring</artifactId> </dependency> <!-- JSP相关 --> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jsp-api</artifactId> <scope>provided</scope> </dependency> <!-- Apache工具组件 --> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-lang3</artifactId> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-io</artifactId> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> </dependency> <dependency> <groupId>com.github.jsqlparser</groupId> <artifactId>jsqlparser</artifactId> </dependency> <dependency> <groupId>com.github.abel533</groupId> <artifactId>mapper</artifactId> </dependency> </dependencies> <build> <plugins> <!-- 配置Tomcat插件 --> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <configuration> <port>80</port> <!-- http://127.0.0.1:{port}/{path} --> <path>/</path> </configuration> </plugin> </plugins> </build> </project> ``` 报错问题代码区: ``` Multiple annotations found at this line: - Execution default-resources of goal org.apache.maven.plugins:maven-resources-plugin:2.7:resources failed: Plugin org.apache.maven.plugins:maven-resources-plugin:2.7 or one of its dependencies could not be resolved: The following artifacts could not be resolved: org.apache.maven.doxia:doxia-sink-api:jar:1.1, org.apache.maven.doxia:doxia-logging-api:jar:1.1, org.apache.maven:maven-repository-metadata:jar:2.2.1, org.apache.maven:maven-error-diagnostics:jar:2.2.1, org.apache.maven:maven- plugin-descriptor:jar:2.2.1, org.sonatype.plexus:plexus-sec-dispatcher:jar:1.3, org.sonatype.plexus:plexus-cipher:jar:1.4, org.apache.maven:maven-settings:jar:2.2.1, org.apache.maven:maven-monitor:jar:2.2.1: Failure to transfer org.apache.maven.doxia:doxia- sink-api:jar:1.1 from http://maven.aliyun.com/nexus/content/repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/content/repositories/central/): The operation was cancelled. (org.apache.maven.plugins:maven-resources-plugin:2.7:resources:default-resources:process-resources) org.apache.maven.plugin.PluginExecutionException: Execution default-resources of goal org.apache.maven.plugins:maven-resources- plugin:2.7:resources failed: Plugin org.apache.maven.plugins:maven-resources-plugin:2.7 or one of its dependencies could not be resolved: The following artifacts could not be resolved: org.apache.maven.doxia:doxia-sink-api:jar:1.1, org.apache.maven.doxia:doxia- logging-api:jar:1.1, org.apache.maven:maven-repository-metadata:jar:2.2.1, org.apache.maven:maven-error-diagnostics:jar:2.2.1, org.apache.maven:maven-plugin-descriptor:jar:2.2.1, org.sonatype.plexus:plexus-sec-dispatcher:jar:1.3, org.sonatype.plexus:plexus- cipher:jar:1.4, org.apache.maven:maven-settings:jar:2.2.1, org.apache.maven:maven-monitor:jar:2.2.1: Failure to transfer org.apache.maven.doxia:doxia-sink-api:jar:1.1 from http://maven.aliyun.com/nexus/content/repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/content/ repositories/central/): The operation was cancelled. at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:109) at org.eclipse.m2e.core.internal.embedder.MavenImpl.execute(MavenImpl.java:331) at org.eclipse.m2e.core.internal.embedder.MavenImpl.lambda$7(MavenImpl.java:1342) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.executeBare(MavenExecutionContext.java:177) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.execute(MavenExecutionContext.java:112) at org.eclipse.m2e.core.internal.embedder.MavenImpl.execute(MavenImpl.java:1341) at org.eclipse.m2e.core.project.configurator.MojoExecutionBuildParticipant.build(MojoExecutionBuildParticipant.java:52) at org.eclipse.m2e.core.internal.builder.MavenBuilderImpl.build(MavenBuilderImpl.java:137) at org.eclipse.m2e.core.internal.builder.MavenBuilder$1.method(MavenBuilder.java:173) at org.eclipse.m2e.core.internal.builder.MavenBuilder$1.method(MavenBuilder.java:1) at org.eclipse.m2e.core.internal.builder.MavenBuilder$BuildMethod$1$1.call(MavenBuilder.java:116) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.executeBare(MavenExecutionContext.java:177) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.execute(MavenExecutionContext.java:112) at org.eclipse.m2e.core.internal.builder.MavenBuilder$BuildMethod$1.call(MavenBuilder.java:106) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.executeBare(MavenExecutionContext.java:177) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.execute(MavenExecutionContext.java:151) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.execute(MavenExecutionContext.java:99) at org.eclipse.m2e.core.internal.builder.MavenBuilder$BuildMethod.execute(MavenBuilder.java:87) at org.eclipse.m2e.core.internal.builder.MavenBuilder.build(MavenBuilder.java:201) at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:833) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java: 45) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:220) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:263) at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:316) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java: 45) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:319) at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:371) at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:392) at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:154) at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:244) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: org.apache.maven.plugin.PluginResolutionException: Plugin org.apache.maven.plugins:maven-resources-plugin:2.7 or one of its dependencies could not be resolved: The following artifacts could not be resolved: org.apache.maven.doxia:doxia-sink-api:jar:1.1, org.apache.maven.doxia:doxia-logging-api:jar:1.1, org.apache.maven:maven-repository-metadata:jar:2.2.1, org.apache.maven:maven- error-diagnostics:jar:2.2.1, org.apache.maven:maven-plugin-descriptor:jar:2.2.1, org.sonatype.plexus:plexus-sec-dispatcher:jar:1.3, org.sonatype.plexus:plexus-cipher:jar:1.4, org.apache.maven:maven-settings:jar:2.2.1, org.apache.maven:maven-monitor:jar:2.2.1: Failure to transfer org.apache.maven.doxia:doxia-sink-api:jar:1.1 from http://maven.aliyun.com/nexus/content/repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/ content/repositories/central/): The operation was cancelled. at org.apache.maven.plugin.internal.DefaultPluginDependenciesResolver.resolveInternal(DefaultPluginDependenciesResolver.java:218) at org.apache.maven.plugin.internal.DefaultPluginDependenciesResolver.resolve(DefaultPluginDependenciesResolver.java:149) at org.eclipse.m2e.core.internal.project.registry.EclipsePluginDependenciesResolver.resolve(EclipsePluginDependenciesResolver.java:59) at org.apache.maven.plugin.internal.DefaultMavenPluginManager.createPluginRealm(DefaultMavenPluginManager.java:402) at org.apache.maven.plugin.internal.DefaultMavenPluginManager.setupPluginRealm(DefaultMavenPluginManager.java:374) at org.apache.maven.plugin.DefaultBuildPluginManager.getPluginRealm(DefaultBuildPluginManager.java:234) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:105) ... 30 more Caused by: org.eclipse.aether.resolution.ArtifactResolutionException: The following artifacts could not be resolved: org.apache.maven.doxia:doxia- sink-api:jar:1.1, org.apache.maven.doxia:doxia-logging-api:jar:1.1, org.apache.maven:maven-repository-metadata:jar:2.2.1, org.apache.maven:maven-error-diagnostics:jar:2.2.1, org.apache.maven:maven-plugin-descriptor:jar:2.2.1, org.sonatype.plexus:plexus- sec-dispatcher:jar:1.3, org.sonatype.plexus:plexus-cipher:jar:1.4, org.apache.maven:maven-settings:jar:2.2.1, org.apache.maven:maven- monitor:jar:2.2.1: Failure to transfer org.apache.maven.doxia:doxia-sink-api:jar:1.1 from http://maven.aliyun.com/nexus/content/ repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/content/repositories/central/): The operation was cancelled. at org.eclipse.aether.internal.impl.DefaultArtifactResolver.resolve(DefaultArtifactResolver.java:422) at org.eclipse.aether.internal.impl.DefaultArtifactResolver.resolveArtifacts(DefaultArtifactResolver.java:224) at org.eclipse.aether.internal.impl.DefaultRepositorySystem.resolveDependencies(DefaultRepositorySystem.java:338) at org.apache.maven.plugin.internal.DefaultPluginDependenciesResolver.resolveInternal(DefaultPluginDependenciesResolver.java:210) ... 36 more Caused by: org.eclipse.aether.transfer.ArtifactTransferException: Failure to transfer org.apache.maven.doxia:doxia-sink-api:jar: 1.1 from http://maven.aliyun.com/nexus/content/repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/content/repositories/central/): The operation was cancelled. at org.eclipse.aether.internal.impl.DefaultUpdateCheckManager.newException(DefaultUpdateCheckManager.java:240) at org.eclipse.aether.internal.impl.DefaultUpdateCheckManager.checkArtifact(DefaultUpdateCheckManager.java:208) at org.eclipse.aether.internal.impl.DefaultArtifactResolver.gatherDownloads(DefaultArtifactResolver.java:563) at org.eclipse.aether.internal.impl.DefaultArtifactResolver.performDownloads(DefaultArtifactResolver.java:481) at org.eclipse.aether.internal.impl.DefaultArtifactResolver.resolve(DefaultArtifactResolver.java:399) ... 39 more - Execution default-testResources of goal org.apache.maven.plugins:maven-resources-plugin:2.7:testResources failed: Plugin org.apache.maven.plugins:maven-resources-plugin:2.7 or one of its dependencies could not be resolved: The following artifacts could not be resolved: org.apache.maven.doxia:doxia-sink-api:jar:1.1, org.apache.maven.doxia:doxia-logging-api:jar:1.1, org.apache.maven:maven-repository-metadata:jar:2.2.1, org.apache.maven:maven-error-diagnostics:jar:2.2.1, org.apache.maven:maven- plugin-descriptor:jar:2.2.1, org.sonatype.plexus:plexus-sec-dispatcher:jar:1.3, org.sonatype.plexus:plexus-cipher:jar:1.4, org.apache.maven:maven-settings:jar:2.2.1, org.apache.maven:maven-monitor:jar:2.2.1: Failure to transfer org.apache.maven.doxia:doxia- sink-api:jar:1.1 from http://maven.aliyun.com/nexus/content/repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/content/repositories/central/): The operation was cancelled. (org.apache.maven.plugins:maven-resources-plugin:2.7:testResources:default-testResources:process-test- resources) org.apache.maven.plugin.PluginExecutionException: Execution default-testResources of goal org.apache.maven.plugins:maven-resources-plugin:2.7:testResources failed: Plugin org.apache.maven.plugins:maven-resources-plugin: 2.7 or one of its dependencies could not be resolved: The following artifacts could not be resolved: org.apache.maven.doxia:doxia-sink- api:jar:1.1, org.apache.maven.doxia:doxia-logging-api:jar:1.1, org.apache.maven:maven-repository-metadata:jar:2.2.1, org.apache.maven:maven-error-diagnostics:jar:2.2.1, org.apache.maven:maven-plugin-descriptor:jar:2.2.1, org.sonatype.plexus:plexus- sec-dispatcher:jar:1.3, org.sonatype.plexus:plexus-cipher:jar:1.4, org.apache.maven:maven-settings:jar:2.2.1, org.apache.maven:maven- monitor:jar:2.2.1: Failure to transfer org.apache.maven.doxia:doxia-sink-api:jar:1.1 from http://maven.aliyun.com/nexus/content/ repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/content/repositories/central/): The operation was cancelled. at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:109) at org.eclipse.m2e.core.internal.embedder.MavenImpl.execute(MavenImpl.java:331) at org.eclipse.m2e.core.internal.embedder.MavenImpl.lambda$7(MavenImpl.java:1342) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.executeBare(MavenExecutionContext.java:177) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.execute(MavenExecutionContext.java:112) at org.eclipse.m2e.core.internal.embedder.MavenImpl.execute(MavenImpl.java:1341) at org.eclipse.m2e.core.project.configurator.MojoExecutionBuildParticipant.build(MojoExecutionBuildParticipant.java:52) at org.eclipse.m2e.core.internal.builder.MavenBuilderImpl.build(MavenBuilderImpl.java:137) at org.eclipse.m2e.core.internal.builder.MavenBuilder$1.method(MavenBuilder.java:173) at org.eclipse.m2e.core.internal.builder.MavenBuilder$1.method(MavenBuilder.java:1) at org.eclipse.m2e.core.internal.builder.MavenBuilder$BuildMethod$1$1.call(MavenBuilder.java:116) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.executeBare(MavenExecutionContext.java:177) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.execute(MavenExecutionContext.java:112) at org.eclipse.m2e.core.internal.builder.MavenBuilder$BuildMethod$1.call(MavenBuilder.java:106) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.executeBare(MavenExecutionContext.java:177) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.execute(MavenExecutionContext.java:151) at org.eclipse.m2e.core.internal.embedder.MavenExecutionContext.execute(MavenExecutionContext.java:99) at org.eclipse.m2e.core.internal.builder.MavenBuilder$BuildMethod.execute(MavenBuilder.java:87) at org.eclipse.m2e.core.internal.builder.MavenBuilder.build(MavenBuilder.java:201) at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:833) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java: 45) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:220) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:263) at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:316) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java: 45) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:319) at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:371) at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:392) at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:154) at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:244) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: org.apache.maven.plugin.PluginResolutionException: Plugin org.apache.maven.plugins:maven-resources-plugin:2.7 or one of its dependencies could not be resolved: The following artifacts could not be resolved: org.apache.maven.doxia:doxia-sink-api:jar:1.1, org.apache.maven.doxia:doxia-logging-api:jar:1.1, org.apache.maven:maven-repository-metadata:jar:2.2.1, org.apache.maven:maven- error-diagnostics:jar:2.2.1, org.apache.maven:maven-plugin-descriptor:jar:2.2.1, org.sonatype.plexus:plexus-sec-dispatcher:jar:1.3, org.sonatype.plexus:plexus-cipher:jar:1.4, org.apache.maven:maven-settings:jar:2.2.1, org.apache.maven:maven-monitor:jar:2.2.1: Failure to transfer org.apache.maven.doxia:doxia-sink-api:jar:1.1 from http://maven.aliyun.com/nexus/content/repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/ content/repositories/central/): The operation was cancelled. at org.apache.maven.plugin.internal.DefaultPluginDependenciesResolver.resolveInternal(DefaultPluginDependenciesResolver.java:218) at org.apache.maven.plugin.internal.DefaultPluginDependenciesResolver.resolve(DefaultPluginDependenciesResolver.java:149) at org.eclipse.m2e.core.internal.project.registry.EclipsePluginDependenciesResolver.resolve(EclipsePluginDependenciesResolver.java:59) at org.apache.maven.plugin.internal.DefaultMavenPluginManager.createPluginRealm(DefaultMavenPluginManager.java:402) at org.apache.maven.plugin.internal.DefaultMavenPluginManager.setupPluginRealm(DefaultMavenPluginManager.java:374) at org.apache.maven.plugin.DefaultBuildPluginManager.getPluginRealm(DefaultBuildPluginManager.java:234) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:105) ... 30 more Caused by: org.eclipse.aether.resolution.ArtifactResolutionException: The following artifacts could not be resolved: org.apache.maven.doxia:doxia- sink-api:jar:1.1, org.apache.maven.doxia:doxia-logging-api:jar:1.1, org.apache.maven:maven-repository-metadata:jar:2.2.1, org.apache.maven:maven-error-diagnostics:jar:2.2.1, org.apache.maven:maven-plugin-descriptor:jar:2.2.1, org.sonatype.plexus:plexus- sec-dispatcher:jar:1.3, org.sonatype.plexus:plexus-cipher:jar:1.4, org.apache.maven:maven-settings:jar:2.2.1, org.apache.maven:maven- monitor:jar:2.2.1: Failure to transfer org.apache.maven.doxia:doxia-sink-api:jar:1.1 from http://maven.aliyun.com/nexus/content/ repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/content/repositories/central/): The operation was cancelled. at org.eclipse.aether.internal.impl.DefaultArtifactResolver.resolve(DefaultArtifactResolver.java:422) at org.eclipse.aether.internal.impl.DefaultArtifactResolver.resolveArtifacts(DefaultArtifactResolver.java:224) at org.eclipse.aether.internal.impl.DefaultRepositorySystem.resolveDependencies(DefaultRepositorySystem.java:338) at org.apache.maven.plugin.internal.DefaultPluginDependenciesResolver.resolveInternal(DefaultPluginDependenciesResolver.java:210) ... 36 more Caused by: org.eclipse.aether.transfer.ArtifactTransferException: Failure to transfer org.apache.maven.doxia:doxia-sink-api:jar: 1.1 from http://maven.aliyun.com/nexus/content/repositories/central/ was cached in the local repository, resolution will not be reattempted until the update interval of alimaven has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.maven.doxia:doxia-sink-api:jar:1.1 from/to alimaven (http://maven.aliyun.com/nexus/content/repositories/central/): The operation was cancelled. at org.eclipse.aether.internal.impl.DefaultUpdateCheckManager.newException(DefaultUpdateCheckManager.java:240) at org.eclipse.aether.internal.impl.DefaultUpdateCheckManager.checkArtifact(DefaultUpdateCheckManager.java:208) at org.eclipse.aether.internal.impl.DefaultArtifactResolver.gatherDownloads(DefaultArtifactResolver.java:563) at org.eclipse.aether.internal.impl.DefaultArtifactResolver.performDownloads(DefaultArtifactResolver.java:481) at org.eclipse.aether.internal.impl.DefaultArtifactResolver.resolve(DefaultArtifactResolver.java:399) ... 39 more ```
安装eclipse出错log,什么原因
[2019-08-25 21:28:31] Executing bootstrap tasks [2019-08-25 21:28:31] Java(TM) SE Runtime Environment 12.0.2+10 [2019-08-25 21:28:31] Product org.eclipse.products.epp.package.jee.2019-06 [2019-08-25 21:28:31] Bundle org.eclipse.oomph.setup 1.13.0.v20190530-1228, build=4030, branch=ed8d2fdcc99c1d3461399fc1bee02645433fa697 [2019-08-25 21:28:31] Bundle org.eclipse.oomph.setup.core 1.13.0.v20190531-1228, build=4030, branch=ed8d2fdcc99c1d3461399fc1bee02645433fa697 [2019-08-25 21:28:31] Bundle org.eclipse.oomph.setup.p2 1.11.0.v20190530-1228, build=4030, branch=ed8d2fdcc99c1d3461399fc1bee02645433fa697 [2019-08-25 21:28:31] Performing P2 Director (Eclipse IDE for Enterprise Java Developers (2019-06)) [2019-08-25 21:28:31] Offline = false [2019-08-25 21:28:31] Mirrors = true [2019-08-25 21:28:31] Resolving 89 requirements from 3 repositories to E:\eclipse\eclipse\eclipse [2019-08-25 21:28:31] Requirement epp.package.jee [4.12.0,5.0.0) [2019-08-25 21:28:31] Requirement org.eclipse.platform.feature.group [4.12.0,5.0.0) [2019-08-25 21:28:31] Requirement org.eclipse.rcp.feature.group [4.12.0,5.0.0) [2019-08-25 21:28:31] Requirement org.eclipse.buildship.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.cft.server.core.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.cft.server.ui.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.common.doc.user.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.connectivity.doc.user.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.connectivity.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.connectivity.oda.designer.core.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.connectivity.oda.designer.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.connectivity.oda.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.doc.user.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.apache.derby.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.hsqldb.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.ibm.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.ingres.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.jdbc.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.jdt.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.msft.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.mysql.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.oda.designer.feature.feature.group [2019-08-25 21:28:31] Requirement org.eclipse.datatools.enablement.oda.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.enablement.oracle.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.enablement.postgresql.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.enablement.sap.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.enablement.sdk.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.enablement.sqlite.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.enablement.sybase.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.intro.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.modelbase.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sdk.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqldevtools.data.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqldevtools.ddl.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqldevtools.ddlgen.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqldevtools.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqldevtools.parsers.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqldevtools.results.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqldevtools.schemaobjecteditor.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqldevtools.sqlbuilder.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.datatools.sqltools.doc.user.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.eclemma.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.egit.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.egit.mylyn.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.epp.mpc.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jdt.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jpt.common.eclipselink.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jpt.common.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jpt.jaxb.eclipselink.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jpt.jaxb.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jpt.jpa.eclipselink.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jpt.jpa.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jsf.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.common.fproj.enablement.jdt.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.enterprise_ui.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.jsf.apache.trinidad.tagsupport.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.server_adapters.ext.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.server_adapters.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.server_ui.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.web_ui.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.webpageeditor.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.ws.axis2tools.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.ws.cxf.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.ws.jaxws.dom.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.jst.ws.jaxws.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.m2e.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.m2e.logback.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.m2e.wtp.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.m2e.wtp.jaxrs.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.m2e.wtp.jpa.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.m2e.wtp.jsf.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.mylyn.bugzilla_feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.mylyn.context_feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.mylyn.ide_feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.mylyn.java_feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.mylyn.wikitext_feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.mylyn_feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.pde.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.tips.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.tm.terminal.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.wst.common.fproj.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.wst.jsdt.chromium.debug.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.wst.jsdt.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.wst.server_adapters.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.wst.web_ui.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.wst.xml_ui.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.wst.xsl.feature.feature.group [2019-08-25 21:28:32] Requirement org.eclipse.oomph.setup.feature.group [2019-08-25 21:28:32] Repository http://download.eclipse.org/technology/epp/packages/2019-06 [2019-08-25 21:28:32] Repository http://download.eclipse.org/releases/2019-06/201906191000 [2019-08-25 21:28:32] Repository http://download.eclipse.org/oomph/updates/milestone/latest [2019-08-25 21:32:11] ERROR: org.eclipse.equinox.p2.transport.ecf code=1002 Unable to read repository at http://download.eclipse.org/releases/2019-06/201906191000/content.xml.xz. java.net.SocketTimeoutException: Read timed out at java.base/java.net.SocketInputStream.socketRead0(Native Method) at java.base/java.net.SocketInputStream.socketRead(SocketInputStream.java:115) at java.base/java.net.SocketInputStream.read(SocketInputStream.java:168) at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140) at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:137) at org.apache.http.impl.io.SessionInputBufferImpl.fillBuffer(SessionInputBufferImpl.java:153) at org.apache.http.impl.io.SessionInputBufferImpl.read(SessionInputBufferImpl.java:206) at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:189) at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135) at java.base/java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:243) at java.base/java.util.zip.InflaterInputStream.read(InflaterInputStream.java:159) at java.base/java.util.zip.GZIPInputStream.read(GZIPInputStream.java:118) at org.apache.http.client.entity.LazyDecompressingInputStream.read(LazyDecompressingInputStream.java:70) at java.base/java.io.FilterInputStream.read(FilterInputStream.java:133) at java.base/java.io.FilterInputStream.read(FilterInputStream.java:107) at org.eclipse.ecf.provider.filetransfer.retrieve.AbstractRetrieveFileTransfer$1.performFileTransfer(AbstractRetrieveFileTransfer.java:178) at org.eclipse.ecf.filetransfer.FileTransferJob.run(FileTransferJob.java:74) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) [2019-08-25 21:32:11]
淘淘商城在构建mybatis逆向工程报错:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
在导入了逆向工程以后,执行java代码就出现了下面的报错。 ``` com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'performance_schema.session_variables' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1651) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:4198) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3592) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2311) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347) at org.mybatis.generator.internal.db.ConnectionFactory.getConnection(ConnectionFactory.java:68) at org.mybatis.generator.config.Context.getConnection(Context.java:526) at org.mybatis.generator.config.Context.introspectTables(Context.java:436) at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:222) at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:133) at GeneratorSqlmap.generator(GeneratorSqlmap.java:27) at GeneratorSqlmap.main(GeneratorSqlmap.java:33) ```
在win10子系统ubuntu18.04下安装mysql5.7尝试重新启动的时候出现以下报错
在win10子系统ubuntu18.04下安装mysql5.7尝试重新启动的时候出现以下报错 1.安装mysql-server ``` root@PC-5200:/home/tom# apt-get -y install mysql-server ``` ``` Reading package lists... Done Building dependency tree Reading state information... Done The following package was automatically installed and is no longer required: libfreetype6 Use 'apt autoremove' to remove it. The following additional packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-6 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libssl1.1 libtimedate-perl liburi-perl mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7 mysql-server-core-5.7 Suggested packages: libdata-dump-perl libipc-sharedcache-perl libwww-perl mailx tinyca The following NEW packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-6 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libtimedate-perl liburi-perl mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server mysql-server-5.7 mysql-server-core-5.7 The following packages will be upgraded: libssl1.1 1 upgraded, 21 newly installed, 0 to remove and 136 not upgraded. Need to get 21.0 MB of archives. After this operation, 157 MB of additional disk space will be used. Get:1 http://mirrors.aliyun.com/ubuntu bionic/main amd64 mysql-common all 5.8+1.0.4 [7308 B] Get:2 http://mirrors.aliyun.com/ubuntu bionic-updates/main amd64 libaio1 amd64 0.3.110-5ubuntu0.1 [6476 B] Get:3 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 libssl1.1 amd64 1.1.1-1ubuntu2.1~18.04.5 [1300 kB] Get:4 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-client-core-5.7 amd64 5.7.28-0ubuntu0.18.04.4 [6644 kB] Get:5 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-client-5.7 amd64 5.7.28-0ubuntu0.18.04.4 [1943 kB] Get:6 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server-core-5.7 amd64 5.7.28-0ubuntu0.18.04.4 [7432 kB] Get:7 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libevent-core-2.1-6 amd64 2.1.8-stable-4build1 [85.9 kB] Get:8 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server-5.7 amd64 5.7.28-0ubuntu0.18.04.4 [2932 kB] Get:9 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-tagset-perl all 3.20-3 [12.1 kB] Get:10 http://mirrors.aliyun.com/ubuntu bionic/main amd64 liburi-perl all 1.73-1 [77.2 kB] Get:11 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-parser-perl amd64 3.72-3build1 [85.9 kB] Get:12 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libcgi-pm-perl all 4.38-1 [185 kB] Get:13 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libfcgi-perl amd64 0.78-2build1 [32.8 kB] Get:14 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libcgi-fast-perl all 1:2.13-1 [9940 B] Get:15 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libencode-locale-perl all 1.05-1 [12.3 kB] Get:16 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-template-perl all 2.97-1 [59.0 kB] Get:17 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libtimedate-perl all 2.3000-2 [37.5 kB] Get:18 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhttp-date-perl all 6.02-1 [10.4 kB] Get:19 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libio-html-perl all 1.001-1 [14.9 kB] Get:20 http://mirrors.aliyun.com/ubuntu bionic/main amd64 liblwp-mediatypes-perl all 6.02-1 [21.7 kB] Get:21 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhttp-message-perl all 6.14-1 [72.1 kB] Get:22 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server all 5.7.28-0ubuntu0.18.04.4 [9940 B] Fetched 21.0 MB in 9s (2376 kB/s) Preconfiguring packages ... Selecting previously unselected package mysql-common. (Reading database ... 28663 files and directories currently installed.) Preparing to unpack .../0-mysql-common_5.8+1.0.4_all.deb ... Unpacking mysql-common (5.8+1.0.4) ... Selecting previously unselected package libaio1:amd64. Preparing to unpack .../1-libaio1_0.3.110-5ubuntu0.1_amd64.deb ... Unpacking libaio1:amd64 (0.3.110-5ubuntu0.1) ... Preparing to unpack .../2-libssl1.1_1.1.1-1ubuntu2.1~18.04.5_amd64.deb ... Unpacking libssl1.1:amd64 (1.1.1-1ubuntu2.1~18.04.5) over (1.1.0g-2ubuntu4.3) ... Selecting previously unselected package mysql-client-core-5.7. Preparing to unpack .../3-mysql-client-core-5.7_5.7.28-0ubuntu0.18.04.4_amd64.deb ... Unpacking mysql-client-core-5.7 (5.7.28-0ubuntu0.18.04.4) ... Selecting previously unselected package mysql-client-5.7. Preparing to unpack .../4-mysql-client-5.7_5.7.28-0ubuntu0.18.04.4_amd64.deb ... Unpacking mysql-client-5.7 (5.7.28-0ubuntu0.18.04.4) ... Selecting previously unselected package mysql-server-core-5.7. Preparing to unpack .../5-mysql-server-core-5.7_5.7.28-0ubuntu0.18.04.4_amd64.deb ... Unpacking mysql-server-core-5.7 (5.7.28-0ubuntu0.18.04.4) ... Selecting previously unselected package libevent-core-2.1-6:amd64. Preparing to unpack .../6-libevent-core-2.1-6_2.1.8-stable-4build1_amd64.deb ... Unpacking libevent-core-2.1-6:amd64 (2.1.8-stable-4build1) ... Setting up mysql-common (5.8+1.0.4) ... update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode Selecting previously unselected package mysql-server-5.7. (Reading database ... 28832 files and directories currently installed.) Preparing to unpack .../00-mysql-server-5.7_5.7.28-0ubuntu0.18.04.4_amd64.deb ... Unpacking mysql-server-5.7 (5.7.28-0ubuntu0.18.04.4) ... Selecting previously unselected package libhtml-tagset-perl. Preparing to unpack .../01-libhtml-tagset-perl_3.20-3_all.deb ... Unpacking libhtml-tagset-perl (3.20-3) ... Selecting previously unselected package liburi-perl. Preparing to unpack .../02-liburi-perl_1.73-1_all.deb ... Unpacking liburi-perl (1.73-1) ... Selecting previously unselected package libhtml-parser-perl. Preparing to unpack .../03-libhtml-parser-perl_3.72-3build1_amd64.deb ... Unpacking libhtml-parser-perl (3.72-3build1) ... Selecting previously unselected package libcgi-pm-perl. Preparing to unpack .../04-libcgi-pm-perl_4.38-1_all.deb ... Unpacking libcgi-pm-perl (4.38-1) ... Selecting previously unselected package libfcgi-perl. Preparing to unpack .../05-libfcgi-perl_0.78-2build1_amd64.deb ... Unpacking libfcgi-perl (0.78-2build1) ... Selecting previously unselected package libcgi-fast-perl. Preparing to unpack .../06-libcgi-fast-perl_1%3a2.13-1_all.deb ... Unpacking libcgi-fast-perl (1:2.13-1) ... Selecting previously unselected package libencode-locale-perl. Preparing to unpack .../07-libencode-locale-perl_1.05-1_all.deb ... Unpacking libencode-locale-perl (1.05-1) ... Selecting previously unselected package libhtml-template-perl. Preparing to unpack .../08-libhtml-template-perl_2.97-1_all.deb ... Unpacking libhtml-template-perl (2.97-1) ... Selecting previously unselected package libtimedate-perl. Preparing to unpack .../09-libtimedate-perl_2.3000-2_all.deb ... Unpacking libtimedate-perl (2.3000-2) ... Selecting previously unselected package libhttp-date-perl. Preparing to unpack .../10-libhttp-date-perl_6.02-1_all.deb ... Unpacking libhttp-date-perl (6.02-1) ... Selecting previously unselected package libio-html-perl. Preparing to unpack .../11-libio-html-perl_1.001-1_all.deb ... Unpacking libio-html-perl (1.001-1) ... Selecting previously unselected package liblwp-mediatypes-perl. Preparing to unpack .../12-liblwp-mediatypes-perl_6.02-1_all.deb ... Unpacking liblwp-mediatypes-perl (6.02-1) ... Selecting previously unselected package libhttp-message-perl. Preparing to unpack .../13-libhttp-message-perl_6.14-1_all.deb ... Unpacking libhttp-message-perl (6.14-1) ... Selecting previously unselected package mysql-server. Preparing to unpack .../14-mysql-server_5.7.28-0ubuntu0.18.04.4_all.deb ... Unpacking mysql-server (5.7.28-0ubuntu0.18.04.4) ... Setting up libhtml-tagset-perl (3.20-3) ... Setting up libevent-core-2.1-6:amd64 (2.1.8-stable-4build1) ... Processing triggers for ureadahead (0.100.0-21) ... Setting up libencode-locale-perl (1.05-1) ... Setting up libtimedate-perl (2.3000-2) ... Setting up libio-html-perl (1.001-1) ... Setting up liblwp-mediatypes-perl (6.02-1) ... Processing triggers for libc-bin (2.27-3ubuntu1) ... Setting up libaio1:amd64 (0.3.110-5ubuntu0.1) ... Setting up liburi-perl (1.73-1) ... Setting up libssl1.1:amd64 (1.1.1-1ubuntu2.1~18.04.5) ... Checking for services that may need to be restarted...done. Checking for services that may need to be restarted...done. Checking init scripts... Restarting services possibly affected by the upgrade: invoke-rc.d: could not determine current runlevel Services restarted successfully. Processing triggers for systemd (237-3ubuntu10.21) ... Setting up libhtml-parser-perl (3.72-3build1) ... Setting up libcgi-pm-perl (4.38-1) ... Processing triggers for man-db (2.8.3-2ubuntu0.1) ... Setting up mysql-client-core-5.7 (5.7.28-0ubuntu0.18.04.4) ... Setting up libfcgi-perl (0.78-2build1) ... Setting up libhttp-date-perl (6.02-1) ... Setting up libhtml-template-perl (2.97-1) ... Setting up mysql-server-core-5.7 (5.7.28-0ubuntu0.18.04.4) ... Setting up libcgi-fast-perl (1:2.13-1) ... Setting up libhttp-message-perl (6.14-1) ... Setting up mysql-client-5.7 (5.7.28-0ubuntu0.18.04.4) ... Setting up mysql-server-5.7 (5.7.28-0ubuntu0.18.04.4) ... invoke-rc.d: could not determine current runlevel * Stopping MySQL database server mysqld [ OK ] update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode Renaming removed key_buffer and myisam-recover options (if present) Cannot open /proc/net/unix: No such file or directory Cannot stat file /proc/1/fd/5: Operation not permitted Cannot stat file /proc/1/fd/10: Operation not permitted Cannot stat file /proc/1/fd/6: Operation not permitted Cannot stat file /proc/7/fd/7: Operation not permitted Cannot stat file /proc/7/fd/10: Operation not permitted Cannot stat file /proc/7/fd/5: Operation not permitted Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service. invoke-rc.d: could not determine current runlevel Setting up mysql-server (5.7.28-0ubuntu0.18.04.4) ... Processing triggers for libc-bin (2.27-3ubuntu1) ... Processing triggers for ureadahead (0.100.0-21) ... Processing triggers for systemd (237-3ubuntu10.21) ... ``` 2.启动mysql服务 ``` root@PC-5200:/home/tom# systemctl start mysql.service ``` 3.出现如下报错 ``` System has not been booted with systemd as init system (PID 1). Can't operate. ```
mysql 5.6 版本的程序跑mysql 8.0 报错如下 ,数据库可以正常连接,连接数据库的驱动等相关jar 也换成了mysql8.0对应版本还是报如下错误
[http-nio-8085-exec-3] INFO com.gdk.jdbc.connection.ConnectionPoolManager - ***** Add ConnectionPoolShutdownHook to JVM hook ***** [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging. [http-nio-8085-exec-3] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5 [built 02-January-2015 13:25:04 -0500; debug? true; trace: 10] [http-nio-8085-exec-3] WARN com.mchange.v2.c3p0.cfg.C3P0Config - named-config with name 'mysql' does not exist. Using default-config. [http-nio-8085-exec-3] WARN com.mchange.v2.c3p0.cfg.C3P0Config - named-config with name 'mysql' does not exist. Using default-config extensions. [http-nio-8085-exec-3] INFO com.gdk.jdbc.connection.c3p0.C3P0ConnectionProvider - >>>>>> C3P0ConnectionProvider startup initing with configuration: {"file":"/E:/tomcat/webapps/huajiu/WEB-INF/classes/datasource.xml","id":"mysql.1509899288","name":"mysql","driverClass":"com.mysql.cj.jdbc.Driver","driverUrl":"jdbc:mysql://47.XXX.XXX.229:3306/huajiu?useSSL=true","user":"root","password":"******","connectionProvider":"com.gdk.jdbc.connection.c3p0.C3P0ConnectionProvider","dialect":"com.gdk.jdbc.dialect.MySQLDialect","maxConnectionSize":10,"minConnectionSize":1,"initConnectionSize":1,"availableConnectionSize":1,"acquireIncrementSize":1,"maxConnectionIdletime":3600,"maxConnectionLifetime":14400,"acquireRetryAttempts":30,"acquireRetryDelay":2000,"idleConnectionTestPeriod":3600,"testConnectionCheckout":false,"testConnectionCheckin":false,"connectionTimeout":5000,"showSQL":false,"loadOnStartup":true,"monitorEnable":false,"weight":1,"_xaDataSourceClass":"com.mysql.jdbc.jdbc2.optional.MysqlXADataSource","customize":{}} [http-nio-8085-exec-3] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 2000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 5000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> mysql.1509899288, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgf2m9a61o8yo2f6gh111|79cc61a8, idleConnectionTestPeriod -> 3600, initialPoolSize -> 1, jdbcUrl -> jdbc:mysql://47.XXX.XXX.229:3306/huajiu?useSSL=true, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 14400, maxIdleTime -> 3600, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 1, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ] com.gdk.jdbc.connection.ConnectFailedException: Can not get a Master Connection from datasource<mysql>! at com.gdk.jdbc.connection.ConnectionPoolManager.getMasterConnection(ConnectionPoolManager.java:188) at com.gdk.jdbc.JdbcHandlerImpl.getMasterConnection(JdbcHandlerImpl.java:1780) at com.gdk.jdbc.JdbcHandlerImpl.getConnection(JdbcHandlerImpl.java:1767) at com.gdk.jdbc.JdbcHandlerImpl.queryForList(JdbcHandlerImpl.java:1156) at com.gdk.jdbc.JdbcHandlerImpl.queryForList(JdbcHandlerImpl.java:1138) at com.qshl.aqb.sys.dao.PlatformDao.getUserByUname(PlatformDao.java:21) at com.qshl.aqb.sys.service.impl.PlatformServiceImpl.login(PlatformServiceImpl.java:26) at com.qshl.aqb.sys.controller.PlatformController.unameLogin(PlatformController.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1156) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@1c2032db -- timeout at awaitAvailable() at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1461) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:639) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:549) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:756) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:683) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) at com.gdk.jdbc.connection.c3p0.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:230) at com.gdk.jdbc.connection.ConnectionPoolManager.getMasterConnection(ConnectionPoolManager.java:177) ... 49 more
相见恨晚的超实用网站
相见恨晚的超实用网站 持续更新中。。。
Java学习的正确打开方式
在博主认为,对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结,前三者博主将淋漓尽致地挥毫于这篇博客文章中,至于总结在于个人,实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍,博客次之,这又是一个层次了,这里暂时不提后面再谈。博主将为各位入门java保驾护航,各位只管冲鸭!!!上天是公平的,只要不辜负时间,时间自然不会辜负你。 何谓学习?博主所理解的学习,它是一个过程,是一个不断累积、不断沉淀、不断总结、善于传达自己的个人见解以及乐于分享的过程。
程序员必须掌握的核心算法有哪些?
由于我之前一直强调数据结构以及算法学习的重要性,所以就有一些读者经常问我,数据结构与算法应该要学习到哪个程度呢?,说实话,这个问题我不知道要怎么回答你,主要取决于你想学习到哪些程度,不过针对这个问题,我稍微总结一下我学过的算法知识点,以及我觉得值得学习的算法。这些算法与数据结构的学习大多数是零散的,并没有一本把他们全部覆盖的书籍。下面是我觉得值得学习的一些算法以及数据结构,当然,我也会整理一些看过...
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、电子书搜索 对于大部分程序员...
linux系列之常用运维命令整理笔录
本博客记录工作中需要的linux运维命令,大学时候开始接触linux,会一些基本操作,可是都没有整理起来,加上是做开发,不做运维,有些命令忘记了,所以现在整理成博客,当然vi,文件操作等就不介绍了,慢慢积累一些其它拓展的命令,博客不定时更新 free -m 其中:m表示兆,也可以用g,注意都要小写 Men:表示物理内存统计 total:表示物理内存总数(total=used+free) use...
比特币原理详解
一、什么是比特币 比特币是一种电子货币,是一种基于密码学的货币,在2008年11月1日由中本聪发表比特币白皮书,文中提出了一种去中心化的电子记账系统,我们平时的电子现金是银行来记账,因为银行的背后是国家信用。去中心化电子记账系统是参与者共同记账。比特币可以防止主权危机、信用风险。其好处不多做赘述,这一层面介绍的文章很多,本文主要从更深层的技术原理角度进行介绍。 二、问题引入 假设现有4个人...
python 简易微信实现(注册登录+数据库存储+聊天+GUI+文件传输)
socket+tkinter详解+简易微信实现 历经多天的努力,查阅了许多大佬的博客后终于实现了一个简易的微信O(∩_∩)O~~ 简易数据库的实现 使用pands+CSV实现数据库框架搭建 import socket import threading from pandas import * import pymysql import csv # 创建DataFrame对象 # 存储用户数据的表(...
程序员接私活怎样防止做完了不给钱?
首先跟大家说明一点,我们做 IT 类的外包开发,是非标品开发,所以很有可能在开发过程中会有这样那样的需求修改,而这种需求修改很容易造成扯皮,进而影响到费用支付,甚至出现做完了项目收不到钱的情况。 那么,怎么保证自己的薪酬安全呢? 我们在开工前,一定要做好一些证据方面的准备(也就是“讨薪”的理论依据),这其中最重要的就是需求文档和验收标准。一定要让需求方提供这两个文档资料作为开发的基础。之后开发...
网页实现一个简单的音乐播放器(大佬别看。(⊙﹏⊙))
今天闲着无事,就想写点东西。然后听了下歌,就打算写个播放器。 于是乎用h5 audio的加上js简单的播放器完工了。 演示地点演示 html代码如下` music 这个年纪 七月的风 音乐 ` 然后就是css`*{ margin: 0; padding: 0; text-decoration: none; list-...
Python十大装B语法
Python 是一种代表简单思想的语言,其语法相对简单,很容易上手。不过,如果就此小视 Python 语法的精妙和深邃,那就大错特错了。本文精心筛选了最能展现 Python 语法之精妙的十个知识点,并附上详细的实例代码。如能在实战中融会贯通、灵活使用,必将使代码更为精炼、高效,同时也会极大提升代码B格,使之看上去更老练,读起来更优雅。
数据库优化 - SQL优化
以实际SQL入手,带你一步一步走上SQL优化之路!
2019年11月中国大陆编程语言排行榜
2019年11月2日,我统计了某招聘网站,获得有效程序员招聘数据9万条。针对招聘信息,提取编程语言关键字,并统计如下: 编程语言比例 rank pl_ percentage 1 java 33.62% 2 cpp 16.42% 3 c_sharp 12.82% 4 javascript 12.31% 5 python 7.93% 6 go 7.25% 7 p...
通俗易懂地给女朋友讲:线程池的内部原理
餐盘在灯光的照耀下格外晶莹洁白,女朋友拿起红酒杯轻轻地抿了一小口,对我说:“经常听你说线程池,到底线程池到底是个什么原理?”
《奇巧淫技》系列-python!!每天早上八点自动发送天气预报邮件到QQ邮箱
将代码部署服务器,每日早上定时获取到天气数据,并发送到邮箱。 也可以说是一个小型人工智障。 知识可以运用在不同地方,不一定非是天气预报。
经典算法(5)杨辉三角
杨辉三角 是经典算法,这篇博客对它的算法思想进行了讲解,并有完整的代码实现。
腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹?
昨天,有网友私信我,说去阿里面试,彻底的被打击到了。问了为什么网上大量使用ThreadLocal的源码都会加上private static?他被难住了,因为他从来都没有考虑过这个问题。无独有偶,今天笔者又发现有网友吐槽了一道腾讯的面试题,我们一起来看看。 腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹? 在互联网职场论坛,一名程序员发帖求助到。二面腾讯,其中一个算法题:64匹...
面试官:你连RESTful都不知道我怎么敢要你?
干货,2019 RESTful最贱实践
刷了几千道算法题,这些我私藏的刷题网站都在这里了!
遥想当年,机缘巧合入了 ACM 的坑,周边巨擘林立,从此过上了"天天被虐似死狗"的生活… 然而我是谁,我可是死狗中的战斗鸡,智力不够那刷题来凑,开始了夜以继日哼哧哼哧刷题的日子,从此"读题与提交齐飞, AC 与 WA 一色 ",我惊喜的发现被题虐既刺激又有快感,那一刻我泪流满面。这么好的事儿作为一个正直的人绝不能自己独享,经过激烈的颅内斗争,我决定把我私藏的十几个 T 的,阿不,十几个刷题网...
JavaScript 为什么能活到现在?
作者 | 司徒正美 责编 |郭芮 出品 | CSDN(ID:CSDNnews) JavaScript能发展到现在的程度已经经历不少的坎坷,早产带来的某些缺陷是永久性的,因此浏览器才有禁用JavaScript的选项。甚至在jQuery时代有人问出这样的问题,jQuery与JavaScript哪个快?在Babel.js出来之前,发明一门全新的语言代码代替JavaScript...
项目中的if else太多了,该怎么重构?
介绍 最近跟着公司的大佬开发了一款IM系统,类似QQ和微信哈,就是聊天软件。我们有一部分业务逻辑是这样的 if (msgType = "文本") { // dosomething } else if(msgType = "图片") { // doshomething } else if(msgType = "视频") { // doshomething } else { // doshom...
Nginx 原理和架构
Nginx 是一个免费的,开源的,高性能的 HTTP 服务器和反向代理,以及 IMAP / POP3 代理服务器。Nginx 以其高性能,稳定性,丰富的功能,简单的配置和低资源消耗而闻名。 Nginx 的整体架构 Nginx 里有一个 master 进程和多个 worker 进程。master 进程并不处理网络请求,主要负责调度工作进程:加载配置、启动工作进程及非停升级。worker 进程负责处...
致 Python 初学者
欢迎来到“Python进阶”专栏!来到这里的每一位同学,应该大致上学习了很多 Python 的基础知识,正在努力成长的过程中。在此期间,一定遇到了很多的困惑,对未来的学习方向感到迷茫。我非常理解你们所面临的处境。我从2007年开始接触 python 这门编程语言,从2009年开始单一使用 python 应对所有的开发工作,直至今天。回顾自己的学习过程,也曾经遇到过无数的困难,也曾经迷茫过、困惑过。开办这个专栏,正是为了帮助像我当年一样困惑的 Python 初学者走出困境、快速成长。希望我的经验能真正帮到你
Python 编程开发 实用经验和技巧
Python是一门很灵活的语言,也有很多实用的方法,有时候实现一个功能可以用多种方法实现,我这里总结了一些常用的方法和技巧,包括小数保留指定位小数、判断变量的数据类型、类方法@classmethod、制表符中文对齐、遍历字典、datetime.timedelta的使用等,会持续更新......
吐血推荐珍藏的Visual Studio Code插件
作为一名Java工程师,由于工作需要,最近一个月一直在写NodeJS,这种经历可以说是一部辛酸史了。好在有神器Visual Studio Code陪伴,让我的这段经历没有更加困难。眼看这段经历要告一段落了,今天就来给大家分享一下我常用的一些VSC的插件。 VSC的插件安装方法很简单,只需要点击左侧最下方的插件栏选项,然后就可以搜索你想要的插件了。 下面我们进入正题 Material Theme ...
“狗屁不通文章生成器”登顶GitHub热榜,分分钟写出万字形式主义大作
一、垃圾文字生成器介绍 最近在浏览GitHub的时候,发现了这样一个骨骼清奇的雷人项目,而且热度还特别高。 项目中文名:狗屁不通文章生成器 项目英文名:BullshitGenerator 根据作者的介绍,他是偶尔需要一些中文文字用于GUI开发时测试文本渲染,因此开发了这个废话生成器。但由于生成的废话实在是太过富于哲理,所以最近已经被小伙伴们给玩坏了。 他的文风可能是这样的: 你发现,...
程序员:我终于知道post和get的区别
是一个老生常谈的话题,然而随着不断的学习,对于以前的认识有很多误区,所以还是需要不断地总结的,学而时习之,不亦说乎
《程序人生》系列-这个程序员只用了20行代码就拿了冠军
你知道的越多,你不知道的越多 点赞再看,养成习惯GitHub上已经开源https://github.com/JavaFamily,有一线大厂面试点脑图,欢迎Star和完善 前言 这一期不算《吊打面试官》系列的,所有没前言我直接开始。 絮叨 本来应该是没有这期的,看过我上期的小伙伴应该是知道的嘛,双十一比较忙嘛,要值班又要去帮忙拍摄年会的视频素材,还得搞个程序员一天的Vlog,还要写BU...
开源并不是你认为的那些事
点击上方蓝字 关注我们开源之道导读所以 ————想要理清开源是什么?先要厘清开源不是什么,名正言顺是句中国的古代成语,概念本身的理解非常之重要。大部分生物多样性的起源,...
加快推动区块链技术和产业创新发展,2019可信区块链峰会在京召开
11月8日,由中国信息通信研究院、中国通信标准化协会、中国互联网协会、可信区块链推进计划联合主办,科技行者协办的2019可信区块链峰会将在北京悠唐皇冠假日酒店开幕。   区块链技术被认为是继蒸汽机、电力、互联网之后,下一代颠覆性的核心技术。如果说蒸汽机释放了人类的生产力,电力解决了人类基本的生活需求,互联网彻底改变了信息传递的方式,区块链作为构造信任的技术有重要的价值。   1...
Python 植物大战僵尸代码实现(2):植物卡片选择和种植
这篇文章要介绍的是: - 上方植物卡片栏的实现。 - 点击植物卡片,鼠标切换为植物图片。 - 鼠标移动时,判断当前在哪个方格中,并显示半透明的植物作为提示。
程序员把地府后台管理系统做出来了,还有3.0版本!12月7号最新消息:已在开发中有github地址
第一幕:缘起 听说阎王爷要做个生死簿后台管理系统,我们派去了一个程序员…… 996程序员做的梦: 第一场:团队招募 为了应对地府管理危机,阎王打算找“人”开发一套地府后台管理系统,于是就在地府总经办群中发了项目需求。 话说还是中国电信的信号好,地府都是满格,哈哈!!! 经常会有外行朋友问:看某网站做的不错,功能也简单,你帮忙做一下? 而这次,面对这样的需求,这个程序员...
网易云6亿用户音乐推荐算法
网易云音乐是音乐爱好者的集聚地,云音乐推荐系统致力于通过 AI 算法的落地,实现用户千人千面的个性化推荐,为用户带来不一样的听歌体验。 本次分享重点介绍 AI 算法在音乐推荐中的应用实践,以及在算法落地过程中遇到的挑战和解决方案。 将从如下两个部分展开: AI算法在音乐推荐中的应用 音乐场景下的 AI 思考 从 2013 年 4 月正式上线至今,网易云音乐平台持续提供着:乐屏社区、UGC...
相关热词 基于c#波形控件 c# 十进制转十六进制 对文件aes加密vc# c#读取栈中所有的值 c# rsa256加密 好 学c# 还是c++ c# 和java的差距 c# curl网络框架 c# https证书请求 c# 中崎
立即提问