免费注册 查看新帖 |

Chinaunix

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

sybase 自动宕机问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2006-11-07 14:44 |只看该作者 |倒序浏览
系统是aix5。2  装好sybase后 重新建帐的时候突然宕机了   错误日志如下
00:00000:00521:2006/11/06 18:08:23.58 kernel  Spinlock Resource->rdesmgr_spin at address 00000001602fdd80 owned by 143328355
00:00000:00521:2006/11/06 18:08:23.82 kernel  End of spinlock display.
01:00000:00446:2006/11/06 18:08:23.82 kernel  ************************************
01:00000:00446:2006/11/06 18:08:23.94 kernel  SQL causing error : SELECT sysprocesses.spid,              sysprocesses.status,              sysprocesses.program_name,              sysprocesses.cmd,              syspro
01:00000:00446:2006/11/06 18:08:23.94 kernel  ************************************
01:00000:00446:2006/11/06 18:08:23.95 server  SQL Text: SELECT sysprocesses.spid,              sysprocesses.status,              sysprocesses.program_name,              sysprocesses.cmd,              sysprocesses.blocked,              sysprocesses.ipaddr        FROM sysprocesses     
01:00000:00446:2006/11/06 18:08:23.95 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
01:00000:00446:2006/11/06 18:08:23.95 kernel  preverror = 0 transtate = 1
01:00000:00446:2006/11/06 18:08:23.95 kernel  curcmd = 0 program =                              
01:00000:00446:2006/11/06 18:08:27.55 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
00:00000:00521:2006/11/06 18:08:27.55 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
01:00000:00446:2006/11/06 18:08:27.55 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
00:00000:00521:2006/11/06 18:08:27.55 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
01:00000:00446:2006/11/06 18:08:27.55 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
00:00000:00521:2006/11/06 18:08:27.55 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
00:00000:00521:2006/11/06 18:08:28.83 kernel  pc: 0x00000001002225c0 .terminate_process[3]+0x2c()
01:00000:00446:2006/11/06 18:08:28.83 kernel  pc: 0x0000000100222d90 .terminate_process[3]+0x7fc()
01:00000:00446:2006/11/06 18:08:29.06 kernel  pc: 0x000000010059a5fc .kaclkintr[10]+0x15c()
00:00000:00521:2006/11/06 18:08:29.06 kernel  pc: 0x000000010059a5fc .kaclkintr[10]+0x15c()
01:00000:00446:2006/11/06 18:08:29.06 kernel  pc: 0x0000000000008000 ()
00:00000:00521:2006/11/06 18:08:29.06 kernel  pc: 0x0000000177a890f8 ()
01:00000:00446:2006/11/06 18:08:29.11 kernel  pc: 0x0000000100035408 .parse_name+0x2fc()
01:00000:00446:2006/11/06 18:08:29.11 kernel  pc: 0x0000000100035ebc .recvchars[1]+0x110()
00:00000:00521:2006/11/06 18:08:29.11 kernel  pc: 0x00000001000910ac .des__grab+0x28()
01:00000:00446:2006/11/06 18:08:29.11 kernel  pc: 0x000000010005f180 .get_range_sdes[2]+0x20()
01:00000:00446:2006/11/06 18:08:29.11 kernel  pc: 0x000000010005f1dc .get_range_sdes[2]+0x7c()
00:00000:00521:2006/11/06 18:08:29.12 kernel  pc: 0x00000001000800e0 .des_get[6]+0x1c()
00:00000:00521:2006/11/06 18:08:29.12 kernel  pc: 0x0000000100035408 .parse_name+0x2fc()
00:00000:00521:2006/11/06 18:08:29.12 kernel  pc: 0x0000000100035ebc .recvchars[1]+0x110()
00:00000:00521:2006/11/06 18:08:29.14 kernel  pc: 0x00000001000a6ed8 .getid+0x5c()
01:00000:00446:2006/11/06 18:08:29.14 kernel  pc: 0x0000000100051e10 .col_open_range+0x48()
01:00000:00446:2006/11/06 18:08:29.14 kernel  pc: 0x0000000100051ea4 .colnames_driver+0x3c()
01:00000:00446:2006/11/06 18:08:29.14 kernel  pc: 0x0000000100051fa0 .s_normquery+0x74()
01:00000:00446:2006/11/06 18:08:29.14 kernel  pc: 0x0000000100052eb8 .s_normalize[2]+0x6c()
00:00000:00521:2006/11/06 18:08:29.15 kernel  [Handler pc: 0x000000010017858c .droperr installed by the following function:-]
00:00000:00521:2006/11/06 18:08:29.15 kernel  pc: 0x00000001001162b4 .dropo[3]+0x3c()
00:00000:00521:2006/11/06 18:08:29.15 kernel  pc: 0x0000000100116188 .dropobject[1]+0x4c()
00:00000:00521:2006/11/06 18:08:29.16 kernel  pc: 0x000000010065b200 .s_execute[67]+0x3e7c()
01:00000:00446:2006/11/06 18:08:29.16 kernel  [Handler pc: 0x0000000100645230 .s_handle installed by the following function:-]
00:00000:00521:2006/11/06 18:08:29.16 kernel  [Handler pc: 0x0000000100645230 .s_handle installed by the following function:-]
00:00000:00521:2006/11/06 18:08:29.16 kernel  pc: 0x0000000100037260 .sequencer[1]+0x174()
01:00000:00446:2006/11/06 18:08:29.16 kernel  pc: 0x000000010006f934 .sequencer[2]+0x48()
01:00000:00446:2006/11/06 18:08:29.16 kernel  pc: 0x000000010007335c .tdsrecv_language[1]+0x58()
00:00000:00521:2006/11/06 18:08:29.16 kernel  pc: 0x000000010007335c .tdsrecv_language[1]+0x58()
01:00000:00446:2006/11/06 18:08:29.16 kernel  [Handler pc: 0x00000001002233dc .hdl_backout installed by the following function:-]
00:00000:00521:2006/11/06 18:08:29.16 kernel  [Handler pc: 0x00000001002233dc .hdl_backout installed by the following function:-]
00:00000:00521:2006/11/06 18:08:29.17 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
01:00000:00446:2006/11/06 18:08:29.17 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
00:00000:00521:2006/11/06 18:08:29.17 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
01:00000:00446:2006/11/06 18:08:29.17 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x00000001000732ec .result[4]+0x6c()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x00000001000732ec .result[4]+0x6c()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000100015970 +0x1c()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000100015970 +0x1c()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
00:00000:00521:2006/11/06 18:08:29.17 kernel  pc: 0x0000000000000000 ()
01:00000:00446:2006/11/06 18:08:29.17 kernel  end of stack trace, spid 446, kpid 148308028, suid 1
00:00000:00521:2006/11/06 18:08:29.17 kernel  end of stack trace, spid 521, kpid 143328355, suid 591
00:00000:00521:2006/11/06 18:08:29.17 kernel  ueshutdown: exiting
01:00000:00138:2006/11/06 18:09:19.36 kernel  timeslice -501, current process infected
01:00000:00138:2006/11/06 18:09:19.36 kernel  ************************************
01:00000:00138:2006/11/06 18:09:19.36 kernel  SQL causing error : select distinct getdate ( ) from sysobjects
01:00000:00138:2006/11/06 18:09:19.36 kernel  ************************************
01:00000:00138:2006/11/06 18:09:19.36 server  SQL Text: select distinct getdate ( ) from sysobjects
01:00000:00138:2006/11/06 18:09:19.36 kernel  curdb = 5 pstat = 0x10000 lasterror = 0
01:00000:00138:2006/11/06 18:09:19.36 kernel  preverror = 0 transtate = 0
01:00000:00138:2006/11/06 18:09:19.36 kernel  curcmd = 0 program = LSCW                          
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100222d90 .terminate_process[3]+0x7fc()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x000000010059a5fc .kaclkintr[10]+0x15c()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000008000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100035408 .parse_name+0x2fc()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100035ebc .recvchars[1]+0x110()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x000000010005f180 .get_range_sdes[2]+0x20()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x000000010005f1dc .get_range_sdes[2]+0x7c()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100051e10 .col_open_range+0x48()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100051ea4 .colnames_driver+0x3c()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100051fa0 .s_normquery+0x74()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100052eb8 .s_normalize[2]+0x6c()
01:00000:00138:2006/11/06 18:09:19.36 kernel  [Handler pc: 0x0000000100645230 .s_handle installed by the following function:-]
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x000000010006f934 .sequencer[2]+0x48()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x000000010007335c .tdsrecv_language[1]+0x58()
01:00000:00138:2006/11/06 18:09:19.36 kernel  [Handler pc: 0x00000001002233dc .hdl_backout installed by the following function:-]
01:00000:00138:2006/11/06 18:09:19.36 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
01:00000:00138:2006/11/06 18:09:19.36 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x00000001000732ec .result[4]+0x6c()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000100015970 +0x1c()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  pc: 0x0000000000000000 ()
01:00000:00138:2006/11/06 18:09:19.36 kernel  end of stack trace, spid 138, kpid 95224168, suid 397


这个是什么问题啊 ??

论坛徽章:
0
2 [报告]
发表于 2006-11-07 16:40 |只看该作者
数据库版本多少,每次都出错吗?一般可能要通过安装补丁包来解决

论坛徽章:
0
3 [报告]
发表于 2006-11-07 17:56 |只看该作者
数据库是12。5。0。3 补丁打到11335了  不是每次 昨天出现一次  今天我又试了下 没这个问题了

论坛徽章:
0
4 [报告]
发表于 2006-11-07 18:05 |只看该作者
现在关键是想知道为什么回宕机的 以后怕是还会出现这个情况
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP