跨链交易发起:0x0bbbcf153f17ec0e1f12d698bbc64f9d242bc1cd1312dd5f34febf0e6cb6601a
- 根据
tx_hash
查看表l2_to_l1_logs
,得到所在的miniblock_number
为15841
- 根据上面的
miniblock_number
,根据number
查看表miniblocksselect * from miniblocks where number=15841;
- 得到当前跨链交易所在
l1_batch_number
为7670
- 根据
l1_batch_number
,以number
查看l1_batches
表select number,is_finished,eth_commit_tx_id,eth_prove_tx_id,eth_execute_tx_id from l1_batches where number=7670;
得到
number | is_finished | eth_commit_tx_id | eth_prove_tx_id | eth_execute_tx_id
--------+-------------+------------------+-----------------+-------------------
7670 | t | 41073 | 41148 | 41151
- 根据eth_commit_tx_id查询eth_txs,得到CommitBlocks对应交易信息
select nonce,contract_address,tx_type,has_failed,sent_at_block,tx_status,confirmed_eth_tx_history_id from eth_txs where id=41073 ORDER BY updated_at DESC limit 1;
nonce | contract_address | tx_type | has_failed | sent_at_block | tx_status | confirmed_eth_tx_history_id
-------+--------------------------------------------+--------------+------------+---------------+-----------+-----------------------------
41091 | 0x5e3e5f6ef0e21f0cf5b4c3acd3cf29740b1cbbd8 | CommitBlocks | f | | Done | 43194
- 根据
confirmed_eth_tx_history_id
得到CommitBlocks对应交易hashselect eth_tx_id,tx_hash,confirmed_at from eth_txs_history where id=43194 ORDER BY updated_at DESC limit 10;
eth_tx_id | tx_hash | confirmed_at
-----------+--------------------------------------------------------------------+----------------------------
41073 | 0x0b01e199877faef52b95477119f53bf546a2915bc903132331f41542e58da53d | 2023-09-18 03:50:19.059576
- 同理查询
eth_prove_tx_id
和eth_execute_tx_id
得到对应的交易hash