元禾群组消息排查

一、先查询日志

cd /data/logs/rcx-server.inst-0/logs

# 其它查询
grep 'findHistoryMsgCleanTime'  | grep '10\:13\:20' service-historymsg.log*
grep '10\:13\:20' | grep 'ESEQ8sTiS3cnla9v6V0fpI' service-historymsg.log*

grep 'u-_QyUEGS7Ykc4guS1L1Rs' service-historymsg.log | grep 'WhfIDBj_QWgl2Ca1itM_A8'

[root@21 logs]# grep 'u-_QyUEGS7Ykc4guS1L1Rs' service-historymsg.log | grep 'WhfIDBj_QWgl2Ca1itM_A8'
1115 02:06:35,245:service-historymsg-logger:142 [RelationInfoManager][30][RelationInfoManager]appId:161100744	ownerId:WhfIDBj_QWgl2Ca1itM_A8	targetId:u-_QyUEGS7Ykc4guS1L1Rs
1115 02:09:12,176:service-historymsg-logger:142 [RelationInfoManager][30][RelationInfoManager]appId:161100744	ownerId:WhfIDBj_QWgl2Ca1itM_A8	targetId:u-_QyUEGS7Ykc4guS1L1Rs
1115 02:10:13,905:service-historymsg-logger:154 [AbstractQueryMsgActor][176][AbstractQueryMsgActor]QueryMsgActor:appId:161100744     userId:WhfIDBj_QWgl2Ca1itM_A8	targetId:u-_QyUEGS7Ykc4guS1L1Rs	msgSize:0	time:1668477995234	count:10	endTime:0    isPullBeforeJoinMsg:3
1115 02:18:03,860:service-historymsg-logger:142 [RelationInfoManager][30][RelationInfoManager]appId:161100744	ownerId:WhfIDBj_QWgl2Ca1itM_A8	targetId:u-_QyUEGS7Ykc4guS1L1Rs
1115 02:18:13,299:service-historymsg-logger:142 [RelationInfoManager][30][RelationInfoManager]appId:161100744	ownerId:WhfIDBj_QWgl2Ca1itM_A8	targetId:u-_QyUEGS7Ykc4guS1L1Rs

二、登录数据库

supervisorctl  status
rce-rcdb.inst-0                  RUNNING   pid 3932, uptime 106 days, 0:23:24
rce-rcdb.inst-1                  RUNNING   pid 3934, uptime 106 days, 0:23:24
rcx-fileserver.inst-0            RUNNING   pid 3935, uptime 106 days, 0:23:24
rcx-rcdb.inst-0                  RUNNING   pid 3937, uptime 106 days, 0:23:24
rcx-rcdb.inst-1                  RUNNING   pid 3936, uptime 106 days, 0:23:24
redis.inst-0                     RUNNING   pid 3933, uptime 106 days, 0:23:24
netstat -lntp | grep 3936
tcp        0      0 0.0.0.0:8089            0.0.0.0:*               LISTEN      3936/rcdb-server    

cd /data/app/rcx-rcdb.inst-1/tools
ls
_cpy_  ssdb-bench  ssdb_cli  ssdb-cli  ssdb-cli.cpy  ssdb-dump  ssdb-migrate  ssdb-repair

./ssdb-cli -h 127.0.0.1 -p 8089
ssdb (cli) - ssdb command line tool.
Copyright (c) 2012-2015 ssdb.io

'h' or 'help' for help, 'q' to quit.

ssdb-server 1.0.0-

ssdb 127.0.0.1:8089>

三、开始查询

ncscan GroupMsg_161100744_KOwGs1fSSD0sLMBaPS0KDw_202109 -9223372036854775808 9223372036854775807 0 100
ncscan GroupMsg_161100744_JVNnfTfIR3wth8KHbVfexs_202112 -9223372036854775808 9223372036854775807 0 100

ncscan GroupMsg_161100744_u-_QyUEGS7Ykc4guS1L1Rs_202201 -9223372036854775808 9223372036854775807 0 100

ssdb 127.0.0.1:8089> ncscan GroupMsg_161100744_u-_QyUEGS7Ykc4guS1L1Rs_202201 -9223372036854775808 9223372036854775807 0 100
ok ['1643264524728', '7', '0', 'l2_TgwdEQ9gsHApJiLCfd8', '1', 'u-_QyUEGS7Ykc4guS1L1Rs', '2', 'RCE:GrpNtfy', '3', '{"action":1,"targetUsers":[],"targetGroup":{"id":"u-_QyUEGS7Ykc4guS1L1Rs","name":"\xe9\x87\x91\xe7\xa5\x96\xe5\xba\x86\xe3\x80\x81\xe5\xbc\xa0\xe4\xb8\x80\xe5\xbc\x9b\xe3\x80\x81\xe8\xae\xb8\xe6\x96\x87\xe9\xa3\x9e","type":0,"manager_id":"l2_TgwdEQ9gsHApJiLCfd8"},"operatorUser":{"name":"\xe9\x87\x91\xe7\xa5\x96\xe5\xba\x86","id":"l2_TgwdEQ9gsHApJiLCfd8"}}', '4', '1643264524728', '5', '17', '6', 'BUJ8-PC3E-36Q1-QC4E', '1643264524737', '7', '0', 'l2_TgwdEQ9gsHApJiLCfd8', '1', 'u-_QyUEGS7Ykc4guS1L1Rs', '2', 'RC:ImgTextMsg', '3', '{"content":"https:\\/\\/view.inews.qq.com\\/a\\/NEW202201270033211C?uid=C4002BE7-CEC9-4DF4-883C-FF4B4FE94E08&devid=C17C375C-2745-4AD3-9282-2CA3066CF982&qimei=529d1c60-d6f3-4db2-b7d1-8f9eb7c6c38c#","imageUri":"%E6%97%A0%E6%A0%87%E9%A2%98","title":"\xe6\x98\xa5\xe8\x8a\x82\xe5\x81\x87\xe6\x9c\x9f\xe9\xab\x98\xe9\x80\x9f\xe5\x85\xac\xe8\xb7\xaf\xe5\x85\x8d\xe8\xb4\xb9\xe9\x80\x9a\xe8\xa1\x8c\xe6\x97\xb6\xe9\x97\xb4\xe5\x85\xac\xe5\xb8\x83 \xe5\x87\xba\xe8\xa1\x8c\xe5\x89\x8d\xe8\xae\xb0\xe5\xbe\x97\xe5\xb8\xa6\xe9\xbd\x90\xe2\x80\x9c\xe4\xb8\xa4\xe7\xa0\x81\xe4\xb8\xa4\xe8\xaf\x81\xe2\x80\x9d","extra":"","url":"https:\\/\\/view.inews.qq.com\\/a\\/NEW202201270033211C?uid=C4002BE7-CEC9-4DF4-883C-FF4B4FE94E08&devid=C17C375C-2745-4AD3-9282-2CA3066CF982&qimei=529d1c60-d6f3-4db2-b7d1-8f9eb7c6c38c#"}', '4', '1643264524737', '5', '49', '6', 'BUJ8-PC3G-B6S1-QC4E', '1643264578546', '7', '0', 'l2_TgwdEQ9gsHApJiLCfd8', '1', 'u-_QyUEGS7Ykc4guS1L1Rs', '2', 'RC:ImgTextMsg', '3', '{"content":"CEO\xe5\xbe\x90\xe8\xbe\x89\xe5\x8f\x91\xe8\xa1\xa8\xe8\x87\xb4\xe8\xbe\x9e\xef\xbc\x9a\xe4\xbf\x9d\xe6\x8c\x81\xe7\x83\xadAI\xef\xbc\x8c\xe5\x85\xb1\xe8\xb5\xb4\xe5\xb1\xb1\xe6\xb5\xb7","imageUri":"%E6%97%A0%E6%A0%87%E9%A2%98","title":"\\n","extra":"","url":"https:\\/\\/mp.weixin.qq.com\\/s\\/HK0pqRUKyg9G1s24wSa_AA"}', '4', '1643264578546', '5', '49', '6', 'BUJ8-PP7S-J7C1-QC4E', '1643264612168', '7', '0', 'l2_TgwdEQ9gsHApJiLCfd8', '1', 'u-_QyUEGS7Ykc4guS1L1Rs', '2', 'RC:ImgTextMsg', '3', '{"content":"CEO\xe5\xbe\x90\xe8\xbe\x89\xe5\x8f\x91\xe8\xa1\xa8\xe8\x87\xb4\xe8\xbe\x9e\xef\xbc\x9a\xe4\xbf\x9d\xe6\x8c\x81\xe7\x83\xadAI\xef\xbc\x8c\xe5\x85\xb1\xe8\xb5\xb4\xe5\xb1\xb1\xe6\xb5\xb7","imageUri":"%E6%97%A0%E6%A0%87%E9%A2%98","title":"\\n","extra":"","url":"https:\\/