Pruned node missing some coinbase UTXOs (version: 28.1) #33071

Is there an existing issue for this?

• I have searched the existing issues

Current behaviour

Bitcoin Core version: 28.1 Node state: Fully synced, pruned Observed issue: Using a fully synced pruned node (prune=550), I scanned the UTXO set using bitcoin-cli scantxoutset for the address 1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj (known to contain the original 50 BTC coinbase from satoshis block 8).

The result returns only small non-coinbase dust UTXOs totaling 0.00012281 BTC - every transaction except the coinbase.

The expected 50 BTC coinbase UTXO is missing.

This is a huge issue as if some early wallets decided to spend their coins pruned nodes would reject them as invalid.

Expected behaviour

Coinbase transactions should appear no matter how old, even on a pruned node.

The balance should report

50.00012281 not 0.00012281

Steps to reproduce

Config: blocksxor=0 dbcache=32768 maxmempool=1000 par=8 txindex=0 prune=550

Start a new node.

After synced run:

bitcoin-cli scantxoutset start "[{"desc":"addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)"}]"

Relevant log output

bitcoin-cli scantxoutset start "[{\"desc\":\"addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)\"}]"
{
  "success": true,
  "txouts": 167397304,
  "height": 907383,
  "bestblock": "0000000000000000000050b8446a2b0e76cd37563a2fe1718526ba6b6c445e8f",
  "unspents": [
    {
      "txid": "970babece9a5c64da043f3300a5c9b8cc4af572e4b6445c107aebfe8d4b2b202",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000546,
      "coinbase": false,
      "height": 889797,
      "blockhash": "000000000000000000019849a60b83488ea846790f279d4a593f31db48fe12c7",
      "confirmations": 17587
    },
    {
      "txid": "63fc8344f68031d9fd268285788da6dc1a19121bc7ba5f82e4690a8dc7f74a0a",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000546,
      "coinbase": false,
      "height": 889809,
      "blockhash": "000000000000000000016d5aa40f51f1789db679e5f40b94483dddd7ce8a44d9",
      "confirmations": 17575
    },
    {
      "txid": "3f64f5a48fd860d4fb192df1988954a062303226eb80fad6c3379f8e3ec0a20c",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000548,
      "coinbase": false,
      "height": 906883,
      "blockhash": "00000000000000000000be25a44d918d2159e5c5b4282730f614979bbe9c2985",
      "confirmations": 501
    },
    {
      "txid": "596e2a816c6b0d83f9b1b2ba1ab47aa63aa06451bcb2b95335cb21b7cc14d818",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000700,
      "coinbase": false,
      "height": 905786,
      "blockhash": "00000000000000000000c6073752801891705825ed9038637f11a2f3eca36d2d",
      "confirmations": 1598
    },
    {
      "txid": "672ee3dfef7f1b90293a3776c3995d0c84ebe82f94a5d7403f0bcc51fce5eb1f",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000546,
      "coinbase": false,
      "height": 834311,
      "blockhash": "000000000000000000037e88d14f9bcf99e8121faa2c23b1bc10f2f3a554e110",
      "confirmations": 73073
    },
    {
      "txid": "bcb466f4753426ac498bb43333fb02ff145abe4455c87a7043e1ddde76160325",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000700,
      "coinbase": false,
      "height": 905620,
      "blockhash": "00000000000000000001e1097ae918824669ec7a090ddf4568735673d0f7af8f",
      "confirmations": 1764
    },
    {
      "txid": "b92947c2803f7f46a80ff35be587beca9f70599d52026597e778c606bf942854",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000546,
      "coinbase": false,
      "height": 889809,
      "blockhash": "000000000000000000016d5aa40f51f1789db679e5f40b94483dddd7ce8a44d9",
      "confirmations": 17575
    },
    {
      "txid": "8eeacc40538b094b17f2e278dd53a2f6f68e7126ee81bff0ea3bec2fd9a42f66",
      "vout": 559,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000547,
      "coinbase": false,
      "height": 642635,
      "blockhash": "0000000000000000000362f4c59614eefbb6170fd0b1f3065b4b893cd9972b4a",
      "confirmations": 264749
    },
    {
      "txid": "eae4537e85ef54cb20408a385115f0cf88090f27609d4fa0f384b4aa633999a8",
      "vout": 309,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000547,
      "coinbase": false,
      "height": 646789,
      "blockhash": "0000000000000000000095b7bce82d0d69abb7fcd077dc9b2bce4e0cb7ced0ff",
      "confirmations": 260595
    },
    {
      "txid": "5570099b4c974df32705415329a5d1dbd75e7d8c1982db9f711d2ecc4daff1b9",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000600,
      "coinbase": false,
      "height": 881170,
      "blockhash": "000000000000000000020e0a0e9086623df520128b093a86536c880a69b00be5",
      "confirmations": 26214
    },
    {
      "txid": "560b57b385f49efd263b5528d40b54a193eff61ec58abfa589ff95b42ef835bb",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00002000,
      "coinbase": false,
      "height": 843595,
      "blockhash": "00000000000000000001b74d236a985b936d7d6276ccfa730cb7757c99657293",
      "confirmations": 63789
    },
    {
      "txid": "cf57f19b9d2c3b0bd688781c5eb1885ed74cc9b51ae7d94bc580c8de385735c8",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00001111,
      "coinbase": false,
      "height": 840860,
      "blockhash": "0000000000000000000034d48677190c6f44979ffcad1e8b313d062299908895",
      "confirmations": 66524
    },
    {
      "txid": "bf20b2a7820d7a950eaa236c13749382832835bd93721dec1cc2a124761d97c9",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000546,
      "coinbase": false,
      "height": 889809,
      "blockhash": "000000000000000000016d5aa40f51f1789db679e5f40b94483dddd7ce8a44d9",
      "confirmations": 17575
    },
    {
      "txid": "8f716720ef9caf72149e262748e543df1fc2996cb5ae95d6cec2678dd06601ce",
      "vout": 9,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000588,
      "coinbase": false,
      "height": 564789,
      "blockhash": "0000000000000000001a7d2ca8dbec097dee5c4faac737b28758d19710caed57",
      "confirmations": 342595
    },
    {
      "txid": "4fd07bfc09e31eb2a27bf4873af6aebefdfad7a920aeb2cf04e58cc62cab8bd0",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000546,
      "coinbase": false,
      "height": 889809,
      "blockhash": "000000000000000000016d5aa40f51f1789db679e5f40b94483dddd7ce8a44d9",
      "confirmations": 17575
    },
    {
      "txid": "3f184ca05d8d7c8e0d11e550ce897cb4a9f52c6e599fd22d62603aa82ac17de8",
      "vout": 0,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000570,
      "coinbase": false,
      "height": 906824,
      "blockhash": "000000000000000000012d235393ac9977f8bb89e4bce514c684ee3958995246",
      "confirmations": 560
    },
    {
      "txid": "a66b0e20ca318ff84dd5da4c099fb9bcaee60bbc2da637b912bfb73345ffc9e9",
      "vout": 151,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000547,
      "coinbase": false,
      "height": 667553,
      "blockhash": "00000000000000000000e297bcc894987014870ab9b381d95ec244b731b258b9",
      "confirmations": 239831
    },
    {
      "txid": "239cfce453bd562b3cc820e4bb9178fe4816bc73ab62292f33088d1893b1a3ec",
      "vout": 100,
      "scriptPubKey": "76a914bb7f084e57f4f250cab45f73c62841f83bf1d5f688ac",
      "desc": "addr(1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj)#q9gkw72r",
      "amount": 0.00000547,
      "coinbase": false,
      "height": 661018,
      "blockhash": "0000000000000000000477e07701c3163c8c72730061cda1169d87fd6161d6ed",
      "confirmations": 246366
    }
  ],
  "total_amount": 0.00012281
}

