MySql: Too many connection error coming frequently

[sumitrathi]

Hi Team,
I am creating mysql connection and closing it after exceution but still I am getting Too many connectins error frequently. May I get more logs to thoubleshoot the error.

const [rows, fields] = await connection.execute(‘’);
connection.end();

Your workflow at https://pipedream.com/@sumitrathi/p_aNCew2z?e=2MRyv6EhsgbMg0Xllyb9H9KfFIo generated the following error at 8:15:16 AM GMT on Thu, Mar 2, 2023:

Error — Too many connections

Regards,
Sumit

[vunguyenhung]

Hello @sumitrathi,

Pipedream offers various built-in actions for MySQL, for example the execute query below

I believe Pipedream has already handle closing connection case. Would you mind give them a try? Or do you have specific usecase that you want to have a built-in action for?

[sumitrathi]

I will try…