2022072210_entityDataHandle.log 43 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229
  1. 10:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Server shutdown in progress
  2. 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
  3. ["08S01",1053,"Server shutdown in progress"]
  4. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[158]行 code[0] !
  5. 异常堆栈上下文:
  6. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  7. #1 {main}
  8. 数据库执行异常:Server shutdown in progress
  9. 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
  10. ["08S01",1053,"Server shutdown in progress"]
  11. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  12. 异常堆栈上下文:
  13. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  14. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  15. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(187): pdo_fetch()
  16. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(283): bizbase_workerStatistics()
  17. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(100): bizbase_workerEntityHandle()
  18. #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  19. #6 {main}
  20. [上下文相关信息]:
  21. [WsAjaxPrj]=KLY
  22. [WsAjaxBiz]=Worker
  23. [WsAjaxAction]=entityDataHandle
  24. [USER]=nginxphp
  25. [HOME]=/home/nginxphp
  26. [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html
  27. [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
  28. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  29. [HTTP_CONTENT_TYPE]=application/json
  30. [HTTP_CONTENT_LENGTH]=134
  31. [HTTP_CONNECTION]=keep-alive
  32. [HTTP_HOST]=api.kuailaiyou.top
  33. [REDIRECT_STATUS]=200
  34. [SERVER_NAME]=api.kuailaiyou.top
  35. [SERVER_PORT]=443
  36. [SERVER_ADDR]=172.18.217.149
  37. [REMOTE_PORT]=35774
  38. [REMOTE_ADDR]=106.114.66.146
  39. [SERVER_SOFTWARE]=nginx/1.20.1
  40. [GATEWAY_INTERFACE]=CGI/1.1
  41. [HTTPS]=on
  42. [REQUEST_SCHEME]=https
  43. [SERVER_PROTOCOL]=HTTP/1.1
  44. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  45. [DOCUMENT_URI]=/ajaxEntryCenter.php
  46. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  47. [SCRIPT_NAME]=/ajaxEntryCenter.php
  48. [CONTENT_LENGTH]=134
  49. [CONTENT_TYPE]=application/json
  50. [REQUEST_METHOD]=POST
  51. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  52. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  53. [FCGI_ROLE]=RESPONDER
  54. [PHP_SELF]=/ajaxEntryCenter.php
  55. [REQUEST_TIME_FLOAT]=1658454196.0085
  56. [REQUEST_TIME]=1658454196
  57. 10:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Server shutdown in progress
  58. 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;
  59. ["08S01",1053,"Server shutdown in progress"]
  60. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] !
  61. 异常堆栈上下文:
  62. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  63. #1 {main}
  64. 数据库执行异常:Server shutdown in progress
  65. 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;
  66. ["08S01",1053,"Server shutdown in progress"]
  67. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  68. 异常堆栈上下文:
  69. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  70. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  71. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutTrader.php(606): pdo_fetch()
  72. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutTrader.php(110): bizbase_traderStatistics()
  73. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(98): bizbase_traderEntityHandle()
  74. #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  75. #6 {main}
  76. [上下文相关信息]:
  77. [WsAjaxPrj]=KLY
  78. [WsAjaxBiz]=Trader
  79. [WsAjaxAction]=entityDataHandle
  80. [USER]=nginxphp
  81. [HOME]=/home/nginxphp
  82. [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/0/page-frame.html
  83. [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
  84. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  85. [HTTP_CONTENT_TYPE]=application/json
  86. [HTTP_CONTENT_LENGTH]=134
  87. [HTTP_CONNECTION]=keep-alive
  88. [HTTP_HOST]=api.kuailaiyou.top
  89. [REDIRECT_STATUS]=200
  90. [SERVER_NAME]=api.kuailaiyou.top
  91. [SERVER_PORT]=443
  92. [SERVER_ADDR]=172.18.217.149
  93. [REMOTE_PORT]=35887
  94. [REMOTE_ADDR]=106.114.66.146
  95. [SERVER_SOFTWARE]=nginx/1.20.1
  96. [GATEWAY_INTERFACE]=CGI/1.1
  97. [HTTPS]=on
  98. [REQUEST_SCHEME]=https
  99. [SERVER_PROTOCOL]=HTTP/1.1
  100. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  101. [DOCUMENT_URI]=/ajaxEntryCenter.php
  102. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  103. [SCRIPT_NAME]=/ajaxEntryCenter.php
  104. [CONTENT_LENGTH]=134
  105. [CONTENT_TYPE]=application/json
  106. [REQUEST_METHOD]=POST
  107. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle
  108. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  109. [FCGI_ROLE]=RESPONDER
  110. [PHP_SELF]=/ajaxEntryCenter.php
  111. [REQUEST_TIME_FLOAT]=1658454248.8219
  112. [REQUEST_TIME]=1658454248
  113. 10:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Server shutdown in progress
  114. 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
  115. ["08S01",1053,"Server shutdown in progress"]
  116. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[158]行 code[0] !
  117. 异常堆栈上下文:
  118. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  119. #1 {main}
  120. 数据库执行异常:Server shutdown in progress
  121. 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
  122. ["08S01",1053,"Server shutdown in progress"]
  123. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  124. 异常堆栈上下文:
  125. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  126. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  127. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(187): pdo_fetch()
  128. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(283): bizbase_workerStatistics()
  129. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(100): bizbase_workerEntityHandle()
  130. #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  131. #6 {main}
  132. [上下文相关信息]:
  133. [WsAjaxPrj]=KLY
  134. [WsAjaxBiz]=Worker
  135. [WsAjaxAction]=entityDataHandle
  136. [USER]=nginxphp
  137. [HOME]=/home/nginxphp
  138. [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html
  139. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  140. [HTTP_CONTENT_TYPE]=application/json
  141. [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
  142. [HTTP_CHARSET]=utf-8
  143. [HTTP_CONTENT_LENGTH]=134
  144. [HTTP_CONNECTION]=keep-alive
  145. [HTTP_HOST]=api.kuailaiyou.top
  146. [REDIRECT_STATUS]=200
  147. [SERVER_NAME]=api.kuailaiyou.top
  148. [SERVER_PORT]=443
  149. [SERVER_ADDR]=172.18.217.149
  150. [REMOTE_PORT]=63313
  151. [REMOTE_ADDR]=211.94.233.185
  152. [SERVER_SOFTWARE]=nginx/1.20.1
  153. [GATEWAY_INTERFACE]=CGI/1.1
  154. [HTTPS]=on
  155. [REQUEST_SCHEME]=https
  156. [SERVER_PROTOCOL]=HTTP/1.1
  157. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  158. [DOCUMENT_URI]=/ajaxEntryCenter.php
  159. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  160. [SCRIPT_NAME]=/ajaxEntryCenter.php
  161. [CONTENT_LENGTH]=134
  162. [CONTENT_TYPE]=application/json
  163. [REQUEST_METHOD]=POST
  164. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  165. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  166. [FCGI_ROLE]=RESPONDER
  167. [PHP_SELF]=/ajaxEntryCenter.php
  168. [REQUEST_TIME_FLOAT]=1658455492.5153
  169. [REQUEST_TIME]=1658455492
  170. 10:11:47 [error]: 通用的实体数据存取接口异常:数据库执行异常:Server shutdown in progress
  171. 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
  172. ["08S01",1053,"Server shutdown in progress"]
  173. 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[158]行 code[0] !
  174. 异常堆栈上下文:
  175. #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once()
  176. #1 {main}
  177. 数据库执行异常:Server shutdown in progress
  178. 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
  179. ["08S01",1053,"Server shutdown in progress"]
  180. 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] !
  181. 异常堆栈上下文:
  182. #0 /bizroot/approot/klywebapi/base/mysql.php(195): PdoUtil->errhandle()
  183. #1 /bizroot/approot/klywebapi/base/mysql.php(23): PdoUtil->fetch()
  184. #2 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(187): pdo_fetch()
  185. #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutWorker.php(283): bizbase_workerStatistics()
  186. #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(100): bizbase_workerEntityHandle()
  187. #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...')
  188. #6 {main}
  189. [上下文相关信息]:
  190. [WsAjaxPrj]=KLY
  191. [WsAjaxBiz]=Worker
  192. [WsAjaxAction]=entityDataHandle
  193. [USER]=nginxphp
  194. [HOME]=/home/nginxphp
  195. [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html
  196. [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
  197. [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate
  198. [HTTP_CONTENT_TYPE]=application/json
  199. [HTTP_CONTENT_LENGTH]=134
  200. [HTTP_CONNECTION]=keep-alive
  201. [HTTP_HOST]=api.kuailaiyou.top
  202. [REDIRECT_STATUS]=200
  203. [SERVER_NAME]=api.kuailaiyou.top
  204. [SERVER_PORT]=443
  205. [SERVER_ADDR]=172.18.217.149
  206. [REMOTE_PORT]=35816
  207. [REMOTE_ADDR]=106.114.66.146
  208. [SERVER_SOFTWARE]=nginx/1.20.1
  209. [GATEWAY_INTERFACE]=CGI/1.1
  210. [HTTPS]=on
  211. [REQUEST_SCHEME]=https
  212. [SERVER_PROTOCOL]=HTTP/1.1
  213. [DOCUMENT_ROOT]=/bizroot/approot/klywebapi
  214. [DOCUMENT_URI]=/ajaxEntryCenter.php
  215. [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  216. [SCRIPT_NAME]=/ajaxEntryCenter.php
  217. [CONTENT_LENGTH]=134
  218. [CONTENT_TYPE]=application/json
  219. [REQUEST_METHOD]=POST
  220. [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle
  221. [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php
  222. [FCGI_ROLE]=RESPONDER
  223. [PHP_SELF]=/ajaxEntryCenter.php
  224. [REQUEST_TIME_FLOAT]=1658454204.2933
  225. [REQUEST_TIME]=1658454204