Chia Error : Not farming any plots on this harvester / Cannot operate on a closed database

Support
1

Hello ChiaForum Support,

I’m new to CHIA so apologies upfront if I “f” this up a bit as its first time go.

I’ve setup a simple rig to test Chia, get use to it before I spend $$ on a larger rig. All seems to be running as a the Node has oved to Syncing but stuck at this stats for about 3 days.

Attached is a run down of the hardware, software, script checks I’ve done and also the error from the debug file. I’ve checked a heap of forums for hours but now stuck.

I hope the details further below my name (RedPillAussie) show all the necessary details of my setup and the tested outcomes and errors I’m getting, if one of the experts could review and provide feedback would be fantastic help…

Bottom line summary is ;

a) I have a file on my NAS that is now .plot
b) Node is Syncing not Sync’d ( running for 3 days now)
c) Wallet = Not Synced
d) Plots = Syncing
e) Farm = None of your plots have passed the plot filter yet. But you are currently farming 101.4 GiB
f) Harvester Network = 127.0.0.1 (only one connected is me)
g) Your Full Node Connection = 127.0.0.1 (only one connected is me)

Would really appreciate anyone who has come across this issue as I’m bit reticent to reboot or such and lose all the work to get to this point.

Cheers
RedPillAussie

Hardware / Software Setup :

  1. SSD 500GB
  2. Memory 8.00 GB
  3. Intel(R) Core™ i7-6500U CPU @ 2.50GHz 2.59 GHz
  4. Windows 10 Home
  5. CHIA Version v1.2.3

What I’ve setup / checked:

  1. Chia Temp Directory to local SSD
  2. Secondary Directiry to external NAS wih 4TB allocated.
  3. Checked and resync’d date/time on computer to make syre it matches local timezone.
  4. Checked Port 8444 - shows Port 8444 open running https://portchecker.co/

What Chia GUI is showing:

FULL NODE OVERVIEW

  1. Syncing 558,xxx/702,xxx
  2. Network name : mainnet
  3. Connection Status - Connected
  4. Difficulty - 2,384
  5. Blocks activity - seem to be running ok
    Connections :
    0xaf4d83b89695xxxxxxx 127.0.0.1 49867/8447 0/0 Farmer
    0xfbd282f31535fxxxxxxxx 127.0.0.1 49878/8449 2,006.8/0.6 Wallet
    0xb1904aae5a5cxxxxxxxxx 112.172.210.172 8444/8444 0.2/2,486.5 Full Node 709,757
    (There are more connections but very litle to no activity)

