Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sqlite3.ProgrammingError: Cannot operate on a closed database. #85

Open
nPokemon opened this issue Jul 9, 2023 · 1 comment
Open

sqlite3.ProgrammingError: Cannot operate on a closed database. #85

nPokemon opened this issue Jul 9, 2023 · 1 comment

Comments

@nPokemon
Copy link

nPokemon commented Jul 9, 2023

Any one got fixes for it ?
`Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\langchain\output_parsers\pydantic.py", line 26, in parse
return self.pydantic_object.parse_obj(json_object)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "pydantic\main.py", line 526, in pydantic.main.BaseModel.parse_obj
File "pydantic\main.py", line 341, in pydantic.main.BaseModel.init
pydantic.error_wrappers.ValidationError: 6 validation errors for LLMReactionResponse
new_plan -> index
field required (type=value_error.missing)
new_plan -> description
field required (type=value_error.missing)
new_plan -> start_time
field required (type=value_error.missing)
new_plan -> stop_condition
field required (type=value_error.missing)
new_plan -> max_duration_hrs
field required (type=value_error.missing)
new_plan -> location_name
field required (type=value_error.missing)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\langchain\output_parsers\fix.py", line 31, in parse
parsed_completion = self.parser.parse(completion)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\langchain\output_parsers\pydantic.py", line 31, in parse
raise OutputParserException(msg)
langchain.schema.OutputParserException: Failed to parse LLMReactionResponse from completion {
"reaction": "continue",
"thought_process": "Since my current plan is to compile a comprehensive research report on cryptocurrencies, and there haven't been any new events that require immediate attention, I should continue with my plan.
I will proceed with gathering information and insights from my colleagues to ensure a thorough analysis of market trends, potential growth, risks, and the regulatory landscape of each cryptocurrency.",
"new_plan": {}
}. Got: 6 validation errors for LLMReactionResponse
new_plan -> index
field required (type=value_error.missing)
new_plan -> description
field required (type=value_error.missing)
new_plan -> start_time
field required (type=value_error.missing)
new_plan -> stop_condition
field required (type=value_error.missing)
new_plan -> max_duration_hrs
field required (type=value_error.missing)
new_plan -> location_name
field required (type=value_error.missing)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\langchain\output_parsers\pydantic.py", line 26, in parse
return self.pydantic_object.parse_obj(json_object)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "pydantic\main.py", line 526, in pydantic.main.BaseModel.parse_obj
File "pydantic\main.py", line 341, in pydantic.main.BaseModel.init
pydantic.error_wrappers.ValidationError: 6 validation errors for LLMReactionResponse
new_plan -> index
field required (type=value_error.missing)
new_plan -> description
field required (type=value_error.missing)
new_plan -> start_time
field required (type=value_error.missing)
new_plan -> stop_condition
field required (type=value_error.missing)
new_plan -> max_duration_hrs
field required (type=value_error.missing)
new_plan -> location_name
field required (type=value_error.missing)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\main.py", line 47, in run_world_async
await world.run()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\world\base.py", line 113, in run
await asyncio.gather(*tasks)
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\world\base.py", line 101, in run_agent_loop
await self.run_next_agent()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\world\base.py", line 96, in run_next_agent
await agent.run_for_one_step()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\agent\base.py", line 1061, in run_for_one_step
self.react_response = await self._react(events)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\agent\base.py", line 846, in _react
parsed_reaction_response: LLMReactionResponse = reaction_parser.parse(response)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\langchain\output_parsers\fix.py", line 38, in parse
parsed_completion = self.parser.parse(new_completion)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\langchain\output_parsers\pydantic.py", line 31, in parse
raise OutputParserException(msg)
langchain.schema.OutputParserException: Failed to parse LLMReactionResponse from completion {
"reaction": "continue",
"thought_process": "I should continue with my current plan because there haven't been any new developments that require a change in strategy. I will proceed with my tasks and monitor the situation for any updates.",
"new_plan": {}
}. Got: 6 validation errors for LLMReactionResponse
new_plan -> index
field required (type=value_error.missing)
new_plan -> description
field required (type=value_error.missing)
new_plan -> start_time
field required (type=value_error.missing)
new_plan -> stop_condition
field required (type=value_error.missing)
new_plan -> max_duration_hrs
field required (type=value_error.missing)
new_plan -> location_name
field required (type=value_error.missing)

Exception ignored in: <coroutine object World.run_agent_loop at 0x000002026C019FC0>
Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\world\base.py", line 101, in run_agent_loop
await self.run_next_agent()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\world\base.py", line 96, in run_next_agent
await agent.run_for_one_step()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\agent\base.py", line 1053, in run_for_one_step
events = await self.observe()
^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\agent\base.py", line 983, in observe
(events, _) = await self.context.events_manager.get_events(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\event\base.py", line 234, in get_events
await self.refresh_events()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\event\base.py", line 190, in refresh_events
async with self.refresh_lock:
File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64__qbz5n2kfra8p0\Lib\asyncio\locks.py", line 21, in aexit
self.release()
File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64__qbz5n2kfra8p0\Lib\asyncio\locks.py", line 138, in release
self._wake_up_first()
File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64__qbz5n2kfra8p0\Lib\asyncio\locks.py", line 155, in _wake_up_first
fut.set_result(True)
File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64__qbz5n2kfra8p0\Lib\asyncio\base_events.py", line 761, in call_soon
self._check_closed()
File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64__qbz5n2kfra8p0\Lib\asyncio\base_events.py", line 519, in _check_closed
raise RuntimeError('Event loop is closed')
RuntimeError: Event loop is closed
Exception ignored in: <coroutine object World.run_agent_loop at 0x000002026C01A2C0>
Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\world\base.py", line 101, in run_agent_loop
await self.run_next_agent()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\world\base.py", line 96, in run_next_agent
await agent.run_for_one_step()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\agent\base.py", line 1077, in run_for_one_step
if await self._should_reflect():
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\agent\base.py", line 372, in _should_reflect
data = await (await get_database()).get_should_reflect(str(self.id))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd\src\utils\database\sqlite.py", line 97, in get_should_reflect
async with self.client.execute(
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\aiosqlite\context.py", line 44, in aexit
await self._obj.close()
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\aiosqlite\cursor.py", line 80, in close
await self._execute(self._cursor.close)
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\aiosqlite\cursor.py", line 40, in _execute
return await self._conn._execute(fn, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\aiosqlite\core.py", line 126, in _execute
raise ValueError("Connection closed")
ValueError: Connection closed
Future exception was never retrieved
future: <Future finished exception=ProgrammingError('Cannot operate on a closed database.')>
Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\aiosqlite\core.py", line 106, in run
result = function()
^^^^^^^^^^
sqlite3.ProgrammingError: Cannot operate on a closed database.
Future exception was never retrieved
future: <Future finished exception=ProgrammingError('Cannot operate on a closed database.')>
Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\aiosqlite\core.py", line 106, in run
result = function()
^^^^^^^^^^
sqlite3.ProgrammingError: Cannot operate on a closed database.
Future exception was never retrieved
future: <Future finished exception=ProgrammingError('Cannot operate on a closed database.')>
Traceback (most recent call last):
File "C:\Users\Autogpt\Desktop\GPTeam-2nd.venv\Lib\site-packages\aiosqlite\core.py", line 106, in run
result = function()
^^^^^^^^^^
sqlite3.ProgrammingError: Cannot operate on a closed database.`

@MiracleZeroPenguin
Copy link

I encountered the same problem.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants