Horizon returns 404 when trying to query accounts/{ID}/payments

Question

I've spun up a Stellar horizon server using the Docker image mentioned in the repo below

https://github.com/stellar/docker-stellar-core-horizon

It spins up just fine but I don't get any payment history. ie. this URL returns a 404

https://myserver.com/accounts/GCOSW43SJO3V3M3B7APU6OEVB3CY2L4INUUWTNHDNLGOSNVF3JHRSMLB/payments

while it works fine for

https://horizon.stellar.org/accounts/GCOSW43SJO3V3M3B7APU6OEVB3CY2L4INUUWTNHDNLGOSNVF3JHRSMLB/payments

Removing payments makes it work and I get account info just fine

https://myserver.com/accounts/GCOSW43SJO3V3M3B7APU6OEVB3CY2L4INUUWTNHDNLGOSNVF3JHRSMLB

The only issue i see other having is

Horizon server returning 404 for GET /accounts/{id}/payments

which mentions that INJEST needed to be enabled, but it looks like it already is default true in the docker. Other queries run just fine such as ledgers/ and accounts/

Any advice?

Answer 1

Had the same problem but it seems I figured it out. If you want the full history available on your horizon you need to do the following.

Run your stellar-core with CATCHUP_COMPLETE=true. On your horizon side you need to manually tell it to ingest historical ledgers. Just starting horizon with --ingest=true is not enough as it will only ingest ledgers that stellar-core currently processes. The steps to manually ingest history are as follows.

1. horizon db init initialized db schema
2. horizon db backfill NUM_LEDGERS set this slightly higher than the current ledger on stellar-core. This way it should back fill all the way to the beginning of history.
3. horizon --ingest=true Start your horizon with ingest=true to keep it up to date. Horizon can run while you are doing the db backfill in the background.

Maybe there is easier/better ways to do it but this is what worked for me. The docs all just mention --ingest=true but you really also need to do the db backfill for full/more complete history.

Answer 2

It's likely that the specific payments that you see in the public horizon instance are older than your oldest ingested ledger. By default, the docker image's stellar-core configuration will only fetch recent history.

You can verify this by fetching horizon's root element and checking the history_elder_ledger field. In https://horizon.stellar.org/ it's 1. In your own horizon this will probably be newer.

Stellar's core sample config contains some useful information: https://github.com/stellar/stellar-core/blob/master/docs/stellar-core_example.cfg#L220

Horizon's admin overview can also help: https://github.com/stellar/go/blob/master/services/horizon/internal/docs/reference/admin.md#correcting-gaps-in-historical-data