免费注册 查看新帖 |

Chinaunix

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

我的sybase自己给挂了,请问有人知道解决办法吗? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2006-07-29 00:12 |只看该作者 |倒序浏览
28号早上发现sybase挂了,以前一直运行还算正常。我的系统是IBM650,AIX5.2,SYBASE是:Adaptive Server Enterprise/12.5.0.3/EBF 11335 ESD#3/P/RS6000/AIX 5.1/rel12503/19   33/64-bit/FBO/Fri Aug  1 02:23:21 2003
oslevel -r 显示:5200-01
服务器运行的是财务系统,连接的用户进程一般在600个左右,抱错时的日志如下,请问有人知道出错原因及解决办法吗?多谢了。


02:00000:00564:2006/07/28 00:14:20.00 kernel  Cannot read, host process disconnected: LIUWEI 3924 spid: 564
06:00000:00000:2006/07/28 00:14:35.89 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2006/07/28 00:15:39.62 kernel  nrpacket: recv, Connection timed out
06:00000:00000:2006/07/28 00:16:45.86 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2006/07/28 00:18:57.25 kernel  nrpacket: recv, Connection timed out
03:00000:00000:2006/07/28 00:21:21.74 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2006/07/28 00:26:23.69 kernel  nrpacket: recv, Connection timed out
01:00000:00000:2006/07/28 00:26:24.69 kernel  nrpacket: recv, Connection timed out
03:00000:00000:2006/07/28 00:26:40.34 kernel  nrpacket: recv, Connection timed out
06:00000:00000:2006/07/28 00:27:56.35 kernel  nrpacket: recv, Connection timed out
05:00000:00000:2006/07/28 00:28:24.23 kernel  nrpacket: recv, Connection timed out
01:00000:00000:2006/07/28 00:29:21.42 kernel  nrpacket: recv, Connection timed out
04:00000:00000:2006/07/28 00:31:11.78 kernel  nrpacket: recv, Connection timed out
05:00000:00000:2006/07/28 00:31:12.54 kernel  nrpacket: recv, Connection timed out
05:00000:00000:2006/07/28 00:31:37.63 kernel  nrpacket: recv, Connection timed out
05:00000:00000:2006/07/28 00:36:38.90 kernel  nrpacket: recv, Connection timed out
00:00000:01074:2006/07/28 00:41:52.73 kernel  Cannot send, host process disconnected: 计财科02 3404 spid: 1074
06:00000:01074:2006/07/28 00:41:53.84 server  Error: 1608, Severity: 18, State: 4
06:00000:01074:2006/07/28 00:41:54.54 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
01:00000:01736:2006/07/28 00:43:02.12 kernel  timeslice -501, current process infected
01:00000:01736:2006/07/28 00:43:02.24 kernel  Spinlocks held by  kpid 700580851

01:00000:01736:2006/07/28 00:43:02.24 kernel  Spinlock Resource->rdesmgr_spin at address 00000001601c6340 owned by 700580851
01:00000:01736:2006/07/28 00:43:09.26 kernel  End of spinlock display.
01:00000:01736:2006/07/28 00:43:10.93 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
01:00000:01736:2006/07/28 00:43:10.93 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
01:00000:01736:2006/07/28 00:43:10.93 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
01:00000:01736:2006/07/28 00:43:10.99 kernel  pc: 0x00000001002225c0 .terminate_process[3]+0x2c()
01:00000:01736:2006/07/28 00:43:11.05 kernel  pc: 0x000000010059a5fc .kaclkintr[10]+0x15c()
01:00000:01736:2006/07/28 00:43:11.05 kernel  pc: 0x00000001888b4d78 ()
01:00000:01736:2006/07/28 00:43:11.05 kernel  [Handler pc: 0x0000000100223390 .hdl_backout_msg installed by the following function:-]
01:00000:01736:2006/07/28 00:43:11.21 kernel  pc: 0x00000001000b2438 .checkpoint[1]+0x240()
01:00000:01736:2006/07/28 00:43:11.24 kernel  [Handler pc: 0x00000001006f784c .dpdb_handle installed by the following function:-]
01:00000:01736:2006/07/28 00:43:11.31 kernel  pc: 0x00000001000a308c .dmpx__truncatemain+0x828()
01:00000:01736:2006/07/28 00:43:11.46 kernel  [Handler pc: 0x000000010089a934  installed by the following function:-]
01:00000:01736:2006/07/28 00:43:11.49 kernel  pc: 0x00000001000f3778 .j_adjust_cachesize[15]+0x20()
01:00000:01736:2006/07/28 00:43:11.52 kernel  pc: 0x0000000100114358 .ckptproc[1]+0x18()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000100015970 +0x1c()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()
01:00000:01736:2006/07/28 00:43:11.56 kernel  pc: 0x0000000000000000 ()

论坛徽章:
0
2 [报告]
发表于 2006-07-29 00:12 |只看该作者
续帖抱错日志信息:
01:00000:01736:2006/07/28 00:43:11.56 kernel  end of stack trace, spid 1736, kpid 700580851, suid 0
01:00000:01736:2006/07/28 00:43:11.56 kernel  ueshutdown: exiting
03:00000:01122:2006/07/28 00:43:51.46 kernel  timeslice -501, current process infected
03:00000:01122:2006/07/28 00:43:51.46 kernel  ************************************
03:00000:01122:2006/07/28 00:43:51.48 kernel  SQL causing error : select COUNT ( 1 ) From LSKMZX Where F_CODE ='1130120001020112' And '4151120012990000000000000000' Like F_LIKE
03:00000:01122:2006/07/28 00:43:51.48 kernel  ************************************
03:00000:01122:2006/07/28 00:43:51.49 server  SQL Text: select COUNT ( 1 ) From LSKMZX Where F_CODE ='1130120001020112' And '4151120012990000000000000000' Like F_LIKE
03:00000:01122:2006/07/28 00:43:51.50 kernel  curdb = 22 pstat = 0x10000 lasterror = 0
03:00000:01122:2006/07/28 00:43:51.50 kernel  preverror = 0 transtate = 0
03:00000:01122:2006/07/28 00:43:51.50 kernel  curcmd = 0 program = LSCW                          
06:00000:00080:2006/07/28 00:43:51.52 kernel  timeslice -501, current process infected
06:00000:00080:2006/07/28 00:43:51.52 kernel  ************************************
06:00000:00080:2006/07/28 00:43:51.52 kernel  SQL causing error : sp_server_info 1
06:00000:00080:2006/07/28 00:43:51.52 kernel  ************************************
06:00000:00080:2006/07/28 00:43:51.52 server  SQL Text: sp_server_info 1
06:00000:00080:2006/07/28 00:43:51.52 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
06:00000:00080:2006/07/28 00:43:51.52 kernel  preverror = 0 transtate = 1
06:00000:00080:2006/07/28 00:43:51.52 kernel  curcmd = 224 program =                              
00:00000:01345:2006/07/28 00:43:51.56 kernel  timeslice -501, current process infected
00:00000:01345:2006/07/28 00:43:51.56 kernel  ************************************
00:00000:01345:2006/07/28 00:43:51.56 kernel  SQL causing error : select F_GNBH from LSUSGN where F_GNBH ='QQ1021' and F_ZGBH ='3058'
00:00000:01345:2006/07/28 00:43:51.56 kernel  ************************************
00:00000:01345:2006/07/28 00:43:51.57 server  SQL Text: select F_GNBH from LSUSGN where F_GNBH ='QQ1021' and F_ZGBH ='3058'
00:00000:01345:2006/07/28 00:43:51.57 kernel  curdb = 22 pstat = 0x10000 lasterror = 0
00:00000:01345:2006/07/28 00:43:51.57 kernel  preverror = 0 transtate = 0
00:00000:01345:2006/07/28 00:43:51.57 kernel  curcmd = 193 program = QQSJXQ                        
04:00000:01758:2006/07/28 00:43:52.25 kernel  timeslice -501, current process infected
06:00000:00080:2006/07/28 00:43:52.25 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
06:00000:00080:2006/07/28 00:43:52.25 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
06:00000:00080:2006/07/28 00:43:52.25 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
04:00000:01758:2006/07/28 00:43:52.25 kernel  ************************************
04:00000:01758:2006/07/28 00:43:52.25 kernel  SQL causing error : select count ( 1 ) from syscolumns_view where id =object_id ( 'LSPOPL' ) and name ='F_CODE'
04:00000:01758:2006/07/28 00:43:52.25 kernel  ************************************
04:00000:01758:2006/07/28 00:43:52.25 server  SQL Text: select count ( 1 ) from syscolumns_view where id =object_id ( 'LSPOPL' ) and name ='F_CODE'
04:00000:01758:2006/07/28 00:43:52.25 kernel  curdb = 22 pstat = 0x10000 lasterror = 0
04:00000:01758:2006/07/28 00:43:52.25 kernel  preverror = 0 transtate = 0
04:00000:01758:2006/07/28 00:43:52.25 kernel  curcmd = 0 program = LSCW                          
06:00000:00080:2006/07/28 00:43:52.34 kernel  pc: 0x0000000100222d90 .terminate_process[3]+0x7fc()
06:00000:00080:2006/07/28 00:43:52.43 kernel  pc: 0x000000010059a5fc .kaclkintr[10]+0x15c()
06:00000:00080:2006/07/28 00:43:52.43 kernel  pc: 0x0000000000008000 ()
06:00000:00080:2006/07/28 00:43:52.55 kernel  pc: 0x0000000100035408 .parse_name+0x2fc()
06:00000:00080:2006/07/28 00:43:52.55 kernel  pc: 0x0000000100035ebc .recvchars[1]+0x110()
06:00000:00080:2006/07/28 00:43:52.57 kernel  pc: 0x000000010003a20c .proc_get[1]+0x28()
06:00000:00080:2006/07/28 00:43:52.57 kernel  pc: 0x000000010003a678 .s_getTreeOrPlan+0x94()
06:00000:00080:2006/07/28 00:43:52.57 kernel  pc: 0x000000010003b608 .execproc+0x13c()
06:00000:00080:2006/07/28 00:43:52.61 kernel  pc: 0x000000010008ccfc .s_execute[38]+0xb0()
06:00000:00080:2006/07/28 00:43:52.70 kernel  [Handler pc: 0x0000000100645230 .s_handle installed by the following function:-]
06:00000:00080:2006/07/28 00:43:52.70 kernel  pc: 0x0000000100037260 .sequencer[1]+0x174()
06:00000:00080:2006/07/28 00:43:52.73 kernel  pc: 0x000000010007335c .tdsrecv_language[1]+0x58()
06:00000:00080:2006/07/28 00:43:52.73 kernel  [Handler pc: 0x00000001002233dc .hdl_backout installed by the following function:-]
04:00000:01758:2006/07/28 00:43:52.79 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
04:00000:01758:2006/07/28 00:43:52.79 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
04:00000:01758:2006/07/28 00:43:52.79 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
04:00000:01758:2006/07/28 00:43:52.84 kernel  pc: 0x0000000100222d90 .terminate_process[3]+0x7fc()
04:00000:01758:2006/07/28 00:43:52.90 kernel  pc: 0x000000010059a5fc .kaclkintr[10]+0x15c()
04:00000:01758:2006/07/28 00:43:52.90 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:52.96 kernel  pc: 0x0000000100080130 .des_get[6]+0x6c()
04:00000:01758:2006/07/28 00:43:52.98 kernel  pc: 0x0000000100035408 .parse_name+0x2fc()
04:00000:01758:2006/07/28 00:43:52.98 kernel  pc: 0x0000000100035ebc .recvchars[1]+0x110()
03:00000:01122:2006/07/28 00:43:53.21 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
03:00000:01122:2006/07/28 00:43:53.21 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
03:00000:01122:2006/07/28 00:43:53.21 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
00:00000:01345:2006/07/28 00:43:53.27 kernel  pc: 0x0000000100355e80 .pcstkwalk+0x88()
00:00000:01345:2006/07/28 00:43:53.27 kernel  pc: 0x0000000100356538 .ucstkgentrace+0x238()
00:00000:01345:2006/07/28 00:43:53.27 kernel  pc: 0x00000001003552c8 .ucbacktrace+0x78()
03:00000:01122:2006/07/28 00:43:53.46 kernel  pc: 0x0000000100222d90 .terminate_process[3]+0x7fc()
00:00000:01345:2006/07/28 00:43:53.46 kernel  pc: 0x0000000100222d90 .terminate_process[3]+0x7fc()
03:00000:01122:2006/07/28 00:43:53.46 kernel  pc: 0x000000010059a5fc .kaclkintr[10]+0x15c()
00:00000:01345:2006/07/28 00:43:53.46 kernel  pc: 0x000000010059a5fc .kaclkintr[10]+0x15c()
03:00000:01122:2006/07/28 00:43:53.46 kernel  pc: 0x0000000000008000 ()
00:00000:01345:2006/07/28 00:43:53.46 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.46 kernel  pc: 0x000000010000ce14 .closetable+0x134()
00:00000:01345:2006/07/28 00:43:53.46 kernel  pc: 0x000000010000ccb8 .close_range[1]+0x80()
00:00000:01345:2006/07/28 00:43:53.51 kernel  pc: 0x0000000100008e9c .s_estmt_loopend+0x11c()
00:00000:01345:2006/07/28 00:43:53.51 kernel  pc: 0x0000000100008594 .run[4]+0x20c()
03:00000:01122:2006/07/28 00:43:53.56 kernel  pc: 0x000000010005770c .pg_log_alloc[1]+0x64()
03:00000:01122:2006/07/28 00:43:53.56 kernel  pc: 0x000000010003e68c .lock_neighbors[1]+0xec()
03:00000:01122:2006/07/28 00:43:53.56 kernel  pc: 0x000000010005e23c .get_range_sdes[1]+0x24()
03:00000:01122:2006/07/28 00:43:53.59 kernel  pc: 0x000000010000d280 .s_opentables[1]+0x218()
03:00000:01122:2006/07/28 00:43:53.63 kernel  pc: 0x0000000100053148 .apl_getnext[11]+0x48()
04:00000:01758:2006/07/28 00:43:53.69 kernel  [Handler pc: 0x00000001007f5548 .vu_resviewerr installed by the following function:-]
04:00000:01758:2006/07/28 00:43:53.69 kernel  pc: 0x00000001007f0698 .vu_getviewdefn+0x28c()
04:00000:01758:2006/07/28 00:43:53.69 kernel  pc: 0x00000001007eea30 .vu_analyze_view+0x104()
04:00000:01758:2006/07/28 00:43:53.69 kernel  pc: 0x00000001007eb9f4 .vu_call_analyze_view+0xcc()
04:00000:01758:2006/07/28 00:43:53.69 kernel  pc: 0x00000001007edde0 .vu_view_driver+0x88()
04:00000:01758:2006/07/28 00:43:53.69 kernel  pc: 0x00000001007edce4 .vu_maincmdloop+0x5c()
04:00000:01758:2006/07/28 00:43:53.69 kernel  pc: 0x00000001007edc54 .vu_findviews[1]+0x20()
04:00000:01758:2006/07/28 00:43:53.69 kernel  [Handler pc: 0x00000001007f5548 .vu_resviewerr installed by the following function:-]
04:00000:01758:2006/07/28 00:43:53.69 kernel  [Handler pc: 0x00000001007f5548 .vu_resviewerr installed by the following function:-]
04:00000:01758:2006/07/28 00:43:53.69 kernel  pc: 0x000000010007394c .vu_res_view+0x120()
00:00000:01345:2006/07/28 00:43:53.71 kernel  [Handler pc: 0x0000000100645230 .s_handle installed by the following function:-]
04:00000:01758:2006/07/28 00:43:53.71 kernel  pc: 0x0000000100067954 .pre_aggview[1]+0x90()
03:00000:01122:2006/07/28 00:43:53.71 kernel  pc: 0x00000001000685f0 .s_preprocess[1]+0x90()
04:00000:01758:2006/07/28 00:43:53.71 kernel  pc: 0x00000001000685bc .s_preprocess[1]+0x5c()
03:00000:01122:2006/07/28 00:43:53.71 kernel  pc: 0x00000001000693d4 .zero_joindatas_on_one_side_of_union+0xfc()
04:00000:01758:2006/07/28 00:43:53.71 kernel  pc: 0x00000001000693d4 .zero_joindatas_on_one_side_of_union+0xfc()
00:00000:01345:2006/07/28 00:43:53.71 kernel  pc: 0x0000000100037260 .sequencer[1]+0x174()
00:00000:01345:2006/07/28 00:43:53.73 kernel  pc: 0x000000010007335c .tdsrecv_language[1]+0x58()
00:00000:01345:2006/07/28 00:43:53.73 kernel  [Handler pc: 0x00000001002233dc .hdl_backout installed by the following function:-]
04:00000:01758:2006/07/28 00:43:53.75 kernel  [Handler pc: 0x0000000100645230 .s_handle installed by the following function:-]
03:00000:01122:2006/07/28 00:43:53.75 kernel  [Handler pc: 0x0000000100645230 .s_handle installed by the following function:-]
04:00000:01758:2006/07/28 00:43:53.76 kernel  pc: 0x000000010006f99c .sequencer[2]+0xb0()
03:00000:01122:2006/07/28 00:43:53.77 kernel  pc: 0x000000010006f99c .sequencer[2]+0xb0()
04:00000:01758:2006/07/28 00:43:53.76 kernel  pc: 0x000000010007335c .tdsrecv_language[1]+0x58()
03:00000:01122:2006/07/28 00:43:53.77 kernel  pc: 0x000000010007335c .tdsrecv_language[1]+0x58()
04:00000:01758:2006/07/28 00:43:53.76 kernel  [Handler pc: 0x00000001002233dc .hdl_backout installed by the following function:-]
03:00000:01122:2006/07/28 00:43:53.77 kernel  [Handler pc: 0x00000001002233dc .hdl_backout installed by the following function:-]
06:00000:00080:2006/07/28 00:43:53.77 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
06:00000:00080:2006/07/28 00:43:53.77 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
06:00000:00080:2006/07/28 00:43:53.77 kernel  pc: 0x00000001000732ec .result[4]+0x6c()
00:00000:01345:2006/07/28 00:43:53.78 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
00:00000:01345:2006/07/28 00:43:53.78 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x00000001000732ec .result[4]+0x6c()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000100015970 +0x1c()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  pc: 0x0000000000000000 ()
00:00000:01345:2006/07/28 00:43:53.78 kernel  end of stack trace, spid 1345, kpid 1368590222, suid 3643
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000100015970 +0x1c()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  pc: 0x0000000000000000 ()
06:00000:00080:2006/07/28 00:43:53.80 kernel  end of stack trace, spid 80, kpid 1368850985, suid 3661
03:00000:01122:2006/07/28 00:43:53.82 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
03:00000:01122:2006/07/28 00:43:53.82 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
03:00000:01122:2006/07/28 00:43:53.82 kernel  pc: 0x00000001000732ec .result[4]+0x6c()
03:00000:01122:2006/07/28 00:43:53.82 kernel  pc: 0x0000000100015970 +0x1c()
03:00000:01122:2006/07/28 00:43:53.82 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
03:00000:01122:2006/07/28 00:43:53.82 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.82 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.82 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.83 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.83 kernel  [Handler pc: 0x0000000100453e78 .ut_handle installed by the following function:-]
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.83 kernel  pc: 0x00000001000732ec .result[4]+0x6c()
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.83 kernel  pc: 0x0000000000000000 ()
03:00000:01122:2006/07/28 00:43:53.83 kernel  end of stack trace, spid 1122, kpid 1351353976, suid 4443
04:00000:01758:2006/07/28 00:43:53.84 kernel  pc: 0x0000000100015970 +0x1c()
04:00000:01758:2006/07/28 00:43:53.84 kernel  pc: 0x000000010001594c .kpinitproc[1]+0x1c()
04:00000:01758:2006/07/28 00:43:53.84 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.84 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.84 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.84 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.84 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.84 kernel  pc: 0x0000000000000000 ()
04:00000:01758:2006/07/28 00:43:53.84 kernel  end of stack trace, spid 1758, kpid 1348404128, suid 4444

