Topic: SGO6 status (Read 35417 times)

Bonk · « **Reply #140 on:** August 12, 2006, 10:50:52 pm »

The extra copies of the kit were started after I grabbed that database so that is not the reason the editor had issues, the server did crash for the first time since it started just before this copy of the db however, which may be realted. I'll PM you a link to the troublesome db momentarily Dave.

Database from 9:10 PM Central restored, server rebooted.

Only about an hour is lost in the difference. I'll be sure to check for Dizzy on TS before I edit and reboot the server in future, apologies for any inconvenience.

The question is why did the terminal server allow multiple sessions on the same login?... oh wait I think I know why, I'll have to check with Frey to see if we can prevent that from happening should we get our wires crossed again. Tough one though, tricky call as to wther to allow dupliacte sessions or not. hmmm....

Bonk · « **Reply #141 on:** August 12, 2006, 10:55:28 pm »

Quote from: dizzy on August 12, 2006, 10:48:09 pm

Well, at least we got to the end of the VC Round w/o a major issue. Small 15 min outtage but we are ok otherwise... Let's see what happens.

We lost an hour and 20 minutes. Had I just stopped the multiple copies immediately and restored the good database, we would have only lost 15 minutes. Oh well, I know to check TS make sure you're not starting a copy of the server when I am working on it now.

Dizzy · « **Reply #142 on:** August 12, 2006, 11:49:59 pm »

No biggy... As long as we notify everyone on TS one of us is on top of the issue I dont see the stars getting crossed.

At least we didnt have a snafu happen trying to reach the end of round one... We actually made it there with only a small server outtage for 15 mins. Overall Im happy.

NuclearWessels · « **Reply #143 on:** August 13, 2006, 11:31:24 am »

Quote from: Bonk on August 12, 2006, 10:35:30 pm

Quote from: NuclearWessels on August 12, 2006, 10:19:32 pm
Quote from: Bonk on August 12, 2006, 09:22:24 pm
Great timing eh?

Server burped, clean with Dave's editor failed, cleaned with DE's editor successfully, restored combined chat channels, rebooted server. (if you dont get general chat on login just logout, wait a few minutes and login again - you logged in to soon after the server started...)

Dave, I will pack up the db that failed to clean and PM you a link tomorrow. (lucky you! )

$#%&^!!!

Thanks Bonk!
dave

I have yet to determine if it was corrupted by running multiple copies of the kit on one database... you may not be able to account for that.

Well, that was embarassing. Apparently (a) I can't count, and (b) I forgot to rerun the test with prepared mission in the list

Fixed now, and reposted

dave

Bonk · « **Reply #144 on:** August 13, 2006, 12:33:34 pm »

Very interesting.... I meant to mention in the Dev forum that I think we should have the server clear the prepared mission list on startup to deal with when crashes occur... I suspect it confuses the kit on SQL even more so.

Again, thanks bunches Dave!

I think this is what may have been an issue preventing the editor from working for some time now, as Scipio always found it stopped working after the first few days of a server (probably after the first crash with prepared missions in the db that never get cleared...).

I will test it out on the next maintenance cycle and let you know the result. (probably tomorrow morning, though possibly sooner)

NuclearWessels · « **Reply #145 on:** August 13, 2006, 01:46:44 pm »

Quote from: Bonk on August 13, 2006, 12:33:34 pm

Very interesting.... I meant to mention in the Dev forum that I think we should have the server clear the prepared mission list on startup to deal with when crashes occur... I suspect it confuses the kit on SQL even more so.

Again, thanks bunches Dave! I think this is what may have been an issue preventing the editor from working for some time now, as Scipio always found it stopped working after the first few days of a server (probably after the first crash with prepared missions in the db that never get cleared...).

I will test it out on the next maintenance cycle and let you know the result. (probably tomorrow morning, though possibly sooner)

If you'd like, I can set the DB clean option to clean out the prepared mission lists at the same time as the rest (just a one line code change)

