Startseite Erkunden Hilfe
Registrieren Anmelden
ZONIOT
/
water-iot
3
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: b64b382053
Branches Tags
water-iot
/
gydatasync
/
log.log

log.log 12 KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 
  1. 2020-07-22 14:34:40.455  INFO 7804 --- [main] c.h.gydatasync.GydatasyncApplication     : Starting GydatasyncApplication on ZJY-PC with PID 7804 (E:\Work\对外接口\桂阳\code\gydatasync\target\classes started by ZJY in E:\Work\对外接口\桂阳\code\gydatasync)
    2. 

  2. 2020-07-22 14:34:40.490  INFO 7804 --- [main] c.h.gydatasync.GydatasyncApplication     : The following profiles are active: dev
    3. 

  3. 2020-07-22 14:34:42.879  INFO 7804 --- [main] o.s.s.c.ThreadPoolTaskScheduler          : Initializing ExecutorService 'taskScheduler'
    4. 

  4. 2020-07-22 14:35:06.987  INFO 7804 --- [main] c.h.gydatasync.GydatasyncApplication     : Started GydatasyncApplication in 27.194 seconds (JVM running for 28.189)
    5. 

  5. 2020-07-22 14:35:07.048  INFO 7804 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    6. 

  6. 2020-07-22 14:35:15.065  INFO 7804 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    7. 

  7. 2020-07-22 14:35:15.122 DEBUG 7804 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==>  Preparing: select COUNT(*) from WaterData where CONVERT(varchar(10),UpLoadDateTime,120) = CONVERT(varchar(10),GETDATE(),120)
    8. 

  8. 2020-07-22 14:35:15.887 DEBUG 7804 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==> Parameters: 
    9. 

  9. 2020-07-22 14:35:16.376 DEBUG 7804 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : <==      Total: 1
    10. 

  10. 2020-07-22 14:40:09.330  WARN 7804 --- [HikariPool-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=4m54s159ms653µs980ns).
    11. 

  11. 2020-07-22 14:40:09.333  INFO 7804 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Starting...
    12. 

  12. 2020-07-22 14:40:09.899  INFO 7804 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Start completed.
    13. 

  13. 2020-07-22 14:40:09.901 DEBUG 7804 --- [scheduling-1] c.h.g.dao.mysql.ReadMeterDao.getAllList  : ==>  Preparing: SELECT sd.water_meter_file_no as customerID, a.device_id as deviceID, a.read_data as cbz, a.read_time as cbsj, now() as upLoadDateTime, CONCAT(sd.water_meter_file_no,'1') as customerMeterID FROM sc_meter_read_record a left JOIN sc_device sd on a.device_id = sd.id WHERE a.read_date = DATE_FORMAT( DATE_SUB( now(), INTERVAL 1 DAY ), '%Y%m%d' ) AND a.device_id IN ( SELECT id FROM sc_device WHERE building_id IN ( 6675, 6676, 6677, 6678, 6679, 6680 ) AND STATUS = 1 )
    14. 

  14. 2020-07-22 14:40:09.938 DEBUG 7804 --- [scheduling-1] c.h.g.dao.mysql.ReadMeterDao.getAllList  : ==> Parameters: 
    15. 

  15. 2020-07-22 14:40:10.479 DEBUG 7804 --- [scheduling-1] c.h.g.dao.mysql.ReadMeterDao.getAllList  : <==      Total: 476
    16. 

  16. 2020-07-22 14:40:56.786  WARN 7804 --- [HikariPool-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=47s455ms360µs350ns).
    17. 

  17. 2020-07-22 14:40:56.788  WARN 7804 --- [HikariPool-2 housekeeper] com.zaxxer.hikari.pool.HikariPool        : HikariPool-2 - Thread starvation or clock leap detected (housekeeper delta=46s787ms862µs479ns).
    18. 

  18. 2020-07-22 14:40:56.856  INFO 7804 --- [SpringContextShutdownHook] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'taskScheduler'
    19. 

  19. 2020-07-22 14:40:56.857  INFO 7804 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
    20. 

  20. 2020-07-22 14:40:56.862  INFO 7804 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
    21. 

  21. 2020-07-22 14:40:56.864  INFO 7804 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Shutdown initiated...
    22. 

  22. 2020-07-22 14:40:56.872  INFO 7804 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Shutdown completed.
    23. 

  23. 2020-07-22 14:45:16.734  INFO 10816 --- [main] c.h.gydatasync.GydatasyncApplication     : Starting GydatasyncApplication on ZJY-PC with PID 10816 (E:\Work\对外接口\桂阳\code\gydatasync\target\classes started by ZJY in E:\Work\对外接口\桂阳\code\gydatasync)
    24. 

  24. 2020-07-22 14:45:16.739  INFO 10816 --- [main] c.h.gydatasync.GydatasyncApplication     : The following profiles are active: dev
    25. 

  25. 2020-07-22 14:45:17.751  INFO 10816 --- [main] o.s.s.c.ThreadPoolTaskScheduler          : Initializing ExecutorService 'taskScheduler'
    26. 

  26. 2020-07-22 14:45:22.081  INFO 10816 --- [main] c.h.gydatasync.GydatasyncApplication     : Started GydatasyncApplication in 5.737 seconds (JVM running for 6.374)
    27. 

  27. 2020-07-22 14:45:22.132  INFO 10816 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    28. 

  28. 2020-07-22 14:45:29.890  INFO 10816 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    29. 

  29. 2020-07-22 14:45:29.946 DEBUG 10816 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==>  Preparing: select COUNT(*) from WaterData where CONVERT(varchar(10),UpLoadDateTime,120) = CONVERT(varchar(10),GETDATE(),120)
    30. 

  30. 2020-07-22 14:45:30.688 DEBUG 10816 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==> Parameters: 
    31. 

  31. 2020-07-22 14:45:31.089 DEBUG 10816 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : <==      Total: 1
    32. 

  32. 2020-07-22 14:46:41.936  WARN 10816 --- [HikariPool-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=1m11s944ms422µs457ns).
    33. 

  33. 2020-07-22 14:46:41.937  INFO 10816 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Starting...
    34. 

  34. 2020-07-22 14:46:41.997  INFO 10816 --- [SpringContextShutdownHook] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'taskScheduler'
    35. 

  35. 2020-07-22 14:46:41.999  INFO 10816 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
    36. 

  36. 2020-07-22 14:46:42.005  INFO 10816 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
    37. 

  37. 2020-07-22 14:52:03.682  INFO 11176 --- [main] c.h.gydatasync.GydatasyncApplication     : Starting GydatasyncApplication on ZJY-PC with PID 11176 (E:\Work\对外接口\桂阳\code\gydatasync\target\classes started by ZJY in E:\Work\对外接口\桂阳\code\gydatasync)
    38. 

  38. 2020-07-22 14:52:03.684  INFO 11176 --- [main] c.h.gydatasync.GydatasyncApplication     : The following profiles are active: dev
    39. 

  39. 2020-07-22 14:52:04.720  INFO 11176 --- [main] o.s.s.c.ThreadPoolTaskScheduler          : Initializing ExecutorService 'taskScheduler'
    40. 

  40. 2020-07-22 14:52:08.049  INFO 11176 --- [main] c.h.gydatasync.GydatasyncApplication     : Started GydatasyncApplication in 4.734 seconds (JVM running for 5.359)
    41. 

  41. 2020-07-22 14:52:08.100  INFO 11176 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    42. 

  42. 2020-07-22 14:52:16.759  INFO 11176 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    43. 

  43. 2020-07-22 14:52:16.817 DEBUG 11176 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==>  Preparing: select COUNT(*) from WaterData where CONVERT(varchar(10),UpLoadDateTime,120) = CONVERT(varchar(10),GETDATE(),120)
    44. 

  44. 2020-07-22 14:52:17.627 DEBUG 11176 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==> Parameters: 
    45. 

  45. 2020-07-22 14:52:18.056 DEBUG 11176 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : <==      Total: 1
    46. 

  46. 2020-07-22 14:53:08.573  WARN 11176 --- [HikariPool-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=51s711ms984µs857ns).
    47. 

  47. 2020-07-22 14:53:08.575  INFO 11176 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Starting...
    48. 

  48. 2020-07-22 14:53:08.624  INFO 11176 --- [SpringContextShutdownHook] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'taskScheduler'
    49. 

  49. 2020-07-22 14:53:08.625  INFO 11176 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
    50. 

  50. 2020-07-22 14:53:08.631  INFO 11176 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
    51. 

  51. 2020-07-22 14:56:00.743  INFO 9644 --- [main] c.h.gydatasync.GydatasyncApplication     : Starting GydatasyncApplication on ZJY-PC with PID 9644 (E:\Work\对外接口\桂阳\code\gydatasync\target\classes started by ZJY in E:\Work\对外接口\桂阳\code\gydatasync)
    52. 

  52. 2020-07-22 14:56:00.746  INFO 9644 --- [main] c.h.gydatasync.GydatasyncApplication     : The following profiles are active: dev
    53. 

  53. 2020-07-22 14:56:01.851  INFO 9644 --- [main] o.s.s.c.ThreadPoolTaskScheduler          : Initializing ExecutorService 'taskScheduler'
    54. 

  54. 2020-07-22 14:56:01.886  INFO 9644 --- [main] c.h.gydatasync.GydatasyncApplication     : Started GydatasyncApplication in 1.492 seconds (JVM running for 2.129)
    55. 

  55. 2020-07-22 14:56:01.898  INFO 9644 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    56. 

  56. 2020-07-22 14:56:02.104  INFO 9644 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    57. 

  57. 2020-07-22 14:56:02.111 DEBUG 9644 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==>  Preparing: select COUNT(*) from WaterData where CONVERT(varchar(10),UpLoadDateTime,120) = CONVERT(varchar(10),GETDATE(),120)
    58. 

  58. 2020-07-22 14:56:02.141 DEBUG 9644 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==> Parameters: 
    59. 

  59. 2020-07-22 14:56:02.169 DEBUG 9644 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : <==      Total: 1
    60. 

  60. 2020-07-22 15:01:41.411  INFO 9644 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Starting...
    61. 

  61. 2020-07-22 15:01:41.413  WARN 9644 --- [HikariPool-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=6m9s302ms961µs737ns).
    62. 

  62. 2020-07-22 15:01:41.469  INFO 9644 --- [SpringContextShutdownHook] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'taskScheduler'
    63. 

  63. 2020-07-22 15:01:41.470  INFO 9644 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
    64. 

  64. 2020-07-22 15:01:41.482  INFO 9644 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
    65. 

  65. 2020-07-22 15:01:54.872  INFO 4348 --- [main] c.h.gydatasync.GydatasyncApplication     : Starting GydatasyncApplication on ZJY-PC with PID 4348 (E:\Work\对外接口\桂阳\code\gydatasync\target\classes started by ZJY in E:\Work\对外接口\桂阳\code\gydatasync)
    66. 

  66. 2020-07-22 15:01:54.875  INFO 4348 --- [main] c.h.gydatasync.GydatasyncApplication     : The following profiles are active: dev
    67. 

  67. 2020-07-22 15:01:55.927  INFO 4348 --- [main] o.s.s.c.ThreadPoolTaskScheduler          : Initializing ExecutorService 'taskScheduler'
    68. 

  68. 2020-07-22 15:01:55.964  INFO 4348 --- [main] c.h.gydatasync.GydatasyncApplication     : Started GydatasyncApplication in 1.484 seconds (JVM running for 2.102)
    69. 

  69. 2020-07-22 15:01:55.976  INFO 4348 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    70. 

  70. 2020-07-22 15:01:56.176  INFO 4348 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    71. 

  71. 2020-07-22 15:01:56.184 DEBUG 4348 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==>  Preparing: select COUNT(*) from WaterData where CONVERT(varchar(10),UpLoadDateTime,120) = CONVERT(varchar(10),GETDATE(),120)
    72. 

  72. 2020-07-22 15:01:56.205 DEBUG 4348 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : ==> Parameters: 
    73. 

  73. 2020-07-22 15:01:56.233 DEBUG 4348 --- [scheduling-1] c.h.g.d.mssql.SaveMeterDataDao.IsExist   : <==      Total: 1
    74. 

  74. 2020-07-22 15:02:24.323  WARN 4348 --- [HikariPool-1 housekeeper] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=58s146ms293µs997ns).
    75. 

  75. 2020-07-22 15:02:24.325  INFO 4348 --- [scheduling-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Starting...
    76. 

  76. 2020-07-22 15:02:24.401  INFO 4348 --- [SpringContextShutdownHook] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'taskScheduler'
    77. 

  77. 2020-07-22 15:02:24.403  INFO 4348 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
    78. 

  78. 2020-07-22 15:02:24.410  INFO 4348 --- [SpringContextShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
    79.