Sākums Izpētīt Palīdzība
Reģistrēties Pierakstīties
YouYan
/
IOT
2
0
Atdalīts 0
Faili Problēmas 0 Izmaiņu pieprasījumi 0 Vikivietne
Atzars: master
Atzari Tagi
IOT
/
SourceCode
/
logs
/
cems-data-service.2022-03-20.0.log

cems-data-service.2022-03-20.0.log 50 KB
Patstāvīgā saite Vēsture Neapstrādāts

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148 
  1. 2022-03-20 18:54:05.287 [main] INFO  com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 44736 (D:\iwb-workstation-2021\InternetOfThing\SourceCode\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\SourceCode)
    2. 

  2. 2022-03-20 18:54:05.288 [main] INFO  com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: dev
    3. 

  3. 2022-03-20 18:54:06.515 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8196"]
    4. 

  4. 2022-03-20 18:54:06.515 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
    5. 

  5. 2022-03-20 18:54:06.516 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
    6. 

  6. 2022-03-20 18:54:06.603 [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
    7. 

  7. 2022-03-20 18:54:07.510 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
    8. 

  8. 2022-03-20 18:54:07.617 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
    9. 

  9. 2022-03-20 18:54:10.372 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
    10. 

  10. 2022-03-20 18:54:10.475 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited
    11. 

  11. 2022-03-20 18:54:14.930 [main] INFO  com.yyjc.fbs.server.dbserveice.config.XxlJobConfig - >>>>>>>>>>> xxl-job config init.
    12. 

  12. 2022-03-20 18:54:15.297 [main] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    13. 

  13. 2022-03-20 18:54:15.298 [main] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysMonitorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@286866cb[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
    14. 

  14. 2022-03-20 18:54:15.298 [main] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataErrorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@ce561cc[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#executeError]
    15. 

  15. 2022-03-20 18:54:15.327 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8196"]
    16. 

  16. 2022-03-20 18:54:15.341 [main] INFO  com.yyjc.fbs.server.dbserveice.DBServiceApplication - Started DBServiceApplication in 11.13 seconds (JVM running for 12.086)
    17. 

  17. 2022-03-20 18:54:15.560 [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
    18. 

  18. 2022-03-20 18:56:00.241 [xxl-rpc, EmbedServer bizThreadPool-46102204] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    19. 

  19. 2022-03-20 18:56:00.291 [Thread-8] INFO  Sharding-Sphere-SQL - Logic SQL: select * from parse_type
    20. 

  20. 2022-03-20 18:56:00.291 [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)
    21. 

  21. 2022-03-20 18:56:00.291 [Thread-8] INFO  Sharding-Sphere-SQL - Actual SQL: cems-server-config ::: select * from t_parse_type
    22. 

  22. 2022-03-20 18:56:00.370 [Thread-8] INFO  Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
    23. 

  23. 2022-03-20 18:56:00.370 [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)
    24. 

  24. 2022-03-20 18:56:00.370 [Thread-8] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
    25. 

  25. 2022-03-20 18:57:33.776 [Thread-7] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-7,10,main]
    26. 

  26. 2022-03-20 18:58:00.046 [xxl-rpc, EmbedServer bizThreadPool-1486548243] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    27. 

  27. 2022-03-20 18:59:33.291 [Thread-9] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-9,10,main]
    28. 

  28. 2022-03-20 19:00:00.043 [xxl-rpc, EmbedServer bizThreadPool-1928412827] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    29. 

  29. 2022-03-20 19:01:33.294 [Thread-11] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-11,10,main]
    30. 

  30. 2022-03-20 19:02:00.047 [xxl-rpc, EmbedServer bizThreadPool-1480146326] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    31. 

  31. 2022-03-20 19:03:33.310 [Thread-13] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-13,10,main]
    32. 

  32. 2022-03-20 19:04:00.043 [xxl-rpc, EmbedServer bizThreadPool-2142847828] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    33. 

  33. 2022-03-20 19:05:00.032 [xxl-rpc, EmbedServer bizThreadPool-2142847828] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@286866cb[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
    34. 

  34. 2022-03-20 19:05:00.040 [Thread-18] INFO  Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
    35. 

  35. 2022-03-20 19:05:00.040 [Thread-18] 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)
    36. 

  36. 2022-03-20 19:05:00.041 [Thread-18] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
    37. 

  37. 2022-03-20 19:05:33.307 [Thread-15] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-15,10,main]
    38. 

  38. 2022-03-20 19:06:00.024 [xxl-rpc, EmbedServer bizThreadPool-2142847828] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    39. 

  39. 2022-03-20 19:06:33.414 [Thread-17] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-17,10,main]
    40. 

  40. 2022-03-20 19:07:33.282 [Thread-19] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-19,10,main]
    41. 

  41. 2022-03-20 19:08:00.016 [xxl-rpc, EmbedServer bizThreadPool-1385428601] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    42. 

  42. 2022-03-20 19:09:33.247 [Thread-21] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-21,10,main]
    43. 

  43. 2022-03-20 19:10:00.052 [xxl-rpc, EmbedServer bizThreadPool-1406603918] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    44. 

  44. 2022-03-20 19:11:33.335 [Thread-23] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-23,10,main]
    45. 

  45. 2022-03-20 19:12:00.032 [xxl-rpc, EmbedServer bizThreadPool-1767552751] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    46. 

  46. 2022-03-20 19:13:33.269 [Thread-25] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-25,10,main]
    47. 

  47. 2022-03-20 19:14:00.051 [xxl-rpc, EmbedServer bizThreadPool-847935920] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    48. 

  48. 2022-03-20 19:14:00.133 [Thread-28] INFO  Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ),( ?,?,?,   ?  )
    49. 

  49. 2022-03-20 19:14:00.134 [Thread-28] 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@37b25790], 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)
    50. 

  50. 2022-03-20 19:14:00.134 [Thread-28] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_03  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ), ( ?,?,?,   ?  ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220320191000, 20220320191201, 2.020000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220320191000, 20220320191201, 2.470000000000]]
    51. 

  51. 2022-03-20 19:14:02.292 [Thread-28] 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  (  ?,?,?,   ? , ? , ? , ? , ? , ? , ? , ? , ? , ?  )
    52. 

  52. 2022-03-20 19:14:02.293 [Thread-28] 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@36d79b04], 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)
    53. 

  53. 2022-03-20 19:14:02.293 [Thread-28] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_03  (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, 20220320191000, 20220320191201, null, null, 1.780000000000, 0.07000000, 2.900000000000, null, null, null, null, null]]
    54. 

  54. 2022-03-20 19:15:35.640 [Thread-27] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-27,10,main]
    55. 

  55. 2022-03-20 19:16:00.024 [xxl-rpc, EmbedServer bizThreadPool-1890753981] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    56. 

  56. 2022-03-20 19:17:33.307 [Thread-29] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-29,10,main]
    57. 

  57. 2022-03-20 19:18:00.053 [xxl-rpc, EmbedServer bizThreadPool-661393542] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    58. 

  58. 2022-03-20 19:18:00.060 [Thread-32] INFO  Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ),( ?,?,?,   ?  )
    59. 

  59. 2022-03-20 19:18:00.060 [Thread-32] 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@37b25790], 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)
    60. 

  60. 2022-03-20 19:18:00.060 [Thread-32] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_03  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ), ( ?,?,?,   ?  ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220320191500, 20220320191701, 2.550000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220320191500, 20220320191701, 5.240000000000]]
    61. 

  61. 2022-03-20 19:18:01.261 [Thread-32] 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  (  ?,?,?,   ? , ? , ? , ? , ? , ? , ? , ? , ? , ?  )
    62. 

  62. 2022-03-20 19:18:01.262 [Thread-32] 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@36d79b04], 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)
    63. 

  63. 2022-03-20 19:18:01.262 [Thread-32] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_03  (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, 20220320191500, 20220320191701, null, null, 4.130000000000, 0.07000000, 1.070000000000, null, null, null, null, null]]
    64. 

  64. 2022-03-20 19:19:34.568 [Thread-31] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-31,10,main]
    65. 

  65. 2022-03-20 19:20:00.023 [xxl-rpc, EmbedServer bizThreadPool-1600878136] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    66. 

  66. 2022-03-20 19:21:33.230 [Thread-33] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-33,10,main]
    67. 

  67. 2022-03-20 19:22:00.025 [xxl-rpc, EmbedServer bizThreadPool-1734360571] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    68. 

  68. 2022-03-20 19:23:33.300 [Thread-35] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-35,10,main]
    69. 

  69. 2022-03-20 19:24:00.016 [xxl-rpc, EmbedServer bizThreadPool-1297807686] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    70. 

  70. 2022-03-20 19:24:00.025 [Thread-38] INFO  Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ),( ?,?,?,   ?  )
    71. 

  71. 2022-03-20 19:24:00.025 [Thread-38] 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@37b25790], 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)
    72. 

  72. 2022-03-20 19:24:00.025 [Thread-38] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_03  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ), ( ?,?,?,   ?  ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220320192000, 20220320192201, 4.520000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220320192000, 20220320192201, 4.990000000000]]
    73. 

  73. 2022-03-20 19:24:02.133 [Thread-38] 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  (  ?,?,?,   ? , ? , ? , ? , ? , ? , ? , ? , ? , ?  )
    74. 

  74. 2022-03-20 19:24:02.133 [Thread-38] 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@36d79b04], 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)
    75. 

  75. 2022-03-20 19:24:02.133 [Thread-38] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_03  (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, 20220320192000, 20220320192201, null, null, 2.550000000000, 0.07000000, 1.710000000000, null, null, null, null, null]]
    76. 

  76. 2022-03-20 19:25:35.479 [Thread-37] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-37,10,main]
    77. 

  77. 2022-03-20 19:26:00.049 [xxl-rpc, EmbedServer bizThreadPool-541324982] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    78. 

  78. 2022-03-20 19:27:33.305 [Thread-39] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-39,10,main]
    79. 

  79. 2022-03-20 19:28:00.048 [xxl-rpc, EmbedServer bizThreadPool-598868081] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    80. 

  80. 2022-03-20 19:28:00.057 [Thread-42] INFO  Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ),( ?,?,?,   ?  )
    81. 

  81. 2022-03-20 19:28:00.057 [Thread-42] 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@37b25790], 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)
    82. 

  82. 2022-03-20 19:28:00.057 [Thread-42] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_03  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ), ( ?,?,?,   ?  ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220320192500, 20220320192701, 2.070000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220320192500, 20220320192701, 2.860000000000]]
    83. 

  83. 2022-03-20 19:28:01.285 [Thread-42] 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  (  ?,?,?,   ? , ? , ? , ? , ? , ? , ? , ? , ? , ?  )
    84. 

  84. 2022-03-20 19:28:01.285 [Thread-42] 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@36d79b04], 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)
    85. 

  85. 2022-03-20 19:28:01.285 [Thread-42] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_03  (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, 20220320192500, 20220320192701, null, null, 2.120000000000, 0.07000000, 2.930000000000, null, null, null, null, null]]
    86. 

  86. 2022-03-20 19:29:34.627 [Thread-41] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-41,10,main]
    87. 

  87. 2022-03-20 19:30:00.029 [xxl-rpc, EmbedServer bizThreadPool-2104524359] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    88. 

  88. 2022-03-20 19:31:33.282 [Thread-43] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-43,10,main]
    89. 

  89. 2022-03-20 19:32:00.048 [xxl-rpc, EmbedServer bizThreadPool-1026043114] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    90. 

  90. 2022-03-20 19:33:18.572 [Thread-5] INFO  com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server stop.
    91. 

  91. 2022-03-20 19:33:18.579 [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]
    92. 

  92. 2022-03-20 19:33:18.581 [xxl-job, executor ExecutorRegistryThread] INFO  com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job, executor registry thread destory.
    93. 

  93. 2022-03-20 19:33:18.581 [SpringApplicationShutdownHook] INFO  com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server destroy success.
    94. 

  94. 2022-03-20 19:33:18.585 [Thread-45] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-45,10,main]
    95. 

  95. 2022-03-20 19:33:18.586 [xxl-job, executor TriggerCallbackThread] INFO  com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor callback thread destory.
    96. 

  96. 2022-03-20 19:33:18.586 [Thread-4] INFO  com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor retry callback thread destory.
    97. 

  97. 2022-03-20 19:33:24.252 [main] INFO  com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 45592 (D:\iwb-workstation-2021\InternetOfThing\SourceCode\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\SourceCode)
    98. 

  98. 2022-03-20 19:33:24.254 [main] INFO  com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: dev
    99. 

  99. 2022-03-20 19:33:25.478 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8196"]
    100. 

  100. 2022-03-20 19:33:25.478 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
    101. 

  101. 2022-03-20 19:33:25.479 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
    102. 

  102. 2022-03-20 19:33:25.573 [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
    103. 

  103. 2022-03-20 19:33:26.557 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
    104. 

  104. 2022-03-20 19:33:26.653 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
    105. 

  105. 2022-03-20 19:33:26.750 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
    106. 

  106. 2022-03-20 19:33:26.844 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited
    107. 

  107. 2022-03-20 19:33:27.768 [main] INFO  com.yyjc.fbs.server.dbserveice.config.XxlJobConfig - >>>>>>>>>>> xxl-job config init.
    108. 

  108. 2022-03-20 19:33:28.117 [main] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    109. 

  109. 2022-03-20 19:33:28.117 [main] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysMonitorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@286866cb[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
    110. 

  110. 2022-03-20 19:33:28.118 [main] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataErrorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@ce561cc[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#executeError]
    111. 

  111. 2022-03-20 19:33:28.156 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8196"]
    112. 

  112. 2022-03-20 19:33:28.172 [main] INFO  com.yyjc.fbs.server.dbserveice.DBServiceApplication - Started DBServiceApplication in 4.977 seconds (JVM running for 6.003)
    113. 

  113. 2022-03-20 19:33:28.397 [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
    114. 

  114. 2022-03-20 19:34:00.254 [xxl-rpc, EmbedServer bizThreadPool-1403128545] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    115. 

  115. 2022-03-20 19:34:00.296 [Thread-8] INFO  Sharding-Sphere-SQL - Logic SQL: select * from parse_type
    116. 

  116. 2022-03-20 19:34:00.296 [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)
    117. 

  117. 2022-03-20 19:34:00.297 [Thread-8] INFO  Sharding-Sphere-SQL - Actual SQL: cems-server-config ::: select * from t_parse_type
    118. 

  118. 2022-03-20 19:34:00.336 [Thread-8] INFO  Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
    119. 

  119. 2022-03-20 19:34:00.336 [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)
    120. 

  120. 2022-03-20 19:34:00.336 [Thread-8] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
    121. 

  121. 2022-03-20 19:34:00.546 [Thread-8] INFO  Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ),( ?,?,?,   ?  )
    122. 

  122. 2022-03-20 19:34:00.546 [Thread-8] 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@64b7a896], 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)
    123. 

  123. 2022-03-20 19:34:00.546 [Thread-8] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_03  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ), ( ?,?,?,   ?  ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220320193000, 20220320193201, 4.980000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220320193000, 20220320193201, 4.940000000000]]
    124. 

  124. 2022-03-20 19:34:00.561 [Thread-8] 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  (  ?,?,?,   ? , ? , ? , ? , ? , ? , ? , ? , ? , ?  )
    125. 

  125. 2022-03-20 19:34:00.562 [Thread-8] 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@6ae9e78], 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)
    126. 

  126. 2022-03-20 19:34:00.562 [Thread-8] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_03  (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, 20220320193000, 20220320193201, null, null, 2.240000000000, 0.07000000, 2.460000000000, null, null, null, null, null]]
    127. 

  127. 2022-03-20 19:35:00.030 [xxl-rpc, EmbedServer bizThreadPool-1403128545] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@286866cb[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
    128. 

  128. 2022-03-20 19:35:00.033 [Thread-10] INFO  Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
    129. 

  129. 2022-03-20 19:35:00.034 [Thread-10] 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)
    130. 

  130. 2022-03-20 19:35:00.034 [Thread-10] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
    131. 

  131. 2022-03-20 19:35:33.840 [Thread-7] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-7,10,main]
    132. 

  132. 2022-03-20 19:36:00.058 [xxl-rpc, EmbedServer bizThreadPool-633840823] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    133. 

  133. 2022-03-20 19:36:33.243 [Thread-9] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-9,10,main]
    134. 

  134. 2022-03-20 19:37:33.329 [Thread-11] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-11,10,main]
    135. 

  135. 2022-03-20 19:38:00.045 [xxl-rpc, EmbedServer bizThreadPool-1597921926] INFO  com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@1b4a3a1[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
    136. 

  136. 2022-03-20 19:38:00.053 [Thread-14] INFO  Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ),( ?,?,?,   ?  )
    137. 

  137. 2022-03-20 19:38:00.053 [Thread-14] 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@64b7a896], 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)
    138. 

  138. 2022-03-20 19:38:00.053 [Thread-14] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_03  (terminal_id,upload_date,insert_time,  ia ) VALUES  (  ?,?,?,   ?  ), ( ?,?,?,   ?  ) ::: [[C9ADFEEFC4EB4EB08FB296F4S1, 20220320193500, 20220320193701, 2.210000000000, C9ADFEEFC4EB4EB08FB296F4S2, 20220320193500, 20220320193701, 3.810000000000]]
    139. 

  139. 2022-03-20 19:38:00.094 [Thread-14] 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  (  ?,?,?,   ? , ? , ? , ? , ? , ? , ? , ? , ? , ?  )
    140. 

  140. 2022-03-20 19:38:00.094 [Thread-14] 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@6ae9e78], 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)
    141. 

  141. 2022-03-20 19:38:00.094 [Thread-14] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_03  (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, 20220320193500, 20220320193701, null, null, 2.920000000000, 0.07000000, 1.770000000000, null, null, null, null, null]]
    142. 

  142. 2022-03-20 19:38:14.036 [Thread-5] INFO  com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server stop.
    143. 

  143. 2022-03-20 19:38:14.039 [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]
    144. 

  144. 2022-03-20 19:38:14.039 [xxl-job, executor ExecutorRegistryThread] INFO  com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job, executor registry thread destory.
    145. 

  145. 2022-03-20 19:38:14.040 [SpringApplicationShutdownHook] INFO  com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server destroy success.
    146. 

  146. 2022-03-20 19:38:14.065 [Thread-13] INFO  com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-13,10,main]
    147. 

  147. 2022-03-20 19:38:14.066 [xxl-job, executor TriggerCallbackThread] INFO  com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor callback thread destory.
    148. 

  148. 2022-03-20 19:38:14.067 [Thread-4] INFO  com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor retry callback thread destory.
    149.