RE: [Rainbowportal-devel] Maybe these logfiles help against instability
Brought to you by:
danijel_kecman,
manudea
From: William F. <WF...@im...> - 2004-12-29 08:39:27
|
There are a ton of them. Look for anything ending in db.cs... Usersdb.cs, etc...=20 -----Original Message----- From: rai...@li... [mailto:rai...@li...] On Behalf Of Charles Carroll Sent: Wednesday, December 29, 2004 12:20 AM To: rai...@li... Subject: Re: [Rainbowportal-devel] Maybe these logfiles help against instability why would open datareaders be passed up any layers? But EVEN IF THEY ARE using Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); everywhere we can. This enumeration effectively guarantees that when we we close a READER the connection gets closed. What files are we looking at?=20 Give me some filenames and code to look at. On Wed, 29 Dec 2004 00:04:09 -0800, William Forney <WF...@im...> wrote: > This is something I'm working on as well. In fact, I branched the=20 > code to refactor the data access because of this. The problem is=20 > connections are leaking due to open datareaders being passed as return > values to business/UI layer functions and then read & never properly cleaned up. > The connections behind the datareaders just hang there in lots of=20 > places until either the GC cleans them up. >=20 > -----Original Message----- > From: rai...@li... > [mailto:rai...@li...] On Behalf Of=20 > Christoph Schramm > Sent: Tuesday, December 28, 2004 9:01 AM > To: rai...@li... > Subject: [Rainbowportal-devel] Maybe these logfiles help against=20 > instability >=20 > Okay, we're trying to find this huuuuugeeee error which raises=20 > Portal/Website does not exist and brings our most import portal=20 > running on > RC4 down... > I ran 3 stress tests on the same Tab/Page (only ONE page) and after=20 > each of them I copied the specifig rb_log We noticed that the errors=20 > always affect SQL (we sometimes have 100 open > (sleeping) connections) and there are some errors in SQLUrlProvider. > Tell me where the problem could be and I will search for it and debug=20 > it! > It seems to me that connections are not closed properly... > MS Act returns me a max Rps of 30 and after 1000 successful=20 > connections we have 120 http errors where none should be, and 3-5 socket errors... ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now.=20 http://productguide.itmanagersjournal.com/ _______________________________________________ Rainbowportal-devel mailing list Rai...@li... https://lists.sourceforge.net/lists/listinfo/rainbowportal-devel |