Event log error from Select Service

[muhsmann]

This morning the connection to server is taking a very long time. I looked in the Application Log of the Event viewer of the Select Service box and see a few of these errors:

Error occured on service boundary.
Error: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:01:00'.
Stack Trace:
at System.ServiceModel.Channels.SocketConnection.Write(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout)
at System.ServiceModel.Channels.BufferedConnection.WriteNow(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout, BufferManager bufferManager)
at System.ServiceModel.Channels.BufferedConnection.Write(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout)
at System.ServiceModel.Channels.ServerSessionPreambleConnectionReader.ServerFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open()
at System.ServiceModel.Dispatcher.ChannelHandler.OpenAndEnsurePump()
XML Log:
<ILExceptionData>
<Point module="System.ServiceModel.dll" classFull="System.ServiceModel.Channels.SocketConnection" methodName="Write" methodSignature="Void Write(Byte[], Int32, Int32, Boolean, System.TimeSpan)" methodToken="0x6000f9b" ILOffset="97" />
<Point module="System.ServiceModel.dll" classFull="System.ServiceModel.Channels.BufferedConnection" methodName="WriteNow" methodSignature="Void WriteNow(Byte[], Int32, Int32, System.TimeSpan, System.ServiceModel.Channels.BufferManager)" methodToken="0x6000745" ILOffset="133" />
<Point module="System.ServiceModel.dll" classFull="System.ServiceModel.Channels.BufferedConnection" methodName="Write" methodSignature="Void Write(Byte[], Int32, Int32, Boolean, System.TimeSpan)" methodToken="0x6000743" ILOffset="71" />
<Point module="System.ServiceModel.dll" classFull="System.ServiceModel.Channels.ServerSessionPreambleConnectionReader+ServerFramingDuplexSessionChannel" methodName="OnOpen" methodSignature="Void OnOpen(System.TimeSpan)" methodToken="0x60009ce" ILOffset="302" />
<Point module="System.ServiceModel.dll" classFull="System.ServiceModel.Channels.CommunicationObject" methodName="Open" methodSignature="Void Open(System.TimeSpan)" methodToken="0x60000e5" ILOffset="167" />
<Point module="System.ServiceModel.dll" classFull="System.ServiceModel.Channels.CommunicationObject" methodName="Open" methodSignature="Void Open()" methodToken="0x60000e4" ILOffset="0" />
<Point module="System.ServiceModel.dll" classFull="System.ServiceModel.Dispatcher.ChannelHandler" methodName="OpenAndEnsurePump" methodSignature="Void OpenAndEnsurePump()" methodToken="0x6005499" ILOffset="2" />
</ILExceptionData>
***********************************************************************************
Error: An existing connection was forcibly closed by the remote host
Stack Trace:
at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.ServiceModel.Channels.SocketConnection.Write(Byte[] buffer, Int32 offset, Int32 size, Boolean immediate, TimeSpan timeout)
XML Log:
<ILExceptionData>
<Point module="System.dll" classFull="System.Net.Sockets.Socket" methodName="Send" methodSignature="Int32 Send(Byte[], Int32, Int32, System.Net.Sockets.SocketFlags)" methodToken="0x6002c1c" ILOffset="23" />
<Point module="System.ServiceModel.dll" classFull="System.ServiceModel.Channels.SocketConnection" methodName="Write" methodSignature="Void Write(Byte[], Int32, Int32, Boolean, System.TimeSpan)" methodToken="0x6000f9b" ILOffset="43" />
</ILExceptionData>

Unable to retrieve OperationContext.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any idea whats going on here?

[Randy Mellow]

Assuming those event entries coincide with the slowness you noticed, it appears as if the select service is being kicked off of its communication port for some reason, a few possibilities are listed in the error message. Problems such as this are typically related to network/environment issues.

Did this just start happening? Was anything changed with respect to your app or the Select service that coincides with this problem occurring. Is the problem intermittent or are these errors filling up your event viewer? Are Select clients experiencing this problem as well?

[muhsmann]

Randy,
Yes this strated happening and nothing had changed wrt Select service. The Select clients were filling the affects as well.
What I did find was the SQL server had un-bounded memory constraints. There were other indicatations that the box was suffering from lack of memory resources. The issue seems to have 'gone' away and I'm not certain why. I did cap the memory allocation on the SQL side but have not re-cycled the service yet. But for now I think we're satisfied this was an issue on our side in our environment and not related to Select.