18:24:54.899 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 18:24:54.950 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 19180 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 18:24:54.950 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 18:24:55.011 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 18:24:55.011 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 18:24:56.955 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 18:24:56.959 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 18:24:57.029 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 56 ms. Found 0 Redis repository interfaces. 18:24:57.176 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 18:24:57.195 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 18:24:58.011 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 18:24:58.012 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2999 ms 18:25:00.579 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 18:25:00.590 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 18:25:00.590 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 18:25:00.591 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 18:25:00.592 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED' 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 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. 18:25:00.592 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 18:25:00.592 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 18:25:00.592 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@10820e6c 18:25:02.671 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 18:25:02.837 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 18:25:02.874 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 18:25:02.875 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 18:25:02.875 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 18:25:02.903 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 18:25:02.913 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 18:25:02.924 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 18:25:02.963 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 18:25:03.022 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 18:25:03.177 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 18:25:03.178 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 150 ms 18:25:03.191 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 18:25:03.231 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 18:25:03.252 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8089 (http) 18:25:03.255 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 18:25:03.255 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:03.279 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 8.919 seconds (process running for 9.743) 18:25:03.282 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 18:25:03.290 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 18:25:03.710 [restartedMain] INFO p6spy - 2023-06-28 18:25:03 | Time Consuming: 18 ms | Connection: statement-0 | SQL: SELECT 1 18:25:03.716 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@47d09491 18:25:03.721 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 18:25:03.800 [restartedMain] INFO p6spy - 2023-06-28 18:25:03 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT A.job_id, A.job_title, A.job_desc, A.status, A.job_type, A.job_code, A.job_cron, A.job_class_id, B.job_class, A.cycle_title, A.cycle_period, A.cycle_unit FROM job AS A LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id) WHERE A.deleted_flag = 0 AND A.status = 1 ORDER BY A.job_id ASC 18:25:03.835 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:03.850 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:03.850 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:03.851 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:03.851 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:03.852 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:03.852 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:03.852 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:25:04.097 [RMI TCP Connection(4)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 18:25:04.098 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 18:25:04.101 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 3 ms 18:25:04.107 [RMI TCP Connection(5)-192.168.3.5] INFO p6spy - 2023-06-28 18:25:04 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 18:26:08.472 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:26:08 | Time Consuming: 42 ms | Connection: statement-0 | SQL: SELECT 1 18:26:08.488 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:26:08 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 18:26:08.511 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:26:08 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 18:26:08.790 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:26:08 | Time Consuming: 31 ms | Connection: statement-0 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:26:26.148 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 18:26:26.154 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 18:26:26.154 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 18:26:26.156 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 18:26:26.157 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 18:26:26.157 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 18:26:26.157 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 18:26:26.170 [SpringApplicationShutdownHook] INFO o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process) 18:26:26.172 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 18:26:26.172 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 18:26:26.172 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 18:26:26.173 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 18:26:26.185 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 18:26:26.189 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed. 18:26:33.322 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 18:26:33.381 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 8884 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 18:26:33.382 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 18:26:33.444 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 18:26:33.445 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 18:26:35.143 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 18:26:35.146 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 18:26:35.215 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 54 ms. Found 0 Redis repository interfaces. 18:26:35.362 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 18:26:35.380 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 18:26:36.190 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 18:26:36.191 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2745 ms 18:26:38.854 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 18:26:38.865 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 18:26:38.865 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 18:26:38.866 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 18:26:38.867 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED' 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 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. 18:26:38.867 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 18:26:38.867 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 18:26:38.867 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@21dda797 18:26:40.796 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 18:26:40.941 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 18:26:40.973 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 18:26:40.974 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 18:26:40.974 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 18:26:40.994 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 18:26:41.003 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 18:26:41.014 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 18:26:41.046 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 18:26:41.099 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 18:26:41.229 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 18:26:41.229 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 124 ms 18:26:41.239 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 18:26:41.274 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 18:26:41.290 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8089 (http) 18:26:41.294 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 18:26:41.294 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:41.318 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 8.521 seconds (process running for 9.368) 18:26:41.320 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 18:26:41.327 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 18:26:41.692 [restartedMain] INFO p6spy - 2023-06-28 18:26:41 | Time Consuming: 15 ms | Connection: statement-0 | SQL: SELECT 1 18:26:41.698 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@6bdeaa69 18:26:41.702 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 18:26:41.784 [restartedMain] INFO p6spy - 2023-06-28 18:26:41 | Time Consuming: 7 ms | Connection: statement-0 | SQL: SELECT A.job_id, A.job_title, A.job_desc, A.status, A.job_type, A.job_code, A.job_cron, A.job_class_id, B.job_class, A.cycle_title, A.cycle_period, A.cycle_unit FROM job AS A LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id) WHERE A.deleted_flag = 0 AND A.status = 1 ORDER BY A.job_id ASC 18:26:41.819 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:41.821 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:41.821 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:26:42.443 [RMI TCP Connection(4)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 18:26:42.443 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 18:26:42.445 [RMI TCP Connection(3)-192.168.3.5] INFO p6spy - 2023-06-28 18:26:42 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 18:26:42.448 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms 18:26:42.460 [RMI TCP Connection(3)-192.168.3.5] INFO p6spy - 2023-06-28 18:26:42 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 18:30:06.701 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:30:06 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 18:30:06.738 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:30:06 | Time Consuming: 29 ms | Connection: statement-0 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:34:16.468 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:16 | Time Consuming: 5029 ms | Connection: statement-0 | SQL: SELECT 1 18:34:21.471 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:21 | Time Consuming: 5001 ms | Connection: statement-1 | SQL: SELECT 1 18:34:26.473 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:26 | Time Consuming: 5001 ms | Connection: statement-2 | SQL: SELECT 1 18:34:31.476 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:31 | Time Consuming: 5001 ms | Connection: statement-3 | SQL: SELECT 1 18:34:36.479 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 5002 ms | Connection: statement-4 | SQL: SELECT 1 18:34:36.485 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT 1 18:34:36.501 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 9 ms | Connection: statement-5 | SQL: UPDATE account SET updated_by = 406283 WHERE oc_id = 406283 AND account_id = 406283 18:34:36.569 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 6 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 18:34:36.591 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 18:34:57.455 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:57 | Time Consuming: 8 ms | Connection: statement-5 | SQL: SELECT 1 18:34:57.489 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:57 | Time Consuming: 28 ms | Connection: statement-5 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:35:03.133 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:03 | Time Consuming: 7 ms | Connection: statement-5 | SQL: SELECT 1 18:35:03.144 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:03 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 18:35:03.164 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:03 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 18:35:03.324 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:03 | Time Consuming: 32 ms | Connection: statement-5 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:35:31.778 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:31 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT 1 18:35:31.792 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:31 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:39:12.283 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:12 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1 18:39:12.294 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:12 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 18:39:12.311 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:12 | Time Consuming: 6 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 18:39:12.495 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:12 | Time Consuming: 28 ms | Connection: statement-5 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:39:16.181 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:16 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 18:39:16.189 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:16 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:39:17.479 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 5011 ms | Connection: statement-7 | SQL: SELECT 1 18:39:17.479 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 5013 ms | Connection: statement-6 | SQL: SELECT 1 18:39:17.479 [XNIO-1 task-5] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 5007 ms | Connection: statement-8 | SQL: SELECT 1 18:39:17.484 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1 18:39:17.538 [XNIO-1 task-5] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 18:39:17.545 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 18:39:17.549 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 18:39:22.492 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:22 | Time Consuming: 5013 ms | Connection: statement-9 | SQL: SELECT 1 18:39:22.515 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:22 | Time Consuming: 21 ms | Connection: statement-5 | SQL: SELECT 1 18:39:22.525 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:22 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 18:39:25.333 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 18:39:25.340 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 18:39:25.359 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 18:39:25.463 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1 18:39:25.481 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 13 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:39:25.493 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 29 ms | Connection: statement-5 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:39:43.654 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:43 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1 18:39:43.662 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:43 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:40:16.230 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:16 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 18:40:16.237 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:16 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:40:32.512 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:32 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 18:40:32.519 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:32 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:40:38.464 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 18:40:38.473 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 18:40:38.489 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 18:40:38.586 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 18:40:38.586 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 2 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:40:38.622 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 30 ms | Connection: statement-11 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:41:23.423 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:41:23 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 18:41:23.433 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:41:23 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:41:39.449 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:41:39 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 18:41:39.458 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:41:39 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:42:03.504 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:42:03 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 18:42:03.513 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:42:03 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:43:09.578 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:43:09 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 18:43:09.586 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:43:09 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:44:01.629 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:01 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 18:44:01.662 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:01 | Time Consuming: 29 ms | Connection: statement-11 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:44:04.042 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1 18:44:04.050 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:44:57.420 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:57 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 18:44:57.454 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:57 | Time Consuming: 28 ms | Connection: statement-11 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 18:44:57.934 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:57 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:44:59.014 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:59 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 18:44:59.025 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:59 | Time Consuming: 6 ms | Connection: statement-11 | SQL: UPDATE goaf_bigscreencfg SET bigscreen_addr = 'http://192.168.3.16:998/cn/index-iframe.html' WHERE oc_id = 406283 18:44:59.059 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:59 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:45:02.031 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:02 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1 18:45:02.042 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:02 | Time Consuming: 6 ms | Connection: statement-11 | SQL: UPDATE goaf_bigscreencfg SET bigscreen_addr = 'http://192.168.3.16:8080/#/' WHERE oc_id = 406283 18:45:02.073 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:02 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 18:45:04.210 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1 18:45:04.218 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 19:01:01.517 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 19:01:01.523 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 19:01:01.523 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 19:01:01.525 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 19:01:01.526 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 19:01:01.526 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 19:01:01.526 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 19:01:01.537 [SpringApplicationShutdownHook] INFO o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process) 19:01:01.538 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 19:01:01.539 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 19:01:01.539 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 19:01:01.539 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 19:01:01.551 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 19:01:01.553 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.