Topic: ***** STRESS TEST for SG6***** Was last night, test is over thx all (Read 1153 times)

762_XC · « **Reply #30 on:** August 05, 2006, 10:34:09 am »

Are we abandoning SQL then?

Bonk · « **Reply #31 on:** August 05, 2006, 10:37:10 am »

For SGO6, yes. Ship assignments will be done with Dave's flatfile editor on db cleaning maintenance cycles.

The Forge will continue to run on SQL after SGO6 is done as there is no motivation for people to forfeit missions on it.

Testing of the debug development version of the serverkit will also resume after SGO6 is complete. We are committed to get the serverkit working well on MySQL.

Lepton · « **Reply #32 on:** August 05, 2006, 10:43:12 am »

This was precisely as I feared, and now SQL is withdrawn for almost no reason whatsoever. Was this a mere gambit to get an SQL stress test? If so, time for some honest brokers to come forth and pony up the truth?

I have no understanding of what is transpiring here. All the OCI hype and one problem to the public's mind and SQL is out the window? What am I missing here?

Bonk · « **Reply #33 on:** August 05, 2006, 11:00:12 am »

Quote from: Lepton on August 05, 2006, 10:43:12 am

This was precisely as I feared, and now SQL is withdrawn for almost no reason whatsoever. Was this a mere gambit to get an SQL stress test? If so, time for some honest brokers to come forth and pony up the truth?

I have no understanding of what is transpiring here. All the OCI hype and one problem to the public's mind and SQL is out the window? What am I missing here?

No, the debug MySQL tests are run in a totally different (stock) configuration running a debug build from within the VC++ IDE. I have collected no debug data from the SGO6 test runs. It would be pointless, it is not running on stock files. A modded server cannot be used as a baseline.

I do not try and fool people and object to the insinuation. (like I would be that dumb to debug a heavily modded server...

)

Nobody will show up for MySQL debug tests because they are on stock files (and absolutely must be) but we press on.

The OCI was developed for The Forge which chugs along just fine. It is also to give people an idea of what is possible with running the kit on MySQL and hopefully provide some motivation to show up for stock debug test runs.

People are going to forfeit missions on a "serious" server no matter what. Forfetis max out the cpu to 100% for seconds at a time leaving no cpu left for MySQL to do its work, this snowballs and the server crashes.

SQL is not out the window, as mentioned above The Forge will continue to run on MySQL and tests of the kit on stock files in debug mode will continue to be run. We are committed to getting it to work well. Once it is done I would like to disable the ability to forfeit, or just replace the code with a function that does nothing, then move on the PvP DV shifts (which will work on the flatfile as well).

Riskyllama · « **Reply #34 on:** August 05, 2006, 11:02:15 am »

perhaps its not the sql server causing all of these problems? perhaps its the cable causing issues? Seeing as usually when the cable is on the fritz, which seems to be a common problem around server launch times in retrospect, there always seem to be a lot of problems.

Hexx · « **Reply #35 on:** August 05, 2006, 11:02:51 am »

Quote from: Bonk on August 05, 2006, 10:22:16 am

As mentioned above. It does not matter whether the server is run on SQL or not, forfeits saturate CPU use and will eventually cause the server to crash. It may be amplified by using SQL due to the additional cpu overhead of MySQL but the effect holds for the flatfile as well. I know this to be true.

The flatfile test server is up and running. Do not bother forfeiting, I already know exactly what it does to the server in any configuration. The forfeit penalty will remain at 1000 PP to discourage forfeits.

Webmap is here: http://www.dynaverse.net/webmap_sgo6_ff/

Updated missions required here: http://www3.telus.net/NuclearWessels/sfc/downloads/NWPack.exe

The new SGO6 installer will not be posted until approximately 2 hours after I have received the new shiplist.

Unfortunate.

However ~ If I may be so bold~ If yuo want to discourage all forefeits make it a PENALTY. Cheap ships and high paying missions
(as well as 50K of course on the test) make 1k a drop in the bucket.
Make it 10K and I think you'd get alot fewer.

Dizzy · « **Reply #36 on:** August 05, 2006, 11:07:16 am »

Ghosted players forfeit. Its a game engine problem...

