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 ...
George - APEX Stake Pool's user avatar
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 ...
Thom's user avatar
  • 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 ...
eddex's user avatar
  • 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, ...
Marek Mahut - StakeNuts's user avatar
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 ...
Erik de Castro Lopo's user avatar
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 ...
spirois's user avatar
  • 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 ...
Samuel Leathers's user avatar
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.
Erik de Castro Lopo's user avatar
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 ...
Erik de Castro Lopo's user avatar
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 ...
George - APEX Stake Pool's user avatar
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 ...
Marek Mahut - StakeNuts's user avatar
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.
adjuric's user avatar
  • 145
3 votes

cardano-db-sync table link diagram?

There is an Entity Relationship Diagram (ERD) here
Kostas Dermentzis's user avatar
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 ...
raghu's user avatar
  • 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 ...
Marek Mahut - StakeNuts's user avatar
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.
Kuldeep Srivastava's user avatar
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 ...
baocontact's user avatar
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 ...
Erik de Castro Lopo's user avatar
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
MC_Brisbane - JUST Pool's user avatar
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).
Samuel Leathers's user avatar
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 ...
sean's user avatar
  • 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.
lambda's user avatar
  • 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 ...
Pedro Martins Timóteo da Costa's user avatar
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 ...
zhekson's user avatar
  • 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 ...
Erik de Castro Lopo's user avatar
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" ...
Erik de Castro Lopo's user avatar
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.
baocontact's user avatar
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. ...
Patrick Sturm's user avatar
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 ...
Patrick Sturm's user avatar
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 ...
Alain Magazin's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible