0

I have set up a private network with core & horizon, when creating accounts I am getting internal server error.

In horizon logs I am getting msg="select failed: pq: relation "signers" does not exist"

I did horizon db init and it was successful and follwing tables were created:

enter image description here

Also history_elder_ledger is not increasing. Have I missed something? Following data is in gorp_migrations table post db init.

enter image description here

Improve this question
2
  • What does your stellar-core tables look like? signers is stellar-core, not horizon.
    – Johan Stén
    Commented Feb 25, 2019 at 9:24
  • In the future, please copy output as text. This improves search-ability and helps people to answer your question. See stackoverflow.com/help/how-to-ask
    – Synesso
    Commented Feb 27, 2019 at 2:05

1 Answer 1

Reset to default
1

Error at Horizon = msg="select failed: pq: relation "signers" does not exist"

That is due to Horizon wants to get information from Core, as Horizon is a plug-in above Core. But the table "signers" does not exist at DB of Core yet. (Likely your Core DB is still empty, without any schema)

Initialize the DB at Core and you will get a number of tables:

stellar-core --newdb

After --newdb Core command, these tables are added / re-initialized at Core DB. (if successful)

enter image description here

(my Core is v9.2; v10 may vary a bit)

Also remember to initialize the history archive:

stellar-core --newhist <YOUR-HIST-NAME>

Improve this answer
1
  • 1
    Thanks @cesarm. I found this out. Apparently my stellar core version was very old or --new db command was unable to create signers table. Getting latest version and setting up helped me to set the required tables properly.
    – sweta
    Commented Feb 26, 2019 at 5:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.