ADI10HERO / ADI10HERO/SkiSyAI

SQLite objects created in a thread can only be used in that same thread bug

Open
#11 0 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.