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

Horizon endpoint /accounts?asset=<USDC> getting 503's #4632

Closed
jcx120 opened this issue Oct 3, 2022 · 0 comments · Fixed by #4635
Closed

Horizon endpoint /accounts?asset=<USDC> getting 503's #4632

jcx120 opened this issue Oct 3, 2022 · 0 comments · Fixed by #4635
Assignees

Comments

@jcx120
Copy link

jcx120 commented Oct 3, 2022

What version are you using?

Horizon SDF 2.21

What did you do?

503 error after running curl https://horizon.stellar.org/accounts/?asset=USDC%3AGA5ZSEJYB37JRC5AVCIA5MOP4RHTM335X2KGX3IHOJAPP5RE34K4KZVN

What did you expect to see?

a working response

What did you see instead?

503 error

More Context:

Assets such as USDC, AQUA will have unbounded accounts associated with them. This endpoint should only return the first 10 records with paging support but is timing out.

graphana metrics seems to indicate DB query timeout/potential saturation risk:
https://grafana.stellar-ops.com/d/vHv3RMNMz/horizon-dashboard-bartek?orgId=1&var-environment=prd&var-cluster=blue&var-network=pubnet&var-route=All&var-interval=5m&from=now-6h&to=now

@jcx120 jcx120 moved this to Backlog in Platform Scrum Oct 3, 2022
@jcx120 jcx120 moved this from Backlog to Next Sprint Proposal in Platform Scrum Oct 3, 2022
@jcx120 jcx120 moved this from Next Sprint Proposal to Backlog in Platform Scrum Oct 3, 2022
@jcx120 jcx120 moved this from Backlog to Next Sprint Proposal in Platform Scrum Oct 4, 2022
@jcx120 jcx120 moved this from Next Sprint Proposal to In Progress in Platform Scrum Oct 5, 2022
@bartekn bartekn self-assigned this Oct 12, 2022
@bartekn bartekn moved this from In Progress to Needs Review in Platform Scrum Oct 12, 2022
Repository owner moved this from Needs Review to Done in Platform Scrum Oct 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Done
Development

Successfully merging a pull request may close this issue.

2 participants