SQL Plugin creating multiple sessions for each query inside a loop and none getting closed

bimodh_jo_mathew · July 6, 2021, 8:01pm

Within a workflow, I have a for loop and I am running an sql query in the loop. So, for each of this query in the loop, the SQL plugin is opening new sessions. Ideally, a single workflow should use a single connection and this connection should be used for all of the queries within the workflow and at the end of the workflow, the session should be closed.

For example, I have a workflow that uses for loop and within the for loop, I have 2 SQL queries. Now, if I run this workflow, it opens 20 connections to the database and none gets closed. So ultimately, I am maxing out the number of connections to the database and not able to connect to the database anymore.

joey_mcadams · July 6, 2021, 8:18pm

Thanks for the feedback!

This is a known issue. We’ve got code ready to fix it, but are still running QA on it to verify it works. You should see an update that fixes this very soon.

bimodh_jo_mathew · July 19, 2021, 2:43pm

Hi @joey_mcadams

Is there any update on ETA of the release?

joey_mcadams · July 19, 2021, 4:04pm

Checking…(The team that’s working on this one is in Europe, I’m not sure if they’re still online or not).

joey_mcadams · July 19, 2021, 4:55pm

ETA is end of the day. Don’t quote me on that, there might be blockers or other issues that come up, but it will be soon for sure.

bimodh_jo_mathew · July 19, 2021, 4:57pm

Thanks for the update, looking forward.

luke_milby · August 2, 2021, 3:00pm

@bimodh_jo_mathew 3.0.1 got released addressing the open connection issue! Rapid7 Extensions

bimodh_jo_mathew · August 10, 2021, 3:48pm

Tested the updated plugin, working like a charm…

Thanks folks… !!!

mike_rinehart · August 17, 2021, 2:46pm

Glad to hear it Bimodh!