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