Topic: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central  (Read 13827 times)

0 Members and 4 Guests are viewing this topic.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« on: November 18, 2005, 05:02:45 pm »
This will be a first for us and is well overdue. (Since DarkElf's efforts that got cut short due to RL issues)

We will be running a debug version of the serverkit from the Visual C++ debugger. This will allow us to see exactly where in the code it crashes if it does.

This will be on stock files (absolutley necessary).

Frey installed the necessary tools on the server and Magnumman put a bunch of work into this, we are lucky to have these guys!  :notworthy:

I cannot emphasise enough the significance of this test. So please, everybody be there with bells on!
« Last Edit: November 22, 2005, 09:57:16 am by Bonk »

Offline Hexx

  • Sexy Shoeless Lyran God Of War
  • Captain
  • *
  • Posts: 6058
Re: BIG MySQL Test Saturday 8PM Central
« Reply #1 on: November 18, 2005, 05:35:35 pm »
Stock as is OP 4.0 or stock as in what cam with the game?
Courageously Protesting "Lyran Pelt Day"

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test Saturday 8PM Central
« Reply #2 on: November 18, 2005, 05:41:01 pm »
Stock OP 2.5.5.2. (not OP+ 4.0)

Offline Lepton

  • Lt. Commander
  • *
  • Posts: 1620
Re: BIG MySQL Test Saturday 8PM Central
« Reply #3 on: November 18, 2005, 07:32:40 pm »
What's the expectation for this test? Is this a server load test?  Are we trying to break it in some manner or are we just expected to log on and play?


System Specs:

Dell Dimension E521
AMD64x2 5000+
2G DDR2 RAM
ATI Radeon HD 4850 512MB GDDR3
250GB SATA HD

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test Saturday 8PM Central
« Reply #4 on: November 18, 2005, 07:52:54 pm »
Just login and play. Preferably we will get enough players on to possibly crash it so we can see the problems in the code.

Offline FPF-SCM_TraceyG_XC

  • Empress of the Empire
  • Commander
  • *
  • Posts: 2543
  • Gender: Female
Re: BIG MySQL Test Saturday 8PM Central
« Reply #5 on: November 18, 2005, 08:22:45 pm »
More than just a server load test, we WANT the serverkit to crash. By running the serverkit through the debugger, we can see each line of code being executed as it happens, or rather, when the kit crashes, the debugger will be showing us the last line of code that was being executed.

Instead of trying to find a needle in a haystack, this will tell us precisely what is causing the kit to crash, and therefore, how to fix it precisely. It may only take 10 minutes, for all we know. It is also quite possible, depending upon the nature of the bugs found, that we will fix, recompile and restart the test on the fly, attempting to locate as many bugs as we can, thus in this fashion, we can get quite a lot of work done and make huge leaps in finally getting the serverkit to work bug free!!  ;D
Captain FPF-TraceyG, Federation Protection Fleet


SFC2.net Admin member
SFC3.net Admin member
Voting member of the DGA
Member of XenoCorp, Squadron Commodore

Offline FA Frey XC

  • Site Owner
  • Administrator
  • Captain
  • *
  • Posts: 5695
  • Gender: Male
    • XenoCorp.Net
Re: BIG MySQL Test Saturday 8PM Central
« Reply #6 on: November 18, 2005, 08:49:28 pm »
Let's all roll out and help test this, it's more important than you could know.

This test could very well determine the future of the Dynaverse online campaigns.

 :o
Vice President of Technology,
Dynaverse Gaming Association
Owner, CEO XenoCorp Inc.


Offline FPF-SCM_TraceyG_XC

  • Empress of the Empire
  • Commander
  • *
  • Posts: 2543
  • Gender: Female
Re: BIG MySQL Test Saturday 8PM Central
« Reply #7 on: November 18, 2005, 09:10:10 pm »
Its also very important we get as many people as we can, so please acknowledge in this thread if you will be available. Actually, I'll start a new thread for that. Depending on numbers, since it is at short notice, we may need to run another debug test next Friday night.
Captain FPF-TraceyG, Federation Protection Fleet


SFC2.net Admin member
SFC3.net Admin member
Voting member of the DGA
Member of XenoCorp, Squadron Commodore

Offline Hexx

  • Sexy Shoeless Lyran God Of War
  • Captain
  • *
  • Posts: 6058
Re: BIG MySQL Test Saturday 8PM Central
« Reply #8 on: November 19, 2005, 09:51:52 am »
Oh, and if it doesn't mess anything up can we actually get
enough prestige to buy like hundreds of ships?
Seem to remember we had one of these before where you couldn't buy
much.

More prestige lets more people who fight me buy more ships so
they'll stop running away.
Courageously Protesting "Lyran Pelt Day"

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test Saturday 8PM Central
« Reply #9 on: November 19, 2005, 09:54:37 am »
Starting PP is set to 5000 and ships will be dirt cheap.

Offline RazalYllib

  • Imperial Romulan Information Service-senior advisor
  • Lt.
  • *
  • Posts: 784
  • Gender: Male
    • IRIS
Re: BIG MySQL Test Saturday 8PM Central
« Reply #10 on: November 19, 2005, 10:19:03 am »
Sounds like a reason to decloak from semi retirements...8 Pm central...I am there.
Comes a time when the blind man takes your hand
Says "don't you see?"
Gotta make it somehow
On the dreams you still believe
Don't give it up
You got an empty cup
Only love can fill
Only love can fill

Offline Dfly

  • Lt. Commander
  • *
  • Posts: 1735
  • Lyran Alliance Lives
Re: BIG MySQL Test Saturday 8PM Central
« Reply #11 on: November 19, 2005, 10:22:33 am »
So just to clarify, all we have to do is uninstal 4.0?  or you asking us all to redo all to get to 2.5.5.2 ?

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test Saturday 8PM Central
« Reply #12 on: November 19, 2005, 10:38:17 am »
All you should need to do is uninstall OP+4. It will restore stock 2.5.5.2 files. Hopefully your stock missions have not been overwritten or deleted. If they have, you can get the stock missions from the currently posted serverkit.


NOTICE: There may be a delay in the test start as I have to upload my own source code to the server as there is a problem with the code on the test server that I cannot find. It will take me about 8 hours to upload it over my connection but hopefully we can still start the test on schedule tonight.

762_XC

  • Guest
Re: BIG MySQL Test Saturday 8PM Central
« Reply #13 on: November 19, 2005, 02:31:02 pm »
I'll be there. I suggest everyone get on Dnet TS as well.

Offline IAF Lyrkiller

  • Semi retired, but I am still around
  • D.Net Beta Tester
  • Lt. Commander
  • *
  • Posts: 1321
  • Gender: Male
  • JAG & Tech Support
Re: BIG MySQL Test Saturday 8PM Central
« Reply #14 on: November 19, 2005, 04:40:32 pm »
<Waves both paws wildly>. ;D

I will be on tonight.




KAT-Lyrkiller
Semi-retired
Captain of the MSC Maus
MEMBER OF KLAW
SILENCE.....I keel you!!!

Offline Riskyllama

  • D.Net Beta Tester
  • Lt.
  • *
  • Posts: 748
  • Gender: Male
  • Risky
Re: BIG MySQL Test Saturday 8PM Central
« Reply #15 on: November 19, 2005, 04:45:37 pm »
i'll try to be there.

As a side note, has anyone thought of going to some of the other forum areas that might not look in here normally, like the modelers threads and such? I mean who knows if anyone else would show up, bt it's worth a try right?
Everything is sweetened by risk. ~Alexander Smith

Offline KBFLordKrueg

  • Commander
  • *
  • Posts: 3733
  • KBF CO
Re: BIG MySQL Test Saturday 8PM Central
« Reply #16 on: November 19, 2005, 05:37:03 pm »
More than just a server load test, we WANT the serverkit to crash. By running the serverkit through the debugger, we can see each line of code being executed as it happens, or rather, when the kit crashes, the debugger will be showing us the last line of code that was being executed.

Instead of trying to find a needle in a haystack, this will tell us precisely what is causing the kit to crash, and therefore, how to fix it precisely. It may only take 10 minutes, for all we know. It is also quite possible, depending upon the nature of the bugs found, that we will fix, recompile and restart the test on the fly, attempting to locate as many bugs as we can, thus in this fashion, we can get quite a lot of work done and make huge leaps in finally getting the serverkit to work bug free!!  ;D

So...what are we going to do to try and make it crash...?
Forfiets? Alting? piling in a hex?
Last time seems there was much confusion about exactly what the admins wanted us to try.  ;)
Lord Krueg
KBF CO
We are the Dead