How did you obtain Bitcoin Core

Compiled from source

What version of Bitcoin Core are you using?

Bitcoin Core version v28.1.0

Operating system and version

Ubuntu 24.04.2 LTS

Machine specifications

Linux Ubuntu 24.04.2 LTS, 13th Gen Intel(R) Core(TM) i7-13650HX (2.60 GHz) 64GB RAM Kingston NV2 SSD 562.2 Mbps download / 49.8 Mbps upload

Using a fully synced pruned node (prune=550), I scanned the UTXO set using bitcoin-cli scantxoutset for the address 1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj (known to contain the original 50 BTC coinbase from satoshis block 8).

First of all I think you mean block 9 ;-) And second of all, this is not known and is in fact incorrect! Satoshi did not use a pay-to-pubkey-hash address. If you check that coinbase transaction on an explorer you'll see the output script is a raw, uncompressed pay-to-public-key:

410411db93e1dcdb8a016b49840f8c53bc1eb68a382e97b1482ecad7b148a6909a5cb2e0eaddfb84ccf9744464f82e160bfa9b8b64f9d4c03f999b8643f656b412a3ac

Converting this to a descriptor means trimming off the length byte at the beginning and the CHECKSIG opcode at the end. Try this scan:

bitcoin-cli scantxoutset start '[{"desc":"pk(0411db93e1dcdb8a016b49840f8c53bc1eb68a382e97b1482ecad7b148a6909a5cb2e0eaddfb84ccf9744464f82e160bfa9b8b64f9d4c03f999b8643f656b412a3)"}]'

And finally, since we know this output was SPENT, we should expect it to NOT appear in the UTXO set.

I am currently scanning for the block 1 coinbase P2PK on my pruned node, I'll let you know how it goes...

finally...

$ bitcoin-cli -rpcclienttimeout=999999999999999 scantxoutset start  '[{"desc":"pk(0496b538e853519c726a2c91e61ec11600ae1390813a627c66fb8be7947be63c52da7589379515d4e0a604f8141781e62294721166bf621e73a82cbf2342c858ee)"}]'
{
  "success": true,
  "txouts": 167415131,
  "height": 907405,
  "bestblock": "000000000000000000017573b428d3f13ad8944f368b53ad195ad03b3bdbb1a1",
  "unspents": [
    {
      "txid": "0e3e2357e806b6cdb1f70b54c3a3a17b6714ee1f0e68bebb44a74b1efd512098",
      "vout": 0,
      "scriptPubKey": "410496b538e853519c726a2c91e61ec11600ae1390813a627c66fb8be7947be63c52da7589379515d4e0a604f8141781e62294721166bf621e73a82cbf2342c858eeac",
      "desc": "pk([119b098e]0496b538e853519c726a2c91e61ec11600ae1390813a627c66fb8be7947be63c52da7589379515d4e0a604f8141781e62294721166bf621e73a82cbf2342c858ee)#886589wh",
      "amount": 50.00000000,
      "coinbase": true,
      "height": 1,
      "blockhash": "00000000839a8e6886ab5951d76f411475428afc90947ee320161bbf18eb6048",
      "confirmations": 907405
    }
  ],
  "total_amount": 50.00000000
}

I marked it closed cause I was stupid. I did mean block 8 but looking up by address doesn't work for early coinbase one has to look up by pk