WALLET
Wallet Status: Not Synced (559,xxx)
Total Balance - 0 XCH
(I’ve requested a chia from https://faucet.chia.net/reques) = Accepted. Your request is in the queue and will be processed in the order it was received.

HARVESTER PLOTS
Status = Syncing
K-32, 101.4 GiB

FARM
Farm Status = Syncing
Plot Count = 1
Total Size of Plots = 101.4 GiB
XCH Total Chia Farmed = 0
Last Height Farmed = 0 No blocks farmed yet
Last Attempted Proof = None of your plots have passed the plot filter yet. But you are currently farming 101.4 GiB
Latest Block Challenges = (nothing showing at all)
Your Full Node Connection = 127.0.0.1 8444/8444 0/0 (Connection Status: Connected)
Your Harvester Network = 127.0.0.1 49849/8448 11.3/248.2 (Connection Status: Connected)

PLOT files:

  1. The Chia software was running o.k for about 2 days, the .2.chia.tmp file was created on my secondary directory and has now moved to .plot
  2. the TMP files that were being processed to the temporary chia file directory were running but nothing has processed through this since the file on the secondary directory went to .plot status

Some of the commands scripts I’ve run to test the system :

PS C:\WINDOWS\system32> chia init
Chia directory C:\Users\xxxxxx.chia\mainnet
C:\Users\xxxxxx.chia\mainnet already exists, no migration action taken

PS C:\WINDOWS\system32> chia wallet show
Wallet height: 555xxx
Sync status: Not synced
Balances, fingerprint: 334xxxxxxxxx
Wallet ID 1 type STANDARD_WALLET Chia Wallet
-Total Balance: 0.0 xch (0 mojo)
-Pending Total Balance: 0.0 xch (0 mojo)
-Spendable: 0.0 xch (0 mojo)

PS C:\WINDOWS\system32> chia show -s
Current Blockchain Status: Syncing 555xxx/702xxx.
Peak: Hash: ebc90bb18cxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Time: Sun Jul 11 2021 18:31:40 AUS Eastern Standard Time Height: 555xxx

Estimated network space: 30.449 EiB
Current difficulty: 2272
Current VDF sub_slot_iters: 120xxxxxxx
Total iterations since the start of the blockchain: 18736xxxxxxxxx

Height: | Hash:
555796 | ebc90bb1xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555795 | 44cec08exxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555794 | 9796a8fbxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555793 | 076c1ebxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555792 | 8ee242dxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555791 | 72ec508xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555790 | 6352bd4xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555789 | 9279f7bxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555788 | c270b3xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
555787 | dd728bxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

PS C:\WINDOWS\system32> chia farm summary
Farming status: Syncing
Total chia farmed: 0.0
User transaction fees: 0.0
Block rewards: 0.0
Last height farmed: 0
Local Harvester
1 plots of size: 101.400 GiB
Plot count for all harvesters: 1
Total size of plots: 101.400 GiB
Estimated network space: 30.431 EiB
Expected time to win: 189 years and 7 months
Note: log into your key using ‘chia wallet show’ to see rewards for each key

ERROR LOG FROM RUNNING DEBUG under CHIA:
2021-08-11T07:05:55.549 wallet chia.wallet.wallet_node : WARNING No keys present. Create keys with the UI, or with the ‘chia keys’ program.
2021-08-11T07:06:27.675 full_node chia.full_node.full_node: WARNING querying DNS introducer failed: The DNS operation timed out after 30.011899709701538 seconds
2021-08-11T07:07:47.688 full_node chia.full_node.full_node: WARNING querying DNS introducer failed: The DNS operation timed out after 30.005048751831055 seconds
2021-08-11T07:10:12.804 full_node chia.full_node.full_node: ERROR Error with syncing: <class ‘RuntimeError’>Traceback (most recent call last):
File “chia\full_node\full_node.py”, line 669, in _sync
RuntimeError: Weight proof did not arrive in time from peer: 118.233.148.41

2021-08-11T07:29:00.630 wallet asyncio : ERROR Task exception was never retrieved
future: <Task finished name=‘Task-214’ coro=<WalletPeers.ensure_is_closed() done, defined at chia\server\node_discovery.py:701> exception=AttributeError("‘WalletPeers’ object has no attribute ‘connection’")>
Traceback (most recent call last):
File “chia\server\node_discovery.py”, line 704, in ensure_is_closed
File “chia\server\node_discovery.py”, line 118, in _close_common
AttributeError: ‘WalletPeers’ object has no attribute ‘connection’
2021-08-12T00:29:07.543 harvester chia.harvester.harvester: WARNING Not farming any plots on this harvester. Check your configuration.
2021-08-12T10:56:50.212 harvester chia.harvester.harvester: WARNING Not farming any plots on this harvester. Check your configuration.
2021-08-12T11:01:54.469 full_node chia.full_node.full_node: WARNING Received unsolicited/late block from peer {‘host’: ‘75.73.164.204’, ‘port’: 8444}
2021-08-12T11:04:22.346 harvester chia.harvester.harvester: WARNING Not farming any plots on this harvester. Check your configuration.
2021-08-12T11:04:29.386 wallet chia.wallet.wallet_blockchain: ERROR Error during db transaction: Cannot operate on a closed database.
2021-08-12T11:04:29.406 wallet wallet_server : ERROR Exception: Cannot operate on a closed database., None. Traceback (most recent call last):
File “chia\server\server.py”, line 528, in wrapped_coroutine
File “chia\wallet\wallet_node_api.py”, line 49, in new_peak_wallet
File “chia\wallet\wallet_node.py”, line 462, in new_peak_wallet
File “chia\wallet\wallet_node.py”, line 514, in wallet_short_sync_backtrack
File “chia\wallet\wallet_node.py”, line 417, in complete_blocks
File “chia\wallet\wallet_blockchain.py”, line 233, in receive_block
File “chia\util\db_wrapper.py”, line 19, in begin_transaction
File “aiosqlite\core.py”, line 184, in execute
File “aiosqlite\core.py”, line 129, in _execute
File “aiosqlite\core.py”, line 102, in run
sqlite3.ProgrammingError: Cannot operate on a closed database.

2021-08-12T11:04:29.415 wallet wallet_server : ERROR Exception: Cannot operate on a closed database. <class ‘sqlite3.ProgrammingError’>, closing connection None. Traceback (most recent call last):
File “chia\server\server.py”, line 538, in api_call
File “asyncio\tasks.py”, line 442, in wait_for
File “chia\server\server.py”, line 535, in wrapped_coroutine
File “chia\server\server.py”, line 528, in wrapped_coroutine
File “chia\wallet\wallet_node_api.py”, line 49, in new_peak_wallet
File “chia\wallet\wallet_node.py”, line 462, in new_peak_wallet
File “chia\wallet\wallet_node.py”, line 514, in wallet_short_sync_backtrack
File “chia\wallet\wallet_node.py”, line 417, in complete_blocks
File “chia\wallet\wallet_blockchain.py”, line 233, in receive_block
File “chia\util\db_wrapper.py”, line 19, in begin_transaction
File “aiosqlite\core.py”, line 184, in execute
File “aiosqlite\core.py”, line 129, in _execute
File “aiosqlite\core.py”, line 102, in run
sqlite3.ProgrammingError: Cannot operate on a closed database.

2021-08-12T11:23:22.939 harvester chia.harvester.harvester: WARNING Not farming any plots on this harvester. Check your configuration.
2021-08-12T19:23:31.114 full_node full_node_server : WARNING Invalid handshake with peer {‘host’: ‘181.231.209.199’, ‘port’: 6899}. Maybe the peer is running old software.
2021-08-12T21:28:58.164 full_node full_node_server : WARNING Cannot write to closing transport 110.82.19.137
2021-08-13T02:13:28.337 full_node full_node_server : WARNING Cannot write to closing transport 37.130.78.11
2021-08-13T02:26:08.383 full_node full_node_server : WARNING Banning 171.42.253.179 for 10 seconds
2021-08-13T02:26:08.383 full_node full_node_server : WARNING Invalid handshake with peer. Maybe the peer is running old software.
2021-08-13T05:17:02.127 full_node chia.full_node.full_node: WARNING Received unsolicited/late block from peer {‘host’: ‘222.128.183.156’, ‘port’: 8444}
2021-08-13T11:35:39.221 full_node full_node_server : WARNING Banning 115.218.71.101 for 10 seconds
2021-08-13T11:35:39.221 full_node full_node_server : WARNING Invalid handshake with peer. Maybe the peer is running old software.
2021-08-13T14:30:04.116 full_node full_node_server : WARNING Banning 171.212.128.204 for 10 seconds
2021-08-13T14:30:04.116 full_node full_node_server : WARNING Invalid handshake with peer. Maybe the peer is running old software.
2021-08-13T15:41:18.031 full_node chia.full_node.full_node: WARNING Received unsolicited/late block from peer {‘host’: ‘60.191.137.230’, ‘port’: 8444}
2021-08-13T19:39:38.204 full_node full_node_server : WARNING Was not able to get peername from 54.184.182.118 - closing connection

2

So I didn’t read your whole story but a few things from the start.

Syncing the blockchain can take a long time (days) as long as it is not synced, nothing else works.
Wallet will not sync, plots will not sync.

Some people claim to do it in under a day, I have no idea how but there are a few tips.

  • open port 8444 on your router
  • don;t farm on a NAS, or if you do find out how to do it because it it know to have issues.
  • manually add more peers to the connection list in the Chia app
  • If the main blockchain does not make any porogress for too long, close the app, delete the db files and start the app again.
    (/.chia/mainnet/db/)
3

Thanks Voodoo - much appreciated mate - my port 8444 is open. I heard the NAS can cause time issues so I need to check it out more.

I’ll add more peers as you’ve noted.

BTW: If I delete the db files and start app again , will this wipe out everything so I’m starting from day zero or will it ick up from when I restarted the app?

Cheers RPA.

4

Hm, this is actually a problem. :thinking:

This is saying that the Chia software didn’t detect your keys, which is surprising because how did you make the plot without them?

Did you generate a 24 word mnemonic?

Or was this error from before you started plotting? (Time stamp says 11th Aug 7:05am)

1 Like
5

start from scratch…

6

Hi uChiaFarmer - Yeah its weird, I have a .plot file on my NAS, Status PLOT so looks all o.k there.

It looks like I’m Farming but no Wallet Sync?? Under Full Node, its still creating blocks and finishing them. I also thought my Chia key might need to be reinstated so I generated a new one, however when I go to KEYS in the Chia Console it now has two! , perhaps I should delete the one I manually created. Bit new to this but learning fast.

From the beginning: I generated Private Key (green button) from the beginning to create the seed wallet 24 phrases. I then simply kept going with the install and setup. Not sure why its maybe not detected my keys?

  1. I have a wallet address e.g xch1gxxxxxxxxxxxxxxxxxxxxxxxxxxx
  2. Under the PLOT I have a plot key 0x8f0xxxxxxxxxxxxxxxxxxxxx
  3. I have a pool key 0x807xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
  4. I also have a ; Private Key, Public Key, Farmer Public Key, Pool Public Key, Seed (which is the 24 wallet phrases)

I’ve not done the import from mnemonics at the beginning of my setup, I just selected the CREATE A NEW PRIVATE KEY

Perhaps I missed a step and need to now manually enter a new Chia key ?

Bit lost and going in circles.

cheers
RPA

7

AH bugger ! I’ll try to get it working and if all else fails :frowning:

8

Right now I’m suspecting that this error is from when you first loaded the Chia program, before you generated keys.

Your wallet won’t finish syncing until your node is fully sync’d.

It looks like its syncing…

It looks like its currently up to 559000, which is a good sign, hopefully it’ll keep going up until it has caught up to current height of … 710298 (as of now). But keep an eye on it and make sure that number is increasing.

9

Sorry forgot to add, I didn’t see any errors as it was all just running and syncing, under harvest plots it started from 1%, about two days later the progress bar went orange and had Syncing status. I noticed the statuses were still

Node (Syncing)
Wallet (Not Synced)
Farm (Syncing)

I did the debug dump today - the Chia setup I started back on the 11th Aug.

Hope this helps.

Cheers
RPA

10

Thanks uChiaFarmer, I’ll feel like an idiot if its just a matter of time and it’ll then get to Synced status.

At the moment the Peak Height has gone up to 587,700 so its increasing all the time.

Its now 588,308 in just a matter of 5mins so hopefully a good sign.

I’ll add some more peers too as some of the ones connected have done zero work.

Thanks again for your expert advise and guidance.

Cheers
RPA

11

Considering downloading the node database so you can skip most of the sync. Otherwise it takes forever.