Project

General

Profile

Actions

Bug #5045

open

[Workbench] reports "oops, request failed" rendering projects with very large collections

Added by Tim Pierce over 9 years ago. Updated over 9 years ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
Workbench
Target version:
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 #1

Updated by Tim Pierce over 9 years ago

  • Target version changed from Bug Triage to Deferred

Resolved on 4xphq with #3021. Moving this to Deferred on the expectation that this particular failure is unlikely to happen for this particular reason again, and ongoing database schema improvements will make it less likely in general, without needing to address this specific request.

Actions

Also available in: Atom PDF