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 ...
- 1,220
5
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 ...
- 354
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,753
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, ...
- 7,269
5
votes
db-sync "Killed" sometimes. Why?
db-sync has a rather high memory usage. We (I am one of the developers) are working on reducing it, but for now, the only solution is to provide more memory.
If you are running node on the same ...
- 2,415
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 ...
- 141
4
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,677
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.
- 2,415
4
votes
How to get number of delegators of a pool?
It seems the the table delegation also contains the delegation history, not only the delegation at current time?
Yes, that makes the delegation table a bit of a pain in the neck for something like ...
- 2,415
4
votes
db-sync "Killed" sometimes. Why?
Most likely it is killed because the server's RAM is exhausted. How much RAM does the server have? I assume it is running on mainnet.
You can double check with dmesg -T to see if it was really killed ...
- 1,220
3
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 ...
- 7,269
3
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.
- 145
3
votes
cardano-db-sync table link diagram?
There is an Entity Relationship Diagram (ERD) here
3
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,834
3
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 ...
- 7,269
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
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 ...
- 589
3
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,415
3
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
3
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,677
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,463
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.
- 804
3
votes
Accepted
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
...
3
votes
Accepted
How is Number Of Confirmations derived for a transaction?
Number of confirmations refers to how "deep" the block containing the transaction is in the chain, relative to the current tip. For example, if my transaction was included in block #10, then ...
- 3,629
3
votes
Accepted
What is your comfort level for Number Of Confirmations, and why?
I have not had to do this, but if I did, my level of comfort would depend on the amount in question. If it was US$20 I might want 2 confirmations whereas if it was US$20,000 I might want 20 ...
- 2,415
3
votes
Accepted
Querying a transaction by hash vs id
Fortunately, your query can be written more simply as:
select * from tx where hash = '\x28b492be2f733201ba3441d5d7d0fefc097c3deba3f299628680fae484293758' ;
Note that I have prepended "\x" ...
- 2,415
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.
- 589
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.
...
- 251
2
votes
Query all the transaction details from a given block using cardano db sync
Efficient manner is join.
select block.id as block_identifier,* from tx left join block on block.id=tx.block_index where tx.hash='\x{hash}';
Make sure you pay attention to not mixing ID fields.
Some ...
- 251
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 ...
- 329
Only top scored, non community-wiki answers of a minimum length are eligible