123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189 |
- 2022-07-13 09:59:20.713 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-13 09:59:27.343 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-13 09:59:27.347 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-13 09:59:27.436 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 71 ms. Found 0 Redis repository interfaces.
- 2022-07-13 09:59:28.654 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@67acfde9' 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-13 09:59:28.684 [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-13 09:59:30.112 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 9371 ms
- 2022-07-13 09:59:38.795 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-13 09:59:38.819 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-13 09:59:38.819 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-13 09:59:38.827 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-13 09:59:38.830 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-13 09:59:38.831 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657677578798'
- 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-13 09:59:38.831 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-13 09:59:38.831 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-13 09:59:38.834 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@4a0c04ab
- 2022-07-13 09:59:41.766 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-13 09:59:43.846 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-13 09:59:44.216 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-13 09:59:44.233 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-13 09:59:44.289 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-13 09:59:44.353 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 53646 (http)
- 2022-07-13 09:59:44.784 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-13 09:59:45.785 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-13 09:59:45.796 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-13 09:59:45.796 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657677578798 shutting down.
- 2022-07-13 09:59:45.796 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657677578798 paused.
- 2022-07-13 09:59:45.797 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657677578798 shutdown complete.
- 2022-07-13 09:59:45.799 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-13 09:59:45.837 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657677578798 started.
- 2022-07-13 09:59:45.856 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1657677578798_MisfireHandler] ERROR o.s.scheduling.quartz.LocalDataSourceJobStore - MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Wed Jul 13 09:59:45 CST 2022
- org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Wed Jul 13 09:59:45 CST 2022
- at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:168)
- at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3246)
- at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:4012)
- at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:4033)
- Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Wed Jul 13 09:59:45 CST 2022
- at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1574)
- at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1427)
- at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5059)
- at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:726)
- at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5055)
- at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1405)
- at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1397)
- at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:100)
- at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:194)
- at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:140)
- at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
- at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:165)
- ... 3 common frames omitted
- 2022-07-13 10:46:07.528 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-13 10:46:09.885 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-13 10:46:09.889 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-13 10:46:09.987 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 77 ms. Found 0 Redis repository interfaces.
- 2022-07-13 10:46:11.260 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@7be7c052' 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-13 10:46:11.295 [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-13 10:46:12.377 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4792 ms
- 2022-07-13 10:46:20.746 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-13 10:46:20.774 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-13 10:46:20.774 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-13 10:46:20.782 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-13 10:46:20.787 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-13 10:46:20.788 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657680380749'
- 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-13 10:46:20.789 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-13 10:46:20.789 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-13 10:46:20.793 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@6992a147
- 2022-07-13 10:46:24.050 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-13 10:46:26.387 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-13 10:46:26.815 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-13 10:46:26.832 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-13 10:46:26.896 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-13 10:46:26.966 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 56184 (http)
- 2022-07-13 10:46:27.971 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-13 10:47:32.530 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-13 10:47:36.930 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680380749 started.
- 2022-07-13 10:47:40.144 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3203 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-12 00:00:00","2022-07-12 23:59:59","006172"]
- 2022-07-13 10:48:30.891 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1657680380749_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1657680380749) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
- 2022-07-13 10:48:59.860 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1657680380749_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1657680380749) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
- 2022-07-13 10:49:32.052 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680380749 paused.
- 2022-07-13 10:49:32.078 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-13 10:49:32.078 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680380749 shutting down.
- 2022-07-13 10:49:32.078 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680380749 paused.
- 2022-07-13 10:49:32.080 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680380749 shutdown complete.
- 2022-07-13 10:49:32.081 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-13 10:50:33.423 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-13 10:50:35.518 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-13 10:50:35.522 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-13 10:50:35.605 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 69 ms. Found 0 Redis repository interfaces.
- 2022-07-13 10:50:36.874 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@67acfde9' 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-13 10:50:36.906 [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-13 10:50:38.335 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4878 ms
- 2022-07-13 10:50:46.459 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-13 10:50:46.481 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-13 10:50:46.481 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-13 10:50:46.486 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-13 10:50:46.491 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-13 10:50:46.492 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657680646461'
- 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-13 10:50:46.493 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-13 10:50:46.493 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-13 10:50:46.495 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2d1f3639
- 2022-07-13 10:50:49.101 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-13 10:50:51.241 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-13 10:50:51.602 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-13 10:50:51.620 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-13 10:50:51.669 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-13 10:50:51.736 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 56408 (http)
- 2022-07-13 10:50:52.167 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-13 10:50:53.168 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-13 10:50:53.477 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680646461 started.
- 2022-07-13 10:50:56.822 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3915 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-12 00:00:00","2022-07-12 23:59:59","006172"]
- 2022-07-13 10:50:58.658 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680646461 paused.
- 2022-07-13 10:50:58.681 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-13 10:50:58.681 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680646461 shutting down.
- 2022-07-13 10:50:58.681 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680646461 paused.
- 2022-07-13 10:50:58.683 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657680646461 shutdown complete.
- 2022-07-13 10:50:58.684 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-13 13:32:52.875 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-13 13:32:57.698 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-13 13:32:57.704 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-13 13:32:57.805 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 75 ms. Found 0 Redis repository interfaces.
- 2022-07-13 13:32:59.843 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@2db86a7c' 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-13 13:32:59.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-07-13 13:33:02.613 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 9695 ms
- 2022-07-13 13:33:34.988 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-13 13:33:37.497 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-13 13:33:37.500 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-13 13:33:37.609 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 86 ms. Found 0 Redis repository interfaces.
- 2022-07-13 13:33:38.935 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@611d0763' 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-13 13:33:38.973 [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-13 13:33:40.458 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5426 ms
- 2022-07-13 13:33:49.271 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-13 13:33:49.294 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-13 13:33:49.294 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-13 13:33:49.300 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-13 13:33:49.304 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-13 13:33:49.305 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1657690429274'
- 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-13 13:33:49.306 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-13 13:33:49.306 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-13 13:33:49.308 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@15a0f9
- 2022-07-13 13:33:52.129 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-13 13:33:54.499 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-13 13:33:54.933 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-13 13:33:54.951 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-13 13:33:55.012 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-13 13:33:55.087 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 53552 (http)
- 2022-07-13 13:33:55.520 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-13 13:33:56.521 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-13 13:33:56.652 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657690429274 started.
- 2022-07-13 13:33:58.832 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2581 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-12 00:00:00","2022-07-12 23:59:59","006172"]
- 2022-07-13 13:34:00.709 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657690429274 paused.
- 2022-07-13 13:34:00.731 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-13 13:34:00.731 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657690429274 shutting down.
- 2022-07-13 13:34:00.731 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657690429274 paused.
- 2022-07-13 13:34:00.733 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1657690429274 shutdown complete.
- 2022-07-13 13:34:00.734 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
|