Losing hope with GUI on Ubuntu

Full node GUI on Ubuntu VM worked flawlessly for months, but suddenly refuses to even try to sync.

First it would sync to the latest block then immediately change to “not synced”.

Now it says syncing 0/1,445,000 or whatever the latest block is. Wont budge.

Ports are open, plots are not corrupt.

Here is the latest from my log:

exception=KeyError(b’\xd7\x80\xd2,z\x87\xc9\xe0\x1d\x98\xb4\x9a\t\x10\xf6p\x1c;\x95\x01WA1k?\xda\x04.]{\x81\xd2’)>
Traceback (most recent call last):
File “chia/rpc/rpc_server.py”, line 51, in _state_changed
File “chia/rpc/full_node_rpc_api.py”, line 61, in _state_changed
File “chia/rpc/full_node_rpc_api.py”, line 102, in get_blockchain_state
File “chia/consensus/blockchain.py”, line 157, in get_peak
File “chia/consensus/blockchain.py”, line 674, in height_to_block_record
File “chia/consensus/blockchain.py”, line 670, in block_record
KeyError: b’\xd7\x80\xd2,z\x87\xc9\xe0\x1d\x98\xb4\x9a\t\x10\xf6p\x1c;\x95\x01WA1k?\xda\x04.]{\x81\xd2’
2022-01-19T13:19:44.514 full_node full_node_server : INFO Connection closed: 202.89.154.139, node id: 6738938d591344b2ae0331d303a505d3f394b8715d900c7c2d2991d160871fa9
2022-01-19T13:19:44.515 full_node full_node_server : WARNING Banning 202.89.154.139 for 10 seconds
2022-01-19T13:19:44.517 full_node chia.full_node.full_node: INFO peer disconnected {‘host’: ‘202.89.154.139’, ‘port’: 8444}
2022-01-19T13:19:44.520 full_node full_node_server : ERROR Exception b’\xd7\x80\xd2,z\x87\xc9\xe0\x1d\x98\xb4\x9a\t\x10\xf6p\x1c;\x95\x01WA1k?\xda\x04.]{\x81\xd2’, exception Stack: Traceback (most recent call last):
File “chia/server/server.py”, line 437, in start_client
File “chia/server/server.py”, line 335, in connection_added
File “chia/full_node/full_node.py”, line 619, in on_connect
File “chia/full_node/full_node.py”, line 585, in synced
File “chia/consensus/blockchain.py”, line 157, in get_peak
File “chia/consensus/blockchain.py”, line 674, in height_to_block_record
File “chia/consensus/blockchain.py”, line 670, in block_record
KeyError: b’\xd7\x80\xd2,z\x87\xc9\xe0\x1d\x98\xb4\x9a\t\x10\xf6p\x1c;\x95\x01WA1k?\xda\x04.]{\x81\xd2’

2022-01-19T13:19:44.528 full_node asyncio : ERROR Task exception was never retrieved
future: <Task finished name=‘Task-39372’ coro=<RpcServer._state_changed() done, defined at chia/rpc/rpc_server.py:48> exception=KeyError(b’\xd7\x80\xd2,z\x87\xc9\xe0\x1d\x98\xb4\x9a\t\x10\xf6p\x1c;\x95\x01WA1k?\xda\x04.]{\x81\xd2’)>
Traceback (most recent call last):
File “chia/rpc/rpc_server.py”, line 51, in _state_changed
File “chia/rpc/full_node_rpc_api.py”, line 61, in _state_changed
File “chia/rpc/full_node_rpc_api.py”, line 102, in get_blockchain_state
File “chia/consensus/blockchain.py”, line 157, in get_peak
File “chia/consensus/blockchain.py”, line 674, in height_to_block_record
File “chia/consensus/blockchain.py”, line 670, in block_record
KeyError: b’\xd7\x80\xd2,z\x87\xc9\xe0\x1d\x98\xb4\x9a\t\x10\xf6p\x1c;\x95\x01WA1k?\xda\x04.]{\x81\xd2’

Please help me, at my wits end : (

What client version are u on?
If its below .11 and you get more than 20 blocks behind you will never resync.

1.2.11, electron 14.0.1

I’m on Windows so not quite the same.
But I’m also on .11, managed to see that sane 0/ 1445**** last night.
I replaced my db with a good one from a week earlier and instantly started to sync.

So if you have a good backup thats maybe worth a try.

I don’t have a backup old enough to restore to a stable version.

I see a lot of posts talking about deleting the DB and resyncing from scratch. Can you help me understand which DB i would delete, like the specific file?

Thank you

Sure, look in the database folder, there will be a cpl of sqlite files.

Incase it’s not that corrupted, I’d copy that to somewhere else rather than a straight delete.
Then delete it from the database folder.

It’s the biggest file in that folder blockchain_v1_mainnet.sqlite

Do you know where the db ( database ) folder is located?
It’s in the sane folder that your log folder is in.

You could try downloading it as is mentioned in this post.

When you say database, does this mean the wallet DB or is that separate?

Also stupid question but will deleting the DB remove any blocks ive won?

Finally, do I have to do anything to recreate the DB or do i just simply open chia?

Thank you

The wallet db is separate.
You can copy that somewhere else also, and once your other db is sorted move it back.

Don’t worry, any coin you own is safe so long as you have your mnemonic.

You won’t see them in the wallet until your wallet db is synced to the point you got those coins, but they are safely stored on the blockchain and won’t get lost

You just need to delete the db and restart chia to sync from scratch.
Or
Download the database from that link I shared from the other post, and put that in the db folder and restart chia.
( this will be much much faster as they regularly update the backups)

Make sure chia is not running when you mess with those folders and all chia processes are ended.