Offline KBFLordKrueg

  • Commander
  • *
  • Posts: 3733
  • KBF CO
Re: BIG MySQL Test Saturday 8PM Central
« Reply #17 on: November 19, 2005, 05:40:58 pm »
All you should need to do is uninstall OP+4. It will restore stock 2.5.5.2 files. Hopefully your stock missions have not been overwritten or deleted. If they have, you can get the stock missions from the currently posted serverkit.


NOTICE: There may be a delay in the test start as I have to upload my own source code to the server as there is a problem with the code on the test server that I cannot find. It will take me about 8 hours to upload it over my connection but hopefully we can still start the test on schedule tonight.

Any updates on this...?
Still a couple hrs away from test time, but, just curious
Lord Krueg
KBF CO
We are the Dead

Offline FPF-Thrain

  • Lt. Junior Grade
  • *
  • Posts: 124
  • Gender: Male
Re: BIG MySQL Test Saturday 8PM Central
« Reply #18 on: November 19, 2005, 07:01:28 pm »
I'll be there as well. Seems like a good time to see if I have any skill with the game remaining. Will be happy to entertain my death as many times as you can kill me.

I won't run away, will you? :flame:


'Hail Gurthang! No lord or loyalty dost thou know, save the hand that wieldeth thee. From no blood wilt thou shrink. Wilt thou therefore take Túrin Turambar, wilt thou slay me swiftly?'
And from the blade rang a cold voice in answer: 'Yea, I will drink thy blood gladly, that so I may forget the blood of Beleg my master, and the blood of Brandir slain unjustly. I will slay thee swiftly.'

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test Saturday 8PM Central
« Reply #19 on: November 19, 2005, 08:15:57 pm »
9.3 hour upload just finished... I need to build it (about 20 minutes) then we should be ready... so about 30 minutes from now...

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test Saturday 8PM Central
« Reply #20 on: November 19, 2005, 08:34:03 pm »
Building now, I'll start it once on the flatfile to check things out, then stop it right away and then start it on MySQL and announce it as ready for testing.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test Saturday 8PM Central
« Reply #21 on: November 19, 2005, 09:08:40 pm »
Dammit, still having issues with building on thor - if I can't have it ready within the next hour we're postponing till tomorrow...

