123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831 |
- 2022-07-04 09:09:39.766 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 09:09:46.621 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 09:09:46.625 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 09:09:46.717 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 72 ms. Found 0 Redis repository interfaces.
- 2022-07-04 09:09:48.203 [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-07-04 09:09:48.306 [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-04 09:09:49.525 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 9697 ms
- 2022-07-04 09:09:59.606 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 09:09:59.626 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 09:09:59.626 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 09:09:59.632 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 09:09:59.635 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 09:09:59.636 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656896999609'
- 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-04 09:09:59.636 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 09:09:59.636 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 09:09:59.639 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2fb9695a
- 2022-07-04 09:10:04.933 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 09:10:07.250 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 09:10:07.705 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 09:10:07.727 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 09:10:07.789 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 09:10:07.863 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 61734 (http)
- 2022-07-04 09:10:08.330 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 09:10:09.331 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 09:10:09.496 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 09:10:09.496 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656639387413"'s failed in-progress jobs.
- 2022-07-04 09:10:10.041 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656896999609 started.
- 2022-07-04 09:10:19.255 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 9732 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 09:10:20.717 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656896999609 paused.
- 2022-07-04 09:10:20.743 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 09:10:20.743 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656896999609 shutting down.
- 2022-07-04 09:10:20.744 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656896999609 paused.
- 2022-07-04 09:10:20.745 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656896999609 shutdown complete.
- 2022-07-04 09:10:20.746 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 09:19:22.862 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 09:19:28.706 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 09:19:28.714 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 09:19:28.910 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 158 ms. Found 0 Redis repository interfaces.
- 2022-07-04 09:19:31.880 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@2cadcff6' 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-04 09:19:31.961 [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-04 09:19:34.720 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 11718 ms
- 2022-07-04 09:19:54.834 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 09:19:54.892 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 09:19:54.895 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 09:19:54.913 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 09:19:54.922 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 09:19:54.926 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656897594839'
- 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-04 09:19:54.926 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 09:19:54.927 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 09:19:54.932 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@23e0b938
- 2022-07-04 09:20:00.290 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 09:20:04.605 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 09:20:05.365 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 09:20:05.405 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 09:20:05.518 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 09:20:05.661 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 62229 (http)
- 2022-07-04 09:20:06.451 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 09:20:07.453 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 09:20:07.552 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 09:20:07.553 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656896999609"'s failed in-progress jobs.
- 2022-07-04 09:20:07.651 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897594839 started.
- 2022-07-04 09:20:12.460 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 4827 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 09:20:13.830 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897594839 paused.
- 2022-07-04 09:20:13.856 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 09:20:13.856 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897594839 shutting down.
- 2022-07-04 09:20:13.856 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897594839 paused.
- 2022-07-04 09:20:13.857 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897594839 shutdown complete.
- 2022-07-04 09:20:13.859 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 09:22:12.249 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 09:22:14.548 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 09:22:14.554 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 09:22:14.647 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 73 ms. Found 0 Redis repository interfaces.
- 2022-07-04 09:22:15.842 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@70ee1963' 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-04 09:22:15.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-04 09:22:16.891 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4595 ms
- 2022-07-04 09:22:24.965 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 09:22:24.989 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 09:22:24.990 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 09:22:24.996 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 09:22:25.001 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 09:22:25.002 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656897744969'
- 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-04 09:22:25.002 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 09:22:25.002 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 09:22:25.005 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@686ee555
- 2022-07-04 09:22:28.114 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 09:22:30.438 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 09:22:30.924 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 09:22:30.948 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 09:22:31.009 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 09:22:31.088 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 62378 (http)
- 2022-07-04 09:22:31.583 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 09:22:32.585 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 09:22:32.674 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 09:22:32.674 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656897594839"'s failed in-progress jobs.
- 2022-07-04 09:22:32.763 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897744969 started.
- 2022-07-04 09:22:35.032 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2512 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 09:22:36.430 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897744969 paused.
- 2022-07-04 09:22:36.457 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 09:22:36.457 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897744969 shutting down.
- 2022-07-04 09:22:36.457 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897744969 paused.
- 2022-07-04 09:22:36.459 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656897744969 shutdown complete.
- 2022-07-04 09:22:36.460 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 09:35:59.181 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 09:36:01.628 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 09:36:01.633 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 09:36:01.718 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 67 ms. Found 0 Redis repository interfaces.
- 2022-07-04 09:36:03.041 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@44ddb518' 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-04 09:36:03.074 [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-04 09:36:04.122 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4891 ms
- 2022-07-04 09:36:12.781 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 09:36:12.870 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 09:36:12.871 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 09:36:12.887 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 09:36:12.893 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 09:36:12.895 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656898572788'
- 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-04 09:36:12.896 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 09:36:12.897 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 09:36:12.901 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@31b827a6
- 2022-07-04 09:36:16.068 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 09:36:18.401 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 09:36:18.804 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 09:36:18.820 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 09:36:18.875 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 09:36:18.941 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 63306 (http)
- 2022-07-04 09:36:19.371 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 09:36:20.373 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 09:36:20.439 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 09:36:20.439 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656897744969"'s failed in-progress jobs.
- 2022-07-04 09:36:20.514 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898572788 started.
- 2022-07-04 09:36:24.073 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3903 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 09:38:56.108 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898572788 paused.
- 2022-07-04 09:38:56.142 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 09:38:56.143 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898572788 shutting down.
- 2022-07-04 09:38:56.143 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898572788 paused.
- 2022-07-04 09:38:56.162 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1656898572788_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-07-04 09:38:56.163 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1656898572788_ClusterManager] ERROR o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Error managing cluster: 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.doCheckin(JobStoreSupport.java:3322)
- at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3935)
- at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3972)
- 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-07-04 09:38:56.164 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898572788 shutdown complete.
- 2022-07-04 09:38:56.166 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 09:38:56.173 [ElfScheduler_QuartzSchedulerThread] ERROR org.quartz.core.ErrorLogger - An error occurred while scanning for the next triggers to fire.
- org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': com.alibaba.druid.pool.DataSourceDisableException
- at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:168)
- at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3861)
- at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2802)
- at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:287)
- Caused by: com.alibaba.druid.pool.DataSourceDisableException: null
- at com.alibaba.druid.pool.DruidDataSource.close(DruidDataSource.java:2133)
- at org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:239)
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:587)
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:559)
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.destroySingleton(DefaultListableBeanFactory.java:1161)
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:520)
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.destroySingletons(DefaultListableBeanFactory.java:1154)
- at org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1106)
- at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1075)
- at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.doClose(ServletWebServerApplicationContext.java:172)
- at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1021)
- at org.springframework.boot.SpringApplicationShutdownHook.closeAndWait(SpringApplicationShutdownHook.java:145)
- at java.lang.Iterable.forEach(Iterable.java:75)
- at org.springframework.boot.SpringApplicationShutdownHook.run(SpringApplicationShutdownHook.java:114)
- at java.lang.Thread.run(Thread.java:748)
- 2022-07-04 09:39:08.917 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 09:39:11.284 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 09:39:11.290 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 09:39:11.381 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 70 ms. Found 0 Redis repository interfaces.
- 2022-07-04 09:39:12.740 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@2c56eba5' 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-04 09:39:12.776 [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-04 09:39:13.812 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4837 ms
- 2022-07-04 09:39:23.286 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 09:39:23.327 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 09:39:23.327 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 09:39:23.336 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 09:39:23.342 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 09:39:23.344 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656898763290'
- 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-04 09:39:23.344 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 09:39:23.344 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 09:39:23.348 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@14c1cba6
- 2022-07-04 09:39:26.596 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 09:39:29.363 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 09:39:29.867 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 09:39:29.890 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 09:39:29.967 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 09:39:30.052 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 63521 (http)
- 2022-07-04 09:39:30.565 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 09:39:31.568 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 09:39:31.719 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 09:39:31.719 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656898572788"'s failed in-progress jobs.
- 2022-07-04 09:39:31.816 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898763290 started.
- 2022-07-04 09:39:38.951 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 7590 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 09:40:22.120 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898763290 paused.
- 2022-07-04 09:40:22.158 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 09:40:22.158 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898763290 shutting down.
- 2022-07-04 09:40:22.158 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898763290 paused.
- 2022-07-04 09:40:22.160 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656898763290 shutdown complete.
- 2022-07-04 09:40:22.163 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 09:43:37.040 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 09:43:39.406 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 09:43:39.411 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 09:43:39.501 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 72 ms. Found 0 Redis repository interfaces.
- 2022-07-04 09:43:40.805 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@67a6a2d0' 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-04 09:43:40.844 [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-04 09:43:41.981 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4896 ms
- 2022-07-04 09:43:50.313 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 09:43:50.341 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 09:43:50.341 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 09:43:50.348 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 09:43:50.353 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 09:43:50.355 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656899030317'
- 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-04 09:43:50.355 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 09:43:50.355 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 09:43:50.359 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@577b2c5f
- 2022-07-04 09:43:53.192 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 09:43:55.820 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 09:43:56.340 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 09:43:56.363 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 09:43:56.427 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 09:43:56.498 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 63775 (http)
- 2022-07-04 09:43:56.989 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 09:43:57.990 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 09:43:58.303 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 09:43:58.303 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656898763290"'s failed in-progress jobs.
- 2022-07-04 09:43:58.450 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899030317 started.
- 2022-07-04 09:44:00.804 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3023 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 09:44:02.135 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899030317 paused.
- 2022-07-04 09:44:02.174 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 09:44:02.174 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899030317 shutting down.
- 2022-07-04 09:44:02.174 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899030317 paused.
- 2022-07-04 09:44:02.201 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899030317 shutdown complete.
- 2022-07-04 09:44:02.203 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 09:57:06.279 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 09:57:08.630 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 09:57:08.635 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 09:57:08.722 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 67 ms. Found 0 Redis repository interfaces.
- 2022-07-04 09:57:09.953 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@6fc0e448' 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-04 09:57:09.991 [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-04 09:57:10.980 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4656 ms
- 2022-07-04 09:57:19.107 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 09:57:19.138 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 09:57:19.138 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 09:57:19.146 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 09:57:19.150 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 09:57:19.151 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656899839111'
- 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-04 09:57:19.151 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 09:57:19.151 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 09:57:19.154 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@d20e900
- 2022-07-04 09:57:22.304 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 09:57:25.077 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 09:57:25.583 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 09:57:25.604 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 09:57:25.668 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 09:57:25.750 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 64389 (http)
- 2022-07-04 09:57:26.242 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 09:57:27.244 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 09:57:27.335 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 09:57:27.335 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656899030317"'s failed in-progress jobs.
- 2022-07-04 09:57:27.479 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899839111 started.
- 2022-07-04 09:57:29.836 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2754 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 09:57:31.265 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899839111 paused.
- 2022-07-04 09:57:31.293 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 09:57:31.294 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899839111 shutting down.
- 2022-07-04 09:57:31.294 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899839111 paused.
- 2022-07-04 09:57:31.295 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899839111 shutdown complete.
- 2022-07-04 09:57:31.297 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 09:59:30.693 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 09:59:33.029 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 09:59:33.033 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 09:59:33.121 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 69 ms. Found 0 Redis repository interfaces.
- 2022-07-04 09:59:34.417 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@75a9cc24' 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-04 09:59:34.454 [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-04 09:59:35.501 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4761 ms
- 2022-07-04 09:59:44.227 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 09:59:44.251 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 09:59:44.251 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 09:59:44.257 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 09:59:44.260 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 09:59:44.261 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656899984230'
- 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-04 09:59:44.261 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 09:59:44.262 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 09:59:44.264 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@21139739
- 2022-07-04 09:59:47.981 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 09:59:50.314 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 09:59:50.730 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 09:59:50.748 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 09:59:50.802 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 09:59:50.865 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 64523 (http)
- 2022-07-04 09:59:51.286 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 09:59:52.287 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 09:59:52.637 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 09:59:52.638 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656899839111"'s failed in-progress jobs.
- 2022-07-04 09:59:53.090 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899984230 started.
- 2022-07-04 09:59:57.721 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5648 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 09:59:59.155 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899984230 paused.
- 2022-07-04 09:59:59.185 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 09:59:59.186 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899984230 shutting down.
- 2022-07-04 09:59:59.186 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899984230 paused.
- 2022-07-04 09:59:59.187 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656899984230 shutdown complete.
- 2022-07-04 09:59:59.189 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 10:02:27.473 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 10:02:29.994 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 10:02:29.998 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 10:02:30.104 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 79 ms. Found 0 Redis repository interfaces.
- 2022-07-04 10:02:31.557 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@4db46344' 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-04 10:02:31.588 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
- 2022-07-04 10:02:32.598 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5075 ms
- 2022-07-04 10:02:40.850 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 10:02:40.887 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 10:02:40.888 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 10:02:40.898 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 10:02:40.906 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 10:02:40.909 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656900160854'
- 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-04 10:02:40.910 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 10:02:40.910 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 10:02:40.915 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@17e7cc67
- 2022-07-04 10:02:43.720 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 10:02:46.068 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 10:02:46.534 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 10:02:46.555 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 10:02:46.608 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 10:02:46.681 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 64688 (http)
- 2022-07-04 10:02:47.159 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 10:02:48.160 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 10:02:48.352 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 10:02:48.353 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656899984230"'s failed in-progress jobs.
- 2022-07-04 10:02:48.612 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900160854 started.
- 2022-07-04 10:02:51.511 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3577 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 10:02:52.863 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900160854 paused.
- 2022-07-04 10:02:52.888 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 10:02:52.889 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900160854 shutting down.
- 2022-07-04 10:02:52.889 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900160854 paused.
- 2022-07-04 10:02:52.890 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900160854 shutdown complete.
- 2022-07-04 10:02:52.892 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 10:07:36.750 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 10:07:39.099 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 10:07:39.104 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 10:07:39.201 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 75 ms. Found 0 Redis repository interfaces.
- 2022-07-04 10:07:40.467 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@4ec427' 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-04 10:07:40.510 [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-04 10:07:41.531 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4742 ms
- 2022-07-04 10:07:49.543 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 10:07:49.566 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 10:07:49.566 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 10:07:49.571 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 10:07:49.575 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 10:07:49.576 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656900469546'
- 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-04 10:07:49.576 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 10:07:49.576 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 10:07:49.579 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@4a3e1b5d
- 2022-07-04 10:07:52.523 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 10:07:54.948 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 10:07:55.402 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 10:07:55.420 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 10:07:55.481 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 10:07:55.540 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 64971 (http)
- 2022-07-04 10:07:55.987 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 10:07:56.989 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 10:07:57.069 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 10:07:57.069 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "DESKTOP-NA1JNLE1656900160854"'s failed in-progress jobs.
- 2022-07-04 10:07:57.171 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900469546 started.
- 2022-07-04 10:07:59.486 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2671 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 10:08:01.285 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900469546 paused.
- 2022-07-04 10:08:01.316 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 10:08:01.317 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900469546 shutting down.
- 2022-07-04 10:08:01.317 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900469546 paused.
- 2022-07-04 10:08:01.318 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656900469546 shutdown complete.
- 2022-07-04 10:08:01.320 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 10:26:01.787 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 10:26:04.120 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 10:26:04.125 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 10:26:04.209 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 67 ms. Found 0 Redis repository interfaces.
- 2022-07-04 10:26:05.511 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@3fde2209' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
- 2022-07-04 10:26:05.553 [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-04 10:26:07.094 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5279 ms
- 2022-07-04 10:26:16.048 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 10:26:16.075 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 10:26:16.075 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 10:26:16.081 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 10:26:16.085 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 10:26:16.087 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656901576052'
- 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-04 10:26:16.087 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 10:26:16.087 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 10:26:16.090 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2d1f3639
- 2022-07-04 10:26:19.434 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 10:26:21.796 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 10:26:22.251 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 10:26:22.272 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 10:26:22.334 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 10:26:22.406 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 49451 (http)
- 2022-07-04 10:26:22.866 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 10:26:23.304 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 10:26:23.304 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901576052 shutting down.
- 2022-07-04 10:26:23.304 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901576052 paused.
- 2022-07-04 10:26:23.306 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901576052 shutdown complete.
- 2022-07-04 10:26:23.307 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 10:27:06.951 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 10:27:09.403 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 10:27:09.408 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 10:27:09.506 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 80 ms. Found 0 Redis repository interfaces.
- 2022-07-04 10:27:10.791 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@4b336cc8' 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-04 10:27:10.829 [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-04 10:27:11.883 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4876 ms
- 2022-07-04 10:27:19.984 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 10:27:20.010 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 10:27:20.010 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 10:27:20.017 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 10:27:20.021 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 10:27:20.022 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656901639987'
- 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-04 10:27:20.022 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 10:27:20.022 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 10:27:20.025 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5f59b6c5
- 2022-07-04 10:27:23.373 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 10:27:25.760 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 10:27:26.243 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 10:27:26.261 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 10:27:26.313 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 10:27:26.372 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 49564 (http)
- 2022-07-04 10:27:26.845 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 10:27:27.740 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 10:27:27.741 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901639987 shutting down.
- 2022-07-04 10:27:27.741 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901639987 paused.
- 2022-07-04 10:27:27.742 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901639987 shutdown complete.
- 2022-07-04 10:27:27.744 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 10:27:27.847 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 10:27:51.087 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 10:27:53.439 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 10:27:53.443 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 10:27:53.532 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 69 ms. Found 0 Redis repository interfaces.
- 2022-07-04 10:27:54.836 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@6200b644' 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-04 10:27:54.882 [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-04 10:27:55.877 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4738 ms
- 2022-07-04 10:28:04.543 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 10:28:04.567 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 10:28:04.568 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 10:28:04.574 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 10:28:04.579 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 10:28:04.580 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656901684547'
- 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-04 10:28:04.581 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 10:28:04.581 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 10:28:04.583 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2d6abfc7
- 2022-07-04 10:28:07.639 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 10:28:10.291 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 10:28:10.812 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 10:28:10.834 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 10:28:10.912 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 10:28:10.997 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 49638 (http)
- 2022-07-04 10:28:11.485 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 10:28:12.317 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 10:28:12.317 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901684547 shutting down.
- 2022-07-04 10:28:12.317 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901684547 paused.
- 2022-07-04 10:28:12.318 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901684547 shutdown complete.
- 2022-07-04 10:28:12.320 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 10:29:17.519 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 10:29:19.885 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 10:29:19.890 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 10:29:19.973 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 64 ms. Found 0 Redis repository interfaces.
- 2022-07-04 10:29:21.308 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@40a28bda' 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-04 10:29:21.343 [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-04 10:29:22.372 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4817 ms
- 2022-07-04 10:29:31.253 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 10:29:31.283 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 10:29:31.283 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 10:29:31.291 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 10:29:31.295 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 10:29:31.296 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656901771256'
- 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-04 10:29:31.297 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 10:29:31.297 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 10:29:31.300 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@65d3e2ba
- 2022-07-04 10:29:34.350 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 10:29:36.798 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 10:29:37.485 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 10:29:37.511 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 10:29:37.599 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 10:29:37.705 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 49758 (http)
- 2022-07-04 10:29:38.364 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 10:29:39.366 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 10:29:39.622 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 10:29:39.622 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "LAPTOP-KDQRJNDH1656901398568"'s failed in-progress jobs.
- 2022-07-04 10:29:43.349 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 3976 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 10:29:44.271 [Quartz Scheduler [ElfScheduler]] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 4636 millis. DELETE FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?["LAPTOP-KDQRJNDH1656901398568"]
- 2022-07-04 10:29:44.478 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901771256 started.
- 2022-07-04 10:29:44.699 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901771256 paused.
- 2022-07-04 10:29:44.772 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 10:29:44.772 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901771256 shutting down.
- 2022-07-04 10:29:44.772 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901771256 paused.
- 2022-07-04 10:29:44.784 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656901771256 shutdown complete.
- 2022-07-04 10:29:44.795 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 13:31:14.697 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 13:31:17.079 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 13:31:17.083 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 13:31:17.173 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 72 ms. Found 0 Redis repository interfaces.
- 2022-07-04 13:31:18.417 [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-04 13:31:18.447 [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-04 13:31:20.456 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5696 ms
- 2022-07-04 13:31:30.884 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 13:31:30.905 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 13:31:30.906 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 13:31:30.912 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 13:31:30.915 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 13:31:30.916 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656912690887'
- 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-04 13:31:30.916 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 13:31:30.916 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 13:31:30.919 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2d1f3639
- 2022-07-04 13:31:35.689 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 13:31:37.857 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 13:31:38.218 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 13:31:38.231 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 13:31:38.293 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 13:31:38.356 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 62107 (http)
- 2022-07-04 13:31:38.747 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 13:31:39.748 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 13:31:39.810 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912690887 started.
- 2022-07-04 13:31:43.767 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 4216 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 13:31:45.825 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912690887 paused.
- 2022-07-04 13:31:45.851 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 13:31:45.851 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912690887 shutting down.
- 2022-07-04 13:31:45.851 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912690887 paused.
- 2022-07-04 13:31:45.852 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912690887 shutdown complete.
- 2022-07-04 13:31:45.854 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 13:32:40.577 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 13:32:42.990 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 13:32:42.995 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 13:32:43.092 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 76 ms. Found 0 Redis repository interfaces.
- 2022-07-04 13:32:44.403 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@6c66ddab' 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-04 13:32:44.437 [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-04 13:32:45.526 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 4891 ms
- 2022-07-04 13:32:53.699 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 13:32:53.725 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 13:32:53.726 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 13:32:53.733 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 13:32:53.737 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 13:32:53.738 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656912773702'
- 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-04 13:32:53.738 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 13:32:53.738 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 13:32:53.742 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@682fc714
- 2022-07-04 13:32:56.795 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 13:32:59.269 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 13:32:59.835 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 13:32:59.854 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 13:32:59.904 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 13:32:59.962 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 62239 (http)
- 2022-07-04 13:33:00.459 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 13:33:01.461 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 13:33:01.693 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912773702 started.
- 2022-07-04 13:33:05.401 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 4139 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 13:34:51.526 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1656912773702_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1656912773702) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
- 2022-07-04 13:36:13.898 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1656912773702_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1656912773702) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
- 2022-07-04 13:36:13.948 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912773702 paused.
- 2022-07-04 13:36:13.976 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 13:36:13.977 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912773702 shutting down.
- 2022-07-04 13:36:13.977 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912773702 paused.
- 2022-07-04 13:36:13.978 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656912773702 shutdown complete.
- 2022-07-04 13:36:13.980 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 14:21:57.864 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 14:22:05.651 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 14:22:05.661 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 14:22:05.834 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 139 ms. Found 0 Redis repository interfaces.
- 2022-07-04 14:22:08.043 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@391d1e33' 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-04 14:22:08.135 [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-04 14:22:10.486 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 12551 ms
- 2022-07-04 14:22:24.419 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 14:22:24.456 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 14:22:24.456 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 14:22:24.467 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 14:22:24.471 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 14:22:24.473 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656915744423'
- 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-04 14:22:24.473 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 14:22:24.473 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 14:22:24.477 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@34fcc5e3
- 2022-07-04 14:22:28.029 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 14:22:31.447 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 14:22:32.056 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 14:22:32.086 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 14:22:32.171 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 14:22:32.258 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 53056 (http)
- 2022-07-04 14:22:32.925 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 14:22:33.926 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 14:22:33.967 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 14:22:33.967 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "LAPTOP-KDQRJNDH1656915706086"'s failed in-progress jobs.
- 2022-07-04 14:22:34.011 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656915744423 started.
- 2022-07-04 14:22:36.563 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2554 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 14:22:39.564 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656915744423 paused.
- 2022-07-04 14:22:39.598 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 14:22:39.598 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656915744423 shutting down.
- 2022-07-04 14:22:39.599 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656915744423 paused.
- 2022-07-04 14:22:39.600 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656915744423 shutdown complete.
- 2022-07-04 14:22:39.603 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
- 2022-07-04 14:26:34.111 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 14:26:36.509 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 14:26:36.514 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 14:26:36.613 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 75 ms. Found 0 Redis repository interfaces.
- 2022-07-04 14:26:37.962 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@281b2dfd' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
- 2022-07-04 14:26:37.998 [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-04 14:26:39.493 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5343 ms
- 2022-07-04 14:27:21.475 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
- 2022-07-04 14:27:24.234 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
- 2022-07-04 14:27:24.241 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
- 2022-07-04 14:27:24.352 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 87 ms. Found 0 Redis repository interfaces.
- 2022-07-04 14:27:25.821 [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-04 14:27:25.864 [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-04 14:27:27.578 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6062 ms
- 2022-07-04 14:27:35.699 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
- 2022-07-04 14:27:35.722 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
- 2022-07-04 14:27:35.722 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
- 2022-07-04 14:27:35.729 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
- 2022-07-04 14:27:35.733 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
- 2022-07-04 14:27:35.735 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1656916055702'
- 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-04 14:27:35.735 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
- 2022-07-04 14:27:35.735 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
- 2022-07-04 14:27:35.739 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@7ffc4195
- 2022-07-04 14:27:38.506 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
- 2022-07-04 14:27:40.625 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
- 2022-07-04 14:27:41.015 [main] INFO org.xnio - XNIO version 3.8.6.Final
- 2022-07-04 14:27:41.034 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
- 2022-07-04 14:27:41.095 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
- 2022-07-04 14:27:41.171 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 53371 (http)
- 2022-07-04 14:27:41.664 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
- 2022-07-04 14:27:42.665 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
- 2022-07-04 14:27:42.970 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: detected 1 failed or restarted instances.
- 2022-07-04 14:27:42.971 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - ClusterManager: Scanning for instance "LAPTOP-KDQRJNDH1656915848695"'s failed in-progress jobs.
- 2022-07-04 14:27:43.385 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656916055702 started.
- 2022-07-04 14:27:44.609 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2448 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-03 00:00:00","2022-07-03 23:59:59","006172"]
- 2022-07-04 14:27:45.987 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656916055702 paused.
- 2022-07-04 14:27:46.038 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
- 2022-07-04 14:27:46.038 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656916055702 shutting down.
- 2022-07-04 14:27:46.038 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656916055702 paused.
- 2022-07-04 14:27:46.040 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1656916055702 shutdown complete.
- 2022-07-04 14:27:46.042 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
|