Flowise icon indicating copy to clipboard operation
Flowise copied to clipboard
Published 2 months ago • verified publisher icon FlowiseAI

Record manager keeps open connections to mysql

Open factoryhr opened this issue 10 months ago • 1 comments

Describe the bug When embedding the content and using Record Manager it seems like it keeps open connections to mysql and opens up a new connection on each api request. I soon get Too many connections error from mysql

Expected behavior Connection should be terminated once the API request finishes

Setup

  • Installation docker
  • Flowise Version 2.2.7-patch.1
  • OS: Ubuntu
  • Browser Chrome

factoryhr avatar Apr 04 '25 17:04 factoryhr

thats strange, it should released the connection for each api request as seen here

HenryHengZJ avatar Apr 07 '25 08:04 HenryHengZJ

@HenryHengZJ await queryRunner.release() does not close the connection. Actually the connections is established via new DataSource() call

Disconnection (closing all connections in the pool) occurs when the destroy method is called.

I created PR #5315 that fixes the issue

cuca24 avatar Oct 11 '25 17:10 cuca24