Offline FPF-SCM_TraceyG_XC

  • Empress of the Empire
  • Commander
  • *
  • Posts: 2543
  • Gender: Female
Re: BIG MySQL Test Saturday 8PM Central
« Reply #22 on: November 19, 2005, 09:41:29 pm »
More than just a server load test, we WANT the serverkit to crash. By running the serverkit through the debugger, we can see each line of code being executed as it happens, or rather, when the kit crashes, the debugger will be showing us the last line of code that was being executed.

Instead of trying to find a needle in a haystack, this will tell us precisely what is causing the kit to crash, and therefore, how to fix it precisely. It may only take 10 minutes, for all we know. It is also quite possible, depending upon the nature of the bugs found, that we will fix, recompile and restart the test on the fly, attempting to locate as many bugs as we can, thus in this fashion, we can get quite a lot of work done and make huge leaps in finally getting the serverkit to work bug free!!  ;D

So...what are we going to do to try and make it crash...?
Forfiets? Alting? piling in a hex?
Last time seems there was much confusion about exactly what the admins wanted us to try.  ;)

In this test, we'll be trying everything and anything to make it crash. Alting and forfeits are permitted. All that is asked, however, is that you record details of your actions, including things like hex number locations, missions taken, what ship(s) you are flying, connection issues, anything.
Captain FPF-TraceyG, Federation Protection Fleet


