at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at com.sun.proxy.$Proxy141.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:158) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:76) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62) at com.sun.proxy.$Proxy164.getLCTJList(Unknown Source) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl.getLCTJList(Plan3ServiceImpl.java:315) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl$$FastClassBySpringCGLIB$$c6801ebe.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl$$EnhancerBySpringCGLIB$$aa54a576.getLCTJList(<generated>) at org.jeecg.modules.cable.controller.IndexController.getLCTJList(IndexController.java:73) at org.jeecg.modules.cable.controller.IndexController$$FastClassBySpringCGLIB$$24184f3e.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 org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at org.jeecg.modules.system.aspect.DictAspect.doAround(DictAspect.java:50) 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:498) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) at org.jeecg.modules.cable.controller.IndexController$$EnhancerBySpringCGLIB$$b54b34e3.getLCTJList(<generated>) 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:498) 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.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96) 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 com.github.xiaoymin.swaggerbootstrapui.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.github.xiaoymin.swaggerbootstrapui.filter.ProductionSecurityFilter.doFilter(ProductionSecurityFilter.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 com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90) 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.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.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:117) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:106) 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:200) 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:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 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: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 437, line 14, column 44, token FROM : SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1 at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:806) at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:259) at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568) at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:930) at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122) at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568) at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:341) at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:349) at sun.reflect.GeneratedMethodAccessor187.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55) at com.sun.proxy.$Proxy322.prepareStatement(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86) at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88) at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59) 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:498) at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:176) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy321.prepare(Unknown Source) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:94) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:66) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) 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.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:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy320.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) 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:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ... 120 common frames omitted Caused by: com.alibaba.druid.sql.parser.ParserException: ERROR. pos 437, line 14, column 44, token FROM at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:866) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:198) at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:154) at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:3352) at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:675) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.query(MySqlSelectParser.java:181) at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:236) at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:88) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseTableSource(MySqlSelectParser.java:246) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseFrom(MySqlSelectParser.java:89) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.query(MySqlSelectParser.java:193) at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:236) at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:88) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseSelect(MySqlStatementParser.java:284) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:248) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:182) at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:624) at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:578) at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:793) ... 162 common frames omitted |
|||||
| WARN | 2020-09-17 16:04:49,069 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:04:59,072 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:05:09,074 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| INFO | 2020-09-17 16:05:11,586 | 【websocket消息】连接断开，总数为:0 | onClose | WebSocket.java | 51 |
| INFO | 2020-09-17 16:05:13,034 | ------ 通过令牌获取用户拥有的访问菜单 ---- TOKEN ------ eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE2MDAzMjExMjYsInVzZXJuYW1lIjoiYWRtaW4ifQ.HErC4qGs2ebmiYys5n7vpaOxv0-Smxc5fQF8tt-9f-E | getUserPermissionByToken | SysPermissionController.java | 206 |
| INFO | 2020-09-17 16:05:14,847 | 【websocket消息】有新的连接，总数为:1 | onOpen | WebSocket.java | 42 |
| ERROR | 2020-09-17 16:05:15,092 | ### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 437, line 14, column 44, token FROM : SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1 ### The error may exist in file [F:\git仓库\cable__xinrun_logistics\cable-master\jeecg-boot\jeecg-boot-module-system\target\classes\org\jeecg\modules\cable\mapper\xml\Plan3Mapper.xml] ### The error may involve org.jeecg.modules.cable.mapper.Plan3Mapper.getLCTJList ### The error occurred while executing a query ### SQL: SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1 ### Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 437, line 14, column 44, token FROM : SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1 ; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: ERROR. pos 437, line 14, column 44, token FROM : SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1; nested exception is java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 437, line 14, column 44, token FROM : SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1 | handleException | JeecgBootExceptionHandler.java | 57 |
|
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: java.sql.SQLException: sql injection
violation, syntax error: ERROR. pos 437, line 14, column 44, token FROM
: SELECT
result.backup1,
SUM( result.deliverNum ) AS deliverNum,
result.deliver_time,
SUM( result.receivingNum ) AS receivingNum,
result.receiving_time
FROM
(
SELECT
m.backup1,
SUM( d.accomplish_num ) AS deliverNum,
d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum,
r.receiving_time AS receivingTime,
FROM
plan3 p
LEFT JOIN deliver_storage d ON p.id = d.plan_id
AND d.plan_type = 3
LEFT JOIN receiving_storage r ON p.id = r.plan_id
AND r.plan_type = 3
LEFT JOIN material m ON p.material_code = m.serial
WHERE
p.plan_type = '临措'
AND m.backup1 IN ( '电缆', '电缆配件', '变压器' )
GROUP BY
m.backup1 UNION ALL
SELECT
'其他' as backup1,
SUM( d.accomplish_num ) AS deliverNum,
d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum,
r.receiving_time AS receivingTime,
FROM
plan3 p
LEFT JOIN deliver_storage d ON p.id = d.plan_id
AND d.plan_type = 3
LEFT JOIN receiving_storage r ON p.id = r.plan_id
AND r.plan_type = 3
LEFT JOIN material m ON p.material_code = m.serial
WHERE
p.plan_type = '临措'
AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' )
GROUP BY
m.backup1
) `result`
GROUP BY `result`.backup1
### The error may exist in file
[F:\git仓库\cable__xinrun_logistics\cable-master\jeecg-boot\jeecg-boot-module-system\target\classes\org\jeecg\modules\cable\mapper\xml\Plan3Mapper.xml]
### The error may involve
org.jeecg.modules.cable.mapper.Plan3Mapper.getLCTJList
### The error occurred while executing a query
### SQL: SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum,
result.deliver_time, SUM( result.receivingNum ) AS receivingNum,
result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num )
AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS
receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN
deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN
receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN
material m ON p.material_code = m.serial WHERE p.plan_type = '临措'
AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP
BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM(
d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM(
r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime,
FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND
d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND
r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE
p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件',
'变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1
### Cause: java.sql.SQLException: sql injection violation, syntax error:
ERROR. pos 437, line 14, column 44, token FROM : SELECT
result.backup1,
SUM( result.deliverNum ) AS deliverNum,
result.deliver_time,
SUM( result.receivingNum ) AS receivingNum,
result.receiving_time
FROM
(
SELECT
m.backup1,
SUM( d.accomplish_num ) AS deliverNum,
d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum,
r.receiving_time AS receivingTime,
FROM
plan3 p
LEFT JOIN deliver_storage d ON p.id = d.plan_id
AND d.plan_type = 3
LEFT JOIN receiving_storage r ON p.id = r.plan_id
AND r.plan_type = 3
LEFT JOIN material m ON p.material_code = m.serial
WHERE
p.plan_type = '临措'
AND m.backup1 IN ( '电缆', '电缆配件', '变压器' )
GROUP BY
m.backup1 UNION ALL
SELECT
'其他' as backup1,
SUM( d.accomplish_num ) AS deliverNum,
d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum,
r.receiving_time AS receivingTime,
FROM
plan3 p
LEFT JOIN deliver_storage d ON p.id = d.plan_id
AND d.plan_type = 3
LEFT JOIN receiving_storage r ON p.id = r.plan_id
AND r.plan_type = 3
LEFT JOIN material m ON p.material_code = m.serial
WHERE
p.plan_type = '临措'
AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' )
GROUP BY
m.backup1
) `result`
GROUP BY `result`.backup1
; uncategorized SQLException; SQL state [null]; error code [0]; sql
injection violation, syntax error: ERROR. pos 437, line 14, column 44,
token FROM : SELECT
result.backup1,
SUM( result.deliverNum ) AS deliverNum,
result.deliver_time,
SUM( result.receivingNum ) AS receivingNum,
result.receiving_time
FROM
(
SELECT
m.backup1,
SUM( d.accomplish_num ) AS deliverNum,
d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum,
r.receiving_time AS receivingTime,
FROM
plan3 p
LEFT JOIN deliver_storage d ON p.id = d.plan_id
AND d.plan_type = 3
LEFT JOIN receiving_storage r ON p.id = r.plan_id
AND r.plan_type = 3
LEFT JOIN material m ON p.material_code = m.serial
WHERE
p.plan_type = '临措'
AND m.backup1 IN ( '电缆', '电缆配件', '变压器' )
GROUP BY
m.backup1 UNION ALL
SELECT
'其他' as backup1,
SUM( d.accomplish_num ) AS deliverNum,
d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum,
r.receiving_time AS receivingTime,
FROM
plan3 p
LEFT JOIN deliver_storage d ON p.id = d.plan_id
AND d.plan_type = 3
LEFT JOIN receiving_storage r ON p.id = r.plan_id
AND r.plan_type = 3
LEFT JOIN material m ON p.material_code = m.serial
WHERE
p.plan_type = '临措'
AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' )
GROUP BY
m.backup1
) `result`
GROUP BY `result`.backup1; nested exception is java.sql.SQLException:
sql injection violation, syntax error: ERROR. pos 437, line 14, column
44, token FROM : SELECT
result.backup1,
SUM( result.deliverNum ) AS deliverNum,
result.deliver_time,
SUM( result.receivingNum ) AS receivingNum,
result.receiving_time
FROM
(
SELECT
m.backup1,
SUM( d.accomplish_num ) AS deliverNum,
d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum,
r.receiving_time AS receivingTime,
FROM
plan3 p
LEFT JOIN deliver_storage d ON p.id = d.plan_id
AND d.plan_type = 3
LEFT JOIN receiving_storage r ON p.id = r.plan_id
AND r.plan_type = 3
LEFT JOIN material m ON p.material_code = m.serial
WHERE
p.plan_type = '临措'
AND m.backup1 IN ( '电缆', '电缆配件', '变压器' )
GROUP BY
m.backup1 UNION ALL
SELECT
'其他' as backup1,
SUM( d.accomplish_num ) AS deliverNum,
d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum,
r.receiving_time AS receivingTime,
FROM
plan3 p
LEFT JOIN deliver_storage d ON p.id = d.plan_id
AND d.plan_type = 3
LEFT JOIN receiving_storage r ON p.id = r.plan_id
AND r.plan_type = 3
LEFT JOIN material m ON p.material_code = m.serial
WHERE
p.plan_type = '临措'
AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' )
GROUP BY
m.backup1
) `result`
GROUP BY `result`.backup1
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at com.sun.proxy.$Proxy141.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:158) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:76) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62) at com.sun.proxy.$Proxy164.getLCTJList(Unknown Source) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl.getLCTJList(Plan3ServiceImpl.java:315) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl$$FastClassBySpringCGLIB$$c6801ebe.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl$$EnhancerBySpringCGLIB$$aa54a576.getLCTJList(<generated>) at org.jeecg.modules.cable.controller.IndexController.getLCTJList(IndexController.java:73) at org.jeecg.modules.cable.controller.IndexController$$FastClassBySpringCGLIB$$24184f3e.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 org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at org.jeecg.modules.system.aspect.DictAspect.doAround(DictAspect.java:50) 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:498) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) at org.jeecg.modules.cable.controller.IndexController$$EnhancerBySpringCGLIB$$b54b34e3.getLCTJList(<generated>) 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:498) 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.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96) 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 com.github.xiaoymin.swaggerbootstrapui.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.github.xiaoymin.swaggerbootstrapui.filter.ProductionSecurityFilter.doFilter(ProductionSecurityFilter.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 com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90) 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.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.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:117) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:106) 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:200) 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:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 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: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 437, line 14, column 44, token FROM : SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime, FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1 at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:806) at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:259) at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568) at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:930) at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122) at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568) at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:341) at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:349) at sun.reflect.GeneratedMethodAccessor187.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55) at com.sun.proxy.$Proxy322.prepareStatement(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86) at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88) at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59) 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:498) at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:176) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy321.prepare(Unknown Source) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:94) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:66) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) 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.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:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy320.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) 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:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ... 120 common frames omitted Caused by: com.alibaba.druid.sql.parser.ParserException: ERROR. pos 437, line 14, column 44, token FROM at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:866) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:198) at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:154) at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:3352) at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:675) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.query(MySqlSelectParser.java:181) at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:236) at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:88) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseTableSource(MySqlSelectParser.java:246) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseFrom(MySqlSelectParser.java:89) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.query(MySqlSelectParser.java:193) at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:236) at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:88) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseSelect(MySqlStatementParser.java:284) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:248) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:182) at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:624) at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:578) at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:793) ... 162 common frames omitted |
|||||
| WARN | 2020-09-17 16:05:19,077 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:05:29,080 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:05:39,083 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:05:49,087 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:05:59,091 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:06:09,095 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:06:19,099 | This scheduler instance (PC-20180606FUAG1600329843585) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| INFO | 2020-09-17 16:06:23,118 | Scheduler MyScheduler_$_PC-20180606FUAG1600329843585 paused. | standby | QuartzScheduler.java | 585 |
| INFO | 2020-09-17 16:06:23,121 | Shutting down ExecutorService 'applicationTaskExecutor' | shutdown | ExecutorConfigurationSupport.java | 208 |
| INFO | 2020-09-17 16:06:23,124 | Shutting down Quartz Scheduler | destroy | SchedulerFactoryBean.java | 844 |
| INFO | 2020-09-17 16:06:23,124 | Scheduler MyScheduler_$_PC-20180606FUAG1600329843585 shutting down. | shutdown | QuartzScheduler.java | 666 |
| INFO | 2020-09-17 16:06:23,125 | Scheduler MyScheduler_$_PC-20180606FUAG1600329843585 paused. | standby | QuartzScheduler.java | 585 |
| INFO | 2020-09-17 16:06:23,126 | Scheduler MyScheduler_$_PC-20180606FUAG1600329843585 shutdown complete. | shutdown | QuartzScheduler.java | 740 |
| INFO | 2020-09-17 16:06:23,132 | closing dynamicDatasource ing.... | destroy | DynamicRoutingDataSource.java | 182 |
| INFO | 2020-09-17 16:06:23,134 | {dataSource-1} closing ... | close | DruidDataSource.java | 1948 |
| INFO | 2020-09-17 16:06:23,138 | {dataSource-1} closed | close | DruidDataSource.java | 2020 |
| INFO | 2020-09-17 16:06:24,287 | 【websocket消息】连接断开，总数为:0 | onClose | WebSocket.java | 51 |
| Level | Date | Message | MethodOfCaller | FileOfCaller | LineOfCaller |
| INFO | 2020-09-17 16:06:29,131 | Starting JeecgApplication on PC-20180606FUAG with PID 10788 (started by Administrator in F:\git仓库\cable__xinrun_logistics\cable-master\jeecg-boot) | logStarting | StartupInfoLogger.java | 50 |
| INFO | 2020-09-17 16:06:29,136 | The following profiles are active: dev | logStartupProfileInfo | SpringApplication.java | 679 |
| INFO | 2020-09-17 16:06:30,999 | Multiple Spring Data modules found, entering strict repository configuration mode! | multipleStoresDetected | RepositoryConfigurationDelegate.java | 244 |
| INFO | 2020-09-17 16:06:31,002 | Bootstrapping Spring Data repositories in DEFAULT mode. | registerRepositoriesIn | RepositoryConfigurationDelegate.java | 126 |
| INFO | 2020-09-17 16:06:31,113 | Finished Spring Data repository scanning in 94ms. Found 0 repository interfaces. | registerRepositoriesIn | RepositoryConfigurationDelegate.java | 182 |
| INFO | 2020-09-17 16:06:31,634 | Bean 'shiroConfig' of type [org.jeecg.config.ShiroConfig$$EnhancerBySpringCGLIB$$a10c4bcf] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:31,733 | Bean 'shiroRealm' of type [org.jeecg.modules.shiro.authc.ShiroRealm] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:31,829 | ===============(1)创建缓存管理器RedisCacheManager | redisCacheManager | ShiroConfig.java | 209 |
| INFO | 2020-09-17 16:06:31,832 | ===============(2)创建RedisManager,连接Redis..URL= <IP_ADDRESS>:6379 | redisManager | ShiroConfig.java | 227 |
| INFO | 2020-09-17 16:06:31,839 | Bean 'redisManager' of type [org.crazycake.shiro.RedisManager] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:31,846 | Bean 'securityManager' of type [org.apache.shiro.web.mgt.DefaultWebSecurityManager] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:31,882 | Bean 'authorizationAttributeSourceAdvisor' of type [org.apache.shiro.spring.security.interceptor.AuthorizationAttributeSourceAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:31,964 | Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$8106e239] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,126 | Bean 'spring.datasource.dynamic-com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceProperties' of type [com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,132 | Bean 'com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceAutoConfiguration' of type [com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceAutoConfiguration$$EnhancerBySpringCGLIB$$ea95530a] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,144 | Bean 'dsProcessor' of type [com.baomidou.dynamic.datasource.processor.DsHeaderProcessor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,150 | Bean 'dynamicDatasourceAnnotationAdvisor' of type [com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,176 | Bean 'spring.redis-org.springframework.boot.autoconfigure.data.redis.RedisProperties' of type [org.springframework.boot.autoconfigure.data.redis.RedisProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,186 | Bean 'org.springframework.boot.autoconfigure.data.redis.LettuceConnectionConfiguration' of type [org.springframework.boot.autoconfigure.data.redis.LettuceConnectionConfiguration$$EnhancerBySpringCGLIB$$9620a083] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,308 | Bean 'lettuceClientResources' of type [io.lettuce.core.resource.DefaultClientResources] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,515 | Bean 'redisConnectionFactory' of type [org.springframework.data.redis.connection.lettuce.LettuceConnectionFactory] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,554 | Bean 'redisConfig' of type [org.jeecg.config.RedisConfig$$EnhancerBySpringCGLIB$$ebdad319] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,595 | Bean 'org.apache.shiro.spring.boot.autoconfigure.ShiroBeanAutoConfiguration' of type [org.apache.shiro.spring.boot.autoconfigure.ShiroBeanAutoConfiguration$$EnhancerBySpringCGLIB$$941fbfe9] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:32,601 | Bean 'eventBus' of type [org.apache.shiro.event.support.DefaultEventBus] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | postProcessAfterInitialization | PostProcessorRegistrationDelegate.java | 330 |
| INFO | 2020-09-17 16:06:33,070 | Tomcat initialized with port(s): 8080 (http) | initialize | TomcatWebServer.java | 90 |
| INFO | 2020-09-17 16:06:33,088 | Initializing ProtocolHandler ["http-nio-8080"] | log | DirectJDKLog.java | 173 |
| INFO | 2020-09-17 16:06:33,098 | Starting service [Tomcat] | log | DirectJDKLog.java | 173 |
| INFO | 2020-09-17 16:06:33,098 | Starting Servlet engine: [Apache Tomcat/9.0.16] | log | DirectJDKLog.java | 173 |
| INFO | 2020-09-17 16:06:33,104 | The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [C:\Program Files\Java\jdk1.8.0_101\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;E:\tmpSoft\Xshell6\;E:\tmpSoft\Xftp6\;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;E:\apache-maven-3.6.3\bin;C:\Program Files\nodejs\;E:\tmpSoft\mysql-5.7.26-winx64\bin;E:\tmpSoft\Git\cmd;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps;C:\Users\Administrator\AppData\Roaming\npm;.] | log | DirectJDKLog.java | 173 |
| INFO | 2020-09-17 16:06:33,246 | Initializing Spring embedded WebApplicationContext | log | DirectJDKLog.java | 173 |
| INFO | 2020-09-17 16:06:33,247 | Root WebApplicationContext: initialization completed in 4016 ms | prepareWebApplicationContext | ServletWebServerApplicationContext.java | 296 |
| INFO | 2020-09-17 16:06:33,715 | 动态数据源-检测到druid存在,如配置中未指定type,druid会默认配置 | <init> | DynamicDataSourceCreator.java | 113 |
| INFO | 2020-09-17 16:06:34,041 | {dataSource-1,master} inited | init | DruidDataSource.java | 1003 |
| INFO | 2020-09-17 16:06:34,041 | 初始共加载 1 个数据源 | afterPropertiesSet | DynamicRoutingDataSource.java | 203 |
| INFO | 2020-09-17 16:06:34,042 | 动态数据源-加载 master 成功 | addDataSource | DynamicRoutingDataSource.java | 142 |
| INFO | 2020-09-17 16:06:34,042 | 当前的默认数据源是单数据源，数据源名为 master | afterPropertiesSet | DynamicRoutingDataSource.java | 212 |
| INFO | 2020-09-17 16:06:40,069 | Using default implementation for ThreadExecutor | instantiate | StdSchedulerFactory.java | 1208 |
| INFO | 2020-09-17 16:06:40,072 | Job execution threads will use class loader of thread: main | initialize | SimpleThreadPool.java | 268 |
| INFO | 2020-09-17 16:06:40,086 | Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl | <init> | SchedulerSignalerImpl.java | 61 |
| INFO | 2020-09-17 16:06:40,086 | Quartz Scheduler v.2.3.0 created. | <init> | QuartzScheduler.java | 229 |
| INFO | 2020-09-17 16:06:40,091 | Using db table-based data access locking (synchronization). | initialize | JobStoreSupport.java | 672 |
| INFO | 2020-09-17 16:06:40,094 | JobStoreCMT initialized. | initialize | JobStoreCMT.java | 145 |
| INFO | 2020-09-17 16:06:40,095 | Scheduler meta-data: Quartz Scheduler (v2.3.0) 'MyScheduler' with instanceId 'PC-20180606FUAG1600330000071' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. | initialize | QuartzScheduler.java | 294 |
| INFO | 2020-09-17 16:06:40,095 | Quartz scheduler 'MyScheduler' initialized from an externally provided properties instance. | instantiate | StdSchedulerFactory.java | 1362 |
| INFO | 2020-09-17 16:06:40,096 | Quartz scheduler version: 2.3.0 | instantiate | StdSchedulerFactory.java | 1366 |
| INFO | 2020-09-17 16:06:40,096 | JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@5b5e45bc | setJobFactory | QuartzScheduler.java | 2287 |
| INFO | 2020-09-17 16:06:42,615 | Exposing 2 endpoint(s) beneath base path '/actuator' | <init> | EndpointLinksResolver.java | 59 |
| INFO | 2020-09-17 16:06:42,968 | Mapped URL path [/v2/api-docs] onto method [public org.springframework.http.ResponseEntity<springfox.documentation.spring.web.json.Json> springfox.documentation.swagger2.web.Swagger2Controller.getDocumentation(java.lang.String,javax.servlet.http.HttpServletRequest)] | initHandlerMethods | PropertySourcedRequestMappingHandlerMapping.java | 69 |
| INFO | 2020-09-17 16:06:43,358 | Initializing ExecutorService 'applicationTaskExecutor' | initialize | ExecutorConfigurationSupport.java | 171 |
| INFO | 2020-09-17 16:06:44,462 | Context refreshed | start | DocumentationPluginsBootstrapper.java | 160 |
| INFO | 2020-09-17 16:06:44,480 | Found 1 custom documentation plugin(s) | start | DocumentationPluginsBootstrapper.java | 163 |
| INFO | 2020-09-17 16:06:44,560 | Scanning for api listing references | scan | ApiListingReferenceScanner.java | 41 |
| INFO | 2020-09-17 16:06:44,808 | Generating unique operation named: addUsingPOST_1 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,810 | Generating unique operation named: deleteUsingDELETE_1 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,812 | Generating unique operation named: deleteBatchUsingDELETE_1 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,814 | Generating unique operation named: editUsingPUT_1 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,816 | Generating unique operation named: queryByIdUsingGET_1 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,821 | Generating unique operation named: queryPageListUsingGET_1 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,831 | Generating unique operation named: addUsingPOST_2 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,833 | Generating unique operation named: deleteUsingDELETE_2 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,835 | Generating unique operation named: deleteBatchUsingDELETE_2 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,837 | Generating unique operation named: editUsingPUT_2 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,838 | Generating unique operation named: queryByIdUsingGET_2 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,852 | Generating unique operation named: addUsingPOST_3 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,854 | Generating unique operation named: deleteUsingDELETE_3 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,857 | Generating unique operation named: deleteBatchUsingDELETE_3 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,859 | Generating unique operation named: editUsingPUT_3 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,870 | Generating unique operation named: queryByIdUsingGET_3 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,942 | Generating unique operation named: addUsingPOST_4 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,944 | Generating unique operation named: deleteUsingDELETE_4 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,946 | Generating unique operation named: deleteBatchUsingDELETE_4 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,949 | Generating unique operation named: editUsingPUT_4 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,960 | Generating unique operation named: queryByIdUsingGET_4 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,962 | Generating unique operation named: queryPageListUsingGET_2 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,966 | Generating unique operation named: addUsingPOST_5 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,968 | Generating unique operation named: deleteUsingDELETE_5 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,969 | Generating unique operation named: editUsingPUT_5 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:44,974 | Generating unique operation named: queryByIdUsingGET_5 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,088 | Generating unique operation named: queryPageListUsingGET_3 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,177 | Generating unique operation named: addUsingPOST_6 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,179 | Generating unique operation named: deleteUsingDELETE_6 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,181 | Generating unique operation named: editUsingPUT_6 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,183 | Generating unique operation named: idsqueryChuListUsingGET_1 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,184 | Generating unique operation named: idsqueryRuListUsingGET_1 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,186 | Generating unique operation named: queryByIdUsingGET_6 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,192 | Generating unique operation named: queryPageListUsingGET_4 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,207 | Generating unique operation named: addUsingPOST_7 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,209 | Generating unique operation named: deleteUsingDELETE_7 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,211 | Generating unique operation named: editUsingPUT_7 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,213 | Generating unique operation named: idsqueryChuListUsingGET_2 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,215 | Generating unique operation named: idsqueryRuListUsingGET_2 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,217 | Generating unique operation named: queryByIdUsingGET_7 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,224 | Generating unique operation named: queryPageListUsingGET_5 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,237 | Generating unique operation named: addUsingPOST_8 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,239 | Generating unique operation named: deleteUsingDELETE_8 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,241 | Generating unique operation named: editUsingPUT_8 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,243 | Generating unique operation named: idsqueryChuListUsingGET_3 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,248 | Generating unique operation named: idsqueryRuListUsingGET_3 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,250 | Generating unique operation named: queryByIdUsingGET_8 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,260 | Generating unique operation named: queryPageListUsingGET_6 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,268 | Generating unique operation named: addUsingPOST_9 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,270 | Generating unique operation named: deleteUsingDELETE_9 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,272 | Generating unique operation named: deleteBatchUsingDELETE_5 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,273 | Generating unique operation named: editUsingPUT_9 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,275 | Generating unique operation named: queryByIdUsingGET_9 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,283 | Generating unique operation named: queryPageListUsingGET_7 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,332 | Generating unique operation named: addUsingPOST_10 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,334 | Generating unique operation named: deleteUsingDELETE_10 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,336 | Generating unique operation named: editUsingPUT_10 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,338 | Generating unique operation named: queryByIdUsingGET_10 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,346 | Generating unique operation named: queryPageListUsingGET_8 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,358 | Generating unique operation named: addUsingPOST_11 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,362 | Generating unique operation named: deleteUsingDELETE_11 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,366 | Generating unique operation named: deleteBatchUsingDELETE_6 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,368 | Generating unique operation named: editUsingPUT_11 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,371 | Generating unique operation named: queryByIdUsingGET_11 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,387 | Generating unique operation named: queryPageListUsingGET_9 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,406 | Generating unique operation named: addUsingPOST_12 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,407 | Generating unique operation named: deleteUsingDELETE_12 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,409 | Generating unique operation named: editUsingPUT_12 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,412 | Generating unique operation named: queryByIdUsingGET_12 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,417 | Generating unique operation named: queryPageListUsingGET_10 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,428 | Generating unique operation named: addUsingPOST_13 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,433 | Generating unique operation named: deleteUsingDELETE_13 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,435 | Generating unique operation named: deleteBatchUsingDELETE_7 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,437 | Generating unique operation named: editUsingPUT_13 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,438 | Generating unique operation named: queryByIdUsingGET_13 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,442 | Generating unique operation named: queryPageListUsingGET_11 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,449 | Generating unique operation named: addUsingPOST_14 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,450 | Generating unique operation named: deleteUsingDELETE_14 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,451 | Generating unique operation named: deleteBatchUsingDELETE_8 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,453 | Generating unique operation named: editUsingPUT_14 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,454 | Generating unique operation named: queryByIdUsingGET_14 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,458 | Generating unique operation named: queryPageListUsingGET_12 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,463 | Generating unique operation named: addUsingPOST_15 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,464 | Generating unique operation named: deleteUsingDELETE_15 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,465 | Generating unique operation named: deleteBatchUsingDELETE_9 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,467 | Generating unique operation named: editUsingPUT_15 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,468 | Generating unique operation named: queryByIdUsingGET_15 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,471 | Generating unique operation named: queryPageListUsingGET_13 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,477 | Generating unique operation named: addUsingPOST_16 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,478 | Generating unique operation named: deleteUsingDELETE_16 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,480 | Generating unique operation named: deleteBatchUsingDELETE_10 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,481 | Generating unique operation named: editUsingPUT_16 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,482 | Generating unique operation named: queryByIdUsingGET_16 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,486 | Generating unique operation named: queryPageListUsingGET_14 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,491 | Generating unique operation named: addUsingPOST_17 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,492 | Generating unique operation named: deleteUsingDELETE_17 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,494 | Generating unique operation named: deleteBatchUsingDELETE_11 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,495 | Generating unique operation named: editUsingPUT_17 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,497 | Generating unique operation named: queryByIdUsingGET_17 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,501 | Generating unique operation named: queryPageListUsingGET_15 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,508 | Generating unique operation named: addUsingPOST_18 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,510 | Generating unique operation named: deleteUsingDELETE_18 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,512 | Generating unique operation named: deleteBatchUsingDELETE_12 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,513 | Generating unique operation named: editUsingPUT_18 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,514 | Generating unique operation named: queryByIdUsingGET_18 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,522 | Generating unique operation named: queryPageListUsingGET_16 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,526 | Generating unique operation named: addUsingPOST_19 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,530 | Generating unique operation named: deleteUsingDELETE_19 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,531 | Generating unique operation named: editUsingPUT_19 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,538 | Generating unique operation named: addUsingPOST_20 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,540 | Generating unique operation named: deleteUsingDELETE_20 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,542 | Generating unique operation named: deleteBatchUsingDELETE_13 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,543 | Generating unique operation named: editUsingPUT_20 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,545 | Generating unique operation named: queryByIdUsingGET_19 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,550 | Generating unique operation named: queryPageListUsingGET_17 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,556 | Generating unique operation named: addUsingPOST_21 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,558 | Generating unique operation named: deleteUsingDELETE_21 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,559 | Generating unique operation named: deleteBatchUsingDELETE_14 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,563 | Generating unique operation named: editUsingPUT_21 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,565 | Generating unique operation named: queryByIdUsingGET_20 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,570 | Generating unique operation named: queryPageListUsingGET_18 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,575 | Generating unique operation named: queryPageListUsingGET_19 | startingWith | CachingOperationNameGenerator.java | 40 |
| INFO | 2020-09-17 16:06:45,604 | Starting Quartz Scheduler now | startScheduler | SchedulerFactoryBean.java | 726 |
| INFO | 2020-09-17 16:06:45,825 | Scheduler MyScheduler_$_PC-20180606FUAG1600330000071 started. | start | QuartzScheduler.java | 547 |
| INFO | 2020-09-17 16:06:45,847 | Starting ProtocolHandler ["http-nio-8080"] | log | DirectJDKLog.java | 173 |
| INFO | 2020-09-17 16:06:45,878 | Tomcat started on port(s): 8080 (http) with context path '/jeecg-boot' | start | TomcatWebServer.java | 204 |
| INFO | 2020-09-17 16:06:45,881 | Started JeecgApplication in 17.835 seconds (JVM running for 18.934) | logStarted | StartupInfoLogger.java | 59 |
| INFO | 2020-09-17 16:06:45,897 | ---------------------------------------------------------- Application Jeecg-Boot is running! Access URLs: Local: http://localhost:8080/jeecg-boot/ External: http://<IP_ADDRESS>:8080/jeecg-boot/ Swagger-UI: http://<IP_ADDRESS>:8080/jeecg-boot/doc.html ---------------------------------------------------------- | main | JeecgApplication.java | 29 |
| INFO | 2020-09-17 16:06:46,413 | Initializing Spring DispatcherServlet 'dispatcherServlet' | log | DirectJDKLog.java | 173 |
| INFO | 2020-09-17 16:06:46,414 | Initializing Servlet 'dispatcherServlet' | initServletBean | FrameworkServlet.java | 524 |
| INFO | 2020-09-17 16:06:46,494 | Completed initialization in 79 ms | initServletBean | FrameworkServlet.java | 546 |
| INFO | 2020-09-17 16:06:46,578 | Starting without optional epoll library | <clinit> | EpollProvider.java | 68 |
| INFO | 2020-09-17 16:06:46,581 | Starting without optional kqueue library | <clinit> | KqueueProvider.java | 70 |
| INFO | 2020-09-17 16:06:48,429 | 【websocket消息】有新的连接，总数为:1 | onOpen | WebSocket.java | 42 |
| INFO | 2020-09-17 16:06:51,407 | 【websocket消息】连接断开，总数为:0 | onClose | WebSocket.java | 51 |
| INFO | 2020-09-17 16:06:55,260 | ------ 通过令牌获取用户拥有的访问菜单 ---- TOKEN ------ eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE2MDAzMjExMjYsInVzZXJuYW1lIjoiYWRtaW4ifQ.HErC4qGs2ebmiYys5n7vpaOxv0-Smxc5fQF8tt-9f-E | getUserPermissionByToken | SysPermissionController.java | 206 |
| WARN | 2020-09-17 16:06:55,756 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| INFO | 2020-09-17 16:06:58,609 | 【websocket消息】有新的连接，总数为:1 | onOpen | WebSocket.java | 42 |
| ERROR | 2020-09-17 16:06:59,094 | {conn-10003, pstmt-20015} execute error. SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1 | statementLogError | Slf4jLogFilter.java | 149 |
|
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
column 'result.deliver_time' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.wall.WallFilter.preparedStatement_execute(WallFilter.java:627) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) 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:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy323.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) 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:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy321.query(Unknown Source) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:67) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) 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.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:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy320.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) 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:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) at com.sun.proxy.$Proxy141.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:158) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:76) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62) at com.sun.proxy.$Proxy164.getLCTJList(Unknown Source) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl.getLCTJList(Plan3ServiceImpl.java:315) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl$$FastClassBySpringCGLIB$$c6801ebe.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl$$EnhancerBySpringCGLIB$$403d2d22.getLCTJList(<generated>) at org.jeecg.modules.cable.controller.IndexController.getLCTJList(IndexController.java:73) at org.jeecg.modules.cable.controller.IndexController$$FastClassBySpringCGLIB$$24184f3e.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 org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at org.jeecg.modules.system.aspect.DictAspect.doAround(DictAspect.java:50) 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:498) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) at org.jeecg.modules.cable.controller.IndexController$$EnhancerBySpringCGLIB$$dc58557.getLCTJList(<generated>) 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:498) 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.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96) 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 com.github.xiaoymin.swaggerbootstrapui.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.github.xiaoymin.swaggerbootstrapui.filter.ProductionSecurityFilter.doFilter(ProductionSecurityFilter.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 com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90) 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.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.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:117) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:106) 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:200) 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:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 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) |
|||||
| ERROR | 2020-09-17 16:06:59,144 | ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'result.deliver_time' in 'field list' ### The error may exist in file [F:\git仓库\cable__xinrun_logistics\cable-master\jeecg-boot\jeecg-boot-module-system\target\classes\org\jeecg\modules\cable\mapper\xml\Plan3Mapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT result.backup1, SUM( result.deliverNum ) AS deliverNum, result.deliver_time, SUM( result.receivingNum ) AS receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM( d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime, SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS receivingTime FROM plan3 p LEFT JOIN deliver_storage d ON p.id = d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id = r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON p.material_code = m.serial WHERE p.plan_type = '临措' AND m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' ) GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1 ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'result.deliver_time' in 'field list' ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'result.deliver_time' in 'field list' | handleException | JeecgBootExceptionHandler.java | 57 |
|
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
column 'result.deliver_time' in 'field list'
### The error may exist in file
[F:\git仓库\cable__xinrun_logistics\cable-master\jeecg-boot\jeecg-boot-module-system\target\classes\org\jeecg\modules\cable\mapper\xml\Plan3Mapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT result.backup1, SUM( result.deliverNum ) AS
deliverNum, result.deliver_time, SUM( result.receivingNum ) AS
receivingNum, result.receiving_time FROM ( SELECT m.backup1, SUM(
d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS
receivingTime FROM plan3 p LEFT JOIN deliver_storage d ON p.id =
d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id
= r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON
p.material_code = m.serial WHERE p.plan_type = '临措' AND
m.backup1 IN ( '电缆', '电缆配件', '变压器' ) GROUP
BY m.backup1 UNION ALL SELECT '其他' as backup1, SUM(
d.accomplish_num ) AS deliverNum, d.deliver_time AS deliverTime,
SUM( r.accomplish_num ) AS receivingNum, r.receiving_time AS
receivingTime FROM plan3 p LEFT JOIN deliver_storage d ON p.id =
d.plan_id AND d.plan_type = 3 LEFT JOIN receiving_storage r ON p.id
= r.plan_id AND r.plan_type = 3 LEFT JOIN material m ON
p.material_code = m.serial WHERE p.plan_type = '临措' AND
m.backup1 NOT IN ( '电缆', '电缆配件', '变压器' )
GROUP BY m.backup1 ) `result` GROUP BY `result`.backup1
### Cause:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
column 'result.deliver_time' in 'field list'
; bad SQL grammar []; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
column 'result.deliver_time' in 'field list'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at com.sun.proxy.$Proxy141.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:158) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:76) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62) at com.sun.proxy.$Proxy164.getLCTJList(Unknown Source) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl.getLCTJList(Plan3ServiceImpl.java:315) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl$$FastClassBySpringCGLIB$$c6801ebe.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) at org.jeecg.modules.cable.service.impl.Plan3ServiceImpl$$EnhancerBySpringCGLIB$$403d2d22.getLCTJList(<generated>) at org.jeecg.modules.cable.controller.IndexController.getLCTJList(IndexController.java:73) at org.jeecg.modules.cable.controller.IndexController$$FastClassBySpringCGLIB$$24184f3e.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 org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at org.jeecg.modules.system.aspect.DictAspect.doAround(DictAspect.java:50) 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:498) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) at org.jeecg.modules.cable.controller.IndexController$$EnhancerBySpringCGLIB$$dc58557.getLCTJList(<generated>) 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:498) 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.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96) 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 com.github.xiaoymin.swaggerbootstrapui.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.github.xiaoymin.swaggerbootstrapui.filter.ProductionSecurityFilter.doFilter(ProductionSecurityFilter.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 com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90) 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.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.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:117) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:106) 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:200) 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:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 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.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'result.deliver_time' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.wall.WallFilter.preparedStatement_execute(WallFilter.java:627) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) 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:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy323.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) 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:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy321.query(Unknown Source) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:67) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) 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.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:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy320.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) 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:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ... 120 common frames omitted |
|||||
| WARN | 2020-09-17 16:07:05,759 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:07:15,764 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:07:25,768 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:07:35,771 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:07:45,776 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:07:55,779 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:08:05,784 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| WARN | 2020-09-17 16:08:15,788 | This scheduler instance (PC-20180606FUAG1600330000071) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. | findFailedInstances | JobStoreSupport.java | 3396 |
| INFO | 2020-09-17 16:08:16,537 | Scheduler MyScheduler_$_PC-20180606FUAG1600330000071 paused. | standby | QuartzScheduler.java | 585 |
| INFO | 2020-09-17 16:08:16,539 | Shutting down ExecutorService 'applicationTaskExecutor' | shutdown | ExecutorConfigurationSupport.java | 208 |
| INFO | 2020-09-17 16:08:16,543 | Shutting down Quartz Scheduler | destroy | SchedulerFactoryBean.java | 844 |
| INFO | 2020-09-17 16:08:16,543 | Scheduler MyScheduler_$_PC-20180606FUAG1600330000071 shutting down. | shutdown | QuartzScheduler.java | 666 |
| INFO | 2020-09-17 16:08:16,543 | Scheduler MyScheduler_$_PC-20180606FUAG1600330000071 paused. | standby | QuartzScheduler.java | 585 |
| INFO | 2020-09-17 16:08:16,544 | Scheduler MyScheduler_$_PC-20180606FUAG1600330000071 shutdown complete. | shutdown | QuartzScheduler.java | 740 |
| INFO | 2020-09-17 16:08:16,550 | closing dynamicDatasource ing.... | destroy | DynamicRoutingDataSource.java | 182 |
| INFO | 2020-09-17 16:08:16,552 | {dataSource-1} closing ... | close | DruidDataSource.java | 1948 |
| INFO | 2020-09-17 16:08:16,557 | {dataSource-1} closed | close | DruidDataSource.java | 2020 |
| INFO | 2020-09-17 16:08:17,709 | 【websocket消息】连接断开，总数为:0 | onClose | WebSocket.java | 51 |
| Level | Date | Message | MethodOfCaller | FileOfCaller | LineOfCaller |
| INFO | 2020-09-17 16:08:22,539 | Starting JeecgApplication on PC-20180606FUAG with PID 7884 (started by Administrator in F:\git仓库\cable__xinrun_logistics\cable-master\jeecg-boot) | logStarting | StartupInfoLogger.java | 50 |
| INFO | 2020-09-17 16:08:22,544 | The following profiles are active: dev | logStartupProfileInfo | SpringApplication.java | 679 |
| INFO | 2020-09-17 16:08:24,566 | Multiple Spring Data modules found, entering strict repository configuration mode! | multipleStoresDetected | RepositoryConfigurationDelegate.java | 244 |
| INFO | 2020-09-17 16:08:24,569 | Bootstrapping Spring Data repositories in DEFAULT mode. | registerRepositoriesIn | RepositoryConfigurationDelegate.java | 126 |