00:00000:00000:2009/09/17 22:35:16.96 kernel timeslice -500, current process infected
00:00000:00011:2009/09/17 22:35:16.96 kernel SQL Server system exception (0xe0000001) generated by a process exceeding its time slice allotment.
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x77E7BCB1 KERNEL32.dll (0xE0000001, 0x00000001, 0x00000000, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x77E7BCB1 KERNEL32.dll (0x2A5B3A68, 0x00000000, 0x29E0BD04, 0x0340F120)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A09F95 kpntraise+ 0x1b (0xFFF4AF73, 0x29483674, 0x00000000, 0x29572725)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00738153 sqt_id_exists+ 0x5d (0x0340F154, 0x001F34C9, 0x2A0817A8, 0x2A08160C)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00B6ED80 make_negative_obj_id+ 0x110 (0x0340F770, 0x00000009, 0x00BB27C0, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel [Handler pc: 0x00688040 ut_handle installed by the following function:-]
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x006D9E6D lwp_create+ 0x196 (0x0340F860, 0x00000001, 0x00000000, 0x29E24EF4)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x006D5186 proccreate+ 0x556 (0x0340FA18, 0x0072B876, 0x29483674, 0x004989EE)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x0072CEBF s_crtproc+ 0x25b (0x29E24800, 0x00000001, 0x00000009, 0x0340FA67)
00:00000:00011:2009/09/17 22:35:16.96 kernel [Handler pc: 0x0072DF86 s_handle installed by the following function:-]
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x0072A150 sequencer+ 0x8f0 (0x00000000, 0x00000000, 0x29483674, 0x53090001)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x0044356A tdsrecv_language+ 0x540 (0x000000E7, 0x00BB27C0, 0x00000000, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00442CA7 tdsrecv_dynamic+ 0xd5 (0x00000011, 0x00BB27C0, 0x00000000, 0x299E883C)
00:00000:00011:2009/09/17 22:35:16.96 kernel [Handler pc: 0x00465417 hdl_backout installed by the following function:-]
00:00000:00011:2009/09/17 22:35:16.96 kernel [Handler pc: 0x00688040 ut_handle installed by the following function:-]
00:00000:00011:2009/09/17 22:35:16.96 kernel [Handler pc: 0x00688040 ut_handle installed by the following function:-]
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00411900 conn_hdlr+ 0x3057 (0x299E883C, 0x00BB27C0, 0x00000000, 0x299E883C)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A09ED7 kpntwrapper+ 0x84 (0x00A09E53, 0x299E883C, 0x00000000, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x77E5B3BC KERNEL32.dll (0x29DC3800, 0x29483674, 0x29E24800, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x77E5B958 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel end of stack trace, spid 11, kpid 3145776, suid 1
00:00000:00011:2009/09/17 22:35:16.96 kernel ************************************
00:00000:00011:2009/09/17 22:35:16.96 kernel SQL causing error : create proc S477E0000 as Insert food_gogi_tb (code, fcode, feedate, fckuse, foodfee, filedate) Values('203190085600', '00', '200909', 30, 920, '200909
00:00000:00011:2009/09/17 22:35:16.96 kernel ************************************
00:00000:00011:2009/09/17 22:35:16.96 server SQL Text: create proc S477E0000 as Insert food_gogi_tb (code, fcode, feedate, fckuse, foodfee, filedate) Values('203190085600', '00', '200909', 30, 920, '20090908')
00:00000:00011:2009/09/17 22:35:16.96 kernel curdb = 4 pstat = 0x40010000 lasterror = 0
00:00000:00011:2009/09/17 22:35:16.96 kernel preverror = 0 transtate = 1
00:00000:00011:2009/09/17 22:35:16.96 kernel curcmd = 0 program =
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x0340E94C, 0x77EA2160, 0x77E521F0, 0xFFFFFFFF)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x0340E94C, 0x0340E704, 0x0000270F, 0x00000002)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A589EA pcstkwalk+ 0x204 (0x00300030, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A58674 ucstkgentrace+ 0x224 (0x00300030, 0x00000001, 0x00BB27C0, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A1431B ucbacktrace+ 0xab (0x00300030, 0xFFFFFFFF, 0xE0000001, 0x29483674)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00406D71 terminate_process+ 0xb8f (0xE0000001, 0x7800BDB5, 0x0340ECCC, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A0944D kiexception+ 0x2e0 (0x299E883C, 0x00BB27C0, 0x00000000, 0x299E883C)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x00A09F57 kpntwrapper+ 0x104 (0x00A09E53, 0x299E883C, 0x00000000, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x77E5B3BC KERNEL32.dll (0x29DC3800, 0x29483674, 0x29E24800, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel pc: 0x77E5B958 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00011:2009/09/17 22:35:16.96 kernel end of stack trace, spid 11, kpid 3145776, suid 1
** OS : windows 2000 server
** VERSION : Adaptive Server Enterprise/12.5/SWR 9616 GA/P/NT (IX86)/OS 4.0/main/1647/32-bit/OPT/Fri Jun 01 16:58:25 2001
위 로그는 odbc를 통한 application에서 데이터(txt)화일을 읽어 테이블에 insert 작업을 하던도중 발생한 error 입니다.
화일의 약 45,000건정도의 데이터를 읽어 테이블에 insert 작업 (loop) 을 하던도중 32317 건에서 계속 멈추는 현상이 발생합니다.
procedure cache percent, number of lock, 등 여러가지 설정을 바꾸어 봐도 항상 정확히 32317 건에서 계속 동일한 현상이 일어나네요..
(procedure cache 는 여유가 많이 있습니다)
원인이 무엇인지.. 해결방법은 무엇인지 알려주시면 감사하겠습니다.
오늘 하루종일 이 문제 해결못해서 지금까지 고생하고 있습니다.
도와주세요.. ㅠㅠ
|