123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216 |
- 11:18:34 [error]: 通用的实体数据存取接口异常:数据库执行异常:Lock wait timeout exceeded; try restarting transaction
- 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
- and(
- (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
- or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
- or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
- (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
- or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
- or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
- ))
- )
- ; 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
- and(
- (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
- or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
- or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
- (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
- or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
- or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
- ))
- )
- ; insert into biz_message_queue( createtime, biz_catalog, biz_id) select :nowtime, 0, :bizid from dual where 1=1;commit;
- ["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"]
- 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
- 异常堆栈上下文:
- #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
- #1 {main}
- 数据库执行异常:Lock wait timeout exceeded; try restarting transaction
- 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
- and(
- (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
- or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
- or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
- (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
- or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
- or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
- ))
- )
- ; 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
- and(
- (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
- or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
- or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
- (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
- or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
- or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
- ))
- )
- ; insert into biz_message_queue( createtime, biz_catalog, biz_id) select :nowtime, 0, :bizid from dual where 1=1;commit;
- ["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"]
- 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
- 异常堆栈上下文:
- #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
- #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
- #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
- #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(586): pdo_query3()
- #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(290): bizbase_enrollPassHandleCore()
- #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2477): bizbase_paySuccess()
- #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(1236): {closure}()
- #7 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
- #8 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(24): filelock_handle()
- #9 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(1238): biz_flkForRecruit()
- #10 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2551): bizbase_recruitWorkLock()
- #11 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(82): bizbase_todoWorkEntityHandle()
- #12 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
- #13 {main}
- [上下文相关信息]:
- [WsAjaxPrj]=KLY
- [WsAjaxBiz]=Trader
- [WsAjaxAction]=entityDataHandle
- [USER]=nginxphp
- [HOME]=/home/nginxphp
- [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
- [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
- [HTTP_SEC_FETCH_DEST]=empty
- [HTTP_SEC_FETCH_MODE]=cors
- [HTTP_SEC_FETCH_SITE]=cross-site
- [HTTP_ACCEPT]=*/*
- [HTTP_CONTENT_TYPE]=application/json
- [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/
- [HTTP_CONTENT_LENGTH]=218
- [HTTP_CONNECTION]=keep-alive
- [HTTP_HOST]=api.kuailaiyou.top
- [REDIRECT_STATUS]=200
- [SERVER_NAME]=api.kuailaiyou.top
- [SERVER_PORT]=443
- [SERVER_ADDR]=172.18.217.149
- [REMOTE_PORT]=14915
- [REMOTE_ADDR]=180.212.71.213
- [SERVER_SOFTWARE]=nginx/1.20.1
- [GATEWAY_INTERFACE]=CGI/1.1
- [HTTPS]=on
- [REQUEST_SCHEME]=https
- [SERVER_PROTOCOL]=HTTP/1.1
- [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
- [DOCUMENT_URI]=/ajaxEntryCenter.php
- [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
- [SCRIPT_NAME]=/ajaxEntryCenter.php
- [CONTENT_LENGTH]=218
- [CONTENT_TYPE]=application/json
- [REQUEST_METHOD]=POST
- [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
- [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
- [FCGI_ROLE]=RESPONDER
- [PHP_SELF]=/ajaxEntryCenter.php
- [REQUEST_TIME_FLOAT]=1658373463.3372
- [REQUEST_TIME]=1658373463
- 11:57:15 [error]: 通用的实体数据存取接口异常:数据库执行异常:Lock wait timeout exceeded; try restarting transaction
- 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
- and(
- (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
- or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
- or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
- (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
- or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
- or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
- ))
- )
- ; 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
- and(
- (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
- or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
- or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
- (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
- or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
- or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
- ))
- )
- ; insert into biz_message_queue( createtime, biz_catalog, biz_id) select :nowtime, 0, :bizid from dual where 1=1;commit;
- ["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"]
- 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
- 异常堆栈上下文:
- #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
- #1 {main}
- 数据库执行异常:Lock wait timeout exceeded; try restarting transaction
- 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
- and(
- (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
- or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
- or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
- (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
- or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
- or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
- ))
- )
- ; 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
- and(
- (tdwk.todo_begindate>=:plandoDateStart and tdwk.todo_begindate<=:plandoDateFinish)
- or(tdwk.todo_begindate>=:workDateStart and tdwk.todo_begindate<=:workDateFinish)
- or( btr.settle_catalog<=0 and btr.finish_datetime>btr.begin_datetime and (
- (btr.begin_datetime>=:workDateStart and btr.begin_datetime<=:workDateFinish)
- or(btr.begin_datetime<=:workDateStart and btr.finish_datetime>=:workDateFinish)
- or(btr.finish_datetime>=:workDateStart and btr.finish_datetime<=:workDateFinish)
- ))
- )
- ; insert into biz_message_queue( createtime, biz_catalog, biz_id) select :nowtime, 0, :bizid from dual where 1=1;commit;
- ["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"]
- 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
- 异常堆栈上下文:
- #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle()
- #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2()
- #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans()
- #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(586): pdo_query3()
- #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(290): bizbase_enrollPassHandleCore()
- #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2477): bizbase_paySuccess()
- #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(1236): {closure}()
- #7 /bizroot/approot/klywebapi/base/base.php(355): {closure}()
- #8 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(24): filelock_handle()
- #9 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(1238): biz_flkForRecruit()
- #10 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2551): bizbase_recruitWorkLock()
- #11 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(82): bizbase_todoWorkEntityHandle()
- #12 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
- #13 {main}
- [上下文相关信息]:
- [WsAjaxPrj]=KLY
- [WsAjaxBiz]=Trader
- [WsAjaxAction]=entityDataHandle
- [USER]=nginxphp
- [HOME]=/home/nginxphp
- [HTTP_ACCEPT_ENCODING]=gzip, deflate, br
- [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/devtools/page-frame.html
- [HTTP_SEC_FETCH_DEST]=empty
- [HTTP_SEC_FETCH_MODE]=cors
- [HTTP_SEC_FETCH_SITE]=cross-site
- [HTTP_ACCEPT]=*/*
- [HTTP_CONTENT_TYPE]=application/json
- [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/
- [HTTP_CONTENT_LENGTH]=218
- [HTTP_CONNECTION]=keep-alive
- [HTTP_HOST]=api.kuailaiyou.top
- [REDIRECT_STATUS]=200
- [SERVER_NAME]=api.kuailaiyou.top
- [SERVER_PORT]=443
- [SERVER_ADDR]=172.18.217.149
- [REMOTE_PORT]=13369
- [REMOTE_ADDR]=180.212.71.213
- [SERVER_SOFTWARE]=nginx/1.20.1
- [GATEWAY_INTERFACE]=CGI/1.1
- [HTTPS]=on
- [REQUEST_SCHEME]=https
- [SERVER_PROTOCOL]=HTTP/1.1
- [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
- [DOCUMENT_URI]=/ajaxEntryCenter.php
- [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
- [SCRIPT_NAME]=/ajaxEntryCenter.php
- [CONTENT_LENGTH]=218
- [CONTENT_TYPE]=application/json
- [REQUEST_METHOD]=POST
- [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
- [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
- [FCGI_ROLE]=RESPONDER
- [PHP_SELF]=/ajaxEntryCenter.php
- [REQUEST_TIME_FLOAT]=1658375784.7369
- [REQUEST_TIME]=1658375784
|