免费注册 查看新帖 |

Chinaunix

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

紧急求助sybase使用问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-05-06 17:49 |只看该作者 |倒序浏览
这些日子,我的数据库总是出现问题,错误提示如下:
01:00000:00000:2009/05/06 13:42:40.71 kernel  sddone: read error on virtual disk 21 block 141569:
01:00000:00000:2009/05/06 13:42:40.71 kernel  sddone: Windows NT system error 1450: Unforseen error.
01:00000:00067:2009/05/06 13:42:42.65 kernel  Symbolic stack trace information is successfully loaded
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00C57F38 os_get_cur_stk_desc+ 0x170 (0x71B3E934, 0x7C821A60, 0x7C824598, 0xFFFFFFFF)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00C57F38 os_get_cur_stk_desc+ 0x170 (0x71B3E934, 0x71B3E6EC, 0x0000270F, 0x00000002)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00C2D4D5 pcstkwalk+ 0x204 (0x00B600B6, 0x00000002, 0x0000270F, 0x00000000)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00C2D15F ucstkgentrace+ 0x25f (0x00B600B6, 0x00000001, 0x71B3ED38, 0x0047E0A
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00BD7A0B ucbacktrace+ 0xab (0x00000008, 0x00000017, 0x00000018, 0x00000001)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x004D450B des__errhdl+ 0x24 (0x00000008, 0x00000017, 0x00000018, 0x00000001)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x0047E0A8 ex_raise+ 0x2b3 (0x644C1A48, 0x06D3B9A4, 0x71B3FF4C, 0x0144B184)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x004F8D1F bufread+ 0xae7 (0x06D3B9A4, 0x00000002, 0x00000020, 0x71B3F000)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x0061C2AE getpage_with_validation+ 0x90e (0x06D3B9A4, 0x71B3F0B0, 0x00000002, 0x00000020)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x0061DBDC getpage_noscan_with_validation+ 0x136 (0x06D3B9A4, 0x00022901, 0x71B3F0B0, 0x00000002)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x0054045A pg_latchoam+ 0x48 (0x00000004, 0x049C698C, 0x71B3F108, 0x05B61560)
01:00000:00067:2009/05/06 13:42:42.68 kernel  [Handler pc: 0x0047E128 hdl_backout_msg  installed by the following function:-]
01:00000:00067:2009/05/06 13:42:42.68 kernel  [Handler pc: 0x0047E128 hdl_backout_msg  installed by the following function:-]
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x005AA5CC at_get+ 0x253 (0x049C698C, 0x00000001, 0x00569388, 0x00000001)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x004CF407 des__fill_dolinfo+ 0x1f (0x049C698C, 0x05B61560, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:42:42.68 kernel  [Handler pc: 0x004D44E7 des__errhdl  installed by the following function:-]
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x004D603E des__fill_common+ 0x7ce (0x049C698C, 0x05B61560, 0x00000003, 0x00000000)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x004CF3E2 des__fill+ 0x600 (0x05B61560, 0x00000003, 0x00000000, 0x109D2A44)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x004C8BC9 des_get+ 0x13a0 (0x71B3F588, 0x00000003, 0x05B61560, 0x109D2A44)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00609D29 open_for_cacheid+ 0x724 (0x109D000D, 0x00000003, 0x00000002, 0x109D2A44)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00609B27 open_for_cacheid+ 0x522 (0x00000000, 0x00000000, 0x109D000D, 0x00000002)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00609348 open_user_table+ 0xb8 (0x109D29C4, 0x00000002, 0x00000000, 0x71B3FF4C)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x0081ED89 get_range_sdes+ 0xb7 (0x00000000, 0x101C2E70, 0x00000000, 0x101C0004)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x0081E4FC open_range+ 0x68c (0x101C2DEC, 0x71B3F76C, 0x71B3F75C, 0x00000000)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00827259 col_open_range+ 0x34 (0x136F9800, 0x101C2DEC, 0x00000001, 0x06D3B414)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x00822E55 colnames_driver+ 0x45 (0x136F9800, 0x00000000, 0x00000001, 0x06D3B414)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x007ED90A s_normquery+ 0x17c (0x136F9800, 0x00000000, 0x206F746E, 0x4B575A23)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x007F32BB s__call_normquery+ 0x89 (0x00000000, 0x00000000, 0x7C957D59, 0x7C81B012)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x007EC9C4 s_normalize+ 0x83e (0x101C2800, 0x71B3FF4C, 0x0144B184, 0x000000B6)
01:00000:00067:2009/05/06 13:42:42.68 kernel  [Handler pc: 0x007EF612 s_handle  installed by the following function:-]
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x007EA175 sequencer+ 0x405 (0x06D3B400, 0x00000000, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:42:42.68 kernel  pc: 0x0045DB68 tdsrecv_language+ 0x552 (0x00000034, 0x00000000, 0x00000000, 0x0BCFB130)
01:00000:00067:2009/05/06 13:42:42.76 kernel  [Handler pc: 0x0047E114 hdl_backout  installed by the following function:-]
01:00000:00067:2009/05/06 13:42:42.76 kernel  [Handler pc: 0x00708ED0 ut_handle  installed by the following function:-]
01:00000:00067:2009/05/06 13:42:42.76 kernel  [Handler pc: 0x00708ED0 ut_handle  installed by the following function:-]
01:00000:00067:2009/05/06 13:42:42.76 kernel  pc: 0x004235D6 conn_hdlr+ 0x37a2 (0x0BCFB130, 0x00000000, 0x00000000, 0x0BCFB130)
01:00000:00067:2009/05/06 13:42:42.78 kernel  pc: 0x00BCCAD7 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:42:42.78 kernel  pc: 0x7C82482F GetModuleHandleA+ 0xdf (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:42:42.78 kernel  end of stack trace, spid 67, kpid 11927734, suid 23
01:00000:00067:2009/05/06 13:42:42.81 server  Error: 823, Severity: 24, State: 1
01:00000:00067:2009/05/06 13:42:42.82 server  I/O error detected during read for BUF=0x644C1A48, MASS=0x644C1A48, Buf#=0, page=0x22DB8800, dbid=13, Mass vpage=352463105, Buf lpage=141569, Mass stat=0x4000100, Buf stat=0x1, size=2048, cid=0 ('default data cache'), Pinned xdes=0x00000000, spid=0.
01:00000:00000:2009/05/06 13:43:15.20 kernel  sddone: read error on virtual disk 22 block 204830:
01:00000:00000:2009/05/06 13:43:15.20 kernel  sddone: Windows NT system error 1450: Unforseen error.
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00C57F38 os_get_cur_stk_desc+ 0x170 (0x71B3E8A0, 0x7C821A60, 0x7C824598, 0xFFFFFFFF)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00C57F38 os_get_cur_stk_desc+ 0x170 (0x71B3E8A0, 0x71B3E658, 0x0000270F, 0x00000002)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00C2D4D5 pcstkwalk+ 0x204 (0x00B600B6, 0x00000002, 0x0000270F, 0x00000000)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00C2D15F ucstkgentrace+ 0x25f (0x00B600B6, 0x00000001, 0x71B3ECA4, 0x0047E0A
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00BD7A0B ucbacktrace+ 0xab (0x00000008, 0x00000017, 0x00000018, 0x00000001)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x004D450B des__errhdl+ 0x24 (0x00000008, 0x00000017, 0x00000018, 0x00000001)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x0047E0A8 ex_raise+ 0x2b3 (0x644CAD88, 0x06D3B9A4, 0x71B3FF4C, 0x0144B184)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x004F8D1F bufread+ 0xae7 (0x06D3B9A4, 0x00000004, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x0061C2AE getpage_with_validation+ 0x90e (0x06D3B9A4, 0x00000003, 0x0000000D, 0xFFFFFFFE)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x0060E3EB apl_getnext+ 0x20b5 (0x06D3B9A4, 0x06D3B9A4, 0x04116EB1, 0x38000001)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x0060BF02 getnext+ 0x1a2 (0x00000050, 0x0CBAE877, 0x71B3F334, 0x0000000D)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x0081FBD5 getcoloff+ 0x9d (0x04C8C564, 0x05B61560, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:43:15.20 kernel  [Handler pc: 0x004D44E7 des__errhdl  installed by the following function:-]
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x004D6243 des__fill_common+ 0x9d3 (0x04C8C564, 0x05B61560, 0x00000003, 0x00000000)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x004CF3E2 des__fill+ 0x600 (0x05B61560, 0x00000003, 0x00000000, 0x13550244)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x004C8BC9 des_get+ 0x13a0 (0x71B3F588, 0x00000003, 0x05B61560, 0x13550244)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00609D29 open_for_cacheid+ 0x724 (0x1355000D, 0x00000003, 0x00000002, 0x13550244)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00609B27 open_for_cacheid+ 0x522 (0x00000000, 0x00000000, 0x1355000D, 0x00000002)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00609348 open_user_table+ 0xb8 (0x135501C4, 0x00000002, 0x00000000, 0x71B3FF4C)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x0081ED89 get_range_sdes+ 0xb7 (0x00000000, 0x10AA3E70, 0x00000000, 0x10AA0004)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x0081E4FC open_range+ 0x68c (0x10AA3DEC, 0x71B3F76C, 0x71B3F75C, 0x00000000)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00827259 col_open_range+ 0x34 (0x105F5000, 0x10AA3DEC, 0x00000001, 0x06D3B414)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00822E55 colnames_driver+ 0x45 (0x105F5000, 0x00000000, 0x00000001, 0x06D3B414)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x007ED90A s_normquery+ 0x17c (0x105F5000, 0x00000000, 0x206F746E, 0x4B575A23)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x007F32BB s__call_normquery+ 0x89 (0x00000000, 0x00000000, 0x7C957D59, 0x7C81B012)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x007EC9C4 s_normalize+ 0x83e (0x10AA3800, 0x71B3FF4C, 0x0144B184, 0x000000B6)
01:00000:00067:2009/05/06 13:43:15.20 kernel  [Handler pc: 0x007EF612 s_handle  installed by the following function:-]
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x007EA175 sequencer+ 0x405 (0x06D3B400, 0x00000000, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x0045DB68 tdsrecv_language+ 0x552 (0x00000034, 0x00000000, 0x00000000, 0x0BCFB130)
01:00000:00067:2009/05/06 13:43:15.20 kernel  [Handler pc: 0x0047E114 hdl_backout  installed by the following function:-]
01:00000:00067:2009/05/06 13:43:15.20 kernel  [Handler pc: 0x00708ED0 ut_handle  installed by the following function:-]
01:00000:00067:2009/05/06 13:43:15.20 kernel  [Handler pc: 0x00708ED0 ut_handle  installed by the following function:-]
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x004235D6 conn_hdlr+ 0x37a2 (0x0BCFB130, 0x00000000, 0x00000000, 0x0BCFB130)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x00BCCAD7 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:43:15.20 kernel  pc: 0x7C82482F GetModuleHandleA+ 0xdf (0x00000000, 0x00000000, 0x00000000, 0x00000000)
01:00000:00067:2009/05/06 13:43:15.20 kernel  end of stack trace, spid 67, kpid 11927734, suid 23
01:00000:00067:2009/05/06 13:43:15.20 server  Error: 823, Severity: 24, State: 1
01:00000:00067:2009/05/06 13:43:15.20 server  I/O error detected during read for BUF=0x644CAD88, MASS=0x644CAD88, Buf#=0, page=0x22E50800, dbid=13, Mass vpage=369303582, Buf lpage=972830, Mass stat=0x4000100, Buf stat=0x1, size=2048, cid=0 ('default data cache'), Pinned xdes=0x00000000, spid=0.
01:00000:00000:2009/05/06 13:43:41.96 kernel  sddone: write error on virtual disk 9 block 2233344:
01:00000:00000:2009/05/06 13:43:41.96 kernel  sddone: Windows NT system error 1450: Unforseen error.

一出现以上错误,sybase就瘫痪了,其中Windows NT system error 1450: Unforseen error.,我查了一下,1450是系统资源不足的意思,我也按照微软网站上修改了注册表,可是还是总出现这样的错误,请问各位大侠,该怎么解决啊??急死我了
对了我的系统是windows 2003 ent 数据库是sybase12.5.3

论坛徽章:
0
2 [报告]
发表于 2009-05-06 18:29 |只看该作者
磁盘或者设备有问题

论坛徽章:
34
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
3 [报告]
发表于 2009-05-07 15:02 |只看该作者
按照上面的错误,看一下你的硬盘或设备是否为物理损坏,如果是物理损坏,这会能把数据备份出来是当务之急!

论坛徽章:
0
4 [报告]
发表于 2009-05-31 18:27 |只看该作者
磁盘或存储设备有问题,抓紧时间处理。问题很严重。

论坛徽章:
0
5 [报告]
发表于 2009-06-01 23:04 |只看该作者
以前遇到过这种问题,当时以为是盘阵的磁盘坏了,正好有两个亮灯了,盘阵里看上去也像是硬盘故障,就给换了,结果正常了一段时间,后来又报错,再次检查才发现是盘阵上的光纤通道卡有问题了
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP