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

Too many queries cause block importing to crash. #517

Closed
winder opened this issue Jun 1, 2021 · 1 comment
Closed

Too many queries cause block importing to crash. #517

winder opened this issue Jun 1, 2021 · 1 comment
Labels

Comments

@winder
Copy link
Contributor

winder commented Jun 1, 2021

Summary

If the indexer is receiving many requests it's possible to hit the Postgres client limit.

I reproduced this with a docker environment which was sending lots of queries to indexer over and over again.

indexer-postgres | 2021-06-01 16:36:04.546 UTC [823] FATAL:  sorry, too many clients already
indexer       | {"error":"error committing block, CommitBlock(): pq: sorry, too many clients already","level":"error","msg":"ImportDecodedBlock 9","time":"2021-06-01T16:36:04Z"}

Scope/Requirements

Make sure we can recover gracefully from Postgres failures during block import.

Urgency/Relative Priority

@winder
Copy link
Contributor Author

winder commented Jul 8, 2021

Resolved by #554, I can no longer reproduce this

@winder winder closed this as completed Jul 8, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants