10:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Server shutdown in progress sql语句: select sum(workTotal) as workTotal ,sum(waitEnrollTotal) as waitEnrollTotal,sum(enrollTotal) as enrollTotal ,sum(workingTotal) as workingTotal,sum(waitSettleTotal) as waitSettleTotal ,sum(finishedTotal) as finishedTotal,sum(exceptTotal) as exceptTotal ,sum(refuseTotal) as refuseTotal,sum(breakoffTotal) as breakoffTotal ,sum(cancelTotal) as cancelTotal,sum(cancel2Total) as cancel2Total,sum(denypayTotal) as denypayTotal ,sum(noStartWorkTotal) as noStartWorkTotal,sum(noFinishWorkTotal) as noFinishWorkTotal ,sum(unreadWKTotal_8) as unreadWKTotal_8 ,sum(unreadWKTotal_7) as unreadWKTotal_7 ,sum(unreadWKTotal_6) as unreadWKTotal_6 ,sum(unreadWKTotal_5) as unreadWKTotal_5 ,sum(unreadWKTotal_4) as unreadWKTotal_4 ,sum(unreadWKTotal_3) as unreadWKTotal_3 ,sum(unreadWKTotal_2) as unreadWKTotal_2 ,sum(unreadWKTotal_1) as unreadWKTotal_1 ,sum(unreadWKTotal0) as unreadWKTotal0 ,sum(unreadWKTotal1) as unreadWKTotal1 ,sum(unreadWKTotal2) as unreadWKTotal2 ,sum(unreadWKTotal3) as unreadWKTotal3 ,sum(unreadWKTotal4) as unreadWKTotal4 ,sum(unreadWKTotal5) as unreadWKTotal5 from ( select sum(case when tdwk.id>0 then 1 else 0 end) as workTotal ,sum(case when tdwk.`status`=1 then 1 else 0 end) as waitEnrollTotal ,sum(case when tdwk.`status`>=2 then 1 else 0 end) as enrollTotal ,sum(case when (tdwk.`status`=2 or tdwk.`status`=3) then 1 else 0 end) as workingTotal ,sum(case when tdwk.`status`=4 then 1 else 0 end) as waitSettleTotal ,sum(case when tdwk.`status`>=5 then 1 else 0 end) as finishedTotal ,sum(case when tdwk.`status`<0 then 1 else 0 end) as exceptTotal ,sum(case when tdwk.`status`=-1 then 1 else 0 end) as refuseTotal ,sum(case when tdwk.`status`=-3 then 1 else 0 end) as breakoffTotal ,sum(case when tdwk.`status`=-2 then 1 else 0 end) as cancelTotal ,sum(case when tdwk.`status`=-4 then 1 else 0 end) as cancel2Total ,sum(case when (tdwk.`status`=-5 or tdwk.`status`=-8) then 1 else 0 end) as denypayTotal ,sum(case when tdwk.`status`=-6 then 1 else 0 end) as noStartWorkTotal ,sum(case when tdwk.`status`=-7 then 1 else 0 end) as noFinishWorkTotal ,sum(case when (tdwk.`status`=-8 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_8 ,sum(case when (tdwk.`status`=-7 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_7 ,sum(case when (tdwk.`status`=-6 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_6 ,sum(case when (tdwk.`status`=-5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_5 ,sum(case when (tdwk.`status`=-4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_4 ,sum(case when (tdwk.`status`=-3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_3 ,sum(case when (tdwk.`status`=-2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_2 ,sum(case when (tdwk.`status`=-1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_1 ,sum(case when (tdwk.`status`=0 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal0 ,sum(case when (tdwk.`status`=1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal1 ,sum(case when (tdwk.`status`=2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal2 ,sum(case when (tdwk.`status`=3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal3 ,sum(case when (tdwk.`status`=4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal4 ,sum(case when (tdwk.`status`=5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal5 from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.biz_workerid=313 group by tdwk.biz_recruitid ) as temp ["08S01",1053,"Server shutdown in progress"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[158]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Server shutdown in progress sql语句: select sum(workTotal) as workTotal ,sum(waitEnrollTotal) as waitEnrollTotal,sum(enrollTotal) as enrollTotal ,sum(workingTotal) as workingTotal,sum(waitSettleTotal) as waitSettleTotal ,sum(finishedTotal) as finishedTotal,sum(exceptTotal) as exceptTotal ,sum(refuseTotal) as refuseTotal,sum(breakoffTotal) as breakoffTotal ,sum(cancelTotal) as cancelTotal,sum(cancel2Total) as cancel2Total,sum(denypayTotal) as denypayTotal ,sum(noStartWorkTotal) as noStartWorkTotal,sum(noFinishWorkTotal) as noFinishWorkTotal ,sum(unreadWKTotal_8) as unreadWKTotal_8 ,sum(unreadWKTotal_7) as unreadWKTotal_7 ,sum(unreadWKTotal_6) as unreadWKTotal_6 ,sum(unreadWKTotal_5) as unreadWKTotal_5 ,sum(unreadWKTotal_4) as unreadWKTotal_4 ,sum(unreadWKTotal_3) as unreadWKTotal_3 ,sum(unreadWKTotal_2) as unreadWKTotal_2 ,sum(unreadWKTotal_1) as unreadWKTotal_1 ,sum(unreadWKTotal0) as unreadWKTotal0 ,sum(unreadWKTotal1) as unreadWKTotal1 ,sum(unreadWKTotal2) as unreadWKTotal2 ,sum(unreadWKTotal3) as unreadWKTotal3 ,sum(unreadWKTotal4) as unreadWKTotal4 ,sum(unreadWKTotal5) as unreadWKTotal5 from ( select sum(case when tdwk.id>0 then 1 else 0 end) as workTotal ,sum(case when tdwk.`status`=1 then 1 else 0 end) as waitEnrollTotal ,sum(case when tdwk.`status`>=2 then 1 else 0 end) as enrollTotal ,sum(case when (tdwk.`status`=2 or tdwk.`status`=3) then 1 else 0 end) as workingTotal ,sum(case when tdwk.`status`=4 then 1 else 0 end) as waitSettleTotal ,sum(case when tdwk.`status`>=5 then 1 else 0 end) as finishedTotal ,sum(case when tdwk.`status`<0 then 1 else 0 end) as exceptTotal ,sum(case when tdwk.`status`=-1 then 1 else 0 end) as refuseTotal ,sum(case when tdwk.`status`=-3 then 1 else 0 end) as breakoffTotal ,sum(case when tdwk.`status`=-2 then 1 else 0 end) as cancelTotal ,sum(case when tdwk.`status`=-4 then 1 else 0 end) as cancel2Total ,sum(case when (tdwk.`status`=-5 or tdwk.`status`=-8) then 1 else 0 end) as denypayTotal ,sum(case when tdwk.`status`=-6 then 1 else 0 end) as noStartWorkTotal ,sum(case when tdwk.`status`=-7 then 1 else 0 end) as noFinishWorkTotal ,sum(case when (tdwk.`status`=-8 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_8 ,sum(case when (tdwk.`status`=-7 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_7 ,sum(case when (tdwk.`status`=-6 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_6 ,sum(case when (tdwk.`status`=-5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_5 ,sum(case when (tdwk.`status`=-4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_4 ,sum(case when (tdwk.`status`=-3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_3 ,sum(case when (tdwk.`status`=-2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_2 ,sum(case when (tdwk.`status`=-1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_1 ,sum(case when (tdwk.`status`=0 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal0 ,sum(case when (tdwk.`status`=1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal1 ,sum(case when (tdwk.`status`=2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal2 ,sum(case when (tdwk.`status`=3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal3 ,sum(case when (tdwk.`status`=4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal4 ,sum(case when (tdwk.`status`=5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal5 from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.biz_workerid=313 group by tdwk.biz_recruitid ) as temp ["08S01",1053,"Server shutdown in progress"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(187): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(283): bizbase_workerStatistics() #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(100): bizbase_workerEntityHandle() #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #6 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.26(0x18001a23) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=134 [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]=35774 [REMOTE_ADDR]=106.114.66.146 [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=Worker&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=134 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1658454196.0085 [REQUEST_TIME]=1658454196 10:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Server shutdown in progress sql语句: select sum(workTotal) as workTotal, sum(enrollUnauditTotal) as enrollUnauditTotal, sum(enrollTotal) as enrollTotal ,sum(waitSettledTotal) as waitSettledTotal,sum(settledTotal) as settledTotal ,sum(exceptTotal) as exceptTotal ,sum(refuseTotal) as refuseTotal,sum(breakoffTotal) as breakoffTotal ,sum(cancelTotal) as cancelTotal,sum(cancel2Total) as cancel2Total,sum(denypayTotal) as denypayTotal ,sum(noStartWorkTotal) as noStartWorkTotal,sum(noFinishWorkTotal) as noFinishWorkTotal ,sum(unreadWKTotal_8) as unreadWKTotal_8 ,sum(unreadWKTotal_7) as unreadWKTotal_7 ,sum(unreadWKTotal_6) as unreadWKTotal_6 ,sum(unreadWKTotal_5) as unreadWKTotal_5 ,sum(unreadWKTotal_4) as unreadWKTotal_4 ,sum(unreadWKTotal_3) as unreadWKTotal_3 ,sum(unreadWKTotal_2) as unreadWKTotal_2 ,sum(unreadWKTotal_1) as unreadWKTotal_1 ,sum(unreadWKTotal0) as unreadWKTotal0 ,sum(unreadWKTotal1) as unreadWKTotal1 ,sum(unreadWKTotal2) as unreadWKTotal2 ,sum(unreadWKTotal3) as unreadWKTotal3 ,sum(unreadWKTotal4) as unreadWKTotal4 ,sum(unreadWKTotal5) as unreadWKTotal5 from (select sum(case when tdwk.id>0 then 1 else 0 end) as workTotal ,sum(case when tdwk.`status`>=2 then 1 else 0 end) as enrollTotal ,sum(case when tdwk.`status`=1 then 1 else 0 end) as enrollUnauditTotal ,sum(case when tdwk.`status`=4 then 1 else 0 end) as waitSettledTotal ,sum(case when tdwk.`status`=5 then 1 else 0 end) as settledTotal ,sum(case when tdwk.`status`<0 then 1 else 0 end) as exceptTotal ,sum(case when tdwk.`status`=-1 then 1 else 0 end) as refuseTotal ,sum(case when tdwk.`status`=-3 then 1 else 0 end) as breakoffTotal ,sum(case when tdwk.`status`=-2 then 1 else 0 end) as cancelTotal ,sum(case when tdwk.`status`=-4 then 1 else 0 end) as cancel2Total ,sum(case when (tdwk.`status`=-5 or tdwk.`status`=-8) then 1 else 0 end) as denypayTotal ,sum(case when tdwk.`status`=-6 then 1 else 0 end) as noStartWorkTotal ,sum(case when tdwk.`status`=-7 then 1 else 0 end) as noFinishWorkTotal ,sum(case when (tdwk.`status`=-8 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_8 ,sum(case when (tdwk.`status`=-7 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_7 ,sum(case when (tdwk.`status`=-6 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_6 ,sum(case when (tdwk.`status`=-5 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_5 ,sum(case when (tdwk.`status`=-4 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_4 ,sum(case when (tdwk.`status`=-3 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_3 ,sum(case when (tdwk.`status`=-2 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_2 ,sum(case when (tdwk.`status`=-1 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_1 ,sum(case when (tdwk.`status`=0 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal0 ,sum(case when (tdwk.`status`=1 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal1 ,sum(case when (tdwk.`status`=2 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal2 ,sum(case when (tdwk.`status`=3 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal3 ,sum(case when (tdwk.`status`=4 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal4 ,sum(case when (tdwk.`status`=5 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal5 from biz_todowork tdwk inner join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where btr.biz_traderid=110 group by tdwk.biz_recruitid ) as temp; ["08S01",1053,"Server shutdown in progress"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Server shutdown in progress sql语句: select sum(workTotal) as workTotal, sum(enrollUnauditTotal) as enrollUnauditTotal, sum(enrollTotal) as enrollTotal ,sum(waitSettledTotal) as waitSettledTotal,sum(settledTotal) as settledTotal ,sum(exceptTotal) as exceptTotal ,sum(refuseTotal) as refuseTotal,sum(breakoffTotal) as breakoffTotal ,sum(cancelTotal) as cancelTotal,sum(cancel2Total) as cancel2Total,sum(denypayTotal) as denypayTotal ,sum(noStartWorkTotal) as noStartWorkTotal,sum(noFinishWorkTotal) as noFinishWorkTotal ,sum(unreadWKTotal_8) as unreadWKTotal_8 ,sum(unreadWKTotal_7) as unreadWKTotal_7 ,sum(unreadWKTotal_6) as unreadWKTotal_6 ,sum(unreadWKTotal_5) as unreadWKTotal_5 ,sum(unreadWKTotal_4) as unreadWKTotal_4 ,sum(unreadWKTotal_3) as unreadWKTotal_3 ,sum(unreadWKTotal_2) as unreadWKTotal_2 ,sum(unreadWKTotal_1) as unreadWKTotal_1 ,sum(unreadWKTotal0) as unreadWKTotal0 ,sum(unreadWKTotal1) as unreadWKTotal1 ,sum(unreadWKTotal2) as unreadWKTotal2 ,sum(unreadWKTotal3) as unreadWKTotal3 ,sum(unreadWKTotal4) as unreadWKTotal4 ,sum(unreadWKTotal5) as unreadWKTotal5 from (select sum(case when tdwk.id>0 then 1 else 0 end) as workTotal ,sum(case when tdwk.`status`>=2 then 1 else 0 end) as enrollTotal ,sum(case when tdwk.`status`=1 then 1 else 0 end) as enrollUnauditTotal ,sum(case when tdwk.`status`=4 then 1 else 0 end) as waitSettledTotal ,sum(case when tdwk.`status`=5 then 1 else 0 end) as settledTotal ,sum(case when tdwk.`status`<0 then 1 else 0 end) as exceptTotal ,sum(case when tdwk.`status`=-1 then 1 else 0 end) as refuseTotal ,sum(case when tdwk.`status`=-3 then 1 else 0 end) as breakoffTotal ,sum(case when tdwk.`status`=-2 then 1 else 0 end) as cancelTotal ,sum(case when tdwk.`status`=-4 then 1 else 0 end) as cancel2Total ,sum(case when (tdwk.`status`=-5 or tdwk.`status`=-8) then 1 else 0 end) as denypayTotal ,sum(case when tdwk.`status`=-6 then 1 else 0 end) as noStartWorkTotal ,sum(case when tdwk.`status`=-7 then 1 else 0 end) as noFinishWorkTotal ,sum(case when (tdwk.`status`=-8 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_8 ,sum(case when (tdwk.`status`=-7 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_7 ,sum(case when (tdwk.`status`=-6 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_6 ,sum(case when (tdwk.`status`=-5 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_5 ,sum(case when (tdwk.`status`=-4 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_4 ,sum(case when (tdwk.`status`=-3 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_3 ,sum(case when (tdwk.`status`=-2 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_2 ,sum(case when (tdwk.`status`=-1 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal_1 ,sum(case when (tdwk.`status`=0 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal0 ,sum(case when (tdwk.`status`=1 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal1 ,sum(case when (tdwk.`status`=2 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal2 ,sum(case when (tdwk.`status`=3 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal3 ,sum(case when (tdwk.`status`=4 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal4 ,sum(case when (tdwk.`status`=5 and !FIND_IN_SET(tdwk.`status`, tdwk.trader_readed)) then 1 else 0 end) as unreadWKTotal5 from biz_todowork tdwk inner join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where btr.biz_traderid=110 group by tdwk.biz_recruitid ) as temp; ["08S01",1053,"Server shutdown in progress"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutTrader.php(606): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutTrader.php(110): bizbase_traderStatistics() #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(98): bizbase_traderEntityHandle() #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #6 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Trader [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.26(0x18001a23) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=134 [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]=35887 [REMOTE_ADDR]=106.114.66.146 [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]=134 [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]=1658454248.8219 [REQUEST_TIME]=1658454248 10:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Server shutdown in progress sql语句: select sum(workTotal) as workTotal ,sum(waitEnrollTotal) as waitEnrollTotal,sum(enrollTotal) as enrollTotal ,sum(workingTotal) as workingTotal,sum(waitSettleTotal) as waitSettleTotal ,sum(finishedTotal) as finishedTotal,sum(exceptTotal) as exceptTotal ,sum(refuseTotal) as refuseTotal,sum(breakoffTotal) as breakoffTotal ,sum(cancelTotal) as cancelTotal,sum(cancel2Total) as cancel2Total,sum(denypayTotal) as denypayTotal ,sum(noStartWorkTotal) as noStartWorkTotal,sum(noFinishWorkTotal) as noFinishWorkTotal ,sum(unreadWKTotal_8) as unreadWKTotal_8 ,sum(unreadWKTotal_7) as unreadWKTotal_7 ,sum(unreadWKTotal_6) as unreadWKTotal_6 ,sum(unreadWKTotal_5) as unreadWKTotal_5 ,sum(unreadWKTotal_4) as unreadWKTotal_4 ,sum(unreadWKTotal_3) as unreadWKTotal_3 ,sum(unreadWKTotal_2) as unreadWKTotal_2 ,sum(unreadWKTotal_1) as unreadWKTotal_1 ,sum(unreadWKTotal0) as unreadWKTotal0 ,sum(unreadWKTotal1) as unreadWKTotal1 ,sum(unreadWKTotal2) as unreadWKTotal2 ,sum(unreadWKTotal3) as unreadWKTotal3 ,sum(unreadWKTotal4) as unreadWKTotal4 ,sum(unreadWKTotal5) as unreadWKTotal5 from ( select sum(case when tdwk.id>0 then 1 else 0 end) as workTotal ,sum(case when tdwk.`status`=1 then 1 else 0 end) as waitEnrollTotal ,sum(case when tdwk.`status`>=2 then 1 else 0 end) as enrollTotal ,sum(case when (tdwk.`status`=2 or tdwk.`status`=3) then 1 else 0 end) as workingTotal ,sum(case when tdwk.`status`=4 then 1 else 0 end) as waitSettleTotal ,sum(case when tdwk.`status`>=5 then 1 else 0 end) as finishedTotal ,sum(case when tdwk.`status`<0 then 1 else 0 end) as exceptTotal ,sum(case when tdwk.`status`=-1 then 1 else 0 end) as refuseTotal ,sum(case when tdwk.`status`=-3 then 1 else 0 end) as breakoffTotal ,sum(case when tdwk.`status`=-2 then 1 else 0 end) as cancelTotal ,sum(case when tdwk.`status`=-4 then 1 else 0 end) as cancel2Total ,sum(case when (tdwk.`status`=-5 or tdwk.`status`=-8) then 1 else 0 end) as denypayTotal ,sum(case when tdwk.`status`=-6 then 1 else 0 end) as noStartWorkTotal ,sum(case when tdwk.`status`=-7 then 1 else 0 end) as noFinishWorkTotal ,sum(case when (tdwk.`status`=-8 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_8 ,sum(case when (tdwk.`status`=-7 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_7 ,sum(case when (tdwk.`status`=-6 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_6 ,sum(case when (tdwk.`status`=-5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_5 ,sum(case when (tdwk.`status`=-4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_4 ,sum(case when (tdwk.`status`=-3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_3 ,sum(case when (tdwk.`status`=-2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_2 ,sum(case when (tdwk.`status`=-1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_1 ,sum(case when (tdwk.`status`=0 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal0 ,sum(case when (tdwk.`status`=1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal1 ,sum(case when (tdwk.`status`=2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal2 ,sum(case when (tdwk.`status`=3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal3 ,sum(case when (tdwk.`status`=4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal4 ,sum(case when (tdwk.`status`=5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal5 from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.biz_workerid=317 group by tdwk.biz_recruitid ) as temp ["08S01",1053,"Server shutdown in progress"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[158]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Server shutdown in progress sql语句: select sum(workTotal) as workTotal ,sum(waitEnrollTotal) as waitEnrollTotal,sum(enrollTotal) as enrollTotal ,sum(workingTotal) as workingTotal,sum(waitSettleTotal) as waitSettleTotal ,sum(finishedTotal) as finishedTotal,sum(exceptTotal) as exceptTotal ,sum(refuseTotal) as refuseTotal,sum(breakoffTotal) as breakoffTotal ,sum(cancelTotal) as cancelTotal,sum(cancel2Total) as cancel2Total,sum(denypayTotal) as denypayTotal ,sum(noStartWorkTotal) as noStartWorkTotal,sum(noFinishWorkTotal) as noFinishWorkTotal ,sum(unreadWKTotal_8) as unreadWKTotal_8 ,sum(unreadWKTotal_7) as unreadWKTotal_7 ,sum(unreadWKTotal_6) as unreadWKTotal_6 ,sum(unreadWKTotal_5) as unreadWKTotal_5 ,sum(unreadWKTotal_4) as unreadWKTotal_4 ,sum(unreadWKTotal_3) as unreadWKTotal_3 ,sum(unreadWKTotal_2) as unreadWKTotal_2 ,sum(unreadWKTotal_1) as unreadWKTotal_1 ,sum(unreadWKTotal0) as unreadWKTotal0 ,sum(unreadWKTotal1) as unreadWKTotal1 ,sum(unreadWKTotal2) as unreadWKTotal2 ,sum(unreadWKTotal3) as unreadWKTotal3 ,sum(unreadWKTotal4) as unreadWKTotal4 ,sum(unreadWKTotal5) as unreadWKTotal5 from ( select sum(case when tdwk.id>0 then 1 else 0 end) as workTotal ,sum(case when tdwk.`status`=1 then 1 else 0 end) as waitEnrollTotal ,sum(case when tdwk.`status`>=2 then 1 else 0 end) as enrollTotal ,sum(case when (tdwk.`status`=2 or tdwk.`status`=3) then 1 else 0 end) as workingTotal ,sum(case when tdwk.`status`=4 then 1 else 0 end) as waitSettleTotal ,sum(case when tdwk.`status`>=5 then 1 else 0 end) as finishedTotal ,sum(case when tdwk.`status`<0 then 1 else 0 end) as exceptTotal ,sum(case when tdwk.`status`=-1 then 1 else 0 end) as refuseTotal ,sum(case when tdwk.`status`=-3 then 1 else 0 end) as breakoffTotal ,sum(case when tdwk.`status`=-2 then 1 else 0 end) as cancelTotal ,sum(case when tdwk.`status`=-4 then 1 else 0 end) as cancel2Total ,sum(case when (tdwk.`status`=-5 or tdwk.`status`=-8) then 1 else 0 end) as denypayTotal ,sum(case when tdwk.`status`=-6 then 1 else 0 end) as noStartWorkTotal ,sum(case when tdwk.`status`=-7 then 1 else 0 end) as noFinishWorkTotal ,sum(case when (tdwk.`status`=-8 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_8 ,sum(case when (tdwk.`status`=-7 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_7 ,sum(case when (tdwk.`status`=-6 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_6 ,sum(case when (tdwk.`status`=-5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_5 ,sum(case when (tdwk.`status`=-4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_4 ,sum(case when (tdwk.`status`=-3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_3 ,sum(case when (tdwk.`status`=-2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_2 ,sum(case when (tdwk.`status`=-1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_1 ,sum(case when (tdwk.`status`=0 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal0 ,sum(case when (tdwk.`status`=1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal1 ,sum(case when (tdwk.`status`=2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal2 ,sum(case when (tdwk.`status`=3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal3 ,sum(case when (tdwk.`status`=4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal4 ,sum(case when (tdwk.`status`=5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal5 from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.biz_workerid=317 group by tdwk.biz_recruitid ) as temp ["08S01",1053,"Server shutdown in progress"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(187): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(283): bizbase_workerStatistics() #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(100): bizbase_workerEntityHandle() #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #6 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 10; YAL-AL50 Build/HUAWEIYAL-AL50; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4271 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/5219 MicroMessenger/8.0.24.2180(0x28001895) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=134 [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]=63313 [REMOTE_ADDR]=211.94.233.185 [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=Worker&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=134 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1658455492.5153 [REQUEST_TIME]=1658455492 10:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Server shutdown in progress sql语句: select sum(workTotal) as workTotal ,sum(waitEnrollTotal) as waitEnrollTotal,sum(enrollTotal) as enrollTotal ,sum(workingTotal) as workingTotal,sum(waitSettleTotal) as waitSettleTotal ,sum(finishedTotal) as finishedTotal,sum(exceptTotal) as exceptTotal ,sum(refuseTotal) as refuseTotal,sum(breakoffTotal) as breakoffTotal ,sum(cancelTotal) as cancelTotal,sum(cancel2Total) as cancel2Total,sum(denypayTotal) as denypayTotal ,sum(noStartWorkTotal) as noStartWorkTotal,sum(noFinishWorkTotal) as noFinishWorkTotal ,sum(unreadWKTotal_8) as unreadWKTotal_8 ,sum(unreadWKTotal_7) as unreadWKTotal_7 ,sum(unreadWKTotal_6) as unreadWKTotal_6 ,sum(unreadWKTotal_5) as unreadWKTotal_5 ,sum(unreadWKTotal_4) as unreadWKTotal_4 ,sum(unreadWKTotal_3) as unreadWKTotal_3 ,sum(unreadWKTotal_2) as unreadWKTotal_2 ,sum(unreadWKTotal_1) as unreadWKTotal_1 ,sum(unreadWKTotal0) as unreadWKTotal0 ,sum(unreadWKTotal1) as unreadWKTotal1 ,sum(unreadWKTotal2) as unreadWKTotal2 ,sum(unreadWKTotal3) as unreadWKTotal3 ,sum(unreadWKTotal4) as unreadWKTotal4 ,sum(unreadWKTotal5) as unreadWKTotal5 from ( select sum(case when tdwk.id>0 then 1 else 0 end) as workTotal ,sum(case when tdwk.`status`=1 then 1 else 0 end) as waitEnrollTotal ,sum(case when tdwk.`status`>=2 then 1 else 0 end) as enrollTotal ,sum(case when (tdwk.`status`=2 or tdwk.`status`=3) then 1 else 0 end) as workingTotal ,sum(case when tdwk.`status`=4 then 1 else 0 end) as waitSettleTotal ,sum(case when tdwk.`status`>=5 then 1 else 0 end) as finishedTotal ,sum(case when tdwk.`status`<0 then 1 else 0 end) as exceptTotal ,sum(case when tdwk.`status`=-1 then 1 else 0 end) as refuseTotal ,sum(case when tdwk.`status`=-3 then 1 else 0 end) as breakoffTotal ,sum(case when tdwk.`status`=-2 then 1 else 0 end) as cancelTotal ,sum(case when tdwk.`status`=-4 then 1 else 0 end) as cancel2Total ,sum(case when (tdwk.`status`=-5 or tdwk.`status`=-8) then 1 else 0 end) as denypayTotal ,sum(case when tdwk.`status`=-6 then 1 else 0 end) as noStartWorkTotal ,sum(case when tdwk.`status`=-7 then 1 else 0 end) as noFinishWorkTotal ,sum(case when (tdwk.`status`=-8 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_8 ,sum(case when (tdwk.`status`=-7 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_7 ,sum(case when (tdwk.`status`=-6 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_6 ,sum(case when (tdwk.`status`=-5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_5 ,sum(case when (tdwk.`status`=-4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_4 ,sum(case when (tdwk.`status`=-3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_3 ,sum(case when (tdwk.`status`=-2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_2 ,sum(case when (tdwk.`status`=-1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_1 ,sum(case when (tdwk.`status`=0 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal0 ,sum(case when (tdwk.`status`=1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal1 ,sum(case when (tdwk.`status`=2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal2 ,sum(case when (tdwk.`status`=3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal3 ,sum(case when (tdwk.`status`=4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal4 ,sum(case when (tdwk.`status`=5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal5 from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.biz_workerid=313 group by tdwk.biz_recruitid ) as temp ["08S01",1053,"Server shutdown in progress"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[158]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Server shutdown in progress sql语句: select sum(workTotal) as workTotal ,sum(waitEnrollTotal) as waitEnrollTotal,sum(enrollTotal) as enrollTotal ,sum(workingTotal) as workingTotal,sum(waitSettleTotal) as waitSettleTotal ,sum(finishedTotal) as finishedTotal,sum(exceptTotal) as exceptTotal ,sum(refuseTotal) as refuseTotal,sum(breakoffTotal) as breakoffTotal ,sum(cancelTotal) as cancelTotal,sum(cancel2Total) as cancel2Total,sum(denypayTotal) as denypayTotal ,sum(noStartWorkTotal) as noStartWorkTotal,sum(noFinishWorkTotal) as noFinishWorkTotal ,sum(unreadWKTotal_8) as unreadWKTotal_8 ,sum(unreadWKTotal_7) as unreadWKTotal_7 ,sum(unreadWKTotal_6) as unreadWKTotal_6 ,sum(unreadWKTotal_5) as unreadWKTotal_5 ,sum(unreadWKTotal_4) as unreadWKTotal_4 ,sum(unreadWKTotal_3) as unreadWKTotal_3 ,sum(unreadWKTotal_2) as unreadWKTotal_2 ,sum(unreadWKTotal_1) as unreadWKTotal_1 ,sum(unreadWKTotal0) as unreadWKTotal0 ,sum(unreadWKTotal1) as unreadWKTotal1 ,sum(unreadWKTotal2) as unreadWKTotal2 ,sum(unreadWKTotal3) as unreadWKTotal3 ,sum(unreadWKTotal4) as unreadWKTotal4 ,sum(unreadWKTotal5) as unreadWKTotal5 from ( select sum(case when tdwk.id>0 then 1 else 0 end) as workTotal ,sum(case when tdwk.`status`=1 then 1 else 0 end) as waitEnrollTotal ,sum(case when tdwk.`status`>=2 then 1 else 0 end) as enrollTotal ,sum(case when (tdwk.`status`=2 or tdwk.`status`=3) then 1 else 0 end) as workingTotal ,sum(case when tdwk.`status`=4 then 1 else 0 end) as waitSettleTotal ,sum(case when tdwk.`status`>=5 then 1 else 0 end) as finishedTotal ,sum(case when tdwk.`status`<0 then 1 else 0 end) as exceptTotal ,sum(case when tdwk.`status`=-1 then 1 else 0 end) as refuseTotal ,sum(case when tdwk.`status`=-3 then 1 else 0 end) as breakoffTotal ,sum(case when tdwk.`status`=-2 then 1 else 0 end) as cancelTotal ,sum(case when tdwk.`status`=-4 then 1 else 0 end) as cancel2Total ,sum(case when (tdwk.`status`=-5 or tdwk.`status`=-8) then 1 else 0 end) as denypayTotal ,sum(case when tdwk.`status`=-6 then 1 else 0 end) as noStartWorkTotal ,sum(case when tdwk.`status`=-7 then 1 else 0 end) as noFinishWorkTotal ,sum(case when (tdwk.`status`=-8 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_8 ,sum(case when (tdwk.`status`=-7 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_7 ,sum(case when (tdwk.`status`=-6 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_6 ,sum(case when (tdwk.`status`=-5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_5 ,sum(case when (tdwk.`status`=-4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_4 ,sum(case when (tdwk.`status`=-3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_3 ,sum(case when (tdwk.`status`=-2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_2 ,sum(case when (tdwk.`status`=-1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal_1 ,sum(case when (tdwk.`status`=0 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal0 ,sum(case when (tdwk.`status`=1 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal1 ,sum(case when (tdwk.`status`=2 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal2 ,sum(case when (tdwk.`status`=3 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal3 ,sum(case when (tdwk.`status`=4 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal4 ,sum(case when (tdwk.`status`=5 and !FIND_IN_SET(tdwk.`status`, tdwk.worker_readed)) then 1 else 0 end) as unreadWKTotal5 from biz_todowork tdwk left join biz_trader_recruit btr on btr.id=tdwk.biz_recruitid where tdwk.biz_workerid=313 group by tdwk.biz_recruitid ) as temp ["08S01",1053,"Server shutdown in progress"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch() #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(187): pdo_fetch() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(283): bizbase_workerStatistics() #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(100): bizbase_workerEntityHandle() #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #6 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_USER_AGENT]=Mozilla/5.0 (iPhone; CPU iPhone OS 14_8_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.26(0x18001a23) NetType/WIFI Language/zh_CN [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_CONTENT_LENGTH]=134 [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]=35816 [REMOTE_ADDR]=106.114.66.146 [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=Worker&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=134 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1658454204.2933 [REQUEST_TIME]=1658454204