1. Forum
  2. USENET
  3. comp.databases.ingres

  • Re: [Info-ingres] File descriptor soft limit for the NET Server

    From Steve@s.anderson.au@gmail.com to comp.databases.ingres on Mon Nov 9 20:04:22 2020
    From Newsgroup: comp.databases.ingres

    It seems the default soft and hard limits on 64-bit Solaris 10 are 256 and 65536 respectively.

    The soft limit can be set by any user and thus can be different across users. The soft limit change is lost upon logging out, if not added to the user's profile, for example.

    To check file limits:
    ulimit -Sn
    ulimit -Hn

    To change the soft limit:
    ulimit -Sn 2000

    Ingres indicated it needed 614 file descriptors per-process, so I set the soft limit to 2000.

    Steve
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Karl Schendel@schendel@kbcomputer.com to Steve on Sat Aug 29 20:25:56 2020
    From Newsgroup: comp.databases.ingres


    On Aug 28, 2020, at 5:30 AM, Steve <s.anderson.au@gmail.com> wrote:

    Ingres reported the following warning on startup:

    WARNING!!! The recommended file descriptor soft limit for the NET Server to service 64 inbound, and 64 outbound connections is 261. The current file descriptor soft limit is set to 256.
    ...
    ulimit -a
    nofiles(descriptors) 256

    ulimit -aH
    nofiles(descriptors) 65536

    Don't know why there is such a big difference between the soft and hard limits?
    This is generally set by some sort of system configuration file; what
    OS are you running? Any change was likely caused either by an OS upgrade
    or some sort of system admin action; Ingres has little or no say in it.
    Karl
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Steve@s.anderson.au@gmail.com to comp.databases.ingres on Mon Aug 31 19:04:10 2020
    From Newsgroup: comp.databases.ingres

    On Sunday, August 30, 2020 at 10:26:04 AM UTC+10, Karl Schendel wrote:
    On Aug 28, 2020, at 5:30 AM, Steve <s.ande...@gmail.com> wrote:

    Ingres reported the following warning on startup:

    WARNING!!! The recommended file descriptor soft limit for the NET Server to service 64 inbound, and 64 outbound connections is 261. The current file descriptor soft limit is set to 256.
    ...
    ulimit -a
    nofiles(descriptors) 256

    ulimit -aH
    nofiles(descriptors) 65536

    Don't know why there is such a big difference between the soft and hard limits?
    This is generally set by some sort of system configuration file; what
    OS are you running? Any change was likely caused either by an OS upgrade
    or some sort of system admin action; Ingres has little or no say in it.

    Karl

    Running Solaris 10.

    I presume increasing the soft limit does not affect Ingres, in terms of its configuration, memory allocation, etc.

    Will highlight the soft limit with the administrator, God willing.

    Thanks
    Steve
    --- Synchronet 3.21d-Linux NewsLink 1.2