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 1766 게시물 읽기
No. 1766
에러에 대해 설명 부탁드립니다..
작성자
박민규(mkmos)
작성일
2006-12-19 14:49
조회수
5,182

sybase  log 상에는 이런 메시지가 생겼고...

00:00000:00048:2006/12/15 23:20:35.28 kernel  ************************************
00:00000:00048:2006/12/15 23:20:35.29 kernel  SQL causing error : !
00:00000:00048:2006/12/15 23:20:35.29 kernel  ************************************
00:00000:00048:2006/12/15 23:20:35.29 server  SQL Text: !
00:00000:00048:2006/12/15 23:20:35.29 kernel  curdb = 4 pstat = 0x10000 lasterror = 0
00:00000:00048:2006/12/15 23:20:35.29 kernel  preverror = 2601 transtate = 0
00:00000:00048:2006/12/15 23:20:35.29 kernel  curcmd = 0 program =                              
00:00000:00048:2006/12/15 23:20:35.33 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
00:00000:00048:2006/12/15 23:20:35.33 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
00:00000:00048:2006/12/15 23:20:35.33 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
00:00000:00048:2006/12/15 23:20:35.35 kernel  pc: 0x0000000100222d90 .terminate_process[3]+0x7fc()
00:00000:00048:2006/12/15 23:20:35.35 kernel  pc: 0x00000001002236f4 .close_network+0x18()
00:00000:00048:2006/12/15 23:20:35.35 kernel  pc: 0x0000000100223378 .hdl_default+0x50()
00:00000:00048:2006/12/15 23:20:35.35 kernel  pc: 0x0000000100223914 .ex_raise[2]+0x1a0()
00:00000:00048:2006/12/15 23:20:35.36 kernel  pc: 0x00000001003e6778 .tdsrecv__onepfmt[2]+0x4c()
00:00000:00048:2006/12/15 23:20:35.36 kernel  pc: 0x00000001003e80b0 .tdsrecv_paramfmt[2]+0x3e8()
00:00000:00048:2006/12/15 23:20:35.36 kernel  pc: 0x00000001003ea9cc .tdsrecv_language[2]+0x288()
00:00000:00048:2006/12/15 23:20:35.36 kernel  [Handler pc: 0x00000001002233dc .hdl_backout installed by the following function:-]
00:00000:00048:2006/12/15 23:20:35.37 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
00:00000:00048:2006/12/15 23:20:35.37 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
00:00000:00048:2006/12/15 23:20:35.38 kernel  pc: 0x00000001000732ec .result[4]+0x6c()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000100015970 +0x1c()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  pc: 0x0000000000000000 ()
00:00000:00048:2006/12/15 23:20:35.39 kernel  end of stack trace, spid 48, kpid 1274806474, suid 3

이때 app상에는 이런 메시지가 생기는데...

[23:20:35] Server : cs_interfaceInsert() INSERT CS_INTERFACE FAIL [20061215][99200612150000001156][-5702][The SQL Server is terminating this process.
]
[23:20:35] Server : cs_interfaceInsert() UPDATE CS_INTERFACE FAIL [20061215][99200612150000001152][-84083974][ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect]
[23:20:35] Server : data_process successed...
[23:20:35] Server : exit(0) before...
[23:20:35] Server : data_process successed...
[23:20:35] Server : exit(0) before...
[23:20:35] Server : cs_interfaceInsert() INSERT CS_INTERFACE FAIL [20061215][99200612150000001158][-16843058][ct_command(): user api layer: external error: The connection has been marked dead.]
[23:20:35] Server : data_process successed...
[23:20:35] Server : exit(0) before...
[23:20:35] Server : cs_interfaceInsert() INSERT CS_INTERFACE FAIL [20061215][99200612150000001160][-16843058][ct_command(): user api layer: external error: The connection has been marked dead.]
[23:20:35] Server : data_process successed...
[23:20:35] Server : exit(0) before...
[23:20:35] Server : cs_interfaceInsert() INSERT CS_INTERFACE FAIL [20061215][99200612150000001154][-84083974][ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect]



이 에러가 무엇인지 궁금합니다...
혹 아시는 분은 답글 부탁 드립니다.. ^^;






이 글에 대한 댓글이 총 1건 있습니다.

 SQL causing error 는 대략 2개의 원인이 있습니다



1. sybase db의 bug로 patch를 하시면 됩니다


2. User의 app의 err입니다

   다행히 App를 아시니 App를 튜닝하시기 바랍니다



상황은 특정 App실행시  SQL causing error 를 발생시키면서 App가 죽는 상황이고요



1의 경우는 한 10%, 2의 경우는 90%정도 됩니다

지연님이 2006-12-20 09:06에 작성한 댓글입니다. Edit
[Top]
No.
제목
작성자
작성일
조회
1769서버가 갑자기 다운 되더니 구동이 안되네요... [1]
강민현
2006-12-20
4810
1768SQL syntax check를 하려면 어떻게 하나요? [3]
정완호
2006-12-20
4440
1767DB 가 offline 상태인대 online이 안데네요. [3]
HelpMe
2006-12-19
5428
1766에러에 대해 설명 부탁드립니다.. [1]
박민규
2006-12-19
5182
1765코딩 스타일에 관해서 여쭤보고 싶어요~ [2]
박상묵
2006-12-15
4735
1764대량데이터의 count 방법 알려주세요. [1]
박선영
2006-12-14
5200
1763쿼리이관 [1]
손동길
2006-12-13
4290
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.018초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다