2022-07-07 13:21:10.961 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-07-07 13:21:13.177 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-07-07 13:21:13.180 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-07-07 13:21:13.260 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 64 ms. Found 0 Redis repository interfaces. 2022-07-07 13:21:14.836 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@3fde2209' 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-07-07 13:21:14.867 [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-07-07 13:21:16.269 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5278 ms 2022-07-07 13:21:25.114 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-07-07 13:21:25.140 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-07-07 13:21:25.140 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-07-07 13:21:25.146 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-07-07 13:21:25.150 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-07-07 13:21:25.152 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657171285118' 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-07-07 13:21:25.153 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-07-07 13:21:25.153 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-07-07 13:21:25.156 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@7a14ab66 2022-07-07 13:21:27.812 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-07-07 13:21:30.248 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-07-07 13:21:30.677 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-07-07 13:21:30.691 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-07-07 13:21:30.753 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-07-07 13:21:30.816 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 50560 (http) 2022-07-07 13:21:31.243 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-07-07 13:21:32.205 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-07-07 13:21:32.205 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657171285118 shutting down. 2022-07-07 13:21:32.205 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657171285118 paused. 2022-07-07 13:21:32.207 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657171285118 shutdown complete. 2022-07-07 13:21:32.209 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-07-07 13:21:32.245 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-07-07 13:22:08.260 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-07-07 13:22:10.625 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-07-07 13:22:10.630 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-07-07 13:22:10.725 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 75 ms. Found 0 Redis repository interfaces. 2022-07-07 13:22:12.025 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@73da7f08' 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-07-07 13:22:12.063 [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-07-07 13:22:13.074 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4758 ms 2022-07-07 13:22:21.093 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-07-07 13:22:21.122 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-07-07 13:22:21.122 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-07-07 13:22:21.128 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-07-07 13:22:21.132 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-07-07 13:22:21.133 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657171341096' 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-07-07 13:22:21.134 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-07-07 13:22:21.134 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-07-07 13:22:21.137 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2ed9e59b 2022-07-07 13:22:24.451 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-07-07 13:22:27.110 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-07-07 13:22:27.591 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-07-07 13:22:27.610 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-07-07 13:22:27.681 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-07-07 13:22:27.763 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 50695 (http) 2022-07-07 13:22:28.296 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-07-07 13:22:29.054 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-07-07 13:22:29.054 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657171341096 shutting down. 2022-07-07 13:22:29.054 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657171341096 paused. 2022-07-07 13:22:29.055 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657171341096 shutdown complete. 2022-07-07 13:22:29.057 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-07-07 13:37:18.624 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-07-07 13:37:20.755 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-07-07 13:37:20.759 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-07-07 13:37:20.844 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 70 ms. Found 0 Redis repository interfaces. 2022-07-07 13:37:21.999 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@4f114b' 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-07-07 13:37:22.031 [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-07-07 13:37:23.308 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4638 ms 2022-07-07 13:37:30.988 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-07-07 13:37:31.012 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-07-07 13:37:31.012 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-07-07 13:37:31.017 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-07-07 13:37:31.021 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-07-07 13:37:31.022 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657172250991' 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-07-07 13:37:31.022 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-07-07 13:37:31.022 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-07-07 13:37:31.025 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@7a14ab66 2022-07-07 13:37:33.926 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-07-07 13:37:36.076 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-07-07 13:37:36.484 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-07-07 13:37:36.498 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-07-07 13:37:36.546 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-07-07 13:37:36.614 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 52287 (http) 2022-07-07 13:37:37.055 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-07-07 13:37:38.056 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-07-07 13:37:38.244 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657172250991 started. 2022-07-07 13:37:40.693 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2709 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 = ?)["2021-07-06 00:00:00","2022-07-06 23:59:59","006172"] 2022-07-07 13:37:47.481 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657172250991 paused. 2022-07-07 13:37:47.507 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-07-07 13:37:47.508 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657172250991 shutting down. 2022-07-07 13:37:47.508 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657172250991 paused. 2022-07-07 13:37:47.509 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657172250991 shutdown complete. 2022-07-07 13:37:47.511 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-07-07 14:04:57.416 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-07-07 14:04:59.669 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-07-07 14:04:59.672 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-07-07 14:04:59.767 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 80 ms. Found 0 Redis repository interfaces. 2022-07-07 14:05:00.945 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@281b2dfd' 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-07-07 14:05:00.974 [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-07-07 14:05:02.254 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4799 ms 2022-07-07 14:05:09.840 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-07-07 14:05:09.860 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-07-07 14:05:09.861 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-07-07 14:05:09.867 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-07-07 14:05:09.871 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-07-07 14:05:09.872 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657173909843' 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-07-07 14:05:09.873 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-07-07 14:05:09.873 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-07-07 14:05:09.876 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@48126a17 2022-07-07 14:05:13.423 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-07-07 14:05:15.312 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-07-07 14:05:15.677 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-07-07 14:05:15.690 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-07-07 14:05:15.748 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-07-07 14:05:15.823 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 55229 (http) 2022-07-07 14:05:16.200 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-07-07 14:05:17.201 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-07-07 14:05:17.345 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173909843 started. 2022-07-07 14:05:19.934 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2891 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 = ?)["2021-07-06 00:00:00","2022-07-06 23:59:59","006172"] 2022-07-07 14:05:26.866 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173909843 paused. 2022-07-07 14:05:26.893 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-07-07 14:05:26.893 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173909843 shutting down. 2022-07-07 14:05:26.893 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173909843 paused. 2022-07-07 14:05:26.895 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173909843 shutdown complete. 2022-07-07 14:05:26.896 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-07-07 14:06:08.558 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-07-07 14:06:10.866 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-07-07 14:06:10.871 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-07-07 14:06:10.964 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 74 ms. Found 0 Redis repository interfaces. 2022-07-07 14:06:12.302 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@281b2dfd' 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-07-07 14:06:12.336 [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-07-07 14:06:13.826 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5226 ms 2022-07-07 14:06:22.469 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-07-07 14:06:22.491 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-07-07 14:06:22.491 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-07-07 14:06:22.498 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-07-07 14:06:22.501 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-07-07 14:06:22.503 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657173982473' 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-07-07 14:06:22.503 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-07-07 14:06:22.503 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-07-07 14:06:22.506 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@9c5d76b 2022-07-07 14:06:26.215 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-07-07 14:06:28.451 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-07-07 14:06:28.860 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-07-07 14:06:28.878 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-07-07 14:06:28.939 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-07-07 14:06:29.006 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 55430 (http) 2022-07-07 14:06:29.435 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-07-07 14:06:30.436 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-07-07 14:06:30.725 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173982473 started. 2022-07-07 14:06:36.919 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 6012 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 = ?)["2021-07-06 00:00:00","2022-07-06 23:59:59","006172"] 2022-07-07 14:06:44.548 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173982473 paused. 2022-07-07 14:06:44.573 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-07-07 14:06:44.573 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173982473 shutting down. 2022-07-07 14:06:44.573 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173982473 paused. 2022-07-07 14:06:44.574 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657173982473 shutdown complete. 2022-07-07 14:06:44.575 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-07-07 15:28:50.579 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-07-07 15:28:52.722 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-07-07 15:28:52.726 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-07-07 15:28:52.813 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 70 ms. Found 0 Redis repository interfaces. 2022-07-07 15:28:53.957 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@4f114b' 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-07-07 15:28:53.986 [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-07-07 15:28:55.260 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4646 ms 2022-07-07 15:29:03.212 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-07-07 15:29:03.232 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-07-07 15:29:03.232 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-07-07 15:29:03.238 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-07-07 15:29:03.241 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-07-07 15:29:03.242 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657178943214' 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-07-07 15:29:03.242 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-07-07 15:29:03.242 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-07-07 15:29:03.245 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5b31a9e3 2022-07-07 15:29:06.075 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-07-07 15:29:08.125 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-07-07 15:29:08.543 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-07-07 15:29:08.558 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-07-07 15:29:08.616 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-07-07 15:29:08.685 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 64092 (http) 2022-07-07 15:29:09.113 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-07-07 15:29:10.062 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-07-07 15:29:10.062 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657178943214 shutting down. 2022-07-07 15:29:10.062 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657178943214 paused. 2022-07-07 15:29:10.063 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657178943214 shutdown complete. 2022-07-07 15:29:10.065 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-07-07 15:29:10.114 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds