[Bug]: MySQL connections don't get evicted till after 5 mins

[sneha122]

Is there an existing issue for this?

• I have searched the existing issues

Description

When I create mysql datasource, current max connection pool size is 5, so when query is executed, my database gets flooded with 5 connections and they are not evicted until 5 mins are over. This causes issue when the database is configured with max connections of 10, so if I run 2 queries back to back, my DB gets flooded and I can't execute any queries anymore

Steps To Reproduce

1. Create MySQL datasource
2. Create two queries and bind them to widgets
3. Configure mysql database to have max connections of 10

Public Sample App

No response

Environment

Production

Severity

High (Blocker to building or releasing)

Issue video log

No response

Version

Cloud - v1.63