sybase服务自动退出，请问有人知道是什么原因吗？
<p>我单位用的是IBM P650，带8个cpu，12G内存，用于运行财务管理程序，总的用户数300多，并发用户一般200来人。sybase是12.5.0.3，已经打了ebf11445。最近升级完开发商提供的财务软件后，已多次出现sybase服务自动宕机的故障，提示信息我也看不懂，不知道有没有高手能指点一下，看是什么原因，谢谢！</p><p>日志信息：</p><p>00:00000:00020:2006/11/14 10:14:58.52 kernel Cannot read, host process disconnected: 1396 spid: 20<br/>00:00000:00009:2006/11/14 10:19:08.17 kernel timeslice -501, current process infected<br/>00:00000:00009:2006/11/14 10:19:08.19 kernel Spinlocks held by kpid 7602292</p><p>00:00000:00009:2006/11/14 10:19:08.19 kernel Spinlock Resource->rdesmgr_spin at address 0000000160267b40 owned by 7602292<br/>00:00000:00009:2006/11/14 10:19:08.23 kernel End of spinlock display.<br/>00:00000:00009:2006/11/14 10:19:08.29 kernel pc: 0x0000000100356a88 .pcstkwalk+0x88()<br/>00:00000:00009:2006/11/14 10:19:08.29 kernel pc: 0x0000000100357140 .ucstkgentrace+0x238()<br/>00:00000:00009:2006/11/14 10:19:08.29 kernel pc: 0x0000000100355ed0 .ucbacktrace+0x78()<br/>00:00000:00009:2006/11/14 10:19:08.31 kernel pc: 0x00000001002236f0 .terminate_process+0x2c()<br/>00:00000:00009:2006/11/14 10:19:08.33 kernel pc: 0x000000010059b80c .kaclkintr+0x124()<br/>00:00000:00009:2006/11/14 10:19:08.33 kernel pc: 0x00000001788195a0 ()<br/>00:00000:00009:2006/11/14 10:19:08.33 kernel <br/>00:00000:00009:2006/11/14 10:19:08.35 kernel pc: 0x00000001000b3540 .checkpoint+0x240()<br/>00:00000:00009:2006/11/14 10:19:08.39 kernel <br/>00:00000:00009:2006/11/14 10:19:08.41 kernel pc: 0x00000001000a495c .dmpx__truncatemain+0x828()<br/>00:00000:00009:2006/11/14 10:19:08.41 kernel <br/>00:00000:00009:2006/11/14 10:19:08.43 kernel pc: 0x00000001000f4060 .qualsargs+0x60()<br/>00:00000:00009:2006/11/14 10:19:08.43 kernel pc: 0x0000000100112c80 .ckptproc+0x18()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000100015740 +0x1c()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x000000010001571c .kpinitproc+0x1c()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel pc: 0x0000000000000000 ()<br/>00:00000:00009:2006/11/14 10:19:08.45 kernel end of stack trace, spid 9, kpid 7602292, suid 0<br/>00:00000:00009:2006/11/14 10:19:08.46 kernel ueshutdown: exiting<br/>02:00000:00365:2006/11/14 10:19:58.17 kernel timeslice -501, current process infected<br/>02:00000:00365:2006/11/14 10:19:58.17 kernel ************************************<br/>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<br/>02:00000:00365:2006/11/14 10:19:58.18 kernel ************************************<br/>06:00000:00743:2006/11/14 10:19:58.20 kernel timeslice -501, current process infected<br/>06:00000:00743:2006/11/14 10:19:58.20 kernel ************************************<br/>06:00000:00743:2006/11/14 10:19:58.20 kernel SQL causing error : SELECT F_GD FROM LSZHGD WHERE F_ZH ='10' <br/>06:00000:00743:2006/11/14 10:19:58.20 kernel ************************************<br/>06:00000:00743:2006/11/14 10:19:58.20 server SQL Text: SELECT F_GD FROM LSZHGD WHERE F_ZH ='10' <br/>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)<br/>06:00000:00743:2006/11/14 10:19:58.21 kernel curdb = 22 pstat = 0x10000 lasterror = 0 <br/>02:00000:00365:2006/11/14 10:19:58.21 kernel curdb = 9 pstat = 0x10000 lasterror = 0 <br/>06:00000:00743:2006/11/14 10:19:58.21 kernel preverror = 0 transtate = 1<br/>02:00000:00365:2006/11/14 10:19:58.21 kernel preverror = 0 transtate = 1<br/>06:00000:00743:2006/11/14 10:19:58.21 kernel curcmd = 193 program = LSCW <br/>02:00000:00365:2006/11/14 10:19:58.21 kernel curcmd = 0 program = LSCW <br/>02:00000:00365:2006/11/14 10:19:58.21 kernel pc: 0x0000000100356a88 .pcstkwalk+0x88()<br/>02:00000:00365:2006/11/14 10:19:58.21 kernel pc: 0x0000000100357140 .ucstkgentrace+0x238()<br/>02:00000:00365:2006/11/14 10:19:58.21 kernel pc: 0x0000000100355ed0 .ucbacktrace+0x78()<br/>02:00000:00365:2006/11/14 10:19:58.22 kernel pc: 0x0000000100223ec4 .terminate_process+0x800()<br/>02:00000:00365:2006/11/14 10:19:58.22 kernel <br/>02:00000:00365:2006/11/14 10:19:58.25 kernel pc: 0x000000010059b80c .kaclkintr+0x124()<br/>04:00000:00782:2006/11/14 10:19:58.27 kernel timeslice -501, current process infected<br/>04:00000:00782:2006/11/14 10:19:58.27 kernel ************************************<br/>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' <br/>04:00000:00782:2006/11/14 10:19:58.27 kernel ************************************<br/>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' <br/>04:00000:00782:2006/11/14 10:19:58.27 kernel curdb = 22 pstat = 0x10000 lasterror = 0 <br/>04:00000:00782:2006/11/14 10:19:58.27 kernel preverror = 0 transtate = 0<br/>04:00000:00782:2006/11/14 10:19:58.27 kernel curcmd = 0 program = LSCW <br/>01:00000:00870:2006/11/14 10:19:58.29 kernel timeslice -501, current process infected<br/>01:00000:00870:2006/11/14 10:19:58.29 kernel ************************************<br/>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_<br/>01:00000:00870:2006/11/14 10:19:58.29 kernel ************************************<br/>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 )<br/>01:00000:00870:2006/11/14 10:19:58.29 kernel curdb = 7 pstat = 0x10000 lasterror = 0 <br/>02:00000:00365:2006/11/14 10:19:58.29 kernel pc: 0x00000001000dc8ac .dropo+0x118()<br/>01:00000:00870:2006/11/14 10:19:58.29 kernel preverror = 3701 transtate = 0<br/>01:00000:00870:2006/11/14 10:19:58.29 kernel curcmd = 198 program = LSCW <br/>02:00000:00365:2006/11/14 10:19:58.31 kernel <br/>02:00000:00365:2006/11/14 10:19:58.32 kernel pc: 0x00000001000d52dc .des_install_pre_firstopen+0xc8()<br/>02:00000:00365:2006/11/14 10:19:58.36 kernel <br/>02:00000:00365:2006/11/14 10:19:58.36 kernel pc: 0x00000001000e6b58 .drop_with_retry+0xd8()<br/>02:00000:00365:2006/11/14 10:19:58.39 kernel pc: 0x0000000100073430 .tdsrecv_language+0x58()<br/>02:00000:00365:2006/11/14 10:19:58.39 kernel pc: 0x00000001000e7930 .tmp_dropto+0x14()<br/>02:00000:00365:2006/11/14 10:19:58.40 kernel <br/>02:00000:00365:2006/11/14 10:19:58.41 kernel <br/>02:00000:00365:2006/11/14 10:19:58.41 kernel <br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x000000010006fb60 .sequencer+0xec()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000100015740 +0x1c()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pcstkwalk: exception stack underflow occurred.<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x00000001000733c0 .result+0x6c()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000100239440 .mda_nap_data_createinit_fn+0x18()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x000000010001571c .kpinitproc+0x1c()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel pc: 0x0000000000000000 ()<br/>02:00000:00365:2006/11/14 10:19:58.41 kernel end of stack trace, spid 365, kpid 655360293, suid 3614<br/></p> 先增加ASE timeslice（cpu grace time） 值，再观察[此贴子已经被作者于2006-11-15 22:26:15编辑过]
<p>谢谢<font color="#000000"><strong>flybean，</strong>这个方法我试过，似乎不管用，改了以后，仍然有问题。</font></p><p>我的这个问题以前在chinaunix上也提过，地址： <a href="http://bbs.chinaunix.net/viewthread.php?tid=800411&highlight=zhouscy">http://bbs.chinaunix.net/viewthread.php?tid=800411&highlight=zhouscy</a>，有几个人开头还帮我支了会招，后面就不见了。</p><p>能麻烦你再帮我看看吗？先谢了</p><p><strong><font color="#ff0000"></font></strong></p> 怀疑是ASE的一个BUG，注意到你的版本是12.5.0.3，建议与SYBASE联系，升级到12.5.3。<br/>TIMESLICE错误的处理，虽然通常会建议增加grace time的值，但很大的可能是由于系统自身的BUG导致，因此最好的办法是更新ASE。<br/> BTW，你下载一个12。5。3的EBF，然后仔细检查一下bug fixed清单，看是否有符合的<br/> 明白了，看来也只好这样了。再次感谢<font color="#000000"><strong>flybean</strong></font> 需要检查你的sql语句 <div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>hobbylu</i>在2006-11-17 14:45:10的发言：</b><br/>需要检查你的sql语句</div><p>请问你的意思是说这个问题是和应用程序有关了？</p><p>我曾给软件开发商提过这个问题，以下是记录：</p><p>问：“升级前月末有时候速度慢，但是不会把服务挂掉，现在动不动就挂了，有时服务器都挂了，很郁闷！”</p><p>答复“现在为了记录日志,一个用户有两个进程,导致对服务器的连接翻倍,可能会引起死锁或服务器资源紧张.有的单位服务器参数优化时留有余地,就感觉不到.有的单位服务器参数优化时只是刚好,可能会感觉到慢或其他现象.”</p><p></p><p>看起来这个问题还很复杂，优化服务器又超出了我的水平，现在大概只能先凑合了。</p>
[此贴子已经被作者于2006-11-18 1:07:54编辑过]
<p>不知道你这个问题解决了没有?我公司也遇到这个问题.</p> timeslice时间片问题怎么解决啊? 之前已讲过,timeslice的问题通常是由ASE自身的BUG导致的,请查看targeted cr-list<br/>
页:
[1]