spawn ssh -o StrictHostKeyChecking=no opsuser@8.147.119.215 sudo -S -i bash -lc 'echo ==zhct-mq==; obclient -h127.0.0.1 -P2883 -uzhct_user@sys#city_subcenter_ob -p<redacted> -D zhct_csfzx -N -e "SELECT \"paired_equipment\",COUNT(*) FROM ydy_equipment WHERE del_flag=0 AND mate_flag=1; SELECT type,COUNT(*) cnt FROM ydy_equipment WHERE del_flag=0 AND mate_flag=1 GROUP BY type ORDER BY type; SELECT \"mq_message_for_test_staff\",COUNT(*) FROM ydy_mq_message WHERE staff_uuid IN (SELECT uuid FROM ydy_staff WHERE personnel_umber LIKE \"CSFZX_TEST_USER_%\"); SELECT type,COUNT(*) cnt FROM ydy_mq_message WHERE staff_uuid IN (SELECT uuid FROM ydy_staff WHERE personnel_umber LIKE \"CSFZX_TEST_USER_%\") GROUP BY type ORDER BY type; SELECT \"mq_log_after_import\",COUNT(*) FROM ydy_mq_message_log WHERE create_time >= \"2026-06-22 15:08:00\"; SELECT type,COUNT(*) cnt FROM ydy_mq_message_log WHERE create_time >= \"2026-06-22 15:08:00\" GROUP BY type ORDER BY type;"; echo ==ai-count==; obclient -h127.0.0.1 -P2883 -uzhct_user@sys#city_subcenter_ob -p<redacted> -D aizhct_csfzx -N -e "SELECT COUNT(*) FROM yoshop_user WHERE zhct_user_id IN (SELECT id FROM zhct_csfzx.ydy_user WHERE staff_uuid IN (SELECT uuid FROM zhct_csfzx.ydy_staff WHERE personnel_umber LIKE \"CSFZX_TEST_USER_%\"));"; echo ==logs==; grep -R "暂无在线的设备(card)|暂无在线的设备|推送卡片状态变更消息失败|AIApi|AI同步|syncAi|Connection refused|8081" -n /workspace/wwwroot/zhct_csfzx/project/runtime/log 2>/dev/null | tail -120; echo ==php-nginx-log==; tail -120 /workspace/wwwlogs/zhctcsfzx.yyangpt.cn.error.log 2>/dev/null || true; tail -120 /workspace/wwwlogs/zhct_csfzx.error.log 2>/dev/null || true'

opsuser@8.147.119.215's password:
[sudo] password for opsuser: <redacted>
==zhct-mq==
paired_equipment	0
mq_message_for_test_staff	0
mq_log_after_import	0
==ai-count==
==logs==
ERROR 1054 (42S22) at line 1: Unknown column 'zhct_user_id' in 'where clause'
==php-nginx-log==
Env-Version: develop
H-B: zhct
H-C: 10000
Platform: MP-WEIXIN
Referer: https://servicewechat.com/wxb4e2e1480798187c/devtools/page-frame.html
Version: 2.0.51

"
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http cleanup add: 0000AAAACCF2C1F0
2026/06/22 15:17:08 [debug] 1604145#0: *4391 get rr peer, try: 1
2026/06/22 15:17:08 [debug] 1604145#0: *4391 stream socket 17
2026/06/22 15:17:08 [debug] 1604145#0: *4391 epoll add connection: fd:17 ev:80002005
2026/06/22 15:17:08 [debug] 1604145#0: *4391 connect to 127.0.0.1:8081, fd:17 #4395
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http upstream connect: -2
2026/06/22 15:17:08 [debug] 1604145#0: *4391 posix_memalign: 0000AAAACCEDC0F0:128 @16
2026/06/22 15:17:08 [debug] 1604145#0: *4391 event timer add: 17: 60000:972870145
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http finalize request: -4, "/index.php?s=/api/user/info" a:1, c:2
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http request count:2 blk:0
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http run request: "/index.php?s=/api/user/info"
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http upstream check client, write event:1, "/index.php"
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http upstream request: "/index.php?s=/api/user/info"
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http upstream send request handler
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http upstream send request
2026/06/22 15:17:08 [debug] 1604145#0: *4391 http upstream send request body
2026/06/22 15:17:08 [debug] 1604145#0: *4391 chain writer buf fl:1 s:781
2026/06/22 15:17:08 [debug] 1604145#0: *4391 chain writer in: 0000AAAACCF2C240
2026/06/22 15:17:08 [debug] 1604145#0: *4391 writev: 781 of 781
2026/06/22 15:17:08 [debug] 1604145#0: *4391 chain writer out: 0000000000000000
2026/06/22 15:17:08 [debug] 1604145#0: *4391 event timer del: 17: 972870145
2026/06/22 15:17:08 [debug] 1604145#0: *4391 event timer add: 17: 60000:972870145
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream request: "/index.php?s=/api/user/info"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream process header
2026/06/22 15:17:24 [debug] 1604145#0: *4391 malloc: 0000AAAACCF2C270:4096
2026/06/22 15:17:24 [debug] 1604145#0: *4391 posix_memalign: 0000AAAACCFB8B80:4096 @16
2026/06/22 15:17:24 [debug] 1604145#0: *4391 recv: eof:0, avail:-1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 recv: fd:17 175 of 4096
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http proxy status 500 "500 Internal Server Error"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http proxy header: "Server: nginx"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http proxy header: "Date: Mon, 22 Jun 2026 07:17:24 GMT"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http proxy header: "Content-Type: text/html; charset=UTF-8"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http proxy header: "Connection: close"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http proxy header: "X-Powered-By: PHP/7.4.33"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http proxy header done
2026/06/22 15:17:24 [debug] 1604145#0: *4391 HTTP/1.1 500 Internal Server Error
Server: nginx
Date: Mon, 22 Jun 2026 07:17:24 GMT
Content-Type: text/html; charset=UTF-8
Transfer-Encoding: chunked
Connection: keep-alive
X-Powered-By: PHP/7.4.33

