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

Postgres clients exhausted, preventing albumart switch #238

Open
kenellorando opened this issue Feb 24, 2023 · 0 comments
Open

Postgres clients exhausted, preventing albumart switch #238

kenellorando opened this issue Feb 24, 2023 · 0 comments
Labels
domain: cadence-api Relates to cadence API domain: cadence-db Relates to cadence database type: bug

Comments

@kenellorando
Copy link
Owner

kenellorando commented Feb 24, 2023

After any user spends long enough time connected on the UI, the following begins to appear in the logs:

postgres    | 2023-02-24 06:55:57.782 UTC [244] FATAL:  sorry, too many clients already                         
cadence     | 2023/02/24 06:55:57 [ERROR][SEARCHBYTITLEARTIST] Could not query DB.                              
cadence     | pq: sorry, too many clients already    

Once this starts to appear, all future requests by that same client (e.g. the same open browser tab) to /api/nowplaying/albumart will fail. Refreshing the browser will fix the issue until enough songs have passed on the radio that enough calls to /api/nowplaying/albumart have been made for things to break down.

This bug can be reproduced by running the stack with at least two unique songs that have different album artwork, then using /api/dev/skip to fast-forward though songs.

@kenellorando kenellorando added type: bug domain: cadence-api Relates to cadence API domain: cadence-db Relates to cadence database labels Feb 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
domain: cadence-api Relates to cadence API domain: cadence-db Relates to cadence database type: bug
Projects
None yet
Development

No branches or pull requests

1 participant