Security restrict flooding connections in my database

======== TEMPLATE BUG FORM ========

Wappler Version : 3.4.2
Operating System : Catalina
Server Model: NodeJS
Database Type: Postgresql
Hosting Type: Heroku and Local

Expected behavior

What do you think should happen?

Security Restrict database checks should close the db connection.

Actual behavior

What actually happens?

The connections stays open and idle and will eventually kill my app as it will not allow more connections.

How to reproduce

Add a security restrict check against database and check active connections in PG.

select *
from pg_stat_activity
WHERE pg_stat_activity.usename = 'youruser'

@patrick I know you added a fix to kill knex connections in one of the updates I am missing. But I don’t know if it addresses specifically the Security restrict action or it addresses all knex connections(including the one created by Security Restrict).

Unfortunately I can’t update at the moment so I have to stay in 3.4.2 until I finish a feature.

Community Page
Last updated: