nerp.2022-08-18.0.log 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. 2022-08-18 09:14:43.721 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  2. 2022-08-18 09:14:50.212 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  3. 2022-08-18 09:14:50.216 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  4. 2022-08-18 09:14:50.314 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 81 ms. Found 0 Redis repository interfaces.
  5. 2022-08-18 09:14:51.512 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@35025a0a' 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)
  6. 2022-08-18 09:14:51.545 [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)
  7. 2022-08-18 09:14:53.023 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 9264 ms
  8. 2022-08-18 09:15:11.457 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  9. 2022-08-18 09:15:11.485 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  10. 2022-08-18 09:15:11.485 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  11. 2022-08-18 09:15:11.512 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  12. 2022-08-18 09:15:11.515 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  13. 2022-08-18 09:15:11.516 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1660785311462'
  14. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  15. NOT STARTED.
  16. Currently in standby mode.
  17. Number of jobs executed: 0
  18. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  19. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  20. 2022-08-18 09:15:11.516 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  21. 2022-08-18 09:15:11.516 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  22. 2022-08-18 09:15:11.519 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@20a116a0
  23. 2022-08-18 09:15:20.738 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  24. 2022-08-18 09:15:24.611 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  25. 2022-08-18 09:15:25.571 [main] INFO org.xnio - XNIO version 3.8.6.Final
  26. 2022-08-18 09:15:25.595 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  27. 2022-08-18 09:15:25.700 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  28. 2022-08-18 09:15:25.877 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 55067 (http)
  29. 2022-08-18 09:15:26.479 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  30. 2022-08-18 09:15:27.481 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  31. 2022-08-18 09:15:28.205 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660785311462 started.
  32. 2022-08-18 09:16:42.557 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70729 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
  33. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  34. 2022-08-18 09:17:54.904 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70666 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
  35. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  36. 2022-08-18 09:17:57.803 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1479 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data
  37. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  38. 2022-08-18 09:17:59.770 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1661 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data
  39. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  40. 2022-08-18 09:18:01.684 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1805 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data
  41. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  42. 2022-08-18 09:19:12.906 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 71208 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
  43. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  44. 2022-08-18 09:20:34.563 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70642 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
  45. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  46. 2022-08-18 09:22:41.123 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 71111 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
  47. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  48. 2022-08-18 09:23:53.410 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70639 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
  49. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  50. 2022-08-18 09:25:05.483 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70610 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
  51. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  52. 2022-08-18 09:26:24.594 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70598 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
  53. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  54. 2022-08-18 09:27:37.275 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70823 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
  55. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  56. 2022-08-18 09:28:49.604 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70995 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
  57. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  58. 2022-08-18 09:30:02.050 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 70623 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
  59. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006170"]
  60. 2022-08-18 09:30:04.046 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660785311462 paused.
  61. 2022-08-18 09:30:04.080 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  62. 2022-08-18 09:30:04.080 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660785311462 shutting down.
  63. 2022-08-18 09:30:04.080 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660785311462 paused.
  64. 2022-08-18 09:30:04.081 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660785311462 shutdown complete.
  65. 2022-08-18 09:30:04.083 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
  66. 2022-08-18 14:02:32.620 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  67. 2022-08-18 14:02:38.284 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  68. 2022-08-18 14:02:38.288 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  69. 2022-08-18 14:02:38.426 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 102 ms. Found 0 Redis repository interfaces.
  70. 2022-08-18 14:02:40.111 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@36e3321e' 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)
  71. 2022-08-18 14:02:40.156 [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)
  72. 2022-08-18 14:02:42.049 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 9368 ms
  73. 2022-08-18 14:02:51.898 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  74. 2022-08-18 14:02:51.935 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  75. 2022-08-18 14:02:51.935 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  76. 2022-08-18 14:02:52.034 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  77. 2022-08-18 14:02:52.039 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  78. 2022-08-18 14:02:52.040 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1660802571908'
  79. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  80. NOT STARTED.
  81. Currently in standby mode.
  82. Number of jobs executed: 0
  83. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  84. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  85. 2022-08-18 14:02:52.040 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  86. 2022-08-18 14:02:52.040 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  87. 2022-08-18 14:02:52.043 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@57e9cd2
  88. 2022-08-18 14:02:55.643 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  89. 2022-08-18 14:02:58.412 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  90. 2022-08-18 14:02:58.909 [main] INFO org.xnio - XNIO version 3.8.6.Final
  91. 2022-08-18 14:02:58.934 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  92. 2022-08-18 14:02:59.030 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  93. 2022-08-18 14:02:59.187 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 59972 (http)
  94. 2022-08-18 14:03:00.264 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  95. 2022-08-18 14:03:01.265 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  96. 2022-08-18 14:03:01.470 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660802571908 started.
  97. 2022-08-18 14:03:02.933 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1925 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
  98. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-08-17 00:00:00","2022-08-17 23:59:59","006177"]
  99. 2022-08-18 14:03:23.666 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1660802571908_MisfireHandler] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 6711 millis. SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ?[1660802584919,"WAITING"]
  100. 2022-08-18 14:04:10.585 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1660802571908_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1660802571908) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
  101. 2022-08-18 14:04:33.723 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1660802571908_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 7954 millis. SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'ElfScheduler'[]
  102. 2022-08-18 14:04:34.909 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1660802571908_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1134 millis. UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?[1660802673769,"DESKTOP-NA1JNLE1660802571908"]
  103. 2022-08-18 14:05:21.192 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1660802571908_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 25093 millis. UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'ElfScheduler' AND INSTANCE_NAME = ?[1660802696094,"DESKTOP-NA1JNLE1660802571908"]
  104. 2022-08-18 14:05:26.773 [ElfScheduler_QuartzSchedulerThread] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5421 millis. SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND TRIGGER_STATE = ? AND NEXT_FIRE_TIME <= ? AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= ?)) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC["WAITING",1660802751191,1660802709338]
  105. 2022-08-18 14:05:27.771 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1660802571908_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1660802571908) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
  106. 2022-08-18 14:06:56.752 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1660802571908_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1660802571908) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
  107. 2022-08-18 14:06:56.807 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660802571908 paused.
  108. 2022-08-18 14:06:56.852 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  109. 2022-08-18 14:06:56.852 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660802571908 shutting down.
  110. 2022-08-18 14:06:56.852 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660802571908 paused.
  111. 2022-08-18 14:06:56.853 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1660802571908 shutdown complete.
  112. 2022-08-18 14:06:56.855 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError