Skip to content

Postgres load 100% #196

@dtitov

Description

@dtitov

Describe the bug
Running query with OR statement may trigger 100% CPU load of Postgres process.

To Reproduce
Steps to reproduce the behavior:

  1. Search for
(samples.content->'biospecimen_class'->'term_label' ? 'Cell'
OR samples.content->'donor_age' ? '25 - 30')
AND experiments.content->'technique'->'term_label' ? 'DNase I hypersensitive sites sequencing assay'

Actual behavior
It hangs with the progress bar stuck at the end of the screen + 100% Postgress service CPU load in the VM.

Expected behavior
We get the results.

Screenshots
If applicable, add screenshots to help explain your problem.

For UI-related issues, please complete the following information:

  • OS: [e.g. iOS]
  • Browser [e.g. chrome, safari]
  • Version [e.g. 22]

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions