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: 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...