sybase服务自动退出，请问有人知道是什么原因吗？

zhouscy

免费乐捐，感谢支持

我单位用的是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

flybean

先增加ASE timeslice（cpu grace time） 值，再观察

[此贴子已经被作者于2006-11-15 22:26:15编辑过]

zhouscy

谢谢flybean，这个方法我试过，似乎不管用，改了以后，仍然有问题。

我的这个问题以前在chinaunix上也提过，地址： http://bbs.chinaunix.net/viewthread.php?tid=800411&highlight=zhouscy，有几个人开头还帮我支了会招，后面就不见了。

能麻烦你再帮我看看吗？先谢了

flybean

怀疑是ASE的一个BUG，注意到你的版本是12.5.0.3，建议与SYBASE联系，升级到12.5.3。
TIMESLICE错误的处理，虽然通常会建议增加grace time的值，但很大的可能是由于系统自身的BUG导致，因此最好的办法是更新ASE。

flybean

BTW，你下载一个12。5。3的EBF，然后仔细检查一下bug fixed清单，看是否有符合的

zhouscy

明白了，看来也只好这样了。再次感谢flybean

hobbylu

需要检查你的sql语句

zhouscy

免费乐捐，感谢支持

QUOTE:

以下是引用hobbylu在2006-11-17 14:45:10的发言：
需要检查你的sql语句

请问你的意思是说这个问题是和应用程序有关了？

我曾给软件开发商提过这个问题，以下是记录：

问：“升级前月末有时候速度慢，但是不会把服务挂掉，现在动不动就挂了，有时服务器都挂了，很郁闷！”

答复“现在为了记录日志,一个用户有两个进程,导致对服务器的连接翻倍,可能会引起死锁或服务器资源紧张.有的单位服务器参数优化时留有余地,就感觉不到.有的单位服务器参数优化时只是刚好,可能会感觉到慢或其他现象.”

看起来这个问题还很复杂，优化服务器又超出了我的水平，现在大概只能先凑合了。

[此贴子已经被作者于2006-11-18 1:07:54编辑过]

weibaigr

不知道你这个问题解决了没有?我公司也遇到这个问题.

weibaigr

timeslice时间片问题怎么解决啊?

flybean

之前已讲过,timeslice的问题通常是由ASE自身的BUG导致的,请查看targeted cr-list