Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

High Memory usage when using #rdbms:query #1042

Open
thisIsAnil opened this issue Sep 25, 2019 · 0 comments
Open

High Memory usage when using #rdbms:query #1042

thisIsAnil opened this issue Sep 25, 2019 · 0 comments

Comments

@thisIsAnil
Copy link

Description:
Apps consumes a lot of memory(RAM) which keeps increasing linearly with time(or events may be).
At start my siddhi app consumes ~320MB and after 5hrs and <120 events the RAM usage goes to >1GB.
After looking into monitoring dashboard it was found that queries with db call(#rdbms:query/cud) and aggregation function (window.timeBatch) consume lot of memory which increases exponentially. Also stream with #rdbms:query for which no event was arrived also consume same memory which keeps increasing.
Database used - Postgres
Events throughput - < 1 event/min.

I suspect the postgres connection is not closed every time a #rdbms:query is requested which leads to memory leak. I have 5 queries in the app where #rdbms:query is used.

Affected Product Version:
WSO2 SP 4.4.0.1 (docker)

OS, DB, other environment details and versions:
Tested in multiple environment with different RAM config upto 64GB and Linux and Mac OS.
DB - Postgres

Steps to reproduce:
Connect Postgres to wso2 and create an app which queries postgres using #query:rdbms.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant