Print Page - RE: Account Has Exceeded Its CPU Quota
Airline Mogul Forum
Airline Mogul => Game News => Topic started by: Air Elbonia on July 21, 2007, 06:57:53 am
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Air Elbonia on July 21, 2007, 06:57:53 am
It has come to my attention that various site growth (good thing) the hourly script has been dealing with more... 'stuff'.
Of late, thats amounted to enough to start generating some minor issues sending the site down for brief periods. I'm attacking the problem as best i can, squeezing out further efficiency wherever i can.
I've uploaded a new copy, which has a minor efficiency boost and should help me identify better what is taking so long.
Just thought I'd pass this information along, just as an FYI.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: tomauer on July 21, 2007, 07:49:00 am
Ahh i see, Must be the reason i got booted from the site a few hours ago.
Cheers.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: CornField on July 28, 2007, 05:09:47 am
I just got that message about 40 minutes ago.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Air Elbonia on July 28, 2007, 05:15:50 am
Yeap. that one was me.
I've managed to greatly reduce the time it takes for the hrly script to run.
still isn't perfect, but it's a lot more acceptable at present.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: tomauer on July 28, 2007, 02:37:47 pm
nice, Well i got the message again, not a big problem really.. it only last's a maximum of 1 minute anyway.
Good to see the game already booming, this new round is huge compared to earlier day's. :roll:
thanks for the work.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Crow on August 07, 2007, 05:47:09 am
actually it's on now too :(
Title: RE: Account Has Exceeded Its CPU Quota
Post by: StephenM on August 07, 2007, 05:48:02 am
Quote from: "Crow"
actually it's on now too :(
Hopefully it will be back soon.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: hpscot08 on August 07, 2007, 05:49:16 am
Sorry, I had to join the club that Will and Stephen were in. You silly people wiht your multiple airlines that I have to go through and delete!
Title: RE: Account Has Exceeded Its CPU Quota
Post by: StephenM on August 07, 2007, 05:50:20 am
Quote from: "hpscot08"
Sorry, I had to join the club that Will and Stephen were in. You silly people wiht your multiple airlines that I have to go through and delete!
Just looking at the list of them brought the site down. :lol:
Title: RE: Account Has Exceeded Its CPU Quota
Post by: hpscot08 on August 07, 2007, 05:52:54 am
It was only down for like 2 min, much better than certain other people. BTW, anyone like my new sig?
Title: RE: Account Has Exceeded Its CPU Quota
Post by: StephenM on August 07, 2007, 05:55:52 am
Quote from: "hpscot08"
It was only down for like 2 min, much better than certain other people. BTW, anyone like my new sig?
Its very... Trendy :P
Title: RE: Account Has Exceeded Its CPU Quota
Post by: hpscot08 on August 07, 2007, 06:10:21 am
Testing...
Title: RE: Account Has Exceeded Its CPU Quota
Post by: StephenM on August 07, 2007, 06:13:13 am
Quote from: "hpscot08"
Testing...
Trying to out do Daniels wonderful hard work!
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Daniel Doorgakant on August 07, 2007, 04:09:03 pm
Boom Like!
Title: RE: Account Has Exceeded Its CPU Quota
Post by: MrOrange on September 05, 2007, 07:23:10 pm
We're down again.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Air Elbonia on September 05, 2007, 07:30:12 pm
Sorry, was making two adjustments to indexes in big tables in an effort to reduce traffic jams at hrly updates.
site should be a little better off now (as the hrly script caused a little bit of a delay in the table where aircraft are stored triggering the only, single, site driven cpu exceeded of the day, and i realized cashflow had a pretty redundant index that was easily rid of.)
Title: RE: Account Has Exceeded Its CPU Quota
Post by: dktc on September 05, 2007, 09:02:34 pm
We have been going down every hour for the past 5~6 hours at least. Still going down though :?
Title: RE: Account Has Exceeded Its CPU Quota
Post by: MrOrange on September 05, 2007, 09:18:27 pm
Oh well, maybe we should create a little side-game that you can play while the game is down. I'll create something :lol:
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Air Elbonia on September 05, 2007, 09:37:42 pm
Quote from: "dktc"
We have been going down every hour for the past 5~6 hours at least. Still going down though :?
So we have... hmm. definitely tonight will attempt a patch to one of the more common occuring slow queries which i hope will shave a little time off of it. bloody scary to look at those cpu exceeded logs... takes forever to find the ones that actually "drove" it over the edge as it were. and usually, they're (these days) a few 2-5 second things. The most recent one as of the time of this post was a combined 30 seconds of cpu time on 8-10ish queries, and a loooot of really tiny things.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eddie on September 07, 2007, 03:46:15 am
maybe get a better server?
Title: RE: Account Has Exceeded Its CPU Quota
Post by: dktc on September 07, 2007, 03:51:13 am
Quote from: "eddie"
maybe get a better server?
The admins are looking into it. Please see Air Elbonia's post http://stephenm.org/forum/viewtopic.php?p=11911#11911
and I know... all these links are making me dizzy as well. :wink:
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eddie on September 07, 2007, 03:52:22 am
i was about to say it lol
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eddie on September 07, 2007, 04:20:45 am
ok im about to call i quits.
i think in the last hour its been down more then up
Title: RE: Account Has Exceeded Its CPU Quota
Post by: clee899 on September 07, 2007, 04:23:20 am
Quote from: "eddie"
ok im about to call i quits.
i think in the last hour its been down more then up
Patience. It usually takes 10/15 minutes at most for me. Time to start donating money for that upgraded server i guess...
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eddie on September 07, 2007, 04:30:27 am
Quote from: "clee899"
Quote from: "eddie"
ok im about to call i quits.
i think in the last hour its been down more then up
Patience. It usually takes 10/15 minutes at most for me. Time to start donating money for that upgraded server i guess...
hahah i offered to put it on my server cluster. dont know what more i can do
ohh well
Title: RE: Account Has Exceeded Its CPU Quota
Post by: sarcean on September 07, 2007, 05:58:31 am
*edited*.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: sarcean on September 07, 2007, 06:05:28 am
*edited*
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Air Elbonia on September 07, 2007, 06:36:34 am
Thank you sarcean.
-makes that ftp access go poof-.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eddie on September 07, 2007, 06:37:09 am
Quote from: "sarcean"
please take away eddies db/script access immediately
He is running scripts to give people free money..and its going to *cabbage* up the game. He is giving people from the forum (offtopic.com) free money and if you allow it to go on the game is going to get *cabbage*ed.
You shouldn't have given him access he is just running whatever code he wants
umm im eddie and i dont know what you are talking about ??
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eddie on September 07, 2007, 06:37:41 am
noone has ever given me anything.
:confused:
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Air Elbonia on September 07, 2007, 06:40:32 am
being eddie or not, i know who was doing that and now that capability has been removed.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: sarcean on September 07, 2007, 07:08:23 am
.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eWRXshun on September 07, 2007, 08:11:24 am
to forum administration staff:
there is a wager in progress on offtopic.com (herein referred to as OT) to see if i have created a fake account under the name "sarcean" to expose the person running a money script.
if you could coordinate with the site owner and/or a super-mod on OT and provide both of the IP addresses of me and the member "sarcean" so that the staff on there can compare the two to see who is the real person behind the expose, it would be greatly appreciated.
i have been accused by mutiple parties on OT as a snitch because i spoke out against giving money away.
now i have wagered the accusing parties a permanent ban from the forum plus a lifetime membership.
your coordination would be greatly appreciated.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: sarcean on September 07, 2007, 08:14:58 am
Quote from: eWRXshun
to forum administration staff:
there is a wager in progress on offtopic.com (herein referred to as OT) to see if i have created a fake account under the name "sarcean" to expose the person running a money script.
if you could coordinate with the site owner and/or a super-mod on OT and provide both of the IP addresses of me and the member "sarcean" so that the staff on there can compare the two to see who is the real person behind the expose, it would be greatly appreciated.
i have been accused by mutiple parties on OT as a snitch because i spoke out against giving money away.
now i have wagered the accusing parties a permanent ban from the forum plus a lifetime membership.
your coordination would be greatly appreciated.
.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eWRXshun on September 07, 2007, 08:17:58 am
Quote from: "sarcean"
no, I was only helping the game out by exposing what efiniti was doing. If no one had told the admin alot of *vegetable* could of gone down with out his knowing...Obviously it wasn't you
Why would the admin of this site out me?
well i'm glad that i have to be the fall guy for something i didn't even do... (http://smiliesftw.com/x/ugh2.gif) (http://smiliesftw.com)
just the same, as long as the admin on here coordinates with the admin on OT, i'm sure this can all be taken care of. you don't need to be publicly made on OT, just as long as the ruling party has their proof.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: sarcean on September 07, 2007, 08:23:47 am
.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Blue Sky Mine on September 07, 2007, 08:40:47 am
Calm down plz!
Title: RE: Account Has Exceeded Its CPU Quota
Post by: eWRXshun on September 07, 2007, 08:47:46 am
now what:
Either the email address and password entered do not match those on the file, you have not activated your account or you are not appoved for testing.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: StephenM on September 07, 2007, 10:08:35 am
Quote from: "eWRXshun"
now what:
Either the email address and password entered do not match those on the file, you have not activated your account or you are not appoved for testing.
If there is a problem with the Login, email Daniel Doorgakant.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Pod1967 on September 07, 2007, 01:01:58 pm
got the old http 500 internal server error message. Definately annoying when you're in the middle of editing routes, but sh%t happens.
Is this down to the large user activity around certain times?
Title: RE: Account Has Exceeded Its CPU Quota
Post by: dktc on September 07, 2007, 01:08:49 pm
Quote from: "Pod1967"
got the old http 500 internal server error message. Definately annoying when you're in the middle of editing routes, but sh%t happens.
Is this down to the large user activity around certain times?
I would say it is about the same thing, although I am not too sure... (waiting for the admins to say something)
@eWRXshun and sarcean, all I can say is grow up! eWRXshun, you are behaving like a elementary school student. sarcean, keep you emotion in check or you will get into trouble. That being said, anymore posts not directly related to the site being down (ie. not reporting the site being down), will risk being deleted.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: MrOrange on September 07, 2007, 01:31:48 pm
@Pod1967: First, thanks, thanks for making the first useful thread-related not-flaming post in a while. The 500 error is probably due to a server error or overload, which could either be because of large activity or some demanding scripts.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Jps on September 07, 2007, 01:32:29 pm
That's happening right now... :(
Title: RE: Account Has Exceeded Its CPU Quota
Post by: MrOrange on September 07, 2007, 01:38:46 pm
Not for me :?
Title: RE: Account Has Exceeded Its CPU Quota
Post by: dktc on September 07, 2007, 01:41:47 pm
error 500 usually pops up for a very short time only.
CPU error page is the one that last longer.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Pilgrim on September 07, 2007, 02:40:26 pm
i don't know if this is related but today ive been getting blank pages often when clicking on different pages. No error, and its not around the top of the hour only either, but all the time... though it seems to of calmed down now, im still getting them occasionally. And it's happening on 2 computers from 2 locations too.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: Air Elbonia on September 07, 2007, 03:53:44 pm
-looks through, modifies an index, knocks out another pretty common slow query-
edit: And yeah, that site white-screen does happen to just about everyone as near as i can tell... Usually seems to be something running long without triggering the cpu exceeded. trying my best to smash down slow queries that cause the backups. Pondering disabling route history data updates
EDIT: Alright. route histories temporarily disabled (the update, any existing data will remain, of course). this should hopefully cut down on the cascading factor that sends the site down at the hours.
Title: RE: Account Has Exceeded Its CPU Quota
Post by: gizgiz on September 08, 2007, 08:54:41 am
Do you guys need a mirror by any chance?
Title: RE: Account Has Exceeded Its CPU Quota
Post by: StephenM on September 08, 2007, 10:40:05 am
Quote from: "gizgiz"
Do you guys need a mirror by any chance?
We are sorting it, dont worry. ;)
Title: RE: Account Has Exceeded Its CPU Quota
Post by: blue25 on September 08, 2007, 10:43:13 am
Yeah... :roll: It'll be worked on I hope :wink: Oh BTW... I get this message even when I'm inactive for a while :?