Assets not available for use #1034

SevenLiquor · 2024-07-19T02:17:02Z

SevenLiquor
Jul 19, 2024

hi！
Here's the problem.
My tapd has an asset that I can't use.

tapd:0.3.3 lnd:0.17.5 use litd start.
Yesterday I tried to transfer all the assets within a tapd.When I entered the tapcli assets balance I got 79997。

{
    "asset_balances":  {
        "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308":  {
            "asset_genesis":  {
                "genesis_point":  "9aac0f8149ef38f6af5ed809476350dabae89801699d17ebbfc821c6f17d0db7:2",
                "name":  "Phenix",
                "meta_hash":  "dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "output_index":  0,
                "version":  0
            },
            "balance":  "79997"
        }
    },
    "asset_group_balances":  {}
}

So I used a 79997 addr, but got an error.

2024-07-18 06:58:33.020 [INF] LITD: Handling gRPC request: /taprpc.TaprootAssets/SendAsset
2024-07-18 06:58:33.025 [INF] FRTR: Received to send request to 1 addrs: [TapAddr{id=47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308, amount=79997, script_key=0231c60f23b00ab663282775143a595d48adbd42e963e173a9b7a3cd9d0bd729bb}]
2024-07-18 06:58:33.026 [INF] FRTR: ChainPorter executing state: SendStateVirtualCommitmentSelect
2024-07-18 06:58:33.050 [INF] FRTR: Identified 2 eligible asset inputs for send of 79997 to 47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308
2024-07-18 06:58:33.050 [ERR] FRTR: Error evaluating state (SendStateVirtualCommitmentSelect): unable to fund address send: unable to select coins: failed to find coin(s) that satisfy given constraints; if previous transfers are un-confirmed, wait for them to confirm before trying again
2024-07-18 06:58:33.054 [ERR] RPCS: [/taprpc.TaprootAssets/SendAsset]: unable to fund address send: unable to select coins: failed to find coin(s) that satisfy given constraints; if previous transfers are un-confirmed, wait for them to confirm before trying again

I knew that this error meant that I didn't have enough assets for the payment, so I waited a while and then checked the tapcli assets list command.I got 2 results for a total of only 29997 amount

{
    "assets":  [
        {
            "version":  "ASSET_VERSION_V0",
            "asset_genesis":  {
                "genesis_point":  "9aac0f8149ef38f6af5ed809476350dabae89801699d17ebbfc821c6f17d0db7:2",
                "name":  "Phenix",
                "meta_hash":  "dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "output_index":  0,
                "version":  0
            },
            "amount":  "10000",
            "lock_time":  0,
            "relative_lock_time":  0,
            "script_version":  0,
            "script_key":  "02d938c31d88917f89bf007f91363e7a0fc7732fbee653cef4faefe6f3e1b11a47",
            "script_key_is_local":  true,
            "asset_group":  null,
            "chain_anchor":  {
                "anchor_tx":  "02000000000103f1a78030aaa0e5616eb7e66c2eec9fd9e3a118ef45f7f30a6a16cb199b16c8b50200000000ffffffff2b71edc295b963da75a0acea7dc7fce4f194400fa58e1e7bba69f43b465759d50200000000ffffffff329e06a8838d020f64c6d2899a89fef8742c1d06ccb35db228905580c2007c7e00000000000000000002e803000000000000225120068fab1446358f34de2efb8c797d55f295fb6f457b0c2a17c1a54dca3b92db83770800000000000022512059a4163bd5b8f37980eef995ba673edac7cf979d1e3f3a5191aeaeda1df7bb3a0140dbefefdd48be219e4151b711bc005437da8c7f0937f03a78a005bd5a15e05571b78fb589f3d3851e00b992f9f80a6d64e9fda5636fc467bbe76221369cd3052a0140ef8f30166ee75418c36f32a737f9f4e368b4e7c276d0959b6edee5d97a922549ae7b10aec874229ac112ed81163c8b6832b849363da7f767571a57d92427e41201400eafb4ef1b93910fe685eb34bee08c2457f2fa663c99c574c0c09b8ab75edf8d3e470cd785693f5ba05b3f9b23a6e663edbcd6e71d09cded13928fcac4c4e79a00000000",
                "anchor_block_hash":  "00000000000000000002001ebcf443ac2d72338a9a40210c6da5f8881af75b37",
                "anchor_outpoint":  "273feebe085b17de39408b1fba984d9301b94b99965fcbf5c8f7a32c3230a644:1",
                "internal_key":  "0237d21812535a92199c929e9ba456c9eb43de7c9a92861d69038e2c69f93325ff",
                "merkle_root":  "93dd20e68fa1377a9175e3934cf90cf4ed455ab32d76ff54a1bd9ebb0c16693b",
                "tapscript_sibling":  "",
                "block_height":  0
            },
            "prev_witnesses":  [],
            "is_spent":  false,
            "lease_owner":  "",
            "lease_expiry":  "0",
            "is_burn":  false
        },
        {
            "version":  "ASSET_VERSION_V0",
            "asset_genesis":  {
                "genesis_point":  "9aac0f8149ef38f6af5ed809476350dabae89801699d17ebbfc821c6f17d0db7:2",
                "name":  "Phenix",
                "meta_hash":  "dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "output_index":  0,
                "version":  0
            },
            "amount":  "19997",
            "lock_time":  0,
            "relative_lock_time":  0,
            "script_version":  0,
            "script_key":  "02c12b9d2a5957eb5e185f9c9306f33ed10636e7b54c76a675d0ecd51392ca6f67",
            "script_key_is_local":  true,
            "asset_group":  null,
            "chain_anchor":  {
                "anchor_tx":  "02000000000104a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb0400000000ffffffffa0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb000000000000000000c51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a82640100000000000000005317e33b22fe17dec5962e9d1eeba9c9ea3f2ff965bb729e9b7ac92b1e991ee501000000000000000003e803000000000000225120f1b451b13056ef4e93115e5db5e465c9b50972f704a20bafd24efca59932fce3e80300000000000022512001b33cffe0f4e2b4e1cfc20b15646f9ee5d786e711202b5f8f220ab851ee73f82e220000000000002251205a9e175380d1cae7ac1a1c404b441b472a94a74942a6a13b0c744fc334adbb660140cac452b551db50fabfaf7ea95a2987a1216960d17486bb3cd3ca38ab14e169704fb67673b8661ff0def731f6b6703d47c0878454f4ad2ca381c27ca67bb7d25e014005b729fe566a1a314ed550eed38d13ce4a80b9be759e9c77f0e257b56a7fb08500b7bda00b358bf9673dbb89c20780e0e7703e22e5b3c8db7400f8e29f5cf89501403670dcc4a08748e2a9bfe257fcd30a501c752e9aa77e9ae5dbe985b9baf1e62b913f906c934664d2fcfce88c83cb335319d3bebe8ffdee5792b0d66c5821ddd201408230b85ebe7bc91e6fcebedd88443b657049d6f51af3e8c609d060f35390ab010feefa207619a88499506c1048bed1faf7239d7b571e047fd73a195ba1ded32400000000",
                "anchor_block_hash":  "00000000000000000002083b03b70d941d09f3531e15aa82d5abe8b816fade4b",
                "anchor_outpoint":  "5252d4e329ab2dfd454a05257af170c833b2dd702298839df1e78f72fbb22ba9:0",
                "internal_key":  "020075dfec48b74d34db19682b08042e196c5413ecba01e3669cb7c5e2f58178ba",
                "merkle_root":  "66d3cf0a641aad28f189dbf687292958f426675d4778810bc58c2fb9d32b1f33",
                "tapscript_sibling":  "",
                "block_height":  0
            },
            "prev_witnesses":  [],
            "is_spent":  false,
            "lease_owner":  "",
            "lease_expiry":  "0",
            "is_burn":  false
        }
    ]
}

