2022-09-05 09:35:15.515 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-05 09:35:17.819 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-05 09:35:17.823 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-05 09:35:17.915 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 74 ms. Found 0 Redis repository interfaces. 2022-09-05 09:35:19.231 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@7df3da0b' 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-09-05 09:35:19.268 [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-09-05 09:35:20.423 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4864 ms 2022-09-05 09:35:32.652 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-05 09:35:32.677 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-05 09:35:32.677 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-05 09:35:32.683 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-05 09:35:32.687 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-05 09:35:32.689 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1662341732655' 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-09-05 09:35:32.689 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-05 09:35:32.689 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-05 09:35:32.692 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@435848de 2022-09-05 09:35:40.880 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-05 09:35:43.244 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-05 09:35:43.681 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-05 09:35:43.702 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-05 09:35:43.759 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-05 09:35:43.829 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 50729 (http) 2022-09-05 09:35:44.658 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-05 09:35:45.659 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-05 09:35:46.432 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662341732655 started. 2022-09-05 09:36:15.885 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 30044 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-04 00:00:00","2022-09-04 23:59:59","7317"] 2022-09-05 09:37:02.366 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662341732655_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1662341732655) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-09-05 09:37:04.762 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662341732655_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2391 millis. UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?[1662341822368,"DESKTOP-NA1JNLE1662341732655"] 2022-09-05 09:37:04.823 [ElfScheduler_QuartzSchedulerThread] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2483 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",1662341852191,1662341810331] 2022-09-05 09:37:19.731 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662341732655_MisfireHandler] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3759 millis. SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ?[1662341823951,"WAITING"] 2022-09-05 09:37:29.960 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662341732655_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 10141 millis. UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?[1662341839801,"DESKTOP-NA1JNLE1662341732655"] 2022-09-05 09:38:12.116 [ElfScheduler_QuartzSchedulerThread] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 9092 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",1662341912836,1662341871011] 2022-09-05 09:38:12.164 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662341732655 paused. 2022-09-05 09:38:12.164 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662341732655_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1662341732655) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-09-05 09:38:12.193 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-05 09:38:12.193 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662341732655 shutting down. 2022-09-05 09:38:12.193 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662341732655 paused. 2022-09-05 09:38:12.209 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662341732655_MisfireHandler] ERROR o.s.scheduling.quartz.LocalDataSourceJobStore - MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': java.sql.SQLException org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': java.sql.SQLException 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: java.sql.SQLException: null at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1707) 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 Caused by: java.lang.InterruptedException: null at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2088) at com.alibaba.druid.pool.DruidDataSource.pollLast(DruidDataSource.java:2269) at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1688) ... 14 common frames omitted 2022-09-05 09:38:12.510 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662341732655 shutdown complete. 2022-09-05 09:38:12.515 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-05 09:39:52.804 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-05 09:39:55.502 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-05 09:39:55.507 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-05 09:39:55.618 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 86 ms. Found 0 Redis repository interfaces. 2022-09-05 09:39:57.141 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@45fb2354' 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-09-05 09:39:57.180 [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-09-05 09:39:58.337 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5471 ms 2022-09-05 09:40:10.311 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-05 09:40:10.332 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-05 09:40:10.332 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-05 09:40:10.337 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-05 09:40:10.340 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-05 09:40:10.341 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1662342010313' 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-09-05 09:40:10.341 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-05 09:40:10.341 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-05 09:40:10.343 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@64657b13 2022-09-05 09:40:18.591 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-05 09:40:20.823 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-05 09:40:21.265 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-05 09:40:21.287 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-05 09:40:21.346 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-05 09:40:21.450 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 50962 (http) 2022-09-05 09:40:22.333 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-05 09:40:23.334 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-05 09:40:23.826 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662342010313 started. 2022-09-05 09:40:53.508 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 30722 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-04 00:00:00","2022-09-04 23:59:59","7317"] 2022-09-05 09:41:36.257 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662342010313_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 15353 millis. SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'ElfScheduler'[] 2022-09-05 09:41:36.258 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662342010313_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1662342010313) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-09-05 09:41:41.763 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662342010313_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5397 millis. INSERT INTO QRTZ_SCHEDULER_STATE (SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('ElfScheduler', ?, ?, ?)["DESKTOP-NA1JNLE1662342010313",1662342096259,15000] 2022-09-05 09:41:45.227 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662342010313_MisfireHandler] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3359 millis. SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ?[1662342089841,"WAITING"] 2022-09-05 09:41:57.114 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662342010313_MisfireHandler] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3164 millis. SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ?[1662342101930,"WAITING"] 2022-09-05 09:41:57.149 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662342010313 paused. 2022-09-05 09:41:57.169 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-05 09:41:57.169 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662342010313 shutting down. 2022-09-05 09:41:57.169 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662342010313 paused. 2022-09-05 09:41:57.233 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662342010313 shutdown complete. 2022-09-05 09:41:57.234 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-05 10:12:56.372 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-05 10:12:58.430 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-05 10:12:58.433 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-05 10:12:58.509 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 62 ms. Found 0 Redis repository interfaces. 2022-09-05 10:12:59.632 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@1e226bcd' 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-09-05 10:12:59.657 [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-09-05 10:13:00.979 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4579 ms 2022-09-05 10:13:11.792 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-05 10:13:11.811 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-05 10:13:11.812 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-05 10:13:11.817 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-05 10:13:11.819 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-05 10:13:11.820 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1662343991794' 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-09-05 10:13:11.820 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-05 10:13:11.820 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-05 10:13:11.822 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@571c7572 2022-09-05 10:13:19.778 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-05 10:13:21.619 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-05 10:13:22.014 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-05 10:13:22.027 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-05 10:13:22.070 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-05 10:13:22.159 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 52479 (http) 2022-09-05 10:13:22.529 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-05 10:13:23.530 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-05 10:13:24.060 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662343991794 started. 2022-09-05 10:14:27.497 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 64280 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-04 00:00:00","2022-09-04 23:59:59","006173"] 2022-09-05 10:14:28.208 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662343991794 paused. 2022-09-05 10:14:28.241 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-05 10:14:28.241 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662343991794 shutting down. 2022-09-05 10:14:28.241 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662343991794 paused. 2022-09-05 10:14:28.243 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662343991794 shutdown complete. 2022-09-05 10:14:28.244 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-05 10:16:39.323 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-05 10:16:41.819 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-05 10:16:41.824 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-05 10:16:41.903 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 64 ms. Found 0 Redis repository interfaces. 2022-09-05 10:16:43.201 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@65ef9a0a' 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-09-05 10:16:43.247 [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-09-05 10:16:44.245 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4848 ms 2022-09-05 10:16:55.762 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-05 10:16:55.789 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-05 10:16:55.790 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-05 10:16:55.795 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-05 10:16:55.799 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-05 10:16:55.800 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1662344215766' 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-09-05 10:16:55.800 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-05 10:16:55.800 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-05 10:16:55.803 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@ae49f31 2022-09-05 10:17:09.697 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-05 10:17:11.937 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-05 10:17:12.362 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-05 10:17:12.382 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-05 10:17:12.454 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-05 10:17:12.522 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 52673 (http) 2022-09-05 10:17:13.288 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-05 10:17:14.289 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-05 10:17:15.124 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344215766 started. 2022-09-05 10:18:18.325 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 64499 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-04 00:00:00","2022-09-04 23:59:59","006173"] 2022-09-05 10:19:01.134 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1662344215766_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1662344215766) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-09-05 10:19:06.224 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344215766 paused. 2022-09-05 10:19:06.251 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-05 10:19:06.252 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344215766 shutting down. 2022-09-05 10:19:06.252 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344215766 paused. 2022-09-05 10:19:06.253 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344215766 shutdown complete. 2022-09-05 10:19:06.255 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-05 10:19:26.613 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-05 10:19:28.667 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-05 10:19:28.671 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-05 10:19:28.758 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 69 ms. Found 0 Redis repository interfaces. 2022-09-05 10:19:29.846 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@b1b471' 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-09-05 10:19:29.878 [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-09-05 10:19:31.143 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4498 ms 2022-09-05 10:19:42.005 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-05 10:19:42.027 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-05 10:19:42.027 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-05 10:19:42.033 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-05 10:19:42.036 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-05 10:19:42.037 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1662344382007' 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-09-05 10:19:42.037 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-05 10:19:42.037 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-05 10:19:42.039 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@4c12f54a 2022-09-05 10:19:50.122 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-05 10:19:52.021 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-05 10:19:52.352 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-05 10:19:52.370 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-05 10:19:52.415 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-05 10:19:52.471 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 52824 (http) 2022-09-05 10:19:52.847 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-05 10:19:53.849 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-05 10:19:54.342 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344382007 started. 2022-09-05 10:20:57.356 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 63853 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-04 00:00:00","2022-09-04 23:59:59","006173"] 2022-09-05 10:20:58.147 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344382007 paused. 2022-09-05 10:20:58.170 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-05 10:20:58.171 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344382007 shutting down. 2022-09-05 10:20:58.171 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344382007 paused. 2022-09-05 10:20:58.172 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1662344382007 shutdown complete. 2022-09-05 10:20:58.173 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError