v1.1.7 Many Errors in the log

[pluto2021]

2021-06-05T01:58:35.321 full_node full_node_server : ERROR Exception: too many SQL variables, {'host': 'XXX.XXX.XX.XX', 'port': 8444}. 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-05T01:58:35.391 full_node full_node_server : ERROR Exception: too many SQL variables <class 'sqlite3.OperationalError'>, closing connection {'host': 'XXX.XXX.XX.XX', 'port': 8444}. 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-05T01:58:35.398 full_node asyncio : ERROR Task exception was never retrieved
future: <Task finished coro=<ChiaServer.incoming_api_task..api_call() done, defined at chia\server\server.py:487> exception=CancelledError()>
concurrent.futures._base.CancelledError
2021-06-05T01:58:35.399 full_node full_node_server : ERROR Exception: <class 'concurrent.futures._base.CancelledError'>, closing connection {'host': 'XXX.XXX.XX.XX', 'port': 8444}. 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-05T03:38:00.452 full_node full_node_server : ERROR Exception Was not able to get peername from <function WSChiaConnection.getattr..invoke at 0x0000021857B10E58> at XXX.XXX.XX.XX, exception Stack: Traceback (most recent call last):
File "chia\server\server.py", line 248, in incoming_connection
File "chia\server\ws_connection.py", line 59, in init
ValueError: Was not able to get peername from <function WSChiaConnection.getattr..invoke at 0x0000021857B10E58> at XXX.XXX.XX.XX

[loppefaaret]

SQL errors are fixed in 1.1.7
the CancelledError, is a cahinreaction from another error, mostly just a disconnect or timeout
unable to get a peername is also a conenction problem - there is plenty of other working peers out there

[BrandtH22]

@pluto2021 , since this ticket was opened a number of years ago without further comments it seems this issue has been resolved.
We will be closing this ticket but if we have closed this ticket in error do not hesitate to reach out to us again with any followup questions or comments.

The best place to reach our support team is on Discord (https://discord.gg/chia) or by reopening this ticket.