Why does the SDMB search engine no longer work on threads before a certain date?

The BBQ Pit
1

I’m not sure what that date is, but I know it won’t pick up threads I clearly remember starting more than three years ago. Why not? :mad:

2

IIRC, they put those threads in a bit of a limbo, until they upgrade the servers. Eventually, all will be set right. In the meantime…

3

Apparently you didn’t start any threads before 12/28/2005. :dubious:
OTOH, when I do a search for threads I started, they go all the way back to May 2001.

Your missing threads are probably still there, as they were for Eva Luna when she had similar troubles a few weeks ago. They just can’t be found by searching.
As I implied in that thread, the search database is probably corrupt.
I wonder how long it’d take jdavis to rebuild it from scratch?

4

So how do we bribe it?!

5

Bribes are ineffective in dealing with rogue databases. We must isolate it, and impose meaningful economic sanctions in order to force it to mend its ways. If isolation and sanctions fail, our only recourse is to nuke it from orbit.

I checked on a few other poster’s first OP date:


tomndebb 2002
Giraffe 2001
samclem 2001
Tubadiva 2001
xash 2001
Aeschines 12/29 2005
duffer 1/2006
CalMeacham 2001
furt  2001
John Mace 2003
Elucidator 2001
Eve 2001

From the sample, it looks like maybe 10 to 20% of them are affected.

6

I haven’t done it myself in a long while, but if I can make a guess it’d likely take a couple days, maybe longer, and put a pretty good strain on the server (it can be run while the boards are active). It’s a pretty intensive process. And to be clear - you just have to click something and let it go - there’s no manual involvement aside from starting it up and making sure it finishes.

They’re also apparently having some issue where the size of the database is limited, causing crashes when we exceed it. That’s why some old threads are disappearing to perhaps be restored at a later date. This is a consideration for rebuilding the search index as well, as it takes up a significant amount of disk space. The database for my vBulletin site is 1.1 GB total, and almost 400 MB of that is the search index.

7

Despite Mr. Angry Smiley, this probably could have gone in ATMB. lol. I say that because Eva Luna noticed a problem with the “Threads Started By” index late last month and posted about it in ATMB. It seems to me it might be the same issue. I posted a workaround in that thread that might find the threads you want.