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 ...
user avatar
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 ...
user avatar
  • 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, ...
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 ...
user avatar
  • 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.
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.
user avatar
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 ...
user avatar
  • 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 ...
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 ...
user avatar
  • 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.
user avatar
  • 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 ...
user avatar
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 ...
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.
user avatar
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 ...
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 ...
user avatar
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 ...
user avatar
  • 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. ...
user avatar
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 (...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 (...
user avatar
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.
user avatar
  • 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.
user avatar
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 (...
user avatar
  • 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 ...
user avatar
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
user avatar
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 ...
user avatar
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).
user avatar
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 "...
user avatar
  • 1,089

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