2026/06/22 15:17:24 [debug] 1604145#0: *4391 write new buf t:1 f:0 0000AAAACCFB8F00, pos 0000AAAACCFB8F00, size: 208 file: 0, size: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http write filter: l:0 f:0 s:208
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http cacheable: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http proxy filter init s:500 h:0 c:0 l:-1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream process upstream
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe read upstream: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe preread: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe buf free s:0 t:1 f:0 0000AAAACCF2C270, pos 0000AAAACCF2C31F, size: 0 file: 0, size: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe length: -1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 event timer del: 17: 972870145
2026/06/22 15:17:24 [debug] 1604145#0: *4391 event timer add: 17: 60000:972886898
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream request: "/index.php?s=/api/user/info"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream dummy handler
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream request: "/index.php?s=/api/user/info"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream process upstream
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe read upstream: 1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 readv: eof:1, avail:-1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 readv: 1, last:3921
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe recv chain: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe buf free s:0 t:1 f:0 0000AAAACCF2C270, pos 0000AAAACCF2C31F, size: 0 file: 0, size: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe length: -1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe write downstream: 1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 pipe write downstream done
2026/06/22 15:17:24 [debug] 1604145#0: *4391 event timer: 17, old: 972886898, new: 972886899
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream exit: 0000000000000000
2026/06/22 15:17:24 [debug] 1604145#0: *4391 finalize http upstream request: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 finalize http proxy request
2026/06/22 15:17:24 [debug] 1604145#0: *4391 free rr peer 1 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 close http upstream connection: 17
2026/06/22 15:17:24 [debug] 1604145#0: *4391 free: 0000AAAACCEDC0F0, unused: 48
2026/06/22 15:17:24 [debug] 1604145#0: *4391 event timer del: 17: 972886898
2026/06/22 15:17:24 [debug] 1604145#0: *4391 reusable connection: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http upstream temp fd: -1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http output filter "/index.php?s=/api/user/info"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http copy filter: "/index.php?s=/api/user/info"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http postpone filter "/index.php?s=/api/user/info" 0000FFFFCD95B198
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http chunk: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 write old buf t:1 f:0 0000AAAACCFB8F00, pos 0000AAAACCFB8F00, size: 208 file: 0, size: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 write new buf t:0 f:0 0000000000000000, pos 0000AAAAB1EE1EA2, size: 5 file: 0, size: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http write filter: l:1 f:0 s:213
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http write filter limit 524288
2026/06/22 15:17:24 [debug] 1604145#0: *4391 writev: 213 of 213
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http write filter 0000000000000000
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http copy filter: 0 "/index.php?s=/api/user/info"
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http finalize request: 0, "/index.php?s=/api/user/info" a:1, c:1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 set http keepalive handler
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http close request
2026/06/22 15:17:24 [debug] 1604145#0: *4391 http log handler
2026/06/22 15:17:24 [debug] 1604145#0: *4391 free: 0000AAAACCF2C270
2026/06/22 15:17:24 [debug] 1604145#0: *4391 free: 0000AAAACCF2A250, unused: 8
2026/06/22 15:17:24 [debug] 1604145#0: *4391 free: 0000AAAACCF2B260, unused: 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 free: 0000AAAACCFB8B80, unused: 1850
2026/06/22 15:17:24 [debug] 1604145#0: *4391 free: 0000AAAACCF22240
2026/06/22 15:17:24 [debug] 1604145#0: *4391 hc free: 0000000000000000
2026/06/22 15:17:24 [debug] 1604145#0: *4391 hc busy: 0000000000000000 0
2026/06/22 15:17:24 [debug] 1604145#0: *4391 reusable connection: 1
2026/06/22 15:17:24 [debug] 1604145#0: *4391 event timer add: 16: 60000:972886899
2026/06/22 15:18:08 [debug] 1604144#0: *4328 event timer del: 35: 972870084
2026/06/22 15:18:08 [debug] 1604144#0: *4328 http keepalive handler
2026/06/22 15:18:08 [debug] 1604144#0: *4328 close http connection: 35
2026/06/22 15:18:08 [debug] 1604144#0: *4328 reusable connection: 0
2026/06/22 15:18:08 [debug] 1604144#0: *4328 free: 0000000000000000
2026/06/22 15:18:08 [debug] 1604144#0: *4328 free: 0000AAAACCEDEF20, unused: 128
2026/06/22 15:18:24 [debug] 1604145#0: *4391 event timer del: 16: 972886899
2026/06/22 15:18:24 [debug] 1604145#0: *4391 http keepalive handler
2026/06/22 15:18:24 [debug] 1604145#0: *4391 close http connection: 16
2026/06/22 15:18:24 [debug] 1604145#0: *4391 reusable connection: 0
2026/06/22 15:18:24 [debug] 1604145#0: *4391 free: 0000000000000000
2026/06/22 15:18:24 [debug] 1604145#0: *4391 free: 0000AAAACCEC19B0, unused: 128