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');