SFC2.net Admin member
SFC3.net Admin member
Voting member of the DGA
Member of XenoCorp, Squadron Commodore

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - POSTPONED
« Reply #23 on: November 19, 2005, 09:57:22 pm »
Test postponed.  :(

Aplogies, but trust me, I think I'm the most disappointed here. I've been busting my butt on this. It makes no sense. The debug build works fine on my machine but not on Thor...

Offline likkerpig

  • Commander
  • *
  • Posts: 2614
  • Gender: Male
Re: BIG MySQL Test - POSTPONED
« Reply #24 on: November 19, 2005, 11:48:20 pm »
Test postponed.  :(

Aplogies, but trust me, I think I'm the most disappointed here. I've been busting my butt on this. It makes no sense. The debug build works fine on my machine but not on Thor...

Hey, keep up the good work Bonk... us non-sql types will be around to help with what we can, when yer ready.
Chin up and know your work is appreciated!
 :thumbsup:
"Atheism is a religion like not collecting stamps is a hobby."



Offline KBFLordKrueg

  • Commander
  • *
  • Posts: 3733
  • KBF CO
Re: BIG MySQL Test - POSTPONED
« Reply #25 on: November 20, 2005, 10:59:54 am »
Test postponed.  :(

Aplogies, but trust me, I think I'm the most disappointed here. I've been busting my butt on this. It makes no sense. The debug build works fine on my machine but not on Thor...

Have you tried getting with Frey about that?
Lord Krueg
KBF CO
We are the Dead

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - POSTPONED
« Reply #26 on: November 20, 2005, 02:53:13 pm »
There is a progess/notes thread in a development area of the forum that Frey has been reading as well.

Magnumman has identified a probable cause, work is underway...

Offline Sanfeng

  • Lt. Junior Grade
  • *
  • Posts: 53
Re: BIG MySQL Test - POSTPONED
« Reply #27 on: November 20, 2005, 03:39:24 pm »
there was talk last night of possible postponedment until tonight... is that still the plan? or will it wait till next week? I can prolly be availible to help test whenever...

keep up the good work guys... Im sure youll get it figured.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - POSTPONED
« Reply #28 on: November 20, 2005, 04:00:51 pm »
Looks like it will be next week...

Offline Lepton

  • Lt. Commander
  • *
  • Posts: 1620
Re: BIG MySQL Test - POSTPONED
« Reply #29 on: November 20, 2005, 06:52:12 pm »
I know I am usually the last to suggest this, but next weekend is a long weekend here in the States. Thanksgiving and all that.  I am wondering if people think that will hurt test server attendance.  I know for once in my life I will actually be occupied that weekend.  Thurs, Fri, Sat, Sun, out of town.  Don't know if this applies to most people.  If not, test on weekend seems fine.  If not, may want to postpone again.


System Specs:

Dell Dimension E521
AMD64x2 5000+
2G DDR2 RAM
ATI Radeon HD 4850 512MB GDDR3
250GB SATA HD

Offline Capt Jeff

  • 1AF
  • Lt.
  • *
  • Posts: 736
  • Gender: Male
    • Facebook
Re: BIG MySQL Test - POSTPONED
« Reply #30 on: November 21, 2005, 05:47:49 am »
I've been pretty quiet on here as late due to my computer usually not lasting more then 10 minutes before it locks up.  Think it's the video card or processor.... when rebooting, I get a warning that my motherboard temp is too high...lol.

Computer is 6 years old anyway, and I just plopped out $2400 on a new machine that should be here tomorrow.  Once I get it set up, I will be glad to help however I can.

Keep up the good work Bonk !!   ;)
Capt Jeff

Former SFC2.NET Administrator
C.O., Heavy Command Cruiser
USS Crasher NCC 1733

1AF---Friendship, Honor, Fun.  It's what we Play For.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - POSTPONED
« Reply #31 on: November 21, 2005, 10:23:26 am »
Thanks for the tip, it just might take two weeks to get it running anyway...

What's the deal with Thanksgiving in November anyway? What's wrong with October? Is is just that being further south November represents the end of harvest instead of October? This has always confused me...

Offline Hexx

  • Sexy Shoeless Lyran God Of War
  • Captain
  • *
  • Posts: 6058
Re: BIG MySQL Test - POSTPONED
« Reply #32 on: November 21, 2005, 11:12:49 am »
Americans... what do you expect?
Courageously Protesting "Lyran Pelt Day"

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: BIG MySQL Test - POSTPONED
« Reply #33 on: November 21, 2005, 11:25:52 am »
In october its too close to halloween
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

el-Karnak

  • Guest
Re: BIG MySQL Test - POSTPONED
« Reply #34 on: November 21, 2005, 12:20:52 pm »
Thanks for the tip, it just might take two weeks to get it running anyway...

What's the deal with Thanksgiving in November anyway? What's wrong with October? Is is just that being further south November represents the end of harvest instead of October? This has always confused me...

Since most of Canada's weather resembles the US Mid-West or the North-Eastern states and is worse the futher north you go, it's better to have Thanksgiving when it's still fall outside. In US, it's still summer in October in most southern states so it's more expedient to wait until the end of November. In addition, it's much smarter to have the holiday on a Thursday cuz then you have a ready-made excuse not to go to work on the following Friday; ergo, the 4 day weekend. Also, Thanksgiving seems to be much more of a religious holiday in the US than it is in Canada, the whole country is practically shut down just like Canada is on Christmas. Malls and most retail businesses are closed. It was a shock to me when I first came to US because Canada's Thanksgiving day is more like a shopping mall day.

In addition, the day-after US Thanksgiving is the traditional kick-off feeding frenzyfor all the Shop Rex's in America who are sick of serving Thanksginving dinner and can't wait to draft the over-indulgent mall mules into shopping bag hauling duty at the crack of dawn Friday to work off their Turkey dinners. Cuz the Xmas shopping season has arrived.  ;D

Finally, Canada's Thanksgiving day is also Columbus Day in the US.  This means the US Gov't. employees want to take this day off even though most other non-Federal US workers do not. Plus, these federal workers get to take Thanksgiving Day off too. So, don't mess with those Federal gov't. worker holidays by making Thanksgiving overlap with Columbus Day, all in the name of increased gov't. worker productitivity. This would actually make US taxpayers think they would be getting good value for their money and the whole country would irretrievably spin into riots and chaos.  Whole gov't. agencies might disappear due to the consolidation of resources made possible by such increased Federal worker productivit:  the space shuttle would actually work, the US Immigration guys would actually understand what their job duties are, Homeland Security would actually get its priorities straight, FEMA would actually hire qualified managers to handle its workload, and/or the CIA would actually understand the the "I" in their acronym stands for "Intelligence" cuz they are the most heavily funded "intelligence" agency on the planet.  We are talking about boat-loads of  Washington beltway lobbyists that would lose work,  and all the lawsuits currently pending against Gov't. agencies simply asking them to do their jobs right would be rendered moot resulting in a catastrophic loss of business for the all US lawyers.

That simply is not acceptable. So, US Thanksgiving Day stays where it is.

*stomps foot*

Karnak the brain-washed American frog.

:P :P
« Last Edit: November 21, 2005, 12:35:53 pm by el-Karnak »

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - POSTPONED
« Reply #35 on: November 21, 2005, 12:27:29 pm »
Finally, Canada's Thanksgiving day is also Columbus Day in the US.  This means the US Gov't. employees want to take this day off even though most other non-Federal US workers do not. Plus, these federal workers get to take Thanksgiving Day off too. So, don't mess with those Federal gov't. worker holidays by making Thanksgiving overlap with Columbus Day, all in the name of increased gov't. worker productitivity.

Aha! We have a winner, that must be it. (Having worked for the feds up here...)

el-Karnak

  • Guest
Re: BIG MySQL Test - POSTPONED
« Reply #36 on: November 21, 2005, 12:42:11 pm »
Finally, Canada's Thanksgiving day is also Columbus Day in the US.  This means the US Gov't. employees want to take this day off even though most other non-Federal US workers do not. Plus, these federal workers get to take Thanksgiving Day off too. So, don't mess with those Federal gov't. worker holidays by making Thanksgiving overlap with Columbus Day, all in the name of increased gov't. worker productitivity.

Aha! We have a winner, that must be it. (Having worked for the feds up here...)

Aint that the truth. You have not met a truly dysfunctional gov't. agency on this planet until you've dealt with the US Immigration agency. I was not surprised one bit when FEMA fell on its collective a$$es over the New Orleans tragedy cuz this agency was made part of Homeland Security. The same dept. built out of the dysfunctinal INS of the 1990s. Too bad, it took Hurricane Katrina to wake everybody in the US up about how badly the US agencies are being run and finally make it show up in the Presidential approval ratings. You could call it Pearl Harbor day for the US Gov't. agencies. Now, that we got the White House and Congress collective attention, they are starting to fire people and clean up the mess.   Unlike Canada that has record surpluses, the US is being forced to cut it Federal budget cuz the deficit is getting too much out of hand. NASA is even being told to shape up or have its budget cut. Space Shuttle program is the first one on the axe block. You even hear of "know-it-all" NASA managers admit that they may have gone too far with the Space Shuttle program, and we're not really getting our money's worth out of it.

It will take a long time, if ever, though to get the US Gov't. agencies where they should be. At least, they got a  no-nonsense  former US Federal prosecutor running Homeland Security dept. and starting to make his presence felt in the ranks. Cherztoff is trying to clean it up big-time after the New Orleans fiasco.

Like "Bones" McCoy said in Star Trek 4:

"Bureaucracy is the great universal constant."
« Last Edit: November 21, 2005, 01:16:57 pm by el-Karnak »

Offline RazalYllib

  • Imperial Romulan Information Service-senior advisor
  • Lt.
  • *
  • Posts: 784
  • Gender: Male
    • IRIS
Re: BIG MySQL Test - POSTPONED
« Reply #37 on: November 21, 2005, 06:51:15 pm »
Back on topic...

I was there, saturday nite fired up ready to go and no where interesting to expend time on....I did fire up a quickie single player camp- just for old times sakes, and was rather startled how much I remember and did without even thinking about it. It was mere childs play to ballet w/ my snipe-b a fed ff+ and capture it with out taking a single internal. Does this mean I have learned it? I needed the break from routine anyway.  CoH/CoV taking up the lions share of the precious free moments due to RL issues originating with spouses health issues (with a little Black and White 2 thrown in for good measure). I look forward to the next test with warm plasma glowie feelie thingie inside. I have absolute and utter faith that things will progress and Bonk, take another bow. We would have not gotten this far at all without your talents and efforts. The test should reveal the "show stoppers"  and that data is gold.  That player generated data in some fashion will contribute to a fully functional sql kit and then the fun really begins.....all without the client source code in hand.
Comes a time when the blind man takes your hand
Says "don't you see?"
Gotta make it somehow
On the dreams you still believe
Don't give it up
You got an empty cup
Only love can fill
Only love can fill

Offline Dfly

  • Lt. Commander
  • *
  • Posts: 1735
  • Lyran Alliance Lives
Re: BIG MySQL Test - POSTPONED
« Reply #38 on: November 21, 2005, 06:53:41 pm »




In addition, the day-after US Thanksgiving is the traditional kick-off feeding frenzyfor all the Shop Rex's in America who are sick of serving Thanksginving dinner and can't wait to draft the over-indulgent mall mules into shopping bag hauling duty at the crack of dawn Friday to work off their Turkey dinners. Cuz the Xmas shopping season has arrived.  ;D



Don't tell Jinn about this, but make sure SR realizes it. Wait a minute,  I bet SR actually started that trend.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - POSTPONED
« Reply #39 on: November 22, 2005, 01:06:00 am »
I finally got the debug serverkit running on Thor.  :woot:

I'll leave it up for the week to see if I catch a crash or learn anything interesting. I'll confer with the rest of the development group on a few settings and such and we can aim for a load test this weekend. If not enough players are around because of the holiday then we'll just try it again the following week!

Offline Flywh33l

  • Lt. Junior Grade
  • *
  • Posts: 28
Re: BIG MySQL Test - POSTPONED
« Reply #40 on: November 22, 2005, 02:33:19 am »
ill be there.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #41 on: November 22, 2005, 09:59:05 am »
I've tentatively scheduled the first load test for this Friday Nov. 25th 8PM Central.

Offline RazalYllib

  • Imperial Romulan Information Service-senior advisor
  • Lt.
  • *
  • Posts: 784
  • Gender: Male
    • IRIS
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #42 on: November 22, 2005, 06:08:51 pm »
JOY..RAPTURE...BLISS
Comes a time when the blind man takes your hand
Says "don't you see?"
Gotta make it somehow
On the dreams you still believe
Don't give it up
You got an empty cup
Only love can fill
Only love can fill

Offline FA Frey XC

  • Site Owner
  • Administrator
  • Captain
  • *
  • Posts: 5695
  • Gender: Male
    • XenoCorp.Net
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #43 on: November 22, 2005, 07:18:00 pm »
 :drink:
Vice President of Technology,
Dynaverse Gaming Association
Owner, CEO XenoCorp Inc.


Offline drb

  • Lt. Junior Grade
  • *
  • Posts: 331
  • Gender: Male
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #44 on: November 23, 2005, 12:57:40 am »
Hoi Folks,

 Just got back online in my new place in Dartmouth, NS. With the exception of work and domestic stuff I should be ready for Friday, more like 3am Sat., but I have Sat. and Sun. off.

Great work!

Take care

drb

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #45 on: November 23, 2005, 08:59:02 am »
drb!!  :)  Cool man, glad to hear you're getting settled in. Look forward to wingin with ya.

Offline SurveyCrew

  • Lt. Junior Grade
  • *
  • Posts: 70
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #46 on: November 24, 2005, 07:48:32 am »
Ill try to be there

Offline KBF-Crim

  • 1st Deacon ,Church of Taldren
  • Global Moderator
  • Commodore
  • *
  • Posts: 12271
  • Gender: Male
  • Crim,son of Rus'l
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #47 on: November 25, 2005, 04:58:32 pm »
We still up for this?


Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #48 on: November 25, 2005, 05:08:40 pm »
It will be up and I will be there.

6 PM Pacific / 7 PM Mountain / 8 PM Central / 9 PM Eastern / 10 PM Atlantic

Offline KBF-Crim

  • 1st Deacon ,Church of Taldren
  • Global Moderator
  • Commodore
  • *
  • Posts: 12271
  • Gender: Male
  • Crim,son of Rus'l
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #49 on: November 25, 2005, 05:10:25 pm »
Ok....disregard my PM then...*snicker* ;)

