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 1961 게시물 읽기
No. 1961
errorlog 내용좀 봐주세요
작성자
이은영(eunylee)
작성일
2007-06-26 09:21
조회수
5,709

 안녕하세요 errorlog내용인데요..


이게 뭔 일이 있단 건가여???


웬지 문제가 있어 보이는데..-.-


02:00000:00325:2007/06/25 20:12:48.47 kernel  Cannot read, host process disconnected:  2472 spid: 325

00:00000:00316:2007/06/25 20:19:15.82 kernel  Cannot read, host process disconnected:  3496 spid: 316

00:00000:00312:2007/06/25 20:28:21.49 kernel  current process (0x2ea000d5) infected with 11

00:00000:00312:2007/06/25 20:28:21.49 kernel  Error at address 0x400000000099933f (r_i4Swap+0x4f)

00:00000:00312:2007/06/25 20:28:21.49 kernel  ir=0000000003284400.0000000000000003

00:00000:00312:2007/06/25 20:28:21.49 kernel  pc=0000000004231800.4000000000999343  psw=0000000000097514

00:00000:00312:2007/06/25 20:28:21.49 kernel  gr0-3   0000000000000000 80000000005ea470 40000000007d859b c00000004e840580

00:00000:00312:2007/06/25 20:28:21.52 kernel  gr4-7   c000000049b6cd20 0000000000000000 40000000007d6eb0 0000000000000000

00:00000:00312:2007/06/25 20:28:21.52 kernel  gr8-11  c000000049b835e0 c00000004e5a3078 000000000000c000 0000000000000000

00:00000:00312:2007/06/25 20:28:21.52 kernel  gr12-15 400000000043d000 0000000000000024 0000000000000000 c00000004e89df88

00:00000:00312:2007/06/25 20:28:21.52 kernel  gr16-19 0000000000000000 4000000000999328 40000000007d8570 40000000005e4d30

00:00000:00312:2007/06/25 20:28:21.52 kernel  gr20-23 c000000040038af8 c000000049b6cd20 800000000061d5a0 c00000004e5a3238

00:00000:00312:2007/06/25 20:28:21.52 kernel  gr24-27 000000000000013f 000000000000013e 0000000000000000 8000000000603c70

00:00000:00312:2007/06/25 20:28:21.52 kernel  gr28-31 0000000000000000 c000000043e644a0 c000000043e645a0 c000000049b6cd20

00:00000:00312:2007/06/25 20:28:21.52 kernel  ************************************

00:00000:00312:2007/06/25 20:28:21.52 kernel  SQL causing error : ^b^E

00:00000:00312:2007/06/25 20:28:21.52 kernel  ************************************

00:00000:00312:2007/06/25 20:28:21.52 server  SQL Text: ^b^E

00:00000:00312:2007/06/25 20:28:21.52 kernel  curdb = 6 tempdb = 2 pstat = 0x10010000

00:00000:00312:2007/06/25 20:28:21.52 kernel  lasterror = 0 preverror = 0 transtate = 1

00:00000:00312:2007/06/25 20:28:21.52 kernel  curcmd = 264 program = Query Tool (using ODBC) 4.1 -

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x4000000000ea1000 pcstkwalk+0x30()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x4000000000ea18a0 ucstkgentrace+0x2a8()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x4000000000e5cca0 ucbacktrace+0x60()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x40000000006b0fdc terminate_process+0xf44()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x4000000000e79ad8 kisignal+0x210()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x400000000083d340 setarg+0x178()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x400000000099933c r_i4Swap+0x4c()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x40000000007d8598 run+0x16c8()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x4000000000c79d54 exec_ojoinrow+0xc4()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x40000000007f2bcc exec_eop+0x181c()

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x4000000000c78bb8 prsubst+0x58 installed by the following function:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x4000000000d96828 pthread_create+0x8 installed by the following function

:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x4000000000c213a0 strtobin+0xe0 installed by the following function:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x4000000000c78bb8 prsubst+0x58 installed by the following function:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x4000000000c78bb8 prsubst+0x58 installed by the following function:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x40000000009650c0 lm___api_key_to_uint+0x558 installed by the following

function:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x40000000007f3d44 execute+0x45c()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x4000000000830cc0 curs_fetch+0x68()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x40000000007c8130 s_execute+0x1780()

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x400000000094ad80 reset__dlreq+0x40 installed by the following function:

-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x40000000008134c8 sequencer+0x248()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x40000000009057f8 tdsrecv_fetch+0x80()

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x4000000000963ae0 cm__wash_mass_clock+0x3b0 installed by the following f

unction:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x4000000000b874c8 pthread_create+0x8 installed by the following function

:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  [Handler pc: 0x4000000000b874c8 pthread_create+0x8 installed by the following function

:-]

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x4000000000760ad0 conn_hdlr+0x21f8()

00:00000:00312:2007/06/25 20:28:21.52 kernel  pc: 0x40000000007f38c0 proc_stack_switch+0x40()

00:00000:00312:2007/06/25 20:28:21.52 kernel  end of stack trace, spid 312, kpid 782237909, suid 49

02:00000:00185:2007/06/25 20:30:29.28 kernel  Cannot read, host process disconnected:  3444 spid: 185

00:00000:00141:2007/06/25 20:30:29.28 kernel  Cannot read, host process disconnected:  3444 spid: 141

02:00000:00194:2007/06/25 20:30:29.28 kernel  Cannot read, host process disconnected:  3444 spid: 194

