2022072111_entityDataHandle.log 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216
  1. 11:18:34 [error]: 通用的实体数据存取接口异常:数据库执行异常:Lock wait timeout exceeded; try restarting transaction
  2. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_trader_account where biz_traderid=:biz_traderid and `type`=1 and `biz_catalog`=8 and `biz_id`=:bizid and `status`=1 limit 1; insert into biz_trader_account ( `biz_traderid`, `createtime`,`type`, `money`, `status`, `biz_catalog`,`biz_id`, remark ) select :biz_traderid , :nowtime , 1 , :feetotal, 1, 8 , :bizid, :accremark2 from dual where ifnull(@handle_id,0)=0; update biz_todowork set updatetime=:nowtime,`status`=2 ,remark=concat(:bizremark,ifnull(remark,'')) where id=:bizid; insert into biz_worker_account ( `biz_workerid`, `createtime`,`type`, `money`, `status`, `biz_catalog`,`biz_id`, remark ) select tdwk.biz_workerid , :nowtime , 0 , tdwk.enroll_premoney, 1, 5 , tdwk.id, :cancel_remark from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.id<>:bizid and tdwk.biz_workerid=:biz_workerid and tdwk.`status`=1
  3. and(
  4. (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
  5. or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
  6. or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
  7. (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
  8. or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
  9. or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
  10. ))
  11. )
  12. ; update biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid set tdwk.updatetime=:nowtime, tdwk.`status`=-4, tdwk.`teamstatus`=-4 , tdwk.remark=concat(:cancel_remark,ifnull(tdwk.remark,'')), tdwk.teamremark=concat(:cancel_remark,ifnull(tdwk.teamremark,'')) where tdwk.id<>:bizid and tdwk.biz_workerid=:biz_workerid and tdwk.`status`=1
  13. and(
  14. (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
  15. or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
  16. or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
  17. (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
  18. or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
  19. or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
  20. ))
  21. )
  22. ; insert into biz_message_queue( createtime, biz_catalog, biz_id) select :nowtime, 0, :bizid from dual where 1=1;commit;
  23. ["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"]
  24. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  25. 异常堆栈上下文:
  26. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  27. #1 {main}
  28. 数据库执行异常:Lock wait timeout exceeded; try restarting transaction
  29. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_trader_account where biz_traderid=:biz_traderid and `type`=1 and `biz_catalog`=8 and `biz_id`=:bizid and `status`=1 limit 1; insert into biz_trader_account ( `biz_traderid`, `createtime`,`type`, `money`, `status`, `biz_catalog`,`biz_id`, remark ) select :biz_traderid , :nowtime , 1 , :feetotal, 1, 8 , :bizid, :accremark2 from dual where ifnull(@handle_id,0)=0; update biz_todowork set updatetime=:nowtime,`status`=2 ,remark=concat(:bizremark,ifnull(remark,'')) where id=:bizid; insert into biz_worker_account ( `biz_workerid`, `createtime`,`type`, `money`, `status`, `biz_catalog`,`biz_id`, remark ) select tdwk.biz_workerid , :nowtime , 0 , tdwk.enroll_premoney, 1, 5 , tdwk.id, :cancel_remark from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.id<>:bizid and tdwk.biz_workerid=:biz_workerid and tdwk.`status`=1
  30. and(
  31. (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
  32. or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
  33. or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
  34. (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
  35. or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
  36. or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
  37. ))
  38. )
  39. ; update biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid set tdwk.updatetime=:nowtime, tdwk.`status`=-4, tdwk.`teamstatus`=-4 , tdwk.remark=concat(:cancel_remark,ifnull(tdwk.remark,'')), tdwk.teamremark=concat(:cancel_remark,ifnull(tdwk.teamremark,'')) where tdwk.id<>:bizid and tdwk.biz_workerid=:biz_workerid and tdwk.`status`=1
  40. and(
  41. (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
  42. or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
  43. or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
  44. (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
  45. or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
  46. or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
  47. ))
  48. )
  49. ; insert into biz_message_queue( createtime, biz_catalog, biz_id) select :nowtime, 0, :bizid from dual where 1=1;commit;
  50. ["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"]
  51. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  52. 异常堆栈上下文:
  53. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  54. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  55. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  56. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(586): pdo_query3()
  57. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(290): bizbase_enrollPassHandleCore()
  58. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2477): bizbase_paySuccess()
  59. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(1236): {closure}()
  60. #7 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  61. #8 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(24): filelock_handle()
  62. #9 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(1238): biz_flkForRecruit()
  63. #10 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2551): bizbase_recruitWorkLock()
  64. #11 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(82): bizbase_todoWorkEntityHandle()
  65. #12 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  66. #13 {main}
  67. [上下文相关信息]:
  68. [WsAjaxPrj]=KLY
  69. [WsAjaxBiz]=Trader
  70. [WsAjaxAction]=entityDataHandle
  71. [USER]=nginxphp
  72. [HOME]=/home/nginxphp
  73. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  74. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  75. [HTTP_SEC_FETCH_DEST]=empty
  76. [HTTP_SEC_FETCH_MODE]=cors
  77. [HTTP_SEC_FETCH_SITE]=cross-site
  78. [HTTP_ACCEPT]=*/*
  79. [HTTP_CONTENT_TYPE]=application/json
  80. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.06.2206090 MicroMessenger/8.0.5 Language/zh_CN webview/
  81. [HTTP_CONTENT_LENGTH]=218
  82. [HTTP_CONNECTION]=keep-alive
  83. [HTTP_HOST]=api.kuailaiyou.top
  84. [REDIRECT_STATUS]=200
  85. [SERVER_NAME]=api.kuailaiyou.top
  86. [SERVER_PORT]=443
  87. [SERVER_ADDR]=172.18.217.149
  88. [REMOTE_PORT]=14915
  89. [REMOTE_ADDR]=180.212.71.213
  90. [SERVER_SOFTWARE]=nginx/1.20.1
  91. [GATEWAY_INTERFACE]=CGI/1.1
  92. [HTTPS]=on
  93. [REQUEST_SCHEME]=https
  94. [SERVER_PROTOCOL]=HTTP/1.1
  95. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  96. [DOCUMENT_URI]=/ajaxEntryCenter.php
  97. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  98. [SCRIPT_NAME]=/ajaxEntryCenter.php
  99. [CONTENT_LENGTH]=218
  100. [CONTENT_TYPE]=application/json
  101. [REQUEST_METHOD]=POST
  102. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  103. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  104. [FCGI_ROLE]=RESPONDER
  105. [PHP_SELF]=/ajaxEntryCenter.php
  106. [REQUEST_TIME_FLOAT]=1658373463.3372
  107. [REQUEST_TIME]=1658373463
  108. 11:57:15 [error]: 通用的实体数据存取接口异常:数据库执行异常:Lock wait timeout exceeded; try restarting transaction
  109. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_trader_account where biz_traderid=:biz_traderid and `type`=1 and `biz_catalog`=8 and `biz_id`=:bizid and `status`=1 limit 1; insert into biz_trader_account ( `biz_traderid`, `createtime`,`type`, `money`, `status`, `biz_catalog`,`biz_id`, remark ) select :biz_traderid , :nowtime , 1 , :feetotal, 1, 8 , :bizid, :accremark2 from dual where ifnull(@handle_id,0)=0; update biz_todowork set updatetime=:nowtime,`status`=2 ,remark=concat(:bizremark,ifnull(remark,'')) where id=:bizid; insert into biz_worker_account ( `biz_workerid`, `createtime`,`type`, `money`, `status`, `biz_catalog`,`biz_id`, remark ) select tdwk.biz_workerid , :nowtime , 0 , tdwk.enroll_premoney, 1, 5 , tdwk.id, :cancel_remark from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.id<>:bizid and tdwk.biz_workerid=:biz_workerid and tdwk.`status`=1
  110. and(
  111. (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
  112. or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
  113. or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
  114. (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
  115. or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
  116. or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
  117. ))
  118. )
  119. ; update biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid set tdwk.updatetime=:nowtime, tdwk.`status`=-4, tdwk.`teamstatus`=-4 , tdwk.remark=concat(:cancel_remark,ifnull(tdwk.remark,'')), tdwk.teamremark=concat(:cancel_remark,ifnull(tdwk.teamremark,'')) where tdwk.id<>:bizid and tdwk.biz_workerid=:biz_workerid and tdwk.`status`=1
  120. and(
  121. (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
  122. or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
  123. or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
  124. (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
  125. or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
  126. or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
  127. ))
  128. )
  129. ; insert into biz_message_queue( createtime, biz_catalog, biz_id) select :nowtime, 0, :bizid from dual where 1=1;commit;
  130. ["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"]
  131. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  132. 异常堆栈上下文:
  133. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  134. #1 {main}
  135. 数据库执行异常:Lock wait timeout exceeded; try restarting transaction
  136. sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_trader_account where biz_traderid=:biz_traderid and `type`=1 and `biz_catalog`=8 and `biz_id`=:bizid and `status`=1 limit 1; insert into biz_trader_account ( `biz_traderid`, `createtime`,`type`, `money`, `status`, `biz_catalog`,`biz_id`, remark ) select :biz_traderid , :nowtime , 1 , :feetotal, 1, 8 , :bizid, :accremark2 from dual where ifnull(@handle_id,0)=0; update biz_todowork set updatetime=:nowtime,`status`=2 ,remark=concat(:bizremark,ifnull(remark,'')) where id=:bizid; insert into biz_worker_account ( `biz_workerid`, `createtime`,`type`, `money`, `status`, `biz_catalog`,`biz_id`, remark ) select tdwk.biz_workerid , :nowtime , 0 , tdwk.enroll_premoney, 1, 5 , tdwk.id, :cancel_remark from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.id<>:bizid and tdwk.biz_workerid=:biz_workerid and tdwk.`status`=1
  137. and(
  138. (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
  139. or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
  140. or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
  141. (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
  142. or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
  143. or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
  144. ))
  145. )
  146. ; update biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid set tdwk.updatetime=:nowtime, tdwk.`status`=-4, tdwk.`teamstatus`=-4 , tdwk.remark=concat(:cancel_remark,ifnull(tdwk.remark,'')), tdwk.teamremark=concat(:cancel_remark,ifnull(tdwk.teamremark,'')) where tdwk.id<>:bizid and tdwk.biz_workerid=:biz_workerid and tdwk.`status`=1
  147. and(
  148. (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
  149. or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
  150. or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
  151. (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
  152. or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
  153. or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
  154. ))
  155. )
  156. ; insert into biz_message_queue( createtime, biz_catalog, biz_id) select :nowtime, 0, :bizid from dual where 1=1;commit;
  157. ["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"]
  158. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  159. 异常堆栈上下文:
  160. #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
  161. #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
  162. #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
  163. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(586): pdo_query3()
  164. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(290): bizbase_enrollPassHandleCore()
  165. #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2477): bizbase_paySuccess()
  166. #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(1236): {closure}()
  167. #7 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
  168. #8 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(24): filelock_handle()
  169. #9 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(1238): biz_flkForRecruit()
  170. #10 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2551): bizbase_recruitWorkLock()
  171. #11 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(82): bizbase_todoWorkEntityHandle()
  172. #12 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  173. #13 {main}
  174. [上下文相关信息]:
  175. [WsAjaxPrj]=KLY
  176. [WsAjaxBiz]=Trader
  177. [WsAjaxAction]=entityDataHandle
  178. [USER]=nginxphp
  179. [HOME]=/home/nginxphp
  180. [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
  181. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
  182. [HTTP_SEC_FETCH_DEST]=empty
  183. [HTTP_SEC_FETCH_MODE]=cors
  184. [HTTP_SEC_FETCH_SITE]=cross-site
  185. [HTTP_ACCEPT]=*/*
  186. [HTTP_CONTENT_TYPE]=application/json
  187. [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1 wechatdevtools/1.06.2206090 MicroMessenger/8.0.5 Language/zh_CN webview/
  188. [HTTP_CONTENT_LENGTH]=218
  189. [HTTP_CONNECTION]=keep-alive
  190. [HTTP_HOST]=api.kuailaiyou.top
  191. [REDIRECT_STATUS]=200
  192. [SERVER_NAME]=api.kuailaiyou.top
  193. [SERVER_PORT]=443
  194. [SERVER_ADDR]=172.18.217.149
  195. [REMOTE_PORT]=13369
  196. [REMOTE_ADDR]=180.212.71.213
  197. [SERVER_SOFTWARE]=nginx/1.20.1
  198. [GATEWAY_INTERFACE]=CGI/1.1
  199. [HTTPS]=on
  200. [REQUEST_SCHEME]=https
  201. [SERVER_PROTOCOL]=HTTP/1.1
  202. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  203. [DOCUMENT_URI]=/ajaxEntryCenter.php
  204. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  205. [SCRIPT_NAME]=/ajaxEntryCenter.php
  206. [CONTENT_LENGTH]=218
  207. [CONTENT_TYPE]=application/json
  208. [REQUEST_METHOD]=POST
  209. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  210. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  211. [FCGI_ROLE]=RESPONDER
  212. [PHP_SELF]=/ajaxEntryCenter.php
  213. [REQUEST_TIME_FLOAT]=1658375784.7369
  214. [REQUEST_TIME]=1658375784