Checking if everything is okay with my farming

snaap · June 8, 2021, 1:43pm

Hi folks. I just started to Chia plotting/farming. As for now it is around 10 days and I have 55 plots so far. Everything seems green and also 0. I’m learning how things works and just wanted someone experienced check if something is wrong or everything is wrong or not and what to do.

2 - Is there anything to show like 0.000001 Chia Farmed in this system? Seeing 0 everywhere is not very encouraging.

I attached some screenshots and a debug log full of error I try to figure out. Any help would be appreciated. Thank you.

Here is the last few lines of debug log :

2021-06-08T16:15:02.233 full_node full_node_server        : WARNING  Trying to ban localhost for 10, but will not ban
2021-06-08T16:15:02.236 full_node full_node_server        : ERROR    Exception:  <class 'concurrent.futures._base.CancelledError'>, closing connection {'host': '127.0.0.1', 'port': 8449}. Traceback (most recent call last):
  File "chia\server\server.py", line 536, in api_call
  File "asyncio\tasks.py", line 435, in wait_for
concurrent.futures._base.CancelledError

2021-06-08T16:15:02.268 full_node asyncio                 : ERROR    Task exception was never retrieved
future: <Task finished coro=<ChiaServer.incoming_api_task.<locals>.api_call() done, defined at chia\server\server.py:487> exception=CancelledError()>
concurrent.futures._base.CancelledError
2021-06-08T16:15:03.076 full_node full_node_server        : ERROR    Exception: too many SQL variables, {'host': '127.0.0.1', 'port': 8449}. Traceback (most recent call last):
  File "chia\server\server.py", line 526, in wrapped_coroutine
  File "chia\full_node\full_node_api.py", line 244, in request_proof_of_weight
  File "chia\full_node\weight_proof.py", line 77, in get_proof_of_weight
  File "chia\full_node\weight_proof.py", line 119, in _create_proof_of_weight
  File "chia\consensus\blockchain.py", line 695, in get_block_records_at
  File "chia\full_node\block_store.py", line 181, in get_block_records_by_hash
  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.OperationalError: too many SQL variables

2021-06-08T16:15:03.077 full_node full_node_server        : ERROR    Exception: too many SQL variables <class 'sqlite3.OperationalError'>, closing connection {'host': '127.0.0.1', 'port': 8449}. Traceback (most recent call last):
  File "chia\server\server.py", line 536, in api_call
  File "asyncio\tasks.py", line 442, in wait_for
  File "chia\server\server.py", line 533, in wrapped_coroutine
  File "chia\server\server.py", line 526, in wrapped_coroutine
  File "chia\full_node\full_node_api.py", line 244, in request_proof_of_weight
  File "chia\full_node\weight_proof.py", line 77, in get_proof_of_weight
  File "chia\full_node\weight_proof.py", line 119, in _create_proof_of_weight
  File "chia\consensus\blockchain.py", line 695, in get_block_records_at
  File "chia\full_node\block_store.py", line 181, in get_block_records_by_hash
  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.OperationalError: too many SQL variables

2021-06-08T16:15:03.083 full_node full_node_server        : WARNING  Trying to ban localhost for 10, but will not ban
2021-06-08T16:15:05.808 full_node asyncio                 : ERROR    Task exception was never retrieved
future: <Task finished coro=<ChiaServer.incoming_api_task.<locals>.api_call() done, defined at chia\server\server.py:487> exception=CancelledError()>
concurrent.futures._base.CancelledError

1stMiningRig.com · June 8, 2021, 2:55pm

go to: C:\Users\USERNAME.chia\mainnet\config , open config.yaml, search for “log_level:” and change it from WARNING to INFO.
wait about 10-15 minutes after doing step one then go to: C:\Users\USERNAME.chia\mainnet\log , open debug.log and search for eligible plots… should look like: “1 plots were eligible for farming” followed by more details and time response. You should have at least 1 plot eligible. if all are 0 something is going wrong. also, not really sure but response time should be under 30 seconds.

snaap · June 9, 2021, 11:24am

Thank you for response. I just edited config file and waiting for log. I will share log results to see what is going on.

snaap · June 9, 2021, 12:02pm

Just getting same lines again and again. Can’t find anything about eligible plots.

I assume this is a week ago and no new “not farming” warning since then :

2021-06-01T22:36:29.651 harvester chia.harvester.harvester: WARNING  Not farming any plots on this harvester. Check your configuration.

Those are newest ones, repeating:

2021-06-09T14:49:42.426 full_node full_node_server        : ERROR    Exception: too many SQL variables <class 'sqlite3.OperationalError'>, closing connection {'host': '127.0.0.1', 'port': 8449}. Traceback (most recent call last):
  File "chia\server\server.py", line 536, in api_call
  File "asyncio\tasks.py", line 442, in wait_for
  File "chia\server\server.py", line 533, in wrapped_coroutine
  File "chia\server\server.py", line 526, in wrapped_coroutine
  File "chia\full_node\full_node_api.py", line 244, in request_proof_of_weight
  File "chia\full_node\weight_proof.py", line 77, in get_proof_of_weight
  File "chia\full_node\weight_proof.py", line 119, in _create_proof_of_weight
  File "chia\consensus\blockchain.py", line 695, in get_block_records_at
  File "chia\full_node\block_store.py", line 181, in get_block_records_by_hash
  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.OperationalError: too many SQL variables

2021-06-09T14:49:42.427 full_node full_node_server        : WARNING  Trying to ban localhost for 10, but will not ban
2021-06-09T14:49:45.283 full_node asyncio                 : ERROR    Task exception was never retrieved
future: <Task finished coro=<ChiaServer.incoming_api_task.<locals>.api_call() done, defined at chia\server\server.py:487> exception=CancelledError()>
concurrent.futures._base.CancelledError