Fast computers can handle forfeits. We dont have a fast server computer to handle them... DH could, but he has heat problems during the day. His computer catches fire.

I still want to try SQL... I think Im being backed into the flatfile corner tho...

Bonk · « **Reply #37 on:** August 05, 2006, 11:08:43 am »

Quote from: Hexx on August 05, 2006, 11:02:51 am

However ~ If I may be so bold~ If yuo want to discourage all forefeits make it a PENALTY. Cheap ships and high paying missions
(as well as 50K of course on the test) make 1k a drop in the bucket.
Make it 10K and I think you'd get alot fewer.

I was considering that, but I have not tested what happens if the forfeit penalty is greater than a players PP... will it go negative? Will it crash the server? This is unknown. If I knew that the serverkit would handle it properly I would the forfeit penalty to 1000000, but now is not the time for me to go digging through the serverkit code to find out if the math and code will handle that properly. Though we could test it and find out. But I still need the new shiplist and map and we are already past launch time...

Dizzy · « **Reply #38 on:** August 05, 2006, 11:10:14 am »

U have the new shiplist ck ur email...

Ill get u the map fairly soon... Can you make terrain edits on the map using flatfile?

Bonk · « **Reply #39 on:** August 05, 2006, 11:12:54 am »

Quote from: dizzy on August 05, 2006, 11:07:16 am

Ghosted players forfeit. Its a game engine problem...

Fast computers can handle forfeits. We dont have a fast server computer to handle them... DH could, but he has heat problems during the day. His computer catches fire.

I still want to try SQL... I think Im being backed into the flatfile corner tho...

Ghosted players: bandwidth issue (and software firewalls)

Forfeits: will still max out a quad Xeon 2.4 GHz machine. (I have observed it occur on the UAW server hosted on such a box).

I would like to run on SQL too but I have already reconfigured for the flatfile and we are running late and I do not trust that people will not forfeit when convenient, knowing it will crash the server... (too many opponents on? forfeit a few times and crash the server... too easy an exploit.)

Let me think about it while I wait for the new shplist and map and over the two hours it will take to upload the new installer).

Bonk · « **Reply #40 on:** August 05, 2006, 11:15:22 am »

Quote from: dizzy on August 05, 2006, 11:10:14 am

U have the new shiplist ck ur email...

Ill get u the map fairly soon... Can you make terrain edits on the map using flatfile?

Coolness I can start on the new installer then.

Yes I can edit the map on the flatfile while the server is down either with Dave's editor or my trusty hex editor (Sweetscape's 010 Editor).

Dizzy · « **Reply #41 on:** August 05, 2006, 11:16:19 am »

Good. Then the Doomsday Device can destroy everyone's planets! MUHAHAHAHAHAHA

Riskyllama · « **Reply #42 on:** August 05, 2006, 11:21:15 am »

Quote from: Bonk on August 05, 2006, 11:08:43 am

Quote from: Hexx on August 05, 2006, 11:02:51 am
However ~ If I may be so bold~ If yuo want to discourage all forefeits make it a PENALTY. Cheap ships and high paying missions
(as well as 50K of course on the test) make 1k a drop in the bucket.
Make it 10K and I think you'd get alot fewer.

I was considering that, but I have not tested what happens if the forfeit penalty is greater than a players PP... will it go negative? Will it crash the server? This is unknown. If I knew that the serverkit would handle it properly I would the forfeit penalty to 1000000, but now is not the time for me to go digging through the serverkit code to find out if the math and code will handle that properly. Though we could test it and find out. But I still need the new shiplist and map and we are already past launch time...

it goes to 0 and stays there, at least on FF but i would assume that happens in SQL as well

Bonk · « **Reply #43 on:** August 05, 2006, 11:24:11 am »

Thanks Risky. Consider it done then, the forfeit penalty will be 1000000. (though I'm sure that won't stop people from crashing the server when its convenient with an alternate account)

Dizzy · « **Reply #44 on:** August 05, 2006, 11:29:23 am »

If a player is ghosted and someone runs a mission in their hex they get a forfeit. FYI

EDIT: And thge drafting player gets a long countdown after which he to will get a forfeit or a crash or a mission start, one of the three.

