nerp.2022-09-21.0.log 52 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400
  1. 2022-09-21 09:27:23.008 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  2. 2022-09-21 09:27:26.201 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  3. 2022-09-21 09:27:26.208 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  4. 2022-09-21 09:27:26.321 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 91 ms. Found 0 Redis repository interfaces.
  5. 2022-09-21 09:27:26.559 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration.
  6. 2022-09-21 09:27:28.359 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@65259c53' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  7. 2022-09-21 09:27:28.403 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  8. 2022-09-21 09:27:29.415 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6343 ms
  9. 2022-09-21 09:27:40.691 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  10. 2022-09-21 09:27:40.724 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  11. 2022-09-21 09:27:40.724 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  12. 2022-09-21 09:27:40.730 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  13. 2022-09-21 09:27:40.734 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  14. 2022-09-21 09:27:40.736 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663723660696'
  15. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  16. NOT STARTED.
  17. Currently in standby mode.
  18. Number of jobs executed: 0
  19. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  20. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  21. 2022-09-21 09:27:40.736 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  22. 2022-09-21 09:27:40.736 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  23. 2022-09-21 09:27:40.740 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@47541b42
  24. 2022-09-21 09:27:43.992 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  25. 2022-09-21 09:27:47.309 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  26. 2022-09-21 09:27:47.824 [main] INFO org.xnio - XNIO version 3.8.6.Final
  27. 2022-09-21 09:27:47.852 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  28. 2022-09-21 09:27:47.919 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  29. 2022-09-21 09:27:47.995 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 58175 (http)
  30. 2022-09-21 09:27:48.989 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  31. 2022-09-21 09:27:49.990 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  32. 2022-09-21 09:27:50.416 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 started.
  33. 2022-09-21 09:27:55.660 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 6091 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173
  34. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"]
  35. 2022-09-21 09:29:42.949 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 paused.
  36. 2022-09-21 09:29:42.991 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  37. 2022-09-21 09:29:42.991 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 shutting down.
  38. 2022-09-21 09:29:42.991 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 paused.
  39. 2022-09-21 09:29:42.997 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663723660696_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1663723660696) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
  40. 2022-09-21 09:29:43.005 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663723660696_MisfireHandler] ERROR o.s.scheduling.quartz.LocalDataSourceJobStore - MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': java.sql.SQLException
  41. org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ElfScheduler': java.sql.SQLException
  42. at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:168)
  43. at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3246)
  44. at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:4012)
  45. at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:4033)
  46. Caused by: java.sql.SQLException: null
  47. at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1707)
  48. at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1427)
  49. at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5059)
  50. at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:726)
  51. at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5055)
  52. at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1405)
  53. at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1397)
  54. at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:100)
  55. at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:194)
  56. at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:140)
  57. at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
  58. at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:165)
  59. ... 3 common frames omitted
  60. Caused by: java.lang.InterruptedException: null
  61. at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014)
  62. at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2088)
  63. at com.alibaba.druid.pool.DruidDataSource.pollLast(DruidDataSource.java:2269)
  64. at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1688)
  65. ... 14 common frames omitted
  66. 2022-09-21 09:29:43.036 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663723660696 shutdown complete.
  67. 2022-09-21 09:29:43.039 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
  68. 2022-09-21 09:46:09.371 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  69. 2022-09-21 09:46:13.160 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  70. 2022-09-21 09:46:13.166 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  71. 2022-09-21 09:46:13.310 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 125 ms. Found 0 Redis repository interfaces.
  72. 2022-09-21 09:46:13.735 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration.
  73. 2022-09-21 09:46:16.454 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@447521e' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  74. 2022-09-21 09:46:16.508 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  75. 2022-09-21 09:46:18.749 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 9329 ms
  76. 2022-09-21 09:46:19.306 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  77. 2022-09-21 09:46:25.913 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  78. 2022-09-21 09:46:25.922 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  79. 2022-09-21 09:46:26.205 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 213 ms. Found 0 Redis repository interfaces.
  80. 2022-09-21 09:46:26.669 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration.
  81. 2022-09-21 09:46:29.806 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@990b86b' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  82. 2022-09-21 09:46:29.902 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  83. 2022-09-21 09:46:33.414 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 14084 ms
  84. 2022-09-21 09:46:41.359 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  85. 2022-09-21 09:46:41.456 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  86. 2022-09-21 09:46:41.462 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  87. 2022-09-21 09:46:41.479 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  88. 2022-09-21 09:46:41.493 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  89. 2022-09-21 09:46:41.496 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663724801368'
  90. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  91. NOT STARTED.
  92. Currently in standby mode.
  93. Number of jobs executed: 0
  94. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  95. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  96. 2022-09-21 09:46:41.496 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  97. 2022-09-21 09:46:41.497 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  98. 2022-09-21 09:46:41.501 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@6b756a62
  99. 2022-09-21 09:46:46.786 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  100. 2022-09-21 09:46:50.050 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  101. 2022-09-21 09:46:50.583 [main] INFO org.xnio - XNIO version 3.8.6.Final
  102. 2022-09-21 09:46:50.611 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  103. 2022-09-21 09:46:50.714 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  104. 2022-09-21 09:46:50.792 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 59322 (http)
  105. 2022-09-21 09:46:51.669 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  106. 2022-09-21 09:46:52.540 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  107. 2022-09-21 09:46:52.579 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  108. 2022-09-21 09:46:52.579 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  109. 2022-09-21 09:46:52.588 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  110. 2022-09-21 09:46:52.592 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  111. 2022-09-21 09:46:52.594 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663724812544'
  112. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  113. NOT STARTED.
  114. Currently in standby mode.
  115. Number of jobs executed: 0
  116. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  117. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  118. 2022-09-21 09:46:52.594 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  119. 2022-09-21 09:46:52.594 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  120. 2022-09-21 09:46:52.598 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5b3427c4
  121. 2022-09-21 09:46:52.688 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  122. 2022-09-21 09:46:52.771 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 started.
  123. 2022-09-21 09:46:58.776 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5886 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173
  124. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"]
  125. 2022-09-21 09:47:00.722 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  126. 2022-09-21 09:47:06.099 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  127. 2022-09-21 09:47:07.052 [main] INFO org.xnio - XNIO version 3.8.6.Final
  128. 2022-09-21 09:47:07.127 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  129. 2022-09-21 09:47:07.219 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  130. 2022-09-21 09:47:07.357 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 59354 (http)
  131. 2022-09-21 09:47:09.035 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  132. 2022-09-21 09:47:10.041 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  133. 2022-09-21 09:47:10.293 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 started.
  134. 2022-09-21 09:47:11.075 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 paused.
  135. 2022-09-21 09:47:11.109 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  136. 2022-09-21 09:47:11.109 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 shutting down.
  137. 2022-09-21 09:47:11.109 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 paused.
  138. 2022-09-21 09:47:11.111 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724801368 shutdown complete.
  139. 2022-09-21 09:47:11.114 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
  140. 2022-09-21 09:47:15.176 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5354 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173
  141. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"]
  142. 2022-09-21 09:47:59.508 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663724812544_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1663724812544) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
  143. 2022-09-21 09:48:45.911 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663724812544_ClusterManager] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 20673 millis. INSERT INTO QRTZ_SCHEDULER_STATE (SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('ElfScheduler', ?, ?, ?)["DESKTOP-NA1JNLE1663724812544",1663724879545,15000]
  144. 2022-09-21 09:48:45.912 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663724812544_MisfireHandler] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 11667 millis. SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler' AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ?[1663724891092,"WAITING"]
  145. 2022-09-21 09:48:48.068 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 paused.
  146. 2022-09-21 09:48:48.092 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  147. 2022-09-21 09:48:48.092 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 shutting down.
  148. 2022-09-21 09:48:48.093 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 paused.
  149. 2022-09-21 09:48:48.094 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724812544 shutdown complete.
  150. 2022-09-21 09:48:48.096 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
  151. 2022-09-21 09:49:09.383 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  152. 2022-09-21 09:49:12.433 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  153. 2022-09-21 09:49:12.439 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  154. 2022-09-21 09:49:12.566 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 99 ms. Found 0 Redis repository interfaces.
  155. 2022-09-21 09:49:12.796 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration.
  156. 2022-09-21 09:49:14.477 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@2cc34cd5' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  157. 2022-09-21 09:49:14.525 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  158. 2022-09-21 09:49:15.522 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6052 ms
  159. 2022-09-21 09:49:25.844 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  160. 2022-09-21 09:49:25.879 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  161. 2022-09-21 09:49:25.880 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  162. 2022-09-21 09:49:25.888 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  163. 2022-09-21 09:49:25.891 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  164. 2022-09-21 09:49:25.893 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663724965848'
  165. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  166. NOT STARTED.
  167. Currently in standby mode.
  168. Number of jobs executed: 0
  169. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  170. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  171. 2022-09-21 09:49:25.893 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  172. 2022-09-21 09:49:25.893 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  173. 2022-09-21 09:49:25.896 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@769d0ef2
  174. 2022-09-21 09:49:29.099 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  175. 2022-09-21 09:49:32.027 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  176. 2022-09-21 09:49:32.521 [main] INFO org.xnio - XNIO version 3.8.6.Final
  177. 2022-09-21 09:49:32.545 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  178. 2022-09-21 09:49:32.669 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  179. 2022-09-21 09:49:32.756 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 59514 (http)
  180. 2022-09-21 09:49:33.836 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  181. 2022-09-21 09:49:34.839 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  182. 2022-09-21 09:49:35.085 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 started.
  183. 2022-09-21 09:49:39.665 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 5289 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173
  184. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"]
  185. 2022-09-21 09:54:40.062 [QuartzScheduler_ElfScheduler-DESKTOP-NA1JNLE1663724965848_ClusterManager] WARN o.s.scheduling.quartz.LocalDataSourceJobStore - This scheduler instance (DESKTOP-NA1JNLE1663724965848) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior.
  186. 2022-09-21 09:54:42.304 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 paused.
  187. 2022-09-21 09:54:42.331 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  188. 2022-09-21 09:54:42.331 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 shutting down.
  189. 2022-09-21 09:54:42.331 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 paused.
  190. 2022-09-21 09:54:42.332 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663724965848 shutdown complete.
  191. 2022-09-21 09:54:42.334 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
  192. 2022-09-21 09:59:55.145 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  193. 2022-09-21 09:59:58.218 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  194. 2022-09-21 09:59:58.226 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  195. 2022-09-21 09:59:58.372 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 112 ms. Found 0 Redis repository interfaces.
  196. 2022-09-21 09:59:58.650 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration.
  197. 2022-09-21 10:00:00.362 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@6b3b4f37' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  198. 2022-09-21 10:00:00.397 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  199. 2022-09-21 10:00:01.440 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6224 ms
  200. 2022-09-21 10:00:12.314 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  201. 2022-09-21 10:00:12.346 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  202. 2022-09-21 10:00:12.346 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  203. 2022-09-21 10:00:12.353 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  204. 2022-09-21 10:00:12.358 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  205. 2022-09-21 10:00:12.360 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663725612318'
  206. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  207. NOT STARTED.
  208. Currently in standby mode.
  209. Number of jobs executed: 0
  210. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  211. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  212. 2022-09-21 10:00:12.360 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  213. 2022-09-21 10:00:12.360 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  214. 2022-09-21 10:00:12.364 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@2f32fe68
  215. 2022-09-21 10:00:15.632 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  216. 2022-09-21 10:00:18.529 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  217. 2022-09-21 10:00:19.053 [main] INFO org.xnio - XNIO version 3.8.6.Final
  218. 2022-09-21 10:00:19.076 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  219. 2022-09-21 10:00:19.143 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  220. 2022-09-21 10:00:19.224 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 60140 (http)
  221. 2022-09-21 10:00:20.283 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  222. 2022-09-21 10:00:21.285 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  223. 2022-09-21 10:00:21.626 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 started.
  224. 2022-09-21 10:00:25.708 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 4851 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173
  225. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2021-09-20 00:00:00","2022-09-20 23:59:59","006173"]
  226. 2022-09-21 10:00:44.050 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 paused.
  227. 2022-09-21 10:00:44.073 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  228. 2022-09-21 10:00:44.074 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 shutting down.
  229. 2022-09-21 10:00:44.074 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 paused.
  230. 2022-09-21 10:00:44.076 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663725612318 shutdown complete.
  231. 2022-09-21 10:00:44.078 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
  232. 2022-09-21 15:29:19.597 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  233. 2022-09-21 15:29:22.353 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  234. 2022-09-21 15:29:22.357 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  235. 2022-09-21 15:29:22.447 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 73 ms. Found 0 Redis repository interfaces.
  236. 2022-09-21 15:29:22.646 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration.
  237. 2022-09-21 15:29:24.215 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@482f7af0' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  238. 2022-09-21 15:29:24.248 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  239. 2022-09-21 15:29:25.782 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 6150 ms
  240. 2022-09-21 15:29:36.086 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  241. 2022-09-21 15:29:36.118 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  242. 2022-09-21 15:29:36.119 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  243. 2022-09-21 15:29:36.125 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  244. 2022-09-21 15:29:36.129 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  245. 2022-09-21 15:29:36.131 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663745376090'
  246. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  247. NOT STARTED.
  248. Currently in standby mode.
  249. Number of jobs executed: 0
  250. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  251. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  252. 2022-09-21 15:29:36.131 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  253. 2022-09-21 15:29:36.131 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  254. 2022-09-21 15:29:36.135 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@3e1c5e0d
  255. 2022-09-21 15:29:43.147 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  256. 2022-09-21 15:29:45.674 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  257. 2022-09-21 15:29:46.178 [main] INFO org.xnio - XNIO version 3.8.6.Final
  258. 2022-09-21 15:29:46.202 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  259. 2022-09-21 15:29:46.282 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  260. 2022-09-21 15:29:46.376 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 51832 (http)
  261. 2022-09-21 15:29:47.013 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  262. 2022-09-21 15:29:48.014 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  263. 2022-09-21 15:29:48.579 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 started.
  264. 2022-09-21 15:31:21.745 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 81343 millis. SELECT * FROM ( SELECT * FROM wind_tower_data_parent_table_5302 WHERE equipment_id = ? AND time BETWEEN ? AND ? ) tp INNER JOIN ( SELECT ea.field_name,tc.* from wind_tower_data_child_table_5302 tc LEFT JOIN equipment_attribute ea on tc.layer_height= ea.id) tc ON tp.id = tc.parent_id ORDER BY tp.time["5302","2021-09-20 00:00:00","2022-09-20 23:59:59"]
  265. 2022-09-21 15:31:42.909 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 8586 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_5302
  266. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-09-01 00:00:00","2022-09-30 23:59:59","5302"]
  267. 2022-09-21 15:31:51.805 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1274 millis. DELETE FROM wind_tower_calculation_data_5302
  268. WHERE (time BETWEEN ? AND ? AND equipment_id = ? AND eb_id = ?)["2022-09-13 00:00:00","2022-09-20 23:59:59","5302","1be74b1a-b180-4549-a9ef-42c8259240b7"]
  269. 2022-09-21 15:31:53.587 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1736 millis. DELETE FROM wind_tower_calculation_data_5302
  270. WHERE (time BETWEEN ? AND ? AND equipment_id = ? AND eb_id = ?)["2022-09-13 00:00:00","2022-09-20 23:59:59","5302","1bfeafe7-b466-403e-9457-212fa2aa2d77"]
  271. 2022-09-21 15:31:59.569 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 4878 millis. INSERT INTO wind_tower_calculation_data_5302 ( id,
  272. equipment_id,
  273. eb_id,
  274. time,
  275. value ) VALUES ( ?,
  276. ?,
  277. ?,
  278. ?,
  279. ? )["2e873b4fa131017110a6ea0a8adb9fd5","5302","dc7be6b0-24fa-42de-918e-f4c3d106d60c","2022-09-14 19:00:00",1004.65]
  280. 2022-09-21 15:32:02.310 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 2658 millis. INSERT INTO wind_tower_calculation_data_5302 ( id,
  281. equipment_id,
  282. eb_id,
  283. time,
  284. value ) VALUES ( ?,
  285. ?,
  286. ?,
  287. ?,
  288. ? )["bd19fc2d6a9601292aecd364ed57049e","5302","909a33ee-819c-4046-9139-769789c93e2e","2022-09-19 07:00:00",228.95]
  289. 2022-09-21 15:32:02.310 [schedule-pool-1] INFO c.j.b.s.impl.WindTowerCalculationDataServiceImpl - 平均风速和风功率密度成功^ ^
  290. 2022-09-21 15:32:02.320 [schedule-pool-1] INFO c.j.b.s.impl.WindTowerCalculationDataServiceImpl - 开始计算小时风切变指数
  291. 2022-09-21 15:32:08.665 [schedule-pool-1] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 6308 millis. DELETE FROM wind_tower_calculation_data_5302
  292. WHERE (time BETWEEN ? AND ? AND equipment_id = ? AND eb_id = ?)["2022-09-13 00:00:00","2022-09-20 23:59:59","5302","cbe9b35b-8fad-4b8a-a9f9-d818620bc1c1"]
  293. 2022-09-21 15:32:12.936 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 144835 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173
  294. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006173"]
  295. 2022-09-21 15:32:13.394 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 paused.
  296. 2022-09-21 15:32:13.427 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  297. 2022-09-21 15:32:13.427 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 shutting down.
  298. 2022-09-21 15:32:13.427 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 paused.
  299. 2022-09-21 15:32:13.429 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745376090 shutdown complete.
  300. 2022-09-21 15:32:13.430 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
  301. 2022-09-21 15:35:53.444 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  302. 2022-09-21 15:35:56.055 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  303. 2022-09-21 15:35:56.059 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  304. 2022-09-21 15:35:56.168 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 92 ms. Found 0 Redis repository interfaces.
  305. 2022-09-21 15:35:56.405 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration.
  306. 2022-09-21 15:35:57.893 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@99a8de3' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  307. 2022-09-21 15:35:57.931 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  308. 2022-09-21 15:35:59.316 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5839 ms
  309. 2022-09-21 15:36:09.059 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  310. 2022-09-21 15:36:09.086 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  311. 2022-09-21 15:36:09.086 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  312. 2022-09-21 15:36:09.093 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  313. 2022-09-21 15:36:09.098 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  314. 2022-09-21 15:36:09.099 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663745769063'
  315. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  316. NOT STARTED.
  317. Currently in standby mode.
  318. Number of jobs executed: 0
  319. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  320. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  321. 2022-09-21 15:36:09.100 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  322. 2022-09-21 15:36:09.100 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  323. 2022-09-21 15:36:09.103 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@24ee6faa
  324. 2022-09-21 15:36:10.181 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1003 millis. DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler'[]
  325. 2022-09-21 15:36:12.135 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 1302 millis. DELETE FROM QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'ElfScheduler'[]
  326. 2022-09-21 15:36:20.597 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  327. 2022-09-21 15:36:22.614 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  328. 2022-09-21 15:36:22.974 [main] INFO org.xnio - XNIO version 3.8.6.Final
  329. 2022-09-21 15:36:22.996 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  330. 2022-09-21 15:36:23.060 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  331. 2022-09-21 15:36:23.134 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 52444 (http)
  332. 2022-09-21 15:36:23.592 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  333. 2022-09-21 15:36:24.593 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  334. 2022-09-21 15:36:24.766 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 started.
  335. 2022-09-21 15:38:13.338 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 108985 millis. SELECT id,equipment_id,eb_id,time,value FROM wind_tower_calculation_data_006173
  336. WHERE (time BETWEEN ? AND ? AND equipment_id = ?)["2022-08-01 00:00:00","2022-08-31 23:59:59","006173"]
  337. 2022-09-21 15:38:14.424 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 paused.
  338. 2022-09-21 15:38:14.454 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  339. 2022-09-21 15:38:14.454 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 shutting down.
  340. 2022-09-21 15:38:14.454 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 paused.
  341. 2022-09-21 15:38:14.455 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663745769063 shutdown complete.
  342. 2022-09-21 15:38:14.457 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError
  343. 2022-09-21 16:02:59.678 [background-preinit] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.2.3.Final
  344. 2022-09-21 16:03:02.418 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
  345. 2022-09-21 16:03:02.422 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  346. 2022-09-21 16:03:02.533 [main] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 89 ms. Found 0 Redis repository interfaces.
  347. 2022-09-21 16:03:02.776 [main] WARN org.mybatis.spring.mapper.ClassPathMapperScanner - No MyBatis mapper was found in '[com.baomidou.mybatisplus.samples.dytablename.mapper]' package. Please check your configuration.
  348. 2022-09-21 16:03:04.211 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@1e56bc9b' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  349. 2022-09-21 16:03:04.248 [main] INFO o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  350. 2022-09-21 16:03:05.572 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 5846 ms
  351. 2022-09-21 16:03:15.061 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  352. 2022-09-21 16:03:15.086 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  353. 2022-09-21 16:03:15.086 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  354. 2022-09-21 16:03:15.093 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization).
  355. 2022-09-21 16:03:15.097 [main] INFO o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized.
  356. 2022-09-21 16:03:15.098 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'ElfScheduler' with instanceId 'DESKTOP-NA1JNLE1663747395064'
  357. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  358. NOT STARTED.
  359. Currently in standby mode.
  360. Number of jobs executed: 0
  361. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 20 threads.
  362. Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
  363. 2022-09-21 16:03:15.098 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'ElfScheduler' initialized from an externally provided properties instance.
  364. 2022-09-21 16:03:15.098 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  365. 2022-09-21 16:03:15.101 [main] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@351d726c
  366. 2022-09-21 16:03:23.689 [main] INFO o.s.b.actuate.endpoint.web.EndpointLinksResolver - Exposing 1 endpoint(s) beneath base path '/actuator'
  367. 2022-09-21 16:03:25.843 [main] INFO o.s.security.web.DefaultSecurityFilterChain - Will not secure any request
  368. 2022-09-21 16:03:26.288 [main] INFO org.xnio - XNIO version 3.8.6.Final
  369. 2022-09-21 16:03:26.312 [main] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.6.Final
  370. 2022-09-21 16:03:26.368 [main] INFO org.jboss.threads - JBoss Threads version 3.1.0.Final
  371. 2022-09-21 16:03:26.436 [main] INFO o.s.boot.web.embedded.undertow.UndertowWebServer - Undertow started on port(s) 54578 (http)
  372. 2022-09-21 16:03:26.905 [main] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Will start Quartz Scheduler [ElfScheduler] in 1 seconds
  373. 2022-09-21 16:03:27.905 [Quartz Scheduler [ElfScheduler]] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now, after delay of 1 seconds
  374. 2022-09-21 16:03:28.201 [Quartz Scheduler [ElfScheduler]] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 started.
  375. 2022-09-21 16:09:32.018 [main] ERROR com.alibaba.druid.filter.stat.StatFilter - slow sql 364344 millis. SELECT * FROM ( SELECT * FROM wind_tower_data_parent_table_006173 WHERE equipment_id = ? AND time BETWEEN ? AND ? ) tp INNER JOIN ( SELECT ea.field_name,tc.* from wind_tower_data_child_table_006173 tc LEFT JOIN equipment_attribute ea on tc.layer_height= ea.id) tc ON tp.id = tc.parent_id ORDER BY tp.time["006173","2022-09-13 23:59:59","2022-09-20 23:59:59"]
  376. 2022-09-21 16:09:33.644 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 paused.
  377. 2022-09-21 16:09:33.670 [SpringApplicationShutdownHook] INFO o.s.scheduling.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  378. 2022-09-21 16:09:33.671 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 shutting down.
  379. 2022-09-21 16:09:33.671 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 paused.
  380. 2022-09-21 16:09:33.672 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler ElfScheduler_$_DESKTOP-NA1JNLE1663747395064 shutdown complete.
  381. 2022-09-21 16:09:33.674 [SpringApplicationShutdownHook] WARN o.s.c.annotation.CommonAnnotationBeanPostProcessor - Destroy method on bean with name 'shutdownManager' threw an exception: java.lang.ExceptionInInitializerError