Offline FPF-DieHard

  • DDO Junkie
  • Captain
  • *
  • Posts: 9461
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #50 on: November 25, 2005, 07:03:56 pm »
Stock or OP+ 4?
Who'd thunk that Star-castling was the root of all evil . . .


Offline Midnight Tech

  • Hot and Spicy
  • Lt. Junior Grade
  • *
  • Posts: 131
  • Gender: Male
    • Tech Support Forum..."We are offering free computer support for everyone"
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #51 on: November 25, 2005, 07:06:24 pm »
Stock w/2552 patch from what I've heard.
For computer problems, check out Tech Support Forum!

Offline KBF-Crim

  • 1st Deacon ,Church of Taldren
  • Global Moderator
  • Commodore
  • *
  • Posts: 12271
  • Gender: Male
  • Crim,son of Rus'l
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #52 on: November 25, 2005, 07:16:51 pm »
Stock 2.5.5.2

Offline Farfarer

  • Lt. Junior Grade
  • *
  • Posts: 227
  • Gender: Male
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #53 on: November 25, 2005, 07:22:23 pm »
I keep getting shiplist and fighterlist error after U/I 4.0.  Working on it.

Offline FPF-Thrain

  • Lt. Junior Grade
  • *
  • Posts: 124
  • Gender: Male
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #54 on: November 25, 2005, 07:44:31 pm »
Unless you have a server specific list installed, all you need to do is uninstall OP+ 4.0.


