sybase异常挂起，忘高手给予指点，谢谢！！！
错误好像是从6月5日凌晨5点29分开始的，一直报重复的timeslice -501, current process infected错误，不知是什么原因。以下是日志的内容,高手帮着看看是什么原因造成的。
00:00000:00101:2008/06/04 16:44:25.76 serverA 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 serverError: 1608, Severity: 18, State: 4
00:00000:00026:2008/06/04 16:44:25.76 serverA 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 serverError: 1608, Severity: 18, State: 4
00:00000:00088:2008/06/04 16:44:25.76 serverA 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 serverError: 1608, Severity: 18, State: 4
00:00000:00013:2008/06/04 16:44:39.23 serverA 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 serverError: 1608, Severity: 18, State: 4
00:00000:00073:2008/06/04 16:44:39.23 serverA 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 kernelCannot read, host process disconnected:56182 spid: 88
00:00000:00008:2008/06/05 05:29:22.81 kerneltimeslice -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 kernelSQL 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 serverSQL Text: ROLLBACK TRANSACTION
00:00000:00008:2008/06/05 05:29:25.15 kernelcurdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00008:2008/06/05 05:29:25.15 kernelpreverror = 0 transtate = 1
00:00000:00008:2008/06/05 05:29:25.15 kernelcurcmd = 0 program =
00:00000:00008:2008/06/05 05:29:25.31 kernelpc: 0x0000000100338238 .pcstkwalk+0x80()
00:00000:00008:2008/06/05 05:29:25.31 kernelpc: 0x000000010033895c .ucstkgentrace+0x1ac()
00:00000:00008:2008/06/05 05:29:25.31 kernelpc: 0x00000001003373a8 .ucbacktrace+0x70()
00:00000:00008:2008/06/05 05:29:25.32 kernelpc: 0x00000001001f23dc .terminate_process+0x800()
00:00000:00008:2008/06/05 05:29:25.34 kernelpc: 0x00000001003e9a4c .kaclkintr+0x2a0()
00:00000:00008:2008/06/05 05:29:25.34 kernelpc: 0xfffffffffffd0000 ()
00:00000:00008:2008/06/05 05:29:25.34 kernelpc: 0x000000010033ba60 .flushtoeom+0x24()
00:00000:00008:2008/06/05 05:29:25.34 kernel
00:00000:00008:2008/06/05 05:29:25.35 kernel
00:00000:00008:2008/06/05 05:29:25.35 kernel
00:00000:00008:2008/06/05 05:29:25.35 kernelpc: 0x000000010033979c .conn_hdlr+0x308()
00:00000:00008:2008/06/05 05:29:25.36 kernelpc: 0x0000000100014a64 +0x1c()
00:00000:00008:2008/06/05 05:29:25.37 kernelend of stack trace, spid 8, kpid 821887143, suid 0
00:00000:00008:2008/06/05 05:29:29.48 serverThe SQL Server is terminating this process.
00:00000:00008:2008/06/05 05:29:29.79 serverError: 1608, Severity: 18, State: 4
00:00000:00008:2008/06/05 05:29:29.79 serverA 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 serverUnable to read in login record.
00:00000:00061:2008/06/05 05:29:30.23 serverUnable to read in login record.
00:00000:00102:2008/06/05 05:30:20.51 kerneltimeslice -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 kernelSQL 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 serverSQL Text: ROLLBACK TRANSACTION
00:00000:00102:2008/06/05 05:30:20.54 kernelcurdb = 1 pstat = 0x10000 lasterror = 0
00:00000:00102:2008/06/05 05:30:20.54 kernelpreverror = 0 transtate = 1
00:00000:00102:2008/06/05 05:30:20.54 kernelcurcmd = 0 program =
00:00000:00102:2008/06/05 05:30:20.54 kernelpc: 0x0000000100338238 .pcstkwalk+0x80()
00:00000:00102:2008/06/05 05:30:20.54 kernelpc: 0x000000010033895c .ucstkgentrace+0x1ac()
00:00000:00102:2008/06/05 05:30:20.54 kernelpc: 0x00000001003373a8 .ucbacktrace+0x70()
00:00000:00102:2008/06/05 05:30:20.54 kernelpc: 0x00000001001f23dc .terminate_process+0x800()
00:00000:00102:2008/06/05 05:30:20.54 kernelpc: 0x00000001003e9a4c .kaclkintr+0x2a0()
00:00000:00102:2008/06/05 05:30:20.54 kernelpc: 0x0000000000000000 ()
00:00000:00102:2008/06/05 05:30:20.55 kernelpc: 0x00000001002e833c .usrfill+0x48()
00:00000:00102:2008/06/05 05:30:20.55 kernel
00:00000:00102:2008/06/05 05:30:20.55 kernel
00:00000:00102:2008/06/05 05:30:20.55 kernel
00:00000:00102:2008/06/05 05:30:20.57 kernelpc: 0x00000001000ff1dc .conn_hdlr+0xd4()
00:00000:00102:2008/06/05 05:30:20.57 kernelpc: 0x0000000100014a64 +0x1c()
00:00000:00102:2008/06/05 05:30:20.57 kernelend of stack trace, spid 102, kpid 822083639, suid 0
00:00000:00102:2008/06/05 05:30:20.57 serverThe SQL Server is terminating this process.
00:00000:00102:2008/06/05 05:31:10.81 kerneltimeslice -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 kernelpc: 0x0000000100338238 .pcstkwalk+0x80()
00:00000:00102:2008/06/05 05:31:10.81 kernelpc: 0x000000010033895c .ucstkgentrace+0x1ac()
00:00000:00102:2008/06/05 05:31:10.81 kernelpc: 0x00000001003373a8 .ucbacktrace+0x70()
00:00000:00102:2008/06/05 05:31:10.81 kernelpc: 0x00000001001f1cc8 .terminate_process+0xec()
00:00000:00102:2008/06/05 05:31:10.81 kernelpc: 0x00000001003e9a4c .kaclkintr+0x2a0()
00:00000:00102:2008/06/05 05:31:10.81 kernelpc: 0x0000000000000000 ()
00:00000:00102:2008/06/05 05:31:10.82 kernelpc: 0x0000000100034a6c .ussflush+0xa4()
00:00000:00102:2008/06/05 05:31:10.82 kernelpc: 0x0000000100034898 .usseom+0x38()
00:00000:00102:2008/06/05 05:31:10.82 kernelpc: 0x000000010004d494 .conn_hdlr_reg_cleanup+0xa0()
00:00000:00102:2008/06/05 05:31:10.82 kernel
00:00000:00102:2008/06/05 05:31:10.82 kernel
00:00000:00102:2008/06/05 05:31:10.82 kernel
00:00000:00102:2008/06/05 05:31:10.83 kernelpc: 0x000000010003e95c .conn_hdlr+0x20c()
00:00000:00102:2008/06/05 05:31:10.83 kernelpc: 0x0000000100014a64 +0x1c()
00:00000:00102:2008/06/05 05:31:10.83 kernelend of stack trace, spid 102, kpid 822083639, suid 0 00:00000:00102:2008/06/05 05:30:20.52 kernelSQL 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 编辑 ]
页:
[1]