search

pg-redis-fdw / redis_fdw

A PostgreSQL foreign data wrapper for Redis
494 stars 68 forks source link

Failed to connect to Redis #18

Open kumarv-rohith opened 7 years ago

kumarv-rohith commented 7 years ago

Hi, I'm currently facing this issue even if connection exists,not for all transactions but only for few. Please provide some solution, because of which i'm not able to use the app.

Any solution will be appreciated.

JerryMSunny commented 7 years ago

Even I'm having this connection issue, basically in my application there is one running php process that connects to the postgres database in turn postgres database perform an insert or an update to the redis through fdw on every request given by the php process. And it will work for some odd 1000 connections after which postgres throws an exception "Failed to connect to Redis: ". When I restart the php process or postgres server it starts to execute again normally for near to 1000 connections and run into having the same issue. I started looking into the c code and found that there are three places where there is this error displayed and also found that it is in the function "redisBeginForeignModify" (out of these three places) that I'm getting this error(if it may help someone to trace it). And I'm suspecting that this is due to the number of connections open by a single process and it is not releasing the temp file used to open the connection. Am I on the right track and is there a way to safely disconnect the connections and release the temp file after every query? Let me know if any solution or where can I look for the issue to fix it. Thanks in advance.

adunstan commented 7 years ago

It might leak connections. Please provide a self-contained test.

mkgrgis commented 1 year ago

Ping @kumarv-rohith ?