iotaledger / iota / 17568988330

63%

Build Type

push

github

Committed by web-flow

Commit Message

feat(indexer): Merge optimistic indexing feature branch to develop (#8460)

# Description of change

The PR introduces optimistic indexing feature to iota-indexer.

From now, transactions and it's effects will be indexed immediately
after they are executed through the indexer, without waiting for the
checkpoint.

 - Transactions will be stored in new `optimistic_transactions` table
 - Objects will be stored in already existing `objects` table
- `tx_global_order` table will be used to store indexing order (could be
used later to serve consistent paginated queries) and also as a
synchronization table to avoid race conditions between optimistic and
checkpoint indexing

Data from new `optimistic_transactions` table will be read by simple
queries like: `get_transaction_block`, `multi_get_transaction_blocks`,
`get_events`.
It will also be used by TransactionBuilder API, allowing user to
construct follow-up transactions without need to wait for checkpoint
indexing of previous transactions.

It will not be read by more complex (filtered/paginated) queries like:
`query_transaction_blocks`.

## Links to any relevant issues

fixes [#6606](https://github.com/iotaledger/iota/issues/6606)

## How the change has been tested

- [x] Basic tests (linting, compilation, formatting, unit/integration
tests)
- [x] Patch-specific tests (correctness, functionality coverage)

### Infrastructure QA (only required for crates that are maintained by
@iotaledger/infrastructure)

- [x] Synchronization of indexer from scratch after DB reset on staging
env
- [ ] Synchronization of the indexer from genesis for a network
including migration objects.
- [x] Restart of indexer synchronization locally without resetting the
database.
- [x] Restart of indexer synchronization on a production-like database.
- [x] Deployment of services using Docker. _(running iota-indexer
container on staging env)_
- [x] Verification of API backward compatibility.

### Release Notes

- [ ] Protocol:
- [ ] Nodes... (continued)

Run Details

0 of 1368 new or added lines in 17 files covered. (0.0%)

78 existing lines in 17 files now uncovered.

228751 of 348305 relevant lines covered (65.68%)

2262949.27 hits per line