论坛徽章:
0
3 [报告]
发表于 2006-07-29 10:29 |只看该作者
重新启动了没有

论坛徽章:
0
4 [报告]
发表于 2006-07-29 11:44 |只看该作者
服务器我第二天重启了,暂时运行还正常,关键是不知道是什么原因引起SYBASE宕机的,害怕问题没彻底解决的话,不定什么时候再给我来一次,心里有点悬。

论坛徽章:
0
5 [报告]
发表于 2006-07-29 12:04 |只看该作者
你发日志文件发上来,我给你看看

论坛徽章:
0
6 [报告]
发表于 2006-07-29 13:37 |只看该作者
附件是日志文件,麻烦给看看,谢谢!

SYBASE.rar

144.27 KB, 下载次数: 59

sybase日志

论坛徽章:
0
7 [报告]
发表于 2006-07-29 19:45 |只看该作者

请确让

interface文件中是用的ip地址?
是否有大的内存池?

论坛徽章:
0
8 [报告]
发表于 2006-07-29 20:42 |只看该作者
原帖由 sybase_au 于 2006-7-29 19:45 发表
interface文件中是用的ip地址?
是否有大的内存池?


interface内容:

SYBASE
        master tcp ether 168.168.168.13 6788
        query tcp ether 168.168.168.13 6788

SYBASE_back
        master tcp ether 168.168.168.13 6789
        query tcp ether 168.168.168.13 6789

我不知道该如何看是否有大内存池。我的服务器是8个CPU,16G内存,主要运行syabse服务,基本上再没干别的。

[ 本帖最后由 zhouscy 于 2006-7-29 20:43 编辑 ]

论坛徽章:
0
9 [报告]
发表于 2006-07-30 11:38 |只看该作者
EBF 11335有点旧了,联系sybase升级到12.5.3看看

论坛徽章:
0
10 [报告]
发表于 2006-07-30 19:35 |只看该作者
exec sp_cacheconfig
go
This will tell you how your memory pool is configured on your server.

By the way,
can you run the following command and post it output
exec sp_configure "stack size"
go

If you large I/O pool, delete it and see how your system going.
If it still won't work, try double your stack size and see how it goes.

Keep in mind, only make one change at one time.

Good luck
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP