Bug #4523

Updated by Tom Clegg almost 7 years ago

To reproduce:

Go to https://workbench.qr1hi.arvadosapi.com/, enter any term into the search box (I used "hash") and click the search button. The search modal box will appear and display a spinning wheel. After some time it issues "Oops, request failed."

Proposed fix:
* Add database indexes to all tables:
** one on owner_uuid
** one on the full set of searchable columns (i.e., @ModelClass.searchable_columns("<") | ModelClass.searchable_columns("like")@) (as returned by ModelClass.searchable_columns)
** (phase2) each searchable column
* To avoid undetected additions of columns without indexes in the future, add a unit test that iterates over all model classes and tests:
** there is a multi-column index on the full set of searchable columns
** there is an index on owner_uuid and an index on uuid
** (phase2) there is an index each searchable column

Let's wait on the "(phase2)" items until we see results from the rest...