It might be one (or more) of my recently added Firefox add-ons but lately, I'm getting a lot of hangs when I try to edit posts. If I hit stop and leave the page for a while and then come back, it will let me go back to the forum but if I try to edit again, it hangs again and then I can't do anything for another 10 minutes or so.
At least I know it's probably the forum. I installed about ten new FF add-ons a few days ago. You never know.
[Link]
the unknown pervert Deactivated User
I'd like to stay but I've got a plane to catch. 3243 Posts 5/06
Posted - Nov 9 2012 : 9:00AM
No problems posting but I have tried to edit a post I just made in the wrestling thread and each time the following has appeared. We are sorry, the server encountered an error processing the page you requested. An error notification has been automatically generated and forwarded to the webmaster.
[Link]
the unknown pervert Deactivated User
I'd like to stay but I've got a plane to catch. 3243 Posts 5/06
Posted - Nov 9 2012 : 9:05AM
Scratch that it does actually edit the post but it still gives the error message instead of going back to the post.
^ Yes. That's what it's been doing with me as well. I get the error message but the post still goes through. However, the site remains unresponsive for a few minutes each time it happens. Even if I hit the stop button and reload. It remains unresponsive if I close the tab or even if I restart Firefox.
When i try to edit a post it eventually times out with this message(below) but the edit does take place after i have clicked on the link to go to the home page..
I just had a problem where "it" wouldn't take an edit to a post. A post from today. Who is that hot ad girl? I was unable to edit my first reply in that thread. Edit test. Edited by - HeyNow on 2/11/2013 10:19:23 PM
And I hit right button and got the Reply Sucessfully...message. I'll try to duplicate it here. [Edit: The edit test worked!!] 20,000 Reasons to LOVE HeyNow: The ADT Event of the YEAR! Edited by - HeyNow on 2/11/2013 10:21:00 PM
We were having some really strange database related problems the past few days. Stuff that has worked for many years simply stopped working. I had to recompile all of the stored procedures and user-defined functions in the database. I have no idea what caused it or why a recompilation fixed it.
Consider yourself lucky that you work for yourself. The only people who like the "I don't know why it worked, but it did" answer less than programmers, are programmer's bosses. I hate when my staff tells me that and I hate it even more when I have to pass that answer along to my boss.
I banged my head against a wall for a few hours yesterday trying to figure out what was wrong. A very simple query that should have returned no results was hanging. The query was the equivalent of 'select X where id=0' I could run that query interactively but it wouldn't run as part of a compiled stored procedure, even after recompiling that specific stored procedure. I had to recompile everything before normal behavior resumed. I suppose I could have stopped and restarted the server for the same effect too. All I can think of is some swap space in memory was corrupted. Our entire database ends up being about 90% RAM-based after running for a few days.
What I wouldn't give for that. Some of our tables have gotten so big that in order to run batch jobs even remotely efficiently, we're splitting input files based on database partitions, sorting them on database keys and then running from 10 to 20 concurrent jobs in attempt to mimic RAM based tables.
“Life can only be understood backwards; but it must be lived forwards.” - Kierkegaard 2684 Posts 8/09
Posted - Feb 17 2013 : 9:08PM
Actually now I remember the problem. Yes, I'm still having it but don't use any other browser besides Firefox, so can't isolate it if it's a browser. Since late last year making a post or editing a post usually takes 10-15 seconds (after pressing "Post Reply" to going thru), instead of the near instantaneous confirmation. Opening a webpage or section is normal time, but it seems like it's only slow during writing ops (not reading ops). I ain't complaining cause I'm used to it now. But now I remember... Edited by - BYOB_Kenobi on 2/17/2013 9:11:02 PM
rebooted the server recently. that might have helped. Posts and edits to posts happen in a transaction. There's roughly a dozen different updates that occur for posts and edits. (a few more if the post contains images and/or links to other websites.) Each of these updates puts an exclusive lock on the database table being updated for the duration of the transaction. So when the site is very busy post updates take a little longer.