Bug report #20331
DB Manager - error editing an SQLite query - single threads
|Affected QGIS version:||3.4.0||Regression?:||No|
|Operating System:||Windows 10||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||28152|
When trying to execute queries on a Geopackage database I get the following message if I try to edit the query:
SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 3948 and this is thread id 13664.
This means that the query has to be perfect before attempting to execute it - so no way to heuristically check the syntax. It also occurs if I execute a query first and then try to load as layer. This means that it is not possible to check the outcome of the query before adding to the canvas.
The work around is to close the DB manager and start again, but this seems like a regression / inconvenience (retype or cut / paste required each time) although the unspecified errors that I was getting in 3.2.3 may have been this issue.