求助。。DBCC时报837错误

zym16621

对数据库做DBCC时，报错。具体说来，是在做到某张表时报错。
单独对那张表进行dbcc checktable,也会报837错误。
日志如下：

00:00000:00001:2011/06/26 13:55:25.84 server  Original error was 837, severity 16, state 1
00:00000:00001:2011/06/26 13:55:25.84 kernel  ************************************
00:00000:00001:2011/06/26 13:55:25.84 kernel  SQL causing error : dbcc checkdb(JUDGE)
00:00000:00001:2011/06/26 13:55:25.84 kernel  ************************************
00:00000:00001:2011/06/26 13:55:25.84 server  SQL Text: dbcc checkdb(JUDGE)
00:00000:00001:2011/06/26 13:55:25.84 kernel  curdb = 5 pstat = 0x14000 lasterror = 837
00:00000:00001:2011/06/26 13:55:25.84 kernel  preverror = 0 transtate = 1
00:00000:00001:2011/06/26 13:55:25.84 kernel  curcmd = 230 program = SQL_Advantage                 
00:00000:00001:2011/06/26 13:55:25.86 kernel  pc: 0x49b268 pcstkwalk+0x20(0x6508a348, 0x0, 0x270f, 0x2, 0x0)
00:00000:00001:2011/06/26 13:55:25.86 kernel  pc: 0x49b17c ucstkgentrace+0x178(0x6f006f, 0x2, 0x270f, 0x0, 0x0)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0x47886c ucbacktrace+0xa4(0x674d6960, 0x1, 0x6f006f, 0x6be0a210, 0x0)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0x77ed0 terminate_process+0xa88(0x0, 0x7d8258, 0x6c00, 0x5400, 0x54c4)
00:00000:00001:2011/06/26 13:55:25.87 kernel  [Handler pc: 0xae1a8 ex_stop_recursion installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0xae890 ex_print+0xfc(0x10, 0x345, 0x7d8000, 0x6c54, 0x0)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0x39afb8 gotdbccerr+0x5c(0x8, 0x25, 0x10, 0x1, 0x6508af10)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0xb18e0 ex_raise+0x1e0(0x8, 0x0, 0x684ce7d0, 0x684d3cec, 0x684d3e3
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0xe4ec8 cm_grabmem_lru+0x1f0(0x0, 0x6beb7810, 0x0, 0x684ce7d0, 0x0)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0xda55c bufgrab+0x12c(0x67aae9e0, 0x0, 0x0, 0x6beb7810, 0x800)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0x1ae0f8 getpage_with_validation+0x318(0x67aae9e0, 0x67aaea74, 0xb9150, 0x0, 0x684ce7d0)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0x1af64c getpage_noscan_with_validation+0x6c(0x5c1c, 0x6508b1c8, 0x4, 0x0, 0x0)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0x3a53e0 text_chaincheck+0x90(0x67aae9e0, 0xb913b, 0x6508b1dc, 0x6508b1d8, 0x6508b1d4)
00:00000:00001:2011/06/26 13:55:25.87 kernel  pc: 0x3a5258 text_tabcheck+0x38c(0x67aae9e0, 0xb913b, 0x7c00, 0xa, 0xa7)
00:00000:00001:2011/06/26 13:55:25.88 kernel  pc: 0x39fb70 data_check+0x3fc(0x565, 0xeac0ce78, 0xead30dbc, 0x0, 0xc4fc5800)
00:00000:00001:2011/06/26 13:55:25.88 kernel  [Handler pc: 0x39af5c gotdbccerr installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.88 kernel  [Handler pc: 0x39af5c gotdbccerr installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.88 kernel  [Handler pc: 0x39af5c gotdbccerr installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.88 kernel  pc: 0x39f05c checktable+0x6ec(0x20e2a80c, 0x1, 0x0, 0x2, 0x67aae9e0)
00:00000:00001:2011/06/26 13:55:25.88 kernel  pc: 0x3d88ac checkdb+0x24c(0x6c686d50, 0x684ce8c0, 0x0, 0x0, 0xffffffff)
00:00000:00001:2011/06/26 13:55:25.88 kernel  [Handler pc: 0xb1ac8 hdl_backout_msg installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.88 kernel  pc: 0x3b8944 exec_dbcc+0x500(0x6c686c28, 0x1ee4, 0x1, 0x4, 0x6c686800)
00:00000:00001:2011/06/26 13:55:25.88 kernel  pc: 0x282b64 s_execute+0x1afc(0xe6, 0x66573c, 0x0, 0x0, 0x1)
00:00000:00001:2011/06/26 13:55:25.88 kernel  [Handler pc: 0x295080 s_handle installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.88 kernel  pc: 0x292afc sequencer+0xee0(0x6400f380, 0x5368, 0x684ce7d0, 0x4, 0x7d8000)
00:00000:00001:2011/06/26 13:55:25.88 kernel  [Handler pc: 0xb1ac0 hdl_backout installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.88 kernel  [Handler pc: 0x258b94 ut_handle installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.88 kernel  [Handler pc: 0x258b94 ut_handle installed by the following function:-]
00:00000:00001:2011/06/26 13:55:25.88 kernel  pc: 0x99898 conn_hdlr+0x1c8c(0x6400, 0x0, 0x7cb800, 0x7d8000, 0x54c0)
00:00000:00001:2011/06/26 13:55:25.88 kernel  pc: 0x4abfbc _coldstart+0x4(0x5, 0x97c0c, 0x0, 0x0, 0x0)
00:00000:00001:2011/06/26 13:55:25.88 kernel  end of stack trace, spid 1, kpid 7274607, suid 1
00:00000:00007:2011/06/26 14:12:46.33 server  
Error 837 encountered .

andkylee

是关于buffer的错误，重启一下试试。

hobbylu

什么版本的数据库？12.0？或者

zym16621

回复 3# hobbylu

数据库版本是11.9.2

zym16621

回复 2# andkylee
重启之后还是报错

hobbylu

你的内存配置的太大了，你看你的total memory是多少，11.92版本的不要超过它的限制。

wufeiwf

那里看出来内存配置太大？

zym16621

回复 6# hobbylu
搞定了，谢谢~~~ 是参数配置有问题。