Topic: 'SG5 Server Status, up or down...

[PGC Graakna]

12:10 EDT, tried to login to the SGOV server and it asked me to generate a new account. Has the DB been reset/whiped?

[Bonk]

12:10 EDT, tried to login to the SGOV server and it asked me to generate a new account. Has the DB been reset/whiped?

Read the above posts in this thread. (Yes, we are testing for database corruption vs network issues.) And don't worry... the db has been saved before the testing reset (though it may be corrupted).

[762_XC]

K'Tool was created several days before all this started. Maybe the third day of the server or thereabouts.

The drafting problems only started last night. Previous to that it was just network/burp issues.

[Bonk]

What we also noticed, at least a few of us was a hex number called
-1,-1 with horribly disfigured values for defense and such that a few
got when logging in. Dont know if thats related, but once logged in
that hex was no where to be found. And only several saw it, including
me.

Got this report... where exactly was this -1,-1 hex seen? On the map, in the news?

(IIRC the server sets a players location to -1,-1 when they are moving... lost packets during a player movement may result in this being observed inthe client...?)

Actually I have seen this before on slow map loads on other servers... I think  know what you mean.. only one hex is showing and it is -1,-1? I think this is how the client responds when the conection is interrupted on map initialisation...

[Bonk]

K'Tool was created several days before all this started. Maybe the third day of the server or thereabouts.

The drafting problems only started last night. Previous to that it was just network/burp issues.

Thanks for the info... The server was not burping, only suffering network interruptions, perhaps the db has been corrupted by these interruptions, resulting in the drafting problems...while the network interruptions continue..

[el-Karnak]

*Reads Thread*  

I'll check back in another couple of days to see if y'all have the dyna server stabilized.

[Bonk]

*Reads Thread* 

I'll check back in another couple of days to see if y'all have the dyna server stabilized.

Sigh... wish I could say that...   

[Capt_Bearslayer_XC]

I've noticed that AI seem to be on and moving, could that be an issue?

Also, is it not correct that some bases are destroyable and others are not?

If so could that be an issue also, IIRC, we were not able to do that before.

[Dizzy]

We just removed base station assault scripts, bear.

Bonk, if XC TS is using considerable system resources, why are we running it?

[Bonk]

I've noticed that AI seem to be on and moving, could that be an issue?

Also, is it not correct that some bases are destroyable and others are not?

If so could that be an issue also, IIRC, we were not able to do that before.

The server AI are a good thing no matter what others will tell you. They do not accumulate. (the server is creating one and destroying 10 per turn carrying 100, they cannot take affect DV.) Only AI from bugged missions will accumulate. (so turn off your firewalls)

Yes some bases are destroyable, others are not. (only because there are no Base tation assault missions though - simple idea, but a good one...). THis should not cause any problems, as it it has been the case since the server start.

[Bonk]

We just removed base station assault scripts, bear.

Bonk, if XC TS is using considerable system resources, why are we running it?

I cannot say for sure its use exceeds the network's capacity, I am just suspicious of it. Frey has a bandwidth limiter in place for xenocorp servers hoated at BearTech, but I'm not sure how it works and if it would result in lost packets or not.

[Hexx]

Sooo can't we fire it up again and ban the coalition from using TS?

[Bonk]

Lets see what happens tonight after 10:30 pm EST to see if it is network or db issues at this point. (still on the starting db)

And, we can't do that, but we can ask them to useanother channel on the SSCF teamspeak server tomorrow if we still see problems toinight.

[FPF-SCM_TraceyG_XC]

Good thinking DieHard, that's worth a try.

I just found a "Database Clean in progress.scr" in the root server folder, not sure if this will confuse the server...(very well might) I zipped it into the db backup folder.

That file is used for database cleaning. It is placed into the ValidatedClientsFile directory while the server is being run to clear the shipyard to prevent people from logging in. They will receive a CRC error message that says "Database Clean in Progress.scr" is missing. After the shipyard has been cleared, then this file is removed from that directory.

Did we ever find out if the database cleaner was removing ships up for bid still? If it doesn't, then we no longer need to clear the shipyard.

[Bonk]

Good thinking DieHard, that's worth a try.

I just found a "Database Clean in progress.scr" in the root server folder, not sure if this will confuse the server...(very well might) I zipped it into the db backup folder.

That file is used for database cleaning. It is placed into the ValidatedClientsFile directory while the server is being run to clear the shipyard to prevent people from logging in. They will receive a CRC error message that says "Database Clean in Progress.scr" is missing. After the shipyard has been cleared, then this file is removed from that directory.

Did we ever find out if the database cleaner was removing ships up for bid still? If it doesn't, then we no longer need to clear the shipyard.

