6
votes
Accepted
Cardano DB Sync as Service (running on background) on Ubuntu
Why are you running cardano-db-sync with cabal? You should just run cardano-db-sync or cardano-db-sync-extended.
And another question, more important: why are you running the service as root? This is ...
5
votes
Cardano Development
A great place to start is https://developers.cardano.org/.
The page provides a good overview about all Cardano development related topics.
Another great place to get started and learn is the cardano ...
- 3,131
5
votes
Accepted
Cardano-graphql: Hasura migration failing for me
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, ...
- 6,334
4
votes
Accepted
Confusion with cardano db sync schema and UTXO model
Thanks for your question.
send about 6000ada to bob then he sends the two UTXOs to bob i.e. 5000ada and 2000ada (total 7000 ada) and he receives a new UTXOs of 1000ada back, right?
Correct. For ...
- 131
4
votes
Accepted
I hear that Daedalus Is a Full Node Does That Mean I Can Set Up a DB Sync Server On Top of It?
Daedaldus consists of two processes, cardano-node and the wallet itself.
Yes, it is possible to connect a db-sync instance to the cardano-node.
3
votes
Cardano Development
You can join reddit channel for Cardano developers. You can also try to join the Plutus Pioneer Program but Haskell is must for it.
3
votes
Cardano Node + DB Sync + Graph QL vs. Blockfrost API
I've been on a bit of a journey with this so might be able to add some insight. We originally started by running our own node inside our Kubernetes cluster, alongside a cardano-wallet container that ...
- 324
3
votes
Block Producer vs Relay Node setup
If you want to get started with Cardano, setting up a stake pool can be a good start to learn the basics. You will be able to explore the different cli commands as well as the fundamentals of the ...
- 559
3
votes
Accepted
What is the numerator (supply) when calculating the pool saturation level?
I think what you're looking for is the formula used here to calculate the "circulating supply" from the UTXOs plus "withdrawable rewards" (rewards minus withdrawals). (You should ...
- 1,089
3
votes
Accepted
Is the Transaction Hash from block frost the same as the transaction id?
Yes, the tx hash and tx id are the same. The terminology is getting used interchangably.
- 754
3
votes
How can db-sync "match" a data_hash to specific outputs?
According to CDDL, the transaction output itself has a data_hash: https://github.com/input-output-hk/cardano-ledger/blob/37322df14d44d1370e8a72b677815d64a92baa00/alonzo/test/cddl-files/alonzo.cddl#L73
...
2
votes
Query latest pool of stake address from cardano db sync
The following will give you a list of pools with associated stake addresses.
SELECT ph.view AS "pool_id", sa.view AS "stake_address"
FROM stake_address sa
JOIN ...
- 6,334
2
votes
Accepted
Using rsync to copy database
Yes you can copy the files to speed up the database synchronization on a new freshly installed and configured node. Try to copy all the db folder and start the node.
- 559
2
votes
Accepted
Query UTxO with PostgreSQL (cardano-db-sync)
To get the basic utxo you would get from query utxo, you want a join from utxo_view to tx table.
SELECT * FROM utxo_view INNER JOIN tx ON tx.id = utxo_view.tx_id WHERE address = 'addr1...'
To get the ...
- 2,347
2
votes
Cardano Node: Connection reset by peer problem ---
Can you provide us with your node version : cardano-node --version
And the slot and epoch number at which your node stopped syncing. Thanks
The testnet recently hard-forked into Alonzo era and if your ...
- 304
2
votes
Cardano db sync sender and receiver address confusion
I am not 100 % sure of this answer;
The input is stored in tx_in table and the corresponding inputs addresses can be found by
select * from tx_out where tx_id in ( select tx_in_id from tx_in where ...
- 1,794
2
votes
Accepted
Mainnet – How to fix a frozen DB syncing?
Hey mate sorry I didn't see this earlier. As per your output logs, you are currently running Cardano-node correctly however, you are using the wrong version. Your current version is not the latest.
...
- 241
2
votes
Accepted
Why my cardano-node is now running a strange loop after an upgrade to a higher version?
Some SPOs in the community have reported that since version 1.29.x of cardano-node it requires at least 10GB of RAM to function properly. If your node has 8GB of RAM, maybe you should try adding swap (...
- 559
2
votes
Accepted
Listing all cardano tokens using cardano db sync
You can join the ma_tx_mint and ma_tx_out tables to utxo_view. This will only get you the policyid and asset name (hex encoded) for an asset though and you need to query the metadata server to get any ...
- 2,347
2
votes
Cardano Node + DB Sync + Graph QL vs. Blockfrost API
I think the best answer is that it depends on your specific use case.
A lot of people start their project using just Blockfrost as they do not want to invest a lot of resources into their ...
- 6,334
2
votes
how to convert an "asset32type" to string?
The above answer does a great job of explaining what it is, but doesn't answer how you get the value as a string. To pull the value as hex (which is the only thing that makes sense for a policy hash ...
- 2,347
2
votes
Accepted
how to convert an "asset32type" to string?
An asset32type is a raw Postgres octet string, but limited to a maximum of 32 bytes. It is defined in schema/migration-1-0004-20201026.sql as:
CREATE DOMAIN asset32type AS bytea CHECK (octet_length (...
2
votes
Accepted
cardano-db-sync error
Make sure you are using the right config file. The error is indicating that the config file you are using does not have the NetworkName parameter.
- 83
2
votes
Accepted
Cardano DB Sync - RTS Options
RTS opts are disabled by default in the db-sync build. To enable it add -rtsopts after -with-rtsopts=-N3 for the cardano-db-sync executable in the file cardano-db-sync/cardano-db-sync.cabal.
2
votes
setting postgresql for db-sync
should I edit permissions (i get a permission 600?
Yes, you need to reduce the permission down to 600. In addition you might also want to look at few things from a default Postgres deployment (...
- 873
2
votes
Disk Space of Cardano node & Cardano DB-sync
The database for db-sync at chain tip is over 100GB.
Syncing on epoch 254. So far in total they have taken 88 GB of disk space.
Yep and by the time you get to epoch 323 (current tip) the database ...
2
votes
Accepted
Disk Space of Cardano node & Cardano DB-sync
As an FYI, the mainnet node DB/chain itself is currently using 41GB of disk on Linux.
$du -h db
38G db/immutable
2.9G db/ledger
163M db/volatile
41G db
2
votes
DB Sync deleting blocks up to slot operation running for 10+ hours
I am the main dev on db-sync.
"Deleting 8751 blocks up to slot 55342638"
The message that is to be expected right after that is "Blocks deleted", but deleting 8751 blocks should ...
2
votes
Mainnet genesis block output off by 1,000,000 Lovelace + what is the test Ada from mainnet genesis?
The test ada entries was used for testing the redemption of ada from the genesis block (aka AVVM certificate process).
- 2,347
2
votes
Accepted
Understanding this transaction - why isn't it spending the full amount?
I think there might be a misunderstanding in the fact that a transaction has several "outputs" - and those outputs are called "UTXO"'s (as long as they are unspent; hence "...
- 1,089
Only top scored, non community-wiki answers of a minimum length are eligible