2022-08-29 11:05:27.986 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 11:05:30.430 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 11:05:30.440 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 11:05:30.541 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 82 ms. Found 0 Redis repository interfaces. 2022-08-29 11:05:31.891 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@73a49597' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 11:05:31.926 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 11:05:33.081 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5055 ms 2022-08-29 11:05:44.472 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 11:05:44.493 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 11:05:44.493 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 11:05:44.497 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 11:05:44.501 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 11:05:44.502 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661742344475' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 11:05:44.503 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 11:05:44.503 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 11:05:44.505 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2cf6dd4d 2022-08-29 11:05:52.247 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 11:05:54.845 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 11:05:55.389 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 11:05:55.412 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 11:05:55.480 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 11:05:55.553 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 57019 (http) 2022-08-29 11:05:56.358 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 11:05:57.360 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 11:05:58.239 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742344475 started. 2022-08-29 11:05:59.112 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2054 millis. SELECT id,equipment_id,status,time,backup_inst,backup_max,backup_min,backup_ave,backup_sta,t_inst,t_max,t_min,t_ave,t_sta,rh_inst,rh_max,rh_min,rh_ave,rh_sta,pa_inst,pa_max,pa_min,pa_ave,pa_sta,ws_inst10,ws_max10,ws_min10,ws_ave10,ws_sta10,wd_inst10,wd_max10,wd_min10,wd_ave10,wd_sta10,ws_inst30,ws_max30,ws_min30,ws_ave30,ws_sta30,wd_inst30,wd_max30,wd_min30,wd_ave30,wd_sta30,ws_inst50,ws_max50,ws_min50,ws_ave50,ws_sta50,wd_inst50,wd_max50,wd_min50,wd_ave50,wd_sta50,ws_inst60,ws_max60,ws_min60,ws_ave60,ws_sta60,wd_inst60,wd_max60,wd_min60,wd_ave60,wd_sta60,ws_inst70,ws_max70,ws_min70,ws_ave70,ws_sta70,wd_inst70,wd_max70,wd_min70,wd_ave70,wd_sta70,ws_inst80,ws_max80,ws_min80,ws_ave80,ws_sta80,wd_inst80,wd_max80,wd_min80,wd_ave80,wd_sta80,ws_inst90,ws_max90,ws_min90,ws_ave90,ws_sta90,wd_inst90,wd_max90,wd_min90,wd_ave90,wd_sta90,ws_inst100,ws_max100,ws_min100,ws_ave100,ws_sta100,wd_inst100,wd_max100,wd_min100,wd_ave100,wd_sta100,ws_inst110,ws_max110,ws_min110,ws_ave110,ws_sta110,wd_inst110,wd_max110,wd_min110,wd_ave110,wd_sta110,ws_inst120,ws_max120,ws_min120,ws_ave120,ws_sta120,wd_inst120,wd_max120,wd_min120,wd_ave120,wd_sta120,wd_inst140,wd_max140,wd_min140,wd_ave140,wd_sta140,ws_inst140,ws_max140,ws_min140,ws_ave140,ws_sta140,wd_inst150,wd_max150,wd_min150,wd_ave150,wd_sta150,ws_inst150,ws_max150,ws_min150,ws_ave150,ws_sta150,air_density,abnormal_data,abnormal_type FROM wind_tower_status_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006177"] 2022-08-29 11:06:00.310 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742344475 paused. 2022-08-29 11:06:00.355 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 11:06:00.355 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742344475 shutting down. 2022-08-29 11:06:00.356 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742344475 paused. 2022-08-29 11:06:00.358 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742344475 shutdown complete. 2022-08-29 11:06:00.360 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 11:08:06.891 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 11:08:09.270 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 11:08:09.276 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 11:08:09.380 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 82 ms. Found 0 Redis repository interfaces. 2022-08-29 11:08:10.704 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@7856f41a' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 11:08:10.769 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 11:08:11.755 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4807 ms 2022-08-29 11:08:22.756 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 11:08:22.775 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 11:08:22.775 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 11:08:22.780 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 11:08:22.782 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 11:08:22.783 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661742502758' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 11:08:22.783 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 11:08:22.784 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 11:08:22.785 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@1cc5d8a9 2022-08-29 11:08:32.526 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 11:08:35.171 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 11:08:35.634 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 11:08:35.655 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 11:08:35.714 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 11:08:35.797 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 57271 (http) 2022-08-29 11:08:36.627 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 11:08:37.628 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 11:08:38.143 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742502758 started. 2022-08-29 11:08:39.330 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2271 millis. SELECT id,equipment_id,status,time,backup_inst,backup_max,backup_min,backup_ave,backup_sta,t_inst,t_max,t_min,t_ave,t_sta,rh_inst,rh_max,rh_min,rh_ave,rh_sta,pa_inst,pa_max,pa_min,pa_ave,pa_sta,ws_inst10,ws_max10,ws_min10,ws_ave10,ws_sta10,wd_inst10,wd_max10,wd_min10,wd_ave10,wd_sta10,ws_inst30,ws_max30,ws_min30,ws_ave30,ws_sta30,wd_inst30,wd_max30,wd_min30,wd_ave30,wd_sta30,ws_inst50,ws_max50,ws_min50,ws_ave50,ws_sta50,wd_inst50,wd_max50,wd_min50,wd_ave50,wd_sta50,ws_inst60,ws_max60,ws_min60,ws_ave60,ws_sta60,wd_inst60,wd_max60,wd_min60,wd_ave60,wd_sta60,ws_inst70,ws_max70,ws_min70,ws_ave70,ws_sta70,wd_inst70,wd_max70,wd_min70,wd_ave70,wd_sta70,ws_inst80,ws_max80,ws_min80,ws_ave80,ws_sta80,wd_inst80,wd_max80,wd_min80,wd_ave80,wd_sta80,ws_inst90,ws_max90,ws_min90,ws_ave90,ws_sta90,wd_inst90,wd_max90,wd_min90,wd_ave90,wd_sta90,ws_inst100,ws_max100,ws_min100,ws_ave100,ws_sta100,wd_inst100,wd_max100,wd_min100,wd_ave100,wd_sta100,ws_inst110,ws_max110,ws_min110,ws_ave110,ws_sta110,wd_inst110,wd_max110,wd_min110,wd_ave110,wd_sta110,ws_inst120,ws_max120,ws_min120,ws_ave120,ws_sta120,wd_inst120,wd_max120,wd_min120,wd_ave120,wd_sta120,wd_inst140,wd_max140,wd_min140,wd_ave140,wd_sta140,ws_inst140,ws_max140,ws_min140,ws_ave140,ws_sta140,wd_inst150,wd_max150,wd_min150,wd_ave150,wd_sta150,ws_inst150,ws_max150,ws_min150,ws_ave150,ws_sta150,air_density,abnormal_data,abnormal_type FROM wind_tower_status_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006177"] 2022-08-29 11:08:39.928 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@8862881] Transaction not enabled 2022-08-29 11:08:40.157 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ced9545] Transaction not enabled 2022-08-29 11:08:40.504 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5d1acb3a] Transaction not enabled 2022-08-29 11:08:40.771 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@56357e52] Transaction not enabled 2022-08-29 11:08:41.059 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b43db07] Transaction not enabled 2022-08-29 11:08:41.330 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@573d3ec6] Transaction not enabled 2022-08-29 11:08:41.592 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5047fc77] Transaction not enabled 2022-08-29 11:08:41.840 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2739f91b] Transaction not enabled 2022-08-29 11:08:41.976 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742502758 paused. 2022-08-29 11:08:42.007 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 11:08:42.007 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742502758 shutting down. 2022-08-29 11:08:42.007 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742502758 paused. 2022-08-29 11:08:42.009 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742502758 shutdown complete. 2022-08-29 11:08:42.011 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 11:15:15.071 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 11:15:17.460 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 11:15:17.464 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 11:15:17.550 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 69 ms. Found 0 Redis repository interfaces. 2022-08-29 11:15:18.893 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@49e62b17' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 11:15:18.942 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 11:15:21.120 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5984 ms 2022-08-29 11:15:32.979 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 11:15:33.005 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 11:15:33.006 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 11:15:33.013 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 11:15:33.017 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 11:15:33.018 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661742932982' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 11:15:33.019 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 11:15:33.019 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 11:15:33.022 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5946e540 2022-08-29 11:15:44.336 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 11:15:46.609 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 11:15:47.116 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 11:15:47.135 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 11:15:47.195 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 11:15:47.267 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 57679 (http) 2022-08-29 11:15:48.128 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 11:15:49.130 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 11:15:49.886 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742932982 started. 2022-08-29 11:15:51.046 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2538 millis. SELECT id,equipment_id,status,time,backup_inst,backup_max,backup_min,backup_ave,backup_sta,t_inst,t_max,t_min,t_ave,t_sta,rh_inst,rh_max,rh_min,rh_ave,rh_sta,pa_inst,pa_max,pa_min,pa_ave,pa_sta,ws_inst10,ws_max10,ws_min10,ws_ave10,ws_sta10,wd_inst10,wd_max10,wd_min10,wd_ave10,wd_sta10,ws_inst30,ws_max30,ws_min30,ws_ave30,ws_sta30,wd_inst30,wd_max30,wd_min30,wd_ave30,wd_sta30,ws_inst50,ws_max50,ws_min50,ws_ave50,ws_sta50,wd_inst50,wd_max50,wd_min50,wd_ave50,wd_sta50,ws_inst60,ws_max60,ws_min60,ws_ave60,ws_sta60,wd_inst60,wd_max60,wd_min60,wd_ave60,wd_sta60,ws_inst70,ws_max70,ws_min70,ws_ave70,ws_sta70,wd_inst70,wd_max70,wd_min70,wd_ave70,wd_sta70,ws_inst80,ws_max80,ws_min80,ws_ave80,ws_sta80,wd_inst80,wd_max80,wd_min80,wd_ave80,wd_sta80,ws_inst90,ws_max90,ws_min90,ws_ave90,ws_sta90,wd_inst90,wd_max90,wd_min90,wd_ave90,wd_sta90,ws_inst100,ws_max100,ws_min100,ws_ave100,ws_sta100,wd_inst100,wd_max100,wd_min100,wd_ave100,wd_sta100,ws_inst110,ws_max110,ws_min110,ws_ave110,ws_sta110,wd_inst110,wd_max110,wd_min110,wd_ave110,wd_sta110,ws_inst120,ws_max120,ws_min120,ws_ave120,ws_sta120,wd_inst120,wd_max120,wd_min120,wd_ave120,wd_sta120,wd_inst140,wd_max140,wd_min140,wd_ave140,wd_sta140,ws_inst140,ws_max140,ws_min140,ws_ave140,ws_sta140,wd_inst150,wd_max150,wd_min150,wd_ave150,wd_sta150,ws_inst150,ws_max150,ws_min150,ws_ave150,ws_sta150,air_density,abnormal_data,abnormal_type FROM wind_tower_status_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006177"] 2022-08-29 11:16:12.643 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@30c98124] Transaction not enabled 2022-08-29 11:16:18.925 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@f083345] Transaction not enabled 2022-08-29 11:16:42.806 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@79b01476] Transaction not enabled 2022-08-29 11:16:52.627 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7d9a5edf] Transaction not enabled 2022-08-29 11:17:03.654 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@69e67993] Transaction not enabled 2022-08-29 11:17:03.889 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1661742932982_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1661742932982) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-08-29 11:17:08.429 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@45a33515] Transaction not enabled 2022-08-29 11:17:11.049 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7921eb37] Transaction not enabled 2022-08-29 11:17:13.188 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@648ebda1] Transaction not enabled 2022-08-29 11:17:13.340 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742932982 paused. 2022-08-29 11:17:13.367 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 11:17:13.368 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742932982 shutting down. 2022-08-29 11:17:13.368 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742932982 paused. 2022-08-29 11:17:13.369 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661742932982 shutdown complete. 2022-08-29 11:17:13.371 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 11:20:24.013 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 11:20:26.328 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 11:20:26.334 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 11:20:26.434 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 78 ms. Found 0 Redis repository interfaces. 2022-08-29 11:20:28.110 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@da5d5e1' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 11:20:28.150 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 11:20:29.132 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5071 ms 2022-08-29 11:20:40.242 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 11:20:40.263 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 11:20:40.263 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 11:20:40.268 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 11:20:40.272 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 11:20:40.273 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661743240244' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 11:20:40.273 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 11:20:40.273 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 11:20:40.275 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@33ed6546 2022-08-29 11:20:48.393 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 11:20:50.722 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 11:20:51.160 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 11:20:51.184 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 11:20:51.248 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 11:20:51.312 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 57958 (http) 2022-08-29 11:20:52.176 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 11:20:53.178 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 11:20:53.871 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661743240244 started. 2022-08-29 11:20:54.684 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1930 millis. SELECT id,equipment_id,status,time,backup_inst,backup_max,backup_min,backup_ave,backup_sta,t_inst,t_max,t_min,t_ave,t_sta,rh_inst,rh_max,rh_min,rh_ave,rh_sta,pa_inst,pa_max,pa_min,pa_ave,pa_sta,ws_inst10,ws_max10,ws_min10,ws_ave10,ws_sta10,wd_inst10,wd_max10,wd_min10,wd_ave10,wd_sta10,ws_inst30,ws_max30,ws_min30,ws_ave30,ws_sta30,wd_inst30,wd_max30,wd_min30,wd_ave30,wd_sta30,ws_inst50,ws_max50,ws_min50,ws_ave50,ws_sta50,wd_inst50,wd_max50,wd_min50,wd_ave50,wd_sta50,ws_inst60,ws_max60,ws_min60,ws_ave60,ws_sta60,wd_inst60,wd_max60,wd_min60,wd_ave60,wd_sta60,ws_inst70,ws_max70,ws_min70,ws_ave70,ws_sta70,wd_inst70,wd_max70,wd_min70,wd_ave70,wd_sta70,ws_inst80,ws_max80,ws_min80,ws_ave80,ws_sta80,wd_inst80,wd_max80,wd_min80,wd_ave80,wd_sta80,ws_inst90,ws_max90,ws_min90,ws_ave90,ws_sta90,wd_inst90,wd_max90,wd_min90,wd_ave90,wd_sta90,ws_inst100,ws_max100,ws_min100,ws_ave100,ws_sta100,wd_inst100,wd_max100,wd_min100,wd_ave100,wd_sta100,ws_inst110,ws_max110,ws_min110,ws_ave110,ws_sta110,wd_inst110,wd_max110,wd_min110,wd_ave110,wd_sta110,ws_inst120,ws_max120,ws_min120,ws_ave120,ws_sta120,wd_inst120,wd_max120,wd_min120,wd_ave120,wd_sta120,wd_inst140,wd_max140,wd_min140,wd_ave140,wd_sta140,ws_inst140,ws_max140,ws_min140,ws_ave140,ws_sta140,wd_inst150,wd_max150,wd_min150,wd_ave150,wd_sta150,ws_inst150,ws_max150,ws_min150,ws_ave150,ws_sta150,air_density,abnormal_data,abnormal_type FROM wind_tower_status_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006177"] 2022-08-29 11:21:36.634 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1923a29a] Transaction not enabled 2022-08-29 11:21:36.725 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1661743240244_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1661743240244) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-08-29 11:21:41.290 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2ba3b4a6] Transaction not enabled 2022-08-29 11:21:43.104 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@22128b73] Transaction not enabled 2022-08-29 11:21:45.513 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@10c88d11] Transaction not enabled 2022-08-29 11:21:45.776 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661743240244 paused. 2022-08-29 11:21:45.807 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 11:21:45.807 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661743240244 shutting down. 2022-08-29 11:21:45.807 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661743240244 paused. 2022-08-29 11:21:45.808 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661743240244 shutdown complete. 2022-08-29 11:21:45.810 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 13:29:54.444 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 13:29:56.613 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 13:29:56.617 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 13:29:56.701 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 67 ms. Found 0 Redis repository interfaces. 2022-08-29 13:29:57.824 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@38732364' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 13:29:57.854 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 13:29:59.130 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4651 ms 2022-08-29 13:30:09.843 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 13:30:09.863 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 13:30:09.863 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 13:30:09.867 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 13:30:09.869 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 13:30:09.870 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661751009846' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 13:30:09.870 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 13:30:09.870 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 13:30:09.872 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@7fcfe065 2022-08-29 13:30:17.788 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 13:30:19.642 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 13:30:19.979 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 13:30:19.993 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 13:30:20.038 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 13:30:20.101 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 64734 (http) 2022-08-29 13:30:20.499 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 13:30:21.496 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 13:30:21.496 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751009846 shutting down. 2022-08-29 13:30:21.496 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751009846 paused. 2022-08-29 13:30:21.497 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751009846 shutdown complete. 2022-08-29 13:30:21.499 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 13:30:21.500 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 13:34:19.525 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 13:34:21.644 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 13:34:21.647 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 13:34:21.733 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 71 ms. Found 0 Redis repository interfaces. 2022-08-29 13:34:22.941 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@38732364' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 13:34:22.989 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 13:34:24.426 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4862 ms 2022-08-29 13:34:35.898 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 13:34:35.920 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 13:34:35.920 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 13:34:35.925 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 13:34:35.928 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 13:34:35.929 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661751275901' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 13:34:35.929 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 13:34:35.929 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 13:34:35.931 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@6dbdeb69 2022-08-29 13:34:43.023 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 13:34:44.955 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 13:34:45.267 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 13:34:45.287 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 13:34:45.335 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 13:34:45.384 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 65141 (http) 2022-08-29 13:34:45.762 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 13:34:46.764 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 13:34:47.318 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances. 2022-08-29 13:34:47.318 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-LAKSJ0V1661740639370"'s failed in-progress jobs. 2022-08-29 13:34:47.974 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751275901 started. 2022-08-29 13:34:48.635 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2237 millis. SELECT id,equipment_id,status,time,backup_inst,backup_max,backup_min,backup_ave,backup_sta,t_inst,t_max,t_min,t_ave,t_sta,rh_inst,rh_max,rh_min,rh_ave,rh_sta,pa_inst,pa_max,pa_min,pa_ave,pa_sta,ws_inst10,ws_max10,ws_min10,ws_ave10,ws_sta10,wd_inst10,wd_max10,wd_min10,wd_ave10,wd_sta10,ws_inst30,ws_max30,ws_min30,ws_ave30,ws_sta30,wd_inst30,wd_max30,wd_min30,wd_ave30,wd_sta30,ws_inst50,ws_max50,ws_min50,ws_ave50,ws_sta50,wd_inst50,wd_max50,wd_min50,wd_ave50,wd_sta50,ws_inst60,ws_max60,ws_min60,ws_ave60,ws_sta60,wd_inst60,wd_max60,wd_min60,wd_ave60,wd_sta60,ws_inst70,ws_max70,ws_min70,ws_ave70,ws_sta70,wd_inst70,wd_max70,wd_min70,wd_ave70,wd_sta70,ws_inst80,ws_max80,ws_min80,ws_ave80,ws_sta80,wd_inst80,wd_max80,wd_min80,wd_ave80,wd_sta80,ws_inst90,ws_max90,ws_min90,ws_ave90,ws_sta90,wd_inst90,wd_max90,wd_min90,wd_ave90,wd_sta90,ws_inst100,ws_max100,ws_min100,ws_ave100,ws_sta100,wd_inst100,wd_max100,wd_min100,wd_ave100,wd_sta100,ws_inst110,ws_max110,ws_min110,ws_ave110,ws_sta110,wd_inst110,wd_max110,wd_min110,wd_ave110,wd_sta110,ws_inst120,ws_max120,ws_min120,ws_ave120,ws_sta120,wd_inst120,wd_max120,wd_min120,wd_ave120,wd_sta120,wd_inst140,wd_max140,wd_min140,wd_ave140,wd_sta140,ws_inst140,ws_max140,ws_min140,ws_ave140,ws_sta140,wd_inst150,wd_max150,wd_min150,wd_ave150,wd_sta150,ws_inst150,ws_max150,ws_min150,ws_ave150,ws_sta150,air_density,abnormal_data,abnormal_type FROM wind_tower_status_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006177"] 2022-08-29 13:34:49.556 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6add8aac] Transaction not enabled 2022-08-29 13:34:50.209 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@57386162] Transaction not enabled 2022-08-29 13:34:50.789 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@46d2be66] Transaction not enabled 2022-08-29 13:34:51.392 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@55448710] Transaction not enabled 2022-08-29 13:34:51.587 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751275901 paused. 2022-08-29 13:34:51.613 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 13:34:51.613 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751275901 shutting down. 2022-08-29 13:34:51.614 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751275901 paused. 2022-08-29 13:34:51.615 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751275901 shutdown complete. 2022-08-29 13:34:51.617 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 13:35:35.367 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 13:35:37.500 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 13:35:37.504 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 13:35:37.584 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 65 ms. Found 0 Redis repository interfaces. 2022-08-29 13:35:38.710 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@48cd319d' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 13:35:38.743 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 13:35:40.043 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4632 ms 2022-08-29 13:35:50.153 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 13:35:50.176 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 13:35:50.176 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 13:35:50.181 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 13:35:50.185 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 13:35:50.187 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661751350156' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 13:35:50.187 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 13:35:50.187 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 13:35:50.189 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@6dbdeb69 2022-08-29 13:35:57.437 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 13:35:59.283 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 13:35:59.640 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 13:35:59.652 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 13:35:59.699 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 13:35:59.758 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 65242 (http) 2022-08-29 13:36:00.144 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 13:36:01.052 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 13:36:01.052 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751350156 shutting down. 2022-08-29 13:36:01.052 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751350156 paused. 2022-08-29 13:36:01.054 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661751350156 shutdown complete. 2022-08-29 13:36:01.055 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 13:36:01.146 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 15:05:43.488 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 15:05:45.874 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 15:05:45.878 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 15:05:45.971 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 73 ms. Found 0 Redis repository interfaces. 2022-08-29 15:05:47.194 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@40c28b0d' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 15:05:47.232 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 15:05:48.271 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4731 ms 2022-08-29 15:06:00.796 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 15:06:00.828 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 15:06:00.828 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 15:06:00.835 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 15:06:00.838 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 15:06:00.840 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661756760807' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 15:06:00.840 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 15:06:00.840 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 15:06:00.843 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5ed6a36a 2022-08-29 15:06:07.775 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 15:06:09.991 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 15:06:10.443 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 15:06:10.460 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 15:06:10.514 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 15:06:10.575 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 53165 (http) 2022-08-29 15:06:11.294 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 15:06:12.296 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 15:13:23.835 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 431081 millis. SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'ElfScheduler' AND LOCK_NAME = ? FOR UPDATE["STATE_ACCESS"] 2022-08-29 15:13:27.611 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3769 millis. SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'ElfScheduler'[] 2022-08-29 15:13:32.455 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1619 millis. SELECT DISTINCT INSTANCE_NAME FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler'[] 2022-08-29 15:13:42.307 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1876 millis. UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?[1661757216830,"DESKTOP-NA1JNLE1661756760807"] 2022-08-29 15:14:14.929 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 30087 millis. INSERT INTO QRTZ_SCHEDULER_STATE (SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('ElfScheduler', ?, ?, ?)["DESKTOP-NA1JNLE1661756760807",1661757216830,15000] 2022-08-29 15:14:17.384 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1314 millis. SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'ElfScheduler' AND LOCK_NAME = ? FOR UPDATE["TRIGGER_ACCESS"] 2022-08-29 15:14:28.221 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances. 2022-08-29 15:14:28.241 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "BF-2022072119451661755238232"'s failed in-progress jobs. 2022-08-29 15:14:39.082 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 6311 millis. SELECT * FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?["BF-2022072119451661755238232"] 2022-08-29 15:14:40.400 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1292 millis. DELETE FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?["BF-2022072119451661755238232"] 2022-08-29 15:14:46.050 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 15:14:46.050 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661756760807 shutting down. 2022-08-29 15:14:46.050 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661756760807 paused. 2022-08-29 15:14:46.051 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661756760807 shutdown complete. 2022-08-29 15:14:46.054 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 15:14:46.176 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661756760807 started. 2022-08-29 15:14:46.180 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1661756760807_MisfireHandler] ERROR o.s.scheduling.quartz.LocalDataSourceJobStore - MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Mon Aug 29 15:14:46 CST 2022 org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Mon Aug 29 15:14:46 CST 2022 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:168) at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3246) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:4012) at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:4033) Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Mon Aug 29 15:14:46 CST 2022 at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1574) at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1427) at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5059) at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:726) at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5055) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1405) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1397) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:100) at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:194) at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:140) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108) at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:165) ... 3 common frames omitted 2022-08-29 15:15:42.260 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 15:15:44.633 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 15:15:44.637 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 15:15:44.744 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 88 ms. Found 0 Redis repository interfaces. 2022-08-29 15:15:46.210 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@356f20b7' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 15:15:46.245 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 15:15:47.337 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5018 ms 2022-08-29 15:15:58.867 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 15:15:58.892 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 15:15:58.892 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 15:15:58.897 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 15:15:58.900 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 15:15:58.901 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661757358870' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 15:15:58.901 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 15:15:58.901 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 15:15:58.904 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@1912ba29 2022-08-29 15:16:06.178 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 15:16:08.442 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 15:16:08.827 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 15:16:08.844 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 15:16:08.899 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 15:16:08.965 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 53768 (http) 2022-08-29 15:16:09.793 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 15:16:28.135 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 15:16:38.342 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2309 millis. SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'ElfScheduler' AND LOCK_NAME = ? FOR UPDATE["STATE_ACCESS"] 2022-08-29 15:16:47.391 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 7513 millis. SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'ElfScheduler'[] 2022-08-29 15:16:47.458 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 15:16:47.458 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661757358870 shutting down. 2022-08-29 15:16:47.458 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661757358870 paused. 2022-08-29 15:16:47.459 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661757358870 shutdown complete. 2022-08-29 15:16:47.461 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 15:16:47.610 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances. 2022-08-29 15:16:47.611 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1661756760807"'s failed in-progress jobs. 2022-08-29 15:25:35.122 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 15:25:37.465 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 15:25:37.470 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 15:25:37.563 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 77 ms. Found 0 Redis repository interfaces. 2022-08-29 15:25:38.854 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@61eab26b' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 15:25:38.894 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 15:25:39.894 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4720 ms 2022-08-29 15:25:50.878 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 15:25:50.902 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 15:25:50.903 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 15:25:50.909 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 15:25:50.912 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 15:25:50.914 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661757950881' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 15:25:50.914 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 15:25:50.914 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 15:25:50.916 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@747b8f5c 2022-08-29 15:26:00.946 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 15:26:03.255 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 15:26:03.645 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 15:26:03.668 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 15:26:03.718 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 15:26:03.785 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 54244 (http) 2022-08-29 15:26:04.705 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 15:26:05.709 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 15:26:44.322 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 8980 millis. SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'ElfScheduler' AND LOCK_NAME = ? FOR UPDATE["STATE_ACCESS"] 2022-08-29 15:26:44.371 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 15:26:44.371 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661757950881 shutting down. 2022-08-29 15:26:44.371 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661757950881 paused. 2022-08-29 15:26:44.372 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661757950881 shutdown complete. 2022-08-29 15:26:44.375 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 16:08:20.216 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 16:08:22.575 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 16:08:22.580 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 16:08:22.667 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 67 ms. Found 0 Redis repository interfaces. 2022-08-29 16:08:23.984 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@5fa5c8cf' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:08:24.018 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:08:25.025 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4754 ms 2022-08-29 16:08:36.530 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 16:08:36.556 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 16:08:36.556 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 16:08:36.562 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 16:08:36.566 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 16:08:36.568 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661760516533' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 16:08:36.568 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 16:08:36.568 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 16:08:36.571 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@155cf9f6 2022-08-29 16:08:44.778 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 16:08:47.079 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 16:08:47.491 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 16:08:47.515 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 16:08:47.577 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 16:08:47.653 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 56422 (http) 2022-08-29 16:08:48.444 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 16:08:49.445 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 16:08:56.456 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2257 millis. SELECT DISTINCT INSTANCE_NAME FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler'[] 2022-08-29 16:09:00.635 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2921 millis. UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?[1661760536463,"DESKTOP-NA1JNLE1661760516533"] 2022-08-29 16:09:07.448 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1434 millis. INSERT INTO QRTZ_SCHEDULER_STATE (SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('ElfScheduler', ?, ?, ?)["DESKTOP-NA1JNLE1661760516533",1661760536463,15000] 2022-08-29 16:09:31.169 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 22264 millis. SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'ElfScheduler' AND LOCK_NAME = ? FOR UPDATE["TRIGGER_ACCESS"] 2022-08-29 16:09:31.170 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances. 2022-08-29 16:09:31.171 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "BF-2022072119451661760363031"'s failed in-progress jobs. 2022-08-29 16:09:31.245 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 16:09:31.246 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661760516533 shutting down. 2022-08-29 16:09:31.246 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661760516533 paused. 2022-08-29 16:09:31.247 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661760516533 shutdown complete. 2022-08-29 16:09:31.249 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 16:30:58.717 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 16:31:01.239 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 16:31:01.243 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 16:31:01.337 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 75 ms. Found 0 Redis repository interfaces. 2022-08-29 16:31:02.646 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@5eb2972f' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:31:02.678 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:31:03.732 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4953 ms 2022-08-29 16:31:15.691 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 16:31:15.718 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 16:31:15.719 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 16:31:15.727 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 16:31:15.731 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 16:31:15.734 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661761875694' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 16:31:15.734 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 16:31:15.734 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 16:31:15.736 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@63bdf82d 2022-08-29 16:31:26.041 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 16:31:28.774 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 16:31:29.228 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 16:31:29.248 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 16:31:29.321 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 16:31:29.392 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 57702 (http) 2022-08-29 16:31:30.189 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 16:31:30.978 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号006173，8月，玫瑰图计算失败，缺少测风塔数据^ ^ 2022-08-29 16:31:31.026 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 16:31:31.026 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661761875694 shutting down. 2022-08-29 16:31:31.026 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661761875694 paused. 2022-08-29 16:31:31.028 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661761875694 shutdown complete. 2022-08-29 16:31:31.030 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 16:31:31.191 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 16:41:51.493 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 16:41:53.819 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 16:41:53.824 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 16:41:53.936 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 90 ms. Found 0 Redis repository interfaces. 2022-08-29 16:41:55.353 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@f3876ef' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:41:55.391 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:41:56.387 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4839 ms 2022-08-29 16:42:07.949 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 16:42:07.971 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 16:42:07.971 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 16:42:07.977 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 16:42:07.980 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 16:42:07.982 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661762527952' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 16:42:07.982 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 16:42:07.982 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 16:42:07.984 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@27c9500c 2022-08-29 16:42:16.869 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 16:42:19.241 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 16:42:19.683 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 16:42:19.707 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 16:42:19.776 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 16:42:19.841 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 58293 (http) 2022-08-29 16:42:20.813 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 16:42:21.815 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 16:42:22.393 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762527952 started. 2022-08-29 16:42:22.605 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@10b9956a] Transaction not enabled 2022-08-29 16:42:24.007 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4ccfd904] Transaction not enabled 2022-08-29 16:42:57.035 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1661762527952_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5787 millis. SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'ElfScheduler'[] 2022-08-29 16:42:57.090 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1661762527952_MisfireHandler] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5837 millis. SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ?[1661762559239,"WAITING"] 2022-08-29 16:42:57.115 [ElfScheduler_QuartzSchedulerThread] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5843 millis. SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND TRIGGER_STATE = ? AND NEXT_FIRE_TIME <= ? AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= ?)) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC["WAITING",1661762601140,1661762559257] 2022-08-29 16:42:57.202 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762527952 paused. 2022-08-29 16:42:57.229 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 16:42:57.229 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762527952 shutting down. 2022-08-29 16:42:57.229 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762527952 paused. 2022-08-29 16:42:57.372 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762527952 shutdown complete. 2022-08-29 16:42:57.373 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 16:44:05.784 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 16:44:08.234 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 16:44:08.239 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 16:44:08.339 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 76 ms. Found 0 Redis repository interfaces. 2022-08-29 16:44:09.634 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@72f24a84' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:44:09.663 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:44:10.680 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4840 ms 2022-08-29 16:44:22.161 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 16:44:22.190 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 16:44:22.190 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 16:44:22.198 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 16:44:22.202 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 16:44:22.203 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661762662165' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 16:44:22.204 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 16:44:22.204 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 16:44:22.206 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@21a14c45 2022-08-29 16:44:30.366 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 16:44:32.722 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 16:44:33.168 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 16:44:33.189 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 16:44:33.250 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 16:44:33.326 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 58431 (http) 2022-08-29 16:44:34.707 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 16:44:35.709 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 16:44:36.201 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762662165 started. 2022-08-29 16:44:36.290 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6b7a96e1] Transaction not enabled 2022-08-29 16:45:13.766 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6d89f87d] Transaction not enabled 2022-08-29 16:46:02.555 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1661762662165_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1661762662165) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-08-29 16:46:56.788 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762662165 paused. 2022-08-29 16:46:56.820 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 16:46:56.820 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762662165 shutting down. 2022-08-29 16:46:56.820 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762662165 paused. 2022-08-29 16:46:56.960 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1661762662165_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1661762662165) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-08-29 16:46:57.339 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762662165 shutdown complete. 2022-08-29 16:46:57.343 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 16:48:09.858 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 16:48:12.191 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 16:48:12.195 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 16:48:12.285 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 72 ms. Found 0 Redis repository interfaces. 2022-08-29 16:48:13.548 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@fde487b' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:48:13.588 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:48:14.661 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4753 ms 2022-08-29 16:48:26.733 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 16:48:26.757 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 16:48:26.757 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 16:48:26.764 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 16:48:26.767 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 16:48:26.769 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661762906736' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 16:48:26.769 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 16:48:26.769 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 16:48:26.771 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@12830e23 2022-08-29 16:48:35.389 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 16:48:37.675 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 16:48:38.049 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 16:48:38.066 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 16:48:38.121 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 16:48:38.195 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 58672 (http) 2022-08-29 16:48:39.078 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 16:48:40.080 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 16:48:40.798 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762906736 started. 2022-08-29 16:48:40.830 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1307 millis. SELECT id,equipment_id,status,time,backup_inst,backup_max,backup_min,backup_ave,backup_sta,t_inst,t_max,t_min,t_ave,t_sta,rh_inst,rh_max,rh_min,rh_ave,rh_sta,pa_inst,pa_max,pa_min,pa_ave,pa_sta,ws_inst10,ws_max10,ws_min10,ws_ave10,ws_sta10,wd_inst10,wd_max10,wd_min10,wd_ave10,wd_sta10,ws_inst30,ws_max30,ws_min30,ws_ave30,ws_sta30,wd_inst30,wd_max30,wd_min30,wd_ave30,wd_sta30,ws_inst50,ws_max50,ws_min50,ws_ave50,ws_sta50,wd_inst50,wd_max50,wd_min50,wd_ave50,wd_sta50,ws_inst60,ws_max60,ws_min60,ws_ave60,ws_sta60,wd_inst60,wd_max60,wd_min60,wd_ave60,wd_sta60,ws_inst70,ws_max70,ws_min70,ws_ave70,ws_sta70,wd_inst70,wd_max70,wd_min70,wd_ave70,wd_sta70,ws_inst80,ws_max80,ws_min80,ws_ave80,ws_sta80,wd_inst80,wd_max80,wd_min80,wd_ave80,wd_sta80,ws_inst90,ws_max90,ws_min90,ws_ave90,ws_sta90,wd_inst90,wd_max90,wd_min90,wd_ave90,wd_sta90,ws_inst100,ws_max100,ws_min100,ws_ave100,ws_sta100,wd_inst100,wd_max100,wd_min100,wd_ave100,wd_sta100,ws_inst110,ws_max110,ws_min110,ws_ave110,ws_sta110,wd_inst110,wd_max110,wd_min110,wd_ave110,wd_sta110,ws_inst120,ws_max120,ws_min120,ws_ave120,ws_sta120,wd_inst120,wd_max120,wd_min120,wd_ave120,wd_sta120,wd_inst140,wd_max140,wd_min140,wd_ave140,wd_sta140,ws_inst140,ws_max140,ws_min140,ws_ave140,ws_sta140,wd_inst150,wd_max150,wd_min150,wd_ave150,wd_sta150,ws_inst150,ws_max150,ws_min150,ws_ave150,ws_sta150,air_density,abnormal_data,abnormal_type FROM wind_tower_status_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","5303"] 2022-08-29 16:48:41.752 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7dc779bb] Transaction not enabled 2022-08-29 16:48:42.505 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5aaab2b0] Transaction not enabled 2022-08-29 16:48:42.956 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762906736 paused. 2022-08-29 16:48:42.986 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 16:48:42.987 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762906736 shutting down. 2022-08-29 16:48:42.987 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762906736 paused. 2022-08-29 16:48:42.988 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762906736 shutdown complete. 2022-08-29 16:48:42.990 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 16:49:40.801 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 16:49:43.113 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 16:49:43.117 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 16:49:43.215 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 79 ms. Found 0 Redis repository interfaces. 2022-08-29 16:49:44.511 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@58ebee9' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:49:44.548 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 16:49:45.528 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4670 ms 2022-08-29 16:49:57.025 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 16:49:57.049 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 16:49:57.050 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 16:49:57.056 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 16:49:57.059 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 16:49:57.061 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661762997028' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 16:49:57.061 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 16:49:57.061 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 16:49:57.063 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5a438c0a 2022-08-29 16:50:05.435 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 16:50:07.756 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 16:50:08.196 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 16:50:08.216 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 16:50:08.277 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 16:50:08.347 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 58783 (http) 2022-08-29 16:50:09.194 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 16:50:10.194 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 16:50:10.635 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762997028 started. 2022-08-29 16:50:11.280 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7a845f91] Transaction not enabled 2022-08-29 16:50:12.811 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@52d57307] Transaction not enabled 2022-08-29 16:50:13.350 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762997028 paused. 2022-08-29 16:50:13.377 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 16:50:13.377 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762997028 shutting down. 2022-08-29 16:50:13.377 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762997028 paused. 2022-08-29 16:50:13.378 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661762997028 shutdown complete. 2022-08-29 16:50:13.380 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-08-29 17:01:13.726 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-08-29 17:01:16.469 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-08-29 17:01:16.473 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-08-29 17:01:16.566 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 75 ms. Found 0 Redis repository interfaces. 2022-08-29 17:01:17.825 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@bfd97fb' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 17:01:17.859 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2022-08-29 17:01:18.847 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5059 ms 2022-08-29 17:01:33.379 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-08-29 17:01:33.403 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-08-29 17:01:33.403 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-08-29 17:01:33.411 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-08-29 17:01:33.414 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-08-29 17:01:33.416 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1661763693382' 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 20 threads. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered. 2022-08-29 17:01:33.416 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-08-29 17:01:33.416 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-08-29 17:01:33.419 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@437ac2dc 2022-08-29 17:01:42.552 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-08-29 17:01:45.113 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-08-29 17:01:45.526 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-08-29 17:01:45.545 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-08-29 17:01:45.596 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-08-29 17:01:45.663 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 59335 (http) 2022-08-29 17:01:46.530 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-08-29 17:01:47.532 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-08-29 17:01:48.058 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661763693382 started. 2022-08-29 17:01:48.175 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fe9851f] Transaction not enabled 2022-08-29 17:01:48.766 [main] WARN c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2463a9ec] Transaction not enabled 2022-08-29 17:01:49.149 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.150 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.150 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.151 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.151 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.152 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.152 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.152 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.153 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.153 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，湍流玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.284 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.285 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.285 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.286 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.287 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.287 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.288 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.298 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.298 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.298 [main] INFO c.j.b.s.i.WindDirectionStatisticsDataServiceImpl - 设备编号5303，风切变玫瑰图计算失败，缺少100层测风塔数据^ ^ 2022-08-29 17:01:49.336 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661763693382 paused. 2022-08-29 17:01:49.364 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-08-29 17:01:49.365 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661763693382 shutting down. 2022-08-29 17:01:49.365 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661763693382 paused. 2022-08-29 17:01:49.367 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1661763693382 shutdown complete. 2022-08-29 17:01:49.369 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError