I have an application that has been working just fine for a couple of years.
It queries a SQL database and returns some formatted data back to the client.
I have a new client, who has a larger database than any of our previous
customers. For example, the query to build the datatable now takes about 2
minutes instead of one minute or less. This is a third party database we are
integrating with. He is getting very strange results. For example, when
running the web page, after a couple of minutes it may come back and ask him
to login to the web page again, this may happen several times in a row.
After this, he may get the results, or he may get an out of memory error, or
some other error indicating that the the page should never have even started
executing (my own error). The server the customer is running on has 2 .5 gig
of memory and w3wp only uses about 90meg before these errors happen.
So I got the customer database and am attempting to address the issues.
However, I also get very strange results. I can point my app at a small
database (only takes a few seconds). However, when I point it at their large
one (3.5 to 4 minuets to run), the web page eventually comes back with an
Action Canceled message after about 10+ minutes. In attempting to debug
this, it appears that the web page takes about 3.5 to 4 minutes to run.
However, after executing and getting the result set back from SQL (not very
large only about 1800 rows or a few hundred bytes each), the page appears to
reload two more times. I noticed this first in SQL Profiler because I could
see the same SQL statements getting executed over again. If I break in the
debugger at the Page_Load function, it does actually get executed 3 times.
After the third time I get the Action Cancelled error. In running the
shorter pages, the page_load function executes only once.
Can someone point in the right direction? I have increased the timeouts
(both SQL and ASP.NET) to 15 minutes. I am pretty sure this is not a problem
as prior customers have run into these timeout issues and my code changes
worked for them.
I am assuming there is some memory issue going on, but I have no idea how to
debug it or track it down.
Gary 6 1699
I did some additional testing and just disabled all the code in the page and
just had the page_load function go to sleep. It appears that after about
140-150 seconds the page will reload once it finishes, instead of just
finished and terminating. If I have the page sleep for less than 140 seconds
it will always finish properly.
Hi Gary,
Welcome to ASPNET newsgroup.
From your description, one of your asp.net web application which runs well
for couple of years come into strange behavior recently after including a
large database into the backend db, yes?
Based on the information you mentioned:
=============== ======
He is getting very strange results. For example, when
running the web page, after a couple of minutes it may come back and ask
him
to login to the web page again, this may happen several times in a row.
After this, he may get the results, or he may get an out of memory error,
or
some other error indicating that the the page should never have even
started
executing (my own error).
=============== ======
I'm a bit confused at the "login to the web page again" you mentioned,
what's the "login" means here? Do it means the Integried windows
authentiation's login dialog or your custom Forms Authentication' s login
page? Anway, I'm curently also thinking the problem is caused by the
long-time consuming task when interacting with the large db.(As you also
have simulated a long-time task through Thread.Sleep and get other strange
behaviors).
Would you also try using the ASP.NET's Trace to output some statement to
ensure that when doing such a long-run task, the page_load will excute
multi-times?
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
I have verified the page loads multiple by actually running the page in the
debugger. I have the debugger setup to stop at the Page_Load function.
After the first time it hits the breakpoint, I run it and if the page takes
over 140s, it hits the breakpoint again (in the page_load function).
"Steven Cheng[MSFT]" wrote: Hi Gary,
Welcome to ASPNET newsgroup. From your description, one of your asp.net web application which runs well for couple of years come into strange behavior recently after including a large database into the backend db, yes?
Based on the information you mentioned:
=============== ====== He is getting very strange results. For example, when running the web page, after a couple of minutes it may come back and ask him to login to the web page again, this may happen several times in a row. After this, he may get the results, or he may get an out of memory error, or some other error indicating that the the page should never have even started executing (my own error). =============== ======
I'm a bit confused at the "login to the web page again" you mentioned, what's the "login" means here? Do it means the Integried windows authentiation's login dialog or your custom Forms Authentication' s login page? Anway, I'm curently also thinking the problem is caused by the long-time consuming task when interacting with the large db.(As you also have simulated a long-time task through Thread.Sleep and get other strange behaviors).
Would you also try using the ASP.NET's Trace to output some statement to ensure that when doing such a long-run task, the page_load will excute multi-times?
Thanks,
Steven Cheng Microsoft Online Support
Get Secure! www.microsoft.com/security (This posting is provided "AS IS", with no warranties, and confers no rights.)
In doing some further work I have discovered something a bit different. When
I run this page independent of any other page, it works fine for an unlimited
period of time. However, this page gets called from another page. How it
gets called is the user clicks on a button in another frame of the page, then
the asp.net creates a form and adds a line of javascript to submit the form
wiht the target being the bottom frame. Is this the correct way to do this.
I want the original form with a bunch of options to show up in the top frame,
but then the bottom frame to have the output from the report. I guess I am
not doing this corretly. Is there a better way to switch the frame that is
being executed?
I discovered that for some reason, the client was resending the post to the
server. by adding a Response.Flush to the beginning of the Page_Load
function, the client no longer sends the request again.
Thanks for your further followup Gary,
Then, when you adding all the code you removed earilier back , does the
problem also went away? If so, I think that was the cause you found. If
anything else we can help, please feel free to post here. Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: richard.bair |
last post by:
Hi! I'm trying to setup up a web page that will eventually be hosted
but I want to develop it locally. It will use PHP to hit a MySQL
database. So I have a local database created. I installed PHP and
Apache. Next I thought I would do some basic PHP tests as I don't know
anything about PHP or Apache. So here is where my snag is.
1) I can execute at the command line:
who@where:/var/www/htdocs$ php -r 'echo "hiya\n";'
hiya
|
by: Funduk |
last post by:
Hello,
So I've been playing with Python and Pygame for a while and I decided
I wanted to make a real executable so I could send that stuff over to
my friends to show off my <sarcasm>maad skillz</sarcasm>.
Everything was going great I went and got all the newest software
(including Distutils and PY2EXE) and read the docs on making a setup
py.
|
by: Rod |
last post by:
Hi,
It happens something strange with IE 6 (not with N7, Mozilla...).
I want a div with a background picture.
Within it, I want a picture with a text floating.
With IE, the text is not always displayed, sometimes you need to....click
with the mouse on the text to see it!!!
Or sometime it appears, but if you go to open another window (from another
appication for example) and come back to the IE window, it has disappeared!!
|
by: Julia Baresch |
last post by:
Hi everyone,
My database has 3 data tables with chained one-to-many relationships
i.e.
Table1 1-->Many ->Table2 1-->Many ->Table3
I added a fourth table to hold supplemental data that also relates to
Table2. It also has a one-to-many relationship with Table2, so now
Table2 has two child tables
|
by: Bruno van Dooren |
last post by:
Hi all,
i have a problem that i never experienced with VC6 or VC .NET 2002.
i try to debug a dll by using a 3party app to load and use the dll, and then
placing breakpoints in the code so that i can do step by step execution.
this has always worked fine for me, but when i step into a function,
suddenly breakpoints are positioned on empty lines that nonetheless seem to
be executed when i press F10. if i try to position them again on the...
| |
by: karthikbalaguru |
last post by:
Hi,
I wonder how the 'm' value is 10 in the program below . It should be
7.
Further, it turns later to 11. Strange. :( How is it possible ? Why ?
Need clarification. Any ideas ?
using namespace std;
#include <iostream>
double &biggest (double &r, double &s)
|
by: tiddwaylll |
last post by:
I once had a matrix working like this
matrix
So, since its indexed with 0, I used them as matrix or matrix.
Then the other day, I forgot the 0 index, and used matrix.
And it worked perfectly fine! And worse so, the program didn't work anymore when I revert that back to matrix. Also matrix now had ridiculous values inside.
|
by: CD Tom |
last post by:
I'm lost, I have a form with fields called time1 time2 that are set to standard format Auto decimal with nothing out of the ordinary but here's what's happening I can only enter 1 digit into the field and then it jumps to the next. I have an after update set to check the time1 entered and of course after I enter the first digit it jumps to the after update code. I've restarted Access but still the same thing happens, I have a different database...
|
by: dlite922 |
last post by:
1. Code completion and Syntax checker: Don't know if this exists for perl. I'm a PHP developer and NuSphere PHPED does this quite nicely, no more mistyping of standard PHP functions OR my own class functions. I'm looking for an editor of perl that knows which libraries I included and guess which function I want to call when i start to type it. It should also underline invalid syntax in red like Microsoft Word underlines misspelled words in red. ...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |