ERROR: sorry, too many clients already

[bernejorge]

I'm facing this error. It seems that the database connections are not being closed. I started experiencing this when I upgraded the version and changed the agent memory from SQLite to Postgres.
I'm running flowise in a docker container

2024-12-09 21:35:35 [DEBUG]: [server]: Initializing Agent Memory (agentMemory_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Finished initializing Agent Memory (agentMemory_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Initializing ChatOpenAI (chatOpenAI_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Finished initializing ChatOpenAI (chatOpenAI_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Initializing State (seqState_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Finished initializing State (seqState_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Initializing OpenAI Embeddings (openAIEmbeddings_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Finished initializing OpenAI Embeddings (openAIEmbeddings_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Initializing OpenAI Embeddings (openAIEmbeddings_1)
2024-12-09 21:35:35 [DEBUG]: [server]: Finished initializing OpenAI Embeddings (openAIEmbeddings_1)
2024-12-09 21:35:35 [DEBUG]: [server]: Initializing Start (seqStart_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Finished initializing Start (seqStart_0)
2024-12-09 21:35:35 [DEBUG]: [server]: Initializing Postgres (postgres_0)
2024-12-09 21:35:35 [ERROR]: sorry, too many clients already
error: sorry, too many clients already
at Parser.parseErrorMessage (/usr/local/lib/node_modules/flowise/node_modules/pg-protocol/dist/parser.js:283:98)
at Parser.handlePacket (/usr/local/lib/node_modules/flowise/node_modules/pg-protocol/dist/parser.js:122:29)
at Parser.parse (/usr/local/lib/node_modules/flowise/node_modules/pg-protocol/dist/parser.js:35:38)
at Socket. (/usr/local/lib/node_modules/flowise/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:518:28)
at Socket.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
at TCP.callbackTrampoline (node:internal/async_hooks:130:17)
2024-12-09 21:35:35 [ERROR]: [server]: Error: error: sorry, too many clients already
Error: error: sorry, too many clients already
at buildFlow (/usr/local/lib/node_modules/flowise/dist/utils/index.js:496:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async buildAgentGraph (/usr/local/lib/node_modules/flowise/dist/utils/buildAgentGraph.js:85:32)
at async utilBuildAgentResponse (/usr/local/lib/node_modules/flowise/dist/utils/buildChatflow.js:440:31)
at async utilBuildChatflow (/usr/local/lib/node_modules/flowise/dist/utils/buildChatflow.js:195:20)
at async createAndStreamInternalPrediction (/usr/local/lib/node_modules/flowise/dist/controllers/internal-predictions/index.js:33:29)
2024-12-09 21:35:35 [ERROR]: [server]: Error: Error buildAgentGraph - error: sorry, too many clients already
Error: Error buildAgentGraph - error: sorry, too many clients already
at buildAgentGraph (/usr/local/lib/node_modules/flowise/dist/utils/buildAgentGraph.js:405:15)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async utilBuildAgentResponse (/usr/local/lib/node_modules/flowise/dist/utils/buildChatflow.js:440:31)
at async utilBuildChatflow (/usr/local/lib/node_modules/flowise/dist/utils/buildChatflow.js:195:20)
at async createAndStreamInternalPrediction (/usr/local/lib/node_modules/flowise/dist/controllers/internal-predictions/index.js:33:29)
2024-12-09 21:35:35 [ERROR]: [server]: Error: Error buildAgentGraph - error: sorry, too many clients already
Error: Error buildAgentGraph - error: sorry, too many clients already
at utilBuildAgentResponse (/usr/local/lib/node_modules/flowise/dist/utils/buildChatflow.js:546:15)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async utilBuildChatflow (/usr/local/lib/node_modules/flowise/dist/utils/buildChatflow.js:195:20)
at async createAndStreamInternalPrediction (/usr/local/lib/node_modules/flowise/dist/controllers/internal-predictions/index.js:33:29)