02:00000:00168:2007/06/25 20:47:31.27 kernel  current process (0x2ee3004e) infected with 11

02:00000:00168:2007/06/25 20:47:31.27 kernel  Error at address 0x400000000099933f (r_i4Swap+0x4f)

02:00000:00168:2007/06/25 20:47:31.27 kernel  ir=0000000003284400.0000000000000003

02:00000:00168:2007/06/25 20:47:31.27 kernel  pc=0000000004231800.4000000000999343  psw=000000003fffffff

02:00000:00168:2007/06/25 20:47:31.27 kernel  gr0-3   0000000000000000 80000000005ea470 40000000007d859b c00000004d14ed80

02:00000:00168:2007/06/25 20:47:31.29 kernel  gr4-7   c000000048e942a0 0000000000000000 40000000007d6eb0 c00000004d153ca8

02:00000:00168:2007/06/25 20:47:31.29 kernel  gr8-11  c000000048eaab60 c00000004d154698 000000000000c000 0000000000000000

02:00000:00168:2007/06/25 20:47:31.29 kernel  gr12-15 400000000043d000 0000000000000024 0000000000000000 c00000004d153d50

02:00000:00168:2007/06/25 20:47:31.29 kernel  gr16-19 0000000000000000 4000000000999328 40000000007d8570 40000000005e4d30

02:00000:00168:2007/06/25 20:47:31.29 kernel  gr20-23 c000000040038af8 c000000048e942a0 800000000061d5a0 c00000004d154588

02:00000:00168:2007/06/25 20:47:31.29 kernel  gr24-27 000000000000013f 000000000000013e 0000000000000000 8000000000603c70

02:00000:00168:2007/06/25 20:47:31.29 kernel  gr28-31 0000000000000000 c00000004272f7d0 c00000004272f8d0 c000000048e942a0

02:00000:00168:2007/06/25 20:47:31.29 kernel  ************************************

02:00000:00168:2007/06/25 20:47:31.29 kernel  SQL causing error : ^b^E

02:00000:00168:2007/06/25 20:47:31.29 kernel  ************************************

02:00000:00168:2007/06/25 20:47:31.29 server  SQL Text: ^b^E

02:00000:00168:2007/06/25 20:47:31.29 kernel  curdb = 6 tempdb = 12 pstat = 0x10010000

02:00000:00168:2007/06/25 20:47:31.29 kernel  lasterror = 0 preverror = 0 transtate = 1

02:00000:00168:2007/06/25 20:47:31.30 kernel  curcmd = 264 program = Query Tool (using ODBC) 4.1 -

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x4000000000ea1000 pcstkwalk+0x30()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x4000000000ea18a0 ucstkgentrace+0x2a8()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x4000000000e5cca0 ucbacktrace+0x60()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000006b0fdc terminate_process+0xf44()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x4000000000e79ad8 kisignal+0x210()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x400000000083d340 setarg+0x178()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x400000000099933c r_i4Swap+0x4c()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000007d8598 run+0x16c8()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x4000000000c79d54 exec_ojoinrow+0xc4()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000007f255c exec_eop+0x11ac()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000007f232c exec_eop+0xf7c()

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x4000000000c78bb8 prsubst+0x58 installed by the following function:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x4000000000d96828 pthread_create+0x8 installed by the following function

:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x4000000000c213a0 strtobin+0xe0 installed by the following function:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x4000000000c78bb8 prsubst+0x58 installed by the following function:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x4000000000c78bb8 prsubst+0x58 installed by the following function:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x40000000009650c0 lm___api_key_to_uint+0x558 installed by the following

function:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000007f3d44 execute+0x45c()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x4000000000830cc0 curs_fetch+0x68()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000007c8130 s_execute+0x1780()

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x400000000094ad80 reset__dlreq+0x40 installed by the following function:

-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000008134c8 sequencer+0x248()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000009057f8 tdsrecv_fetch+0x80()

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x4000000000963ae0 cm__wash_mass_clock+0x3b0 installed by the following f

unction:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x4000000000b874c8 pthread_create+0x8 installed by the following function

:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  [Handler pc: 0x4000000000b874c8 pthread_create+0x8 installed by the following function

:-]

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x4000000000760ad0 conn_hdlr+0x21f8()

02:00000:00168:2007/06/25 20:47:31.30 kernel  pc: 0x40000000007f38c0 proc_stack_switch+0x40()

02:00000:00168:2007/06/25 20:47:31.30 kernel  end of stack trace, spid 168, kpid 786628686, suid 49

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

메모리 관련 튜닝이 필요합니다.

sp_monitorconfig 'procedure cache size'

로 cache사이즈 확인후

부족하다면 늘려야 될 듯...

sp_configure 'procedure cache size'

sybase에 문의해서 처리하시는 게 나을듯 합니다.

영빈~(backfish)님이 2007-06-26 13:32에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
1964asiq 백업 정책과 transaction log 백업은? [1]
박현수
2007-06-27
5169
1963char VS varchar [2]
궁금이
2007-06-27
5709
1962sysprotects에서 [1]
이은영
2007-06-26
5370
1961errorlog 내용좀 봐주세요 [1]
이은영
2007-06-26
5709
1960페이징 쿼리 예제를 sybase.co.kr에서 찾고 있습니다. [1]
김민성
2007-06-26
7131
1959bcp를 웹상에서 실행하고 싶은대 가능한가요? [1]
참잘했어요
2007-06-23
5398
1958sp_spaceused 중에서 [3]
바람
2007-06-22
5833
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.017초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다