Cardano DB Sync 11.0.0

This release introduces support for Alonzo.
It is compatible with Cardano Node 1.29.0.
Note that this release requires the database to be dropped and recreated.

⚠️ This release has known problems with rewards (see the known issues section). Work is continuing to deliver a fix for this issue as soon as possible.

The state snapshot files for this release can be found here:

Network	Link to snapshot
Testnet	https://updates-cardano-testnet.s3.amazonaws.com/cardano-db-sync/index.html#11/
Mainnet	https://update-cardano-mainnet.iohk.io/cardano-db-sync/index.html#11/

Documentation for restoring from these files available at state-snapshot.md.

Requires ghc-8.10.x to build.

Added

• Introduces Alonzo support.
• Database changes as per cardano-db changelog.
• Add run time validation that the on-disk schema matches what the app expects (#472).
• Add partial validation of Reward table.
• Add Alonzo (smart contracts) related Redeemer and Script tables.
• Add an epochNo columm to StakeRegistration/Deregistration tables.
• Add instantaneous rewards to the Reward table. This adds two new reward sources (treasury and reserves to the existing leader and member types) and makes the poolId NULLable (treasury and reserves rewards are not associated with a pool).
• For the EpochSyncTime table change the seconds column from double to Word64 and make it non-NULLable.
• For the Reward table, drop the epochNo column and relace it with earnedEpoch and spendableEpoch
• Add opCertCounter column to Block table.
• Add dataHash field to the TxOut table.
• Add a validation to ensure the sum of the AdaPots values per epoch is a constant (#718). - cardano-db-tool
• Add reporting functionalities (balance, teansactions, reward history, latest rewards). - cardano-db-tool

Improved

• Extend ProtocolParams and EpochParams tables for Alonzo.

Removed

• Drop OrphanedRewrd table (because it was incomplete can cannot be fixed).

Resolved

• Fix utxo_view defined in schema (#744).

Known issues

• Unhandled DCertGenesis certificate #290
• Missing staking rewards #683
• db-sync makes a rollback after using RESTORE_SNAPSHOT #784
  • Please use the below workaround for this issue:
    Modify docker-compose‧yml to add the following elements:

services:
  cardano-db-sync:
    working_dir: /var/lib/cdbsync
    volumes:
      - db-sync-tmp:/tmp

volumes:
  db-sync-tmp:

Documentation

Cardano DB Sync Overview
Building and Running the Cardano DB Sync Node
Schema Management
Validation
The Plug-in System
State snapshot

Platforms

• Linux 64-bit
• Docker

Sign off

Role	Approval
Technical Lead	✔️
QA Engineer	✔️
Ops	⏳
Release Manager	✔️