spawn ssh -o StrictHostKeyChecking=no opsuser@8.147.119.215 sudo -S -i bash -lc 'obclient -h127.0.0.1 -P2883 -uzhct_user@sys#city_subcenter_ob -p -D zhct_csfzx -N -e "SELECT config_key,config_value FROM ydy_config WHERE config_key IN (\"ai_sync_switch\",\"ai_api_host\",\"ali_mqtt_disjunctor\",\"ali_mqtt_endPoint\"); SELECT COUNT(*) staff_total, SUM(ai_user_id>0) staff_ai_synced, SUM(ai_user_id=0) staff_ai_zero FROM ydy_staff WHERE personnel_umber LIKE \"CSFZX_TEST_USER_%\"; SELECT COUNT(*) user_total, SUM(ai_user_id>0) user_ai_synced, SUM(ai_user_id=0) user_ai_zero FROM ydy_user WHERE staff_uuid IN (SELECT uuid FROM ydy_staff WHERE personnel_umber LIKE \"CSFZX_TEST_USER_%\"); SELECT COUNT(*) card_total FROM ydy_staff_card WHERE staff_uuid IN (SELECT uuid FROM ydy_staff WHERE personnel_umber LIKE \"CSFZX_TEST_USER_%\") AND is_delete=0; SELECT COUNT(*) card_log_total FROM ydy_staff_card_log WHERE staff_uuid IN (SELECT uuid FROM ydy_staff WHERE personnel_umber LIKE \"CSFZX_TEST_USER_%\"); SELECT type,COUNT(*) cnt FROM ydy_equipment WHERE del_flag=0 AND mate_flag=1 GROUP BY type ORDER BY type; 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 type,COUNT(*) cnt FROM ydy_mq_message_log WHERE create_time >= \"2026-06-22 15:08:00\" GROUP BY type ORDER BY type;"; obclient -h127.0.0.1 -P2883 -uzhct_user@sys#city_subcenter_ob -p -D aizhct_csfzx -N -e "SHOW TABLES LIKE \"%user%\"; 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_%\")) 2>/dev/null || true;"; grep -R "暂无在线的设备(card)|推送卡片状态变更消息失败|AI|syncAi" -n /workspace/wwwroot/zhct_csfzx/project/runtime/log 2>/dev/null | tail -80' opsuser@8.147.119.215's password: [sudo] password for opsuser: ai_api_host http://8.147.119.215:8081 ai_sync_switch 1 ali_mqtt_disjunctor 1 ali_mqtt_endPoint 8.147.119.215 1500 0 1500 1500 0 1500 1500 1500 yoshop_admin_user yoshop_ai_user_identity yoshop_bank_user_relation yoshop_sign_user yoshop_staff_store_user yoshop_store_user yoshop_store_user_relation yoshop_store_user_role yoshop_user yoshop_user_address yoshop_user_balance_log yoshop_user_bind yoshop_user_coupon yoshop_user_course yoshop_user_disease yoshop_user_feedback yoshop_user_grade yoshop_user_grade_log yoshop_user_health_kit yoshop_user_motion yoshop_user_oauth yoshop_user_other_info yoshop_user_points_log yoshop_user_score yoshop_user_score_log yoshop_user_sport_energy yoshop_user_sport_item yoshop_user_sport_target yoshop_user_subsidy yoshop_user_subsidy_log yoshop_user_subsidy_used yoshop_user_weight yoshop_user_weight_status ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near '2>/dev/null || true' at line 1