Serious mistake when moving Farmer: copying only blockchain database file and not wallet file

I made the serious error of only copying across

  • \.chia\mainnet\db\blockchain_v1_mainnet.sqlite file

and not

  • \.chia\mainnet\wallet\db\blockchain_wallet_v1_mainnet_XXXXXXXXXX.sqlite file

as well…

This has resulted in the wallet needing to resync from scratch, and also the main node height being stuck at 274558/278218 for 24 hours and not moving:

Will the main node height not update until the wallet finishes synchronizing?

  • Yes, 8444 is forwarded on a static IP address.
  • Yes, UPnP is disabled in config.yaml
1 Like

I had a similar issue, I just had to re-install and copy over the files again. I think it took about 3 attempts before it finally decided to start working.

1 Like

I tried to copy the wallet sql file over but the Windows client would get stuck at loading wallet.

I just copied the entire mainnet folder and it seemed to work okay after several attempts.

Although removing it is a pain, as it puts itself in 3 different places on Windows.

/Users/.chia
/Users/AppData/Roaming/Chia Blockchain
/Users/AppData/Local/chia-blockchain
1 Like

I honestly just want to know whether the main node height (that’s currently stuck) will not update until the wallet first finishes synchronizing?

i had this issue too when migrated chia to my rpi4,
it took me much more than 24h to sync, since i did a fresh install

1 Like

Thanks for sharing this problem and the possible solution, so it can help others in the future! :beers:

I did the same, based on another post that described only copying the blockchain DB. When I found the wallet wasn’t sync’d I found it’s DB and copied that too (I was running old and new in parallel until the new was validated as working).

I didn’t have any trouble though, stopped the new wallet, copied over from the old node and it sync’d right back up.

1 Like