I am seeing this in the HA log file. As far as I can tell, it is causing no issues, no loss of functionality or anything of the sort, but clearly, something has gone wrong with something, I am just not sure what.
16-08-31 07:04:49 sqlalchemy.pool.NullPool: Exception during reset or similar
Traceback (most recent call last):
File "/home/hass/.homeassistant/deps/sqlalchemy/pool.py", line 636, in _finalize_fairy
fairy._reset(pool)
File "/home/hass/.homeassistant/deps/sqlalchemy/pool.py", line 776, in _reset
pool._dialect.do_rollback(self)
File "/home/hass/.homeassistant/deps/sqlalchemy/engine/default.py", line 420, 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 1613231200 and this is thread id 1995722752
rpitera
(Robert Pitera)
August 31, 2016, 9:31pm
2
You have done it now; you’re infested with gnomes.
Seriously, the only thing I could find related was this; maybe it will point you somewhere?
opened 03:09PM - 24 Apr 16 UTC
closed 06:38PM - 21 May 16 UTC
Feature requests should go in the forum: https://community.home-assistant.io/c/f… eature-requests
**Home Assistant release (`hass --version`):**
0.18.2
**Python release (`python3 --version`):**
3.5.1
**Component/platform:**
sensor.gtfs
**Description of problem:**
I don't see any _actual_ issue here, but since I enabled the GTFS sensor, I often see in my logs a huge quantity of SQLAlchemy related errors. The component seems to be working fine (both in frontend and from automation rules), but…
**Expected:**
No error in logs
**Problem-relevant `configuration.yaml` entries and steps to reproduce:**
``` yaml
- platform: gtfs
origin: 3347699720881315
destination: 3347699720888336
data: tisseo_gtfs.zip
- platform: gtfs
origin: 3347699720888336
destination: 3347699720881315
data: tisseo_gtfs.zip
```
**Traceback (if applicable):**
``` bash
16-04-24 17:03:35 ERROR (Thread-11) [sqlalchemy.pool.NullPool] Exception during reset or similar
Traceback (most recent call last):
File "/home/kernald/.homeassistant/deps/sqlalchemy/pool.py", line 636, in _finalize_fairy
fairy._reset(pool)
File "/home/kernald/.homeassistant/deps/sqlalchemy/pool.py", line 776, in _reset
pool._dialect.do_rollback(self)
File "/home/kernald/.homeassistant/deps/sqlalchemy/engine/default.py", line 420, 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 139793715386112 and this is thread id 139792746518272
16-04-24 17:03:35 ERROR (Thread-11) [sqlalchemy.pool.NullPool] Exception closing connection <sqlite3.Connection object at 0x7f2441952c70>
Traceback (most recent call last):
File "/home/kernald/.homeassistant/deps/sqlalchemy/pool.py", line 636, in _finalize_fairy
fairy._reset(pool)
File "/home/kernald/.homeassistant/deps/sqlalchemy/pool.py", line 776, in _reset
pool._dialect.do_rollback(self)
File "/home/kernald/.homeassistant/deps/sqlalchemy/engine/default.py", line 420, 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 139793715386112 and this is thread id 139792746518272
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/kernald/.homeassistant/deps/sqlalchemy/pool.py", line 290, in _close_connection
self._dialect.do_close(connection)
File "/home/kernald/.homeassistant/deps/sqlalchemy/engine/default.py", line 426, in do_close
dbapi_connection.close()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 139793715386112 and this is thread id 139792746518272
```
**Additional info:**
LOL. Yeah, maybe, if so they are not doing much damage apparently. Thank you for th
e link @rpitera
1 Like
rpitera
(Robert Pitera)
September 1, 2016, 9:07pm
4
Best I could do - I found a few other links but they seemed so out of the loop and unrelated I didn’t bother.
Pro Tip: Leave shortbread cookies out near your Pi and then whack them with a newspaper. Gnomes can’t resist shortbread.
Well, you learn something new everyday. I will give that a shot and just take care of it that way.
bnetse
September 20, 2016, 7:19am
6
Did you find a solution to this?
I just set up a clean install of Home Assistant using the all in one installer for raspberry pi and I have this exact same error.
Currently the only thing I have modified is the lat long location and elevation in the configuration.yaml.
Nope, no solution found as of yet. But it wasn’t seemingly problematic either so it was not getting a lot of attention from me either.