abce
abce copied to clipboard
Issues with database and threading
I am facing the following issue in both macOS 14.0 (M1)
and Ubuntu 22.04.3 LTS
.
(abce) jaime@OptiPlex-7000:~/Documents
$ pypy3
pypy3: /home/jaime/miniconda3/envs/abce/bin/../lib/./libtinfow.so.6: no version information available (required by /home/jaime/miniconda3/envs/abce/bin/../lib/libpypy3.9-c.so)
Python 3.9.18 | packaged by conda-forge | (c5262994, Oct 26 2023, 08:28:20)
[PyPy 7.3.13 with GCC 12.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>>> import abcEconomics as abce
>>>> simulation = abce.Simulation()
>>>> Exception in thread Thread-1:
Traceback (most recent call last):
File "/home/jaime/miniconda3/envs/abce/lib/pypy3.9/threading.py", line 980, in _bootstrap_inner
self.run()
File "/home/jaime/miniconda3/envs/abce/lib/pypy3.9/site-packages/abcEconomics/logger/db.py", line 74, in run
self.dataset_db.query('PRAGMA synchronous=OFF')
File "/home/jaime/miniconda3/envs/abce/lib/pypy3.9/site-packages/dataset/persistence/database.py", line 287, in query
return ResultIter(self.executable.execute(query, **kw),
File "/home/jaime/miniconda3/envs/abce/lib/pypy3.9/site-packages/dataset/persistence/util.py", line 66, in __init__
self.keys = list(result_proxy.keys())
File "/home/jaime/miniconda3/envs/abce/lib/pypy3.9/site-packages/sqlalchemy/engine/result.py", line 906, in keys
return self._metadata.keys
File "/home/jaime/miniconda3/envs/abce/lib/pypy3.9/site-packages/sqlalchemy/engine/cursor.py", line 1366, in keys
self._we_dont_return_rows()
File "/home/jaime/miniconda3/envs/abce/lib/pypy3.9/site-packages/sqlalchemy/engine/cursor.py", line 1338, in _we_dont_return_rows
raise exc.ResourceClosedError(
sqlalchemy.exc.ResourceClosedError: This result object does not return rows. It has been closed automatically.