Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pg_timetable running against read-only replica #565

Closed
pashagolub opened this issue May 17, 2023 Discussed in #563 · 0 comments · Fixed by #568
Closed

pg_timetable running against read-only replica #565

pashagolub opened this issue May 17, 2023 Discussed in #563 · 0 comments · Fixed by #568
Assignees
Labels
🐞 bug Something isn't working

Comments

@pashagolub
Copy link
Collaborator

Discussed in #563

Originally posted by seanzechman May 16, 2023
We have pg_timetable daemon running locally on all of our postgres servers. We are testing a POC and noticed that on read-only replicas pg_timetable takes all of available connections. Is this by design and is there a way to stop the build up of sessions? We would like pg_timetable to work after a failover to a standby node but right now our standby node has issues because max_connections is reached due to this problem

[notice:Cannot obtain lock on a replica. Please, use the primary node] [severity:NOTICE] #33[0mNotice received

pg_timetable:
Version: 5.3.0
DB Schema: 00534
Git Commit: e6a13ee
Built: 2023-03-13T11:38:30Z

@pashagolub pashagolub self-assigned this May 17, 2023
@pashagolub pashagolub added the 🐞 bug Something isn't working label May 17, 2023
pashagolub added a commit that referenced this issue May 23, 2023
…ly-replica

[-] fix connection usage for replicas and locked sessions, fixes #565
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
🐞 bug Something isn't working
Projects
None yet
1 participant