Database Crash

CA3LE

testmy.net Patriarch
Administrator
TMN Sr. Veteran

Offline

Gender: Male

Posts: 4646

yep... ima g33k

Database Crash

« on: December 05, 2006, 01:32:33 PM »

Last night during maintenance we had a database crash. It was a really bad crash and unfortunately I was forced to resorting to backups.

Although the backup was recent (just two days ago) for some reason only 1.6 million entries were backed up. So we have lost 10-19-2006 to present. I'm very sorry and I can assure you I've tried everything in my power to resolve the issue but the data is simply lost. The crash mixed with a bad backup has left me with my hands tied behind my back. The forum database is backed up with great frequency but the scores database is only backed up once a month or so.

This problem will lead me to working on redundant database servers to make sure something like this never happens in the future.

Score logging should kick back on shortly after a reboot of server2.

again... very sorry to those of you that were tracking connections.


	Logged

TimPawlak

Sophist Member
Expert

Offline

Gender: Male

Posts: 1436

InsightBB 15/1.5 --- Telia 50/50

Re: Database Crash

« Reply #1 on: December 05, 2006, 01:38:36 PM »

ah, its ok ca3le its not the biggest problem in the world..


	Logged

AMD Athlon 64 X2 3800+ @ 2.13 GHz
4 GB PC 3200 DDR2 Ram
External and Internal DVD Writer (EXTERNAL BLUE RAY)
NVIDIA Geforce 8600 GT XXX 256 mb GDDR3
3dmark05 score- 9983
3dmark03 score- 16985

CA3LE

testmy.net Patriarch
Administrator
TMN Sr. Veteran

Offline

Gender: Male

Posts: 4646

yep... ima g33k

Re: Database Crash

« Reply #2 on: December 05, 2006, 02:22:02 PM »

yeah, I think most people won't mind too much.

... many people will have to re-do their sigs.

It will still be some time before the database comes back online, I have a batch running. I will update the thread when everything is back to normal.


	Logged

Sparticus

News Anchor
Expert

Offline

Gender: Male

Posts: 1551

Cox 12mb/1mb

Re: Database Crash

« Reply #3 on: December 05, 2006, 03:53:49 PM »

S#!t happens. :haha:


	Logged

mikedallos

Sr. Member

Offline

Gender: Male

Posts: 116

What's happenin'!

Re: Database Crash

« Reply #4 on: December 05, 2006, 04:52:32 PM »

Hang in there............we will survive!!

santa.gif (4.94 KB, 50x76 - viewed 508 times.)
	Logged

tommie gorman

Sophist Member
TMN Seasoned Veteran

Offline

Gender: Male

Posts: 8605

"OLD GLORY"

Re: Database Crash

« Reply #5 on: December 05, 2006, 05:09:43 PM »

Yeah, most others and myself will survive this little thing. At least we are still on. Sorry things keep on happening. I am sure it will get better though.

Again thanks so much CA3LE for the site. Very Happy


	Logged

IF YOU DON'T STAND BEHIND OUR TROOPS, PLEASE, FEEL FREE TO STAND IN FRONT OF THEM !!!

Sprint EVDO Rev. A * AMD 64 3500+ 2.2 GHz cpu Ram 2GB/XP Home * TCP Optimizer

Swimmer

Vice Admin
TMN Seasoned Veteran

Offline

Gender: Male

Posts: 6373

Re: Database Crash

« Reply #6 on: December 05, 2006, 05:14:23 PM »

Ahhh... time to invest in a better back-up scheme? Rolling Eyes

I think everyone can live with having to re-test.. as we all know it is an addiction..


	Logged

granpa

TMN Friend

Offline

Gender: Male

Posts: 793

Re: Database Crash

« Reply #7 on: December 05, 2006, 05:18:48 PM »

I don't have any problems with the loss but I am curious as to how you are entering in these posts with your hands tied behind your back, voice command for text or very flexible? Rolling Eyes

Thanks for all your effort. wink


	Logged

Sprint EVDO A | Syntax mb/AMD 2400 - Win2000 - Home Built

Gave up Hughes 6/20/2007

tommie gorman

Sophist Member
TMN Seasoned Veteran

Offline

Gender: Male

Posts: 8605

"OLD GLORY"

Re: Database Crash

« Reply #8 on: December 05, 2006, 07:41:17 PM »

Quote from: granpa on December 05, 2006, 05:18:48 PM

I don't have any problems with the loss but I am curious as to how you are entering in these posts with your hands tied behind your back, voice command for text or very flexible? Rolling Eyes

Thanks for all your effort. wink


	Logged

IF YOU DON'T STAND BEHIND OUR TROOPS, PLEASE, FEEL FREE TO STAND IN FRONT OF THEM !!!

Sprint EVDO Rev. A * AMD 64 3500+ 2.2 GHz cpu Ram 2GB/XP Home * TCP Optimizer

tdawnaz

shug's and coknuck's momma t...and u can call me momma t too... :-)
Global Moderator
TMN Sr. Veteran

Offline

Gender: Female

Posts: 4052

Who needs shades...I'm still watching u :o)

Re: Database Crash

« Reply #9 on: December 05, 2006, 09:58:41 PM »

omg that was my best score ever in my sig...damnit...that's it i'm gonna sue...emotional distress...that's it emotional distress and pain and suffering...and liable...i'm gonna take u for everthing u have ca3le...watch me

2funny

it'll be okay...this is such a small thing...can't imagine that it would be life threatening to anyone...upsetting to many...but was already said...S#!t happens...luv ya smitten


« Last Edit: December 06, 2006, 06:54:41 AM by tdawnaz »	Logged

worship me like the Goddess I am...

You must not change one thing, one pebble, one grain of sand, until you know what good or evil will follow on that act. The World is in balance, in equilibrium. It is most Perilous. It must follow Knowledge and serve need. To Light a Candle is to cast a Shadow.
A Greener Image Interior Plant Care of Arizona

tommie gorman

Sophist Member
TMN Seasoned Veteran

Offline

Gender: Male

Posts: 8605

"OLD GLORY"

Re: Database Crash

« Reply #10 on: December 06, 2006, 02:04:38 AM »

Guess you could have actually backed it up also tdawnaz, no?? undecided


	Logged

IF YOU DON'T STAND BEHIND OUR TROOPS, PLEASE, FEEL FREE TO STAND IN FRONT OF THEM !!!

Sprint EVDO Rev. A * AMD 64 3500+ 2.2 GHz cpu Ram 2GB/XP Home * TCP Optimizer

granpa

TMN Friend

Offline

Gender: Male

Posts: 793

Re: Database Crash

« Reply #11 on: December 06, 2006, 03:39:52 AM »

Quote from: tdawnaz on December 05, 2006, 09:58:41 PM

it'll be okay...this is such a mall thing...can't imagine that it would be life threatening to anyone...upsetting to many...but was already said...S#!t happens...luv ya smitten

[/color]

Now I know what "such a mall thing" means, I always thought my sister-in-law meant "male thing" when it was just an excuse to go to the "mall".
Thanks for the enlightenment. Surprised


	Logged

Sprint EVDO A | Syntax mb/AMD 2400 - Win2000 - Home Built

Gave up Hughes 6/20/2007

tdawnaz

shug's and coknuck's momma t...and u can call me momma t too... :-)
Global Moderator
TMN Sr. Veteran

Offline

Gender: Female

Posts: 4052

Who needs shades...I'm still watching u :o)

Re: Database Crash

« Reply #12 on: December 06, 2006, 06:59:24 AM »

Quote from: tommie gorman on December 06, 2006, 02:04:38 AM

Guess you could have actually backed it up also tdawnaz, no?? undecided

back it up??...me??...no i can't do that...silly boy

Quote from: granpa on December 06, 2006, 03:39:52 AM

Now I know what "such a mall thing" means, I always thought my sister-in-law meant "male thing" when it was just an excuse to go to the "mall".
Thanks for the enlightenment. Surprised

haha...oops...typo...


	Logged

worship me like the Goddess I am...

just-

Vice Admin
TMN Sr. Veteran

Offline

Gender: Male

Posts: 3885

ISP - Be ADSL2+ 11.6Mbps - 1.3Mbps

Re: Database Crash

« Reply #13 on: December 06, 2006, 12:04:19 PM »

if i paid for the service i would be pissed off

now u offer this for free
am i going to complain ??

well i could but would not get me anywhere

so dont worry man