database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
ㆍSybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Sybase Q&A 3895 게시물 읽기
No. 3895
insert 시 에러입니다. 도와주세요..
작성자
김기택(kamdark)
작성일
2009-09-17 22:55ⓒ
2009-09-17 23:33ⓜ
조회수
7,562

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 는 여유가 많이 있습니다)



원인이 무엇인지.. 해결방법은 무엇인지 알려주시면 감사하겠습니다.


오늘 하루종일 이 문제 해결못해서 지금까지 고생하고 있습니다. 


도와주세요.. ㅠㅠ

이 글에 대한 댓글이 총 1건 있습니다.
다음 가능성에 대해 하나씩 실해하여 문제를 접근해 보십시요
1. sp_configure "cpu grace time", 500  --> 1000으로 변경 하여 보세요
2. dbcc checktable로 insert되는 table를 check해 보세요
3. 32317번째 data의 문제 가능성 등.. 
Chandad(ChanDad)님이 2009-09-18 17:17에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
3916isql 실행시 ct-library에러 [2]
전형진
2009-09-29
11991
3909Row Length를 구하려면 어떻게하나요? [4]
프레야
2009-09-22
7620
3896insert 시 에러입니다. 도와주세요..<1> [3]
김기택
2009-09-19
8050
3895insert 시 에러입니다. 도와주세요.. [1]
김기택
2009-09-17
7562
3894날짜 추출 하는 쿼리 부분에 대한 질문 [1]
쿼리
2009-09-17
7569
3892DB의 log 사용률 알 수 있는 방법은? [1]
sybase
2009-09-16
6803
3891Orange for Sybase IQ 2009 출시 [2]
Kenny B. Kim
2009-09-14
10700
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.025초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다