免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2269 | 回复: 3
打印 上一主题 下一主题

sybase宕机,请教. [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-03-21 08:17 |只看该作者 |倒序浏览
错误提示如下:
00:07/03/21 05:23:41.30 kernel  current process (0x52de0027) infected with 11
00:07/03/21 05:23:41.34 kernel  Address 0x545a8 (des__hashcheck+0x3, siginfo (
code, address) = (1, 0x1de8004c)
00:07/03/21 05:23:41.34 kernel  ************************************
00:07/03/21 05:23:41.34 kernel  SQL causing error : execute dbo.p_gl_audit_put_j
iedai_nar2;1 @pdate = '3-20-2007 0:0:0.000', @pmode = 'D', @langid = 0
00:07/03/21 05:23:41.34 kernel  curdb = 2 pstat = 0x10000 lasterror = 0
00:07/03/21 05:23:41.34 kernel  preverror = 0 transtate = 0
00:07/03/21 05:23:41.34 kernel  curcmd = 198 program =
00:07/03/21 05:23:41.34 kernel  Spinlocks held by  kpid 1390280743
00:07/03/21 05:23:41.35 kernel  Spinlock Resource->rdesmgr_spin at address 8000b
ee0 owned by 52de0027
00:07/03/21 05:23:41.35 kernel  End of spinlock display.
00:07/03/21 05:23:41.37 kernel  pc: 0x2e4b85 ucbacktrace+0x55(0x0,0x1,0x8019062c
,0x1de8004c,0xb)
00:07/03/21 05:23:41.37 kernel  pc: 0x26d0 terminate_process+0x250(0x0,0xfffffff
f,0x607fe7e3,0x0,0x0)
00:07/03/21 05:23:41.37 kernel  pc: 0x2fb95f kisignal+0x9f(0xb,0x80190824,0x8019
0624,0x0,0x0)
00:07/03/21 05:23:41.37 kernel  pc: 0x351a7c sigismember+0x64(0x81387dd4,0x607fe
7e3,0x0,0x0,0x2)
00:07/03/21 05:23:41.37 kernel  pc: 0x551e6 des__search___1+0x4a(0x804e46f0,0x0,
0x806a3298,0x0,0x0)
00:07/03/21 05:23:41.37 kernel  pc: 0x4d433 des_get___1+0xd7(0x813a0b60,0x2,0x60
7fe7e3,0x0,0x0)
00:07/03/21 05:23:41.37 kernel  pc: 0x1d350c open__byid___1+0xb0(0x65727475,0x61
645f70,0x305f3179,0x607fe7e3,0x81fe7d2
00:07/03/21 05:23:41.37 kernel  pc: 0x1d2f94 open_user_table+0xc4(0x607fe7e3,0x2
,0x63,0x81fe7d28,0x19)
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=1700, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=4500, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=2100, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=2000, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=2700, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=2812, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  pc: 0x15de1c proccreate+0x279c(0x80191314,0x5,0x
0,0x83c98f7c,0x801913ff)
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=2700, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=1700, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  pc: 0x12dc77 crc_ckconstr+0x2e7(0x804e46f0,0x805
3fad0,0x83c99000,0x83c95274,0x7)
00:07/03/21 05:23:41.37 kernel  pc: 0x13db6c crt_constr___1+0x160(0x80192f74,0x1
3b4f7,0x812dfd58,0x1,0x0)
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=2700, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=8400, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=8200, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=1700, sev=0)
installed by the following function]
00:07/03/21 05:23:41.37 kernel  pc: 0x13b74d crt_main+0x1d6d(0x80192fe8,0xd5645,
0x806a3298,0x83cdd000,0x0)
00:07/03/21 05:23:41.37 kernel  pc: 0xd6e6f s_execute+0x1b4f(0x806a3298,0x806a32
98,0x801930ec,0x81259cf8,0x80814e44)
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0xe2070 s_handle(num=0, sev=0) inst
alled by the following function]
00:07/03/21 05:23:41.37 kernel  pc: 0xdfa70 sequencer+0xc70(0x83cdd000,0x8019322
8,0x806a3298,0x82ca03d4,0x82ca03d4)
00:07/03/21 05:23:41.37 kernel  pc: 0xd9a3a execproc+0x2da(0x82ca037c,0x82ca03d4
,0x0,0x0,0x0)
00:07/03/21 05:23:41.37 kernel  pc: 0xd6965 s_execute+0x1645(0x806a3298,0x806a32
98,0x801933c4,0x0,0x0)
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0xe2070 s_handle(num=0, sev=0) inst
alled by the following function]
00:07/03/21 05:23:41.37 kernel  pc: 0xdfa70 sequencer+0xc70(0x822c3000,0x290c33,
0xffffffff,0x4,0x80)
00:07/03/21 05:23:41.37 kernel  pc: 0x21ff4f tdsrecv_language+0x31f(0x0,0x806a32
98,0x0,0x0,0x0)
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0xf0c50 hdl_backout(num=3600, sev=2
5) installed by the following function]
00:07/03/21 05:23:41.37 kernel  [Handler pc: 0x173a30 ut_handle(num=700, sev=0)
installed by the following function]
00:07/03/21 05:23:41.38 kernel  pc: 0x20b3a6 conn_hdlr+0x16b6(0x6,0x801936c0,0x6
a006a,0x0,0x0)
00:07/03/21 05:23:41.38 kernel  pc: 0x2f8e30 kpexit(0x0,0x0,0x5374616b,0x0,0x0)
00:07/03/21 05:23:41.38 kernel  pc: 0x6a006a frexp+0x346236(0x5374616b,0x0,0x0,0
x0,0x0)
00:07/03/21 05:23:41.38 kernel  end of stack trace, spid 11, kpid 1390280743, su
id 4
00:07/03/21 05:23:41.38 kernel  ueshutdown: exiting

我在网上找了一下,好像跟 cpu grace 有关,但不确定.请高手指点.
1> sp_configure 'grace'
2> go
Parameter Name                 Default     Memory Used Config Value Run Value  
------------------------------ ----------- ----------- ------------ -----------
cpu grace time                         500           0         200          200

(return status = 0)

服务器:ibm x346 cpu 2.8  内存 2G

服务器重启动后没有报错.检查数据库,发现可使用空间只有400多M,现已扩容.
因没有错误码,无法查sybase的错误消息.

谢谢!

论坛徽章:
4
2015年亚洲杯之阿联酋
日期:2015-03-10 10:32:022015年亚洲杯之阿曼
日期:2015-03-10 14:53:222015亚冠之水原三星
日期:2015-07-18 15:40:262015亚冠之塔什干棉农
日期:2015-07-27 20:52:05
2 [报告]
发表于 2007-03-21 13:06 |只看该作者
why did you set this parameter to 200?
select @@version

论坛徽章:
0
3 [报告]
发表于 2007-03-21 14:54 |只看该作者

回复 2楼 1017of 的帖子

SQL Server/11.0.3/P/SCO/SCO_SV r3.2v5.0.2/2/OPT/Fri Jul 18 19:10:23 PDT 1997
我也觉得奇怪为什么设为200,我对这个参数也不了解.谢谢!

论坛徽章:
4
2015年亚洲杯之阿联酋
日期:2015-03-10 10:32:022015年亚洲杯之阿曼
日期:2015-03-10 14:53:222015亚冠之水原三星
日期:2015-07-18 15:40:262015亚冠之塔什干棉农
日期:2015-07-27 20:52:05
4 [报告]
发表于 2007-03-21 17:05 |只看该作者
pls restore it to default value at least.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP