求解Error: 871
npdhxd
|
1#
npdhxd 发表于 2007-06-22 17:14
求解Error: 871
数据库版本
Adaptive Server Enterprise/12.5.2/EBF 11799/P/Linux Intel/Enterprise Linux/ase1252/1831/32-bit/OPT/Fri Apr 9 02:53:50 2004 经常出现以下错误,在不打补丁的情况下,如何避免或解决,谢谢. 00:00101:00042:2007/06/22 14:28:26.83 server Error: 871, Severity: 20, State: 1 00:00101:00042:2007/06/22 14:28:26.84 server Process 42 is trying to release a latch on buffer 0xb59413d0 (dbid: 4, pageno: 9783) without holding a latch on the buffer. 00:00101:00042:2007/06/22 14:28:26.84 kernel ************************************ 00:00101:00042:2007/06/22 14:28:26.84 kernel curdb = 4 tempdb = 2 pstat = 0x10000 00:00101:00042:2007/06/22 14:28:26.84 kernel lasterror = 871 preverror = 0 transtate = 1 00:00101:00042:2007/06/22 14:28:26.84 kernel curcmd = 193 program = 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x87e16e9 ucbacktrace+0x89(0x0,0x1,0x9302ccc,0x14,0x 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x81af765 terminate_process+0xc09(0x0,0xffffffff,0x9302ccc,0x9bf702f0,0x8207121) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x8206f35 close_network+0x19(0x9302ccc,0x9b57e6a0,0x9bf703b4,0x84f763f,0x 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x8207121 hdl_default+0x49(0x8,0x47,0x14,0x1,0x9bf70400) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x84f763f s_handle+0xf8f(0x8,0x47,0x14,0x1,0x9bf70400) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x8206b88 ex_raise+0x2f8(0x8,0x47,0x14,0x1,0x2a) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x8367bdf getnext+0x2eb(0x9f5d4bac,0x9302ccc,0x0,0xa288b120,0x0) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x8582350 exec_eop+0x10f4(0xa27ec560,0xa288b1cc,0x9bf709c4,0x9302ccc,0x9bf709c4) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x85818c1 exec_eop+0x665(0xa27ec560,0xa288b120,0x9bf709c4,0xa27ec560,0x0) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x8580f14 execute+0x838(0xa27ec4d4,0xa27ec560,0xc1,0x9bf709c4,0x9302ccc) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x823f34f ex_cleanup(0xa27ec4d4,0x0,0x9302ccc,0xb66a01bc,0x160000) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x85722b4 child_driver+0x404(0x0,0x9302ccc,0xb66a01bc,0x160016,0x5) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x823f34f ex_cleanup(0xb66a01bc,0x9bf70abc,0x0,0x0,0x0) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x88437ff kw_member+0x2a3(0x0,0x9bf70ad4,0x895eed31,0x0,0x0) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x8821e88 kpexit(0x0,0x0,0x0,0x9be00900,0x17) 00:00101:00042:2007/06/22 14:28:26.84 kernel pc 0x895eed31 init_dummy+0x8099bc11(0x0,0x9be00900,0x17,0x1,0x5374616b) 00:00101:00042:2007/06/22 14:28:26.84 kernel end of stack trace, spid 42, kpid 1441814, suid 3 00:00098:00040:2007/06/22 14:28:26.84 server Error: 871, Severity: 20, State: 1 00:00098:00040:2007/06/22 14:28:26.84 server Process 40 is trying to release a latch on buffer 0xb59413d0 (dbid: 4, pageno: 9783) without holding a latch on the buffer. 00:00098:00040:2007/06/22 14:28:26.84 kernel ************************************ 00:00098:00040:2007/06/22 14:28:26.84 kernel curdb = 4 tempdb = 2 pstat = 0x10000 00:00098:00040:2007/06/22 14:28:26.84 kernel lasterror = 871 preverror = 0 transtate = 1 00:00098:00040:2007/06/22 14:28:26.84 kernel curcmd = 193 program = 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x87e16e9 ucbacktrace+0x89(0x0,0x1,0x9302ccc,0x14,0x0) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x81af765 terminate_process+0xc09(0x0,0xffffffff,0x9302ccc,0x9d7e217c,0x8207121) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x8206f35 close_network+0x19(0x9302ccc,0x9b57e620,0x9d7e2240,0x84f763f,0x 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x8207121 hdl_default+0x49(0x8,0x47,0x14,0x1,0x9d7e228c) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x84f763f s_handle+0xf8f(0x8,0x47,0x14,0x1,0x9d7e228c) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x8206b88 ex_raise+0x2f8(0x8,0x47,0x14,0x1,0x2 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x8367bdf getnext+0x2eb(0x9f5b7be4,0x9302ccc,0x0,0xa2840920,0x0) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x8582350 exec_eop+0x10f4(0xa2893d60,0xa28409cc,0x9d7e2850,0x9302ccc,0x9d7e2850) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x85818c1 exec_eop+0x665(0xa2893d60,0xa2840920,0x9d7e2850,0xa2893d60,0x0) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x8580f14 execute+0x838(0xa2893cd4,0xa2893d60,0xc1,0x9d7e2850,0x9302ccc) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x823f34f ex_cleanup(0xa2893cd4,0x0,0x9302ccc,0xb669fe6c,0x19d0000) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x85722b4 child_driver+0x404(0x0,0x9302ccc,0xb669fe6c,0x19d019d,0x5) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x823f34f ex_cleanup(0xb669fe6c,0x9d7e2948,0x0,0x0,0x0) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x88437ff kw_member+0x2a3(0x0,0x9d7e2960,0x895eed31,0x0,0x0) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x8821e88 kpexit(0x0,0x0,0x0,0x9be00900,0x19e) 00:00098:00040:2007/06/22 14:28:26.84 kernel pc 0x895eed31 init_dummy+0x8099bc11(0x0,0x9be00900,0x19e,0x1,0x5374616b) 00:00098:00040:2007/06/22 14:28:26.84 kernel end of stack trace, spid 40, kpid 27066781, suid 3 |