Chinaunix

标题: sybase 自动宕机问题 [打印本页]

作者: wxr111 时间: 2006-11-07 14:44
标题: sybase 自动宕机问题
系统是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

这个是什么问题啊？？

作者: ggpl 时间: 2006-11-07 16:40
数据库版本多少，每次都出错吗？一般可能要通过安装补丁包来解决

作者: wxr111 时间: 2006-11-07 17:56
数据库是12。5。0。3 补丁打到11335了不是每次昨天出现一次今天我又试了下没这个问题了

作者: wxr111 时间: 2006-11-07 18:05
现在关键是想知道为什么回宕机的以后怕是还会出现这个情况

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)