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: tables, on
** one on owner_uuid each searchable column
** one on the full set of searchable columns (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:
** each searchable column has an index
there is a multi-column an 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...