search

101dotxyz / GPTeam

GPTeam: An open-source multi-agent simulation
https://www.gpteamai.com/
MIT License
1.65k stars 253 forks source link

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

Open nPokemon opened 1 year ago

nPokemon commented 1 year ago

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_onestep 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_x64qbz5n2kfra8p0\Lib\asyncio\locks.py", line 21, in aexit self.release() File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.1264.0_x64qbz5n2kfra8p0\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_x64qbz5n2kfra8p0\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_x64qbz5n2kfra8p0\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_x64qbz5n2kfra8p0\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 commented 1 year ago

I encountered the same problem.

caseyrandazzo commented 2 weeks ago

I also received this error and this is what worked for me: I ran poetry run db-reset between each run (despite not changing the config file) to clear the initial memory because it was causing this error and others. That worked for me since I was seeking to compare events across runs. I didn't see the error after that.