dave

Bonk · « **Reply #146 on:** August 13, 2006, 01:52:40 pm »

Quote from: NuclearWessels on August 13, 2006, 01:46:44 pm

Quote from: Bonk on August 13, 2006, 12:33:34 pm
Very interesting.... I meant to mention in the Dev forum that I think we should have the server clear the prepared mission list on startup to deal with when crashes occur... I suspect it confuses the kit on SQL even more so.

Again, thanks bunches Dave! I think this is what may have been an issue preventing the editor from working for some time now, as Scipio always found it stopped working after the first few days of a server (probably after the first crash with prepared missions in the db that never get cleared...).

I will test it out on the next maintenance cycle and let you know the result. (probably tomorrow morning, though possibly sooner)

If you'd like, I can set the DB clean option to clean out the prepared mission lists at the same time as the rest (just a one line code change)

dave

Makes sense to me, but there is a PreparedMissionsID for each character in the character table as well, these should probably also be cleared for the corresponding entries that exist in the prepared missions list (or just set all characters to no preapredmissionsID since the list would be being emptied anyway) which may or may not be a pain to do... $:-\$

NuclearWessels · « **Reply #147 on:** August 13, 2006, 02:02:59 pm »

Ah bugger, that's right. NM, that will have to wait for another day

dave

762_XC · « **Reply #148 on:** August 13, 2006, 09:41:55 pm »

Lots of burping tonight.

Dizzy · « **Reply #149 on:** August 13, 2006, 09:46:23 pm »

More details.... player numbers during the burp? Forfeits in the news? Were the forums slow? Frequency? etc...

Bonk · « **Reply #150 on:** August 13, 2006, 10:39:20 pm »

I will take a look in a few minutes.

EDIT: report is that it burped twice a couple hours ago and has since stabilised. Probably just clogged "tubes"...

I'll do the db clean in the morning as planned and leave it be for tonight.

TraumaTech · « **Reply #151 on:** August 13, 2006, 11:45:59 pm »

Quote from: Bonk on August 13, 2006, 10:39:20 pm

I will take a look in a few minutes.

EDIT: report is that it burped twice a couple hours ago and has since stabilised. Probably just clogged "tubes"...

I'll do the db clean in the morning as planned and leave it be for tonight.

when in the morning???? and how long will it take?????

Bonk · « **Reply #152 on:** August 13, 2006, 11:49:39 pm »

When I get up, and about 15 minutes. Do not worry, I'll announce it on general chat in advance and wait for folks to get out of mission, as usual.

762_XC · « **Reply #153 on:** August 14, 2006, 12:58:33 am »

Do it as soon as TT logs on, then call me and tell me what hex he was in.

Dizzy · « **Reply #154 on:** August 14, 2006, 01:52:59 am »

TraumaTech · « **Reply #155 on:** August 14, 2006, 02:16:11 am »

Quote from: 762_XC on August 14, 2006, 12:58:33 am

Do it as soon as TT logs on, then call me and tell me what hex he was in.

just be there when i get on(approx. 0630 A.M. ATLANTIC) i'll tell ya what hex i am in

762_XC · « **Reply #156 on:** August 14, 2006, 10:03:36 am »

6:30??

OMG. I'll look for u later.

Dizzy · « **Reply #157 on:** August 14, 2006, 10:16:04 am »

Don't worry tool, Me and Dax got em... in more ways than one.

Bonk · « **Reply #158 on:** August 14, 2006, 10:49:13 am »

Database edited (awarded PP bonus to two reserve wild geese characters) and cleaned successfully with Dave's latest editor.

The server is back up.

Bonk · « **Reply #159 on:** August 15, 2006, 09:56:58 am »

Taking the server down for a db clean and edits in a few minutes. It should take about 15 minutes.

News:

Topic: SGO6 status (Read 35417 times) var addthis_config = {"data_track_clickback":true};

762_XC

762_XC

762_XC

Topic: SGO6 status (Read 35417 times)