I figured that was what it was for (I have one called "server_maintnenance.scr"), but I zipped and moved it anyway to be prudent, considering the way the server traverses the server folder for gf files, it would not be inconsistent for it to look for .scr files the same way...

Have not tested the shipyard on db cleans yet... just testing for db corruption vs network issues at the moment... but we do need to test that at some point.  (use at least 2 second turns on thor on my gfs to run up the clock or clear the yards, as the server is trying to delete 10 AI per second per turn change so turns need to be >1 second)

[el-Karnak]

*Reads Thread* 

I'll check back in another couple of days to see if y'all have the dyna server stabilized.

Sigh... wish I could say that...   

Mesa very happy not to be Admin.  I get enough of that stress at work, thank you very much.  Even when I delegate the job, it's not very fun.

No me gusta dyna Admin job.

I give +karma to you for trying to fix it. 

[Dizzy]

Bonk, lets make available to DH the entire current server settings and DB and all that. He will host it on his machine tonight. We will start the DB where we last left off when it was having problems. If its truly network issues then drafting and all that weirdness will be gone. If it is a DB problem, it will be apparent right off. Then we can decide how to fix it. Whether you can debug the DB, or how far we go back to a backup thats not corrupted or if we ditch the whoile thing, we can figure out after this test.

[762_XC]

Bonk, lets make available to DH the entire current server settings and DB and all that. He will host it on his machine tonight. We will start the DB where we last left off when it was having problems. If its truly network issues then drafting and all that weirdness will be gone. If it is a DB problem, it will be apparent right off. Then we can decide how to fix it. Whether you can debug the DB, or how far we go back to a backup thats not corrupted or if we ditch the whoile thing, we can figure out after this test.

 

[KBFLordKrueg]

And...so when are we getting back to the map as it was last night?
Like as in Time...? I assume it's tonight...?

[Capt_Bearslayer_XC]

From an MSN converstation I had with Frey a bit ago...

Bearslayer says:
have you been able to help Bonk tract down any of the server issues we have been having?
FA_Frey_XC says:
It's nothing to do with the server
FA_Frey_XC says:
It's been our connection
FA_Frey_XC says:
I keep telling people that
Bearslayer says:
'our' connection?
FA_Frey_XC says:
Work connection
FA_Frey_XC says:
Up here at the office
Bearslayer says:
ah, ok... so basicly, your work is having connectivity issues and when a bunch of d2ers get on it amplifies the problem
FA_Frey_XC says:
No
FA_Frey_XC says:
It doesn't matter who gets on
FA_Frey_XC says:
It had absolutely nothing to do with anyone connecting
FA_Frey_XC says:
It was a BGP routing issue that resulted from MCI's "flapping"
FA_Frey_XC says:
Which was causing routing tables to be re-written
FA_Frey_XC says:
thus, some could connect
FA_Frey_XC says:
while others couldn't
FA_Frey_XC says:
then they could
Bearslayer says:
ah... ok.  Have you posted to that effect on the thread they got going?
FA_Frey_XC says:
but mission matching wouldn't work because once the serverkit matches peeps inna mission
FA_Frey_XC says:
No, I haven't had time
FA_Frey_XC says:
I'll try to tonight
FA_Frey_XC says:
But my home connect has been flakey for the last day and a half 2
FA_Frey_XC says:
When it rains, it pours eh ?
Bearslayer says:
Can I cut and paste what you just told me?
FA_Frey_XC says:
Sure, no one will understand it anywho
FA_Frey_XC says:
I'll make a post there in about an hour
Bearslayer says:
Well, it might help....
FA_Frey_XC says:
Help what ?
Bearslayer says:
b/c they will have a sense of what is going on and stop pulling their hair out over something they have no control over
FA_Frey_XC says:
Who's pulling their hair out ?
Bearslayer says:
Bonk and Dizzy
FA_Frey_XC says:
If anyone had half a clue, then they'd know it's got nothing to do with the serverkit
FA_Frey_XC says:
The serverkit isn't crashing
FA_Frey_XC says:
has it been crashing ?
Bearslayer says:
Well, that is the primary suspect right now
FA_Frey_XC says:
Because if so then that's a different issue
Bearslayer says:
That and using D.net TS at the same time as the server
FA_Frey_XC says:
??
FA_Frey_XC says:
Those are on two seperate servers
FA_Frey_XC says:
LOL
Bearslayer says:
There is a 'test' server up right now to see what is going on
FA_Frey_XC says:
Did someone actually think that could cause a problem ?
Bearslayer says:

FA_Frey_XC says:
"Test" what, did they move it off THOR ?
Bearslayer says:
IE You really need to chime in...