I have four worker process answering the Web site. On one specific option a user did on the Web site, this has triggered a very long SQL command on SQL Server resulting in that process ID to take pretty much 100% of the memory available to it.
Until we stopped that process, we ended up with several errors like this:
"Exception of type 'System.OutOfMemoryException' was thrown."
When looking at the trace, it was normal to see that the trace was pretty much different for each of them as, when there is no more memory available to process a transaction, an error can happen everywhere.
However, what I do not understand, is one of them has this scenario. The Stack Trace ends up with at System.Text.StringBuilder.ToString() as the last item in it. This is from this method:
Public Function StrTran(ByVal tcSearchIn As String, ByVal tcSearchFor As String, _
ByVal tcReplace As String) As String
Dim loStringBuilder As StringBuilder = New StringBuilder(tcSearchIn)
Return loStringBuilder.Replace(tcSearchFor, tcReplace).ToString()
End Function
So, basically, because of a memory issue, the StringBuilder was not able to execute. However, as surprisingly as it gets, the insert into SQL Server to log this error worked.
So, can anyone explain me why a simple command like that could trigger a 'System.OutOfMemoryException' when, at the same time, after it failed at that location, I was able to execute an insert into SQL Server?