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

[Paul White]

Hi Michel

I have run up a test environment which can make 1024 simultaneous inbound and outbound connections. (2048 net connections in total)

What is the error in errlog.log?  I have this:
E_GC2214_MAX_IB_CONNS  GCC server has exceeded max inbound connections.

Version  II 10.2.0 (a64.lnx/100)

config.dat
ii.mine.dbms.*.active_limit:       1024
ii.mine.dbms.*.connect_limit:      1024
ii.mine.dbms.connect_max:          1024
ii.mine.gcc.*.inbound_limit:       1024
ii.mine.gcc.*.outbound_limit:      1024

ulimit -n = 1024
I think that is for my current shell

/etc/security/limits.conf
Does not have any overrides.

syscheck -v
Checking host "mine" for system resources required to run Ingres...

64-bit kernel running.

1038 file descriptors per-process required.
4096 is the current system hard limit.
4096 is the current system soft limit.

306626560 byte shared memory segment required by LG/LK sub-systems.
8404992 byte shared memory segment required by DBMS server(s).
0 byte shared memory segment required by shared DBMS cache(s).
9223372036854775807 bytes is the maximum shared memory segment size.

3 shared memory segments required.
4096 is the total number of shared memory segments allocated by the system.
4096 shared memory segments are currently available.

35 semaphores required.
32000 is the total number of semaphores allocated by the system.
31995 semaphores are currently available.

2 semaphore sets required.
128 is the total number of semaphore sets allocated by the system.
127 semaphore sets are currently available.

Your system has sufficient resources to run Ingres.


Paul

&
Shift Seven Solutions
www.shift7solutions.com.au



-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org [mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Karl and Betty Schendel
Sent: Thursday, 30 November 2017 12:07 PM
To: Ingres and related product discussion forum
Subject: Re: [Info-ingres] Ingres 9.0.4 connections "maxing" at 540, despite higher connect_limit and inbound_limit.


> On Nov 29, 2017, at 5:26 PM, <mvf at cyberren.com> <mvf at cyberren.com> wrote:
> 
> Hi,
>  
> Im having a bit of a strange issue.
>  
> Im 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

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres