Jump to content


- - - - -

Database Crash


  • You cannot reply to this topic
18 replies to this topic

#1 CA3LE

    TestMy.net Webmaster

  • Administrator
  • 6,766 posts
  • Location: 00110110 00110000 00110010

Posted 05 December 2006 - 01:32 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.

#2 TimPawlak

    TMN Veteran

  • Members
  • PipPipPipPipPipPipPipPip
  • 1,574 posts
  • Location: Central Indiana

Posted 05 December 2006 - 01:38 PM

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

#3 CA3LE

    TestMy.net Webmaster

  • Administrator
  • 6,766 posts
  • Location: 00110110 00110000 00110010

Posted 05 December 2006 - 02:22 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.

#4 Sparticus

    TMN Veteran

  • News Anchor
  • PipPipPipPipPipPipPipPip
  • 1,560 posts
  • Location: Virginia

Posted 05 December 2006 - 03:53 PM

S#!t happens.  :haha:

#5 mikedallos

    Sr. Member

  • Members
  • PipPipPipPipPip
  • 134 posts
  • Location: N.Y.Mills, N.Y.

Posted 05 December 2006 - 04:52 PM

Hang in there............[move]we will survive!![/move]

#6 tommie gorman

    TMN Seasoned Veteran

  • Sophist Member
  • PipPipPipPipPipPipPipPipPipPip
  • 12,961 posts
  • Location: western missouri

Posted 05 December 2006 - 05:09 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.  :grin2:

#7 Swimmer

    TMN Seasoned Veteran

  • Inactive Moderator
  • PipPipPipPipPipPipPipPipPipPip
  • 6,411 posts
  • Location: Purdue University

Posted 05 December 2006 - 05:14 PM

Ahhh... time to invest in a better back-up scheme?  :roll:  I think everyone can live with having to re-test.. as we all know it is an addiction..

#8 granpa

    TMN Friend

  • Members
  • PipPipPipPipPipPip
  • 942 posts
  • Location: 78'47"West 43'6"North

Posted 05 December 2006 - 05:18 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?  :roll:
Thanks for all your effort. :wink:

#9 tommie gorman

    TMN Seasoned Veteran

  • Sophist Member
  • PipPipPipPipPipPipPipPipPipPip
  • 12,961 posts
  • Location: western missouri

Posted 05 December 2006 - 07:41 PM

Quote

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?  :roll:
Thanks for all your effort. :wink:
:laughing7:  :iamwithstupid:

#10 tdawnaz

    TMN Secretary

  • TMN Secretary
  • 8,007 posts
  • Location: hades

Posted 05 December 2006 - 09:58 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  :tickedoff:  :knuppel2:

:2funny:  :idiot2:  :uglystupid2:

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:


#11 tommie gorman

    TMN Seasoned Veteran

  • Sophist Member
  • PipPipPipPipPipPipPipPipPipPip
  • 12,961 posts
  • Location: western missouri

Posted 06 December 2006 - 02:04 AM

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

#12 granpa

    TMN Friend

  • Members
  • PipPipPipPipPipPip
  • 942 posts
  • Location: 78'47"West 43'6"North

Posted 06 December 2006 - 03:39 AM

Quote

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.  :o

#13 tdawnaz

    TMN Secretary

  • TMN Secretary
  • 8,007 posts
  • Location: hades

Posted 06 December 2006 - 06:59 AM

Quote

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

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.  :o

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


#14 just-

    TMN Seasoned Veteran

  • Inactive Moderator
  • PipPipPipPipPipPipPipPipPipPip
  • 4,000 posts
  • Location: U.K. - London

Posted 06 December 2006 - 12:04 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

#15 fred

    Sr. Member

  • Members
  • PipPipPipPipPip
  • 184 posts
  • Location: Munford, Tennesse

Posted 13 October 2007 - 03:39 PM

This has not bothered me one Iota :-P :-P

#16 granpa

    TMN Friend

  • Members
  • PipPipPipPipPipPip
  • 942 posts
  • Location: 78'47"West 43'6"North

Posted 13 October 2007 - 04:12 PM

Quote

This has not bothered me one Iota :-P :-P

I guess not, it's only been 10 months since. :2funny:

#17 tommie gorman

    TMN Seasoned Veteran

  • Sophist Member
  • PipPipPipPipPipPipPipPipPipPip
  • 12,961 posts
  • Location: western missouri

Posted 13 October 2007 - 04:18 PM

:cool: Resurrection. I love it when this stuff comes back to life.  :kiss:

#18 granpa

    TMN Friend

  • Members
  • PipPipPipPipPipPip
  • 942 posts
  • Location: 78'47"West 43'6"North

Posted 13 October 2007 - 04:26 PM

Quote

:cool: Resurrection. I love it when this stuff comes back to life.  :kiss:
Have you lately?????????????? :haha:

#19 tommie gorman

    TMN Seasoned Veteran

  • Sophist Member
  • PipPipPipPipPipPipPipPipPipPip
  • 12,961 posts
  • Location: western missouri

Posted 13 October 2007 - 07:49 PM

Quote

Have you lately?????????????? :haha:
My G/F said we'll work on that one.  :wink:





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users