Bug #4523
Updated by Tom Clegg about 10 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...