'Hail Gurthang! No lord or loyalty dost thou know, save the hand that wieldeth thee. From no blood wilt thou shrink. Wilt thou therefore take Túrin Turambar, wilt thou slay me swiftly?'
And from the blade rang a cold voice in answer: 'Yea, I will drink thy blood gladly, that so I may forget the blood of Beleg my master, and the blood of Brandir slain unjustly. I will slay thee swiftly.'

Offline KBF-Crim

  • 1st Deacon ,Church of Taldren
  • Global Moderator
  • Commodore
  • *
  • Posts: 12271
  • Gender: Male
  • Crim,son of Rus'l
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #55 on: November 25, 2005, 07:44:45 pm »
I got on just fine with the uninstall...

did you maybe have a different ship list when you installed OP?....IIRC...it just saves the one you have ...doesnt matter what list it is...


Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #56 on: November 25, 2005, 07:44:56 pm »
If anyone is missing stock lists or missions they can be obtained in the curently posted serverkit:
http://www.dynaverse.net/downloads/sfc2_op/server_kits/SFCOPServer2552_B36.zip

Offline FA Frey XC

  • Site Owner
  • Administrator
  • Captain
  • *
  • Posts: 5695
  • Gender: Male
    • XenoCorp.Net
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #57 on: November 25, 2005, 08:00:10 pm »
So those of us that are here, are here.

What do we do?

Is there anything specific we need to test?

Like jump in one hex and all run a bunch of missions?

Vice President of Technology,
Dynaverse Gaming Association
Owner, CEO XenoCorp Inc.


el-Karnak

  • Guest
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #58 on: November 25, 2005, 10:50:38 pm »
Hoi Folks,

 Just got back online in my new place in Dartmouth, NS. With the exception of work and domestic stuff I should be ready for Friday, more like 3am Sat., but I have Sat. and Sun. off.

Great work!

Take care

drb

drb is back. ;D

:woot: :woot:

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #59 on: November 26, 2005, 01:53:30 am »
Well, we got about 20 players on for about 2 hours and the debug server did not crash, but as it turns out, after I took a look at the server we did find an error that was caught by the debugger that would probably crash a release build.

So this is progress! I won't schedule another load test until I've had a chance to go over the results with the rest of the development group. Once we have modified the code it will be back to the testing grind!

A big hearty thank you to all who turned out to help! This is good!  ;D

Offline TraumaTech

  • DON'T PISS OFF THE KITTY
  • Hot and Spicy
  • Lt.
  • *
  • Posts: 619
  • Gender: Male
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #60 on: November 26, 2005, 07:38:39 am »
Hoi Folks,

 Just got back online in my new place in Dartmouth, NS. With the exception of work and domestic stuff I should be ready for Friday, more like 3am Sat., but I have Sat. and Sun. off.

Great work!

Take care

drb


heya Drb,Mutt is only minutes away from you,in eastern passage  :)  he is presently out to sea,but he should be arriving back this coming week some time.as for myself,i am 45 minutes away from dartmouth in upper rawdon,but temporarily(i hope) living across the bridge from you in clayton park.we should hook up sometime,when Mutt gets back

Offline CaptJosh

  • Lt.
  • *
  • Posts: 775
  • Gender: Male
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #61 on: November 27, 2005, 07:08:42 am »
Well, we got about 20 players on for about 2 hours and the debug server did not crash, but as it turns out, after I took a look at the server we did find an error that was caught by the debugger that would probably crash a release build.

So this is progress! I won't schedule another load test until I've had a chance to go over the results with the rest of the development group. Once we have modified the code it will be back to the testing grind!

A big hearty thank you to all who turned out to help! This is good!  ;D

Good for you, man. At least it's not like  I crash I could reproduce unless I was running a build hooked into a remote debug session on a game I'm a beta tester for. Hopefully if you can get the serverkit debugged fully the last holdout on giving us the client-side source will finally realize that it's worthwhile to let this community have at it.
CaptJosh

There are only 10 kinds of people in the world;
those who understand binary and those who don't.

