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

Fix that the weekly backup process (using pgdump) can result in "dangling" db connections, which stay alive forever (show as "active" in session-manager in dbeaver), and which prevent schema changes and such until terminated #347

Open
Venryx opened this issue Sep 26, 2024 · 0 comments

Comments

@Venryx
Copy link
Collaborator

Venryx commented Sep 26, 2024

I do not currently know what causes the pgdump connections to become "dangling" like this... perhaps it's due to a crash of the app-server while the SQL query in the getPGDump graphql endpoint is being run.

@Venryx Venryx converted this from a draft issue Sep 26, 2024
@Venryx Venryx changed the title Fix that the weekly backup process (using pgdump) can result in "dangling" db connections, which stay alive forever (show as "active" in session-manager in dbeaver), and prevent schema changes and such until terminated Fix that the weekly backup process (using pgdump) can result in "dangling" db connections, which stay alive forever (show as "active" in session-manager in dbeaver), and which prevent schema changes and such until terminated Oct 31, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: 🔖 Short-term (Venryx)
Development

No branches or pull requests

1 participant