gong1231 发表于 2008-06-25 23:48

求助,sybase出错,请高手帮助分析一下,谢谢!

这几天数据库服务器运行缓慢,日志里有许多错误日志,小弟恳请各位高手帮忙分析一下,谢了先!
0:00000:00011:2008/06/25 10:12:16.59 kernelCannot send, host process disconnected:3156 spid: 11
00:00000:00011:2008/06/25 10:12:16.60 serverError: 1608, Severity: 18, State: 4
00:00000:00011:2008/06/25 10:12:16.60 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00031:2008/06/25 11:01:34.57 serverProcess id 27 killed by Hostname , Host process id 208.
00:00000:00039:2008/06/25 14:37:51.40 kernelCannot send, host process disconnected: 0 3156 spid: 39
00:00000:00039:2008/06/25 14:37:51.40 serverError: 1608, Severity: 18, State: 4
00:00000:00039:2008/06/25 14:37:51.40 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00055:2008/06/25 15:50:35.65 kernelCannot send, host process disconnected:2256 spid: 55
00:00000:00050:2008/06/25 16:11:16.93 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:16.93 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:16.93 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:17.67 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:17.67 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:17.67 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:11:18.34 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:18.34 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:18.34 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:18.87 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:18.87 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:18.87 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:11:19.25 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:19.25 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:19.25 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:20.04 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:20.04 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:20.04 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:11:20.45 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:20.45 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:20.45 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:20.82 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:20.82 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:20.82 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:11:21.25 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:21.25 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:21.25 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:21.68 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:21.68 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:21.68 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:11:22.31 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:22.31 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:22.31 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:22.85 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:22.85 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:22.85 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:11:23.26 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:23.26 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:23.26 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:23.64 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:23.64 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:23.64 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:11:24.15 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:24.15 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:24.15 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:24.81 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:24.81 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:24.81 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:11:25.34 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:11:25.34 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:11:25.34 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:11:26.15 kernelCannot send, host process disconnected:1732 spid: 53
00:00000:00053:2008/06/25 16:11:26.15 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:11:26.15 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00050:2008/06/25 16:15:11.85 kernelCannot send, host process disconnected:2328 spid: 50
00:00000:00050:2008/06/25 16:15:11.85 serverError: 1608, Severity: 18, State: 4
00:00000:00050:2008/06/25 16:15:11.85 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00053:2008/06/25 16:20:29.07 kernelCannot send, host process disconnected:2328 spid: 53
00:00000:00053:2008/06/25 16:20:29.07 serverError: 1608, Severity: 18, State: 4
00:00000:00053:2008/06/25 16:20:29.07 serverA client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

shawnlee 发表于 2008-06-26 10:13

zhaopingzi 发表于 2008-06-26 12:44

 报这个错是因为你的客户端非正常退出sybase服务,比如客户端直接kill掉连接.
但是客户断为什么要非正常退出呢,可能的原因就是sybase服务端无法正常响应了,客户端无法忍受而非正常退出,或者客户查询了一半不查询了,把查询结束了.等等.所以可能要查的问题是:

1.网络是否有问题
2.服务器是否存在负荷过高的问题
3.客户端连接数的设置等等参数配置是否合理

仅供参考

[ 本帖最后由 zhaopingzi 于 2008-6-26 19:31 编辑 ]
页: [1]
查看完整版本: 求助,sybase出错,请高手帮助分析一下,谢谢!