API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 10th, 2017
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 28.18 KB | None | 0 0
raw download clone embed print report
  1. 2017-03-10 07:14:22,230 [pool-5-thread-1 ] [DEBUG] [SQLErrorCodesFactory.getErrorCodes]:175 - SQL error codes for 'MySQL' found
  2. 2017-03-10 07:14:22,231 [pool-5-thread-1 ] [DEBUG] [SQLErrorCodeSQLExceptionTranslator.logTranslation]:397 - Translating SQLException with SQL state '41000', error code '1205', message [Lock wait timeout exceeded; try restarting transaction]; SQL was [] for task [
  3. ### Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  4. ### The error may involve com.petrosoftinc.pos.core.dao.mybatis.SettingDao.update-Inline
  5. ### The error occurred while setting parameters
  6. ### SQL: UPDATE setting SET setting_value = ?, setting_key = ? WHERE id = ?
  7. ### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  8. ]
  9. 2017-03-10 07:14:22,232 [pool-5-thread-1 ] [ERROR] [ScheduledTasks.syncOutdoorTransactions]:304 - syncOutdoorTransactions
  10. org.springframework.dao.CannotAcquireLockException:
  11. ### Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  12. ### The error may involve com.petrosoftinc.pos.core.dao.mybatis.SettingDao.update-Inline
  13. ### The error occurred while setting parameters
  14. ### SQL: UPDATE setting SET setting_value = ?, setting_key = ? WHERE id = ?
  15. ### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  16. ; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  17. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:259)
  18. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  19. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
  20. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399)
  21. at com.sun.proxy.$Proxy37.update(Unknown Source)
  22. at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:269)
  23. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:55)
  24. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
  25. at com.sun.proxy.$Proxy39.update(Unknown Source)
  26. at com.petrosoftinc.pos.core.services.domain.SettingService.setSetting(SettingService.java:104)
  27. at com.petrosoftinc.pos.core.services.domain.SettingService.setDateSetting(SettingService.java:89)
  28. at com.petrosoftinc.pos.core.services.enterprise.forecourt.OutdoorTransactionService.updateSyncDate(OutdoorTransactionService.java:84)
  29. at com.petrosoftinc.pos.core.services.enterprise.forecourt.OutdoorTransactionService.syncOutdoorTransactions(OutdoorTransactionService.java:72)
  30. at com.petrosoftinc.pos.core.schedules.ScheduledTasks.syncOutdoorTransactions(ScheduledTasks.java:302)
  31. at sun.reflect.GeneratedMethodAccessor525.invoke(Unknown Source)
  32. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  33. at java.lang.reflect.Method.invoke(Method.java:497)
  34. at com.petrosoftinc.pos.core.annotations.PosScheduledMethodRunnable.run(PosScheduledMethodRunnable.java:30)
  35. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  36. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  37. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  38. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  39. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  40. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  41. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  42. at java.lang.Thread.run(Thread.java:745)
  43. Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  44. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
  45. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
  46. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
  47. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
  48. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
  49. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
  50. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
  51. at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193)
  52. at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
  53. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  54. at java.lang.reflect.Method.invoke(Method.java:497)
  55. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  56. at com.sun.proxy.$Proxy63.execute(Unknown Source)
  57. at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:45)
  58. at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:73)
  59. at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
  60. at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)
  61. at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
  62. at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)
  63. at sun.reflect.GeneratedMethodAccessor313.invoke(Unknown Source)
  64. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  65. at java.lang.reflect.Method.invoke(Method.java:497)
  66. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
  67. ... 22 more
  68. 2017-03-10 07:14:22,235 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.check_forecourt_controller_service_state
  69. 2017-03-10 07:14:22,235 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting MODULE_FUEL=1
  70. 2017-03-10 07:14:22,235 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting HARDWARE_FORECOURT_CONTROLLER=1
  71. 2017-03-10 07:14:22,235 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.check_access_code
  72. 2017-03-10 07:14:22,236 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting SUPPORT_STATUS=0
  73. 2017-03-10 07:14:22,236 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.check_eps_financial_host_state
  74. 2017-03-10 07:14:22,236 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting HARDWARE_CREDIT_CARD_PROCESSOR=5
  75. 2017-03-10 07:14:22,237 [pool-5-thread-1 ] [DEBUG] [ForecourtEpsService.logSendRequest]:1143 - Send request <diagnosisOnline>
  76. 2017-03-10 07:14:22,632 [pool-5-thread-1 ] [DEBUG] [FusionEpsTransportAPI.sendRequest]:183 - [POS -> EPS]
  77. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  78. <ServiceRequest RequestType="Diagnosis" ApplicationSender="SmartPOS" WorkstationID="POS022" POPID="001" RequestID="596085305853238" POSAddress="192.168.116.18" xmlns="http://www.nrf-arts.org/IXRetail/namespace">
  79. <POSData StatusReq="Online">
  80. <POSTimeStamp>2017-03-10T07:14:22.236-05:00</POSTimeStamp>
  81. </POSData>
  82. </ServiceRequest>
  83. 2017-03-10 07:14:24,084 [pool-5-thread-1 ] [DEBUG] [FusionEpsTransportAPI.parseResponse]:343 - [EPS -> POS]
  84. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  85. <ServiceResponse RequestType="Diagnosis" ApplicationSender="SmartPOS" WorkstationID="POS022" POPID="001" RequestID="596085305853238" OverallResult="Success" xmlns="http://www.nrf-arts.org/IXRetail/namespace"/>
  86.  
  87. 2017-03-10 07:14:24,134 [pool-5-thread-1 ] [DEBUG] [ForecourtEpsService.logGetResponse]:1147 - Get response <diagnosisOnline>
  88. 2017-03-10 07:14:24,134 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.third_party_back_office.check_update
  89. 2017-03-10 07:14:24,135 [pool-5-thread-1 ] [INFO ] [OperationStatisticService.start]:24 - [START] THIRD_PARTY_BACK_OFFICE_UPDATE
  90. 2017-03-10 07:14:24,135 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting THIRD_PARTY_BACK_OFFICE_ENABLED=0
  91. 2017-03-10 07:14:24,135 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting THIRD_PARTY_BACK_OFFICE_LOGIN=
  92. 2017-03-10 07:14:24,135 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting THIRD_PARTY_BACK_OFFICE_PASSWORD=
  93. 2017-03-10 07:14:24,136 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting THIRD_PARTY_BACK_OFFICE_GENERATE_CASHIER_REPORT=0
  94. 2017-03-10 07:14:24,136 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting THIRD_PARTY_BACK_OFFICE_GENERATE_DAY_REPORT=0
  95. 2017-03-10 07:14:24,136 [pool-5-thread-1 ] [INFO ] [OperationStatisticService.end]:43 - [END] THIRD_PARTY_BACK_OFFICE_UPDATE duration: 1 ms
  96. 2017-03-10 07:14:24,136 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.pjr_export
  97. 2017-03-10 07:14:24,137 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting PJR_ENABLED=0
  98. 2017-03-10 07:14:26,143 [Thread-11 ] [DEBUG] [FusionTransportAPI.startHeartbeatThread]:390 - [POS -> FDC]
  99. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  100. <POSMessage MessageType="POS_Ready" ApplicationSender="POS022" WorkstationID="POS022" MessageID="182">
  101. <POSdata>
  102. <POSTimeStamp>2017-03-10T07:14:26</POSTimeStamp>
  103. </POSdata>
  104. </POSMessage>
  105. 2017-03-10 07:14:30,011 [Thread-10 ] [DEBUG] [FusionTransportAPI.parseResponse]:313 - [FDC -> POS]
  106. <?xml version="1.0" encoding="UTF-8" ?>
  107. <FDCMessage MessageType="FDC_Ready" ApplicationSender="POS022" WorkstationID="POS022" MessageID="182" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  108. <FDCdata>
  109. <FDCTimeStamp>2017-03-10T07:14:58</FDCTimeStamp>
  110. </FDCdata>
  111. </FDCMessage>
  112. 2017-03-10 07:14:36,144 [Thread-11 ] [DEBUG] [FusionTransportAPI.startHeartbeatThread]:390 - [POS -> FDC]
  113. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  114. <POSMessage MessageType="POS_Ready" ApplicationSender="POS022" WorkstationID="POS022" MessageID="183">
  115. <POSdata>
  116. <POSTimeStamp>2017-03-10T07:14:36</POSTimeStamp>
  117. </POSdata>
  118. </POSMessage>
  119. 2017-03-10 07:14:36,468 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting MODULE_VIDEO_JOURNAL=0
  120. 2017-03-10 07:14:36,468 [pool-4-thread-1 ] [INFO ] [VideoJournalService.checkAndSendIps]:404 - checkAndSendIps: video jounal or NAS mode disabled
  121. 2017-03-10 07:14:36,468 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting MODULE_VIDEO_JOURNAL=0
  122. 2017-03-10 07:14:36,469 [pool-4-thread-1 ] [INFO ] [VideoJournalService.checkNasConnection]:415 - check NAS connection: video jounal or NAS mode disabled
  123. 2017-03-10 07:14:36,474 [pool-4-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting MODULE_VIDEO_JOURNAL=0
  124. 2017-03-10 07:14:36,474 [pool-4-thread-1 ] [INFO ] [VideoJournalService.createScreenshots]:285 - createScreenshots: video jounal disabled
  125. 2017-03-10 07:14:36,484 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.send_pricebook_backup_to_cso
  126. 2017-03-10 07:14:36,485 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting IS_PRICEBOOK_CHANGED_MANUALLY=0
  127. 2017-03-10 07:14:36,540 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.nightly_reports_send
  128. 2017-03-10 07:14:36,540 [pool-5-thread-1 ] [INFO ] [NightlyReportService.sendReports]:186 - Start process for Nightly send files
  129. 2017-03-10 07:14:36,540 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting SALES_DATA_FTP_HOST=
  130. 2017-03-10 07:14:36,541 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting SALES_DATA_FTP_PORT=21
  131. 2017-03-10 07:14:36,541 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting SALES_DATA_FTP_USERNAME=
  132. 2017-03-10 07:14:36,541 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting SALES_DATA_FTP_PASSWORD=
  133. 2017-03-10 07:14:36,541 [pool-5-thread-1 ] [DEBUG] [SettingService.getSetting]:60 - Read setting SALES_DATA_FTP_PATH=
  134. 2017-03-10 07:14:36,541 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  135. 2017-03-10 07:14:36,542 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3417b4] was not registered for synchronization because synchronization is not active
  136. 2017-03-10 07:14:36,542 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  137. 2017-03-10 07:14:36,542 [pool-5-thread-1 ] [DEBUG] [DriverManagerDataSource.getConnectionFromDriver]:142 - Creating new JDBC DriverManager Connection to [jdbc:mysql://localhost:3306/symfony?allowMultiQueries=true&useServerPrepStmts=false&rewriteBatchedStatements=true]
  138. 2017-03-10 07:14:36,546 [pool-5-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mysql.jdbc.JDBC4Connection@1175218] will not be managed by Spring
  139. 2017-03-10 07:14:36,547 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM nightly_report_history WHERE status = 2 ORDER BY id
  140. 2017-03-10 07:14:36,548 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters:
  141. 2017-03-10 07:14:36,550 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  142. 2017-03-10 07:14:36,550 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3417b4]
  143. 2017-03-10 07:14:36,551 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  144. 2017-03-10 07:14:36,552 [pool-5-thread-1 ] [INFO ] [NightlyReportService.sendReports]:232 - End process for Nightly send files
  145. 2017-03-10 07:14:36,609 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.update_drivers
  146. 2017-03-10 07:14:36,610 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  147. 2017-03-10 07:14:36,610 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f19291] was not registered for synchronization because synchronization is not active
  148. 2017-03-10 07:14:36,611 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  149. 2017-03-10 07:14:36,611 [pool-5-thread-1 ] [DEBUG] [DriverManagerDataSource.getConnectionFromDriver]:142 - Creating new JDBC DriverManager Connection to [jdbc:mysql://localhost:3306/symfony?allowMultiQueries=true&useServerPrepStmts=false&rewriteBatchedStatements=true]
  150. 2017-03-10 07:14:36,615 [pool-5-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mysql.jdbc.JDBC4Connection@45e086] will not be managed by Spring
  151. 2017-03-10 07:14:36,616 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM role WHERE title = ? AND is_active = 1 LIMIT 1
  152. 2017-03-10 07:14:36,616 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: Courier(String)
  153. 2017-03-10 07:14:36,617 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 1
  154. 2017-03-10 07:14:36,618 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f19291]
  155. 2017-03-10 07:14:36,619 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  156. 2017-03-10 07:14:36,619 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.getSqlSession]:99 - Creating a new SqlSession
  157. 2017-03-10 07:14:36,620 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.registerSessionHolder]:150 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@33318b] was not registered for synchronization because synchronization is not active
  158. 2017-03-10 07:14:36,620 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doGetConnection]:110 - Fetching JDBC Connection from DataSource
  159. 2017-03-10 07:14:36,621 [pool-5-thread-1 ] [DEBUG] [DriverManagerDataSource.getConnectionFromDriver]:142 - Creating new JDBC DriverManager Connection to [jdbc:mysql://localhost:3306/symfony?allowMultiQueries=true&useServerPrepStmts=false&rewriteBatchedStatements=true]
  160. 2017-03-10 07:14:36,625 [pool-5-thread-1 ] [DEBUG] [SpringManagedTransaction.openConnection]:87 - JDBC Connection [com.mysql.jdbc.JDBC4Connection@dedf5d] will not be managed by Spring
  161. 2017-03-10 07:14:36,626 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Preparing: SELECT * FROM pos_users WHERE role_id= ? and is_clockin=1
  162. 2017-03-10 07:14:36,626 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - ==> Parameters: 35(Integer)
  163. 2017-03-10 07:14:36,627 [pool-5-thread-1 ] [DEBUG] [BaseJdbcLogger.debug]:142 - <== Total: 0
  164. 2017-03-10 07:14:36,628 [pool-5-thread-1 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:193 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@33318b]
  165. 2017-03-10 07:14:36,628 [pool-5-thread-1 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  166. 2017-03-10 07:14:36,629 [pool-5-thread-1 ] [INFO ] [PosScheduledMethodRunnable.run]:28 - Schedule start: schedules.garbage_collect
  167. 2017-03-10 07:14:36,629 [pool-5-thread-1 ] [INFO ] [GarbageCollectorService.runGarbageCollect]:28 - Garbage collect start
  168. 2017-03-10 07:14:36,629 [pool-5-thread-1 ] [INFO ] [GarbageCollectorService.isLoginScreenActive]:57 - User is not on login screen
  169. 2017-03-10 07:14:36,629 [pool-5-thread-1 ] [INFO ] [GarbageCollectorService.runGarbageCollect]:32 - Garbage collect finish
  170. 2017-03-10 07:14:37,141 [pool-3-thread-4 ] [DEBUG] [SqlSessionUtils.closeSqlSession]:188 - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@634c58]
  171. 2017-03-10 07:14:37,142 [pool-3-thread-4 ] [DEBUG] [SQLErrorCodesFactory.getErrorCodes]:199 - Looking up default SQLErrorCodes for DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@6d3a51]
  172. 2017-03-10 07:14:37,144 [pool-3-thread-4 ] [DEBUG] [SQLErrorCodesFactory.getErrorCodes]:207 - SQLErrorCodes found in cache for DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@6d3a51]
  173. 2017-03-10 07:14:37,144 [pool-3-thread-4 ] [DEBUG] [SQLErrorCodeSQLExceptionTranslator.logTranslation]:397 - Translating SQLException with SQL state '41000', error code '1205', message [Lock wait timeout exceeded; try restarting transaction]; SQL was [] for task [
  174. ### Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  175. ### The error may involve com.petrosoftinc.pos.core.dao.mybatis.SyncQueueDao.removeByIdNameAndKey-Inline
  176. ### The error occurred while setting parameters
  177. ### SQL: DELETE FROM sync_queue WHERE entity_id = ? AND entity_name = ? AND license_key = ?
  178. ### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  179. ]
  180. 2017-03-10 07:14:37,146 [pool-3-thread-4 ] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:312 - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@634c58]
  181. 2017-03-10 07:14:37,146 [pool-3-thread-4 ] [DEBUG] [SqlSessionUtils$SqlSessionSynchronization.beforeCompletion]:317 - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@634c58]
  182. 2017-03-10 07:14:37,146 [pool-3-thread-4 ] [DEBUG] [AbstractPlatformTransactionManager.processRollback]:851 - Initiating transaction rollback
  183. 2017-03-10 07:14:37,147 [pool-3-thread-4 ] [DEBUG] [DataSourceTransactionManager.doRollback]:284 - Rolling back JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@12f09f0]
  184. 2017-03-10 07:14:37,148 [pool-3-thread-4 ] [DEBUG] [DataSourceTransactionManager.doCleanupAfterCompletion]:327 - Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@12f09f0] after transaction
  185. 2017-03-10 07:14:37,148 [pool-3-thread-4 ] [DEBUG] [DataSourceUtils.doReleaseConnection]:327 - Returning JDBC Connection to DataSource
  186. 2017-03-10 07:14:37,149 [pool-3-thread-4 ] [ERROR] [TcpStreamHandler.onMessage]:64 -
  187. ### Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  188. ### The error may involve com.petrosoftinc.pos.core.dao.mybatis.SyncQueueDao.removeByIdNameAndKey-Inline
  189. ### The error occurred while setting parameters
  190. ### SQL: DELETE FROM sync_queue WHERE entity_id = ? AND entity_name = ? AND license_key = ?
  191. ### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  192. ; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  193. org.springframework.dao.CannotAcquireLockException:
  194. ### Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  195. ### The error may involve com.petrosoftinc.pos.core.dao.mybatis.SyncQueueDao.removeByIdNameAndKey-Inline
  196. ### The error occurred while setting parameters
  197. ### SQL: DELETE FROM sync_queue WHERE entity_id = ? AND entity_name = ? AND license_key = ?
  198. ### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  199. ; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  200. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:259)
  201. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  202. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
  203. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399)
  204. at com.sun.proxy.$Proxy37.delete(Unknown Source)
  205. at org.mybatis.spring.SqlSessionTemplate.delete(SqlSessionTemplate.java:285)
  206. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
  207. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
  208. at com.sun.proxy.$Proxy144.removeByIdNameAndKey(Unknown Source)
  209. at com.petrosoftinc.pos.core.services.domain.SyncQueueService.removeByIdNameAndKey(SyncQueueService.java:38)
  210. at com.petrosoftinc.pos.core.services.domain.SyncQueueService$$FastClassBySpringCGLIB$$31330665.invoke(<generated>)
  211. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  212. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
  213. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  214. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  215. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  216. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  217. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  218. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
  219. at com.petrosoftinc.pos.core.services.domain.SyncQueueService$$EnhancerBySpringCGLIB$$7d6fe44a.removeByIdNameAndKey(<generated>)
  220. at com.petrosoftinc.pos.core.services.enterprise.entitysync.processors.SyncCompletedProcessor.onMessage(SyncCompletedProcessor.java:31)
  221. at com.petrosoftinc.pos.core.services.enterprise.qsintegration.QsMessageHandler.receive(QsMessageHandler.java:47)
  222. at com.petrosoftinc.pos.core.services.enterprise.tcpintegration.AbstractJsonMessageHandler.receive(AbstractJsonMessageHandler.java:53)
  223. at com.petrosoftinc.pos.core.services.enterprise.entitysync.processors.SubMessageProcessor.onMessage(SubMessageProcessor.java:29)
  224. at com.petrosoftinc.pos.core.services.enterprise.qsintegration.QsMessageHandler.receive(QsMessageHandler.java:47)
  225. at com.petrosoftinc.pos.core.services.enterprise.tcpintegration.AbstractJsonMessageHandler.receive(AbstractJsonMessageHandler.java:53)
  226. at com.petrosoftinc.pos.core.services.enterprise.tcpintegration.TcpStreamHandler.onMessage(TcpStreamHandler.java:61)
  227. at com.petrosoftinc.pos.core.services.enterprise.tcpintegration.TcpStreamHandler.onRead(TcpStreamHandler.java:54)
  228. at com.petrosoftinc.pos.core.services.enterprise.tcpintegration.TcpStreamHandler$ReadHandler.completed(TcpStreamHandler.java:99)
  229. at com.petrosoftinc.pos.core.services.enterprise.tcpintegration.TcpStreamHandler$ReadHandler.completed(TcpStreamHandler.java:82)
  230. at sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:126)
  231. at sun.nio.ch.UnixAsynchronousSocketChannelImpl.finishRead(UnixAsynchronousSocketChannelImpl.java:430)
  232. at sun.nio.ch.UnixAsynchronousSocketChannelImpl.finish(UnixAsynchronousSocketChannelImpl.java:191)
  233. at sun.nio.ch.UnixAsynchronousSocketChannelImpl.onEvent(UnixAsynchronousSocketChannelImpl.java:213)
  234. at sun.nio.ch.EPollPort$EventHandlerTask.run(EPollPort.java:293)
  235. at sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)
  236. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  237. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  238. at java.lang.Thread.run(Thread.java:745)
  239. Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
  240. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
  241. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
  242. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
  243. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
  244. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
  245. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
  246. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
  247. at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193)
  248. at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
  249. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  250. at java.lang.reflect.Method.invoke(Method.java:497)
  251. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  252. at com.sun.proxy.$Proxy63.execute(Unknown Source)
  253. at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:45)
  254. at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:73)
  255. at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
  256. at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)
  257. at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
  258. at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)
  259. at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:185)
  260. at sun.reflect.GeneratedMethodAccessor538.invoke(Unknown Source)
  261. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  262. at java.lang.reflect.Method.invoke(Method.java:497)
  263. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
  264. ... 35 more
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!