appsmithorg / appsmithorg/appsmith
[Bug]-[3.5]:Certain Redshift queries time out
Open
Backend
Bug
Community Reported
Integrations Product
Low
Production
Query & JS Pod
Query Widgets & IDE Pod
Redshift
- Dominant language
- TypeScript
- Stars
- 40.9k
- Forks
- 4.8k
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 45
Description
## Description
User reported that they find a few Redshift queries timing out even though they've expanded the timeout. They see a message: ERROR: Query cancelled on user's request.
User says that this happens for complex queries or where the number of rows in the response are higher.
The error shows up inconsistently. From Discord: "so just to clarify, if I try running the same query 5-10 times, it ends up giving an output. It's not that it never renders an output.
This is agnostic of the size of the response, it even happens for output which is lesser than 20 entries.
The size of the dataset being queried is 300K entries"
User is on cloud hosted edition.
Contributor guide
Assessment
This issue has not been assessed yet.