Cascade Crew Forum Index Cascade Crew
Message Forums
 
 GarageGarage   1/4 Mile Table1/4 Mile Table   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Some info on the errors from yesterday

 
Post new topic   Reply to topic    Cascade Crew Forum Index -> Back Porch
View previous topic :: View next topic  
Author Message
Dewey316
The Lama


Joined: 08 Jan 2004
Posts: 7295
Location: Bringing the tech

1990 Chevrolet Camaro RS

PostPosted: Fri Sep 23, 2005 5:57 am    Post subject: Some info on the errors from yesterday Reply with quote

For those who saw the error last night when trying to access the site. I did not see Jess online, so e-mailed our hosting service. They increased our availabe question amount for the SQL server from 10,000 to 50,000, that should keep that particular problem from happening again.

Quote:
Dear John,

Thank you for contacting iPowerWeb Technical Support.
I apologize for the inconvenience.
We have increased the 'max_questions' limit to 50000 for your account and http://cascadecrew.org/phpBB2/index.php is working fine now.
Please check the same at your end.


Thought the geeks in here might be interested as to the cause, and resolution.

_________________

"Ever see a Motorcycle in front of a Psychiatrists Office?" Me neither
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Kage87Z
Member


Joined: 19 Jan 2004
Posts: 436
Location: 12 Second Club

1969 Chevrolet Camaro

PostPosted: Fri Sep 23, 2005 9:06 am    Post subject: Re: Some info on the errors from yesterday Reply with quote

Dewey316 wrote:
For those who saw the error last night when trying to access the site. I did not see Jess online, so e-mailed our hosting service. They increased our availabe question amount for the SQL server from 10,000 to 50,000, that should keep that particular problem from happening again.

Quote:
Dear John,

Thank you for contacting iPowerWeb Technical Support.
I apologize for the inconvenience.
We have increased the 'max_questions' limit to 50000 for your account and http://cascadecrew.org/phpBB2/index.php is working fine now.
Please check the same at your end.




Thought the geeks in here might be interested as to the cause, and resolution.



_________________
"Are you guys ready? Let's roll."

Todd Beamer - 9/11
Never Forget

My 69's story: http://myspace.com/69camaro454

My 87 Z/28's tale of woah... http://myspace.com/87Zcamaro383
Back to top
View user's profile Send private message
Schultzy89GTA
M.R.A. (11sec Club)


Joined: 08 Jan 2004
Posts: 4417
Location: Gresham, OR

1989 Pontiac GTA

PostPosted: Fri Sep 23, 2005 11:24 am    Post subject: Reply with quote

So it's still not clear... was the limitation on the number of posts/threads on our bulletin board or was it the number of threads to the database (i.e. concurrent users querying)?

Based on your definition last night I thought that we were experiencing a denial of service attack.

-Schultzy

_________________
Red Sled: 89 GTA, 383, TKO, N2O

12.73 @ 109.39, 1.793 60 \ 11.794 @ 121.16, 1.62 60 (old combo)
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address MSN Messenger
Dewey316
The Lama


Joined: 08 Jan 2004
Posts: 7295
Location: Bringing the tech

1990 Chevrolet Camaro RS

PostPosted: Fri Sep 23, 2005 11:45 am    Post subject: Reply with quote

From my understanding, it is the number of SQL query's performed per HOUR. Basicly the phpbb software, was requesting information for SQL at a rate that execeded 10000 questions per hour, that limit was raised to 50000. They did indicated, that if we needed more that 50000 SQL questions per hour, we would have to upgrade our account.
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Schultzy89GTA
M.R.A. (11sec Club)


Joined: 08 Jan 2004
Posts: 4417
Location: Gresham, OR

1989 Pontiac GTA

PostPosted: Fri Sep 23, 2005 4:11 pm    Post subject: Reply with quote

I have a hard time believing that we exceeded that threshold with the number of users that are normally online : shrug :

-Schultzy
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address MSN Messenger
Dewey316
The Lama


Joined: 08 Jan 2004
Posts: 7295
Location: Bringing the tech

1990 Chevrolet Camaro RS

PostPosted: Fri Sep 23, 2005 4:12 pm    Post subject: Reply with quote

It had nothing to do with users. It had to do with the number of database queries that were run in a given period of time. It may have been a bot of some sort, doing something in the background, who knows.
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Schultzy89GTA
M.R.A. (11sec Club)


Joined: 08 Jan 2004
Posts: 4417
Location: Gresham, OR

1989 Pontiac GTA

PostPosted: Fri Sep 23, 2005 4:17 pm    Post subject: Reply with quote

users = execute queries. we are actually agreeing and you validated my point. highly unlikely that with the number of users that we typically have on the board that we would exceed that threshold.

a bot would make sense and relates back to the point that i had made about a DOS attack.

Thanks for working to get the boards back up Thumbs up

-Schultzy
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address MSN Messenger
Dewey316
The Lama


Joined: 08 Jan 2004
Posts: 7295
Location: Bringing the tech

1990 Chevrolet Camaro RS

PostPosted: Fri Sep 23, 2005 4:18 pm    Post subject: Reply with quote

You should have devoted some time for you department at work, to look at the error, and explain why it happened. Wink Wink You have to have some SQL guy's around.
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    Cascade Crew Forum Index -> Back Porch All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group