hflxdhf 发表于 2009-01-13 11:27

请高手帮忙--数据库报错：pcstkwalk+0x7c()

日志中的错误信息如下，请教各位大侠

03:00000:00221:2009/01/13 08:55:02.26 kernel************************************
03:00000:00221:2009/01/13 08:55:02.26 kernelSQL causing error : sp_reexec "1020000038"
03:00000:00221:2009/01/13 08:55:02.26 kernel************************************
03:00000:00221:2009/01/13 08:55:02.26 serverSQL Text: sp_reexec "1020000038"
03:00000:00221:2009/01/13 08:55:02.26 kernelcurdb = 4 tempdb = 2 pstat = 0x10000
03:00000:00221:2009/01/13 08:55:02.26 kernellasterror = 0 preverror = 0 transtate = 1
03:00000:00221:2009/01/13 08:55:02.26 kernelcurcmd = 193 program = SQL_Advantage               
03:00000:00221:2009/01/13 08:55:02.26 kernelpc: 0x0000000100288cd8 pcstkwalk+0x7c()
03:00000:00221:2009/01/13 08:55:02.26 kernelpc: 0x0000000100289408 ucstkgentrace+0x238()
03:00000:00221:2009/01/13 08:55:02.26 kernelpc: 0x0000000100289a84 ucbacktrace+0xe4()
03:00000:00221:2009/01/13 08:55:02.26 kernelpc: 0x000000010036a200 terminate_process__fdpr_3+0x804()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000100ab0efc kisignal+0x168()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x00000002471c17e8 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x000000010000c7f0 rvm_clean_pcrtree__fdpr_1+0x30()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000100011bd4 s_free__fdpr_1+0xc()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x00000001000431b8 s_pop+0x38()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x00000001000458d8 execproc__fdpr_1+0x2dc()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x00000001000a8aa4 s_execute__fdpr_38+0xdc()
03:00000:00221:2009/01/13 08:55:02.27 kernel
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000100041080 sequencer__fdpr_1+0x168()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000100045864 execproc__fdpr_1+0x268()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x00000001000a8aa4 s_execute__fdpr_38+0xdc()
03:00000:00221:2009/01/13 08:55:02.27 kernel
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x00000001002119ec sequencer__fdpr_9+0x108()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000100045864 execproc__fdpr_1+0x268()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x00000001000a8aa4 s_execute__fdpr_38+0xdc()
03:00000:00221:2009/01/13 08:55:02.27 kernel
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000100041080 sequencer__fdpr_1+0x168()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x000000010008b340 tdsrecv_language__fdpr_1+0x44()
03:00000:00221:2009/01/13 08:55:02.27 kernel
03:00000:00221:2009/01/13 08:55:02.27 kernel
03:00000:00221:2009/01/13 08:55:02.27 kernel
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x000000010008af30 startscan__getlocktype__fdpr_4+0x88()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x000000010001736c kpcoldstart+0x1c()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000100017328 kpinitproc__fdpr_1+0x1c()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000000000000 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000000000000 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000000000000 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000000000000 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000000000000 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000000000000 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000000000000 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelpc: 0x0000000000000000 ()
03:00000:00221:2009/01/13 08:55:02.27 kernelend of stack trace, spid 221, kpid 65536210, suid 6
03:00000:00221:2009/01/13 08:55:02.27 kernelcurrent process (0x3e800d2) infected with 11
03:00000:00221:2009/01/13 08:55:02.27 kernelError at address 0x000000010000c910 (rvm__ipcr_attr_cleanup+0x20)

hflxdhf 发表于 2009-01-13 11:33

各位大侠请出手 :em16:

WFCJZ 发表于 2009-01-13 11:54

03:00000:00221:2009/01/13 08:55:02.27 kernelend of stack trace, spid 221, kpid 65536210, suid 6
03:00000:00221:2009/01/13 08:55:02.27 kernelcurrent process (0x3e800d2) infected with 11
03:00000:00221:2009/01/13 08:55:02.27 kernelError at address 0x000000010000c910

从这个上面入手吧,看的好像是数据寻址范围有问题了,看一下硬盘是不是有问题!

xmltiger 发表于 2009-01-14 10:40

1、重新编译一下存储过程，再运行试试看
2、看存储过程中是否有全角字符，如果有，删除重新创建即可。（譬如全角逗号，编译时可以通过，但运行会发生内核错误）
页: [1]
查看完整版本: 请高手帮忙--数据库报错：pcstkwalk+0x7c()