跨链交易发起：0x0bbbcf153f17ec0e1f12d698bbc64f9d242bc1cd1312dd5f34febf0e6cb6601a

1. 根据tx_hash查看表l2_to_l1_logs，得到所在的miniblock_number为15841
2. 根据上面的miniblock_number，根据number查看表miniblocks

   select * from miniblocks where number=15841;

3. 得到当前跨链交易所在l1_batch_number为7670
4. 根据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

5. 根据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

6. 根据confirmed_eth_tx_history_id得到CommitBlocks对应交易hash

   select 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

7. 同理查询eth_prove_tx_id和eth_execute_tx_id得到对应的交易hash

版权属于：区块链中文技术社区 / 转载原创者

本文链接：https://bcskill.com/index.php/archives/1853.html

相关技术文章仅限于相关区块链底层技术研究，禁止用于非法用途，后果自负！本站严格遵守一切相关法律政策！