Offline Midnight Tech

  • Hot and Spicy
  • Lt. Junior Grade
  • *
  • Posts: 131
  • Gender: Male
    • Tech Support Forum..."We are offering free computer support for everyone"
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #62 on: November 27, 2005, 01:10:41 pm »
Another error perhaps? I had a "investigate the cargo container" mission not end properly in the SQL test.
For computer problems, check out Tech Support Forum!

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #63 on: November 27, 2005, 01:27:54 pm »
I got an assert failure in the asynchronous data handler code in the switch project about a dozen times, I'm not really interested in mission errors at this point (most of them probably resulted from people maxing out the cpu by forfeiting missions) These forfeits may also have been the cause of the error in the switch code but its hard to say for sure. We know forfeits are a problem and murder on the server cpu use. I am looking for a way to disable the option to forfeit so that the problem is forever eliminated. Thanks for the report though!

Offline drb

  • Lt. Junior Grade
  • *
  • Posts: 331
  • Gender: Male
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #64 on: November 27, 2005, 03:09:42 pm »
Hoi TraumaTech,

 
Quote
heya Drb,Mutt is only minutes away from you,in eastern passage    he is presently out to sea,but he should be arriving back this coming week some time.as for myself,i am 45 minutes away from dartmouth in upper rawdon,but temporarily(i hope) living across the bridge from you in clayton park.we should hook up sometime,when Mutt gets back

 Sounds good. I work late, shifts end at about 3am each morning, with every other weekend off.  I have a buddy who heads out to Shearwater every so often, he might be willing to give me a lift a little further down the road. We have many options if you move to Claton Park. When I lived on the Bedford Hwy. I played pool at Dooley's in Claton Park, always enjoyed that pool hall.

I'll send a pm as soon as I look at my schedule.

Hey! Hexx, are you still in the area?

Take care

drb

Offline TraumaTech

  • DON'T PISS OFF THE KITTY
  • Hot and Spicy
  • Lt.
  • *
  • Posts: 619
  • Gender: Male
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #65 on: November 27, 2005, 06:12:27 pm »
Hoi TraumaTech,


 Sounds good. I work late, shifts end at about 3am each morning, with every other weekend off.  I have a buddy who heads out to Shearwater every so often, he might be willing to give me a lift a little further down the road. We have many options if you move to Claton Park. When I lived on the Bedford Hwy. I played pool at Dooley's in Claton Park, always enjoyed that pool hall.

I'll send a pm as soon as I look at my schedule.

Hey! Hexx, are you still in the area?

Take care

drb



     excellent........ Mutt and i hit Dooley's every now and then as well         

Offline GDA-Kel

  • Lt. Junior Grade
  • *
  • Posts: 188
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #66 on: November 30, 2005, 09:33:15 am »
Hey SQL Dev Team!

Just wanted to say 'congrats' on the progress you have made so far and to wish you continued success in further testing. 

Another thread got me thinking about the SQL kit again and I wondered if you had the complete kit up and running for your test.  I recall that I disabled several of the 'pieces' of the kit when I was running my EAW servers.  I beleive I disabled the news server, the shipyard server, and the econ server. 

From all your research into the workings of the code, do you have a pretty good idea of what info is passed between the server and the players?  For example, what ports are used to pass what info, and the format of that passed info?  Just curious....

Again...Great job!!!

 
GDA-Kel
Gorn Dragon Alliance

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #67 on: November 30, 2005, 10:17:09 am »
Thanks Kel! Tracey and I are going over the results now...

I am running all servers on The Forge, only turning down the news frequency and probablility. Its pretty stable but does not see high load reallly.

What info is passed between the server and players? Lots from what I can tell , lol.  All info is passed over the direcplay 7 ports (47624 tcp and 2300-2400 tcp&udp) at least I think so... (but the kit will build without directx)  and port 7 for tcp and udp pings (do not forward) we're just getting into the switch code now, at it popped up in this test as a probable issue. Some of the info passed follows  an abortion of the Gamespy SDK (check luigi auriemma's site for some details). Gamespy refuses to acknowledge us and will not provide an updated SDK.  :(  Some of the info follows the obsolete WON SDK which is included in the kit source but is a bit arcane to figure out without the documentation. I guess I can't really answer your question properly now, but hopefully soon!

Offline worfhonour

  • D.Net VIP
  • Lt. Junior Grade
  • *
  • Posts: 176
  • Gender: Male
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #68 on: December 29, 2005, 05:37:09 am »
Hi,
Sorry I missed the Test >:(

Let me know when your testing again i'll be there.

WorfHonour ;D

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #69 on: December 29, 2005, 09:16:47 am »
Roger. THe next test will probably be just a little after KCW finishes. (around the end of January)

762_XC

  • Guest
Re: BIG MySQL Test - Run#1 Friday Nov. 25th 8PM Central
« Reply #70 on: December 29, 2005, 12:34:59 pm »
w00t