2022-09-21 09:27:23.008 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-21 09:27:26.201 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-21 09:27:26.208 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-21 09:27:26.321 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 91 ms. Found 0 Redis repository interfaces. 2022-09-21 09:27:26.559 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration. 2022-09-21 09:27:28.359 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@65259c53' 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-21 09:27:28.403 [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-21 09:27:29.415 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6343 ms 2022-09-21 09:27:40.691 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-21 09:27:40.724 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-21 09:27:40.724 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-21 09:27:40.730 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-21 09:27:40.734 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-21 09:27:40.736 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663723660696' 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-21 09:27:40.736 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-21 09:27:40.736 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-21 09:27:40.740 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@47541b42 2022-09-21 09:27:43.992 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-21 09:27:47.309 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-21 09:27:47.824 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-21 09:27:47.852 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-21 09:27:47.919 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-21 09:27:47.995 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 58175 (http) 2022-09-21 09:27:48.989 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-21 09:27:49.990 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-21 09:27:50.416 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 started. 2022-09-21 09:27:55.660 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 6091 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173 WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"] 2022-09-21 09:29:42.949 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 paused. 2022-09-21 09:29:42.991 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-21 09:29:42.991 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 shutting down. 2022-09-21 09:29:42.991 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 paused. 2022-09-21 09:29:42.997 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663723660696_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1663723660696) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-09-21 09:29:43.005 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663723660696_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-21 09:29:43.036 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 shutdown complete. 2022-09-21 09:29:43.039 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-21 09:46:09.371 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-21 09:46:13.160 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-21 09:46:13.166 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-21 09:46:13.310 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 125 ms. Found 0 Redis repository interfaces. 2022-09-21 09:46:13.735 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration. 2022-09-21 09:46:16.454 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@447521e' 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-21 09:46:16.508 [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-21 09:46:18.749 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 9329 ms 2022-09-21 09:46:19.306 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-21 09:46:25.913 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-21 09:46:25.922 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-21 09:46:26.205 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 213 ms. Found 0 Redis repository interfaces. 2022-09-21 09:46:26.669 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration. 2022-09-21 09:46:29.806 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@990b86b' 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-21 09:46:29.902 [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-21 09:46:33.414 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 14084 ms 2022-09-21 09:46:41.359 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-21 09:46:41.456 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-21 09:46:41.462 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-21 09:46:41.479 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-21 09:46:41.493 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-21 09:46:41.496 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663724801368' 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-21 09:46:41.496 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-21 09:46:41.497 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-21 09:46:41.501 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@6b756a62 2022-09-21 09:46:46.786 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-21 09:46:50.050 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-21 09:46:50.583 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-21 09:46:50.611 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-21 09:46:50.714 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-21 09:46:50.792 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 59322 (http) 2022-09-21 09:46:51.669 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-21 09:46:52.540 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-21 09:46:52.579 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-21 09:46:52.579 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-21 09:46:52.588 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-21 09:46:52.592 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-21 09:46:52.594 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663724812544' 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-21 09:46:52.594 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-21 09:46:52.594 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-21 09:46:52.598 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5b3427c4 2022-09-21 09:46:52.688 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-21 09:46:52.771 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 started. 2022-09-21 09:46:58.776 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5886 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173 WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"] 2022-09-21 09:47:00.722 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-21 09:47:06.099 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-21 09:47:07.052 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-21 09:47:07.127 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-21 09:47:07.219 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-21 09:47:07.357 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 59354 (http) 2022-09-21 09:47:09.035 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-21 09:47:10.041 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-21 09:47:10.293 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 started. 2022-09-21 09:47:11.075 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 paused. 2022-09-21 09:47:11.109 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-21 09:47:11.109 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 shutting down. 2022-09-21 09:47:11.109 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 paused. 2022-09-21 09:47:11.111 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 shutdown complete. 2022-09-21 09:47:11.114 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-21 09:47:15.176 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5354 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173 WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"] 2022-09-21 09:47:59.508 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663724812544_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1663724812544) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-09-21 09:48:45.911 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663724812544_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 20673 millis. INSERT INTO QRTZ_SCHEDULER_STATE (SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('ElfScheduler', ?, ?, ?)["DESKTOP-NA1JNLE1663724812544",1663724879545,15000] 2022-09-21 09:48:45.912 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663724812544_MisfireHandler] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 11667 millis. SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ?[1663724891092,"WAITING"] 2022-09-21 09:48:48.068 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 paused. 2022-09-21 09:48:48.092 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-21 09:48:48.092 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 shutting down. 2022-09-21 09:48:48.093 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 paused. 2022-09-21 09:48:48.094 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 shutdown complete. 2022-09-21 09:48:48.096 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-21 09:49:09.383 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-21 09:49:12.433 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-21 09:49:12.439 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-21 09:49:12.566 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 99 ms. Found 0 Redis repository interfaces. 2022-09-21 09:49:12.796 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration. 2022-09-21 09:49:14.477 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@2cc34cd5' 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-21 09:49:14.525 [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-21 09:49:15.522 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6052 ms 2022-09-21 09:49:25.844 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-21 09:49:25.879 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-21 09:49:25.880 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-21 09:49:25.888 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-21 09:49:25.891 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-21 09:49:25.893 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663724965848' 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-21 09:49:25.893 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-21 09:49:25.893 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-21 09:49:25.896 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@769d0ef2 2022-09-21 09:49:29.099 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-21 09:49:32.027 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-21 09:49:32.521 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-21 09:49:32.545 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-21 09:49:32.669 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-21 09:49:32.756 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 59514 (http) 2022-09-21 09:49:33.836 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-21 09:49:34.839 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-21 09:49:35.085 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 started. 2022-09-21 09:49:39.665 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5289 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173 WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"] 2022-09-21 09:54:40.062 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663724965848_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1663724965848) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2022-09-21 09:54:42.304 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 paused. 2022-09-21 09:54:42.331 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-21 09:54:42.331 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 shutting down. 2022-09-21 09:54:42.331 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 paused. 2022-09-21 09:54:42.332 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 shutdown complete. 2022-09-21 09:54:42.334 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-21 09:59:55.145 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-21 09:59:58.218 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-21 09:59:58.226 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-21 09:59:58.372 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 112 ms. Found 0 Redis repository interfaces. 2022-09-21 09:59:58.650 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration. 2022-09-21 10:00:00.362 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@6b3b4f37' 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-21 10:00:00.397 [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-21 10:00:01.440 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6224 ms 2022-09-21 10:00:12.314 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-21 10:00:12.346 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-21 10:00:12.346 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-21 10:00:12.353 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-21 10:00:12.358 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-21 10:00:12.360 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663725612318' 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-21 10:00:12.360 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-21 10:00:12.360 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-21 10:00:12.364 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2f32fe68 2022-09-21 10:00:15.632 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-21 10:00:18.529 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-21 10:00:19.053 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-21 10:00:19.076 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-21 10:00:19.143 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-21 10:00:19.224 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 60140 (http) 2022-09-21 10:00:20.283 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-21 10:00:21.285 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-21 10:00:21.626 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 started. 2022-09-21 10:00:25.708 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 4851 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173 WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"] 2022-09-21 10:00:44.050 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 paused. 2022-09-21 10:00:44.073 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-21 10:00:44.074 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 shutting down. 2022-09-21 10:00:44.074 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 paused. 2022-09-21 10:00:44.076 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 shutdown complete. 2022-09-21 10:00:44.078 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-21 15:29:19.597 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-21 15:29:22.353 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-21 15:29:22.357 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-21 15:29:22.447 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 73 ms. Found 0 Redis repository interfaces. 2022-09-21 15:29:22.646 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration. 2022-09-21 15:29:24.215 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@482f7af0' 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-21 15:29:24.248 [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-21 15:29:25.782 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6150 ms 2022-09-21 15:29:36.086 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-21 15:29:36.118 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-21 15:29:36.119 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-21 15:29:36.125 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-21 15:29:36.129 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-21 15:29:36.131 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663745376090' 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-21 15:29:36.131 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-21 15:29:36.131 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-21 15:29:36.135 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@3e1c5e0d 2022-09-21 15:29:43.147 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-21 15:29:45.674 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-21 15:29:46.178 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-21 15:29:46.202 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-21 15:29:46.282 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-21 15:29:46.376 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 51832 (http) 2022-09-21 15:29:47.013 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-21 15:29:48.014 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-21 15:29:48.579 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 started. 2022-09-21 15:31:21.745 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 81343 millis. SELECT * FROM ( SELECT * FROM wind_tower_data_parent_table_5302 WHERE equipment_id = ? AND time BETWEEN ? AND ? ) tp INNER JOIN ( SELECT ea.field_name,tc.* from wind_tower_data_child_table_5302 tc LEFT JOIN equipment_attribute ea on tc.layer_height= ea.id) tc ON tp.id = tc.parent_id ORDER BY tp.time["5302","2021-09-20 00:00:00","2022-09-20 23:59:59"] 2022-09-21 15:31:42.909 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 8586 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_5302 WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-09-01 00:00:00","2022-09-30 23:59:59","5302"] 2022-09-21 15:31:51.805 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1274 millis. DELETE FROM wind_tower_calculation_data_5302 WHERE (time BETWEEN ? AND ? AND equipment_id = ? AND eb_id = ?)["2022-09-13 00:00:00","2022-09-20 23:59:59","5302","1be74b1a-b180-4549-a9ef-42c8259240b7"] 2022-09-21 15:31:53.587 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1736 millis. DELETE FROM wind_tower_calculation_data_5302 WHERE (time BETWEEN ? AND ? AND equipment_id = ? AND eb_id = ?)["2022-09-13 00:00:00","2022-09-20 23:59:59","5302","1bfeafe7-b466-403e-9457-212fa2aa2d77"] 2022-09-21 15:31:59.569 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 4878 millis. INSERT INTO wind_tower_calculation_data_5302 ( id, equipment_id, eb_id, time, value ) VALUES ( ?, ?, ?, ?, ? )["2e873b4fa131017110a6ea0a8adb9fd5","5302","dc7be6b0-24fa-42de-918e-f4c3d106d60c","2022-09-14 19:00:00",1004.65] 2022-09-21 15:32:02.310 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2658 millis. INSERT INTO wind_tower_calculation_data_5302 ( id, equipment_id, eb_id, time, value ) VALUES ( ?, ?, ?, ?, ? )["bd19fc2d6a9601292aecd364ed57049e","5302","909a33ee-819c-4046-9139-769789c93e2e","2022-09-19 07:00:00",228.95] 2022-09-21 15:32:02.310 [schedule-pool-1] INFO c.j.b.s.impl.WindTowerCalculationDataServiceImpl - 平均风速和风功率密度成功^ ^ 2022-09-21 15:32:02.320 [schedule-pool-1] INFO c.j.b.s.impl.WindTowerCalculationDataServiceImpl - 开始计算小时风切变指数 2022-09-21 15:32:08.665 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 6308 millis. DELETE FROM wind_tower_calculation_data_5302 WHERE (time BETWEEN ? AND ? AND equipment_id = ? AND eb_id = ?)["2022-09-13 00:00:00","2022-09-20 23:59:59","5302","cbe9b35b-8fad-4b8a-a9f9-d818620bc1c1"] 2022-09-21 15:32:12.936 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 144835 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173 WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006173"] 2022-09-21 15:32:13.394 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 paused. 2022-09-21 15:32:13.427 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-21 15:32:13.427 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 shutting down. 2022-09-21 15:32:13.427 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 paused. 2022-09-21 15:32:13.429 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 shutdown complete. 2022-09-21 15:32:13.430 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-21 15:35:53.444 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-21 15:35:56.055 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-21 15:35:56.059 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-21 15:35:56.168 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 92 ms. Found 0 Redis repository interfaces. 2022-09-21 15:35:56.405 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration. 2022-09-21 15:35:57.893 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@99a8de3' 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-21 15:35:57.931 [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-21 15:35:59.316 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5839 ms 2022-09-21 15:36:09.059 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-21 15:36:09.086 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-21 15:36:09.086 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-21 15:36:09.093 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-21 15:36:09.098 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-21 15:36:09.099 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663745769063' 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-21 15:36:09.100 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-21 15:36:09.100 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-21 15:36:09.103 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@24ee6faa 2022-09-21 15:36:10.181 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1003 millis. DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler'[] 2022-09-21 15:36:12.135 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1302 millis. DELETE FROM QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler'[] 2022-09-21 15:36:20.597 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-21 15:36:22.614 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-21 15:36:22.974 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-21 15:36:22.996 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-21 15:36:23.060 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-21 15:36:23.134 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 52444 (http) 2022-09-21 15:36:23.592 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-21 15:36:24.593 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-21 15:36:24.766 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 started. 2022-09-21 15:38:13.338 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 108985 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173 WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006173"] 2022-09-21 15:38:14.424 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 paused. 2022-09-21 15:38:14.454 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-21 15:38:14.454 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 shutting down. 2022-09-21 15:38:14.454 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 paused. 2022-09-21 15:38:14.455 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 shutdown complete. 2022-09-21 15:38:14.457 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError 2022-09-21 16:02:59.678 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final 2022-09-21 16:03:02.418 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode! 2022-09-21 16:03:02.422 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 2022-09-21 16:03:02.533 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 89 ms. Found 0 Redis repository interfaces. 2022-09-21 16:03:02.776 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration. 2022-09-21 16:03:04.211 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@1e56bc9b' 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-21 16:03:04.248 [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-21 16:03:05.572 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5846 ms 2022-09-21 16:03:15.061 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-09-21 16:03:15.086 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-09-21 16:03:15.086 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 2022-09-21 16:03:15.093 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 2022-09-21 16:03:15.097 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 2022-09-21 16:03:15.098 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663747395064' 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-21 16:03:15.098 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance. 2022-09-21 16:03:15.098 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 2022-09-21 16:03:15.101 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@351d726c 2022-09-21 16:03:23.689 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator' 2022-09-21 16:03:25.843 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request 2022-09-21 16:03:26.288 [main] INFO org.xnio - XNIO version 3.8.6.Final 2022-09-21 16:03:26.312 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final 2022-09-21 16:03:26.368 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final 2022-09-21 16:03:26.436 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 54578 (http) 2022-09-21 16:03:26.905 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds 2022-09-21 16:03:27.905 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds 2022-09-21 16:03:28.201 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 started. 2022-09-21 16:09:32.018 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 364344 millis. SELECT * FROM ( SELECT * FROM wind_tower_data_parent_table_006173 WHERE equipment_id = ? AND time BETWEEN ? AND ? ) tp INNER JOIN ( SELECT ea.field_name,tc.* from wind_tower_data_child_table_006173 tc LEFT JOIN equipment_attribute ea on tc.layer_height= ea.id) tc ON tp.id = tc.parent_id ORDER BY tp.time["006173","2022-09-13 23:59:59","2022-09-20 23:59:59"] 2022-09-21 16:09:33.644 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 paused. 2022-09-21 16:09:33.670 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 2022-09-21 16:09:33.671 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 shutting down. 2022-09-21 16:09:33.671 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 paused. 2022-09-21 16:09:33.672 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 shutdown complete. 2022-09-21 16:09:33.674 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError