lfnetwork.com mark read register faq members calendar

Thread: Lost posts and threads
Thread Tools Display Modes
Post a new thread. Add a reply to this thread. Indicate all threads in this forum as read. Subscribe to this forum. RSS feed: this forum RSS feed: all forums
Old 02-06-2011, 09:53 AM   #1
stoffe
Network Caretaker
 
stoffe's Avatar
 
Status: Administrator
Join Date: Apr 2002
Posts: 5,833
Helpful! 10 year veteran! Notable contributor 
Unhappy Lost posts and threads

Due to a database crash of the more serious kind, all threads started and posts made since last Sunday have been lost beyond recovery. Apologies if anyone has lost anything important, but there was nothing that could be done to salvage them. I had to restore a backup to get any posts back at all.

If you have subscribed to any threads you may also need to re-add those subscriptions. If you notice anything else working strangely, please let us know.

Since the database has been acting weirdly more than usual during the weekly backup process with odd crashes and table corruption, we're looking at possible solutions to make it more reliable.
stoffe is offline   you may: quote & reply,
Old 02-06-2011, 02:59 PM   #2
Ctrl Alt Del
Uncreative User
 
Ctrl Alt Del's Avatar
 
Join Date: Sep 2006
Location: Rio de Janeiro, Brazil
Posts: 3,814
Current Game: Dishonored
Forum Veteran 
Oh, darn. Thankfully I checked the top left of my screen on the main page.


Inspiration

.Bioshock inspiration.
Ctrl Alt Del is offline   you may: quote & reply,
Old 02-06-2011, 03:02 PM   #3
urluckyday
Up all night to get lucky
 
urluckyday's Avatar
 
Join Date: Dec 2003
Location: Beautiful USA
Posts: 2,760
Current Game: Red Orchestra 2
10 year veteran! Forum Veteran 
Damn, that must be a fun job. Sucks that it happened, but I hope it's not too much work for you guys. Thanks for the update!



If I die today, I'm happy how my life turned out
urluckyday is offline   you may: quote & reply,
Old 02-06-2011, 03:19 PM   #4
Lynk Former
internet hate machine
 
Lynk Former's Avatar
 
Status: Administrator
Join Date: Sep 1999
Location: Australia
Posts: 18,974
10 year veteran! The Walking Carpets Guild Officer Imperialist Meatbags Guild Officer LF Jester 
This is what happens when you guys don't talk about video games enough to make sure this doesn't happen again you should all talk more about video games.

This is your only warning.

Lynk Former is offline   you may: quote & reply,
Old 02-06-2011, 03:53 PM   #5
Ctrl Alt Del
Uncreative User
 
Ctrl Alt Del's Avatar
 
Join Date: Sep 2006
Location: Rio de Janeiro, Brazil
Posts: 3,814
Current Game: Dishonored
Forum Veteran 
Well, looking at the weird side, one database crash and the Egyptian Revolution never happened.


Inspiration

.Bioshock inspiration.
Ctrl Alt Del is offline   you may: quote & reply,
Old 02-06-2011, 03:56 PM   #6
Darth Avlectus
Your point?
 
Darth Avlectus's Avatar
 
Join Date: Dec 2006
Location: Attack on Titan
Posts: 4,254
Current Game: Soul Calibur 5
Crap.

Can this kind of thing happening be at least lessened by having more servers?


"I cant see S***! --YOU GO TO HELL!" --Tourettes guy
Darth Avlectus is offline   you may: quote & reply,
Old 02-08-2011, 04:03 PM   #7
Blix
Veteran
 
Blix's Avatar
 
Join Date: Feb 2006
Location: Aboard the Ravager
Posts: 865
Current Game: Morrowind & Dark Arisen
I don't know how affected I am...


Blix is offline   you may: quote & reply,
Old 02-09-2011, 12:55 PM   #8
Det. Bart Lasiter
obama.png
 
Det. Bart Lasiter's Avatar
 
Join Date: Mar 2005
Location: `(.)~
Posts: 7,997
Current Game: all
Forum Veteran LF Jester 
Quote:
Originally Posted by stoffe View Post
Due to a database crash of the more serious kind, all threads started and posts made since last Sunday have been lost beyond recovery. Apologies if anyone has lost anything important, but there was nothing that could be done to salvage them. I had to restore a backup to get any posts back at all.

If you have subscribed to any threads you may also need to re-add those subscriptions. If you notice anything else working strangely, please let us know.

Since the database has been acting weirdly more than usual during the weekly backup process with odd crashes and table corruption, we're looking at possible solutions to make it more reliable.
Have you considered making an archival system of sorts? There are quite a few old posts and threads that don't really need to be bloating the main forum database, but could be put into a separate database accessed by a another instance of vBulletin on a sub-domain like archive.lucasforums.com or some such thing and linked to on the front page. It would also make database backups and repairs go a bit quicker, which would increase reliability and perhaps even reduce the load on the server, unless there's a sudden rush to look at LF posts from a decade ago.



"No, Mama. You can bet your sweet ass and half a titty whoever put that hit on you already got the cops in their back pocket." ~Black Dynamite
Det. Bart Lasiter is offline   you may: quote & reply,
Old 02-09-2011, 01:20 PM   #9
stoffe
Network Caretaker
 
stoffe's Avatar
 
Status: Administrator
Join Date: Apr 2002
Posts: 5,833
Helpful! 10 year veteran! Notable contributor 
Quote:
Originally Posted by Det. Bart Lasiter View Post
Have you considered making an archival system of sorts? There are quite a few old posts and threads that don't really need to be bloating the main forum database, but could be put into a separate database accessed by a another instance of vBulletin on a sub-domain like archive.lucasforums.com or some such thing and linked to on the front page. It would also make database backups and repairs go a bit quicker, which would increase reliability and perhaps even reduce the load on the server, unless there's a sudden rush to look at LF posts from a decade ago.
I was planning to split the post table in two (post, archivedpost) and introduce an "archived" flag on threads. Any thread with that flag ticked would become locked and all its posts moved over to the archivedpost table instead. Then you have a scheduled task running that archives threads where the last activity date is older than X days. The advantage of that approach would be that from a user's perspective you'd see little difference (could still browse old threads but not post in them, use the search feature to look for posts in one go if you aren't sure of how old they are etc).

It's a fair amount of work involved in doing that, however, since it alters fundamental functionality of vBulletin, and lately I have ended up with too little free time to pull something like that off on my own, so that project is on hold for now.

stoffe is offline   you may: quote & reply,
Post a new thread. Add a reply to this thread. Indicate all threads in this forum as read. Subscribe to this forum. RSS feed: this forum RSS feed: all forums
Go Back   LucasForums > Network > Forum Help & Feedback Center > Lost posts and threads

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:05 PM.

LFNetwork, LLC ©2002-2011 - All rights reserved.
Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.