SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Eliminate timeout when posting reply to a post


Eliminate timeout when posting reply to a post

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: Administrators
Points: 143088 Visits: 19424
It happens sometimes, but I try to watch the site throughout the day and see if there are issues. We do have performance problems at times, but they are very intermittent. The vast majority of the day, both the web and db servers trundle along at < 10%.

One thing to be careful of is hitting Enter. These forums (we bought the code) can be slightly flaky with Enter v a click on the button.

Also, I too, CTRL-A, CTRL-C if I have a response fo any size to post

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
JacekO
JacekO
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1537 Visits: 616

I don't think this is performance related. Looks like some kind of timeout on a page or cookie or stuff like this.

It is frustrating because sometimes I just don't realize how long did it take me to write the post or get distracted... and I wish there was a way to figure out how to get rid of this problem on your side instead of going thru the copy and paste in case I went over the time limit.

Do you get a log entry if someone gets 'blanked out' when replying to a post?
Maybe the problem happens more often then the posts would suggest.



---------------------------------------------
Nothing is impossible.
It is just a matter of time and money.

Carl Uman
Carl Uman
SSC-Addicted
SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)

Group: General Forum Members
Points: 439 Visits: 109

Was just looking to post about this problem but did a search first. It's been a year and this is still happening Seems to me that this would be a quick killer of a good forum. Why is it still happening? Personally if I loose a post (it has happened) I will not bother retyping it unless I remembered to copy and paste the text before submiting it. This is happening to me on a regular basis.





Lowell
Lowell
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69726 Visits: 40917

i have been bitten by this bug 6 times this week; some of my posts couldn't have taken me over 3 minutes to type, others were huge detailed answers....I'm a damn decent web developer, if you need someone to trace the code and find the timeout issue, I'd volunteer; change the code to look for a cookie or something so that this doesn't happen.

Like Carl said, because of that, i didn't try to retype my answers....too much trouble.



Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Steve Jones
Steve Jones
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: Administrators
Points: 143088 Visits: 19424
Lowell, our apologies.

It's can't be a simple timeout, but must be some intermittent error. I haven't seen it for months, but it happened this week to me and I was on the form < 5 minutes.

I sent a note to the dev guys to see if they can find time to trace it.

Steve

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Lowell
Lowell
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69726 Visits: 40917

No problem Steve; just wanted you to know; i bet it has something to do with the high traffic your site gets; i love this site and spend a lot of time on it every day.

Thanks!



Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Carl Uman
Carl Uman
SSC-Addicted
SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)

Group: General Forum Members
Points: 439 Visits: 109
Thanks Steve. Still happens to me. I finally just got in the habbit of doing a copy of my text before I post



Steve Jones
Steve Jones
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: Administrators
Points: 143088 Visits: 19424
OK, just got me with the explanation and I forgot the copy/paste.

Doh!

OK, the word from my hot new UK developers with lots of .NET and ASP experience is that it's my fault. They think they've reproduced it a few times in a VM and are fairly confident this is it.

When we went to these ASP.NET forums, we ran into some issues with memory leaks. Actually we didn't know until we had already moved for awhile, but periodically we'd get a "server unavailable" message where all ASP.NET stuff was gone, but the ASP still worked.

So in my very finite web knowledge, I did what any good IIS administrator would do: I set a recycle for the application pool. I set up twice a day, worked great, and life was good.

Well over the years as we've gotten complaints, I had increased that to 6 times a day and as of the server move a few weeks ago it went to every hour. The very talented Stephen D and Steve S at Red Gate (I'm Steve#3), discovered this recycle will lose the session. Which makes the application flip and it doesn't take the post.
So, if you're catching the recycle, whether you've been on the post page for 2 hours or 2 minutes, you lose the text.

They're looking at some Javascript to save to a cookie or something else, but we'd love any suggestions you have.

Saving my text now

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Lowell
Lowell
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69726 Visits: 40917

i think this can be fixed simply by adding some code to either the button that submits the data, or the Sub Page_Load event; the page will have all the values that were submitted, so it would be something like this: i suspect that the submission page either explictly sets the current values to be blank on_load, or simply allows them to be initialized, and they have no value..... by not init-ing them on IsPostBack, the data would remain in place...similar to when you submit username/password, and the password is bad, and you leave the username in place, awaiting a change to the password...

Behind the scenes, an error like invalid viewstate is probably being raised because the session timed out (or the application was restarted...same effect);

simply find the block of code that handles the submit button and in the Try..Catch...don't allow the objects to be initialized, or maybe assign the fields back their value... it's either the submit button or page load events that are wiping the data.

in Page_Load :

If IsPostBack then

'don't init, let the values remain....or assign or ave the values and reassign them? hard to say without the code.

Else

'initing the textboxes to be blank?

End If



Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Steven Davidson
Steven Davidson
SSC Journeyman
SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)

Group: Administrators
Points: 96 Visits: 124

I certainly wouldn't say it's Steve's fault Clearly these are very busy forums and something is causing a problem over time. For the upcoming revision of SqlServerCentral we will be moving to the latest version of the forum software and will try and prove that this problem is no longer there during testing, or fix it if it is.

Lowell - thanks for your suggestion. I think it would be a great fix except for a bit of extra magic that is going on internally to keep the ASP and ASP.NET sides of the site running together. This is effectively converting the POST to a GET so the ultimate destination page has no concept of the previous conversation - it is no longer a postback.

We're looking at a couple of potential fixes/workarounds that should prevent the annoyance of losing your post and we'll keep you posted!





Steven Davidson

Developer, Red Gate Software Ltd.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search