Forum Home Forum Home > Site News, Newbies, Help and Improvements > Report bugs here
  New Posts New Posts RSS Feed - Frequent 'Server errors'
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedFrequent 'Server errors'

 Post Reply Post Reply Page  <1234>
Author
Message
Ivan_Melgar_M View Drop Down
Special Collaborator
Special Collaborator

Honorary Collaborator

Joined: April 27 2004
Location: Peru
Status: Offline
Points: 19535
Direct Link To This Post Posted: July 30 2008 at 01:49
Originally posted by rileydog22 rileydog22 wrote:

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.  
 
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.
 
 
            
Back to Top
b_olariu View Drop Down
Prog Reviewer
Prog Reviewer
Avatar

Joined: March 02 2007
Location: Romania
Status: Offline
Points: 5531
Direct Link To This Post Posted: July 30 2008 at 02:00
Originally posted by Ivan_Melgar_M Ivan_Melgar_M wrote:

B_olariu, please leave some air to 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
 
Ok,  so i'll just wait and see what's going onWacko
Back to Top
ClemofNazareth View Drop Down
Special Collaborator
Special Collaborator
Avatar
Prog Folk Researcher

Joined: August 17 2005
Location: United States
Status: Offline
Points: 4659
Direct Link To This Post Posted: July 30 2008 at 07:34
Originally posted by rushfan4 rushfan4 wrote:

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.


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
Back to Top
The Doctor View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: June 23 2005
Location: The Tardis
Status: Offline
Points: 8543
Direct Link To This Post 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?
Back to Top
Easy Livin View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator / Retired Admin

Joined: February 21 2004
Location: Scotland
Status: Offline
Points: 15585
Direct Link To This Post Posted: August 01 2008 at 14:04
I'm afraid there are ongoing issues. M@x is working very hard to resolve them, but they are proving difficult to eradicate.
Back to Top
VanderGraafKommandöh View Drop Down
Prog Reviewer
Prog Reviewer
Avatar

Joined: July 04 2005
Location: Malaria
Status: Offline
Points: 89372
Direct Link To This Post 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. 
Back to Top
The Doctor View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: June 23 2005
Location: The Tardis
Status: Offline
Points: 8543
Direct Link To This Post 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?
Back to Top
VanderGraafKommandöh View Drop Down
Prog Reviewer
Prog Reviewer
Avatar

Joined: July 04 2005
Location: Malaria
Status: Offline
Points: 89372
Direct Link To This Post 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.


Edited by James - August 01 2008 at 18:49
Back to Top
The Doctor View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: June 23 2005
Location: The Tardis
Status: Offline
Points: 8543
Direct Link To This Post Posted: August 01 2008 at 18:42
Originally posted by James James wrote:

I've sold my Firefox error.


 
And no, I didn't even misquote this time. 
 
Who would be dumb enough to buy a firefox error?  WinkTongue
 
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?
Back to Top
VanderGraafKommandöh View Drop Down
Prog Reviewer
Prog Reviewer
Avatar

Joined: July 04 2005
Location: Malaria
Status: Offline
Points: 89372
Direct Link To This Post Posted: August 01 2008 at 18:50
Originally posted by The Doctor The Doctor wrote:

Originally posted by James James wrote:

I've sold my Firefox error.


 
And no, I didn't even misquote this time. 
 
Who would be dumb enough to buy a firefox error?  WinkTongue
 
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. 


Why you... AngryWinkLOL

Hopefully that'll work, it did for me.  Simply deleting cookies in Options didn't work for me. Cry
Back to Top
Rivertree View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator / Band Submissions

Joined: March 22 2006
Location: Germany
Status: Offline
Points: 17574
Direct Link To This Post Posted: August 01 2008 at 19:30
Thanks James for this clue ... Clap

Don't know why exactly - but it works better when deleting the old cookies .. even if there were build new ones soon ...



Back to Top
VanderGraafKommandöh View Drop Down
Prog Reviewer
Prog Reviewer
Avatar

Joined: July 04 2005
Location: Malaria
Status: Offline
Points: 89372
Direct Link To This Post Posted: August 01 2008 at 19:36
Originally posted by Rivertree Rivertree wrote:

Thanks James for this clue ... Clap

Don't know why exactly - but it works better when deleting the old cookies .. even if there were build new ones soon ...



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.


Edited by James - August 01 2008 at 19:39
Back to Top
Rivertree View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator / Band Submissions

Joined: March 22 2006
Location: Germany
Status: Offline
Points: 17574
Direct Link To This Post Posted: August 01 2008 at 19:49
Smile

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 ...


Edited by Rivertree - August 01 2008 at 19:50


Back to Top
Ricochet View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: February 27 2005
Location: Nauru
Status: Offline
Points: 46301
Direct Link To This Post 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. Smile
Back to Top
Jared View Drop Down
Forum Senior Member
Forum Senior Member
Avatar

Joined: May 06 2005
Location: Hereford, UK
Status: Online
Points: 17534
Direct Link To This Post Posted: August 05 2008 at 05:45
Originally posted by Ricochet Ricochet wrote:

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. Smile
 
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..Ouch
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
Back to Top
Ricochet View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: February 27 2005
Location: Nauru
Status: Offline
Points: 46301
Direct Link To This Post Posted: August 05 2008 at 06:14
Originally posted by fandango fandango wrote:

Originally posted by Ricochet Ricochet wrote:

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. Smile
 
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..Ouch


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.
Back to Top
chopper View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: July 13 2005
Location: Essex, UK
Status: Offline
Points: 19944
Direct Link To This Post Posted: August 05 2008 at 07:21
Yesterday evening was probably the worst period I've seen on the forums for timeout errors.
Back to Top
micky View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: October 02 2005
Location: .
Status: Offline
Points: 46828
Direct Link To This Post Posted: August 05 2008 at 09:11
Originally posted by chopper chopper wrote:

Yesterday evening was probably the worst period I've seen on the forums for timeout errors.


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
Back to Top
Andrea Cortese View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: September 05 2005
Status: Offline
Points: 4411
Direct Link To This Post Posted: August 05 2008 at 17:02
... I've posted this review some minute ago 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!!!Angry
Back to Top
Ivan_Melgar_M View Drop Down
Special Collaborator
Special Collaborator

Honorary Collaborator

Joined: April 27 2004
Location: Peru
Status: Offline
Points: 19535
Direct Link To This Post Posted: August 05 2008 at 17:22
Originally posted by Andrea Cortese Andrea Cortese wrote:

... I've posted this review some minute ago 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!!!Angry
 
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
            
Back to Top
 Post Reply Post Reply Page  <1234>

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.117 seconds.
Donate monthly and keep PA fast-loading and ad-free forever.