Ryu007 · June 9, 2021, 12:53pm

You should restart chia application after changing the log level.

snaap · June 9, 2021, 1:20pm

Thanks, I just removed everything and reinstalled, waiting for synch, following log file to understand.

As for know log file is :

2021-06-09T15:21:24.336 harvester chia.harvester.harvester: WARNING  Not farming any plots on this harvester. Check your configuration.
2021-06-09T15:21:36.315 wallet chia.rpc.wallet_rpc_api    : ERROR    error No backup on backup service
2021-06-09T16:12:18.054 daemon __main__                   : ERROR    Unexpected exception trying to send to websocket: code = 1006 (connection closed abnormally [internal]), no reason Traceback (most recent call last):
  File "websockets\protocol.py", line 838, in transfer_data
concurrent.futures._base.CancelledError

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "chia\daemon\server.py", line 187, in safe_handle
  File "websockets\protocol.py", line 555, in send
  File "websockets\protocol.py", line 812, in ensure_open
websockets.exceptions.ConnectionClosedError: code = 1006 (connection closed abnormally [internal]), no reason

Is this about synching or there is a problem?

1stMiningRig.com · June 9, 2021, 4:22pm

is it full sync now ? are the plots listed in farming tab?

snaap · June 9, 2021, 6:52pm

Still synching. More than half way. Getting those lines repeated :

2021-06-09T21:20:52.033 daemon websockets.protocol        : ERROR    Error in data transfer
Traceback (most recent call last):
  File "websockets\protocol.py", line 827, in transfer_data
  File "websockets\protocol.py", line 895, in read_message
  File "websockets\protocol.py", line 995, in read_data_frame
  File "websockets\protocol.py", line 766, in pong
  File "websockets\protocol.py", line 803, in ensure_open
websockets.exceptions.ConnectionClosedError: code = 1006 (connection closed abnormally [internal]), no reason
2021-06-09T21:35:00.817 daemon __main__                   : ERROR    Unexpected exception trying to send to websocket: code = 1006 (connection closed abnormally [internal]), no reason Traceback (most recent call last):
  File "websockets\protocol.py", line 838, in transfer_data
concurrent.futures._base.CancelledError

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "chia\daemon\server.py", line 187, in safe_handle
  File "websockets\protocol.py", line 555, in send
  File "websockets\protocol.py", line 812, in ensure_open
websockets.exceptions.ConnectionClosedError: code = 1006 (connection closed abnormally [internal]), no reason

nichtsnutz · June 9, 2021, 7:45pm

Have the same error… everything in the GUI looks ok.
No other Warnings or ERRORs in debug log…

moonhash · June 10, 2021, 3:03am

same exact error here, GUI is fine, plotman fine. sync and looks good overall but the error is spitting a lot.

only 1 chia node on my network and I havent changed anything / configs etc on my network in a month

snaap · June 10, 2021, 9:32am

Okay, after deleting everything all folders I know and re-insalling, re-synching here is the log file :

2021-06-10T11:50:11.667 harvester chia.harvester.harvester: INFO     1 plots were eligible for farming 3aafbf8134... Found 0 proofs. Time: 0.02693 s. Total 79 plots
2021-06-10T11:50:13.163 full_node chia.full_node.mempool_manager: INFO     It took 0.0029931068420410156 to pre validate transaction
2021-06-10T11:50:13.174 full_node chia.full_node.mempool_manager: INFO     add_spendbundle took 0.009973287582397461 seconds, cost 10976870 (0.1%)
2021-06-10T11:50:13.316 full_node full_node_server        : INFO     Cannot connect to host 179.34.16.24:8444 ssl:<ssl.SSLContext object at 0x000001A8E73470B8> [Connect call failed ('179.34.16.24', 8444)]
2021-06-10T11:50:13.776 full_node chia.full_node.full_node: INFO      Updated peak to height 410580, weight 128831424, hh 2f31628f5d75e330e0c015fb763381a1bb2621a73c0827fb24a059ed58d26a53, forked at 410579, rh: 1e7c824a81ba4770aacc0626e7403631d0c3516656ee0eea3bc0de2cbd66797a, total iters: 1347375248559, overflow: False, deficit: 0, difficulty: 1472, sub slot iters: 116391936, Generator size: No tx, Generator ref list size: No tx
2021-06-10T11:50:13.783 full_node chia.full_node.full_node: INFO     Block validation time: 0.3231368064880371, cost: None
2021-06-10T11:50:13.878 full_node full_node_server        : INFO     Connected with full_node {'host': '79.165.41.47', 'port': 8444}
2021-06-10T11:50:14.053 wallet chia.wallet.wallet_blockchain: INFO      Updated wallet peak to height 410580, weight 128831424,

I see a lot of 0 plots and 1 plots eligible for farming. Now what? Is it okay? Still got connection errors?

1stMiningRig.com · June 10, 2021, 1:51pm

Everything should be fine since you got at least one “1 plots were eligible”

Is the 8444 port open ?

snaap · June 10, 2021, 2:21pm

When I check it from websites like portcheck whatever it seems closed. I assume it requires static ip because despite i tried to open the port from my router it is still shows as closed? Maybe those websites doesn’t work probably I’m not sure. Is there any way to check if this port open from command line or power shell?

snaap · June 10, 2021, 2:30pm

I just tried to connect with telnet and it failed means port is not open.

1 - Is it because of dynamic IP address?
2 - What is the importance of this port?

snaap · June 11, 2021, 11:14am

I opened the port 8444 with static IP. Is there anything to pay attention after opening port or anything to do extra? Should I restart Chia?