All The Tropes Wiki Project, Part XXIV

[Bob Schroeck]

Is anyone else getting a database error when they search on something that isn't a page title?

I can explain this. One of the biggest parts of a MediaWiki database is the searchindex tables, they can get MASSIVE, and given the sheer scale of the move that had been done, the tables are likely still rebuilding, and while most of the cache of valid pages is still present, they are rebuilding the search index to better optimize it for the new servers, so errors like this are to be expected. 

The good news is this not a permanent matter, and if they can get an ElasticSearch cluster to replace the bog standard searchindex cache, we will have a much faster and accurate searchindex table optimized for very high server loads.

Just as a note to everyone, the indexes are apparently still rebuilding.