search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
34.67k stars 3.75k forks source link

[Bug]: Appsmith become unresponsive with unoptimised postgres queries #15313

Open sh-TU opened 2 years ago

sh-TU commented 2 years ago

Is there an existing issue for this?

Description

When a data source gets really slow and lots of queries on Appsmith are timing out, the api gets unresponsive eventually while health checks and supervisor states are fine.

Unresponsive data sources should not turn Appsmith into unusable state. image

Steps To Reproduce

In our case, we have postgres queries that are not optimized and consumes high cpu. The cpu is at 100% then queries starts timing out. Keep trying for about 5 minutes and then all other apis gets broken.

Public Sample App

No response

Version

Self Hosted - CE v1.7.8

Nikhil-Nandagopal commented 2 years ago

@sh-TU thank you for reporting this. We'll try to reproduce this on our end.

@sumitsum @rohan-arthur

sh-TU commented 1 year ago

@Nikhil-Nandagopal just some observation that might help with this. The v1.9.25-26 still got this problem and we also noticed that upgrading to v1.9.44 made this problem worse.