Webux Lab

By Studio Webux

Troubleshoot Cardano with DB Sync and SMASH

TG
Tommy Gingras Studio Webux 2023-01-21

Commands to troubleshoot Cardano Pool using SMASH API

See below to use DB Sync directly

BECH_32_POOL_ID="pool1n3sjq3qvu5vvcd6aud6ndcwq7r3ghmkafcg60gznlwfrk2ucxku"

pool_id=$(curl https://smash.cardano-mainnet.iohk.io/api/v1/exists/${BECH_32_POOL_ID} | jq -r .poolId)

echo "This next command fails often..."
curl https://smash.cardano-mainnet.iohk.io/api/v1/errors/${BECH_32_POOL_ID} | jq .

curl https://smash.cardano-mainnet.iohk.io/api/v1/metadata/${BECH_32_POOL_ID}/${pool_id} | jq .

Metadata:

Based on my experimentation, url shortening services return a 301 and it seems unhappy with it…
So I recommend :
Create a repository on github (Use the ticker name) and use something like: meta.json for the meta file.
Or use any object storage (aws S3) with or without a domain name.

The goal is to obtain an URL length of 64 characters max.


DB Sync

select *
FROM pool_metadata_ref
WHERE pool_id = (SELECT id
                FROM pool_hash
                WHERE view = 'pool1n3sjq3qvu5vvcd6aud6ndcwq7r3ghmkafcg60gznlwfrk2ucxku');

select *
FROM pool_offline_data
WHERE ticker_name like 'ANVIL';

select *
FROM pool_offline_data
WHERE pool_id = (SELECT id
                FROM pool_hash
                WHERE view = 'pool1n3sjq3qvu5vvcd6aud6ndcwq7r3ghmkafcg60gznlwfrk2ucxku');

select *
FROM pool_offline_fetch_error
WHERE pool_id = (SELECT id
                FROM pool_hash
                WHERE view = 'pool1n3sjq3qvu5vvcd6aud6ndcwq7r3ghmkafcg60gznlwfrk2ucxku');

select *
FROM pool_update
WHERE hash_id = (SELECT id
                FROM pool_hash
                WHERE view = 'pool1n3sjq3qvu5vvcd6aud6ndcwq7r3ghmkafcg60gznlwfrk2ucxku');

select *
FROM pool_owner
WHERE addr_id = (select reward_addr_id
                FROM pool_update
                WHERE hash_id = (SELECT id
                                FROM pool_hash
                                WHERE view = 'pool1n3sjq3qvu5vvcd6aud6ndcwq7r3ghmkafcg60gznlwfrk2ucxku')
                LIMIT 1);

select *
from slot_leader
where pool_hash_id = (SELECT id
                    FROM pool_hash
                    WHERE view = 'pool1n3sjq3qvu5vvcd6aud6ndcwq7r3ghmkafcg60gznlwfrk2ucxku');

Search