Outputs are lost in pending transactions

[Keith-CY]

Outputs are missing when the transaction is pending and appear when the transaction is committed.

Pending

Committed

[Keith-CY]

Address, capacity are not parsed in the pending transaction

[rabbitz]

Related PRs:

nervosnetwork/ckb-explorer#1389
nervosnetwork/ckb-explorer#1406

1. outputs lost

When creating a new cell output, the cell has not yet been stored in the database because the validation has not passed. Therefore, when storing the associated cell data, the CellDatum primary key cell_output_id is nil, and the database cell_output_id is used to auto-increment and store. However, the auto-incremented cell_output_id conflicts with the old data cell_output_id in the database, resulting in failure to create the output.

https://github.com/nervosnetwork/ckb-explorer/blob/develop/app/jobs/import_transaction_job.rb#L69

2. unable to decode address

When creating a cell input, you need to find previous_output, and the associated address is saved in previous_output. But cannot find corresponding cell output, maybe the transaction contains the cell output has not been processed, so add current transaction to pending list, and wait for future processing.

https://github.com/nervosnetwork/ckb-explorer/blob/develop/app/jobs/import_transaction_job.rb#L84
https://github.com/nervosnetwork/ckb-explorer/blob/develop/app/jobs/import_transaction_job.rb#L125