iotplatform/xps-server-3/logs/info/info.2023-08-27.log

18:57:09.582 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
18:57:09.630 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 3796 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
18:57:09.631 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
18:57:09.684 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
18:57:09.684 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
18:57:11.637 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
18:57:11.640 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
18:57:11.732 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 76 ms. Found 0 Redis repository interfaces.
18:57:11.892 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
18:57:11.910 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
18:57:12.663 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:57:12.663 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2978 ms
18:57:15.076 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
18:57:15.088 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
18:57:15.088 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
18:57:15.089 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
18:57:15.089 [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:57:15.089 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
18:57:15.089 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
18:57:15.090 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@32e199f2
18:57:16.677 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
18:57:16.682 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
18:57:16.821 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
18:57:16.853 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
18:57:16.853 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
18:57:16.853 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
18:57:16.879 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:57:16.889 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
18:57:16.900 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
18:57:16.933 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
18:57:16.987 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
18:57:16.988 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
18:57:16.988 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:57:17.011 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 7.91 seconds (process running for 9.622)
18:57:17.016 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
18:57:17.022 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
18:57:17.397 [restartedMain] INFO  p6spy - 2023-08-27 18:57:17 | Time Consuming: 14 ms | Connection: statement-0 | SQL: SELECT 1
18:57:17.402 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@19d397d5
18:57:17.411 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
18:57:17.474 [restartedMain] INFO  p6spy - 2023-08-27 18:57:17 | Time Consuming: 4 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:57:17.493 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:57:17.495 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:57:18.249 [RMI TCP Connection(3)-192.168.3.5] INFO  p6spy - 2023-08-27 18:57:18 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
18:57:18.250 [RMI TCP Connection(2)-192.168.3.5] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
18:57:18.251 [RMI TCP Connection(2)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
18:57:18.253 [RMI TCP Connection(2)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 2 ms
18:57:18.259 [RMI TCP Connection(3)-192.168.3.5] INFO  p6spy - 2023-08-27 18:57:18 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
18:58:33.539 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:33 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT 1
18:58:33.555 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:33 | Time Consuming: 7 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:58:33.574 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:33 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
             
        A.oc_id,
        B.oc_type_id,
        B.oc_name,
        A.account_id,
        A.account_name,
        A.account_real_name,
        A.password,
        A.account_type,
        A.account_staff_no,
        A.account_phone,
        A.account_last_ip,
        A.account_loc,
        A.status,
        A.account_avatar,
        A.account_photo,
        A.account_real_name,
        A.account_intro,
        A.wx_id,
        A.is_fixed
     
        FROM        account AS A
        LEFT JOIN   oc      AS B ON (A.oc_id = B.oc_id )
        WHERE A.deleted_flag = 0
        AND (A.account_name = 'sxky'
        OR   A.account_phone = 'sxky'
        OR   A.account_mail  = 'sxky'
        OR   A.account_staff_no = 'sxky')
18:58:33.584 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:33 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
             
        A.oc_id,
        A.oc_name,
        A.oc_type_id,
        A.root_id,
        A.parent_id,
        A.admin_id,
        B.account_name AS admin_name,
        A.group_id,
        A.node_left,
        A.node_right,
        A.node_level,
        A.is_leaf,
        A.status,
        A.if_lic
     
        FROM oc           AS A
        LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.admin_id = B.account_id)
        WHERE A.oc_id = 406283
18:58:33.591 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:33 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT
             
        A.rm_id,
        A.role_id,
        B.role_type_id,
        B.role_code,
        B.role_name,
        A.account_id
     
        FROM      s_role_member AS A
        LEFT JOIN s_role        AS B ON (A.role_id = B.role_id)
        WHERE account_id = 406283
        LIMIT 1
18:58:33.598 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:33 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
             
        A.gm_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        B.node_left ,
        B.node_right,
        A.account_id
     
        FROM      s_group_member    AS A
        LEFT JOIN s_group           AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
18:58:33.604 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:33 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
             
        A.gmp_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        A.account_id,
        D.account_name,
        D.account_real_name,
        A.position_id,
        C.position_name
     
        FROM      s_group_member_position A
        LEFT JOIN s_group                 B ON (A.oc_id = B.oc_id AND A.group_id     = B.group_id)
        LEFT JOIN s_position              C ON (A.oc_id = C.oc_id AND A.position_id  = C.position_id)
        LEFT JOIN   account               D ON (A.oc_id = D.oc_id AND A.account_id   = D.account_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
18:58:33.611 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:33 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT
             
        A.gmpg_id,
        A.oc_id,
        A.group_id,
        A.account_id,
        A.position_id,
        A.grant_group_id,
        B.group_name AS grant_group_name
     
        FROM      s_group_member_position_grant A
        LEFT JOIN s_group                       B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
         
            AND A.position_id = 406283
         
        LIMIT 1
18:58:34.080 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:34 | Time Consuming: 5 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:58:34.102 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:34 | 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:58:34.444 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:34 | Time Consuming: 38 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:58:35.083 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:35 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
18:58:35.090 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:35 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_sensor WHERE oc_id = 406283
18:58:35.099 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:35 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
 LIMIT 10 
18:58:37.346 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:37 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
18:58:37.356 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:37 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
18:58:37.623 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:37 | Time Consuming: 266 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
18:58:38.823 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:38 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
18:58:38.834 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:38 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
18:58:39.094 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:39 | Time Consuming: 258 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
18:58:40.617 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:40 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
18:58:40.628 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:40 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
18:58:40.887 [XNIO-1 task-3] INFO  p6spy - 2023-08-27 18:58:40 | Time Consuming: 257 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
20:48:11.877 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
20:48:11.878 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
20:48:11.881 [SpringApplicationShutdownHook] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
20:48:11.884 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
20:48:11.885 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
20:48:11.885 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
20:48:11.896 [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)
20:48:11.897 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
20:48:11.897 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
20:48:11.897 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
20:48:11.898 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
20:48:11.923 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
20:48:11.980 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.