Page 1 of 1

Loss of Posts - 2/3/2013

PostPosted: March 3rd, 2013, 12:34 am
by EFFalcon
Hey Guys,

Looks like we had a Data corruption issue on the main post table which resulted in me having to restore from backup.

the end result being that any posts made after ~3am on the 2nd March 2013 will be gone.

If anyone notices any other issues, let me know.
It should only affect posts, PM's etc should have been fine.

now i need some sleep

Re: Loss of Posts - 2/3/2013

PostPosted: March 3rd, 2013, 12:36 am
by EFFalcon
PS - the new posts feature will be a bit iffy until actual new posts catch up.

Its captured that the thread was updated, but the underlying detail is gone.

Re: Loss of Posts - 2/3/2013

PostPosted: March 3rd, 2013, 4:32 am
by TUFFeNF
i thought somthing iffy had happened,before i left for work there was some new posts,checked at about 1 am and couldnt see them any more.that expains it.i thought it was a prob on my end.doh. :scratch:

Re: Loss of Posts - 2/3/2013

PostPosted: March 3rd, 2013, 6:13 am
by GIFFO97
Now I have to redo all my V8 Supercar updates :( Ehh, no problems but. These things happen.

Re: Loss of Posts - 2/3/2013

PostPosted: March 3rd, 2013, 8:20 am
by wombi90
Good work John

Re: Loss of Posts - 2/3/2013

PostPosted: March 3rd, 2013, 10:36 pm
by staunchxr
top work mate.

Re: Loss of Posts - 2/3/2013

PostPosted: March 10th, 2013, 1:04 am
by iCER
no daily backups? :( darn. Someone go bump all the live threads!

Re: Loss of Posts - 2/3/2013

PostPosted: March 10th, 2013, 1:47 am
by Commando
Your mum backs up daily.

Re: Loss of Posts - 2/3/2013

PostPosted: March 10th, 2013, 1:57 am
by iCER
i see. :clapping:

Re: Loss of Posts - 2/3/2013

PostPosted: March 10th, 2013, 2:17 am
by NUT347
Maybe the forum should be handed over to iCERs domain.

Said no one. Ever.

Re: Loss of Posts - 2/3/2013

PostPosted: March 10th, 2013, 9:48 am
by nstg8a
Did this happen again last night?

Re: Loss of Posts - 2/3/2013

PostPosted: March 10th, 2013, 10:36 am
by SnipeZ
Can only assume so


Cheers

Re: Loss of Posts - 2/3/2013

PostPosted: March 10th, 2013, 10:47 am
by Sunboost
Forums have been kinda slow lately too. I can't talk though, I don't no shit about how this all works. I can fix your 4 litre though :good:

Re: Loss of Posts - 2/3/2013

PostPosted: March 10th, 2013, 12:33 pm
by Ef_frmnt
nstg8a wrote:Did this happen again last night?


Yeah I have got error/crash messages a few times using Tapatalk

Re: Loss of Posts - 2/3/2013

PostPosted: March 11th, 2013, 10:24 am
by EFFalcon
iCER wrote:no daily backups? :( darn. Someone go bump all the live threads!


i have daily backups... the issue was the last backup was @ 3am.

the table got corrupted some time around 6 or 7pm.

i didnt get a chance to get on and fix it until about 10pm, and by the time i edited the SQL script it was even later.

I didnt want to do a full database restore, as i didnt want people to lose any recent PM's.

so i restored a handful of tables, it was just that the corrupted table was the biggest one so it took a while.

Re: Loss of Posts - 2/3/2013

PostPosted: March 11th, 2013, 10:26 am
by EFFalcon
nstg8a wrote:Did this happen again last night?


no lost posts that i'm aware of.

if you see any error messages or anything like that, get a screen shot and shoot it to me, or capture the error message.
i've noticed it being a little slow, but no errors or other issues since the 2nd.