Describe the bug
Running query with OR statement may trigger 100% CPU load of Postgres process.
To Reproduce
Steps to reproduce the behavior:
- 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.
Describe the bug
Running query with
ORstatement may trigger 100% CPU load of Postgres process.To Reproduce
Steps to reproduce the behavior:
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:
Additional context
Add any other context about the problem here.