Project

General

Profile

Actions

Bug #8183

closed

[Workbench] should not look up every group/project a user has access to on every page load

Added by Ward Vandewege almost 9 years ago. Updated almost 9 years ago.

Status:
Resolved
Priority:
Normal
Assigned To:
Radhika Chippada
Category:
Workbench
Target version:
Story points:
1.0

Description

A user created over 20,000 groups on one of our installations.

For admin users (who can see every group) and for the user in question, Workbench appears to request all of these groups, 100 at a time, for each page load. An example from the api server logs:

...
10.28.0.7 - - [11/Jan/2016:19:33:58 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 53511 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
10.28.0.7 - - [11/Jan/2016:19:33:59 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 52721 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
10.28.0.7 - - [11/Jan/2016:19:33:59 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 53510 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
10.28.0.7 - - [11/Jan/2016:19:34:00 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 53510 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
10.28.0.7 - - [11/Jan/2016:19:34:00 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 53508 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
10.28.0.7 - - [11/Jan/2016:19:34:00 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 53507 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
10.28.0.7 - - [11/Jan/2016:19:34:00 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 53512 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
10.28.0.7 - - [11/Jan/2016:19:34:01 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 53511 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
10.28.0.7 - - [11/Jan/2016:19:34:01 +0000] "POST /arvados/v1/groups HTTP/1.1" 200 53506 "-" "HTTPClient/1.0 (2.6.0.1, ruby 2.1.4 (2014-10-27))" 
...

This is so slow that it causes the nginx reverse proxy to time out, making workbench unusable. The API server is fine - the cli interface works.

Proposed fix

When building the "my projects" tree for the workbench project dropdowns:
  • fetch one page of "all readable projects" (like we do now, but with "get all pages" turned off)
  • compare the returned result count to items_available
  • if items_available is > 3x returned result count (i.e., it would take more than 2 additional API calls to retrieve the full list), switch tactics and build the "my projects" tree this way instead:
    • set my_project_uuids=[current_user.uuid]
    • retrieve all projects with owner_uuid in my_project_uuids (limit=200)
    • add results to my_project_uuids
    • repeat until no new results arrive, or my_project_uuids has more than 200 entries

For now, the "choose project" dialog should use the old method, even though it will be slow when there are thousands of projects. We will come back and fix this part after #8286.


Subtasks 1 (0 open1 closed)

Task #8364: Review branch: 8183-projects-dropdownResolvedPeter Amstutz02/12/2016Actions

Related issues

Related to Arvados - Bug #8189: [FUSE] Listing a project directory is slow when there are many subprojectsResolvedWard Vandewege01/11/2016Actions
Related to Arvados - Idea #8286: [API] [Workbench] Allow users to choose which projects appear in their dropdown areaResolvedRadhika Chippada01/22/2016Actions
Actions

Also available in: Atom PDF