Database Crash - testmy.net resource / tool
Home
Welcome, Guest. Please login or register.
Did you miss your activation email?

  



donations help testmy.net pay for the very high cost to run the site. Any amount is greatly appreciated.
Click to read why...

  spcr
    
News : Have an idea that will make testmy.net better?  Click here to post it!  We love to hear feedback, user feedback like yours have helped build testmy.net over the years.. true story wink October 15, 2008, 06:56:12 PM
testmy.net Broadband  |  Main Forum  |  News  |  testmy.net News and Updates  |  Topic: Database Crash Advanced search
  0 Members and 1 Guest are viewing this topic. « previous next »
Topic Tools Search this topic
 Pages 1 2  All Go Down
Author
Topic: Database Crash  (Read 7923 times)
CA3LE
testmy.net Patriarch
Administrator
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 5086


yep... ima g33k


View Profile WWW
« on: December 05, 2006, 02: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
News Anchor
Expert
*
Offline Offline

Gender: Male
Posts: 1538


Comcast 20/2 --- Telia 100/75


View Profile WWW
« Reply #1 on: December 05, 2006, 02:38:36 PM »
ah, its ok ca3le its not the biggest problem in the world..
Logged

CA3LE
testmy.net Patriarch
Administrator
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 5086


yep... ima g33k


View Profile WWW
« Reply #2 on: December 05, 2006, 03: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 Offline

Gender: Male
Posts: 1555


Cox 12mb/1mb


View Profile
« Reply #3 on: December 05, 2006, 04:53:49 PM »
S#!t happens.  :haha:
Logged
mikedallos
Sr. Member
*
Offline Offline

Gender: Male
Posts: 123


What's happenin'!


View Profile WWW
« Reply #4 on: December 05, 2006, 05:52:32 PM »
Hang in there............we will survive!!

* santa.gif (4.94 KB, 50x76 - viewed 541 times.)
Logged
tommie gorman
Sophist Member
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 9988


"OLD GLORY"


View Profile
« Reply #5 on: December 05, 2006, 06: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 !!!

"an old country hick from america"

Sprint EVDO Rev. A * AMD 64 3500+ 2.2 GHz cpu Ram 2GB/XP Home * TCP Optimizer
Swimmer
Vice Admin
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 6393



View Profile
« Reply #6 on: December 05, 2006, 06: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 Offline

Gender: Male
Posts: 906


View Profile
« Reply #7 on: December 05, 2006, 06: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
Remote G11 Hughes Site Working Since 9/2001
tommie gorman
Sophist Member
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 9988


"OLD GLORY"


View Profile
« Reply #8 on: December 05, 2006, 08:41:17 PM »
Quote from: granpa on December 05, 2006, 06: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
laughing7  iamwithstupid
Logged
IF YOU DON'T STAND BEHIND OUR TROOPS, PLEASE, FEEL FREE TO STAND IN FRONT OF THEM !!!

"an old country hick from america"

Sprint EVDO Rev. A * AMD 64 3500+ 2.2 GHz cpu Ram 2GB/XP Home * TCP Optimizer
tdawnaz
shugarbabie and coknuck's momma t...u can call me momma t too :-)
TMN Secretary
TMN Seasoned Veteran
*
Offline Offline

Gender: Female
Posts: 5814


whattcha doin??...c'mere ...where's my switch?


View Profile
« Reply #9 on: December 05, 2006, 10: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  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
« Last Edit: December 06, 2006, 07:54:41 AM by tdawnaz » Logged
worship me like the Goddess I am...  Smile

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.
abortion doesn't make you "un" pregnant...it makes you the mother of a dead baby
tommie gorman
Sophist Member
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 9988


"OLD GLORY"


View Profile
« Reply #10 on: December 06, 2006, 03: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 !!!

"an old country hick from america"

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

Gender: Male
Posts: 906


View Profile
« Reply #11 on: December 06, 2006, 04:39:52 AM »
Quote from: tdawnaz on December 05, 2006, 10: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
Remote G11 Hughes Site Working Since 9/2001
tdawnaz
shugarbabie and coknuck's momma t...u can call me momma t too :-)
TMN Secretary
TMN Seasoned Veteran
*
Offline Offline

Gender: Female
Posts: 5814


whattcha doin??...c'mere ...where's my switch?


View Profile
« Reply #12 on: December 06, 2006, 07:59:24 AM »
Quote from: tommie gorman on December 06, 2006, 03: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, 04: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...  Smile

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.
abortion doesn't make you "un" pregnant...it makes you the mother of a dead baby
just-
Vice Admin
TMN Sr. Veteran
*
Offline Offline

Gender: Male
Posts: 3996


ISP - Be ADSL2+ 11.6Mbps - 1.3Mbps


View Profile WWW
« Reply #13 on: December 06, 2006, 01: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
Logged


Download 11.6Mbps
Upload 1.3Mbps

My CPU: http://valid.x86-secret.com/show_oc?id=40752
fred
Sr. Member
*
Offline Offline

Gender: Male
Posts: 179



View Profile
« Reply #14 on: October 13, 2007, 04:39:46 PM »
 This has not bothered me one Iota Razz Razz
Logged
follow instructions, it makes your life so much easier
Print  Pages 1 2  All Go Up
testmy.net Broadband  |  Main Forum  |  News  |  testmy.net News and Updates  |  Topic: Database Crash « previous next »
Jump to:  

 
    
testmy.net's forum is proudly Powered by SMF | SMF © 2006-2007, Simple Machines LLC
Bookmark: Del.icio.us    StumbleUpon
 		  

 

 © 1999-2008 testmy.net - Contact - Legal - Facts & FAQs
Page Loading Stats: This forum Page created in 0.132 seconds with 54 queries.