免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3043 | 回复: 4

数据库出错 [复制链接]

论坛徽章:
0
发表于 2008-12-30 18:12 |显示全部楼层
00:00000:00000:2008/12/30 17:36:47.96 kernel  sddone: read error on virtual disk 6 block 329104:
00:00000:00000:2008/12/30 17:36:47.96 kernel  sddone: Windows NT system error 23: CRC error.
00:00000:00000:2008/12/30 17:36:54.81 kernel  sddone: read error on virtual disk 6 block 329104:
00:00000:00000:2008/12/30 17:36:54.82 kernel  sddone: Windows NT system error 23: CRC error.
00:00000:00001:2008/12/30 17:36:54.90 server  Error: 823, Severity: 24, State: 1
00:00000:00001:2008/12/30 17:36:54.90 server  I/O error detected during read for BUF pointer = '0x5BFE4F00', MASS pointer = '0x5BFE4F00', (Buf#: '0'), page ptr = '0x33805000', dbid = '4', Mass virtpage = '100992400', Buffer page = '676552', Mass status = '0x4000100', Buffer status = '0x1', size = '32768', cache (id: 0) = 'default data cache', Pinning Xdes = '0x00000000', spid = '0'.
00:00000:00001:2008/12/30 17:36:55.15 server  Error: 3414, Severity: 21, State: 1
00:00000:00001:2008/12/30 17:36:55.15 server  Database 'BSSCS' (dbid 4): Recovery failed. Check the SQL Server errorlog for further information as to the cause.

环境Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004  for win2003 server
这个错误是不是能肯定是硬盘硬件的故障?能否做NT自带的磁盘检查工具修复?

我把日志用dbcc rebuild_log重做一遍后数据库现在能起起来,但有很多诸如下面的错误信息:

00:00000:00084:2008/12/30 18:02:43.87 kernel  end of stack trace, spid 84, kpid 5636182, suid 4
00:00000:00084:2008/12/30 18:02:43.89 server  Invalid column length: 30. Value must be between 0 and 20 for 'all-pages' row with minimum row length of 30.
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x00C2AD4D AseHTTPURLInputStream::readBytes+ 0x101365 (0x0244C1B8, 0x7C821A60, 0x7C824598, 0xFFFFFFFF)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x00C2AD4D AseHTTPURLInputStream::readBytes+ 0x101365 (0x0244C1B8, 0x0244BF70, 0x0000270F, 0x00000002)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x00C0195A AseHTTPURLInputStream::readBytes+ 0xd7f72 (0x00560056, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x00C015E4 AseHTTPURLInputStream::readBytes+ 0xd7bfc (0x00560056, 0x00000001, 0x010AEA08, 0x00000080)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x00BB10EB AseHTTPURLInputStream::readBytes+ 0x87703 (0x232E1000, 0x00000045, 0x0000001E, 0x00000014)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x004A0DF6 (Symbol not found)(0x0244C680, 0x232E1000, 0x0000001E, 0x00000001)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x0065F681 (Symbol not found)(0x21EA27D8, 0x232E1000, 0x00000080, 0x0244CAFC)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x0061D72E (Symbol not found)(0x21EA27D8, 0x232E1000, 0x00000080, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x0061CDAB (Symbol not found)(0x00000000, 0x2321BCA4, 0x21EA27D8, 0x232E1000)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x0061C8EC (Symbol not found)(0x2321BCA4, 0x232E2E50, 0x0244E594, 0x21E9B774)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x008AA1AC (Symbol not found)(0x2321BCA4, 0x232E2E50, 0x0244E67C, 0x00000002)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x0088A62A (Symbol not found)(0x2321B800, 0x2321BCA4, 0x000000C3, 0x0244E67C)
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x0088FC70 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x00A5B568 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x00870632 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x0088FC70 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x0088FC70 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x007DC534 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x00888CD5 (Symbol not found)(0x21E9AE6C, 0x22B94DF0, 0x23106E5F, 0x0244E7F4)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x007A2FEB (Symbol not found)(0x23220800, 0x0244EE84, 0x013ED354, 0x006004FC)
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x007E3066 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x007DF1B3 (Symbol not found)(0x23106D14, 0x23106DA4, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x007AD14D (Symbol not found)(0x21E9AE6C, 0x22B94DF0, 0x234E8E6F, 0x0244F0E4)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x007A3700 (Symbol not found)(0x23281000, 0x0244F774, 0x013ED354, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x007E3066 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x007DF1B3 (Symbol not found)(0x234E8D28, 0x234E8DB8, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x007AD14D (Symbol not found)(0x00300033, 0x00390020, 0x00200020, 0x00200020)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x007A3700 (Symbol not found)(0x23584000, 0x0244FF48, 0x013ED354, 0x00000056)
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x007E3066 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x007DF1B3 (Symbol not found)(0x21E9A900, 0x00000000, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x0045BCEB (Symbol not found)(0x00000046, 0x00000000, 0x00000000, 0x22B94DF0)
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x0047BA54 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x006F8C20 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  [Handler pc: 0x006F8C20 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x00422234 (Symbol not found)(0x22B94DF0, 0x00000000, 0x00000000, 0x22B94DF0)
00:00000:00084:2008/12/30 18:02:43.89 kernel  pc: 0x00BA6497 AseHTTPURLInputStream::readBytes+ 0x7caaf (0x00BA6413, 0x22B94DF0, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x7C824829 kernel32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  end of stack trace, spid 84, kpid 5636182, suid 4
00:00000:00084:2008/12/30 18:02:43.90 server  Invalid column length: 30. Value must be between 0 and 20 for 'all-pages' row with minimum row length of 30.
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00C2AD4D AseHTTPURLInputStream::readBytes+ 0x101365 (0x0244BCA0, 0x7C821A60, 0x7C824598, 0xFFFFFFFF)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00C2AD4D AseHTTPURLInputStream::readBytes+ 0x101365 (0x0244BCA0, 0x0244BA58, 0x0000270F, 0x00000002)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00C0195A AseHTTPURLInputStream::readBytes+ 0xd7f72 (0x00560056, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00C015E4 AseHTTPURLInputStream::readBytes+ 0xd7bfc (0x00560056, 0x00000001, 0x010AEA08, 0x00000080)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00BB10EB AseHTTPURLInputStream::readBytes+ 0x87703 (0x305E3020, 0x00000045, 0x0000001E, 0x00000014)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x004A0DF6 (Symbol not found)(0x0244C184, 0x5BE60688, 0x0000000D, 0x22EB5830)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00663066 (Symbol not found)(0x0244C63C, 0x00000000, 0x5C0E0C84, 0x21EA27D
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00683078 (Symbol not found)(0x0244C63C, 0xFFFFFFFF, 0x5C0E0C84, 0x0244C5E
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x006636FF (Symbol not found)(0x0244C63C, 0x00000001, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x0065F92F (Symbol not found)(0x21EA27D8, 0x232E1000, 0x00000080, 0x0244CAFC)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x0061DA86 (Symbol not found)(0x21EA27D8, 0x232E1000, 0x00000080, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x0061CDAB (Symbol not found)(0x00000000, 0x2321BCA4, 0x21EA27D8, 0x232E1000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x0061C8EC (Symbol not found)(0x2321BCA4, 0x232E2E50, 0x0244E594, 0x21E9B774)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x008AA1AC (Symbol not found)(0x2321BCA4, 0x232E2E50, 0x0244E67C, 0x00000002)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x0088A62A (Symbol not found)(0x2321B800, 0x2321BCA4, 0x000000C3, 0x0244E67C)
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x0088FC70 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x00A5B568 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x00870632 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x0088FC70 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x0088FC70 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x007DC534 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00888CD5 (Symbol not found)(0x21E9AE6C, 0x22B94DF0, 0x23106E5F, 0x0244E7F4)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x007A2FEB (Symbol not found)(0x23220800, 0x0244EE84, 0x013ED354, 0x006004FC)
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x007E3066 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x007DF1B3 (Symbol not found)(0x23106D14, 0x23106DA4, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x007AD14D (Symbol not found)(0x21E9AE6C, 0x22B94DF0, 0x234E8E6F, 0x0244F0E4)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x007A3700 (Symbol not found)(0x23281000, 0x0244F774, 0x013ED354, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x007E3066 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x007DF1B3 (Symbol not found)(0x234E8D28, 0x234E8DB8, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x007AD14D (Symbol not found)(0x00300033, 0x00390020, 0x00200020, 0x00200020)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x007A3700 (Symbol not found)(0x23584000, 0x0244FF48, 0x013ED354, 0x00000056)
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x007E3066 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x007DF1B3 (Symbol not found)(0x21E9A900, 0x00000000, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x0045BCEB (Symbol not found)(0x00000046, 0x00000000, 0x00000000, 0x22B94DF0)
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x0047BA54 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x006F8C20 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  [Handler pc: 0x006F8C20 (Symbol not found) installed by the following function:-]
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00422234 (Symbol not found)(0x22B94DF0, 0x00000000, 0x00000000, 0x22B94DF0)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x00BA6497 AseHTTPURLInputStream::readBytes+ 0x7caaf (0x00BA6413, 0x22B94DF0, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  pc: 0x7C824829 kernel32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00084:2008/12/30 18:02:43.90 kernel  end of stack trace, spid 84, kpid 5636182, suid 4

[ 本帖最后由 小无赖 于 2008-12-30 18:15 编辑 ]

论坛徽章:
33
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
发表于 2008-12-30 21:00 |显示全部楼层

论坛徽章:
0
发表于 2008-12-30 22:20 |显示全部楼层
谢谢,看过了.你的提示了损坏的对象,起起来后还可以修复对象.可我没提示对象损坏.看来只有先做个全库DBCC看看了.就怕时间太长了.

论坛徽章:
33
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
发表于 2008-12-30 23:27 |显示全部楼层
只能用这个办法了,看看有提示对象没,这样有针对性的做!或许会好些!

论坛徽章:
0
发表于 2009-01-01 01:16 |显示全部楼层
恩,做了个全库DBCC,发现有几个表坏了,修复了一下,现在没有错误提示了.再观察观察看吧.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP