Actions
Bug #5045
open[Workbench] reports "oops, request failed" rendering projects with very large collections
Story points:
-
Description
Viewing a project that contains many collections with extremely large manifests yields this response from the API server:
#<ArvadosApiClient::ApiErrorResponseException: #<ActiveRecord::StatementInvalid: PG::OutOfMemory: ERROR: out of memory DETAIL: Failed on request of size 134217728. : SELECT "collections".* FROM "collections" WHERE (expires_at IS NULL or expires_at > CURRENT_TIMESTAMP) AND ((collections.owner_uuid = '4xphq-tpzed-0s3ii2p2j20edz6')) AND ((collections.owner_uuid ilike '%%' OR collections.modified_by_client_uuid ilike '%%' OR collections.modified_by_user_uuid ilike '%%' OR collections.portable_data_hash ilike '%%' OR collections.redundancy_confirmed_by_client_uuid ilike '%%' OR collections.uuid ilike '%%' OR collections.name ilike '%%' OR collections.description ilike '%%' OR collections.properties ilike '%%' OR collections.file_names ilike '%%') AND (collections.uuid like '_____-4zz18-_______________')) ORDER BY collections.created_at desc LIMIT 200 OFFSET 0> [API: 422]>
Actions