Redis not closing connections

💬 Queries and Resources
1

I'm using the Redis resource, but it doesn't seem to close connections, I'm quickly using up all my connections on my Redis server and getting "ERR max number of clients reached"

How do I get retool to close the redis connection after a query?

2

Hello @Deekor Welcome to the Retool Community,

Retool doesn't automatically close Redis connections after each query, which can lead to exhausting the connection limit on your Redis server.

  1. You can explicitly close the connection by adding a QUIT or DISCONNECT command after your query.

  2. Set Up a TTL for Idle Connections:

  • If you’re using Redis in a managed environment (like AWS ElastiCache), you can configure an idle timeout to automatically close unused connections
  1. Monitor Redis Connections: Use the redis-cli command CLIENT LIST to monitor the number of active Redis connections. This helps you understand your application's connection usage patterns.
5 Likes