From time to time I encounter transactions which contain UTXOs associated to script addresses with datum hashes for which no corresponding entries are available in the
datum table of a fully-synched cardano-db-sync postgres.
Here is a randomly selected example:
select data_hash from tx_out where tx_id = (select id from tx where hash = '\xfc6536534b03f818494f21698994d387c879a121b263153a06975d056d9cf13e');
This will output
select * from datum where hash = '\x4a664c584e552af70dcc255921811b5f62637fd781a43e5c289d9e571a227117';
finds 0 rows.
As datums values are included in the witness set of the corresponding transactions I would expect all hashes to have a matching entry in the
- Is this a bug on cardano-db-sync?
- Is there any other way to retrieve those datum values directly, maybe by using cardano-cli to query the blockchain directly?