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

  • What does your stellar-core tables look like? signers is stellar-core, not horizon. – Johan Stén Feb 25 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 Feb 27 at 2:05
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>

  • 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 Feb 26 at 5:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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