Re: Internal connection fatal error

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 07/31/04 

Date: Sat, 31 Jul 2004 09:50:19 -0700

Turn on Perfmon and watch the connection pool. Is it constantly growing over
time or does it flatten out after a few minutes under load? Is the network
stable? Are you connecting over a LAN, WAN or web? If you lose a connection
due to IO problems on the wire, you can get this type of exception. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Max Metral" <memetral@hotmail.com> wrote in message
news:OPsOqrmdEHA.3212@TK2MSFTNGP12.phx.gbl...
> I've seen other posts about such errors, but never a solution.  It seems
to
> appear randomly under load.  We are pretty vigilant about "using"
> IDataReader's and Connections, so it's pretty unlikely that we're doing
> something outwardly wrong that would excuse this sort of behavior.  The
> stack is:
>
> TARGETSITE: System.Data.SqlClient.SqlDataReader
> ExecuteReader(System.Data.CommandBehavior,
> System.Data.SqlClient.RunBehavior, Boolean)
>
> STACKTRACE: at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior,
> RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at Web.MyPage.Page_Load(Object sender, EventArgs e)
> <removed by me>
>
> Perhaps related, we also see random errors like this about columns we KNOW
> exist in recordsets that are being returned:
>
> MESSAGE: EventId
> SOURCE: System.Data
> TARGETSITE: Int32 GetOrdinal(System.String)
> STACKTRACE: at System.Data.Common.FieldNameLookup.GetOrdinal(String
> fieldName)
> at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
> at MyObject..ctor(IDataReader eventReader, EventData eventData)
> <removed by me>
>
> This is definitely unacceptable behavior from ADO, SQL Server, or both...
No
> code that an end user writes in a managed language should be able to
create
> this kind of untraceable havoc.
>
> Any thoughts?
>
>

Relevant Pages

  • Re: .Net Scalability problem
    ... LoadRunner will peak out a server with a few virtual users. ... To get an idea of load, ... Fire off the test client and watch the number of ... > So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Resistance of ammeter caused voltage drop
    ... >> On power supplies supplied with external sense compensation there are ... >> load at the same point the supply lead is connected to the load, ... the sense terminals ... >with cable and connection drops, ...
    (sci.electronics.design)
  • Re: Resistance of ammeter caused voltage drop
    ... >> On power supplies supplied with external sense compensation there are ... >> load at the same point the supply lead is connected to the load, ... the sense terminals ... >with cable and connection drops, ...
    (sci.electronics.basics)
  • Re: What causes Vista PC to freeze?
    ... a multimeter and found approriate values according to the motherboard ... Without a load, ... house with NIC installed and no ethernet connection? ... Ethernet cables have galvanic isolation at both ends. ...
    (microsoft.public.windows.vista.general)
  • Checking Connection Speed - Re: Plusnet plans for April +
    ... >> Info (that WinXP generates), but show it in their own Graphical ... Connection, ... AdapterWatch v1.01 - Display information about your network adapters ... Download that - it shows a whole load ...
    (uk.people.silversurfers)
Loading