大家对1605错误有什么解释？

songwk80

failed to open virtual socket for new connections
Refer to the writeup for this erro

++++++++++
什么意思？？？

hehuomumu

看sybase的最大用户连接数是否是不够用了。

songwk80

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


=============================
Adaptive Server Enterprise/11.9.2.4/1175/P/SWR 9521 ESD 3/Linux Intel/Linux 2.2.5-15 i586/

flybean

估计是达到OS的限制了，无法创建句柄。2.2。5的具体限制请查一下。

songwk80

isql 登陆提示密码错误，
但是用sql advantage就没有问题。
=-====================
因为数据库被攻击过，所以出现了奇怪的问题。

flybean

sp_configure "number of user connections"

检查日志中类似行：
00:00000:00000:2005/05/16 21:39:27.64 server  Number of blocks left for proc headers: 3232.
（这是WINDOWS平台上的）

zq5143

但是问题是现在已经连不上了,老是报超时.怎么办?直接杀进程?

zq5143

sp_configure "number of user connections"

检查日志中类似行：
00:00000:00000:2005/05/16 21:39:27. ...
flybean 发表于 2005-09-14 18:51

   现在是连不上数据库了，是否需要直接杀进程？

li_lsl

首先可以扩用户数，试试

zq5143

首先可以扩用户数，试试
li_lsl 发表于 2010-02-09 12:19

    在系统外如何扩？我现在连不上数据库，报连接超时。