免费注册 查看新帖 |

Chinaunix

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

sybase数据库频繁报网络连接问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-05-06 10:23 |只看该作者 |倒序浏览
sybase12.5+solaris10频繁报如下问题:
一个月内,造成两次系统运行非常慢,必须重启服务才能解决。最近一次是造成共享锁阻塞,kill进程提示进程不是alive,没有办法,只好重启服务。大家帮忙发表发表看法?
报错信息如下:
00:00000:00155:2009/05/05 10:55:17.47 kernel  Cannot read, host process disconnected:  2608 spid: 155
00:00000:00280:2009/05/05 11:02:16.58 kernel  Cannot read, host process disconnected:  2472 spid: 280
00:00000:00162:2009/05/05 11:10:39.95 kernel  Cannot read, host process disconnected:  2328 spid: 162
00:00000:00116:2009/05/05 11:10:39.95 kernel  Cannot read, host process disconnected:  2328 spid: 116
00:00000:00171:2009/05/05 11:10:39.95 kernel  Cannot read, host process disconnected:  2328 spid: 171
00:00000:00167:2009/05/05 11:10:39.95 kernel  Cannot send, host process disconnected:  2328 suid: 955
00:00000:00167:2009/05/05 11:10:39.95 server  Error: 1608, Severity: 18, State: 4
00:00000:00167:2009/05/05 11:10:39.95 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00167:2009/05/05 11:10:39.95 kernel  extended error information: hostname:  login: escourt4
00:00000:00166:2009/05/05 11:10:55.92 kernel  Cannot read, host process disconnected:  1696 spid: 166
00:00000:00290:2009/05/05 11:11:41.92 kernel  Cannot read, host process disconnected:  2852 spid: 290
00:00000:00287:2009/05/05 11:11:56.97 kernel  Cannot read, host process disconnected:  1912 spid: 287
00:00000:00106:2009/05/05 11:13:54.13 kernel  Cannot read, host process disconnected:  2920 spid: 106
00:00000:00051:2009/05/05 11:15:55.58 kernel  Cannot read, host process disconnected:  3620 spid: 51
00:00000:00106:2009/05/05 11:24:14.44 kernel  Cannot read, host process disconnected:  1856 spid: 106
00:00000:00288:2009/05/05 11:24:46.24 kernel  Cannot read, host process disconnected:  3916 spid: 288
00:00000:00283:2009/05/05 11:24:46.24 kernel  Cannot read, host process disconnected:  3916 spid: 283
00:00000:00282:2009/05/05 11:24:46.24 kernel  Cannot read, host process disconnected:  3916 spid: 282
00:00000:00000:2009/05/05 11:32:35.80 kernel  nrpacket: recv, Connection timed out
00:00000:00111:2009/05/05 11:36:53.06 kernel  Cannot read, host process disconnected:  1456 spid: 111
00:00000:00299:2009/05/05 11:54:51.09 kernel  Cannot read, host process disconnected:  3316 spid: 299
00:00000:00116:2009/05/05 12:10:14.00 kernel  Cannot read, host process disconnected:   spid: 116
00:00000:00248:2009/05/05 12:31:34.55 kernel  Cannot read, host process disconnected:  624 spid: 248
00:00000:00312:2009/05/05 12:40:59.35 kernel  Cannot read, host process disconnected:  3156 spid: 312
00:00000:00275:2009/05/05 13:09:32.07 kernel  Cannot read, host process disconnected:  3852 spid: 275
00:00000:00253:2009/05/05 13:10:34.21 kernel  Cannot read, host process disconnected:  1856 spid: 253
00:00000:00242:2009/05/05 13:10:34.21 kernel  Cannot read, host process disconnected:  1856 spid: 242
00:00000:00309:2009/05/05 13:10:34.21 kernel  Cannot read, host process disconnected:  1856 spid: 309
00:00000:00162:2009/05/05 13:11:38.09 kernel  Cannot read, host process disconnected:  196 spid: 162
00:00000:00178:2009/05/05 13:15:50.02 kernel  Cannot read, host process disconnected:  3844 spid: 178
00:00000:00000:2009/05/05 13:19:04.58 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:19:21.58 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:20:29.38 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:21:48.94 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:33:49.05 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:41:01.75 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:41:11.63 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:44:10.59 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:44:44.96 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 13:51:25.06 kernel  nrpacket: recv, Connection timed out
00:00000:00082:2009/05/05 14:00:01.75 kernel  Cannot read, host process disconnected:  1692 spid: 82
00:00000:00178:2009/05/05 14:00:01.75 kernel  Cannot read, host process disconnected:  1692 spid: 178
00:00000:00052:2009/05/05 14:00:01.75 kernel  Cannot read, host process disconnected:  1692 spid: 52
00:00000:00000:2009/05/05 14:00:54.82 kernel  nrpacket: recv, Connection timed out
00:00000:00181:2009/05/05 14:01:12.25 kernel  Cannot read, host process disconnected:  3376 spid: 181
00:00000:00316:2009/05/05 14:01:12.25 kernel  Cannot read, host process disconnected:  3376 spid: 316
00:00000:00000:2009/05/05 14:05:46.52 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2009/05/05 14:11:40.74 kernel  nrpacket: recv, Connection timed out
00:00000:00028:2009/05/05 14:20:52.49 kernel  Cannot read, host process disconnected:  2892 spid: 28
00:00000:00022:2009/05/05 14:21:54.79 kernel  Cannot read, host process disconnected: WinNT 4456 spid: 22
00:00000:00000:2009/05/05 14:22:57.23 kernel  nrpacket: recv, Connection timed out
00:00000:00181:2009/05/05 14:27:38.23 kernel  Cannot read, host process disconnected:  2116 spid: 181
00:00000:00307:2009/05/05 14:28:02.15 kernel  Cannot read, host process disconnected:  1704 spid: 307

论坛徽章:
34
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
2 [报告]
发表于 2009-05-06 10:38 |只看该作者
Error: 1608, Severity: 18, State: 4

能具体说一下你的网络硬件环境及连接么?

论坛徽章:
34
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
3 [报告]
发表于 2009-05-07 15:27 |只看该作者
最早也碰到过,结果是HUB有问题,更换HUB问题解决,所以你最好排除你所有网络设备故障,再看看!

论坛徽章:
0
4 [报告]
发表于 2009-05-09 16:02 |只看该作者

回复 #1 romorial 的帖子

你ping一下数据库服务器,看是否丢包~?
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP