2022-05-20 13:55:05.275 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 40024 (D:\iwb-workstation-2021\InternetOfThing\SourceCode\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\SourceCode) 2022-05-20 13:55:05.279 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: dev 2022-05-20 13:55:07.388 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8196"] 2022-05-20 13:55:07.389 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat] 2022-05-20 13:55:07.389 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48] 2022-05-20 13:55:07.525 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext 2022-05-20 13:55:09.037 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited 2022-05-20 13:55:09.170 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited 2022-05-20 13:55:09.291 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited 2022-05-20 13:55:09.424 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited 2022-05-20 13:55:11.329 [main] INFO com.yyjc.fbs.server.dbserveice.config.XxlJobConfig - >>>>>>>>>>> xxl-job config init. 2022-05-20 13:55:11.893 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 13:55:11.895 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataErrorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@444c0f9a[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#executeError] 2022-05-20 13:55:11.895 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysMonitorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@36931450[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor] 2022-05-20 13:55:11.941 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8196"] 2022-05-20 13:55:11.963 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Started DBServiceApplication in 7.944 seconds (JVM running for 10.622) 2022-05-20 13:55:12.530 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server start success, nettype = class com.xxl.job.core.server.EmbedServer, port = 8198 2022-05-20 13:56:00.286 [xxl-rpc, EmbedServer bizThreadPool-1687938270] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 13:56:00.362 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: select * from parse_type 2022-05-20 13:56:00.362 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=parse_type, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=parse_type)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null) 2022-05-20 13:56:00.362 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-server-config ::: select * from t_parse_type 2022-05-20 13:56:00.424 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0 2022-05-20 13:56:00.424 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null) 2022-05-20 13:56:00.424 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0 2022-05-20 13:57:33.881 [Thread-7] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-7,10,main] 2022-05-20 13:58:00.034 [xxl-rpc, EmbedServer bizThreadPool-1833645813] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 13:58:00.144 [Thread-10] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ),( ?,?,?, ? ) 2022-05-20 13:58:00.144 [Thread-10] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_electric, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=5})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_electric), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@1d8723f4], parametersIndex=8)), columns=[Column(name=terminal_id, tableName=online_data_electric), Column(name=upload_date, tableName=online_data_electric), Column(name=insert_time, tableName=online_data_electric), Column(name=ia, tableName=online_data_electric)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4)]), columnsListLastPosition=83, generateKeyColumnIndex=-1, insertValuesListLastPosition=125) 2022-05-20 13:58:00.144 [Thread-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_05 (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ), ( ?,?,?, ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S1, 20220520135500, 20220520135759, 4.720000000000, C9ADFEEFC4EB4EB08FB296F4S2, 20220520135500, 20220520135759, 4.850000000000]] 2022-05-20 13:58:00.221 [Thread-10] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_lampblack (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) 2022-05-20 13:58:00.221 [Thread-10] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_lampblack, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_lampblack), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@2d9b5ce7], parametersIndex=13)), columns=[Column(name=terminal_id, tableName=online_data_lampblack), Column(name=upload_date, tableName=online_data_lampblack), Column(name=insert_time, tableName=online_data_lampblack), Column(name=flue_temp, tableName=online_data_lampblack), Column(name=flue_humidity, tableName=online_data_lampblack), Column(name=smoke_density, tableName=online_data_lampblack), Column(name=voc_density, tableName=online_data_lampblack), Column(name=pm25, tableName=online_data_lampblack), Column(name=longitude, tableName=online_data_lampblack), Column(name=latitude, tableName=online_data_lampblack), Column(name=smoke_total, tableName=online_data_lampblack), Column(name=voc_total, tableName=online_data_lampblack), Column(name=pm25_total, tableName=online_data_lampblack)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13)]), columnsListLastPosition=206, generateKeyColumnIndex=-1, insertValuesListLastPosition=268) 2022-05-20 13:58:00.222 [Thread-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_05 (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S3, 20220520135500, 20220520135759, null, null, 2.770000000000, 0.07000000, 1.490000000000, null, null, null, null, null]] 2022-05-20 13:59:33.488 [Thread-9] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-9,10,main] 2022-05-20 14:00:00.021 [xxl-rpc, EmbedServer bizThreadPool-2146910438] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:02:20.661 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job registry fail, registryParam:RegistryParam{registryGroup='EXECUTOR', registryKey='cems-hj212-db', registryValue='http://127.0.0.1:8198/'}, registryResult:ReturnT [code=500, msg=xxl-rpc remoting error(null), for url : http://127.0.0.1:30000/xxl-job-admin/api/registry, content=null] 2022-05-20 14:03:53.873 [Thread-11] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-11,10,main] 2022-05-20 14:04:00.034 [xxl-rpc, EmbedServer bizThreadPool-705517573] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:06:50.863 [xxl-rpc, EmbedServer bizThreadPool-840482250] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@36931450[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor] 2022-05-20 14:06:50.886 [Thread-17] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0 2022-05-20 14:06:50.886 [Thread-17] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null) 2022-05-20 14:06:50.887 [Thread-17] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0 2022-05-20 14:08:53.806 [Thread-16] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-16,10,main] 2022-05-20 14:12:50.769 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job registry fail, registryParam:RegistryParam{registryGroup='EXECUTOR', registryKey='cems-hj212-db', registryValue='http://127.0.0.1:8198/'}, registryResult:ReturnT [code=500, msg=xxl-rpc remoting error(null), for url : http://127.0.0.1:30000/xxl-job-admin/api/registry, content=null] 2022-05-20 14:30:41.718 [Thread-18] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ),( ?,?,?, ? ) 2022-05-20 14:30:41.719 [Thread-18] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_electric, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=5})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_electric), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@1d8723f4], parametersIndex=8)), columns=[Column(name=terminal_id, tableName=online_data_electric), Column(name=upload_date, tableName=online_data_electric), Column(name=insert_time, tableName=online_data_electric), Column(name=ia, tableName=online_data_electric)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4)]), columnsListLastPosition=83, generateKeyColumnIndex=-1, insertValuesListLastPosition=125) 2022-05-20 14:30:41.721 [Thread-18] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_05 (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ), ( ?,?,?, ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220520140000, 20220520140312, 2.760000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220520140000, 20220520140312, 5.600000000000]] 2022-05-20 14:39:41.912 [Thread-14] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-14,10,main] 2022-05-20 14:40:00.064 [xxl-rpc, EmbedServer bizThreadPool-1524248115] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:41:41.421 [Thread-30] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-30,10,main] 2022-05-20 14:42:00.053 [xxl-rpc, EmbedServer bizThreadPool-674176697] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:43:33.322 [Thread-32] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-32,10,main] 2022-05-20 14:44:00.050 [xxl-rpc, EmbedServer bizThreadPool-674652151] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:45:33.308 [Thread-34] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-34,10,main] 2022-05-20 14:46:00.064 [xxl-rpc, EmbedServer bizThreadPool-389401250] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:47:33.306 [Thread-36] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-36,10,main] 2022-05-20 14:48:00.028 [xxl-rpc, EmbedServer bizThreadPool-1041206580] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:49:33.232 [Thread-38] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-38,10,main] 2022-05-20 14:50:00.031 [xxl-rpc, EmbedServer bizThreadPool-1731719984] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:51:33.322 [Thread-40] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-40,10,main] 2022-05-20 14:52:00.024 [xxl-rpc, EmbedServer bizThreadPool-1545387234] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:53:33.312 [Thread-42] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-42,10,main] 2022-05-20 14:54:00.049 [xxl-rpc, EmbedServer bizThreadPool-930897031] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:55:33.339 [Thread-44] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-44,10,main] 2022-05-20 14:56:00.026 [xxl-rpc, EmbedServer bizThreadPool-902298927] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:57:33.285 [Thread-46] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-46,10,main] 2022-05-20 14:58:00.022 [xxl-rpc, EmbedServer bizThreadPool-1320036007] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 14:59:33.238 [Thread-48] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-48,10,main] 2022-05-20 15:00:00.029 [xxl-rpc, EmbedServer bizThreadPool-139190953] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:01:33.306 [Thread-50] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-50,10,main] 2022-05-20 15:02:00.043 [xxl-rpc, EmbedServer bizThreadPool-1598907544] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:03:33.302 [Thread-52] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-52,10,main] 2022-05-20 15:04:00.046 [xxl-rpc, EmbedServer bizThreadPool-162768615] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:05:00.051 [xxl-rpc, EmbedServer bizThreadPool-162768615] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@36931450[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor] 2022-05-20 15:05:00.055 [Thread-57] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0 2022-05-20 15:05:00.056 [Thread-57] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null) 2022-05-20 15:05:00.057 [Thread-57] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0 2022-05-20 15:05:33.269 [Thread-54] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-54,10,main] 2022-05-20 15:06:00.051 [xxl-rpc, EmbedServer bizThreadPool-162768615] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:06:33.470 [Thread-56] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-56,10,main] 2022-05-20 15:07:33.313 [Thread-58] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-58,10,main] 2022-05-20 15:08:00.051 [xxl-rpc, EmbedServer bizThreadPool-441282729] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:09:33.317 [Thread-60] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-60,10,main] 2022-05-20 15:10:00.040 [xxl-rpc, EmbedServer bizThreadPool-1588768171] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:11:33.324 [Thread-62] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-62,10,main] 2022-05-20 15:12:00.046 [xxl-rpc, EmbedServer bizThreadPool-403932423] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:13:33.310 [Thread-64] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-64,10,main] 2022-05-20 15:14:00.052 [xxl-rpc, EmbedServer bizThreadPool-766141066] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:15:33.308 [Thread-66] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-66,10,main] 2022-05-20 15:16:00.049 [xxl-rpc, EmbedServer bizThreadPool-1523692723] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:17:33.256 [Thread-68] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-68,10,main] 2022-05-20 15:18:00.046 [xxl-rpc, EmbedServer bizThreadPool-1416400164] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:19:33.277 [Thread-70] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-70,10,main] 2022-05-20 15:20:00.049 [xxl-rpc, EmbedServer bizThreadPool-668118566] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:21:33.262 [Thread-72] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-72,10,main] 2022-05-20 15:22:00.020 [xxl-rpc, EmbedServer bizThreadPool-666142089] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:23:33.229 [Thread-74] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-74,10,main] 2022-05-20 15:24:00.024 [xxl-rpc, EmbedServer bizThreadPool-687549981] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:25:33.267 [Thread-76] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-76,10,main] 2022-05-20 15:26:00.042 [xxl-rpc, EmbedServer bizThreadPool-1564219219] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:27:33.271 [Thread-78] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-78,10,main] 2022-05-20 15:28:00.054 [xxl-rpc, EmbedServer bizThreadPool-1064519003] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:29:33.328 [Thread-80] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-80,10,main] 2022-05-20 15:30:00.053 [xxl-rpc, EmbedServer bizThreadPool-235841513] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:31:33.338 [Thread-82] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-82,10,main] 2022-05-20 15:32:00.053 [xxl-rpc, EmbedServer bizThreadPool-862619585] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:33:33.312 [Thread-84] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-84,10,main] 2022-05-20 15:34:00.056 [xxl-rpc, EmbedServer bizThreadPool-635385474] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:35:00.027 [xxl-rpc, EmbedServer bizThreadPool-635385474] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@36931450[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor] 2022-05-20 15:35:00.032 [Thread-89] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0 2022-05-20 15:35:00.033 [Thread-89] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null) 2022-05-20 15:35:00.034 [Thread-89] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0 2022-05-20 15:35:33.273 [Thread-86] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-86,10,main] 2022-05-20 15:36:00.051 [xxl-rpc, EmbedServer bizThreadPool-8259730] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:36:33.336 [Thread-88] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-88,10,main] 2022-05-20 15:37:33.307 [Thread-90] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-90,10,main] 2022-05-20 15:38:00.044 [xxl-rpc, EmbedServer bizThreadPool-1550378935] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:39:33.331 [Thread-92] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-92,10,main] 2022-05-20 15:40:00.053 [xxl-rpc, EmbedServer bizThreadPool-1060709539] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:41:33.274 [Thread-94] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-94,10,main] 2022-05-20 15:42:00.022 [xxl-rpc, EmbedServer bizThreadPool-877273863] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:43:33.320 [Thread-96] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-96,10,main] 2022-05-20 15:44:00.050 [xxl-rpc, EmbedServer bizThreadPool-1940778176] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:45:33.273 [Thread-98] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-98,10,main] 2022-05-20 15:46:00.030 [xxl-rpc, EmbedServer bizThreadPool-713938952] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:47:33.288 [Thread-100] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-100,10,main] 2022-05-20 15:48:00.030 [xxl-rpc, EmbedServer bizThreadPool-1178629114] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:49:33.298 [Thread-102] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-102,10,main] 2022-05-20 15:50:00.057 [xxl-rpc, EmbedServer bizThreadPool-1146532183] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:51:33.345 [Thread-104] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-104,10,main] 2022-05-20 15:52:00.053 [xxl-rpc, EmbedServer bizThreadPool-2024484186] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:53:33.320 [Thread-106] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-106,10,main] 2022-05-20 15:54:00.022 [xxl-rpc, EmbedServer bizThreadPool-1845798741] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:55:33.284 [Thread-108] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-108,10,main] 2022-05-20 15:56:00.025 [xxl-rpc, EmbedServer bizThreadPool-73611392] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:57:33.288 [Thread-110] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-110,10,main] 2022-05-20 15:58:00.043 [xxl-rpc, EmbedServer bizThreadPool-1081582944] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 15:59:33.349 [Thread-112] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-112,10,main] 2022-05-20 16:00:00.064 [xxl-rpc, EmbedServer bizThreadPool-941863909] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:01:33.341 [Thread-114] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-114,10,main] 2022-05-20 16:02:00.045 [xxl-rpc, EmbedServer bizThreadPool-2105765446] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:03:33.319 [Thread-116] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-116,10,main] 2022-05-20 16:04:00.050 [xxl-rpc, EmbedServer bizThreadPool-1177265370] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:05:00.059 [xxl-rpc, EmbedServer bizThreadPool-1177265370] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@36931450[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor] 2022-05-20 16:05:00.063 [Thread-121] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0 2022-05-20 16:05:00.064 [Thread-121] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null) 2022-05-20 16:05:00.064 [Thread-121] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0 2022-05-20 16:05:33.261 [Thread-118] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-118,10,main] 2022-05-20 16:06:00.048 [xxl-rpc, EmbedServer bizThreadPool-1177265370] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:06:33.411 [Thread-120] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-120,10,main] 2022-05-20 16:07:33.312 [Thread-122] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-122,10,main] 2022-05-20 16:08:00.019 [xxl-rpc, EmbedServer bizThreadPool-631585067] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:09:33.281 [Thread-124] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-124,10,main] 2022-05-20 16:10:00.025 [xxl-rpc, EmbedServer bizThreadPool-389912892] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:11:33.289 [Thread-126] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-126,10,main] 2022-05-20 16:12:00.046 [xxl-rpc, EmbedServer bizThreadPool-1892380559] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:13:35.421 [Thread-129] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ),( ?,?,?, ? ) 2022-05-20 16:13:35.422 [Thread-129] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_electric, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=5})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_electric), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@313696bd], parametersIndex=8)), columns=[Column(name=terminal_id, tableName=online_data_electric), Column(name=upload_date, tableName=online_data_electric), Column(name=insert_time, tableName=online_data_electric), Column(name=ia, tableName=online_data_electric)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4)]), columnsListLastPosition=83, generateKeyColumnIndex=-1, insertValuesListLastPosition=125) 2022-05-20 16:13:35.423 [Thread-129] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_05 (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ), ( ?,?,?, ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220520161000, 20220520161032, 2.840000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220520161000, 20220520161032, 3.950000000000]] 2022-05-20 16:13:35.693 [Thread-129] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_lampblack (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) 2022-05-20 16:13:35.693 [Thread-129] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_lampblack, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_lampblack), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@21b53807], parametersIndex=13)), columns=[Column(name=terminal_id, tableName=online_data_lampblack), Column(name=upload_date, tableName=online_data_lampblack), Column(name=insert_time, tableName=online_data_lampblack), Column(name=flue_temp, tableName=online_data_lampblack), Column(name=flue_humidity, tableName=online_data_lampblack), Column(name=smoke_density, tableName=online_data_lampblack), Column(name=voc_density, tableName=online_data_lampblack), Column(name=pm25, tableName=online_data_lampblack), Column(name=longitude, tableName=online_data_lampblack), Column(name=latitude, tableName=online_data_lampblack), Column(name=smoke_total, tableName=online_data_lampblack), Column(name=voc_total, tableName=online_data_lampblack), Column(name=pm25_total, tableName=online_data_lampblack)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13)]), columnsListLastPosition=206, generateKeyColumnIndex=-1, insertValuesListLastPosition=268) 2022-05-20 16:13:35.694 [Thread-129] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_05 (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S3, 20220520161000, 20220520161032, null, null, 2.080000000000, 0.07000000, 1.140000000000, null, null, null, null, null]] 2022-05-20 16:15:33.261 [Thread-128] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-128,10,main] 2022-05-20 16:16:00.044 [xxl-rpc, EmbedServer bizThreadPool-2074412201] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:17:33.330 [Thread-131] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-131,10,main] 2022-05-20 16:18:00.041 [xxl-rpc, EmbedServer bizThreadPool-841368672] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:18:00.063 [Thread-134] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ),( ?,?,?, ? ) 2022-05-20 16:18:00.063 [Thread-134] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_electric, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=5})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_electric), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@313696bd], parametersIndex=8)), columns=[Column(name=terminal_id, tableName=online_data_electric), Column(name=upload_date, tableName=online_data_electric), Column(name=insert_time, tableName=online_data_electric), Column(name=ia, tableName=online_data_electric)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4)]), columnsListLastPosition=83, generateKeyColumnIndex=-1, insertValuesListLastPosition=125) 2022-05-20 16:18:00.064 [Thread-134] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_05 (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ), ( ?,?,?, ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S1, 20220520161500, 20220520161642, 2.710000000000, C9ADFEEFC4EB4EB08FB296F4S2, 20220520161500, 20220520161642, 4.410000000000]] 2022-05-20 16:18:00.129 [Thread-134] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_lampblack (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) 2022-05-20 16:18:00.129 [Thread-134] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_lampblack, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_lampblack), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@21b53807], parametersIndex=13)), columns=[Column(name=terminal_id, tableName=online_data_lampblack), Column(name=upload_date, tableName=online_data_lampblack), Column(name=insert_time, tableName=online_data_lampblack), Column(name=flue_temp, tableName=online_data_lampblack), Column(name=flue_humidity, tableName=online_data_lampblack), Column(name=smoke_density, tableName=online_data_lampblack), Column(name=voc_density, tableName=online_data_lampblack), Column(name=pm25, tableName=online_data_lampblack), Column(name=longitude, tableName=online_data_lampblack), Column(name=latitude, tableName=online_data_lampblack), Column(name=smoke_total, tableName=online_data_lampblack), Column(name=voc_total, tableName=online_data_lampblack), Column(name=pm25_total, tableName=online_data_lampblack)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13)]), columnsListLastPosition=206, generateKeyColumnIndex=-1, insertValuesListLastPosition=268) 2022-05-20 16:18:00.130 [Thread-134] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_05 (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S3, 20220520161500, 20220520161642, null, null, 2.760000000000, 0.07000000, 2.740000000000, null, null, null, null, null]] 2022-05-20 16:19:33.373 [Thread-133] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-133,10,main] 2022-05-20 16:20:00.026 [xxl-rpc, EmbedServer bizThreadPool-1684695015] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:21:33.285 [Thread-135] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-135,10,main] 2022-05-20 16:22:00.047 [xxl-rpc, EmbedServer bizThreadPool-1688941339] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:23:33.312 [Thread-137] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-137,10,main] 2022-05-20 16:24:00.016 [xxl-rpc, EmbedServer bizThreadPool-499220404] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:25:33.288 [Thread-139] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-139,10,main] 2022-05-20 16:26:00.052 [xxl-rpc, EmbedServer bizThreadPool-1863891795] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:27:33.262 [Thread-141] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-141,10,main] 2022-05-20 16:28:00.046 [xxl-rpc, EmbedServer bizThreadPool-1019704345] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:29:33.339 [Thread-143] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-143,10,main] 2022-05-20 16:30:00.022 [xxl-rpc, EmbedServer bizThreadPool-2034938238] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:31:33.305 [Thread-145] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-145,10,main] 2022-05-20 16:32:00.018 [xxl-rpc, EmbedServer bizThreadPool-967583520] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:33:33.245 [Thread-147] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-147,10,main] 2022-05-20 16:34:00.052 [xxl-rpc, EmbedServer bizThreadPool-1525290753] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:35:00.048 [xxl-rpc, EmbedServer bizThreadPool-1525290753] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@36931450[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor] 2022-05-20 16:35:00.052 [Thread-152] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0 2022-05-20 16:35:00.053 [Thread-152] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null) 2022-05-20 16:35:00.053 [Thread-152] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0 2022-05-20 16:35:33.385 [Thread-149] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-149,10,main] 2022-05-20 16:36:00.026 [xxl-rpc, EmbedServer bizThreadPool-1525290753] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:36:33.449 [Thread-151] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-151,10,main] 2022-05-20 16:37:33.302 [Thread-153] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-153,10,main] 2022-05-20 16:38:00.026 [xxl-rpc, EmbedServer bizThreadPool-1523229563] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:39:33.216 [Thread-155] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-155,10,main] 2022-05-20 16:40:00.021 [xxl-rpc, EmbedServer bizThreadPool-1624643526] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:41:33.238 [Thread-157] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-157,10,main] 2022-05-20 16:42:00.040 [xxl-rpc, EmbedServer bizThreadPool-372366028] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:43:33.264 [Thread-159] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-159,10,main] 2022-05-20 16:44:00.046 [xxl-rpc, EmbedServer bizThreadPool-90056620] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:45:33.276 [Thread-161] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-161,10,main] 2022-05-20 16:46:00.029 [xxl-rpc, EmbedServer bizThreadPool-1991358894] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:47:33.307 [Thread-163] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-163,10,main] 2022-05-20 16:48:00.022 [xxl-rpc, EmbedServer bizThreadPool-1901589097] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:49:33.285 [Thread-165] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-165,10,main] 2022-05-20 16:50:00.022 [xxl-rpc, EmbedServer bizThreadPool-1866249029] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:51:33.265 [Thread-167] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-167,10,main] 2022-05-20 16:52:00.050 [xxl-rpc, EmbedServer bizThreadPool-1743992561] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:53:33.312 [Thread-169] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-169,10,main] 2022-05-20 16:54:00.037 [xxl-rpc, EmbedServer bizThreadPool-980487721] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:55:33.238 [Thread-171] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-171,10,main] 2022-05-20 16:56:00.046 [xxl-rpc, EmbedServer bizThreadPool-1416637954] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:57:33.301 [Thread-173] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-173,10,main] 2022-05-20 16:58:00.045 [xxl-rpc, EmbedServer bizThreadPool-1910913490] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 16:59:33.313 [Thread-175] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-175,10,main] 2022-05-20 17:00:00.048 [xxl-rpc, EmbedServer bizThreadPool-792945794] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:01:33.295 [Thread-177] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-177,10,main] 2022-05-20 17:02:00.041 [xxl-rpc, EmbedServer bizThreadPool-1001895640] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:03:33.305 [Thread-179] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-179,10,main] 2022-05-20 17:04:00.059 [xxl-rpc, EmbedServer bizThreadPool-1864412339] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:05:00.056 [xxl-rpc, EmbedServer bizThreadPool-1864412339] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@36931450[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor] 2022-05-20 17:05:00.060 [Thread-184] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0 2022-05-20 17:05:00.060 [Thread-184] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null) 2022-05-20 17:05:00.061 [Thread-184] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0 2022-05-20 17:05:33.337 [Thread-181] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-181,10,main] 2022-05-20 17:06:00.027 [xxl-rpc, EmbedServer bizThreadPool-1864412339] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:06:33.444 [Thread-183] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-183,10,main] 2022-05-20 17:07:33.335 [Thread-185] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-185,10,main] 2022-05-20 17:08:00.056 [xxl-rpc, EmbedServer bizThreadPool-1052542501] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:09:33.354 [Thread-187] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-187,10,main] 2022-05-20 17:10:00.050 [xxl-rpc, EmbedServer bizThreadPool-1244709106] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:11:33.296 [Thread-189] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-189,10,main] 2022-05-20 17:12:00.039 [xxl-rpc, EmbedServer bizThreadPool-680625358] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:13:33.283 [Thread-191] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-191,10,main] 2022-05-20 17:14:00.042 [xxl-rpc, EmbedServer bizThreadPool-396083639] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:15:33.263 [Thread-193] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-193,10,main] 2022-05-20 17:16:00.020 [xxl-rpc, EmbedServer bizThreadPool-1312715282] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:17:33.265 [Thread-195] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-195,10,main] 2022-05-20 17:18:00.048 [xxl-rpc, EmbedServer bizThreadPool-1013419105] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:19:33.256 [Thread-197] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-197,10,main] 2022-05-20 17:20:00.022 [xxl-rpc, EmbedServer bizThreadPool-1767821952] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:21:33.298 [Thread-199] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-199,10,main] 2022-05-20 17:22:00.026 [xxl-rpc, EmbedServer bizThreadPool-810212376] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:23:33.255 [Thread-201] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-201,10,main] 2022-05-20 17:24:00.027 [xxl-rpc, EmbedServer bizThreadPool-9688231] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:25:33.248 [Thread-203] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-203,10,main] 2022-05-20 17:26:00.023 [xxl-rpc, EmbedServer bizThreadPool-1264707314] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:27:33.287 [Thread-205] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-205,10,main] 2022-05-20 17:28:00.030 [xxl-rpc, EmbedServer bizThreadPool-958684651] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:29:33.291 [Thread-207] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-207,10,main] 2022-05-20 17:30:00.029 [xxl-rpc, EmbedServer bizThreadPool-1750117981] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 17:31:33.197 [Thread-209] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-209,10,main] 2022-05-20 17:32:00.033 [xxl-rpc, EmbedServer bizThreadPool-222738086] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 21:38:23.750 [Thread-211] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-211,10,main] 2022-05-20 21:40:00.030 [xxl-rpc, EmbedServer bizThreadPool-802547704] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@dbcf7c3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute] 2022-05-20 21:40:54.995 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server stop. 2022-05-20 21:40:55.000 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job registry-remove success, registryParam:RegistryParam{registryGroup='EXECUTOR', registryKey='cems-hj212-db', registryValue='http://127.0.0.1:8198/'}, registryResult:ReturnT [code=200, msg=null, content=null] 2022-05-20 21:40:55.000 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job, executor registry thread destory. 2022-05-20 21:40:55.001 [SpringApplicationShutdownHook] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server destroy success. 2022-05-20 21:40:55.006 [Thread-213] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-213,10,main] 2022-05-20 21:40:55.006 [xxl-job, executor TriggerCallbackThread] INFO com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor callback thread destory. 2022-05-20 21:40:55.007 [Thread-4] INFO com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor retry callback thread destory.