One table was damaged - dropped and recreated



Moderators: tim, harrymcq, Phrazz, Katie, Cleantone, diesel

One table was damaged - dropped and recreated

Postby Phrazz » Sun Oct 04, 2009 4:37 pm

There's a table for fast word searches that had a bad index, then the whole table got corrupted. Since it doesn't make much sense to take a very old dump from months ago, I just dropped and recreated the table, and rebuilt indices from scratch. This may mean word searches are very slow as the table gets repopulated, but I think we're in the clear (for now, knocking on wood). Been a while since I did any DBA "heavy lifting". I may have missed things so if you see anything weird, try to describe the problem in detail and I'll look into it. Sorry for the slow response...it took a few hours of trying a bunch of different things first. Next time it'll be easier. ;)

The dump I took today included recent posts, so we didn't lose the actual post data, just the search index. That'll slowly grow as new posts occur. I'm also not sure if searches on old posts will work properly (I think the search will rebuild on the fly...will try this with something from a month or two ago to see if it gets found).

[update] yeah...old posts don't get found since the search index is all new now...will have to see how to fix this...might take some heavy scripting
Phrazz

User avatar
Moderator
 
Posts: 1135
Joined: Sun Dec 12, 2004 12:27 pm
Location: Alexandria

Postby harrymcq » Sun Oct 04, 2009 4:48 pm

Does search work at all now?
harrymcq

User avatar
Zion Gatekeeper
 
Posts: 1582
Joined: Tue Jul 04, 2006 9:13 pm
Location: Oakland, CA

Re: One table was damaged - dropped and recreated

Postby Phrazz » Tue Jan 18, 2011 3:37 pm

Looks like the search index is back in action...again, much thanks to Harry for his tech skills!
Every picture tells a story.
Phrazz

User avatar
Moderator
 
Posts: 1135
Joined: Sun Dec 12, 2004 12:27 pm
Location: Alexandria

Re: One table was damaged - dropped and recreated

Postby johnhk4 » Mon Mar 21, 2011 3:52 pm

a quick thank you for this site and your maintaining it!!
John from CT / wheaton college, MA
johnhk4

User avatar
Beantown Rocker
 
Posts: 288
Joined: Tue Apr 25, 2006 10:42 am
Location: Brooklyn NY


Return to Website

Who is online

Users browsing this forum: No registered users and 2 guests

cron