Frequent 'Server errors'
Printed From: Progarchives.com
Category: Site News, Newbies, Help and Improvements
Forum Name: Report bugs here
Forum Description: Help us improve the site from a tech standpoint
URL: http://www.progarchives.com/forum/forum_posts.asp?TID=50467
Printed Date: November 26 2024 at 17:39
Software Version: Web Wiz Forums 11.01 - http://www.webwizforums.com
Topic: Frequent 'Server errors'
Posted By: Blacksword
Subject: Frequent 'Server errors'
Date Posted: July 26 2008 at 09:05
|
Couldn't spot another obvious thread about this.. Sorry if there is one.
I frequentlt get this error when either trying to access PA, or when I post on the forum: Server Error in Forum Application An error has occurred while writing to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_save_new_post_data File Name:- new_post.asp Error details:- Microsoft OLE DB Provider for SQL Server Timeout expired I can see there is a problem with the server, but are others getting this? Could there be a problem my end, exacerbating this problem? |
Replies:
Posted By: avestin
Date Posted: July 26 2008 at 09:24
|
I'm getting this as well all morning today (US east coast time).
Plus, the site is extremely slow!
------------- http://hangingsounds.blogspot.com/" rel="nofollow - Hanging Sounds http://www.progarchives.com/ProgRockShopping.asp" rel="nofollow - PA Index of prog music vendors |
Posted By: Tuzvihar
Date Posted: July 26 2008 at 09:34
|
Ditto!
------------- "Music is much like f**king, but some composers can't climax and others climax too often, leaving themselves and the listener jaded and spent." Charles Bukowski |
Posted By: Ricochet
Date Posted: July 26 2008 at 09:39
|
Yep, the logging/replying/opening threads error are back.
------------- 
|
Posted By: Blacksword
Date Posted: July 27 2008 at 08:22
| Twice today, I've had the problem. I'm slightly reaasured by the fact that it's not just me. I have confidence in Max & co to resolve the issue before long. |
Posted By: Tuzvihar
Date Posted: July 27 2008 at 08:46
That's really irritating. I've got the Active Topics site set as the starting site in my browser and I get this error almost every time I turn on the browser.  Plus the forum is so damn slow...  ------------- "Music is much like f**king, but some composers can't climax and others climax too often, leaving themselves and the listener jaded and spent." Charles Bukowski |
Posted By: Finnforest
Date Posted: July 27 2008 at 08:47
Not getting the error here, but, the speed is just ridiculous. Painfully slow....can't deal with staring at that darn hourglass icon! All other websurfing is fine....it is just PA. |
avestin wrote:Posted By: clarke2001
Date Posted: July 27 2008 at 08:52
|
Four continuous attempts to post a reply in a forum ,every time getting: Server Error in Forum Application An error has occurred while writing to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_getUserData()_update_last_visit File Name:- functions_login.asp Error details:- Microsoft OLE DB Provider for SQL Server Timeout expired When trying to load some artist page, "Service Unavailable" appearead, I finally managed to reach the page but only after repeated retrying. And it's so slow. And this one really takes the cake: after another "post Reply" failure, I pressed the "Back" button on my Mozilla browser and got:  |
Posted By: M@X
Date Posted: July 27 2008 at 09:49
|
Yeah , i am working on it ... I am trying to isolate what is causing the Server CPU to Step UP to 100%. Tonite, I've manage to isolate the Forum and the Discography so that the Discography do not cause the FORUM to slow down in case of High CPU Usage. I am still working on this issue. Please post improvements or problems here. PS: I am also looking to upgrade the server, or to split the Forum and Disco on 2 servers. ------------- Prog On ! |
Posted By: Ricochet
Date Posted: July 27 2008 at 10:31
|
Well, the latest for me is that every time I try to log, it gives me an error, but when going back from the error page, it returns to the front page of the forum, with me being logged. So it eventually logs me, but the whole process is bugged as it always goes through the error. -------------
|
Posted By: CCVP
Date Posted: July 27 2008 at 14:04
the forums and the site are extremely slow and some of my posts / reviews were not posted. Thank God i save everything before posting 
-------------   
|
Posted By: Windhawk
Date Posted: July 28 2008 at 00:35
|
Right now the discographies seems to be completely knocked out - as is the homepage. Big, fat service unavailable greets me there now. Forums seem to be working though. ------------- Websites I work with: http://www.progressor.net http://www.houseofprog.com My profile on Mixcloud: https://www.mixcloud.com/haukevind/ |
Posted By: Yorkie X
Date Posted: July 28 2008 at 02:28
| I'm getting these errors so often I`m starting to wonder whats going on .. So I`m here reading other stories of the same kind wondering whats going on about it ? because I find is very frustrating when making a post just to have it chewed up all the time and being given an error message. Error had happened not long before posting this |
Posted By: M@X
Date Posted: July 28 2008 at 02:33
|
Again --- I am aware of theses errors and woking hard to fix it right now .... Thanks for reporting ------------- Prog On ! |
Posted By: Tuzvihar
Date Posted: July 28 2008 at 12:42
It's much much better now. Thanks a lot M@x!  ------------- "Music is much like f**king, but some composers can't climax and others climax too often, leaving themselves and the listener jaded and spent." Charles Bukowski |
Posted By: The Quiet One
Date Posted: July 29 2008 at 12:51
|
hmmm, today it has been aplied to me these errors or whatever, I've made a thread I'll delete it.
2 out of 5 times posting or entering threads it says what Blacksword said, and also "Service Unavailable" ALSO, the "Search" button to search bands doesn't work, at least to me. |
Posted By: rushfan4
Date Posted: July 29 2008 at 12:57
|
I don't know if this has anything to do with some of the problems, but I have noticed the last couple of days around this time, that the number of on-line forum users spikes dramatically. I just checked and there are 256 users, most of which are not members. I'm not sure if these are hackers or i-robots that are logging in to threads to cause the site to bog down, or something entirely different. I don't know if this helps or not, but it was something that looked rather strange to me. ------------- 
|
Posted By: avestin
Date Posted: July 29 2008 at 12:57
|
about a third of my sent posts ended up with that "Service Unavailable" screen today.
The site seems to be quicker than the last few days but the amount of error notices only increased.
------------- http://hangingsounds.blogspot.com/" rel="nofollow - Hanging Sounds http://www.progarchives.com/ProgRockShopping.asp" rel="nofollow - PA Index of prog music vendors |
Posted By: Slartibartfast
Date Posted: July 29 2008 at 13:01
Disco? Disco? Run away! Run away! Seriously, much thanks for all the hard work.  ------------- Released date are often when it it impacted you but recorded dates are when it really happened... 
|
Posted By: The Quiet One
Date Posted: July 29 2008 at 13:23
That's what's happening with me! 
Check the "Search" button to look for bands on the homepage and tell me if it works. |
Posted By: avestin
Date Posted: July 29 2008 at 13:26
it works for me, but this feature has been known to suffer from errors in the past.
------------- http://hangingsounds.blogspot.com/" rel="nofollow - Hanging Sounds http://www.progarchives.com/ProgRockShopping.asp" rel="nofollow - PA Index of prog music vendors |
Posted By: The Quiet One
Date Posted: July 29 2008 at 13:32
| ^oh you're lucky, hehe..well not so, nobody is in these times. |
Posted By: Tuzvihar
Date Posted: July 29 2008 at 15:08
What happened?! For a short period of time I couldn't load the site. I got the message that the server couldn't be found. 
------------- "Music is much like f**king, but some composers can't climax and others climax too often, leaving themselves and the listener jaded and spent." Charles Bukowski |
Posted By: Windhawk
Date Posted: July 29 2008 at 15:21
|
If it is any help in tracking down the errors currently haunting the site, the problems today started sometime between 8 and 9 am EST. In the hours prior to that it all ran smooth as silk.
------------- Websites I work with: http://www.progressor.net http://www.houseofprog.com My profile on Mixcloud: https://www.mixcloud.com/haukevind/ |
Posted By: Certif1ed
Date Posted: July 29 2008 at 15:41
|
That's about when I started noticing them. We'd had some work done, and the &^%&%( workmen cut through our power cables, so I thought it could have been that - but I'm seeing it on the computer here too. ------------- The important thing is not to stop questioning. |
Posted By: Tuzvihar
Date Posted: July 29 2008 at 15:50
|
BTW, now the message 'Service Unavailable" appears frequently...
------------- "Music is much like f**king, but some composers can't climax and others climax too often, leaving themselves and the listener jaded and spent." Charles Bukowski |
Posted By: Blacksword
Date Posted: July 29 2008 at 16:08
|
ooohh, I've just had a'Stack overflow at Line 0'!!
That was painfull, I can tell you! 
|
Posted By: rileydog22
Date Posted: July 29 2008 at 16:11
Nah, it was crappy at 2 AM. -------------   |
Posted By: Tuzvihar
Date Posted: July 29 2008 at 16:12
------------- "Music is much like f**king, but some composers can't climax and others climax too often, leaving themselves and the listener jaded and spent." Charles Bukowski |
Posted By: Rivertree
Date Posted: July 29 2008 at 16:37
 Service unavailable in many cases - annoying ...
------------- https://awesomeprog.com/users/Rivertree" rel="nofollow">  |
Posted By: Pnoom!
Date Posted: July 29 2008 at 16:38
I would post helpful info in this thread but I keep getting told service is unavailable...
|
Posted By: Ivan_Melgar_M
Date Posted: July 29 2008 at 17:39
|
In my case is different and worst, I can't enter to any thread or even the search function, I had to open an old cookie to enter to a stored page in order to be accepted by the forum.
The same happens in the main section, I can't search for a band, open a genre or post a review
Iván ------------- 
|
Posted By: Slartibartfast
Date Posted: July 29 2008 at 18:05
|
How nice of these errors to keep evolving for us, otherwise they'd be both boring and annoying. And of course it's not like M@x has anything better to do than to spend all his time chasing down the gremlins. Maybe this site just needs a good exorcism:  ------------- Released date are often when it it impacted you but recorded dates are when it really happened...
|
Posted By: Chris S
Date Posted: July 29 2008 at 18:08
a deep breath everyone..................................lets give mailto:M@x - M@x some air ------------- ...As I venture through the slipstream, between the viaducts in your dreams...[/COLOR] |
Posted By: The Quiet One
Date Posted: July 29 2008 at 18:17
I don't have it so bad as yours, but the Search button for bands doesn't work to me also. And the Servive Unavailable, as many said, is appearing frequently. |
Posted By: CCVP
Date Posted: July 29 2008 at 20:11
Agreed, call the Vatican at once! -------------
|
Posted By: b_olariu
Date Posted: July 30 2008 at 01:11
| Errors and errors on my screen, everything i posted or wrote is gone, where nobody knows, again same thing after 10 minutes. I'm a patient man so i 'll wait mailto:M@x - M@x to fix this problem or problems. |
Posted By: b_olariu
Date Posted: July 30 2008 at 01:32
|
Me to, same errors, every time i want to wrote or post something.
Server Error in Forum Application
An error has occurred while sending an email. Please contact the forum administrator. Support Error Code:- err_SQLServer_send_mail_footer File Name:- functions_send_mail.asp Error details:- CDO.Message.1 The parameter is incorrect. |
Posted By: Ivan_Melgar_M
Date Posted: July 30 2008 at 01:40
|
B_olariu, please leave some air to mailto:M@X - M@X this has been repeatedly reported by many members and you are complaining in every thread.-
Leave the man some time, he has to deal with this and has a real life also.
Check all the threads, report if there's something new, and wait.
Iván -------------
|
Posted By: rileydog22
Date Posted: July 30 2008 at 01:44
|
Reporting specific error messages is probably useful for M@X, Ivan. It's a lot easier to fix a problem when you know what it is.
------------- |
Posted By: Ivan_Melgar_M
Date Posted: July 30 2008 at 01:49
Yes Rilleydog, the first time helps if done repeatedly is placing preasure, and this error has been reported more than 20 times over a week.
If people could just read what has been reported already, wouldn't put preasure on someboody that I know is working a lot in this problem for over a month to give us a site that we enjoy for free.
Iván.
-------------
|
Posted By: b_olariu
Date Posted: July 30 2008 at 02:00
Ok, so i'll just wait and see what's going on
 |
Posted By: ClemofNazareth
Date Posted: July 30 2008 at 07:34
Not sure what the 'Service Unavailable' root cause is, but I wonder how much of the forum slowness and the SQL errors are attributable to CPU usage by searchbots. We've always had a lot of traffic from these crawlers, but the last few months or so the percentage of bot logins has risen to where it is usually 90%-plus of the number of logged users at any given time. I've sat and refereshed the users screen several times on different occasions to see if these guys are using reasonable policies for polite cataloging, and most of them don't seem to be. I would not be at all surprised if 98% or more of the site's traffic is due to these bots. And since virtually everything on this site is stored in a SQL database and uses ASP code, I would assume that means a lot of CPU usage. One option (if this hasn't been explored already) would be to restrict searchbots from the forums. I know M@x needs max exposure (no pun intended) for traffic count purposes as well as the 'free' advertising that search engines offer, but I would think this would apply more to the discog section of the site than the forums. The forum data isn't as attractive for a few reasons: - it is more volatile (changes constantly, which just perpetuates the searchbot traffic); - is of limited value to the outside world (ever come across a snippet of a ProgArchives forum thread while Googling for something? These usually fall far down the list on searches and are also usually stale and/or not really appropriate to whatever you were searching for); - there doesn't seem to be any logical rhyme or reason on how these things search or how long their host sites retain the information in their active engine databases. I'm sure M@x has explored all this fully, but I have wondered for quite some time how invasive these bots are to the site as far as bandwidth drain on the server(s), database connections, and CPU usage. I suppose they help keep the hit counts up at least.... ------------- "Peace is the only battle worth waging." Albert Camus |
Posted By: The Doctor
Date Posted: August 01 2008 at 13:24
|
The site is running very slow for me today, and quite often when I click a link I get a Service Unavailable error. I have to go out of the forum, and come back in and then the problem resolves itself....temporarily. ------------- I can understand your anger at me, but what did the horse I rode in on ever do to you? |
Posted By: Easy Livin
Date Posted: August 01 2008 at 14:04
| I'm afraid there are ongoing issues. mailto:M@x - M@x is working very hard to resolve them, but they are proving difficult to eradicate. |
Posted By: VanderGraafKommandöh
Date Posted: August 01 2008 at 14:58
|
I have the same issues as others, except I cannot access any threads in Firefox!
I get the following error: The system cannot find the file specified.
So I'm having to use Internet Explorer for the time being.
I've cleared my cookies and my history in Firefox and I'm still not having any luck.
HughesHB4 also messaged me privately and said he had the same error. -------------   
|
Posted By: The Doctor
Date Posted: August 01 2008 at 15:08
|
I was getting that same error yesterday in Firefox at work.
Now I'm either getting service unavailable, or:
Server Error in Forum Application An error has occurred while writing to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_getUserData()_update_last_visit File Name:- functions_login.asp Error details:- Microsoft OLE DB Provider for SQL Server Timeout expired ------------- I can understand your anger at me, but what did the horse I rode in on ever do to you? |
Posted By: VanderGraafKommandöh
Date Posted: August 01 2008 at 18:13
|
I've solved my Firefox error. If anyone else is experiencing this, you can solve it by doing the following: Go to "Tools" when the error page comes on for P.A. Drag down to "Page Info" Click on the "Security" Tab Click on "View Cookies" You should see a list of Progarchives cookies... delete them by going to "Remove Cookie" for each one (or highlight them all first). That should solve the issue. -------------
|
Posted By: The Doctor
Date Posted: August 01 2008 at 18:42
And no, I didn't even misquote this time.
Who would be dumb enough to buy a firefox error?
 I apologize. The temptation was just too great.
Seriously, thanks James. I'll do that the next time I'm on FF if I have a problem. ------------- I can understand your anger at me, but what did the horse I rode in on ever do to you? |
Posted By: VanderGraafKommandöh
Date Posted: August 01 2008 at 18:50
Why you...  Hopefully that'll work, it did for me. Simply deleting cookies in Options didn't work for me. -------------
|
Posted By: Rivertree
Date Posted: August 01 2008 at 19:30
|
Thanks James for this clue ... Don't know why exactly - but it works better when deleting the old cookies .. even if there were build new ones soon ... ------------- https://awesomeprog.com/users/Rivertree" rel="nofollow"> |
Posted By: VanderGraafKommandöh
Date Posted: August 01 2008 at 19:36
Not a problem. It took me ages to work out. I thought deleting the cookies via Options (under Tools menu), would do the trick but it doesn't. You have to delete the cookies for the whole site, as I indicated above. I still get the SQL errors of course and it's still slow but at least I can use Firefox again... IE was driving me mad! Resetting cookies every so often is always a good plan. It means you will have to log back-in but that should not be an issue. It just makes new Cookies anyhow. There were obviously some old cookies that were causing the issues. -------------
|
Posted By: Rivertree
Date Posted: August 01 2008 at 19:49
 Probably it's a coincidence but I'm browsing through the forum actually and no new errors are occurring after deleting the old cookies ... let's monitor this for a while ... ------------- https://awesomeprog.com/users/Rivertree" rel="nofollow"> |
Posted By: Ricochet
Date Posted: August 05 2008 at 02:00
|
It's good to see you all folks again. Yesterday I couldn't access any links except the front page and front forum page at all.
-------------
|
Posted By: Jared
Date Posted: August 05 2008 at 05:45
Riccy...I'm relieved that I wasn't the only one...yesterday evening, I couldn't get past the main forum page either, and I tried at intermittant intervals throughout the evening..  ------------- Music has always been a matter of energy to me. On some nights I believe that a car with the needle on empty can run 50 more miles if you have the right music very loud on the radio. Hunter S Thompson |
Posted By: Ricochet
Date Posted: August 05 2008 at 06:14
well, since only 6 reviews were managed to be input yesterday (I monitored closely), the site could have been revived at some point, but it must have been for short time. I do imagine that most had this problem as well, so that it was general. -------------
|
Posted By: chopper
Date Posted: August 05 2008 at 07:21
| Yesterday evening was probably the worst period I've seen on the forums for timeout errors. |
Posted By: micky
Date Posted: August 05 2008 at 09:11
yep... managed to get and answer a PM.. and was unable to do much else and gave up and shut it down.. ------------- The Pedro and Micky Experience - When one no longer requires psychotropics to trip |
Posted By: Andrea Cortese
Date Posted: August 05 2008 at 17:02
|
... I've posted this review some minute ago http://www.progarchives.com/Review.asp?id=178898 - http://www.progarchives.com/Review.asp?id=178898 but it has disappeared from the home page... what's the problem?
...and now I have problems to post this comment!!!
|
Posted By: Ivan_Melgar_M
Date Posted: August 05 2008 at 17:22
It's posted Andrea, seems you have not been here for some days....Maybe I'm wrong.
But there's a new addendum at the end of the space for postiong the reviews: Posted review may be delay to appear in site due to caching feature
Sometimes it takes even 30 minutes between the time you posted it and it appears in the home page.
Iván -------------
|
Posted By: Andrea Cortese
Date Posted: August 05 2008 at 17:42
| Didn't know. In fact I've been out in the last days. Thanks Ivàn. |
Posted By: rileydog22
Date Posted: August 05 2008 at 23:45
------------- |
||||