You can see that there is 50000 amount less compared to the balance command.
I inventoried the transaction flow of this tapd and found a record of the receipt of this asset。

        {
            "creation_time_unix_seconds":  "1720698321",
            "addr":  {
                "encoded":  "tapbc1qqqsqqspqqzzq3ldzgx5k9e7k7d6gmx3jkdmnjyped5nxt8c5gfnvygtmgz5qgcgqcss92qzpvnuqmul24ezwap5umf8v38x9sv796k8u3flalnrdya54z76pqss8mzfkpt5anc5ltcv38zm9faj9a5p0vf4sx2sm6pqarn2xrnwrx34pgplms6spssh2mnfwejhyum9wfcxxw309ucnxv3wxgenyt33xqujuwp58gurgdp5luy67w",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "amount":  "50000",
                "group_key":  "",
                "script_key":  "02a8020b27c06f9f5572277434e6d27644e62c19e2eac7e453fefe63693b4a8bda",
                "internal_key":  "03ec49b0574ecf14faf0c89c5b2a7b22f6817b13581950de820e8e6a30e6e19a35",
                "tapscript_sibling":  "",
                "taproot_output_key":  "59c609541c7e171a93dfd564d65f473ac53b546db9d171d9405c4ba84b271a46",
                "proof_courier_addr":  "universerpc://132.232.109.84:8444",
                "asset_version":  "ASSET_VERSION_V0"
            },
            "status":  "ADDR_EVENT_STATUS_COMPLETED",
            "outpoint":  "3fdbbe301bb6209f9140ab19cb263ec32a9f19abc8c81cb27b17b7f27dd9c7cb:1",
            "utxo_amt_sat":  "1000",
            "taproot_sibling":  "",
            "confirmation_height":  851678,
            "has_proof":  true
        }

I looked up the transaction log with the outpoint of this asset and can confirm that this asset is not being used.And I can find it in lnd's utxo.

"outpoint": "3fdbbe301bb6209f9140ab19cb263ec32a9f19abc8c81cb27b17b7f27dd9c7cb:1"

{
        "utxos": [
                {
                        "address_type": 4,
                        "address": "bc1p884ra8qn6638lad45uvmpes97pzsy70hfd990kjalj88nqxuwy6qf8eq49",
                        "amount_sat": 2892,
                        "pk_script": "512039ea3e9c13d6a27ff5b5a719b0e605f0450279f74b4a57da5dfc8e7980dc7134",
                        "outpoint": "7c544ae8d75ce31b67ab052f0f3accc5a0f9cb1c563effe587afcb8446b6a6ea:1",
                        "confirmations": 521
                },
                {
                        "address_type": 4,
                        "address": "bc1pt8rqj4qu0ct34y7l64jdvh688tznk4rdh8ghrk2qt396sje8rfrqgwxy5r",
                        "amount_sat": 1000,
                        "pk_script": "512059c609541c7e171a93dfd564d65f473ac53b546db9d171d9405c4ba84b271a46",
                        "outpoint": "3fdbbe301bb6209f9140ab19cb263ec32a9f19abc8c81cb27b17b7f27dd9c7cb:1",
                        "confirmations": 1146
                }
        ]
}

Answered by guggero

Jul 22, 2024

Okay, can you please do the following (if any step returns an error or does anything unexpected, please abort and report back instead of continuing!):

Make sure sqlite3 --version gives you a proper version (something like 3.45.3 2024-04-15 ..... and not an error).
Stop the node (full litd).
Open the sqlite database, running sqlite3 /data/user/0/io.bitlong/files/.tapd/data/mainnet/tapd.db
Paste the following three lines and press <enter>. You should not get an error, and no response other than a new sqlite> prompt, then it's successful:

update assets set spent = '1' where anchor_utxo_id = (select utxo_id from managed_utxos where lower(hex(outpoint)) = '44a630322ca3f7c8f5cb5f96994bb901934…

View full answer

SevenLiquor · 2024-07-19T02:17:34Z

SevenLiquor
Jul 19, 2024
Author

Other than that, I was able to find it in another place,`tapcli assets list --show_spent

{
    "assets":  [
        {
            "version":  "ASSET_VERSION_V0",
            "asset_genesis":  {
                "genesis_point":  "9aac0f8149ef38f6af5ed809476350dabae89801699d17ebbfc821c6f17d0db7:2",
                "name":  "Phenix",
                "meta_hash":  "dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "output_index":  0,
                "version":  0
            },
            "amount":  "50000",
            "lock_time":  0,
            "relative_lock_time":  0,
            "script_version":  0,
            "script_key":  "02a8020b27c06f9f5572277434e6d27644e62c19e2eac7e453fefe63693b4a8bda",
            "script_key_is_local":  true,
            "asset_group":  null,
            "chain_anchor":  {
                "anchor_tx":  "02000000000102c51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a82640200000000ffffffffc51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a826400000000000000000003e803000000000000225120b6e6545f2aed7320b5bace3de2d2e687e960de8e34845af5085dcc2d828e34e3e80300000000000022512059c609541c7e171a93dfd564d65f473ac53b546db9d171d9405c4ba84b271a46613d000000000000225120fc6fed431e001083f06a3e093b5a920fa2eb8ba570f852536d842d7f77333e060140651c5d7ccd5d18d3e554b7e7756910ed9f6c9ff8ba230b1ac74c55b8f1240ed1ac76a8ff095458990aa1c059bde17c1b8f30fb8200b2b05d76dc86a70eaff6560140748a5802e2d7fc2f2ebbe456b54abe61c9dfb52943a602e10db1ac024e6053708b8f0d55c9ca8347714f4ff47f47b458bf442f3d7c3737b246c8d051648ce59700000000",
                "anchor_block_hash":  "0000000000000000000043c6afbd46a6cfb97680732b9b367e21eaa313772298",
                "anchor_outpoint":  "3fdbbe301bb6209f9140ab19cb263ec32a9f19abc8c81cb27b17b7f27dd9c7cb:1",
                "internal_key":  "03ec49b0574ecf14faf0c89c5b2a7b22f6817b13581950de820e8e6a30e6e19a35",
                "merkle_root":  "d878a89062cde779d7adc17d260f253715e1a5ec08947f8366ea68ae2870818c",
                "tapscript_sibling":  "",
                "block_height":  0
            },
            "prev_witnesses":  [],
            "is_spent":  true,
            "lease_owner":  "",
            "lease_expiry":  "0",
            "is_burn":  false
        },
        {
            "version":  "ASSET_VERSION_V0",
            "asset_genesis":  {
                "genesis_point":  "9aac0f8149ef38f6af5ed809476350dabae89801699d17ebbfc821c6f17d0db7:2",
                "name":  "Phenix",
                "meta_hash":  "dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "output_index":  0,
                "version":  0
            },
            "amount":  "10000",
            "lock_time":  0,
            "relative_lock_time":  0,
            "script_version":  0,
            "script_key":  "02d938c31d88917f89bf007f91363e7a0fc7732fbee653cef4faefe6f3e1b11a47",
            "script_key_is_local":  true,
            "asset_group":  null,
            "chain_anchor":  {
                "anchor_tx":  "02000000000103f1a78030aaa0e5616eb7e66c2eec9fd9e3a118ef45f7f30a6a16cb199b16c8b50200000000ffffffff2b71edc295b963da75a0acea7dc7fce4f194400fa58e1e7bba69f43b465759d50200000000ffffffff329e06a8838d020f64c6d2899a89fef8742c1d06ccb35db228905580c2007c7e00000000000000000002e803000000000000225120068fab1446358f34de2efb8c797d55f295fb6f457b0c2a17c1a54dca3b92db83770800000000000022512059a4163bd5b8f37980eef995ba673edac7cf979d1e3f3a5191aeaeda1df7bb3a0140dbefefdd48be219e4151b711bc005437da8c7f0937f03a78a005bd5a15e05571b78fb589f3d3851e00b992f9f80a6d64e9fda5636fc467bbe76221369cd3052a0140ef8f30166ee75418c36f32a737f9f4e368b4e7c276d0959b6edee5d97a922549ae7b10aec874229ac112ed81163c8b6832b849363da7f767571a57d92427e41201400eafb4ef1b93910fe685eb34bee08c2457f2fa663c99c574c0c09b8ab75edf8d3e470cd785693f5ba05b3f9b23a6e663edbcd6e71d09cded13928fcac4c4e79a00000000",
                "anchor_block_hash":  "00000000000000000002001ebcf443ac2d72338a9a40210c6da5f8881af75b37",
                "anchor_outpoint":  "273feebe085b17de39408b1fba984d9301b94b99965fcbf5c8f7a32c3230a644:1",
                "internal_key":  "0237d21812535a92199c929e9ba456c9eb43de7c9a92861d69038e2c69f93325ff",
                "merkle_root":  "93dd20e68fa1377a9175e3934cf90cf4ed455ab32d76ff54a1bd9ebb0c16693b",
                "tapscript_sibling":  "",
                "block_height":  0
            },
            "prev_witnesses":  [],
            "is_spent":  false,
            "lease_owner":  "",
            "lease_expiry":  "0",
            "is_burn":  false
        },
        {
            "version":  "ASSET_VERSION_V0",
            "asset_genesis":  {
                "genesis_point":  "9aac0f8149ef38f6af5ed809476350dabae89801699d17ebbfc821c6f17d0db7:2",
                "name":  "Phenix",
                "meta_hash":  "dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "output_index":  0,
                "version":  0
            },
            "amount":  "19997",
            "lock_time":  0,
            "relative_lock_time":  0,
            "script_version":  0,
            "script_key":  "02c12b9d2a5957eb5e185f9c9306f33ed10636e7b54c76a675d0ecd51392ca6f67",
            "script_key_is_local":  true,
            "asset_group":  null,
            "chain_anchor":  {
                "anchor_tx":  "02000000000104a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb0400000000ffffffffa0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb000000000000000000c51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a82640100000000000000005317e33b22fe17dec5962e9d1eeba9c9ea3f2ff965bb729e9b7ac92b1e991ee501000000000000000003e803000000000000225120f1b451b13056ef4e93115e5db5e465c9b50972f704a20bafd24efca59932fce3e80300000000000022512001b33cffe0f4e2b4e1cfc20b15646f9ee5d786e711202b5f8f220ab851ee73f82e220000000000002251205a9e175380d1cae7ac1a1c404b441b472a94a74942a6a13b0c744fc334adbb660140cac452b551db50fabfaf7ea95a2987a1216960d17486bb3cd3ca38ab14e169704fb67673b8661ff0def731f6b6703d47c0878454f4ad2ca381c27ca67bb7d25e014005b729fe566a1a314ed550eed38d13ce4a80b9be759e9c77f0e257b56a7fb08500b7bda00b358bf9673dbb89c20780e0e7703e22e5b3c8db7400f8e29f5cf89501403670dcc4a08748e2a9bfe257fcd30a501c752e9aa77e9ae5dbe985b9baf1e62b913f906c934664d2fcfce88c83cb335319d3bebe8ffdee5792b0d66c5821ddd201408230b85ebe7bc91e6fcebedd88443b657049d6f51af3e8c609d060f35390ab010feefa207619a88499506c1048bed1faf7239d7b571e047fd73a195ba1ded32400000000",
                "anchor_block_hash":  "00000000000000000002083b03b70d941d09f3531e15aa82d5abe8b816fade4b",
                "anchor_outpoint":  "5252d4e329ab2dfd454a05257af170c833b2dd702298839df1e78f72fbb22ba9:0",
                "internal_key":  "020075dfec48b74d34db19682b08042e196c5413ecba01e3669cb7c5e2f58178ba",
                "merkle_root":  "66d3cf0a641aad28f189dbf687292958f426675d4778810bc58c2fb9d32b1f33",
                "tapscript_sibling":  "",
                "block_height":  0
            },
            "prev_witnesses":  [],
            "is_spent":  false,
            "lease_owner":  "",
            "lease_expiry":  "0",
            "is_burn":  false
        }
    ]
}

0 replies

SevenLiquor · 2024-07-19T02:23:08Z

SevenLiquor
Jul 19, 2024
Author

and and other,
I think it might have something to do with this.
The address for this asset received two assets and the other has been transferred out.
tapcli addrs receives

        {
            "creation_time_unix_seconds":  "1720698321",
            "addr":  {
                "encoded":  "tapbc1qqqsqqspqqzzq3ldzgx5k9e7k7d6gmx3jkdmnjyped5nxt8c5gfnvygtmgz5qgcgqcss92qzpvnuqmul24ezwap5umf8v38x9sv796k8u3flalnrdya54z76pqss8mzfkpt5anc5ltcv38zm9faj9a5p0vf4sx2sm6pqarn2xrnwrx34pgplms6spssh2mnfwejhyum9wfcxxw309ucnxv3wxgenyt33xqujuwp58gurgdp5luy67w",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "amount":  "50000",
                "group_key":  "",
                "script_key":  "02a8020b27c06f9f5572277434e6d27644e62c19e2eac7e453fefe63693b4a8bda",
                "internal_key":  "03ec49b0574ecf14faf0c89c5b2a7b22f6817b13581950de820e8e6a30e6e19a35",
                "tapscript_sibling":  "",
                "taproot_output_key":  "59c609541c7e171a93dfd564d65f473ac53b546db9d171d9405c4ba84b271a46",
                "proof_courier_addr":  "universerpc://132.232.109.84:8444",
                "asset_version":  "ASSET_VERSION_V0"
            },
            "status":  "ADDR_EVENT_STATUS_COMPLETED",
            "outpoint":  "3fdbbe301bb6209f9140ab19cb263ec32a9f19abc8c81cb27b17b7f27dd9c7cb:1",
            "utxo_amt_sat":  "1000",
            "taproot_sibling":  "",
            "confirmation_height":  851678,
            "has_proof":  true
        },
        {
            "creation_time_unix_seconds":  "1720750276",
            "addr":  {
                "encoded":  "tapbc1qqqsqqspqqzzq3ldzgx5k9e7k7d6gmx3jkdmnjyped5nxt8c5gfnvygtmgz5qgcgqcss92qzpvnuqmul24ezwap5umf8v38x9sv796k8u3flalnrdya54z76pqss8mzfkpt5anc5ltcv38zm9faj9a5p0vf4sx2sm6pqarn2xrnwrx34pgplms6spssh2mnfwejhyum9wfcxxw309ucnxv3wxgenyt33xqujuwp58gurgdp5luy67w",
                "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                "asset_type":  "NORMAL",
                "amount":  "50000",
                "group_key":  "",
                "script_key":  "02a8020b27c06f9f5572277434e6d27644e62c19e2eac7e453fefe63693b4a8bda",
                "internal_key":  "03ec49b0574ecf14faf0c89c5b2a7b22f6817b13581950de820e8e6a30e6e19a35",
                "tapscript_sibling":  "",
                "taproot_output_key":  "59c609541c7e171a93dfd564d65f473ac53b546db9d171d9405c4ba84b271a46",
                "proof_courier_addr":  "universerpc://132.232.109.84:8444",
                "asset_version":  "ASSET_VERSION_V0"
            },
            "status":  "ADDR_EVENT_STATUS_COMPLETED",
            "outpoint":  "e51e991e2bc97a9b9e72bb65f92f3feac9a9eb1e9d2e96c5de17fe223be31753:1",
            "utxo_amt_sat":  "1000",
            "taproot_sibling":  "",
            "confirmation_height":  851771,
            "has_proof":  true
        },

tapcli assets transfers

        {
            "transfer_timestamp":  "1721042325",
            "anchor_tx_hash":  "a92bb2fb728fe7f19d83982270ddb233c870f17a25054a45fd2dab29e3d45252",
            "anchor_tx_height_hint":  852297,
            "anchor_tx_chain_fees":  "2217",
            "inputs":  [
                {
                    "anchor_point":  "cb5e7957fc2342b09c1bf63def3ee53fe49c98fe9c92989fb7378d6111dfafa0:0",
                    "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                    "script_key":  "0237696a94e99d1c047e69f3de78140e71dab1696b1464c8b4b32e67d09b2794ae",
                    "amount":  "1969997"
                },
                {
                    "anchor_point":  "64828a04a83425fac1ee8ab09272cf38c02d758f95e21d067abc3b7cf9b91cc5:1",
                    "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                    "script_key":  "02c71ac876b3c82788d79b8aac1ee0e8c0c2ec143978a87c8484fbbcca267f7442",
                    "amount":  "100000"
                },
                {
                    "anchor_point":  "e51e991e2bc97a9b9e72bb65f92f3feac9a9eb1e9d2e96c5de17fe223be31753:1",
                    "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                    "script_key":  "02a8020b27c06f9f5572277434e6d27644e62c19e2eac7e453fefe63693b4a8bda",
                    "amount":  "50000"
                }
            ],
            "outputs":  [
                {
                    "anchor":  {
                        "outpoint":  "5252d4e329ab2dfd454a05257af170c833b2dd702298839df1e78f72fbb22ba9:0",
                        "value":  "1000",
                        "internal_key":  "020075dfec48b74d34db19682b08042e196c5413ecba01e3669cb7c5e2f58178ba",
                        "taproot_asset_root":  "66d3cf0a641aad28f189dbf687292958f426675d4778810bc58c2fb9d32b1f33",
                        "merkle_root":  "66d3cf0a641aad28f189dbf687292958f426675d4778810bc58c2fb9d32b1f33",
                        "tapscript_sibling":  "",
                        "num_passive_assets":  0
                    },
                    "script_key":  "02c12b9d2a5957eb5e185f9c9306f33ed10636e7b54c76a675d0ecd51392ca6f67",
                    "script_key_is_local":  true,
                    "amount":  "19997",
                    "new_proof_blob":  "544150500004000000000224a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb000000000450000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000096e88000000000000000006fd023902000000000104a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb0400000000ffffffffa0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb000000000000000000c51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a82640100000000000000005317e33b22fe17dec5962e9d1eeba9c9ea3f2ff965bb729e9b7ac92b1e991ee501000000000000000003e803000000000000225120f1b451b13056ef4e93115e5db5e465c9b50972f704a20bafd24efca59932fce3e80300000000000022512001b33cffe0f4e2b4e1cfc20b15646f9ee5d786e711202b5f8f220ab851ee73f82e220000000000002251205a9e175380d1cae7ac1a1c404b441b472a94a74942a6a13b0c744fc334adbb660140cac452b551db50fabfaf7ea95a2987a1216960d17486bb3cd3ca38ab14e169704fb67673b8661ff0def731f6b6703d47c0878454f4ad2ca381c27ca67bb7d25e014005b729fe566a1a314ed550eed38d13ce4a80b9be759e9c77f0e257b56a7fb08500b7bda00b358bf9673dbb89c20780e0e7703e22e5b3c8db7400f8e29f5cf89501403670dcc4a08748e2a9bfe257fcd30a501c752e9aa77e9ae5dbe985b9baf1e62b913f906c934664d2fcfce88c83cb335319d3bebe8ffdee5792b0d66c5821ddd201408230b85ebe7bc91e6fcebedd88443b657049d6f51af3e8c609d060f35390ab010feefa207619a88499506c1048bed1faf7239d7b571e047fd73a195ba1ded324000000000801000afd02b70001000250b70d7df1c621c8bfeb179d690198e8bada50634709d85eaff638ef49810fac9a00000002065068656e6978dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba00000000000401000603fd4e1d0bfd020503ab0165a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb0000000047ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda054023080237696a94e99d1c047e69f3de78140e71dab1696b1464c8b4b32e67d09b2794ae0342014043feed9263be9e7c7dfc2bb6bda63fbefee41906e9f8ed86ec4be66cd5862bc274626cdfeba716cc3d0f72c8f1637178fca00f0e4cfff3f33144fc6a4038fbadab0165c51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a82640000000147ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda0540230802c71ac876b3c82788d79b8aac1ee0e8c0c2ec143978a87c8484fbbcca267f7442034201405ec255db00bc5ecd2ef50471c32f4b7fc998502c059f6bd08b77b7c52803fd62691451a652fe62d7e7cb467f9dd5ed591f568503e81cd5c1cc69b117360374daab01655317e33b22fe17dec5962e9d1eeba9c9ea3f2ff965bb729e9b7ac92b1e991ee50000000147ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda0540230802a8020b27c06f9f5572277434e6d27644e62c19e2eac7e453fefe63693b4a8bda03420140f180aa386cd3185ff20042c129e86fde06593a0cbedf505157fcf9a4133d56f699bbbc2fabd42832919771423909db2af5015cb929c5e57181e70af92245c2d70d28f2d097431780fc4ca19aa02170bbf10fe4cda5fbb2bb19e90e55e07a24b28780000000000020593d0e020000102102c12b9d2a5957eb5e185f9c9306f33ed10636e7b54c76a675d0ecd51392ca6f670c9f0004000000000221020075dfec48b74d34db19682b08042e196c5413ecba01e3669cb7c5e2f58178ba03740149000100022047ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda0540230804220000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff022700010002220000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0df802c70004000000010221031285aae2372df4a1b9af80f19f2c54c5e629a1226cf5c63cd9a1f8d7d014f4fe039c0171000100022047ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308044a0001af42c1c2662ba8e13c14885773519716d17267333407df8d5de905486d6fc9fe0000000000200b20ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff7f022700010002220000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff2e000400000002022102aa39e177f7cb5d60ffa6947517e23bd249c35476c758d33a9951e6d5c6c5d95a0503040101160400000000",
                    "split_commit_root_hash":  "f2d097431780fc4ca19aa02170bbf10fe4cda5fbb2bb19e90e55e07a24b28780",
                    "output_type":  "OUTPUT_TYPE_SPLIT_ROOT",
                    "asset_version":  "ASSET_VERSION_V0"
                },
                {
                    "anchor":  {
                        "outpoint":  "5252d4e329ab2dfd454a05257af170c833b2dd702298839df1e78f72fbb22ba9:1",
                        "value":  "1000",
                        "internal_key":  "031285aae2372df4a1b9af80f19f2c54c5e629a1226cf5c63cd9a1f8d7d014f4fe",
                        "taproot_asset_root":  "85e3085ab4aaea87aae419468d24f35ac31a2168f0aacfc4c9ed368b22b11a83",
                        "merkle_root":  "85e3085ab4aaea87aae419468d24f35ac31a2168f0aacfc4c9ed368b22b11a83",
                        "tapscript_sibling":  "",
                        "num_passive_assets":  0
                    },
                    "script_key":  "0290a86c5fc0fac7c0630bf3d27bed7f3998dac2a460c004155711cbb96aee3ecd",
                    "script_key_is_local":  false,
                    "amount":  "2100000",
                    "new_proof_blob":  "544150500004000000000224a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb000000000450000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000096e88000000000000000006fd023902000000000104a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb0400000000ffffffffa0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb000000000000000000c51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a82640100000000000000005317e33b22fe17dec5962e9d1eeba9c9ea3f2ff965bb729e9b7ac92b1e991ee501000000000000000003e803000000000000225120f1b451b13056ef4e93115e5db5e465c9b50972f704a20bafd24efca59932fce3e80300000000000022512001b33cffe0f4e2b4e1cfc20b15646f9ee5d786e711202b5f8f220ab851ee73f82e220000000000002251205a9e175380d1cae7ac1a1c404b441b472a94a74942a6a13b0c744fc334adbb660140cac452b551db50fabfaf7ea95a2987a1216960d17486bb3cd3ca38ab14e169704fb67673b8661ff0def731f6b6703d47c0878454f4ad2ca381c27ca67bb7d25e014005b729fe566a1a314ed550eed38d13ce4a80b9be759e9c77f0e257b56a7fb08500b7bda00b358bf9673dbb89c20780e0e7703e22e5b3c8db7400f8e29f5cf89501403670dcc4a08748e2a9bfe257fcd30a501c752e9aa77e9ae5dbe985b9baf1e62b913f906c934664d2fcfce88c83cb335319d3bebe8ffdee5792b0d66c5821ddd201408230b85ebe7bc91e6fcebedd88443b657049d6f51af3e8c609d060f35390ab010feefa207619a88499506c1048bed1faf7239d7b571e047fd73a195ba1ded324000000000801000afd03fe0001000250b70d7df1c621c8bfeb179d690198e8bada50634709d85eaff638ef49810fac9a00000002065068656e6978dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba00000000000401000605fe00200b200bfd037401fd03700165000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005fd03054a00019a46d71e0af42a812709c9a3faff2a4f1395a0ffa4ae0c2181c07b8cfb521e090000000000004e1dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdffd02b70001000250b70d7df1c621c8bfeb179d690198e8bada50634709d85eaff638ef49810fac9a00000002065068656e6978dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba00000000000401000603fd4e1d0bfd020503ab0165a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb0000000047ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda054023080237696a94e99d1c047e69f3de78140e71dab1696b1464c8b4b32e67d09b2794ae0342014043feed9263be9e7c7dfc2bb6bda63fbefee41906e9f8ed86ec4be66cd5862bc274626cdfeba716cc3d0f72c8f1637178fca00f0e4cfff3f33144fc6a4038fbadab0165c51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a82640000000147ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda0540230802c71ac876b3c82788d79b8aac1ee0e8c0c2ec143978a87c8484fbbcca267f7442034201405ec255db00bc5ecd2ef50471c32f4b7fc998502c059f6bd08b77b7c52803fd62691451a652fe62d7e7cb467f9dd5ed591f568503e81cd5c1cc69b117360374daab01655317e33b22fe17dec5962e9d1eeba9c9ea3f2ff965bb729e9b7ac92b1e991ee50000000147ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda0540230802a8020b27c06f9f5572277434e6d27644e62c19e2eac7e453fefe63693b4a8bda03420140f180aa386cd3185ff20042c129e86fde06593a0cbedf505157fcf9a4133d56f699bbbc2fabd42832919771423909db2af5015cb929c5e57181e70af92245c2d70d28f2d097431780fc4ca19aa02170bbf10fe4cda5fbb2bb19e90e55e07a24b28780000000000020593d0e020000102102c12b9d2a5957eb5e185f9c9306f33ed10636e7b54c76a675d0ecd51392ca6f670e02000010210290a86c5fc0fac7c0630bf3d27bed7f3998dac2a460c004155711cbb96aee3ecd0c9f0004000000010221031285aae2372df4a1b9af80f19f2c54c5e629a1226cf5c63cd9a1f8d7d014f4fe03740149000100022047ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda0540230804220000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff022700010002220000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0df802c70004000000000221020075dfec48b74d34db19682b08042e196c5413ecba01e3669cb7c5e2f58178ba039c0171000100022047ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308044a0001c1912a8e894ab5c917500c8e46080d6a90820f0efc12670dc6414fb31d766fb20000000000004e1dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff7f022700010002220000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff2e000400000002022102aa39e177f7cb5d60ffa6947517e23bd249c35476c758d33a9951e6d5c6c5d95a05030401010f9f0004000000000221020075dfec48b74d34db19682b08042e196c5413ecba01e3669cb7c5e2f58178ba03740149000100022047ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda0540230804220000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff022700010002220000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff160400000000",
                    "split_commit_root_hash":  "",
                    "output_type":  "OUTPUT_TYPE_SIMPLE",
                    "asset_version":  "ASSET_VERSION_V0"
                }
            ]
        }
    ]
}

0 replies

SevenLiquor · 2024-07-19T02:26:57Z

SevenLiquor
Jul 19, 2024
Author

Ok, that's all I can think of, and it doesn't seem to be the first time it's come up.

6 replies

SevenLiquor Jul 19, 2024
Author

lnd.log
Here's the full log for this node as of yesterday

guggero Jul 19, 2024
Maintainer

Okay, I think I know what's going on. The Taproot Asset Address (tapbc1qqqsqqspqqzzq3ldzgx5k9e7k7d6gmx3jkdmnjyped5nxt8c5gfnvygtmgz5qgcgqcss92qzpvnuqmul24ezwap5umf8v38x9sv796k8u3flalnrdya54z76pqss8mzfkpt5anc5ltcv38zm9faj9a5p0vf4sx2sm6pqarn2xrnwrx34pgplms6spssh2mnfwejhyum9wfcxxw309ucnxv3wxgenyt33xqujuwp58gurgdp5luy67w) was re-used (on-chain address bc1pt8rqj4qu0ct34y7l64jdvh688tznk4rdh8ghrk2qt396sje8rfrqgwxy5r) and two inbound transfers were sent to it.

But due to a bug, the wrong one was set as spent. This was fixed in #984, which will be in the upcoming v0.4.0 release.

So we would need to run a small SQL script to fix this in your local database. How comfortable are you with the command line?
Do you think you'll manage installing (if not already installed) sqlite3 and executing a query?

I think I'd need the output of tapcli assets utxos for the script, so if you could send me that as well, that would be great.

SevenLiquor Jul 20, 2024
Author

This is the result returned by the tapcli assets utxos . As with the tapcli assets list , I can only see information about the other two assets.
tapcli assets utxos

{
    "managed_utxos":  {
        "273feebe085b17de39408b1fba984d9301b94b99965fcbf5c8f7a32c3230a644:1":  {
            "out_point":  "273feebe085b17de39408b1fba984d9301b94b99965fcbf5c8f7a32c3230a644:1",
            "amt_sat":  "2167",
            "internal_key":  "0237d21812535a92199c929e9ba456c9eb43de7c9a92861d69038e2c69f93325ff",
            "taproot_asset_root":  "93dd20e68fa1377a9175e3934cf90cf4ed455ab32d76ff54a1bd9ebb0c16693b",
            "merkle_root":  "93dd20e68fa1377a9175e3934cf90cf4ed455ab32d76ff54a1bd9ebb0c16693b",
            "assets":  [
                {
                    "version":  "ASSET_VERSION_V0",
                    "asset_genesis":  {
                        "genesis_point":  "9aac0f8149ef38f6af5ed809476350dabae89801699d17ebbfc821c6f17d0db7:2",
                        "name":  "Phenix",
                        "meta_hash":  "dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba",
                        "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                        "asset_type":  "NORMAL",
                        "output_index":  0,
                        "version":  0
                    },
                    "amount":  "10000",
                    "lock_time":  0,
                    "relative_lock_time":  0,
                    "script_version":  0,
                    "script_key":  "02d938c31d88917f89bf007f91363e7a0fc7732fbee653cef4faefe6f3e1b11a47",
                    "script_key_is_local":  true,
                    "asset_group":  null,
                    "chain_anchor":  {
                        "anchor_tx":  "02000000000103f1a78030aaa0e5616eb7e66c2eec9fd9e3a118ef45f7f30a6a16cb199b16c8b50200000000ffffffff2b71edc295b963da75a0acea7dc7fce4f194400fa58e1e7bba69f43b465759d50200000000ffffffff329e06a8838d020f64c6d2899a89fef8742c1d06ccb35db228905580c2007c7e00000000000000000002e803000000000000225120068fab1446358f34de2efb8c797d55f295fb6f457b0c2a17c1a54dca3b92db83770800000000000022512059a4163bd5b8f37980eef995ba673edac7cf979d1e3f3a5191aeaeda1df7bb3a0140dbefefdd48be219e4151b711bc005437da8c7f0937f03a78a005bd5a15e05571b78fb589f3d3851e00b992f9f80a6d64e9fda5636fc467bbe76221369cd3052a0140ef8f30166ee75418c36f32a737f9f4e368b4e7c276d0959b6edee5d97a922549ae7b10aec874229ac112ed81163c8b6832b849363da7f767571a57d92427e41201400eafb4ef1b93910fe685eb34bee08c2457f2fa663c99c574c0c09b8ab75edf8d3e470cd785693f5ba05b3f9b23a6e663edbcd6e71d09cded13928fcac4c4e79a00000000",
                        "anchor_block_hash":  "00000000000000000002001ebcf443ac2d72338a9a40210c6da5f8881af75b37",
                        "anchor_outpoint":  "273feebe085b17de39408b1fba984d9301b94b99965fcbf5c8f7a32c3230a644:1",
                        "internal_key":  "0237d21812535a92199c929e9ba456c9eb43de7c9a92861d69038e2c69f93325ff",
                        "merkle_root":  "93dd20e68fa1377a9175e3934cf90cf4ed455ab32d76ff54a1bd9ebb0c16693b",
                        "tapscript_sibling":  "",
                        "block_height":  0
                    },
                    "prev_witnesses":  [],
                    "is_spent":  false,
                    "lease_owner":  "",
                    "lease_expiry":  "0",
                    "is_burn":  false
                }
            ]
        },
        "5252d4e329ab2dfd454a05257af170c833b2dd702298839df1e78f72fbb22ba9:0":  {
            "out_point":  "5252d4e329ab2dfd454a05257af170c833b2dd702298839df1e78f72fbb22ba9:0",
            "amt_sat":  "1000",
            "internal_key":  "020075dfec48b74d34db19682b08042e196c5413ecba01e3669cb7c5e2f58178ba",
            "taproot_asset_root":  "66d3cf0a641aad28f189dbf687292958f426675d4778810bc58c2fb9d32b1f33",
            "merkle_root":  "66d3cf0a641aad28f189dbf687292958f426675d4778810bc58c2fb9d32b1f33",
            "assets":  [
                {
                    "version":  "ASSET_VERSION_V0",
                    "asset_genesis":  {
                        "genesis_point":  "9aac0f8149ef38f6af5ed809476350dabae89801699d17ebbfc821c6f17d0db7:2",
                        "name":  "Phenix",
                        "meta_hash":  "dd70742abe7006267a53178b6c42c42207bdc7f7483432dc62236119b1152dba",
                        "asset_id":  "47ed120d4b173eb79ba46cd1959bb9c881cb69332cf8a21336110bda05402308",
                        "asset_type":  "NORMAL",
                        "output_index":  0,
                        "version":  0
                    },
                    "amount":  "19997",
                    "lock_time":  0,
                    "relative_lock_time":  0,
                    "script_version":  0,
                    "script_key":  "02c12b9d2a5957eb5e185f9c9306f33ed10636e7b54c76a675d0ecd51392ca6f67",
                    "script_key_is_local":  true,
                    "asset_group":  null,
                    "chain_anchor":  {
                        "anchor_tx":  "02000000000104a0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb0400000000ffffffffa0afdf11618d37b79f98929cfe989ce43fe53eef3df61b9cb04223fc57795ecb000000000000000000c51cb9f97c3bbc7a061de2958f752dc038cf7292b08aeec1fa2534a8048a82640100000000000000005317e33b22fe17dec5962e9d1eeba9c9ea3f2ff965bb729e9b7ac92b1e991ee501000000000000000003e803000000000000225120f1b451b13056ef4e93115e5db5e465c9b50972f704a20bafd24efca59932fce3e80300000000000022512001b33cffe0f4e2b4e1cfc20b15646f9ee5d786e711202b5f8f220ab851ee73f82e220000000000002251205a9e175380d1cae7ac1a1c404b441b472a94a74942a6a13b0c744fc334adbb660140cac452b551db50fabfaf7ea95a2987a1216960d17486bb3cd3ca38ab14e169704fb67673b8661ff0def731f6b6703d47c0878454f4ad2ca381c27ca67bb7d25e014005b729fe566a1a314ed550eed38d13ce4a80b9be759e9c77f0e257b56a7fb08500b7bda00b358bf9673dbb89c20780e0e7703e22e5b3c8db7400f8e29f5cf89501403670dcc4a08748e2a9bfe257fcd30a501c752e9aa77e9ae5dbe985b9baf1e62b913f906c934664d2fcfce88c83cb335319d3bebe8ffdee5792b0d66c5821ddd201408230b85ebe7bc91e6fcebedd88443b657049d6f51af3e8c609d060f35390ab010feefa207619a88499506c1048bed1faf7239d7b571e047fd73a195ba1ded32400000000",
                        "anchor_block_hash":  "00000000000000000002083b03b70d941d09f3531e15aa82d5abe8b816fade4b",
                        "anchor_outpoint":  "5252d4e329ab2dfd454a05257af170c833b2dd702298839df1e78f72fbb22ba9:0",
                        "internal_key":  "020075dfec48b74d34db19682b08042e196c5413ecba01e3669cb7c5e2f58178ba",
                        "merkle_root":  "66d3cf0a641aad28f189dbf687292958f426675d4778810bc58c2fb9d32b1f33",
                        "tapscript_sibling":  "",
                        "block_height":  0
                    },
                    "prev_witnesses":  [],
                    "is_spent":  false,
                    "lease_owner":  "",
                    "lease_expiry":  "0",
                    "is_burn":  false
                }
            ]
        }
    }
}

And about sqlite3, I think I can try it. Please tell me what to do.
thank!

guggero Jul 22, 2024
Maintainer

Okay, can you please do the following (if any step returns an error or does anything unexpected, please abort and report back instead of continuing!):

Make sure sqlite3 --version gives you a proper version (something like 3.45.3 2024-04-15 ..... and not an error).
Stop the node (full litd).
Open the sqlite database, running sqlite3 /data/user/0/io.bitlong/files/.tapd/data/mainnet/tapd.db
Paste the following three lines and press <enter>. You should not get an error, and no response other than a new sqlite> prompt, then it's successful:

update assets set spent = '1' where anchor_utxo_id = (select utxo_id from managed_utxos where lower(hex(outpoint)) = '44a630322ca3f7c8f5cb5f96994bb901934d98ba1f8b4039de175b08beee3f2701000000');
update assets set spent = '1' where anchor_utxo_id = (select utxo_id from managed_utxos where lower(hex(outpoint)) = 'a92bb2fb728fe7f19d83982270ddb233c870f17a25054a45fd2dab29e3d4525200000000');
update assets set spent = '0' where anchor_utxo_id = (select utxo_id from managed_utxos where lower(hex(outpoint)) = 'cbc7d97df2b7177bb21cc8c8ab199f2ac33e26cb19ab40919f20b61b30bedb3f01000000');

Type .quit and press <enter> to cleanly exit and save all changes to the database.
Start litd again. You should now see the correct assets being listed with tapcli assets list and should be able to spend them.

Answer selected by SevenLiquor

SevenLiquor Jul 23, 2024
Author

Exciting! I can use this asset now.
I am really grateful for that！

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Assets not available for use #1034

{{title}}

Replies: 3 comments 6 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

Assets not available for use #1034

SevenLiquor Jul 19, 2024

Replies: 3 comments · 6 replies

SevenLiquor Jul 19, 2024 Author

SevenLiquor Jul 19, 2024 Author

SevenLiquor Jul 19, 2024 Author

SevenLiquor Jul 19, 2024 Author

guggero Jul 19, 2024 Maintainer

SevenLiquor Jul 20, 2024 Author

guggero Jul 22, 2024 Maintainer

SevenLiquor Jul 23, 2024 Author

SevenLiquor
Jul 19, 2024

Replies: 3 comments 6 replies

SevenLiquor
Jul 19, 2024
Author

SevenLiquor
Jul 19, 2024
Author

SevenLiquor
Jul 19, 2024
Author

SevenLiquor Jul 19, 2024
Author

guggero Jul 19, 2024
Maintainer

SevenLiquor Jul 20, 2024
Author

guggero Jul 22, 2024
Maintainer

SevenLiquor Jul 23, 2024
Author