论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2008-07-22 10:43 |只看该作者 |倒序浏览

server log里面每个5分钟就会报1608的错，内容类似下面

kernel  Cannot send, host process disconnected: spid: 135
server  Error: 1608, Severity: 18, State: 3
server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
kernel  Cannot send, host process disconnected: spid: 70
server  Error: 1608, Severity: 18, State: 3
server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

我用sp_who查看spid，都是连接一个库的，这个库是不用了的库，不知道被谁删掉一个设备文件，重启时报错如下

kernel  Initializing virtual device 6, '/aaa/bbb.data' with dsync 'on'.
kernel  dopen: open '/aaa/bbb.data', No such file or directory

server  Device 'bbb_dev2' (with physical name '/aaa/bbb.data', and virtual device number 6) has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.
server  Error: 3414, Severity: 17, State: 3
server  Database 'ccc' (dbid 5): Recovery failed. Check the SQL Server errorlog for further information as to the cause.
0

我在测试机上面模拟同样的情况，即建立同样的一个库，删掉一个设备文件，虽然重启也报类似的错误，但是不会有规律的报1608的错误，并且发起应用连接这个库也不会报1608的错误。

现在郁闷的要命，不知道是从哪触发的这个错误，是数据库本身触发的还是其他应用触发的的呢，1608sybase资料上面虽说不是个重要的错误，但是如此有规律的报肯定不正常，不知道各位大侠有无见过类似的错误，望不吝赐教，谢谢。