We changed our privacy policy. Read more.

Questions tagged [cardano-db-sync]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
22 views

Cardano db sync sender and receiver address confusion

I am needing help with this. i queried the rows whose tx_id = 133903 from tx_out table from postgres. select * from tx_out where tx_id = 133903; and i got two rows having two different index 0 and 1. ...
2
votes
1answer
27 views

Mainnet – How to fix a frozen DB syncing?

I've been trying to sync with the Cardano blockchain in order to use CLI wallet on macOS Big Sur 11.6. But syncing is frozen at epoch 289 on block 6,236,059. cardano-cli query tip --mainnet { &...
1
vote
1answer
23 views

Query all the transaction details from a given block using cardano db sync

Can someone help out with how can i query the transaction details from a block using cardano db sync table? I actually need fields like epoch no, date of transaction, stake address, pool and the ...
0
votes
0answers
4 views

cardano-cli query return epoch = null

When I run cardano-cli query tip --testnet-magic 1097911063 I recieve: { "epoch": null, "hash": "b89d3cdc3ca3e16b6a065668b878116b297a788bfce29f904d4840cf2b69fd34", "...
3
votes
1answer
38 views

Block Producer vs Relay Node setup

Can only Pool operators run Producer nodes? What is the difference between the producer and relay from a setup point and where to get the specifics for each on installing? Being new it's hard to know ...
1
vote
1answer
19 views

Using rsync to copy database

I am spinning up another pool. Can I just rsync the database folder, after everything else has been setup? They're on the same 10GBe switch, so I will try anyway... but just wondering.
0
votes
1answer
22 views

cardano-db-sync build instructions?

The ones I found seems to be out of date. https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/building-running.md Warning: Requested index-state 2021-07-02T00:00:00Z is newer than '...
2
votes
1answer
21 views

Can we dump database of db-synch and use it for initialising a fresh db-synch instance?

Db-sync takes about 48 hours to follow the tip, starting from a fresh installation fully. Is there a way to improve the sync time? Is it possible to dump the database and transfer it to a fresh ...
3
votes
1answer
29 views

How much time does Cardano-graphql take to initialize?

I had configured db-sync and it is synchronizing. I had also started the Cardano-graphql. However, the message seems to be struck at "msg":"Initializing. This can take a few minutes...&...
1
vote
0answers
41 views

Query UTxO with PostgreSQL (cardano-db-sync)

How can I query the last UTxO from an address on PostgreSQL (I used cardano-db-sync) like I would do using cardano-cli: cardano-cli query utxo --address ...
2
votes
1answer
56 views

Cardano Node: Connection reset by peer problem ---

My cardano node was running normal and all of sudden I get this error, ErrorPolicySuspendPeer (Just (ApplicationExceptionTrace (MuxError (MuxIOException Network.Socket.recvBuf: resource vanished (...
1
vote
0answers
28 views

db-sync makes a rollback after using RESTORE_SNAPSHOT

After the import of the snapshot finishs it rolls back to genisis and starts over cardano-db-sync2_1 | ALTER TABLE cardano-db-sync2_1 | ALTER TABLE cardano-db-sync2_1 | ALTER TABLE cardano-db-...
2
votes
1answer
74 views

Confusion with cardano db sync schema and UTXO model

I am confused with the tx_in and tx_out schema on Cardano dbsync and the transaction process as a whole. For example: Alice has 10000 ADA distributed as 3000, 5000 and 2000 ADA in three different ...
1
vote
1answer
48 views

Query latest pool of stake address from cardano db sync

How do i query latest pool of all the stake address when using cardano db sync?
3
votes
2answers
76 views

Cardano Development

I am a software developer. I wanted to learn Cardano development so for that where should I start and what technologies are required?
2
votes
1answer
73 views

Error running cardano-db-sync in docker-compose file as devcontainer

I have a docker-compose.yml file which I use as a devcontainer for VSCode. Part of my application requires access to cardano-db-sync so that I can query the database for transaction information. I am ...
6
votes
1answer
49 views

Cardano-graphql: Hasura migration failing for me

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: ...