标题: 大家对1605错误有什么解释? [打印本页] 作者: songwk80 时间: 2005-09-08 15:28 标题: 大家对1605错误有什么解释? failed to open virtual socket for new connections
Refer to the writeup for this erro
++++++++++
什么意思???作者: hehuomumu 时间: 2005-09-08 15:30 标题: 大家对1605错误有什么解释? 看sybase的最大用户连接数是否是不够用了。作者: songwk80 时间: 2005-09-08 15:31 标题: 大家对1605错误有什么解释? 00:00000:00002:2005/08/31 09:10:43.98 server Error: 1605, Severity: 18, State: 1
00:00000:00002:2005/08/31 09:10:43.98 server Failed to open virtual socket for new connections
00:00000:00002:2005/08/31 09:10:48.39 kernel nopen: accept, Too many open files in system
00:00000:00002:2005/08/31 09:10:48.39 server Error: 1605, Severity: 18, State: 1
00:00000:00002:2005/08/31 09:10:48.39 server Failed to open virtual socket for new connections
00:00000:00002:2005/08/31 09:10:55.82 kernel nopen: accept, Too many open files in system
00:00000:00002:2005/08/31 09:10:55.82 server Error: 1605, Severity: 18, State: 1
00:00000:00002:2005/08/31 09:10:55.82 server Failed to open virtual socket for new connections
00:00000:00002:2005/08/31 09:12:53.44 kernel nopen: accept, Too many open files in system
00:00000:00002:2005/08/31 09:12:53.44 server Error: 1605, Severity: 18, State: 1
00:00000:00002:2005/08/31 09:12:53.44 server Failed to open virtual socket for new connections
00:00000:00002:2005/08/31 09:13:33.26 kernel nopen: accept, Too many open files in system
00:00000:00002:2005/08/31 09:13:33.26 server Error: 1605, Severity: 18, State: 1
检查日志中类似行:
00:00000:00000:2005/05/16 21:39:27.64 server Number of blocks left for proc headers: 3232.
(这是WINDOWS平台上的)作者: zq5143 时间: 2010-02-09 08:56
但是问题是现在已经连不上了,老是报超时.怎么办?直接杀进程?作者: zq5143 时间: 2010-02-09 11:13
在系统外如何扩?我现在连不上数据库,报连接超时。作者: andkylee 时间: 2010-02-10 10:50
>>>Too many open files in system
我感觉这个时候不能扩用户连接数,反而应该减少用户连接数。
请看下面的计算公式:
(number of user connections) + (number of devices * max online engines) + (number of remote sites) + (max number network listeners) + (max cis remote connections) + (number of java sockets) <= (number of file descriptors)
Too many open files in system应该是没有可用文件描述符的意思。作者: zwjwelch 时间: 2010-02-21 08:58 作者: andkylee 时间: 2010-02-23 11:10 回复 12#zwjwelch
灌水贴~作者: hefan 时间: 2010-03-18 16:52
sp_configure 'number of open objects',2000
go