数据库出错

小无赖

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 编辑 ]

WFCJZ

参考个人的博客上处理方法,看看可以不:http://blog.chinaunix.net/u/2444/showart_312657.html









http://eblog.cersp.com/UploadFiles/2007-5/59797326.swf

小无赖

谢谢,看过了.你的提示了损坏的对象,起起来后还可以修复对象.可我没提示对象损坏.看来只有先做个全库DBCC看看了.就怕时间太长了.

WFCJZ

只能用这个办法了,看看有提示对象没,这样有针对性的做!或许会好些!

小无赖

恩,做了个全库DBCC,发现有几个表坏了,修复了一下,现在没有错误提示了.再观察观察看吧.