user953: I am having trouble setting up cardano-graphql service. It occurs when Hasura run the migration script to create a bunch a views on top of tables in cardan-db-sync. There error is:
42703] FatalError: column block.merkle_root does not exist
Sure enough I go login to postgres and see that merkle_root is not a column in the block table.
I am running testnet cardano node and testnet db-sync.
I have a multinode setup using nix-build:
Node1: cardano-node, cardano-db-sync-extended (v 9.0)
Node2: cardano-node, cardano-graphql (v 4.0)
Process that runs migration:
cardano-graphql/nix-build/hasura-cli/bin/hasura --skip-update-check --project /nix/store/is2s0kbvbxz04ih2ixzsg7kkyrmhizib-cardano-graphql-4.0.0/packages/api-cardano-db-hasura/hasura/project --endpoint http://localhost:8090 migrate apply --up all

My Hasura start stript:
export CARDANO_NODE_CONFIG_PATH="/home/ubuntu/cardano-my-node/testnet-config.json"
export HASURA_CLI_PATH=${PWD}/nix-build/hasura-cli/bin/hasura
export HASURA_URI=http://localhost:8090
export GENESIS_FILE_BYRON=${PWD}/config/network/testnet/genesis/byron.json
export GENESIS_FILE_SHELLEY=${PWD}/config/network/testnet/genesis/shelley.json
export POSTGRES_DB=testnet
export POSTGRES_HOST=*****
export POSTGRES_PASSWORD****
export POSTGRES_PORT=*****
export POSTGRES_USER=****
./nix-build/cardano-graphql/bin/cardano-graphql


user28: Can you make absolutely sure you are using the cardano-db-sync release 9.0? The specific field merkle_root has been removed only some days ago and this change is still only in the master branch, unreleased.

953: <p>I am having trouble setting up cardano-graphql service. It occurs when Hasura run the migration script to create a bunch a views on top of tables in cardan-db-sync. There error is:</p>
<p><code>42703] FatalError: column block.merkle_root does not exist</code></p>
<p>Sure enough I go login to postgres and see that merkle_root is not a column in the block table.</p>
<p>I am running testnet cardano node and testnet db-sync.</p>
<p>I have a multinode setup using nix-build:</p>
<p>Node1: <code>cardano-node, cardano-db-sync-extended (v 9.0)</code></p>
<p>Node2: <code>cardano-node, cardano-graphql (v 4.0)</code></p>
<p>Process that runs migration:</p>
<pre><code>cardano-graphql/nix-build/hasura-cli/bin/hasura --skip-update-check --project /nix/store/is2s0kbvbxz04ih2ixzsg7kkyrmhizib-cardano-graphql-4.0.0/packages/api-cardano-db-hasura/hasura/project --endpoint http://localhost:8090 migrate apply --up all
</code></pre>
<p>My Hasura start stript:</p>
<pre><code>export CARDANO_NODE_CONFIG_PATH=&quot;/home/ubuntu/cardano-my-node/testnet-config.json&quot;
export HASURA_CLI_PATH=${PWD}/nix-build/hasura-cli/bin/hasura
export HASURA_URI=http://localhost:8090
export GENESIS_FILE_BYRON=${PWD}/config/network/testnet/genesis/byron.json
export GENESIS_FILE_SHELLEY=${PWD}/config/network/testnet/genesis/shelley.json
export POSTGRES_DB=testnet
export POSTGRES_HOST=*****
export POSTGRES_PASSWORD****
export POSTGRES_PORT=*****
export POSTGRES_USER=****
./nix-build/cardano-graphql/bin/cardano-graphql
</code></pre>
 28: <p>Can you make absolutely sure you are using the cardano-db-sync release 9.0? The specific field <code>merkle_root</code> <a href="https://github.com/input-output-hk/cardano-db-sync/commit/f4988e3908b04d356d55bb4e37c2e66ef27f5924" rel="noreferrer">has been removed only some days ago</a> and this change is still only in the master branch, unreleased.</p>
