What application does that PID belong to which opens the 25K connections?
Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sandeep Pandey Sent: Wednesday, January 29, 2014 3:53 AM To: arslist@ARSLIST.ORG Subject: Re: Open connection increasing ** Dear Joe, Thanks for your reply. There are more than 25k active connections showing and 90 % are in established state connection which are internal between local address (application) to foreign address (application) with duplicate PID. We don't have AIE and ITSM. WE just have custom application deployed over ARS 7.6.04 sp4. Kindly suggest why too much internal established connections showing. And its increasing and finally at some extent its not allowing other user to connect because exceeding connections. Even its not allowing to restart the ars services and finally we rebooted the server itself. -- Sandeep Pandey Remedy Developer On Tue, Jan 28, 2014 at 10:27 PM, Joe D'Souza <jdso...@shyle.net> wrote: ** You have not specified open connections from what to what. I am assuming you mean the connection between the AR Server to the database. Yes there used to be a bug a few versions ago (very early versions of 7.0 and some of 6.x and some earlier ones too I think) with what used to be known as the EIE then (now AIE) where after a scheduled run of a data exchange to MS-SQL, the EIE engine would not close that connections and the next time the same schedule was to run, it would open another connection. BMC did fix that bug. Is this something similar? If so the work around until they fixed whatever it was that I had used was to stop the service from the command line using a windows scheduler (sort of a cron job), after the schedule was estimated to have finished it daily run. This killed the connection it opened. And then using another schedule, I started that service minutes before it was to run another schedule. You are on 76.04 SP4, and I do not think that EIE's successor AIE has a similar problem. So you would need to be more specific as to when you get these connections open, and when they fail to close if it is the connection to the database you are inferring. Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sandeep Pandey Sent: Tuesday, January 28, 2014 1:30 AM To: arslist@ARSLIST.ORG Subject: Open connection increasing ** Dear List, There are huge number of open connections (netstat -a) in server and due to this arserver stops working. Following error getting in arerror log file. Most of the connections from application side only. Tue Jan 14 10:34:25 2014 390620 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Tue Jan 14 10:34:25 2014 RDC1-ERM-AP1 (5004) AREA : RPC: Miscellaneous tli error - System error (Connection refused). Environment: ARS 7.6.04 SP4 Windows 2k8 Do we need to do any specific configuration for this? Or this is existing bug/defect? Thanks in advance. -- Sandeep Pandey Remedy Developer _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"