spawn ssh -o StrictHostKeyChecking=no opsuser@8.147.119.215 su - root -c 'echo msg_count; grep -c " MSG " /tmp/csfzx_mqtt_60_sim_messages.log || true; echo first_msgs; grep " MSG " /tmp/csfzx_mqtt_60_sim_messages.log | head -5 || true; echo last_msgs; grep " MSG " /tmp/csfzx_mqtt_60_sim_messages.log | tail -5 || true; echo db_counts; mysql -h127.0.0.1 -P2883 -u"zhct_user@sys#city_subcenter_ob" -p"Zhct_OB_20260615" -N -B -e "SELECT type,status,COUNT(*) FROM zhct_csfzx.ydy_mq_message WHERE receive_device_id LIKE '''CSFZX460%''' GROUP BY type,status;"'

opsuser@8.147.119.215's password:
Password: T8bN!3vGx$6jHy%1c
msg_count
60
first_msgs
2026-06-22 18:15:08 MSG CSFZX460001 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460001 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"AA73F1A1-B2BE-376C-9781-574CDD3FF821","name":"日式姜片 (粉）","file_path":"http://8.147.119.215:8080/static/upload/cater/20230208/4AD0D026-6876-8392-0E78-CB9D8C5551D5.png","category":7,"category_name":"调味品及其他"}}],"msg_uuid":"D9B8388D-6926-8F62-1C7D-0D36DE6B5654"}
2026-06-22 18:15:08 MSG CSFZX460002 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460002 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"C255181D-AEE0-EBC3-C319-75182A2D968E","name":"骨肉相连","file_path":"http://8.147.119.215:8080/static/upload/cater/20230207/75FD2EDD-F7A3-0B77-E44A-22F988AB9589.jpg","category":3,"category_name":"荤菜"}}],"msg_uuid":"3EABA87D-4BF5-A9A5-884B-648FC2E72330"}
2026-06-22 18:15:08 MSG CSFZX460003 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460003 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"83A76F46-1407-66CE-9117-07394F813790","name":"鲮鱼油麦","file_path":"http://8.147.119.215:8080/static/upload/cater/20221219/94F904D3-FAB4-BA2C-7B0B-D2D567F56D6A.png","category":3,"category_name":"荤菜"}}],"msg_uuid":"46BC098F-B3E1-4657-8F06-4D81F441507D"}
2026-06-22 18:15:08 MSG CSFZX460004 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460004 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"94BE12B8-9253-4906-CCB1-1E6B1185AF3D","name":"避风塘炒虾","file_path":"http://8.147.119.215:8080/static/upload/cater/20221219/198A4E92-F64D-D086-C057-1927B72FB92E.png","category":3,"category_name":"荤菜"}}],"msg_uuid":"4AF036B0-5E5C-EB5F-DA68-1D0F56343B8D"}
2026-06-22 18:15:08 MSG CSFZX460005 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460005 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"75A89EE1-15AB-C4DA-FB20-0E23ED6151A1","name":"黄瓜炒蛋","file_path":"http://8.147.119.215:8080/static/upload/cater/20230130/EFA93D6B-BCAC-91A4-1715-3F3EE8BFE11C.JPG","category":3,"category_name":"荤菜"}}],"msg_uuid":"0BD32D59-8674-B5EA-014E-E1CC1AFEE719"}
last_msgs
2026-06-22 18:15:12 MSG CSFZX460056 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460056 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"FE952FC3-85D0-B9BB-8887-88F1C81BF12B","name":"黑胡椒肉柳","file_path":"http://8.147.119.215:8080/static/upload/cater/20250303/14041C81-D3D6-5E9D-3D53-0FF9B5A39BB7黑胡椒肉柳.jpg","category":3,"category_name":"荤菜"}}],"msg_uuid":"8277B663-4750-3D35-B7F2-791260996912"}
2026-06-22 18:15:13 MSG CSFZX460057 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460057 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"52C5D415-25B2-627A-7F25-E0FFE9F98751","name":"蒸玉米","file_path":"http://8.147.119.215:8080/static/upload/cater/20230117/34EBD02F-3FCC-7C2F-00EA-27EA80CD6FD7.png","category":1,"category_name":"主食"}}],"msg_uuid":"ECE0F492-5E0E-F31A-B891-B065EC71691D"}
2026-06-22 18:15:13 MSG CSFZX460058 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460058 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"BE9BA1C3-4F0E-A400-5DA9-8635D3E6356F","name":"葱香清远鸡","file_path":"http://8.147.119.215:8080/static/upload/cater/20221219/87FAABFC-F4A9-9455-6782-36F9F2FE7776.png","category":3,"category_name":"荤菜"}}],"msg_uuid":"666B23AB-58FD-515C-9B9F-DBDE652D8189"}
2026-06-22 18:15:13 MSG CSFZX460059 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460059 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"FC2C5C92-E73D-0065-8065-74AC5089111D","name":"猪肉炖粉条","file_path":"http://8.147.119.215:8080/static/upload/cater/20230207/1D7ECEB0-8E79-CE3C-6DF2-6D759DB00490.jpg","category":3,"category_name":"荤菜"}}],"msg_uuid":"CB2CE21A-3045-7A92-345E-703E8E3D8E89"}
2026-06-22 18:15:13 MSG CSFZX460060 topic=zhct_csfzx/p2p/GID_zhct_csfzx@@@CSFZX460060 payload={"type":2,"dishes":[{"position":1,"dishinfo":{"uuid":"AE17E2D3-889C-A36E-06AD-EA4DBFF24FDA","name":"西红柿炖牛腩","file_path":"http://8.147.119.215:8080/static/upload/cater/20230207/F4179693-F979-9D9E-4423-88362888D5EC.jpg","category":3,"category_name":"荤菜"}}],"msg_uuid":"338B4C43-0BE4-94AA-29A8-426EBECE3260"}
db_counts
mysql: [Warning] Using a password on the command line interface can be insecure.
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 '% GROUP BY type,status' at line 1