sybase异常挂起，忘高手给予指点，谢谢！！！

bmwtony

错误好像是从6月5日凌晨5点29分开始的，一直报重复的timeslice -501, current process infected错误，不知是什么原因。

以下是日志的内容,高手帮着看看是什么原因造成的。

00:00000:00101:2008/06/04 16:44:25.76 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00026:2008/06/04 16:44:25.76 server  Error: 1608, Severity: 18, State: 4
00:00000:00026:2008/06/04 16:44:25.76 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00088:2008/06/04 16:44:25.76 server  Error: 1608, Severity: 18, State: 4
00:00000:00088:2008/06/04 16:44:25.76 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00013:2008/06/04 16:44:39.23 server  Error: 1608, Severity: 18, State: 4
00:00000:00013:2008/06/04 16:44:39.23 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00073:2008/06/04 16:44:39.23 server  Error: 1608, Severity: 18, State: 4
00:00000:00073:2008/06/04 16:44:39.23 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00088:2008/06/04 16:59:29.46 kernel  Cannot read, host process disconnected:  56182 spid: 88
00:00000:00008:2008/06/05 05:29:22.81 kernel  timeslice -501, current process infected
00:00000:00008:2008/06/05 05:29:25.05 kernel  ************************************
00:00000:00008:2008/06/05 05:29:25.11 kernel  SQL causing error : ROLLBACK TRANSACTION
00:00000:00008:2008/06/05 05:29:25.11 kernel  ************************************
00:00000:00008:2008/06/05 05:29:25.11 server  SQL Text: ROLLBACK TRANSACTION
00:00000:00008:2008/06/05 05:29:25.15 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00008:2008/06/05 05:29:25.15 kernel  preverror = 0 transtate = 1
00:00000:00008:2008/06/05 05:29:25.15 kernel  curcmd = 0 program =                              
00:00000:00008:2008/06/05 05:29:25.31 kernel  pc: 0x0000000100338238 .pcstkwalk+0x80()
00:00000:00008:2008/06/05 05:29:25.31 kernel  pc: 0x000000010033895c .ucstkgentrace+0x1ac()
00:00000:00008:2008/06/05 05:29:25.31 kernel  pc: 0x00000001003373a8 .ucbacktrace+0x70()
00:00000:00008:2008/06/05 05:29:25.32 kernel  pc: 0x00000001001f23dc .terminate_process[6]+0x800()
00:00000:00008:2008/06/05 05:29:25.34 kernel  pc: 0x00000001003e9a4c .kaclkintr+0x2a0()
00:00000:00008:2008/06/05 05:29:25.34 kernel  pc: 0xfffffffffffd0000 ()
00:00000:00008:2008/06/05 05:29:25.34 kernel  pc: 0x000000010033ba60 .flushtoeom[1]+0x24()
00:00000:00008:2008/06/05 05:29:25.34 kernel  [Handler pc: 0x00000001001c7934 .hdl_backout installed by the following function:-]
00:00000:00008:2008/06/05 05:29:25.35 kernel  [Handler pc: 0x00000001003b669c .ut_handle installed by the following function:-]
00:00000:00008:2008/06/05 05:29:25.35 kernel  [Handler pc: 0x00000001003b669c .ut_handle installed by the following function:-]
00:00000:00008:2008/06/05 05:29:25.35 kernel  pc: 0x000000010033979c .conn_hdlr[17]+0x308()
00:00000:00008:2008/06/05 05:29:25.36 kernel  pc: 0x0000000100014a64 +0x1c()
00:00000:00008:2008/06/05 05:29:25.37 kernel  end of stack trace, spid 8, kpid 821887143, suid 0
00:00000:00008:2008/06/05 05:29:29.48 server  The SQL Server is terminating this process.
00:00000:00008:2008/06/05 05:29:29.79 server  Error: 1608, Severity: 18, State: 4
00:00000:00008:2008/06/05 05:29:29.79 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00097:2008/06/05 05:29:30.22 server  Unable to read in login record.
00:00000:00061:2008/06/05 05:29:30.23 server  Unable to read in login record.
00:00000:00102:2008/06/05 05:30:20.51 kernel  timeslice -501, current process infected
00:00000:00102:2008/06/05 05:30:20.52 kernel  ************************************
00:00000:00102:2008/06/05 05:30:20.52 kernel  SQL causing error : ROLLBACK TRANSACTION
00:00000:00102:2008/06/05 05:30:20.54 kernel  ************************************
00:00000:00102:2008/06/05 05:30:20.54 server  SQL Text: ROLLBACK TRANSACTION
00:00000:00102:2008/06/05 05:30:20.54 kernel  curdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00102:2008/06/05 05:30:20.54 kernel  preverror = 0 transtate = 1
00:00000:00102:2008/06/05 05:30:20.54 kernel  curcmd = 0 program =                              
00:00000:00102:2008/06/05 05:30:20.54 kernel  pc: 0x0000000100338238 .pcstkwalk+0x80()
00:00000:00102:2008/06/05 05:30:20.54 kernel  pc: 0x000000010033895c .ucstkgentrace+0x1ac()
00:00000:00102:2008/06/05 05:30:20.54 kernel  pc: 0x00000001003373a8 .ucbacktrace+0x70()
00:00000:00102:2008/06/05 05:30:20.54 kernel  pc: 0x00000001001f23dc .terminate_process[6]+0x800()
00:00000:00102:2008/06/05 05:30:20.54 kernel  pc: 0x00000001003e9a4c .kaclkintr+0x2a0()
00:00000:00102:2008/06/05 05:30:20.54 kernel  pc: 0x0000000000000000 ()
00:00000:00102:2008/06/05 05:30:20.55 kernel  pc: 0x00000001002e833c .usrfill[4]+0x48()
00:00000:00102:2008/06/05 05:30:20.55 kernel  [Handler pc: 0x00000001001c7934 .hdl_backout installed by the following function:-]
00:00000:00102:2008/06/05 05:30:20.55 kernel  [Handler pc: 0x00000001003b669c .ut_handle installed by the following function:-]
00:00000:00102:2008/06/05 05:30:20.55 kernel  [Handler pc: 0x00000001003b669c .ut_handle installed by the following function:-]
00:00000:00102:2008/06/05 05:30:20.57 kernel  pc: 0x00000001000ff1dc .conn_hdlr[6]+0xd4()
00:00000:00102:2008/06/05 05:30:20.57 kernel  pc: 0x0000000100014a64 +0x1c()
00:00000:00102:2008/06/05 05:30:20.57 kernel  end of stack trace, spid 102, kpid 822083639, suid 0
00:00000:00102:2008/06/05 05:30:20.57 server  The SQL Server is terminating this process.
00:00000:00102:2008/06/05 05:31:10.81 kernel  timeslice -501, current process infected
00:00000:00102:2008/06/05 05:31:10.81 kernel  ************************************
00:00000:00102:2008/06/05 05:31:10.81 kernel  pc: 0x0000000100338238 .pcstkwalk+0x80()
00:00000:00102:2008/06/05 05:31:10.81 kernel  pc: 0x000000010033895c .ucstkgentrace+0x1ac()
00:00000:00102:2008/06/05 05:31:10.81 kernel  pc: 0x00000001003373a8 .ucbacktrace+0x70()
00:00000:00102:2008/06/05 05:31:10.81 kernel  pc: 0x00000001001f1cc8 .terminate_process[6]+0xec()
00:00000:00102:2008/06/05 05:31:10.81 kernel  pc: 0x00000001003e9a4c .kaclkintr+0x2a0()
00:00000:00102:2008/06/05 05:31:10.81 kernel  pc: 0x0000000000000000 ()
00:00000:00102:2008/06/05 05:31:10.82 kernel  pc: 0x0000000100034a6c .ussflush+0xa4()
00:00000:00102:2008/06/05 05:31:10.82 kernel  pc: 0x0000000100034898 .usseom+0x38()
00:00000:00102:2008/06/05 05:31:10.82 kernel  pc: 0x000000010004d494 .conn_hdlr_reg_cleanup+0xa0()
00:00000:00102:2008/06/05 05:31:10.82 kernel  [Handler pc: 0x00000001001c7934 .hdl_backout installed by the following function:-]
00:00000:00102:2008/06/05 05:31:10.82 kernel  [Handler pc: 0x00000001003b669c .ut_handle installed by the following function:-]
00:00000:00102:2008/06/05 05:31:10.82 kernel  [Handler pc: 0x00000001003b669c .ut_handle installed by the following function:-]
00:00000:00102:2008/06/05 05:31:10.83 kernel  pc: 0x000000010003e95c .conn_hdlr[1]+0x20c()
00:00000:00102:2008/06/05 05:31:10.83 kernel  pc: 0x0000000100014a64 +0x1c()
00:00000:00102:2008/06/05 05:31:10.83 kernel  end of stack trace, spid 102, kpid 822083639, suid 0

WFCJZ

00:00000:00102:2008/06/05 05:30:20.52 kernel  SQL causing error : ROLLBACK TRANSACTION

1>dbcc rebuild_log(dbname,0,0)

2>go

1>dbcc rebuild_log(dbname,1,1)
2>go

1>shutdown  

2>g
重新启动数据库服务器
isql连接
1>update sysdatabases set status=12 where name="dbname"

2>go
1>sp_configure "allow updates",0  
2>
1>shutdown
2>go
重启数据库后，恢复正常，rebuild log工作完成。

按说1608这种错误影响不大的.如果不行,你试加个-T3607试试.
从上面的日志来看,应该是你的硬盘有问题!

[ 本帖最后由 WFCJZ 于 2008-6-5 15:13 编辑 ]