马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?站点注册
×
我单位用的是IBM P650,带8个cpu,12G内存,用于运行财务管理程序,总的用户数300多,并发用户一般200来人。sybase是12.5.0.3,已经打了ebf11445。最近升级完开发商提供的财务软件后,已多次出现sybase服务自动宕机的故障,提示信息我也看不懂,不知道有没有高手能指点一下,看是什么原因,谢谢! 日志信息: 00:00000:00020:2006/11/14 10:14:58.52 kernel Cannot read, host process disconnected: 1396 spid: 20 00:00000:00009:2006/11/14 10:19:08.17 kernel timeslice -501, current process infected 00:00000:00009:2006/11/14 10:19:08.19 kernel Spinlocks held by kpid 7602292 00:00000:00009:2006/11/14 10:19:08.19 kernel Spinlock Resource->rdesmgr_spin at address 0000000160267b40 owned by 7602292 00:00000:00009:2006/11/14 10:19:08.23 kernel End of spinlock display. 00:00000:00009:2006/11/14 10:19:08.29 kernel pc: 0x0000000100356a88 .pcstkwalk+0x88() 00:00000:00009:2006/11/14 10:19:08.29 kernel pc: 0x0000000100357140 .ucstkgentrace+0x238() 00:00000:00009:2006/11/14 10:19:08.29 kernel pc: 0x0000000100355ed0 .ucbacktrace+0x78() 00:00000:00009:2006/11/14 10:19:08.31 kernel pc: 0x00000001002236f0 .terminate_process[3]+0x2c() 00:00000:00009:2006/11/14 10:19:08.33 kernel pc: 0x000000010059b80c .kaclkintr[10]+0x124() 00:00000:00009:2006/11/14 10:19:08.33 kernel pc: 0x00000001788195a0 () 00:00000:00009:2006/11/14 10:19:08.33 kernel [Handler pc: 0x00000001002244c0 .hdl_backout_msg installed by the following function:-] 00:00000:00009:2006/11/14 10:19:08.35 kernel pc: 0x00000001000b3540 .checkpoint[1]+0x240() 00:00000:00009:2006/11/14 10:19:08.39 kernel [Handler pc: 0x00000001006f8150 .dpdb_handle installed by the following function:-] 00:00000:00009:2006/11/14 10:19:08.41 kernel pc: 0x00000001000a495c .dmpx__truncatemain+0x828() 00:00000:00009:2006/11/14 10:19:08.41 kernel [Handler pc: 0x000000010089bc4c .ckptproc_backout installed by the following function:-] 00:00000:00009:2006/11/14 10:19:08.43 kernel pc: 0x00000001000f4060 .qualsargs[7]+0x60() 00:00000:00009:2006/11/14 10:19:08.43 kernel pc: 0x0000000100112c80 .ckptproc[1]+0x18() 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000100015740 +0x1c() 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x000000010001571c .kpinitproc[1]+0x1c() 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 () 00:00000:00009:2006/11/14 10:19:08.45 kernel end of stack trace, spid 9, kpid 7602292, suid 0 00:00000:00009:2006/11/14 10:19:08.46 kernel ueshutdown: exiting 02:00000:00365:2006/11/14 10:19:58.17 kernel timeslice -501, current process infected 02:00000:00365:2006/11/14 10:19:58.17 kernel ************************************ 02:00000:00365:2006/11/14 10:19:58.18 kernel SQL causing error : create table #lsryzy7349 (F_DATE char(8) NULL,F_PZBH varchar(30) NULL,F_DAXH char(100) NULL,F_JY varchar(60) NULL,F_JFJE u001 NULL,F_DFJE u001 02:00000:00365:2006/11/14 10:19:58.18 kernel ************************************ 06:00000:00743:2006/11/14 10:19:58.20 kernel timeslice -501, current process infected 06:00000:00743:2006/11/14 10:19:58.20 kernel ************************************ 06:00000:00743:2006/11/14 10:19:58.20 kernel SQL causing error : SELECT F_GD FROM LSZHGD WHERE F_ZH ='10' 06:00000:00743:2006/11/14 10:19:58.20 kernel ************************************ 06:00000:00743:2006/11/14 10:19:58.20 server SQL Text: SELECT F_GD FROM LSZHGD WHERE F_ZH ='10' 02:00000:00365:2006/11/14 10:19:58.19 server SQL Text: create table #lsryzy7349 (F_DATE char(8) NULL,F_PZBH varchar(30) NULL,F_DAXH char(100) NULL,F_JY varchar(60) NULL,F_JFJE u001 NULL,F_DFJE u001 NULL,F_YEFX char(2) NULL,F_DQYE u001 NULL,F_ZYYH int NULL) 06:00000:00743:2006/11/14 10:19:58.21 kernel curdb = 22 pstat = 0x10000 lasterror = 0 02:00000:00365:2006/11/14 10:19:58.21 kernel curdb = 9 pstat = 0x10000 lasterror = 0 06:00000:00743:2006/11/14 10:19:58.21 kernel preverror = 0 transtate = 1 02:00000:00365:2006/11/14 10:19:58.21 kernel preverror = 0 transtate = 1 06:00000:00743:2006/11/14 10:19:58.21 kernel curcmd = 193 program = LSCW 02:00000:00365:2006/11/14 10:19:58.21 kernel curcmd = 0 program = LSCW 02:00000:00365:2006/11/14 10:19:58.21 kernel pc: 0x0000000100356a88 .pcstkwalk+0x88() 02:00000:00365:2006/11/14 10:19:58.21 kernel pc: 0x0000000100357140 .ucstkgentrace+0x238() 02:00000:00365:2006/11/14 10:19:58.21 kernel pc: 0x0000000100355ed0 .ucbacktrace+0x78() 02:00000:00365:2006/11/14 10:19:58.22 kernel pc: 0x0000000100223ec4 .terminate_process[3]+0x800() 02:00000:00365:2006/11/14 10:19:58.22 kernel [Handler pc: 0x00000001002244c0 .hdl_backout_msg installed by the following function:-] 02:00000:00365:2006/11/14 10:19:58.25 kernel pc: 0x000000010059b80c .kaclkintr[10]+0x124() 04:00000:00782:2006/11/14 10:19:58.27 kernel timeslice -501, current process infected 04:00000:00782:2006/11/14 10:19:58.27 kernel ************************************ 04:00000:00782:2006/11/14 10:19:58.27 kernel SQL causing error : select F_GNBH from LSUSGN where F_GNBH ='0130' and F_ZGBH ='3073' 04:00000:00782:2006/11/14 10:19:58.27 kernel ************************************ 04:00000:00782:2006/11/14 10:19:58.27 server SQL Text: select F_GNBH from LSUSGN where F_GNBH ='0130' and F_ZGBH ='3073' 04:00000:00782:2006/11/14 10:19:58.27 kernel curdb = 22 pstat = 0x10000 lasterror = 0 04:00000:00782:2006/11/14 10:19:58.27 kernel preverror = 0 transtate = 0 04:00000:00782:2006/11/14 10:19:58.27 kernel curcmd = 0 program = LSCW 01:00000:00870:2006/11/14 10:19:58.29 kernel timeslice -501, current process infected 01:00000:00870:2006/11/14 10:19:58.29 kernel ************************************ 01:00000:00870:2006/11/14 10:19:58.29 kernel SQL causing error : u001 default 0 ,F_QTXX varchar(30) null,F_QRBZ char(1) not null,F_YSBH varchar(20) null,F_CODEMC varchar(60) null,F_QRXM varchar(20) null,F_ 01:00000:00870:2006/11/14 10:19:58.29 kernel ************************************ 01:00000:00870:2006/11/14 10:19:58.29 server SQL Text: u001 default 0 ,F_QTXX varchar(30) null,F_QRBZ char(1) not null,F_YSBH varchar(20) null,F_CODEMC varchar(60) null,F_QRXM varchar(20) null,F_QRSJ char(8) null,F_QRRY varchar(20) null, F_QRYY varchar(200) null ) 01:00000:00870:2006/11/14 10:19:58.29 kernel curdb = 7 pstat = 0x10000 lasterror = 0 02:00000:00365:2006/11/14 10:19:58.29 kernel pc: 0x00000001000dc8ac .dropo[1]+0x118() 01:00000:00870:2006/11/14 10:19:58.29 kernel preverror = 3701 transtate = 0 01:00000:00870:2006/11/14 10:19:58.29 kernel curcmd = 198 program = LSCW 02:00000:00365:2006/11/14 10:19:58.31 kernel [Handler pc: 0x0000000100178970 .droperr installed by the following function:-] 02:00000:00365:2006/11/14 10:19:58.32 kernel pc: 0x00000001000d52dc .des_install_pre_firstopen+0xc8() 02:00000:00365:2006/11/14 10:19:58.36 kernel [Handler pc: 0x00000001001f2b28 .s_handle installed by the following function:-] 02:00000:00365:2006/11/14 10:19:58.36 kernel pc: 0x00000001000e6b58 .drop_with_retry+0xd8() 02:00000:00365:2006/11/14 10:19:58.39 kernel pc: 0x0000000100073430 .tdsrecv_language[1]+0x58() 02:00000:00365:2006/11/14 10:19:58.39 kernel pc: 0x00000001000e7930 .tmp_dropto[2]+0x14() 02:00000:00365:2006/11/14 10:19:58.40 kernel [Handler pc: 0x00000001001da5bc .hdl_backout installed by the following function:-] 02:00000:00365:2006/11/14 10:19:58.41 kernel [Handler pc: 0x0000000100454f28 .ut_handle installed by the following function:-] 02:00000:00365:2006/11/14 10:19:58.41 kernel [Handler pc: 0x0000000100454f28 .ut_handle installed by the following function:-] 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x000000010006fb60 .sequencer[2]+0xec() 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000100015740 +0x1c() 02:00000:00365:2006/11/14 10:19:58.41 kernel pcstkwalk: exception stack underflow occurred. 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x00000001000733c0 .result[4]+0x6c() 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000100239440 .mda_nap_data_createinit_fn+0x18() 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x000000010001571c .kpinitproc[1]+0x1c() 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 () 02:00000:00365:2006/11/14 10:19:58.41 kernel end of stack trace, spid 365, kpid 655360293, suid 3614
|