Cardano Updates

The previous error messages like "No instance: HasBlueprintDefinition x"
mimicked standard GHC instance resolution errors, which was misleading.
Users would search for missing instances when the actual problem was
that type families cannot be evaluated with abstract type variables.

This change:
- Replaces "No instance" wording with clearer "Cannot unroll type" message
- Lists all possible causes (abstract type, missing instance, missing Generic)
- Adds specific guidance about DefinitionsFor with polymorphic constraints
- Improves RepIsStuckError with actionable suggestions

Closes #6956

feat: integration testing suite for gateway + hermes, minor fixes + improvements for caribic

Removes Flyway migration files containing optional database indices that
were previously commented out. These indices will now be applied by an
external watchdog service after the node reaches the blockchain tip,
rather than during the initial sync process.

Removed migration files:
- V1.0_2500_0__search_indices.sql (6 search optimization indices)
- V1.0_500_0__rosetta_app_transaction.sql (2 transaction indices)
- V1.0_600_0__rosetta_app_withdrawal.sql (2 withdrawal indices)
- V1.0_900_0__rosetta_app_address_utxo.sql (1 address_utxo index)

Rationale:
These indices improve query performance but significantly slow down the
initial blockchain sync when applied early. By deferring their creation
until after sync completion, we achieve faster time-to-tip while still
maintaining optimal query performance once the system is operational.

The PostgreSQLIndexCreationMonitor tracks index creation progress via
pg_stat_progress_create_index, ensuring the sync status accurately
reflects the APPLYING_INDEXES stage when the watchdog applies these
indices post-sync.

Related to sync status monitoring implementation that reports three stages:
- SYNCING: Initial blockchain sync
- APPLYING_INDEXES: Tip reached, indices being created
- LIVE: Fully operational with all indices applied

Introduces enhanced sync status reporting that monitors both blockchain
synchronization and database index creation progress. This ensures accurate
operational readiness reporting for load balancers and external clients.

Key changes:
- Add IndexCreationMonitor interface with PostgreSQL and H2 implementations
- PostgreSQL monitor queries pg_stat_progress_create_index system view
- H2 monitor provides NOOP implementation for development/testing
- Extract sync status logic into dedicated SyncStatusService
- Add SyncStage enum with three stages: SYNCING, APPLYING_INDEXES, LIVE
- Update NetworkServiceImpl to use new SyncStatusService

Sync status behavior:
- SYNCING: Node has not reached blockchain tip yet (synced=false)
- APPLYING_INDEXES: Node at tip but indexes being created (synced=false)
- LIVE: Fully synced with all indexes applied (synced=true)

The service reports synced=true only when both conditions are met:
1. Node reached blockchain tip (within allowed slot delta)
2. No database indexes are currently being created

This allows external watchdog services to monitor currentIndex vs targetIndex
to trigger index creation, while load balancers use the synced field to
determine when the service is ready for production traffic.

Signed-off-by: Roland Kuhn <[email protected]>

fix links

* feat: add alias support to connection pair records and related services

* feat: enforce alias as a required field in connection pair records and related services

* test: add validation for missing identifier alias when fetching connection by id

* feat: update connection migration scripts to use alias directly and define IdentifierMetadataRecordProps type

* feat: update IdentifierMetadataRecordProps to use CreationStatus enum

* chore: update type

This corresponds to cardano-node 10.6.x. Fix resulting compiler errors.

Signed-off-by: Matthieu Pizenberg <[email protected]>

[EC Api] - Evolution SDK: a new era for Cardano development