I belive there was a search problem yesterday and they are reindexing search currently.

It may take a while to reindex everything since they had to switch from myisam to innodb which does not support full text searches unless your using either MySQL 5.6 or 5.7 not sure which one or mariadb 10+ not sure which version were using for phab.

Task about search problems is T146673

The reindex appears to still be in progress: https://grafana-admin.wikimedia.org/dashboard/db/mysql?panelId=2&fullscreen&from=1474886388229&to=1474902821657&var-dc=eqiad%20prometheus%2Fops&var-server=db1048

The innodb fulltext search index may not behave exactly the same as the old search engine. I would like to experiment with elasticsearch again since it might have improved since we originally tried it out back in 2014-15

+1 to using elasticsearch, @mmodell could you setup a separate task for that and possibly make that a high priority please?

Elasticsearch has been supported since https://secure.phabricator.com/D10955

@Paladox done: T146843: Re-evaluate how we implement phabricator's search engine

I'm actually not sure what to make of this issue. The abovementioned projects show up in the global search autocomplete dropdown. That would seem to indicate that they have already been indexed, however, the results are inconsistent if you press enter to go to the search results page.

I have tried all three examples mentioned and they know yield the appropriate result. I guess it is all related to the search index still being reindex.

From Greg link to db1048 writes:

Thus I would just mark this as resolved the root cause being the fix for the database contention (T146673) eg switching from MyISAM to Innodb with full reindexing.

@hashar: The database reindex didn't actually fix it until I specifically reindexed projects with --force

Search quality for multiple terms is still extremely poor. E.g. for the query phabricator search over half of the top 10 results (including the first one) don't even mention Phabricator. T146843, which should be the obvious winner, is no. 12.

@mmodell Maybe we will want to also do --force for manifest tasks to per ^^

Thanks.

@Tgr: Hopefully T146843: Re-evaluate how we implement phabricator's search engine will address the quality of results. I don't think innodb is doing a very good job.

@Paladox: That would take several days to complete. The index is huge.