[
https://issues.apache.org/jira/browse/DERBY-6985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16569239#comment-16569239
]
sagar commented on DERBY-6985:
------------------------------
For the file descriptors, in linux you can change this or even set it to
unlimited using ulimit command. Dont know if this can be done per process or
globally for the entire os.
For windows i believe there is a limit on the number of open file descriptors
and also number of threads per process.
And any os you also need to consider apart for m the Java heap, the os also
requires ram for stack n heap per proceess per thread and hence sane limits
must be set.
> Document how to configure the keepAlive timeout on network sockets
> ------------------------------------------------------------------
>
> Key: DERBY-6985
> URL: https://issues.apache.org/jira/browse/DERBY-6985
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.14.1.0
> Reporter: Satyabrata Mohanty
> Priority: Major
> Attachments: Derby_Open_Connection.png
>
>
> Hi,
> Below is the complete description of the issue,
> * Running a java application which creates a good number of connections with
> derby on the machine X.
> * We are running the derby database server on the machine lets say Y.
> * We explicitly block the listening of 1527 port of system X traffics on
> system Y in the network until it thrown connection exception and then again
> established the network between the two systems.
> * After the java application has finished execution we found there are still
> some connections remained open in derby.
> * We can see open connections in derby although we have terminated the java
> application.
> * We have restarted derby to free up these connection.
> * Concern here is, how these connection are generated, is these connections
> are broken /stale connection made during the network reset, if YES then, how
> to these connection will be auto deleted or handled in derby ?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
