Ticket #187 (closed 用户报障: 已处理)

Opened 12 years ago

Last modified 12 years ago

页面无法访问，提示：键索引未找到

Reported by: huweiyi Owned by: dingjianyong
Priority: 次高级（2） Milestone:
Component: 电脑网产品论坛 Version:
Keywords: Cc:
Due Date: 02/12/2013

Description

 http://itbbs.pconline.com.cn/mobile/f768572.html

页面无法访问，提示：键索引未找到

Change History

comment:1 Changed 12 years ago by dingjianyong

通过ip端口访问此链点： http://192.168.239.172:81/forum.do?fid=768572，
然后在服务器观察stdout.log，可以看到报错信息如下：

cn.pconline.bbs7.exceptions.BBS7Exception: Sql:[SELECT fid FROM bbs7_topic_forum_33 WHERE tid = ? ] (Key:15631593)Incorrect result size: expected 1, actual 0

可以看出bbs7_topic_forum_33表缺失对应数据，为论坛偶尔出现的数据缺失故障。

解决方案：
让DBA补上缺失的数据后，访问正常。
INSERT INTO bbs7_topic_forum_33 VALUES(15631593,768572);

comment:2 Changed 12 years ago by dingjianyong

后续可以研究这种类型的数据缺失是如何引起，以及更方面的修复方法

comment:3 Changed 12 years ago by dingjianyong

  • Status changed from new to closed
  • Resolution set to 已处理
Note: See TracTickets for help on using tickets.