免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2720 | 回复: 1
打印 上一主题 下一主题

紧急求助:应用系统运行时出现 605 错,救命啊... ... [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2003-02-14 09:09 |只看该作者 |倒序浏览
    
应用系统运行时出现 605 错,故障现象为输入单据速度越来越慢,errorlog日志记录如下:
server  End diagnostics for read failure:
server  Run the DBCC command 'dbcc tablealloc' for both the objects 112003430, 240003886
server  Error: 605, Severity: 21, State: 1
server  An attempt was made to fetch logical page '1819643' in database 'xxx' from cache 'default data cache'. Page belongs to object with id '240003886', not to object 'xx04'.
kernel  ************************************
kernel  SQL causing error : update xx04 SET ttt ='4' WHERE xx04.dd ='7723'
kernel  ************************************
server  SQL Text: update xx04 SET ttt ='4' WHERE xx04.dd ='7723'
kernel  curdb = 5 pstat = 0x10100 lasterror = 605
kernel  preverror = 0 transtate = 0
kernel  curcmd = 197 program = ZZZ

操作系统: HP_UX 11.0/sybase 11.9.2.5

xxx表之xx04表有800万条记录,所以在输入单据(其它表)而修改数据表xx04状态的时候,系统出现605错,错误级别21,请各位大侠鼎力相助,感激涕零~~~

特急~特急~特急~~~

论坛徽章:
0
2 [报告]
发表于 2003-02-14 16:06 |只看该作者

紧急求助:应用系统运行时出现 605 错,救命啊... ...

1.Run the dbcc checktable command on the second object specified in the error message.
2.To help determine the full extent of the corruption, run the dbcc checkdb and dbcc checkalloc commands as soon as feasible.
3.Check the SQL Server error log for other errors which often accompany a 605 error. If the 605 error is not transient, the problem is severe and you will probably need to restore from known clean backups.
4.Either of the following situations may also apply to your
SQL Server:
- If this error occurs after rebuilding the master device or reconfiguring the configuration block to the defaults, then the sort order on the new device may not match the sort order in the dump. If the sort orders do not match, call Technical Support for further assistance.
- To check if the error occurred as the result of hardware failure, examine your operating system error log and correct hardware problems.
If you have dial-in facilities, Technical Support may be able to help you recover from this error without having to restore from backups. However, this recovery procedure often results in a loss of data, and therefore is often unacceptable, especially to production systems.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP