SQLite objects created in a thread can only be used in that same thread bug
- Dominant language
- CSS
- Stars
- 4
- Forks
- 2
- PR merge metrics
- No merged PRs in 30d
Description
Steps to reproduce:
1. Start the app using python app.py
2. Create a new case
When you check the logs u will see something like this:
```
Traceback (most recent call last):
File "D:\Softwares\Anaconda\envs\test\lib\site-packages\sqlalchemy\pool\base.py", line 697, in _finalize_fairy
fairy._reset(pool)
File "D:\Softwares\Anaconda\envs\test\lib\site-packages\sqlalchemy\pool\base.py", line 893, in _reset
pool._dialect.do_rollback(self)
File "D:\Softwares\Anaconda\envs\test\lib\site-packages\sqlalchemy\engine\default.py", line 543, in do_rollback
dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5924 and this is thread id 15648.
Exception closing connection
Traceback (most recent call last):
File "D:\Softwares\Anaconda\envs\test\lib\site-packages\sqlalchemy\pool\base.py", line 697, in _finalize_fairy
fairy._reset(pool)
File "D:\Softwares\Anaconda\envs\test\lib\site-packages\sqlalchemy\pool\base.py", line 893, in _reset
pool._dialect.do_rollback(self)
File "D:\Softwares\Anaconda\envs\test\lib\site-packages\sqlalchemy\engine\default.py", line 543, in do_rollback
dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5924 and this is thread id 15648.
```
Above bug is not affecting the execution of the app (no effects seen directly) but surely these things become a pain in the long run :D
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.