0

I have set up private Stellar Core and Horizon with 2 nodes. I am following this tutorial. I am first creating an account and then I am executing the code below. It is showing select failed: pq: relation "signers" does not exist" on the Horizon console.

Attached is the screenshot of error. I am a newbie. Kindly suggest how I can resolve the issue. error image here

  const HORIZON_ENDPOINT = 'http://127.0.0.1:8000';
  Stellar.Network.use(new Stellar.Network(NETWORK_PASSPHRASE));
  var opts = new Stellar.Config.setAllowHttp(true);
  var server = new Stellar.Server(HORIZON_ENDPOINT, opts);

  let sourceKeys = Stellar.Keypair.fromSecret("SCZ5WJ7ZTEM7CS3KDM7KZSI7YEBXMU52JJV7ETRUTGCDI7WFWRAXP3KF");
        console.log("1");
        // loading root account
        server.loadAccount(sourceKeys.publicKey())
        .then(function(sourceAccount) {

            let txn = new Stellar.TransactionBuilder(sourceAccount)
                        .addOperation(
                            Stellar.Operation.createAccount({
                            destination: pk,
                            startingBalance: "100"}))
                        .addMemo(Stellar.Memo.text('Test Transaction'))
                        .build();
            txn.sign(sourceKeys);
            return server.submitTransaction(txn);
            })
        .then(function(result) {
            console.log({"Msg" : `SUCCESS : ${JSON.stringify(result)}`})
        })
        .catch(function(error) {
            console.error('Something went wrong!', error);
            console.log({"Msg" : `ERROR in inner catch statement`})
        });
  • could you check 2 things? (1) Stellar-Core has a "Sync!" (running) status; (2) Horizon has its DB initialized – cesarm Apr 20 at 10:36
  • @cesarm you can checkout this url pasteboard.co/IaZS7eq.png which can give a confirmation that the stellar-core are sync – Suman Raj Apr 20 at 10:49
  • @cesarm check this liink that whether my horizon db is initialised pasteboard.co/IaZSPdD.png – Suman Raj Apr 20 at 10:50
  • 1
    The signers table was in the stellar-core database and deprecated + removed in stellar-core 10.3.0 (it's now a column in accounts). An upgrade of stellar-horizon to v0.17.4 (or downgrade stellar-core to 10.2) should fix it. – sui Apr 20 at 10:59
  • Ah, and the stellar-horizon repository has moved. If you followed the link in that tutorial you probably installed v0.11.1 here is the actual release github.com/stellar/go/releases/tag/horizon-v0.17.4 – sui Apr 20 at 11:03

Your Answer

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

Browse other questions tagged or ask your own question.