epudwjuhc

It starts to sync from good database backup, then screws up: while true; do sleep 10; chia show -s | grep Status ; done Current Blockchain Status: Syncing 5134139/5134139 (0...

> We are thinking that somehow your coin_record table got corrupted and lost a coin. Best bet would be to get a new database by downloading from torrent or syncing...

Nope, I don't run another. It is exactly not so "simple copy it from another machine". Such projects are started without ahead planing to my eye. Oh just use Sqlite....

can you write a SQL script that will discard last X blocks from the DB ? are there any sequence numbers...

e.g. lets take a simple example of 3 blocks: block1 [ coin1 coin2 coin 3 ] block2 [ coin1 coin2->spent coin3->spent ] block3 [ other stuff ... ] lets assume...

> I ran into this as well on my full node today: 2024-04-10T11:53:05.838 full_node chia.consensus.block_body_validation: ERROR Err.UNKNOWN_UNSPENT: COIN ID: => to me it looks like first update to 1.8.3 then...

ps I was running 1.6.x for a while before I did that upgrade

it prints: chia rpc full_node get_additions_and_removals '{"header_hash": "0x5d5fcb0e572182a82d9e8ea85314894f416288b96f22a2b84f9478994dc484ae"}' Request failed: RPC response failure: {"error": "Block 5d5fcb0e572182a82d9e8ea85314894f416288b96f22a2b84f9478994dc484ae not found", "success": false, "traceback": "Traceback (most recent call last):\n File \"/nvm1/chia/src/chia-blockchain/chia/rpc/util.py\", line 49,...

> Do you still have the v1 DB? Is this reproducible when you convert the DB from v1 to v2? If so that is really interesting and we should be...

So, you are saying the DB was corrupted at an earlier stage but it just manifests right now because someone moved that coin from the past, is that correct? In...