Comments (3)
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.
from redis_fdw.
It might leak connections. Please provide a self-contained test.
from redis_fdw.
Ping @kumarv-rohith ?
from redis_fdw.
Related Issues (20)
- What about redis_fdw for Windows? HOT 1
- make: *** No rule to make target `make'. Stop HOT 1
- Cache expire? HOT 1
- Geo as a tabletype HOT 1
- Redis Secondary Index module
- running on rds postgres HOT 2
- Performance problem HOT 1
- Make use of HINCRBY? HOT 3
- ERROR: failed to get the database size: 19081328 HOT 1
- Does it support postgresql 10.0 or later release?
- missing single quote?..
- Postgresql 11.3 crashed on CREATE EXTENSION redis_fdw compiled with DEBUG HOT 1
- question about connection pooling for the fdw HOT 4
- Null bytes in redis bit strings
- ERROR: invalid byte sequence for encoding "UTF8": 0x86 HOT 2
- Redis Clustering support HOT 5
- question about redis_wrapper as foreign server HOT 1
- No license
- GCC 10.2.1 + PostgreSQL 13 warnings
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from redis_fdw.