Bug report #20331

DB Manager - error editing an SQLite query - single threads

Added by Chris York over 1 year ago.

Status:Open
Priority:Normal
Assignee:-
Category:DB Manager
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

Description

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.


Related issues

Duplicated by QGIS Application - Bug report #21028: DB manager: SQLite objects created in a thread can only b... Closed 2019-01-18

History

#1 Updated by Giovanni Manghi about 1 year ago

  • Related to Bug report #21028: DB manager: SQLite objects created in a thread can only be used in that same thread added

#2 Updated by Alessandro Pasotti about 1 year ago

  • Related to deleted (Bug report #21028: DB manager: SQLite objects created in a thread can only be used in that same thread)

#3 Updated by Alessandro Pasotti about 1 year ago

  • Duplicated by Bug report #21028: DB manager: SQLite objects created in a thread can only be used in that same thread added

Also available in: Atom PDF