API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 19th, 2017
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 102.55 KB | None | 0 0
raw download clone embed print report
  1. 2017-12-19 10:48:17,033 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  2. 2017-12-19 10:48:17,034 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@74a62d] was not registered for synchronization because synchronization is not active
  3. 2017-12-19 10:48:17,034 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  4. 2017-12-19 10:48:17,035 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT.
  5. 2017-12-19 10:48:17,036 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT has SUCCEEDED.
  6. 2017-12-19 10:48:17,037 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@9cac33 [wrapping: com.mysql.jdbc.JDBC4Connection@1d22df]] will not be managed by Spring
  7. 2017-12-19 10:48:17,038 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM sale_mops WHERE id IN ( ? )
  8. 2017-12-19 10:48:17,038 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 3(Integer)
  9. 2017-12-19 10:48:17,039 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ====> Preparing: SELECT * FROM mops WHERE id = ?
  10. 2017-12-19 10:48:17,040 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ====> Parameters: 2(Integer)
  11. 2017-12-19 10:48:17,041 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <==== Total: 1
  12. 2017-12-19 10:48:17,041 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 1
  13. 2017-12-19 10:48:17,042 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@74a62d]
  14. 2017-12-19 10:48:17,042 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  15. 2017-12-19 10:48:17,043 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  16. 2017-12-19 10:48:17,043 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1b7dd1a] was not registered for synchronization because synchronization is not active
  17. 2017-12-19 10:48:17,044 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  18. 2017-12-19 10:48:17,044 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT.
  19. 2017-12-19 10:48:17,044 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT has SUCCEEDED.
  20. 2017-12-19 10:48:17,045 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@10a0e23 [wrapping: com.mysql.jdbc.JDBC4Connection@1d22df]] will not be managed by Spring
  21. 2017-12-19 10:48:17,045 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM sales WHERE id = ?
  22. 2017-12-19 10:48:17,045 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  23. 2017-12-19 10:48:17,047 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 1
  24. 2017-12-19 10:48:17,047 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1b7dd1a]
  25. 2017-12-19 10:48:17,047 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  26. 2017-12-19 10:48:17,048 [JavaFX Application Thread] [DEBUG] [SettingService.getSetting]:61 - Read setting MODULE_TABS=0
  27. 2017-12-19 10:48:17,048 [JavaFX Application Thread] [DEBUG] [SettingService.getSetting]:61 - Read setting MODULE_FUEL=1
  28. 2017-12-19 10:48:17,048 [JavaFX Application Thread] [INFO ] [MetaInfoDelegateService.reloadSaleItems]:163 - Reloading sale items...
  29. 2017-12-19 10:48:17,049 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  30. 2017-12-19 10:48:17,049 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2bfb44] was not registered for synchronization because synchronization is not active
  31. 2017-12-19 10:48:17,049 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  32. 2017-12-19 10:48:17,050 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT.
  33. 2017-12-19 10:48:17,050 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT has SUCCEEDED.
  34. 2017-12-19 10:48:17,050 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1b059b [wrapping: com.mysql.jdbc.JDBC4Connection@1d22df]] will not be managed by Spring
  35. 2017-12-19 10:48:17,051 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM sale_items WHERE sale_id = ? ORDER BY id
  36. 2017-12-19 10:48:17,053 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  37. 2017-12-19 10:48:17,053 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  38. 2017-12-19 10:48:17,054 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2bfb44]
  39. 2017-12-19 10:48:17,055 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  40. 2017-12-19 10:48:17,055 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  41. 2017-12-19 10:48:17,057 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2f79] was not registered for synchronization because synchronization is not active
  42. 2017-12-19 10:48:17,057 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  43. 2017-12-19 10:48:17,058 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT.
  44. 2017-12-19 10:48:17,058 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT has SUCCEEDED.
  45. 2017-12-19 10:48:17,059 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1558e57 [wrapping: com.mysql.jdbc.JDBC4Connection@1d22df]] will not be managed by Spring
  46. 2017-12-19 10:48:17,059 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT sit.* FROM sale_item_taxes sit INNER JOIN sale_items si ON sit.sale_item_id = si.id WHERE si.sale_id = ?
  47. 2017-12-19 10:48:17,060 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  48. 2017-12-19 10:48:17,061 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  49. 2017-12-19 10:48:17,061 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2f79]
  50. 2017-12-19 10:48:17,062 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  51. 2017-12-19 10:48:17,062 [JavaFX Application Thread] [INFO ] [MetaInfoDelegateService.reloadSaleItems]:175 - Reloading sale items finished
  52. 2017-12-19 10:48:17,063 [JavaFX Application Thread] [INFO ] [MetaInfoDelegateService.reloadSaleDepartments]:285 - Reloading sale departments...
  53. 2017-12-19 10:48:17,063 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  54. 2017-12-19 10:48:17,063 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@713a13] was not registered for synchronization because synchronization is not active
  55. 2017-12-19 10:48:17,064 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  56. 2017-12-19 10:48:17,064 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT.
  57. 2017-12-19 10:48:17,065 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT has SUCCEEDED.
  58. 2017-12-19 10:48:17,065 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@789801 [wrapping: com.mysql.jdbc.JDBC4Connection@1d22df]] will not be managed by Spring
  59. 2017-12-19 10:48:17,066 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM sale_departments WHERE sale_id = ? ORDER BY id
  60. 2017-12-19 10:48:17,066 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  61. 2017-12-19 10:48:17,067 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 1
  62. 2017-12-19 10:48:17,068 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@713a13]
  63. 2017-12-19 10:48:17,068 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  64. 2017-12-19 10:48:17,069 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  65. 2017-12-19 10:48:17,069 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@12e7b06] was not registered for synchronization because synchronization is not active
  66. 2017-12-19 10:48:17,070 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  67. 2017-12-19 10:48:17,071 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT.
  68. 2017-12-19 10:48:17,071 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT has SUCCEEDED.
  69. 2017-12-19 10:48:17,072 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@fd7553 [wrapping: com.mysql.jdbc.JDBC4Connection@1d22df]] will not be managed by Spring
  70. 2017-12-19 10:48:17,072 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM pricebook_departments WHERE id IN ( ? )
  71. 2017-12-19 10:48:17,073 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 11(Integer)
  72. 2017-12-19 10:48:17,080 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 1
  73. 2017-12-19 10:48:17,081 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@12e7b06]
  74. 2017-12-19 10:48:17,081 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  75. 2017-12-19 10:48:17,082 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  76. 2017-12-19 10:48:17,082 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@14aacda] was not registered for synchronization because synchronization is not active
  77. 2017-12-19 10:48:17,083 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  78. 2017-12-19 10:48:17,083 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT.
  79. 2017-12-19 10:48:17,084 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT has SUCCEEDED.
  80. 2017-12-19 10:48:17,086 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@c077b0 [wrapping: com.mysql.jdbc.JDBC4Connection@1d22df]] will not be managed by Spring
  81. 2017-12-19 10:48:17,087 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT sdt.* FROM sale_department_taxes sdt INNER JOIN sale_departments sd ON sdt.sale_department_id = sd.id WHERE sd.sale_id = ?
  82. 2017-12-19 10:48:17,088 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  83. 2017-12-19 10:48:17,088 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  84. 2017-12-19 10:48:17,089 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@14aacda]
  85. 2017-12-19 10:48:17,090 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  86. 2017-12-19 10:48:17,091 [JavaFX Application Thread] [INFO ] [MetaInfoDelegateService.reloadSaleDepartments]:297 - Reloading sale departments finished
  87. 2017-12-19 10:48:17,091 [JavaFX Application Thread] [INFO ] [MetaInfoDelegateService.reloadSaleCarWashProducts]:305 - Reloading sale car wash...
  88. 2017-12-19 10:48:17,091 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  89. 2017-12-19 10:48:17,092 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fe6747] was not registered for synchronization because synchronization is not active
  90. 2017-12-19 10:48:17,092 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  91. 2017-12-19 10:48:17,093 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT.
  92. 2017-12-19 10:48:17,093 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@79ae4c] on CHECKOUT has SUCCEEDED.
  93. 2017-12-19 10:48:17,094 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@72f3fb [wrapping: com.mysql.jdbc.JDBC4Connection@1d22df]] will not be managed by Spring
  94. 2017-12-19 10:48:17,094 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM sale_car_wash_products WHERE sale_id = ? ORDER BY id
  95. 2017-12-19 10:48:17,095 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  96. 2017-12-19 10:48:17,095 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  97. 2017-12-19 10:48:17,096 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fe6747]
  98. 2017-12-19 10:48:17,097 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  99. 2017-12-19 10:48:17,097 [JavaFX Application Thread] [INFO ] [MetaInfoDelegateService.reloadSaleCarWashProducts]:318 - Reloading sale car wash finished
  100. 2017-12-19 10:48:17,098 [JavaFX Application Thread] [INFO ] [MetaInfoDelegateService.reloadSaleFuels]:322 - Reloading sale fuels...
  101. 2017-12-19 10:48:17,098 [JavaFX Application Thread] [DEBUG] [AbstractPlatformTransactionManager.getTransaction]:367 - Creating new transaction with name [com.petrosoftinc.pos.core.services.domain.forecourt.SaleFuelService.getBySaleId]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly; '',-java.lang.RuntimeException
  102. 2017-12-19 10:48:17,098 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT.
  103. 2017-12-19 10:48:17,099 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT has SUCCEEDED.
  104. 2017-12-19 10:48:17,099 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doBegin]:206 - Acquired Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@13b4a25 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] for JDBC transaction
  105. 2017-12-19 10:48:17,100 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.prepareConnectionForTransaction]:153 - Setting JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@13b4a25 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] read-only
  106. 2017-12-19 10:48:17,100 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doBegin]:223 - Switching JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@13b4a25 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] to manual commit
  107. 2017-12-19 10:48:17,101 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  108. 2017-12-19 10:48:17,101 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:130 - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6853f]
  109. 2017-12-19 10:48:17,102 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@13b4a25 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] will be managed by Spring
  110. 2017-12-19 10:48:17,102 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM sale_fuels WHERE sale_id = ? ORDER BY id
  111. 2017-12-19 10:48:17,103 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  112. 2017-12-19 10:48:17,104 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  113. 2017-12-19 10:48:17,105 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:188 - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6853f]
  114. 2017-12-19 10:48:17,105 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCommit]:286 - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6853f]
  115. 2017-12-19 10:48:17,106 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:312 - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6853f]
  116. 2017-12-19 10:48:17,106 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:317 - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6853f]
  117. 2017-12-19 10:48:17,106 [JavaFX Application Thread] [DEBUG] [AbstractPlatformTransactionManager.processCommit]:759 - Initiating transaction commit
  118. 2017-12-19 10:48:17,108 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doCommit]:269 - Committing JDBC transaction on Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@13b4a25 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]]
  119. 2017-12-19 10:48:17,109 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.resetConnectionAfterTransaction]:222 - Resetting read-only flag of JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@13b4a25 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]]
  120. 2017-12-19 10:48:17,109 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doCleanupAfterCompletion]:327 - Releasing JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@13b4a25 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] after transaction
  121. 2017-12-19 10:48:17,110 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  122. 2017-12-19 10:48:17,110 [JavaFX Application Thread] [INFO ] [MetaInfoDelegateService.reloadSaleFuels]:335 - Reloading sale fuels finished
  123. 2017-12-19 10:48:17,111 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  124. 2017-12-19 10:48:17,111 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@21fa28] was not registered for synchronization because synchronization is not active
  125. 2017-12-19 10:48:17,111 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  126. 2017-12-19 10:48:17,112 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT.
  127. 2017-12-19 10:48:17,112 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT has SUCCEEDED.
  128. 2017-12-19 10:48:17,113 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@162427d [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] will not be managed by Spring
  129. 2017-12-19 10:48:17,113 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT m1.* FROM sale_mops m1 WHERE m1.sale_id = ? AND m1.is_opened = false AND ((m1.is_canceled = FALSE OR m1.returned_mop_id IS NOT NULL) OR EXISTS(SELECT m2.id FROM sale_mops m2 WHERE m2.sale_id = m1.sale_id AND m2.is_opened = false AND m2.returned_mop_id = m1.id)) ORDER BY id
  130. 2017-12-19 10:48:17,114 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  131. 2017-12-19 10:48:17,115 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  132. 2017-12-19 10:48:17,115 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@21fa28]
  133. 2017-12-19 10:48:17,115 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  134. 2017-12-19 10:48:17,117 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  135. 2017-12-19 10:48:17,117 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1d91af] was not registered for synchronization because synchronization is not active
  136. 2017-12-19 10:48:17,118 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  137. 2017-12-19 10:48:17,118 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT.
  138. 2017-12-19 10:48:17,119 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT has SUCCEEDED.
  139. 2017-12-19 10:48:17,119 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1f5172d [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] will not be managed by Spring
  140. 2017-12-19 10:48:17,120 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM sale_house_account_info WHERE sale_id = ? LIMIT 1
  141. 2017-12-19 10:48:17,120 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer)
  142. 2017-12-19 10:48:17,121 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  143. 2017-12-19 10:48:17,122 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1d91af]
  144. 2017-12-19 10:48:17,122 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  145. 2017-12-19 10:48:17,123 [JavaFX Application Thread] [DEBUG] [AbstractPlatformTransactionManager.getTransaction]:367 - Creating new transaction with name [com.petrosoftinc.pos.core.services.domain.TransactionLogService.isBookmark]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly; '',-java.lang.RuntimeException
  146. 2017-12-19 10:48:17,124 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT.
  147. 2017-12-19 10:48:17,124 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT has SUCCEEDED.
  148. 2017-12-19 10:48:17,125 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doBegin]:206 - Acquired Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1cc529a [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] for JDBC transaction
  149. 2017-12-19 10:48:17,125 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.prepareConnectionForTransaction]:153 - Setting JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1cc529a [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] read-only
  150. 2017-12-19 10:48:17,125 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doBegin]:223 - Switching JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1cc529a [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] to manual commit
  151. 2017-12-19 10:48:17,126 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  152. 2017-12-19 10:48:17,126 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:130 - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1cdc44]
  153. 2017-12-19 10:48:17,127 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1cc529a [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] will be managed by Spring
  154. 2017-12-19 10:48:17,127 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT is_bookmark FROM transaction_log WHERE sale_id = ? AND transaction_event = ?
  155. 2017-12-19 10:48:17,128 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2(Integer), SALE_CREATE(String)
  156. 2017-12-19 10:48:17,129 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 1
  157. 2017-12-19 10:48:17,130 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:188 - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1cdc44]
  158. 2017-12-19 10:48:17,130 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCommit]:286 - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1cdc44]
  159. 2017-12-19 10:48:17,131 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:312 - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1cdc44]
  160. 2017-12-19 10:48:17,131 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:317 - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1cdc44]
  161. 2017-12-19 10:48:17,131 [JavaFX Application Thread] [DEBUG] [AbstractPlatformTransactionManager.processCommit]:759 - Initiating transaction commit
  162. 2017-12-19 10:48:17,132 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doCommit]:269 - Committing JDBC transaction on Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1cc529a [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]]
  163. 2017-12-19 10:48:17,132 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.resetConnectionAfterTransaction]:222 - Resetting read-only flag of JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1cc529a [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]]
  164. 2017-12-19 10:48:17,133 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doCleanupAfterCompletion]:327 - Releasing JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1cc529a [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] after transaction
  165. 2017-12-19 10:48:17,133 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  166. 2017-12-19 10:48:17,134 [JavaFX Application Thread] [ERROR] [BasketService.retryPostponedTransaction]:1591 - Unexpected type for postpone transaction
  167. 2017-12-19 10:48:17,134 [JavaFX Application Thread] [DEBUG] [AbstractPlatformTransactionManager.getTransaction]:367 - Creating new transaction with name [com.petrosoftinc.pos.core.services.domain.TransactionLogService.create]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-com.petrosoftinc.pos.core.services.exception.ServiceException
  168. 2017-12-19 10:48:17,134 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT.
  169. 2017-12-19 10:48:17,135 [JavaFX Application Thread] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@37542] on CHECKOUT has SUCCEEDED.
  170. 2017-12-19 10:48:17,135 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doBegin]:206 - Acquired Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@52cca5 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] for JDBC transaction
  171. 2017-12-19 10:48:17,136 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doBegin]:223 - Switching JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@52cca5 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] to manual commit
  172. 2017-12-19 10:48:17,136 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  173. 2017-12-19 10:48:17,137 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.registerSessionHolder]:130 - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1b61581]
  174. 2017-12-19 10:48:17,137 [JavaFX Application Thread] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@52cca5 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] will be managed by Spring
  175. 2017-12-19 10:48:17,138 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: INSERT INTO transaction_log SET transaction_event = ?, entity_id = ?, initiator = ?, initiator_right = ?, data_set = ?, sale_id = ?, user_id = ?, is_bookmark = ?, has_screen_shot = ?, created_at = now(), processed_for_clean = ?
  176. 2017-12-19 10:48:17,139 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: RETRY_POSTPONED_TRANSACTION(String), null, 0(Integer), 0(Integer), (String), 2(Integer), 1(Integer), false(Boolean), 0(Integer), false(Boolean)
  177. 2017-12-19 10:48:17,140 [JavaFX Application Thread] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Updates: 1
  178. 2017-12-19 10:48:17,141 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils.closeSqlSession]:188 - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1b61581]
  179. 2017-12-19 10:48:17,141 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCommit]:286 - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1b61581]
  180. 2017-12-19 10:48:17,142 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:312 - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1b61581]
  181. 2017-12-19 10:48:17,142 [JavaFX Application Thread] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:317 - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1b61581] 2017-12-19 10:48:17,142 [JavaFX Application Thread] [DEBUG] [AbstractPlatformTransactionManager.processCommit]:759 - Initiating transaction commit
  182. 2017-12-19 10:48:17,143 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doCommit]:269 - Committing JDBC transaction on Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@52cca5 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]]
  183. 2017-12-19 10:48:17,143 [JavaFX Application Thread] [DEBUG] [DataSourceTransactionManager.doCleanupAfterCompletion]:327 - Releasing JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@52cca5 [wrapping: com.mysql.jdbc.JDBC4Connection@c2237]] after transaction
  184. 2017-12-19 10:48:17,144 [JavaFX Application Thread] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  185. 2017-12-19 10:48:18,591 [Thread-13 ] [DEBUG] [FusionTransportAPI.startHeartbeatThread]:390 - [POS -> FDC]
  186. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  187. <POSMessage MessageType="POS_Ready" ApplicationSender="POS001" WorkstationID="POS001" MessageID="93">
  188. <POSdata>
  189. <POSTimeStamp>2017-12-19T10:48:18</POSTimeStamp>
  190. </POSdata>
  191. </POSMessage>
  192. 2017-12-19 10:48:21,220 [Thread-12 ] [DEBUG] [FusionTransportAPI.parseResponse]:313 - [FDC -> POS]
  193. <?xml version="1.0" encoding="UTF-8" ?>
  194. <FDCMessage MessageType="FDC_Ready" ApplicationSender="POS001" WorkstationID="POS001" MessageID="67257" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  195. <FDCdata>
  196. <FDCTimeStamp>2017-12-19T10:48:22</FDCTimeStamp>
  197. </FDCdata>
  198. </FDCMessage>
  199. 2017-12-19 10:48:23,524 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.send_heart_bit
  200. 2017-12-19 10:48:23,525 [pool-5-thread-1 ] [DEBUG] [NetworkingService.sendHeartbeat]:251 - Send Heard bit started
  201. 2017-12-19 10:48:23,525 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting NETWORKING_ENABLED=0
  202. 2017-12-19 10:48:23,525 [pool-5-thread-1 ] [DEBUG] [NetworkingService.sendHeartbeat]:263 - Send Heard bit finished
  203. 2017-12-19 10:48:28,592 [Thread-13 ] [DEBUG] [FusionTransportAPI.startHeartbeatThread]:390 - [POS -> FDC]
  204. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  205. <POSMessage MessageType="POS_Ready" ApplicationSender="POS001" WorkstationID="POS001" MessageID="94">
  206. <POSdata>
  207. <POSTimeStamp>2017-12-19T10:48:28</POSTimeStamp>
  208. </POSdata>
  209. </POSMessage>
  210. 2017-12-19 10:48:31,959 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-AdminTaskTimer] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Checking for expired resources - Tue Dec 19 10:48:31 EST 2017 [com.mchange.v2.resourcepool.BasicResourcePool@88bfa1]
  211. 2017-12-19 10:48:31,959 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-AdminTaskTimer] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@88bfa1]
  212. 2017-12-19 10:48:31,959 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-AdminTaskTimer] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - EXPIRED idle resource: com.mchange.v2.c3p0.impl.NewPooledConnection@19b3c12 ---> idle_time: 224991; max_idle_time: 180000 [com.mchange.v2.resourcepool.BasicResourcePool@88bfa1]
  213. 2017-12-19 10:48:31,959 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-AdminTaskTimer] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Removing expired resource: com.mchange.v2.c3p0.impl.NewPooledConnection@19b3c12 [com.mchange.v2.resourcepool.BasicResourcePool@88bfa1]
  214. 2017-12-19 10:48:31,959 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-AdminTaskTimer] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@88bfa1]
  215. 2017-12-19 10:48:31,959 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-HelperThread-#2] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Preparing to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@19b3c12
  216. 2017-12-19 10:48:31,959 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-HelperThread-#2] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Preparing to destroy PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@19b3c12
  217. 2017-12-19 10:48:31,963 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-HelperThread-#2] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Successfully destroyed PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@19b3c12
  218. 2017-12-19 10:48:31,963 [C3P0PooledConnectionPoolManager[identityToken->z8kfsx9suwsrnv1eaw460|1e89ac8]-HelperThread-#2] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Successfully destroyed resource: com.mchange.v2.c3p0.impl.NewPooledConnection@19b3c12
  219. 2017-12-19 10:48:32,222 [Thread-12 ] [DEBUG] [FusionTransportAPI.parseResponse]:313 - [FDC -> POS]
  220. <?xml version="1.0" encoding="UTF-8" ?>
  221. <FDCMessage MessageType="FDC_Ready" ApplicationSender="POS001" WorkstationID="POS001" MessageID="67259" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  222. <FDCdata>
  223. <FDCTimeStamp>2017-12-19T10:48:33</FDCTimeStamp>
  224. </FDCdata>
  225. </FDCMessage>
  226. 2017-12-19 10:48:32,450 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting MODULE_VIDEO_JOURNAL=1
  227. 2017-12-19 10:48:32,450 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  228. 2017-12-19 10:48:32,451 [pool-4-thread-1 ] [INFO ] [VideoJournalService.checkAndSendIps]:405 - checkAndSendIps: video jounal or NAS mode disabled
  229. 2017-12-19 10:48:32,451 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting MODULE_VIDEO_JOURNAL=1
  230. 2017-12-19 10:48:32,451 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  231. 2017-12-19 10:48:32,451 [pool-4-thread-1 ] [INFO ] [VideoJournalService.checkNasConnection]:416 - check NAS connection: video jounal or NAS mode disabled
  232. 2017-12-19 10:48:32,507 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.nightly_reports_send
  233. 2017-12-19 10:48:32,507 [pool-5-thread-1 ] [INFO ] [NightlyReportService.sendReports]:187 - Start process for Nightly send files
  234. 2017-12-19 10:48:32,507 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting SALES_DATA_FTP_HOST=
  235. 2017-12-19 10:48:32,507 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting SALES_DATA_FTP_PORT=21
  236. 2017-12-19 10:48:32,508 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting SALES_DATA_FTP_USERNAME=
  237. 2017-12-19 10:48:32,508 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting SALES_DATA_FTP_PASSWORD=
  238. 2017-12-19 10:48:32,508 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting SALES_DATA_FTP_PATH=
  239. 2017-12-19 10:48:32,508 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  240. 2017-12-19 10:48:32,508 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1d68040] was not registered for synchronization because synchronization is not active
  241. 2017-12-19 10:48:32,508 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  242. 2017-12-19 10:48:32,509 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT.
  243. 2017-12-19 10:48:32,510 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT has SUCCEEDED.
  244. 2017-12-19 10:48:32,511 [pool-5-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@199b7f2 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] will not be managed by Spring
  245. 2017-12-19 10:48:32,511 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM nightly_report_history WHERE status = 2 ORDER BY id
  246. 2017-12-19 10:48:32,511 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters:
  247. 2017-12-19 10:48:32,512 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  248. 2017-12-19 10:48:32,512 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1d68040]
  249. 2017-12-19 10:48:32,513 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  250. 2017-12-19 10:48:32,513 [pool-5-thread-1 ] [INFO ] [NightlyReportService.sendReports]:233 - End process for Nightly send files
  251. 2017-12-19 10:48:32,520 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.update_drivers
  252. 2017-12-19 10:48:32,520 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  253. 2017-12-19 10:48:32,520 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b36df7] was not registered for synchronization because synchronization is not active
  254. 2017-12-19 10:48:32,520 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  255. 2017-12-19 10:48:32,521 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT.
  256. 2017-12-19 10:48:32,521 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT has SUCCEEDED.
  257. 2017-12-19 10:48:32,521 [pool-5-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@fa9b48 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] will not be managed by Spring
  258. 2017-12-19 10:48:32,522 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM role WHERE title = ? AND is_active = 1 LIMIT 1
  259. 2017-12-19 10:48:32,522 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: Courier(String)
  260. 2017-12-19 10:48:32,522 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  261. 2017-12-19 10:48:32,523 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b36df7]
  262. 2017-12-19 10:48:32,523 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  263. 2017-12-19 10:48:32,523 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.garbage_collect
  264. 2017-12-19 10:48:32,523 [pool-5-thread-1 ] [INFO ] [GarbageCollectorService.runGarbageCollect]:28 - Garbage collect start
  265. 2017-12-19 10:48:32,523 [pool-5-thread-1 ] [INFO ] [GarbageCollectorService.isLoginScreenActive]:57 - User is not on login screen
  266. 2017-12-19 10:48:32,524 [pool-5-thread-1 ] [INFO ] [GarbageCollectorService.runGarbageCollect]:32 - Garbage collect finish
  267. 2017-12-19 10:48:32,562 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting MODULE_VIDEO_JOURNAL=1
  268. 2017-12-19 10:48:32,563 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  269. 2017-12-19 10:48:32,563 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1c27610] was not registered for synchronization because synchronization is not active
  270. 2017-12-19 10:48:32,564 [pool-4-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  271. 2017-12-19 10:48:32,564 [pool-4-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT.
  272. 2017-12-19 10:48:32,564 [pool-4-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT has SUCCEEDED.
  273. 2017-12-19 10:48:32,565 [pool-4-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@17ac766 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] will not be managed by Spring
  274. 2017-12-19 10:48:32,565 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM transaction_log WHERE created_at < ? AND created_at >= DATE_ADD(?, INTERVAL -1 DAY) AND has_screen_shot = false ORDER BY created_at DESC LIMIT ?
  275. 2017-12-19 10:48:32,565 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2017-12-19 10:43:32.563(Timestamp), 2017-12-19 10:43:32.563(Timestamp), 300(Integer)
  276. 2017-12-19 10:48:32,567 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 2
  277. 2017-12-19 10:48:32,567 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1c27610]
  278. 2017-12-19 10:48:32,568 [pool-4-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  279. 2017-12-19 10:48:32,568 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:294 - createScreenshots: transactions without screenshot count <2>
  280. 2017-12-19 10:48:32,568 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:298 - createScreenshots: transaction id <224>, camera<CAM1>
  281. 2017-12-19 10:48:32,568 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM1=
  282. 2017-12-19 10:48:32,568 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM2=
  283. 2017-12-19 10:48:32,569 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM3=
  284. 2017-12-19 10:48:32,569 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM4=
  285. 2017-12-19 10:48:32,569 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  286. 2017-12-19 10:48:32,569 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_IP=
  287. 2017-12-19 10:48:32,569 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PORT=
  288. 2017-12-19 10:48:32,569 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_LOGIN=
  289. 2017-12-19 10:48:32,569 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PASSWORD=
  290. 2017-12-19 10:48:32,570 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  291. 2017-12-19 10:48:32,570 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:330 - createScreenshots: video file not found. Transaction date <Tue Dec 19 10:39:14 EST 2017>
  292. 2017-12-19 10:48:32,570 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:298 - createScreenshots: transaction id <224>, camera<CAM2>
  293. 2017-12-19 10:48:32,570 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM1=
  294. 2017-12-19 10:48:32,570 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM2=
  295. 2017-12-19 10:48:32,570 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM3=
  296. 2017-12-19 10:48:32,571 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM4=
  297. 2017-12-19 10:48:32,571 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  298. 2017-12-19 10:48:32,571 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_IP=
  299. 2017-12-19 10:48:32,571 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PORT=
  300. 2017-12-19 10:48:32,571 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_LOGIN=
  301. 2017-12-19 10:48:32,571 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PASSWORD=
  302. 2017-12-19 10:48:32,571 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  303. 2017-12-19 10:48:32,572 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:330 - createScreenshots: video file not found. Transaction date <Tue Dec 19 10:39:14 EST 2017>
  304. 2017-12-19 10:48:32,572 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:298 - createScreenshots: transaction id <224>, camera<CAM3>
  305. 2017-12-19 10:48:32,572 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM1=
  306. 2017-12-19 10:48:32,572 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM2=
  307. 2017-12-19 10:48:32,572 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM3=
  308. 2017-12-19 10:48:32,572 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM4=
  309. 2017-12-19 10:48:32,572 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  310. 2017-12-19 10:48:32,573 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_IP=
  311. 2017-12-19 10:48:32,573 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PORT=
  312. 2017-12-19 10:48:32,573 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_LOGIN=
  313. 2017-12-19 10:48:32,573 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PASSWORD=
  314. 2017-12-19 10:48:32,573 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  315. 2017-12-19 10:48:32,573 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:330 - createScreenshots: video file not found. Transaction date <Tue Dec 19 10:39:14 EST 2017>
  316. 2017-12-19 10:48:32,574 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:298 - createScreenshots: transaction id <224>, camera<CAM4>
  317. 2017-12-19 10:48:32,574 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM1=
  318. 2017-12-19 10:48:32,574 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM2=
  319. 2017-12-19 10:48:32,574 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM3=
  320. 2017-12-19 10:48:32,574 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM4=
  321. 2017-12-19 10:48:32,574 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  322. 2017-12-19 10:48:32,574 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_IP=
  323. 2017-12-19 10:48:32,575 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PORT=
  324. 2017-12-19 10:48:32,575 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_LOGIN=
  325. 2017-12-19 10:48:32,575 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PASSWORD=
  326. 2017-12-19 10:48:32,575 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  327. 2017-12-19 10:48:32,575 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:330 - createScreenshots: video file not found. Transaction date <Tue Dec 19 10:39:14 EST 2017>
  328. 2017-12-19 10:48:32,575 [pool-4-thread-1 ] [DEBUG] [AbstractPlatformTransactionManager.getTransaction]:367 - Creating new transaction with name [com.petrosoftinc.pos.core.services.domain.TransactionLogService.setHasScreenshotByTransactionId]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-com.petrosoftinc.pos.core.services.exception.ServiceException
  329. 2017-12-19 10:48:32,576 [pool-4-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT.
  330. 2017-12-19 10:48:32,576 [pool-4-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT has SUCCEEDED.
  331. 2017-12-19 10:48:32,576 [pool-4-thread-1 ] [DEBUG] [DataSourceTransactionManager.doBegin]:206 - Acquired Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1c56921 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] for JDBC transaction
  332. 2017-12-19 10:48:32,577 [pool-4-thread-1 ] [DEBUG] [DataSourceTransactionManager.doBegin]:223 - Switching JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1c56921 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] to manual commit
  333. 2017-12-19 10:48:32,577 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  334. 2017-12-19 10:48:32,578 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:130 - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5d43f9]
  335. 2017-12-19 10:48:32,578 [pool-4-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1c56921 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] will be managed by Spring
  336. 2017-12-19 10:48:32,578 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: UPDATE transaction_log SET has_screen_shot = true WHERE id = ?
  337. 2017-12-19 10:48:32,578 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 224(Integer)
  338. 2017-12-19 10:48:32,579 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Updates: 1
  339. 2017-12-19 10:48:32,580 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:188 - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5d43f9]
  340. 2017-12-19 10:48:32,580 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCommit]:286 - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5d43f9]
  341. 2017-12-19 10:48:32,580 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:312 - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5d43f9]
  342. 2017-12-19 10:48:32,580 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:317 - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5d43f9]
  343. 2017-12-19 10:48:32,580 [pool-4-thread-1 ] [DEBUG] [AbstractPlatformTransactionManager.processCommit]:759 - Initiating transaction commit
  344. 2017-12-19 10:48:32,581 [pool-4-thread-1 ] [DEBUG] [DataSourceTransactionManager.doCommit]:269 - Committing JDBC transaction on Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1c56921 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]]
  345. 2017-12-19 10:48:32,581 [pool-4-thread-1 ] [DEBUG] [DataSourceTransactionManager.doCleanupAfterCompletion]:327 - Releasing JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1c56921 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] after transaction
  346. 2017-12-19 10:48:32,581 [pool-4-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  347. 2017-12-19 10:48:32,583 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:298 - createScreenshots: transaction id <223>, camera<CAM1>
  348. 2017-12-19 10:48:32,583 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM1=
  349. 2017-12-19 10:48:32,583 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM2=
  350. 2017-12-19 10:48:32,583 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM3=
  351. 2017-12-19 10:48:32,583 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM4=
  352. 2017-12-19 10:48:32,583 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  353. 2017-12-19 10:48:32,584 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_IP=
  354. 2017-12-19 10:48:32,584 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PORT=
  355. 2017-12-19 10:48:32,584 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_LOGIN=
  356. 2017-12-19 10:48:32,584 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PASSWORD=
  357. 2017-12-19 10:48:32,584 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  358. 2017-12-19 10:48:32,585 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:330 - createScreenshots: video file not found. Transaction date <Tue Dec 19 10:39:11 EST 2017>
  359. 2017-12-19 10:48:32,585 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:298 - createScreenshots: transaction id <223>, camera<CAM2>
  360. 2017-12-19 10:48:32,585 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM1=
  361. 2017-12-19 10:48:32,585 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM2=
  362. 2017-12-19 10:48:32,585 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM3=
  363. 2017-12-19 10:48:32,585 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM4=
  364. 2017-12-19 10:48:32,586 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  365. 2017-12-19 10:48:32,586 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_IP=
  366. 2017-12-19 10:48:32,586 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PORT=
  367. 2017-12-19 10:48:32,586 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_LOGIN=
  368. 2017-12-19 10:48:32,586 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PASSWORD=
  369. 2017-12-19 10:48:32,586 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  370. 2017-12-19 10:48:32,587 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:330 - createScreenshots: video file not found. Transaction date <Tue Dec 19 10:39:11 EST 2017>
  371. 2017-12-19 10:48:32,587 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:298 - createScreenshots: transaction id <223>, camera<CAM3>
  372. 2017-12-19 10:48:32,587 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM1=
  373. 2017-12-19 10:48:32,587 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM2=
  374. 2017-12-19 10:48:32,587 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM3=
  375. 2017-12-19 10:48:32,587 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM4=
  376. 2017-12-19 10:48:32,587 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  377. 2017-12-19 10:48:32,588 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_IP=
  378. 2017-12-19 10:48:32,588 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PORT=
  379. 2017-12-19 10:48:32,588 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_LOGIN=
  380. 2017-12-19 10:48:32,588 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PASSWORD=
  381. 2017-12-19 10:48:32,588 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  382. 2017-12-19 10:48:32,588 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:330 - createScreenshots: video file not found. Transaction date <Tue Dec 19 10:39:11 EST 2017>
  383. 2017-12-19 10:48:32,588 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:298 - createScreenshots: transaction id <223>, camera<CAM4>
  384. 2017-12-19 10:48:32,589 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM1=
  385. 2017-12-19 10:48:32,589 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM2=
  386. 2017-12-19 10:48:32,589 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM3=
  387. 2017-12-19 10:48:32,589 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting CAM4=
  388. 2017-12-19 10:48:32,589 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  389. 2017-12-19 10:48:32,589 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_IP=
  390. 2017-12-19 10:48:32,589 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PORT=
  391. 2017-12-19 10:48:32,589 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_LOGIN=
  392. 2017-12-19 10:48:32,590 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_NAS_PASSWORD=
  393. 2017-12-19 10:48:32,590 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting VIDEO_JOURNAL_STORAGE=1
  394. 2017-12-19 10:48:32,590 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:330 - createScreenshots: video file not found. Transaction date <Tue Dec 19 10:39:11 EST 2017>
  395. 2017-12-19 10:48:32,590 [pool-4-thread-1 ] [DEBUG] [AbstractPlatformTransactionManager.getTransaction]:367 - Creating new transaction with name [com.petrosoftinc.pos.core.services.domain.TransactionLogService.setHasScreenshotByTransactionId]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-com.petrosoftinc.pos.core.services.exception.ServiceException
  396. 2017-12-19 10:48:32,590 [pool-4-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT.
  397. 2017-12-19 10:48:32,591 [pool-4-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT has SUCCEEDED.
  398. 2017-12-19 10:48:32,591 [pool-4-thread-1 ] [DEBUG] [DataSourceTransactionManager.doBegin]:206 - Acquired Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@fd0236 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] for JDBC transaction
  399. 2017-12-19 10:48:32,591 [pool-4-thread-1 ] [DEBUG] [DataSourceTransactionManager.doBegin]:223 - Switching JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@fd0236 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] to manual commit
  400. 2017-12-19 10:48:32,591 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  401. 2017-12-19 10:48:32,592 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:130 - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1c91964]
  402. 2017-12-19 10:48:32,592 [pool-4-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@fd0236 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] will be managed by Spring
  403. 2017-12-19 10:48:32,592 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: UPDATE transaction_log SET has_screen_shot = true WHERE id = ?
  404. 2017-12-19 10:48:32,593 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 223(Integer)
  405. 2017-12-19 10:48:32,593 [pool-4-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Updates: 1
  406. 2017-12-19 10:48:32,593 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:188 - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1c91964]
  407. 2017-12-19 10:48:32,594 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCommit]:286 - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1c91964]
  408. 2017-12-19 10:48:32,594 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:312 - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1c91964]
  409. 2017-12-19 10:48:32,594 [pool-4-thread-1 ] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:317 - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1c91964] 2017-12-19 10:48:32,594 [pool-4-thread-1 ] [DEBUG] [AbstractPlatformTransactionManager.processCommit]:759 - Initiating transaction commit
  410. 2017-12-19 10:48:32,594 [pool-4-thread-1 ] [DEBUG] [DataSourceTransactionManager.doCommit]:269 - Committing JDBC transaction on Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@fd0236 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]]
  411. 2017-12-19 10:48:32,595 [pool-4-thread-1 ] [DEBUG] [DataSourceTransactionManager.doCleanupAfterCompletion]:327 - Releasing JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@fd0236 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] after transaction
  412. 2017-12-19 10:48:32,595 [pool-4-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  413. 2017-12-19 10:48:33,519 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.check_access_code
  414. 2017-12-19 10:48:33,520 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting SUPPORT_STATUS=1
  415. 2017-12-19 10:48:33,520 [pool-5-thread-1 ] [INFO ] [HttpClientService.getRequest]:116 - Send request to CSO: https://edi.cstoreoffice.com/app.php/api/accesses/48426F341661280E69B0/code
  416. 2017-12-19 10:48:33,522 [pool-5-thread-1 ] [DEBUG] [RequestAddCookies.process]:122 - CookieSpec selected: default
  417. 2017-12-19 10:48:33,522 [pool-5-thread-1 ] [DEBUG] [RequestAuthCache.process]:76 - Auth cache not set in the context
  418. 2017-12-19 10:48:33,522 [pool-5-thread-1 ] [DEBUG] [PoolingHttpClientConnectionManager.requestConnection]:249 - Connection request: [route: {s}->https://edi.cstoreoffice.com:443][total kept alive: 0; route allocated: 0 of 2; total allocated: 0 of 20]
  419. 2017-12-19 10:48:33,523 [pool-5-thread-1 ] [DEBUG] [PoolingHttpClientConnectionManager.leaseConnection]:282 - Connection leased: [id: 44][route: {s}->https://edi.cstoreoffice.com:443][total kept alive: 0; route allocated: 1 of 2; total allocated: 1 of 20]
  420. 2017-12-19 10:48:33,523 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:234 - Opening connection {s}->https://edi.cstoreoffice.com:443
  421. 2017-12-19 10:48:33,533 [pool-5-thread-1 ] [DEBUG] [DefaultHttpClientConnectionOperator.connect]:131 - Connecting to edi.cstoreoffice.com/209.166.146.103:443
  422. 2017-12-19 10:48:33,533 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.connectSocket]:335 - Connecting socket to edi.cstoreoffice.com/209.166.146.103:443 with timeout 30000
  423. 2017-12-19 10:48:33,547 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.createLayeredSocket]:388 - Enabled protocols: [TLSv1, TLSv1.1, TLSv1.2]
  424. 2017-12-19 10:48:33,548 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.createLayeredSocket]:389 - Enabled cipher suites:[TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256, TLS_RSA_WITH_AES_128_CBC_SHA256, TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256, TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256, TLS_DHE_RSA_WITH_AES_128_CBC_SHA256, TLS_DHE_DSS_WITH_AES_128_CBC_SHA256, TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA, TLS_RSA_WITH_AES_128_CBC_SHA, TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA, TLS_ECDH_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_DSS_WITH_AES_128_CBC_SHA, TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256, TLS_RSA_WITH_AES_128_GCM_SHA256, TLS_ECDH_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDH_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_DSS_WITH_AES_128_GCM_SHA256, TLS_ECDHE_ECDSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDH_ECDSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDH_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA, TLS_EMPTY_RENEGOTIATION_INFO_SCSV]
  425. 2017-12-19 10:48:33,548 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.createLayeredSocket]:393 - Starting handshake
  426. 2017-12-19 10:48:33,611 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:423 - Secure session established
  427. 2017-12-19 10:48:33,612 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:424 - negotiated protocol: TLSv1
  428. 2017-12-19 10:48:33,681 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:425 - negotiated cipher suite: TLS_RSA_WITH_AES_128_CBC_SHA
  429. 2017-12-19 10:48:33,681 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:433 - peer principal: CN=*.cstoreoffice.com, OU=PremiumSSL Wildcard, O="Petrosoft, Inc", STREET=2025 GREENTREE RD, L=Warminster, ST=PA, OID.2.5.4.17=15220, C=US
  430. 2017-12-19 10:48:33,682 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:442 - peer alternative names: [*.cstoreoffice.com, cstoreoffice.com]
  431. 2017-12-19 10:48:33,683 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:446 - issuer principal: CN=COMODO RSA Organization Validation Secure Server CA, O=COMODO CA Limited, L=Salford, ST=Greater Manchester, C=GB
  432. 2017-12-19 10:48:33,683 [pool-5-thread-1 ] [DEBUG] [DefaultHttpClientConnectionOperator.connect]:138 - Connection established 192.168.26.135:35161<->209.166.146.103:443
  433. 2017-12-19 10:48:33,683 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:255 - Executing request GET /app.php/api/accesses/48426F341661280E69B0/code HTTP/1.1
  434. 2017-12-19 10:48:33,683 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:260 - Target auth state: UNCHALLENGED
  435. 2017-12-19 10:48:33,684 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:266 - Proxy auth state: UNCHALLENGED
  436. 2017-12-19 10:48:33,684 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:124 - http-outgoing-44 >> GET /app.php/api/accesses/48426F341661280E69B0/code HTTP/1.1
  437. 2017-12-19 10:48:33,684 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:127 - http-outgoing-44 >> Host: edi.cstoreoffice.com
  438. 2017-12-19 10:48:33,684 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:127 - http-outgoing-44 >> Connection: Keep-Alive
  439. 2017-12-19 10:48:33,684 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:127 - http-outgoing-44 >> User-Agent: Apache-HttpClient/4.4.1 (Java/1.8.0_66)
  440. 2017-12-19 10:48:33,685 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:127 - http-outgoing-44 >> Accept-Encoding: gzip,deflate
  441. 2017-12-19 10:48:33,685 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 >> "GET /app.php/api/accesses/48426F341661280E69B0/code HTTP/1.1[\r][\n]"
  442. 2017-12-19 10:48:33,685 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 >> "Host: edi.cstoreoffice.com[\r][\n]"
  443. 2017-12-19 10:48:33,685 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 >> "Connection: Keep-Alive[\r][\n]"
  444. 2017-12-19 10:48:33,685 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 >> "User-Agent: Apache-HttpClient/4.4.1 (Java/1.8.0_66)[\r][\n]"
  445. 2017-12-19 10:48:33,685 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 >> "Accept-Encoding: gzip,deflate[\r][\n]"
  446. 2017-12-19 10:48:33,686 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 >> "[\r][\n]"
  447. 2017-12-19 10:48:37,443 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "HTTP/1.1 200 OK[\r][\n]"
  448. 2017-12-19 10:48:37,443 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Server: nginx/1.8.1[\r][\n]"
  449. 2017-12-19 10:48:37,443 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Content-Type: application/json[\r][\n]"
  450. 2017-12-19 10:48:37,443 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Transfer-Encoding: chunked[\r][\n]"
  451. 2017-12-19 10:48:37,444 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Connection: keep-alive[\r][\n]"
  452. 2017-12-19 10:48:37,444 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Vary: Accept-Encoding[\r][\n]"
  453. 2017-12-19 10:48:37,444 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "X-Powered-By: PHP/5.3.29-1~dotdeb.0[\r][\n]"
  454. 2017-12-19 10:48:37,444 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Set-Cookie: PHPSESSID=riq3likudvb2dr8n73dt4tis84; path=/; domain=.cstoreoffice.com[\r][\n]"
  455. 2017-12-19 10:48:37,444 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Set-Cookie: PHPSESSID=0a192182a60d5432ae57181a1bcbc419; path=/; domain=.cstoreoffice.com[\r][\n]"
  456. 2017-12-19 10:48:37,445 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Expires: Thu, 19 Nov 1981 08:52:00 GMT[\r][\n]"
  457. 2017-12-19 10:48:37,445 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0[\r][\n]"
  458. 2017-12-19 10:48:37,445 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Pragma: no-cache[\r][\n]"
  459. 2017-12-19 10:48:37,445 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Cache-Control: no-cache[\r][\n]"
  460. 2017-12-19 10:48:37,445 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Date: Tue, 19 Dec 2017 15:48:38 GMT[\r][\n]"
  461. 2017-12-19 10:48:37,445 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Allow: GET[\r][\n]"
  462. 2017-12-19 10:48:37,446 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Set-Cookie: _currency=%7B%22sign%22%3A%22%24%22%2C%22name%22%3A%22US+Dollar%22%2C%22position%22%3A%22prepend%22%2C%22brackets%22%3Atrue%2C%22full%22%3A%22dollar%22%2C%22short%22%3A%22doll%22%2C%22simple%22%3A%22%24%22%2C%22ISOCode%22%3A%22USD%22%7D; path=/; domain=.cstoreoffice.com[\r][\n]"
  463. 2017-12-19 10:48:37,446 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "Content-Encoding: gzip[\r][\n]"
  464. 2017-12-19 10:48:37,446 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "[\r][\n]"
  465. 2017-12-19 10:48:37,446 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "42[\r][\n]"
  466. 2017-12-19 10:48:37,446 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "[0x1f][0x8b][0x8][0x0][0x0][0x0][0x0][0x0][0x0][0x3][0xab]VJI,IT[0xb2]RR[0xd2]Q*.I,)-V[0xb2]*)*M[0x5][0xf2]J[0x93][0x93]S[0x8b][0xe1][0xdc]\ ;1=U[0xc9]*-1[0xa7]8[0xb5][0x16][0x0][0x9c][0x1][0xa9][0x97]8[0x0][0x0][0x0][\r][\n]"
  467. 2017-12-19 10:48:37,446 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "0[\r][\n]"
  468. 2017-12-19 10:48:37,447 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-44 << "[\r][\n]"
  469. 2017-12-19 10:48:37,447 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:113 - http-outgoing-44 << HTTP/1.1 200 OK
  470. 2017-12-19 10:48:37,447 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Server: nginx/1.8.1
  471. 2017-12-19 10:48:37,447 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Content-Type: application/json
  472. 2017-12-19 10:48:37,447 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Transfer-Encoding: chunked
  473. 2017-12-19 10:48:37,447 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Connection: keep-alive
  474. 2017-12-19 10:48:37,448 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Vary: Accept-Encoding
  475. 2017-12-19 10:48:37,448 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << X-Powered-By: PHP/5.3.29-1~dotdeb.0
  476. 2017-12-19 10:48:37,448 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Set-Cookie: PHPSESSID=riq3likudvb2dr8n73dt4tis84; path=/; domain=.cstoreoffice.com
  477. 2017-12-19 10:48:37,448 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Set-Cookie: PHPSESSID=0a192182a60d5432ae57181a1bcbc419; path=/; domain=.cstoreoffice.com
  478. 2017-12-19 10:48:37,448 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Expires: Thu, 19 Nov 1981 08:52:00 GMT
  479. 2017-12-19 10:48:37,448 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
  480. 2017-12-19 10:48:37,449 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Pragma: no-cache
  481. 2017-12-19 10:48:37,449 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Cache-Control: no-cache
  482. 2017-12-19 10:48:37,449 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Date: Tue, 19 Dec 2017 15:48:38 GMT
  483. 2017-12-19 10:48:37,449 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Allow: GET
  484. 2017-12-19 10:48:37,449 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Set-Cookie: _currency=%7B%22sign%22%3A%22%24%22%2C%22name%22%3A%22US+Dollar%22%2C%22position%22%3A%22prepend%22%2C%22brackets%22%3Atrue%2C%22full%22%3A%22dollar%22%2C%22short%22%3A%22doll%22%2C%22simple%22%3A%22%24%22%2C%22ISOCode%22%3A%22USD%22%7D; path=/; domain=.cstoreoffice.com
  485. 2017-12-19 10:48:37,449 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-44 << Content-Encoding: gzip
  486. 2017-12-19 10:48:37,449 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:284 - Connection can be kept alive indefinitely
  487. 2017-12-19 10:48:37,450 [pool-5-thread-1 ] [DEBUG] [ResponseProcessCookies.processCookies]:118 - Cookie accepted [PHPSESSID="riq3likudvb2dr8n73dt4tis84", version:0, domain:cstoreoffice.com, path:/, expiry:null]
  488. 2017-12-19 10:48:37,450 [pool-5-thread-1 ] [DEBUG] [ResponseProcessCookies.processCookies]:118 - Cookie accepted [PHPSESSID="0a192182a60d5432ae57181a1bcbc419", version:0, domain:cstoreoffice.com, path:/, expiry:null]
  489. 2017-12-19 10:48:37,450 [pool-5-thread-1 ] [DEBUG] [ResponseProcessCookies.processCookies]:118 - Cookie accepted [_currency="%7B%22sign%22%3A%22%24%22%2C%22name%22%3A%22US+Dollar%22%2C%22position%22%3A%22prepend%22%2C%22brack...", version:0, domain:cstoreoffice.com, path:/, expiry:null]
  490. 2017-12-19 10:48:37,451 [pool-5-thread-1 ] [DEBUG] [PoolingHttpClientConnectionManager.releaseConnection]:314 - Connection [id: 44][route: {s}->https://edi.cstoreoffice.com:443] can be kept alive indefinitely
  491. 2017-12-19 10:48:37,451 [pool-5-thread-1 ] [DEBUG] [PoolingHttpClientConnectionManager.releaseConnection]:320 - Connection released: [id: 44][route: {s}->https://edi.cstoreoffice.com:443][total kept alive: 1; route allocated: 1 of 2; total allocated: 1 of 20]
  492. 2017-12-19 10:48:37,451 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting SUPPORT_CODE=9553
  493. 2017-12-19 10:48:37,452 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.check_heart_bit
  494. 2017-12-19 10:48:37,452 [pool-5-thread-1 ] [DEBUG] [ScheduledTasks.checkHeartBit]:337 - check_heart_bit started
  495. 2017-12-19 10:48:37,452 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting NETWORKING_ENABLED=0
  496. 2017-12-19 10:48:37,452 [pool-5-thread-1 ] [DEBUG] [ScheduledTasks.checkHeartBit]:339 - check_heart_bit finished
  497. 2017-12-19 10:48:37,452 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.send_heart_bit
  498. 2017-12-19 10:48:37,452 [pool-5-thread-1 ] [DEBUG] [NetworkingService.sendHeartbeat]:251 - Send Heard bit started
  499. 2017-12-19 10:48:37,452 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting NETWORKING_ENABLED=0
  500. 2017-12-19 10:48:37,452 [pool-5-thread-1 ] [DEBUG] [NetworkingService.sendHeartbeat]:263 - Send Heard bit finished
  501. 2017-12-19 10:48:37,792 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.sync_outdoor_transactions
  502. 2017-12-19 10:48:37,793 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting MODULE_FUEL=1
  503. 2017-12-19 10:48:37,793 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting HARDWARE_FORECOURT_CONTROLLER=1
  504. 2017-12-19 10:48:37,793 [pool-5-thread-1 ] [DEBUG] [OutdoorTransactionService.syncOutdoorTransactions]:63 - Outdoor transactions sync started
  505. 2017-12-19 10:48:37,793 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting FUEL_LAST_OUTDOOR_TRANSACTIONS_SYNC_DATE=2017-12-19 10:47:37
  506. 2017-12-19 10:48:37,794 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting FUSION_IP=192.168.26.145
  507. 2017-12-19 10:48:37,794 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting FUSION_TRANSACTION_SERVICE_PASSPHRASE=dresserwayne
  508. 2017-12-19 10:48:37,794 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  509. 2017-12-19 10:48:37,794 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@a62fec] was not registered for synchronization because synchronization is not active
  510. 2017-12-19 10:48:37,794 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  511. 2017-12-19 10:48:37,795 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT.
  512. 2017-12-19 10:48:37,795 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT has SUCCEEDED.
  513. 2017-12-19 10:48:37,795 [pool-5-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@8b3323 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] will not be managed by Spring
  514. 2017-12-19 10:48:37,795 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM report_periods WHERE started_at <= ? AND period_type_id = ? ORDER BY started_at DESC LIMIT 1
  515. 2017-12-19 10:48:37,796 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2017-12-19 10:48:37.794(Timestamp), 4(Integer)
  516. 2017-12-19 10:48:37,801 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ====> Preparing: SELECT * FROM pos_users WHERE id = ?
  517. 2017-12-19 10:48:37,801 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ====> Parameters: 1(Integer)
  518. 2017-12-19 10:48:37,804 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ======> Preparing: SELECT * FROM user_permission WHERE user_id = ? ORDER BY id
  519. 2017-12-19 10:48:37,805 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ======> Parameters: 1(Integer)
  520. 2017-12-19 10:48:37,806 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <====== Total: 21
  521. 2017-12-19 10:48:37,807 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <==== Total: 1
  522. 2017-12-19 10:48:37,807 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 1
  523. 2017-12-19 10:48:37,808 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@a62fec]
  524. 2017-12-19 10:48:37,808 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  525. 2017-12-19 10:48:37,808 [pool-5-thread-1 ] [INFO ] [ForecourtTransactionService.httpRequest]:122 - Send request to Transaction Service: https://192.168.26.145/fts/get_data/xmlquery/?auth=79e9070a9e17c55694ab216cd8cd1813&begindatetime=2017-12-19%2010:47:37&enddatetime=2017-12-19%2010:48:37&overallresult=Success
  526. 2017-12-19 10:48:37,811 [pool-5-thread-1 ] [DEBUG] [RequestAddCookies.process]:122 - CookieSpec selected: default
  527. 2017-12-19 10:48:37,812 [pool-5-thread-1 ] [DEBUG] [RequestAuthCache.process]:76 - Auth cache not set in the context
  528. 2017-12-19 10:48:37,812 [pool-5-thread-1 ] [DEBUG] [PoolingHttpClientConnectionManager.requestConnection]:249 - Connection request: [route: {s}->https://192.168.26.145:443][total kept alive: 0; route allocated: 0 of 2; total allocated: 0 of 20]
  529. 2017-12-19 10:48:37,813 [pool-5-thread-1 ] [DEBUG] [PoolingHttpClientConnectionManager.leaseConnection]:282 - Connection leased: [id: 45][route: {s}->https://192.168.26.145:443][total kept alive: 0; route allocated: 1 of 2; total allocated: 1 of 20]
  530. 2017-12-19 10:48:37,813 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:234 - Opening connection {s}->https://192.168.26.145:443
  531. 2017-12-19 10:48:37,813 [pool-5-thread-1 ] [DEBUG] [DefaultHttpClientConnectionOperator.connect]:131 - Connecting to /192.168.26.145:443
  532. 2017-12-19 10:48:37,814 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.connectSocket]:335 - Connecting socket to /192.168.26.145:443 with timeout 10000
  533. 2017-12-19 10:48:37,815 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.createLayeredSocket]:388 - Enabled protocols: [TLSv1, TLSv1.1, TLSv1.2]
  534. 2017-12-19 10:48:37,816 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.createLayeredSocket]:389 - Enabled cipher suites:[TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256, TLS_RSA_WITH_AES_128_CBC_SHA256, TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA256, TLS_ECDH_RSA_WITH_AES_128_CBC_SHA256, TLS_DHE_RSA_WITH_AES_128_CBC_SHA256, TLS_DHE_DSS_WITH_AES_128_CBC_SHA256, TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA, TLS_RSA_WITH_AES_128_CBC_SHA, TLS_ECDH_ECDSA_WITH_AES_128_CBC_SHA, TLS_ECDH_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_RSA_WITH_AES_128_CBC_SHA, TLS_DHE_DSS_WITH_AES_128_CBC_SHA, TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256, TLS_RSA_WITH_AES_128_GCM_SHA256, TLS_ECDH_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDH_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_DSS_WITH_AES_128_GCM_SHA256, TLS_ECDHE_ECDSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDH_ECDSA_WITH_3DES_EDE_CBC_SHA, TLS_ECDH_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA, SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA, TLS_EMPTY_RENEGOTIATION_INFO_SCSV]
  535. 2017-12-19 10:48:37,816 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.createLayeredSocket]:393 - Starting handshake
  536. 2017-12-19 10:48:37,890 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:423 - Secure session established
  537. 2017-12-19 10:48:37,890 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:424 - negotiated protocol: TLSv1
  538. 2017-12-19 10:48:37,890 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:425 - negotiated cipher suite: TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA
  539. 2017-12-19 10:48:37,890 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:433 - peer principal: CN=localhost, OU=Wayne, O=GE, L=AUSTIN, ST=TX, C=US
  540. 2017-12-19 10:48:37,891 [pool-5-thread-1 ] [DEBUG] [SSLConnectionSocketFactory.verifyHostname]:446 - issuer principal: CN=localhost, OU=Wayne, O=GE, L=AUSTIN, ST=TX, C=US
  541. 2017-12-19 10:48:37,891 [pool-5-thread-1 ] [DEBUG] [DefaultHttpClientConnectionOperator.connect]:138 - Connection established 192.168.26.135:34790<->192.168.26.145:443
  542. 2017-12-19 10:48:37,891 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:255 - Executing request GET /fts/get_data/xmlquery/?auth=79e9070a9e17c55694ab216cd8cd1813&begindatetime=2017-12-19%2010:47:37&enddatetime=2017-12-19%2010:48:37&overallresult=Success HTTP/1.1
  543. 2017-12-19 10:48:37,891 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:260 - Target auth state: UNCHALLENGED
  544. 2017-12-19 10:48:37,891 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:266 - Proxy auth state: UNCHALLENGED
  545. 2017-12-19 10:48:37,892 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:124 - http-outgoing-45 >> GET /fts/get_data/xmlquery/?auth=79e9070a9e17c55694ab216cd8cd1813&begindatetime=2017-12-19%2010:47:37&enddatetime=2017-12-19%2010:48:37&overallresult=Success HTTP/1.1
  546. 2017-12-19 10:48:37,892 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:127 - http-outgoing-45 >> Host: 192.168.26.145
  547. 2017-12-19 10:48:37,892 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:127 - http-outgoing-45 >> Connection: Keep-Alive
  548. 2017-12-19 10:48:37,892 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:127 - http-outgoing-45 >> User-Agent: Apache-HttpClient/4.4.1 (Java/1.8.0_66)
  549. 2017-12-19 10:48:37,892 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onRequestSubmitted]:127 - http-outgoing-45 >> Accept-Encoding: gzip,deflate
  550. 2017-12-19 10:48:37,892 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 >> "GET /fts/get_data/xmlquery/?auth=79e9070a9e17c55694ab216cd8cd1813&begindatetime=2017-12-19%2010:47:37&enddatetime=2017-12-19%2010:48:37&overallresult=Success HTTP/1.1[\r][\n]"
  551. 2017-12-19 10:48:37,893 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 >> "Host: 192.168.26.145[\r][\n]"
  552. 2017-12-19 10:48:37,893 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 >> "Connection: Keep-Alive[\r][\n]"
  553. 2017-12-19 10:48:37,893 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 >> "User-Agent: Apache-HttpClient/4.4.1 (Java/1.8.0_66)[\r][\n]"
  554. 2017-12-19 10:48:37,893 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 >> "Accept-Encoding: gzip,deflate[\r][\n]"
  555. 2017-12-19 10:48:37,893 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 >> "[\r][\n]"
  556. 2017-12-19 10:48:38,182 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "HTTP/1.1 200 OK[\r][\n]"
  557. 2017-12-19 10:48:38,182 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "Date: Tue, 19 Dec 2017 15:48:38 GMT[\r][\n]"
  558. 2017-12-19 10:48:38,183 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "Server: Apache/2.4.18 (Win32) OpenSSL/1.0.2h mod_wsgi/4.4.12 Python/2.7.10[\r][\n]"
  559. 2017-12-19 10:48:38,183 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "Keep-Alive: timeout=15, max=100[\r][\n]"
  560. 2017-12-19 10:48:38,183 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "Connection: Keep-Alive[\r][\n]"
  561. 2017-12-19 10:48:38,183 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "Transfer-Encoding: chunked[\r][\n]"
  562. 2017-12-19 10:48:38,183 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "Content-Type: text/xml[\r][\n]"
  563. 2017-12-19 10:48:38,184 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "[\r][\n]"
  564. 2017-12-19 10:48:38,184 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:113 - http-outgoing-45 << HTTP/1.1 200 OK
  565. 2017-12-19 10:48:38,184 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-45 << Date: Tue, 19 Dec 2017 15:48:38 GMT
  566. 2017-12-19 10:48:38,184 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-45 << Server: Apache/2.4.18 (Win32) OpenSSL/1.0.2h mod_wsgi/4.4.12 Python/2.7.10
  567. 2017-12-19 10:48:38,184 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-45 << Keep-Alive: timeout=15, max=100
  568. 2017-12-19 10:48:38,184 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-45 << Connection: Keep-Alive
  569. 2017-12-19 10:48:38,185 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-45 << Transfer-Encoding: chunked
  570. 2017-12-19 10:48:38,185 [pool-5-thread-1 ] [DEBUG] [LoggingManagedHttpClientConnection.onResponseReceived]:116 - http-outgoing-45 << Content-Type: text/xml
  571. 2017-12-19 10:48:38,185 [pool-5-thread-1 ] [DEBUG] [MainClientExec.execute]:284 - Connection can be kept alive for 15000 MILLISECONDS
  572. 2017-12-19 10:48:38,185 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "ea[\r][\n]"
  573. 2017-12-19 10:48:38,186 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "<?xml version="1.0" encoding="UTF-8"?>[\r][\n]"
  574. 2017-12-19 10:48:38,186 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "<TransactionServicesRecords xmlns:eps="http://www.nrf-arts.org/IXRetail/namespace" [\r][\n]"
  575. 2017-12-19 10:48:38,186 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << " Result="Success" NumberRecordsFound="0" NumberRecordsReturned="0">[\r][\n]"
  576. 2017-12-19 10:48:38,186 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << " [\r][\n]"
  577. 2017-12-19 10:48:38,187 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "[\r][\n]"
  578. 2017-12-19 10:48:38,188 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:86 - http-outgoing-45 << "</TransactionServicesRecords>"
  579. 2017-12-19 10:48:38,188 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "[\r][\n]"
  580. 2017-12-19 10:48:38,188 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "0[\r][\n]"
  581. 2017-12-19 10:48:38,188 [pool-5-thread-1 ] [DEBUG] [Wire.wire]:72 - http-outgoing-45 << "[\r][\n]"
  582. 2017-12-19 10:48:38,189 [pool-5-thread-1 ] [DEBUG] [PoolingHttpClientConnectionManager.releaseConnection]:314 - Connection [id: 45][route: {s}->https://192.168.26.145:443] can be kept alive for 15.0 seconds
  583. 2017-12-19 10:48:38,189 [pool-5-thread-1 ] [DEBUG] [PoolingHttpClientConnectionManager.releaseConnection]:320 - Connection released: [id: 45][route: {s}->https://192.168.26.145:443][total kept alive: 1; route allocated: 1 of 2; total allocated: 1 of 20]
  584. 2017-12-19 10:48:38,271 [pool-5-thread-1 ] [DEBUG] [OutdoorTransactionService.syncOutdoorTransactions]:79 - Received <0> outdoor transactions from <Tue Dec 19 10:47:37 EST 2017> to <Tue Dec 19 10:48:37 EST 2017>
  585. 2017-12-19 10:48:38,271 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:61 - Read setting FUEL_LAST_OUTDOOR_TRANSACTIONS_SYNC_DATE=2017-12-19 10:47:37
  586. 2017-12-19 10:48:38,272 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  587. 2017-12-19 10:48:38,272 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5732c8] was not registered for synchronization because synchronization is not active
  588. 2017-12-19 10:48:38,272 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  589. 2017-12-19 10:48:38,272 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT.
  590. 2017-12-19 10:48:38,273 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT has SUCCEEDED.
  591. 2017-12-19 10:48:38,273 [pool-5-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1d6c80f [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] will not be managed by Spring
  592. 2017-12-19 10:48:38,273 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM setting WHERE setting_key = ?
  593. 2017-12-19 10:48:38,274 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: FUEL_LAST_OUTDOOR_TRANSACTIONS_SYNC_DATE(String)
  594. 2017-12-19 10:48:38,274 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 1
  595. 2017-12-19 10:48:38,275 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5732c8]
  596. 2017-12-19 10:48:38,275 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  597. 2017-12-19 10:48:38,275 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  598. 2017-12-19 10:48:38,275 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@bfa08c] was not registered for synchronization because synchronization is not active
  599. 2017-12-19 10:48:38,276 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  600. 2017-12-19 10:48:38,276 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT.
  601. 2017-12-19 10:48:38,276 [pool-5-thread-1 ] [DEBUG] [Slf4jMLog$Slf4jMLogger$DebugLogger.log]:204 - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@12454d9] on CHECKOUT has SUCCEEDED.
  602. 2017-12-19 10:48:38,276 [pool-5-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@12eb7a0 [wrapping: com.mysql.jdbc.JDBC4Connection@18ea9ec]] will not be managed by Spring
  603. 2017-12-19 10:48:38,277 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: UPDATE setting SET setting_value = ?, setting_key = ? WHERE id = ?
  604. 2017-12-19 10:48:38,277 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 2017-12-19 10:48:37(String), FUEL_LAST_OUTDOOR_TRANSACTIONS_SYNC_DATE(String), 143(Integer)
  605. 2017-12-19 10:48:38,277 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Updates: 1
  606. 2017-12-19 10:48:38,278 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@bfa08c]
  607. 2017-12-19 10:48:38,278 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  608. 2017-12-19 10:48:38,278 [pool-5-thread-1 ] [INFO ] [SettingService.setSetting]:107 - Updated setting FUEL_LAST_OUTDOOR_TRANSACTIONS_SYNC_DATE=2017-12-19 10:48:37
  609. 2017-12-19 10:48:38,278 [pool-5-thread-1 ] [DEBUG] [OutdoorTransactionService.updateSyncDate]:92 - Set last sync date <Tue Dec 19 10:48:37 EST 2017>
  610. 2017-12-19 10:48:38,278 [pool-5-thread-1 ] [DEBUG] [OutdoorTransactionService.syncOutdoorTransactions]:87 - Outdoor transactions sync finished
  611. 2017-12-19 10:48:38,593 [Thread-13 ] [DEBUG] [FusionTransportAPI.startHeartbeatThread]:390 - [POS -> FDC]
  612. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  613. <POSMessage MessageType="POS_Ready" ApplicationSender="POS001" WorkstationID="POS001" MessageID="95">
  614. <POSdata>
  615. <POSTimeStamp>2017-12-19T10:48:38</POSTimeStamp>
  616. </POSdata>
  617. </POSMessage>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!