StackStorm / StackStorm/st2

Stacktorm UI can't go further than page 3

Open
#5,680 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
6.5k
Forks
787
PR merge metrics
No merged PRs in 30d

Description

SUMMARY

Stackstorm web UI can't go further than page4

STACKSTORM VERSION

st2 3.7.0 st2web 3.7.0 mongodb 4.0.0

OS, environment, install method

RHEL7, upgrade to 3.7.0 from 3.4.1 by RPM

Steps to reproduce the problem

Show how to reproduce the problem, using a minimal test-case. Make sure to include any content
(pack content - workflows, actions, etc.) which are needed to reproduce the problem.

Expected Results

1 navigate to UI https://xx.xx.xx.xx/#/history

2, click "OLDER" button to go to next page

3, after navigate to page4, it pops up error box in left-bottom of page

4, check with st2api.log, found error like below:

pymongo.errors.OperationFailure: Executor error during find command :: caused by :: Sort operation used more than the maximum 335544320 bytes of RAM. Add an index, or specify a smaller limit., full error: {'ok': 0.0, 'errmsg': 'Executor error during find command :: caused by :: Sort operation used more than the maximum 335544320 bytes of RAM. Add an index, or specify a smaller limit.', 'code': 96, 'codeName': 'OperationFailed'}

5, reset mongodb attribute by command to expand query blocking bit to 503316480 (based on error message to google)
db.adminCommand({setParameter: 1, internalQueryExecMaxBlockingSortBytes: 503316480})

6, back to Web UI, the page 4 display

7, continue to click "OLDER" button

8, the same error show again when it goes to page 7.

Actual Results

The web UI should show every page properly. How to fixed it except setting internalQueryExecMaxBlockingSortBytes to larger vaule in mongodb

Thanks!

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the history UI route at #/history and the st2api.log entry showing MongoDB's blocking sort memory error; reproduce it by repeatedly clicking "OLDER". Trace the history-page query and its pagination and sorting behavior, then verify that later pages load without requiring a larger MongoDB sort-memory setting.

Written by the indexing model from the issue text.

Assessment

Tech stack
mongodb, python
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.