[Info-ingres] Ingres 9.0.4 connections "maxing" at 540, despite higher connect_limit and inbound_limit.

[Karl and Betty Schendel]

> On Nov 29, 2017, at 5:26 PM, <mvf at cyberren.com> <mvf at cyberren.com> wrote:
> 
> Hi,
>  
> I’m having a bit of a strange issue.
>  
> I’m using Ingres 9.0.4 (community edition) and after 540 connections showing in “ipm”, suddenly nobody else can connect.
>  
> The thing is, it should really be allowing up to 832 in my opinion.  In the DBMS Configuration, I have the connect_limit set to 832.  In the Net Server configuration, I have the inbound_limit set to 832.

What's your system per-process file descriptor limit?  try ulimit -n to see if it's 1024, which
is likely.  Try raising the limit (in /etc/security/limits.conf if you're on linux).  You can
try ulimit -n 4096 and then start ingres, as a test.

Karl