贴一下参数
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
@@max_connections
的值!
参考文档:http://infocenter.sybase.com/hel ... ml/sag1/sag1274.htm作者: xumouxin1 时间: 2010-02-04 17:15
00:00000:01739:2010/02/04 16:42:59.57 kernel Cannot send, host process disconnected: TELEPOW 2830 suid: 3
00:00000:00010:2010/02/04 16:42:59.57 kernel soc_nopen: No free file descriptors available.
00:00000:01519:2010/02/04 16:42:59.57 kernel Cannot send, host process disconnected: TELEPOW 2262 suid: 3
00:00000:00010:2010/02/04 16:42:59.57 kernel soc_nopen: No free file descriptors available.
00:00000:00103:2010/02/04 16:42:59.57 kernel Cannot send, host process disconnected: TELEPOW 2258 suid: 3
00:00000:00010:2010/02/04 16:42:59.57 kernel soc_nopen: No free file descriptors available.
00:00000:01105:2010/02/04 16:42:59.57 kernel Cannot send, host process disconnected: TELEPOW 2249 suid: 3
00:00000:00010:2010/02/04 16:42:59.57 kernel soc_nopen: No free file descriptors available.
00:00000:01859:2010/02/04 16:42:59.58 kernel Cannot send, host process disconnected: TELEPOW 2636 suid: 3
00:00000:00010:2010/02/04 16:42:59.58 kernel soc_nopen: No free file descriptors available.
00:00000:02331:2010/02/04 17:16:23.81 kernel Cannot read, host process disconnected: spid: 2331
00:00000:00010:2010/02/04 17:16:23.81 kernel soc_nopen: No free file descriptors available.作者: xumouxin1 时间: 2010-02-04 17:15
谢谢啊!日志不多,都是在重复上面的错误作者: xumouxin1 时间: 2010-02-04 17:30
现在数据库无法登录,还没重启,下面的参数是从配置文件中查的,但是@@max_connections不知道该查哪个参数值
number of user connections = 2700
number of devices = 20
max online engines = 3
number of remote sites = DEFAULT
max number network listeners = DEFAULT
max cis remote connections = DEFAULT
number of java sockets = DEFAULT作者: andkylee 时间: 2010-02-04 17:39
在isql下用 select @@max_connections 来查询。
number of user connections = 2700 估计是超过最大文件描述符file descriptor 了。
公式 (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) 不能大于 @@max_connections