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

[Bug] SudoSOS saturates all its available MariaDB connections #289

Open
Yoronex opened this issue Aug 30, 2024 · 0 comments
Open

[Bug] SudoSOS saturates all its available MariaDB connections #289

Yoronex opened this issue Aug 30, 2024 · 0 comments

Comments

@Yoronex
Copy link
Member

Yoronex commented Aug 30, 2024

Current behavior

SudoSOS saturates all its available MariaDB connections and does not close any connections it is not using. This is problematic, as it is for example not possible to use the CLI. Also, when restarting, it might be that all connections are in use and the rebooted instance is not able to make any DB connections, thus not starting properly.

Desired behavior

Possible solutions might be:

  • Gracefully close all connections when stopping SudoSOS (AppDataSource.destroy()).
  • Do not keep any connections alive; instead, have TypeORM make a new connection for every query/transaction.
    However, other (undiscovered) possible solutions might also work.

API Route

No response

Steps to reproduce

Start SudoSOS prod on the GEWIS server. If you try to use the CLI, it will not have any connections available. Furthermore, a restart might cause it to hang on [INFO] Application - Starting application instance....

Logs and Error Messages

No response

Other Information

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants