Questions tagged [cardano-db-sync]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
15 views

how to convert an "asset32type" to string?

i want to convert an "asset32type" to a string, reason being the datatype in the "name" column of dbsync's multi_asset table is "asset32type". what is an "...
0
votes
0answers
7 views

Can I manually install cardano-graphql using local data?

I'm running a relay node and have dbsync pushing data into postgresql. To build the graphql data, do I have to use the weekly restore snapshot as described in the github page for cardano-graphql or ...
0
votes
1answer
19 views

How to Remove Burned NFTs from SQL Output

I am querying the Cardano Postgres DB and can't figure out how to remove NFTs (multi-assets) that have been burned. In the SQL query below, I am selecting the mint transactions for an asset ...
0
votes
2answers
42 views

cardano-db-sync error

When following the instruction here https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/building-running.md I get an error at the last line PGPASSFILE=config/pgpass-mainnet db-sync-node/...
0
votes
0answers
14 views

cardano-db-sync table link diagram?

Is a diagram showing cardano-db-sync table links available? i'm aware of the schema.md file, was after something more visual.
1
vote
3answers
37 views

About slot battles and db sync

I wanted a way to check if a pool is having some sort of slot dispute with somebody else's pool for the right to mine a block. I couldn't find a solution for that, maybe using dbsync I don't know ...
0
votes
1answer
15 views

Query next epoch from postgresql

How can I get the next Epoch.No using Postgresql. If I use 'SELECT no FROM epoch ORDER BY no desc limit 1' , it returned last epoch/currentEpoch, if I want to receive the next Epoch.No, what should ...
1
vote
1answer
68 views

Stake pool blockchain sync is incredibly slow

Has anyone synced a node lately? It has been 3 days and I've only reached 75% of the tip. This is much slower than a few months ago. I'm currently only connected to the IOHK North America relay with a ...
0
votes
1answer
45 views

cardano db sync stuck at epoch 299

I have been stuck at epoch 299 for a long time now, it randomly stops around hash e15.. or sometimes gets lucky and stop at around e1f... I have 16g ram, 16g swap, i7 octa core, ubuntu 20.04.2 lts my ...
0
votes
0answers
56 views

version `GLIBC_2.33' not found

trying to install nix (on a clean fedora 35 server), getting this error, help! /nix/store/sbbifs2ykc05inws26203h0xwcadnf0l-glibc-2.32-46/lib/libc.so.6: version `GLIBC_2.33' not found (required by /usr/...
2
votes
2answers
140 views

Cardano Node + DB Sync + Graph QL vs. Blockfrost API

I've been contemplating the value of essentially running all your own infrastructure by deploying Cardano node, along side DB Sync and exposing it through Cardano GraphQL. I like the idea of building ...
0
votes
1answer
95 views

How to search for an NFT asset name?

Let's say, I have created an asset with name 'xyz' and I want to search for all the nfts with this asset name on the chain. How and where do I do that ?
2
votes
1answer
127 views

Extracting metadata info of cardano tokens

I am currently working with cardano-db-sync and I am doing research to extract the metadata of all the native tokens. I found out the policy id and asset name can be extracted from cardano-db-sync but ...
1
vote
2answers
107 views

Sync DB mainnet stuck

I used the great guidance on https://developers.cardano.org/docs/get-started/running-cardano to step by step sync with the Cardano mainnet. Everything went fine and i was almost done untill 2 weekish ...
3
votes
1answer
60 views

Why my cardano-node is now running a strange loop after an upgrade to a higher version?

Lately, after a node upgrade to a higher version (1.30.1), my Block-Producing (BP) node will "stay" in the "start" phase for about 45 minutes making a strange loop by switching to ...
2
votes
1answer
98 views

Listing all cardano tokens using cardano db sync

I am currently starting out with cardano db sync and wanted to ask if it is possible to obtain all native and nft tokens and their metadata using cardano db sync? could someone guide me? I can't seem ...
1
vote
1answer
53 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
132 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 { &...
2
votes
1answer
81 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
11 views

cardano-cli query return epoch = null

When I run cardano-cli query tip --testnet-magic 1097911063 I recieve: { "epoch": null, "hash": "b89d3cdc3ca3e16b6a065668b878116b297a788bfce29f904d4840cf2b69fd34", "...
5
votes
1answer
159 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 ...
2
votes
1answer
48 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
55 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 '...
3
votes
2answers
55 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 ...
4
votes
1answer
40 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...&...
2
votes
1answer
122 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 ...
3
votes
1answer
116 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
79 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-...
4
votes
1answer
142 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
78 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?
4
votes
2answers
82 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?
3
votes
1answer
130 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 ...
7
votes
1answer
73 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: ...