Obviously, forfeits are a small hole and unpatched problem of this game. Sigh.

Bonk · « **Reply #45 on:** August 05, 2006, 11:31:03 am »

Quote from: dizzy on August 05, 2006, 11:29:23 am

If a player is ghosted and someone runs a mission in their hex they get a forfeit. FYI

Getting a forfeit as a mission result is not the same as pressing the forfeit button. (the bloody evil thing should not even be there at all, I have no idea what Taldren was thinking and how its code passed QA... assuming there was any... OK, I'm getitng cranky time to chill...

)

Dizzy · « **Reply #46 on:** August 05, 2006, 11:32:31 am »

U still get docked prestige.

Bonk · « **Reply #47 on:** August 05, 2006, 11:34:06 am »

I am convinced that player ghosting would be significantly reduced if people did not insist on running software firewalls.

Riskyllama · « **Reply #48 on:** August 05, 2006, 11:41:28 am »

or if the cable the server was on actually worked all the time..

Bonk · « **Reply #49 on:** August 05, 2006, 11:48:21 am »

That too of course. Unfortunately, Comcast is incapable of physically securing their copper. (I don't know why, every Canadian cable company I have had experience with is extremely anal about line security and manages to keep their lines secure...)

SideSwipe9th · « **Reply #50 on:** August 05, 2006, 11:54:15 am »

Securing their copper? Is someone actually 'taping' your line and stealing your bandwidth?

Maybe it would be good to look for another providor, I believe most contracts have a clause in them that allows the client to break it if they are recieving unsatisfactory service

762_XC · « **Reply #51 on:** August 05, 2006, 12:24:29 pm »

Frey needs to finish the "Woes of the Administrator" story.

SideSwipe9th · « **Reply #52 on:** August 05, 2006, 12:32:44 pm »

Rofl, I just found that thread. I wanna hear more on it

SCM_SFHQ_XC · « **Reply #53 on:** August 05, 2006, 12:35:10 pm »

I dont think he will be doing more of that.. at least last time I talked to him he said he probably wouldnt finish it...

Bonk · « **Reply #54 on:** August 05, 2006, 01:37:49 pm »

Quote from: SideSwipe9th on August 05, 2006, 11:54:15 am

Securing their copper? Is someone actually 'taping' your line and stealing your bandwidth?

Yes tapping the lines, but to steal cable TV. The noise introduced on the line makes network traffic nearly impossible. While coax is a superior signal conductor it is very fussy about how it is wired. Inexpert tenants stealing cable in nearby apartment buildings is all it takes to cripple a cable network segment. Most buildings have their cable access points locked down. Unfortunately there are some down there who do not and seem to refuse to.

Anyway, I have decided the forfeit penalty will remain at 1000 PP as I'm not sure if it is deducted from erroneous forfeit mission results. And cranking it up to a million will not stop people from creating another account to crash the server at their convenience anyway.

762_XC · « **Reply #55 on:** August 05, 2006, 01:39:43 pm »

Are we just talking about mission forfeits? Does ESC-Forfeit in a mission cause the same problems?

Does Alt-F4?

Bonk · « **Reply #56 on:** August 05, 2006, 01:42:31 pm »

I am talking about pressing the forfeit button instead of accepting a mandatory mission at the mission selection panel.

As far as I know an ALT-F4 or ESC-Forfeit does not force the server to try to resolve a mission as a forfeit in the same way.

762_XC · « **Reply #57 on:** August 05, 2006, 01:44:58 pm »

K, just checking

Dizzy · « **Reply #58 on:** August 05, 2006, 01:56:09 pm »

When the news reports that a player has forfeited a mission, said player is docked whatever the pp penalty is. FYI

762_XC · « **Reply #59 on:** August 05, 2006, 02:00:42 pm »

Sometimes lag causes that. I have seen myself get that in the news and I never forfeit.

Anytime you get a countdown to 0 I think it reports a forfeit.

The good news is TT has a new puter now.

News:

Author Topic: ***** STRESS TEST for SG6***** Was last night, test is over thx all (Read 1153 times)

762_XC

762_XC

762_XC

762_XC

762_XC

Author Topic: * STRESS TEST for SG6* Was last night, test is over thx all (Read 1153 times)