SYBASE错误, 请高手分析一下.

寻路人

00:00000:00084:2005/02/18 11:19:31.85 kernel  Cannot read, host process disconnected: POS157 21822 spid: 84
00:00000:00107:2005/02/18 11:19:43.47 kernel  Cannot read, host process disconnected: POS129 -26343 spid: 107
00:00000:00097:2005/02/18 11:28:31.07 server  Unable to read in login record.
00:00000:00166:2005/02/18 11:28:31.07 kernel  Cannot read, host process disconnected: POS149 20832 spid: 166
01:00000:00112:2005/02/18 11:29:21.35 kernel  timeslice -501, current process infected
01:00000:00112:2005/02/18 11:29:21.36 kernel  ************************************
01:00000:00112:2005/02/18 11:29:21.36 kernel  SQL causing error : select * from TRANDEL

  where ((IsNull(CLFD,0) & power(2,1))) <>;power(2,1)

    and CODE='XTCZYGRP'


01:00000:00112:2005/02/18 11:29:21.36 kernel  ************************************
01:00000:00112:2005/02/18 11:29:21.36 server  SQL Text: select * from TRANDEL

  where ((IsNull(CLFD,0) & power(2,1))) <>;power(2,1)

    and CODE='XTCZYGRP'

01:00000:00112:2005/02/18 11:29:21.36 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
01:00000:00112:2005/02/18 11:29:21.36 kernel  preverror = 0 transtate = 1
01:00000:00112:2005/02/18 11:29:21.36 kernel  curcmd = 0 program =                              
01:00000:00112:2005/02/18 11:29:21.40 kernel  pc: 0x1001073c pcstkwalk+0x3c()
01:00000:00112:2005/02/18 11:29:21.40 kernel  pc: 0x10010de0 ucstkgentrace+0x1b8()
01:00000:00112:2005/02/18 11:29:21.40 kernel  pc: 0x1000f884 ucbacktrace+0xcc()
01:00000:00112:2005/02/18 11:29:21.40 kernel  pc: 0x1000d650 terminate_process+0x884()
01:00000:00112:2005/02/18 11:29:21.40 kernel  pc: 0x100287e4 kaclkintr+0x440()
01:00000:00112:2005/02/18 11:29:21.40 kernel  end of stack trace, spid 112, kpid 1015808133, suid 0
01:00000:00112:2005/02/18 11:29:21.40 server  The SQL Server is terminating this process.
00:00000:00112:2005/02/18 11:29:21.43 kernel  Cannot read, host process disconnected:            spid: 112
00:00000:00068:2005/02/18 11:29:21.44 kernel  Cannot read, host process disconnected: POS157 30606 spid: 68
00:00000:00146:2005/02/18 11:29:21.44 kernel  Cannot read, host process disconnected: POS204 -23795 spid: 146
00:00000:00050:2005/02/18 11:29:21.70 kernel  Cannot read, host process disconnected: POS124 31523 spid: 50
01:00000:00107:2005/02/18 11:30:11.65 kernel  timeslice -501, current process infected
01:00000:00107:2005/02/18 11:30:11.65 kernel  ************************************
01:00000:00107:2005/02/18 11:30:11.65 kernel  SQL causing error : !

01:00000:00107:2005/02/18 11:30:11.65 kernel  ************************************
01:00000:00107:2005/02/18 11:30:11.65 server  SQL Text: !

01:00000:00107:2005/02/18 11:30:11.65 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
01:00000:00107:2005/02/18 11:30:11.65 kernel  preverror = 0 transtate = 1
01:00000:00107:2005/02/18 11:30:11.65 kernel  curcmd = 0 program =                              
01:00000:00107:2005/02/18 11:30:11.65 kernel  pc: 0x1001073c pcstkwalk+0x3c()
01:00000:00107:2005/02/18 11:30:11.65 kernel  pc: 0x10010de0 ucstkgentrace+0x1b8()
01:00000:00107:2005/02/18 11:30:11.65 kernel  pc: 0x1000f884 ucbacktrace+0xcc()
01:00000:00107:2005/02/18 11:30:11.65 kernel  pc: 0x1000d650 terminate_process+0x884()
01:00000:00107:2005/02/18 11:30:11.65 kernel  pc: 0x100287e4 kaclkintr+0x440()
01:00000:00107:2005/02/18 11:30:11.66 kernel  pc: 0x4778 ()
01:00000:00107:2005/02/18 11:30:11.66 kernel  end of stack trace, spid 107, kpid 1015873891, suid 0
00:00000:00107:2005/02/18 11:30:11.66 server  The SQL Server is terminating this process.
01:00000:00173:2005/02/18 11:30:11.66 kernel  Cannot read, host process disconnected: POS154 -21412 spid: 173
01:00000:00153:2005/02/18 11:30:11.67 kernel  Cannot read, host process disconnected: POS188 20748 spid: 153
01:00000:00123:2005/02/18 11:30:12.08 kernel  Cannot read, host process disconnected: POS601 19941 spid: 123
01:00000:00170:2005/02/18 11:30:12.08 kernel  Cannot read, host process disconnected: POS103 25869 spid: 170
01:00000:00063:2005/02/18 11:30:12.08 kernel  Cannot read, host process disconnected: POS131 25424 spid: 63
01:00000:00080:2005/02/18 11:30:12.08 kernel  Cannot read, host process disconnected: POS602 12239 spid: 80
01:00000:00092:2005/02/18 11:30:12.08 kernel  Cannot read, host process disconnected: POS207 28207 spid: 92
01:00000:00012:2005/02/18 11:30:12.08 kernel  Cannot read, host process disconnected: POS135 -6024 spid: 12
01:00000:00102:2005/02/18 11:30:14.55 kernel  Cannot read, host process disconnected: POS210 18872 spid: 102
01:00000:00059:2005/02/18 11:30:23.95 kernel  Cannot read, host process disconnected: POS303 32423 spid: 59
01:00000:00159:2005/02/18 11:30:24.25 kernel  Cannot read, host process disconnected: POS145 19286 spid: 159
01:00000:00045:2005/02/18 11:30:33.94 kernel  Cannot read, host process disconnected:  -283929 spid: 45
01:00000:00010:2005/02/18 11:30:43.98 kernel  Cannot read, host process disconnected: POS105 20432 spid: 10
00:00000:00050:2005/02/18 11:31:01.89 kernel  timeslice -501, current process infected
00:00000:00050:2005/02/18 11:31:01.89 kernel  ************************************
00:00000:00050:2005/02/18 11:31:01.89 kernel  SQL causing error : select SP_ID,NAME,UNIT,PACKED,PFDJ,LSDJ,SPTYPE from SPXX where SPCODE='203035'
00:00000:00050:2005/02/18 11:31:01.89 kernel  ************************************
00:00000:00050:2005/02/18 11:31:01.89 server  SQL Text: select SP_ID,NAME,UNIT,PACKED,PFDJ,LSDJ,SPTYPE from SPXX where SPCODE='203035'
00:00000:00050:2005/02/18 11:31:01.89 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00050:2005/02/18 11:31:01.89 kernel  preverror = 0 transtate = 1
00:00000:00050:2005/02/18 11:31:01.89 kernel  curcmd = 0 program =                              
01:00000:00107:2005/02/18 11:31:01.89 server  Error: 1608, Severity: 18, State: 4
01:00000:00107:2005/02/18 11:31:01.89 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:00107:2005/02/18 11:31:52.15 kernel  timeslice -501, current process infected
01:00000:00107:2005/02/18 11:31:52.15 kernel  ************************************
01:00000:00107:2005/02/18 11:31:52.15 kernel  pc: 0x1001073c pcstkwalk+0x3c()
01:00000:00107:2005/02/18 11:31:52.15 kernel  pc: 0x10010de0 ucstkgentrace+0x1b8()
01:00000:00107:2005/02/18 11:31:52.15 kernel  pc: 0x1000f884 ucbacktrace+0xcc()
01:00000:00107:2005/02/18 11:31:52.15 kernel  pc: 0x1000ced8 terminate_process+0x10c()
01:00000:00107:2005/02/18 11:31:52.15 kernel  pc: 0x100287e4 kaclkintr+0x440()
01:00000:00107:2005/02/18 11:31:52.15 kernel  pc: 0x4778 ()
01:00000:00107:2005/02/18 11:31:52.15 kernel  end of stack trace, spid 107, kpid 1015873891, suid 0
00:00000:00086:2005/02/18 11:31:52.19 kernel  timeslice -501, current process infected
00:00000:00086:2005/02/18 11:31:52.19 kernel  ************************************
00:00000:00086:2005/02/18 11:31:52.19 kernel  SQL causing error :
00:00000:00086:2005/02/18 11:31:52.19 kernel  ************************************
00:00000:00086:2005/02/18 11:31:52.19 server  SQL Text:
00:00000:00086:2005/02/18 11:31:52.19 kernel  curdb = 5 pstat = 0x10000 lasterror = 0
00:00000:00086:2005/02/18 11:31:52.19 kernel  preverror = 0 transtate = 1
00:00000:00086:2005/02/18 11:31:52.19 kernel  curcmd = 0 program =

1017of

贴出完整版本与OS版本号

寻路人

OS: AIX4.3.3    ASE:11.9.2

1017of

sp_configure 'cpu grace time'