SYBASE ASE 12.5的ERRORLOG,麻烦看一下是什么错误,如何解决
<P>01:00275:00275:2005/07/15 15:03:52.66 kernelSQL Server system exception (0xc0000005) generated by a storage access violation.<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x005B16E2 sortcmp+ 0x892 (0x27C4EA00, 0x27C4EA40, 0x2862D0E8, 0x00000000)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x005B16E2 sortcmp+ 0x892 (0x285014FC, 0x725CF79C, 0x00000001, 0x0F6DEA64)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x005AFC80 lmlink+ 0x9bc (0x285014FC, 0x00000002, 0x00000001, 0x2811BDB4)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x005AB5B6 startsort+ 0x11f9 (0x285014FC, 0x00000002, 0x00000001, 0x2811BDB4)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x005A9EEA sort+ 0x12da (0x26A6E88C, 0x280B12B0, 0x0F6DF2E4, 0x00000000)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x007C6ECE exec_eop+ 0x1b36 (0x283E46C4, 0x26A6E88C, 0x000000C1, 0x0F6DF2E4)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x007C4D4C execute+ 0xa8c (0x0F6DF750, 0x00000000, 0x00000000, 0x00000000)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x007D37E1 pll_exec+ 0x2191 (0x272C8098, 0x00000000, 0x00000000, 0x00000000)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x00705386 s_execute+ 0x2706 (0x2814B800, 0x00449075, 0x00000000, 0x00000000)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernel<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x00736835 sequencer+ 0x17f5 (0x246CEB00, 0x00000000, 0x00000000, 0x00000000)<BR>01:00275:00275:2005/07/15 15:03:53.99 kernelpc: 0x00444314 tdsrecv_language+ 0x540 (0x00000099, 0x00000000, 0x00000000, 0x25982E24)<BR>01:00275:00275:2005/07/15 15:03:54.01 kernel<BR>01:00275:00275:2005/07/15 15:03:54.01 kernel<BR>01:00275:00275:2005/07/15 15:03:54.01 kernel<BR>01:00275:00275:2005/07/15 15:03:54.01 kernelpc: 0x00412202 conn_hdlr+ 0x3429 (0x25982E24, 0x00000000, 0x00000000, 0x25982E24)<BR>01:00275:00275:2005/07/15 15:03:54.04 kernelpc: 0x00A1EF27 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)<BR>01:00275:00275:2005/07/15 15:03:54.07 kernelpc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)<BR>01:00275:00275:2005/07/15 15:03:54.07 kernelend of stack trace, spid 275, kpid 306774242, suid 135<BR>01:00000:00275:2005/07/15 15:03:54.07 kernel************************************<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelSQL causing error : TDT_REFITADD)) = "" )) <BR>01:00000:00275:2005/07/15 15:03:54.07 kernel************************************<BR>01:00000:00275:2005/07/15 15:03:54.07 serverSQL Text: TDT_REFITADD)) = "" )) <BR>01:00000:00275:2005/07/15 15:03:54.07 kernelcurdb = 4 pstat = 0x10000 lasterror = 0 <BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpreverror = 0 transtate = 0<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelcurcmd = 193 program = SUM/ERP! <BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x0F6DD74C, 0x77EB1F44, 0x77E621F0, 0xFFFFFFFF)<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x0F6DD74C, 0x0F6DD504, 0x0000270F, 0x00000002)<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpc: 0x00A6F8BA pcstkwalk+ 0x204 (0x124900E2, 0x00000002, 0x0000270F, 0x00000000)<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpc: 0x00A6F544 ucstkgentrace+ 0x224 (0x124900E2, 0x00000001, 0x00BEC888, 0x00000000)<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpc: 0x00A2969B ucbacktrace+ 0xab (0x124900E2, 0xFFFFFFFF, 0xC0000005, 0x246CEB8C)<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpc: 0x00406FC1 terminate_process+ 0xb8f (0xC0000005, 0x7800BDB5, 0x0F6DDACC, 0x00000000)<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpc: 0x00A1E47B kiexception+ 0x2e0 (0x25982E24, 0x00000000, 0x00000000, 0x25982E24)<BR>01:00000:00275:2005/07/15 15:03:54.07 kernelpc: 0x00A1EFA7 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)<BR>01:00000:00275:2005/07/15 15:03:54.10 kernelpc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)<BR>01:00000:00275:2005/07/15 15:03:54.10 kernelend of stack trace, spid 275, kpid 306774242, suid 135<BR>00:00000:00289:2005/07/15 16:28:51.38 kernelCannot send, host process disconnected: ZP077 1652 spid: 289<BR></P><P>谢谢大家。版本为:</P>
<P><BR> Adaptive Server Enterprise/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501<BR>/<BR> 1/32-bit/OPT/Tue Jul 30 23:45:57 2002</P>
<P>好象因为原来系统的原因,也不能再升级了~~以前从没出现过类似的问题,请问应该如何处理?</P> 从错误信息来看,应是SQL有问题。检查SQL语句,以及该SQL所访问的表。<br>
谢谢无言,这么说查起来工程就大了~~还是先放放吧,这是第一次出现这样的问题.以后如果再出来就好好查一下.
页:
[1]