villebro commented on issue #25518:
URL: https://github.com/apache/superset/issues/25518#issuecomment-1753166287
@giftig I was reading through local stacktraces, and I saw this during query
execution (I see the same on both async and sync execution):
```
sqlalchemy.exc.ProgrammingError: (sqlite3.ProgrammingError) SQLite objects
created in a thread can only be used in that same thread. The object was
created in thread id 6214594560 and this is thread id 8085426944.
[SQL: UPDATE "query" SET extra_json=?, tracking_url=?, changed_on=? WHERE
"query".id = ?]
[parameters: [{'tracking_url':
'https://foobar.com/ui/query.html?20231009_144529_02675_g5bvj', 'extra_json':
'{"columns": {}, "progress": "Running statement 1 out of 1", "cancel_query":
"20231009_144529_02675_g5bvj"}', 'query_id': 1231}]]
(Background on this error at: https://sqlalche.me/e/14/f405)
```
I'm not able to try this locally with a proper metastore like Postgres, but
the fact that it's happening on Preset (which I'm sure isn't running SQLite)
would indicate to me that this is not only limited to SQLite.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
