Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #61662

Re: Strange crashes

Show all headers | View raw

On Thu, Dec 12, 2013 at 4:25 PM, Igor Korot <ikorot01@gmail.com> wrote:
> ProgrammingError: SQLite objects created in a thread can only be used
> in that same thread.The object was created in thread id 14260 and this
> is thread id 9264
>
> Where should I start looking for causes?

Well, I'd look for something that creates an SQLite object on one
thread and uses it on another :)

More generally, your issue is probably due to sharing things across
threads that shouldn't be shared. That's going to give all sorts of
race conditions that you might never be able to replicate - the exact
order of operations might depend on any number of factors, even stuff
you wouldn't expect to have ANY significance like the speed of your
hard drive. The fact that it works on your system is indicative of
luck.

See if you can avoid *any* mutable globals in your thread handlers, or
if you can't achieve that, have a good hard look at every global that
any thread other than the main thread can change. The less you have to
look at, the easier it'll be to find this sort of thing.

ChrisA

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Re: Strange crashes Chris Angelico <rosuav@gmail.com> - 2013-12-12 16:31 +1100
  Re: Strange crashes Roy Smith <roy@panix.com> - 2013-12-12 00:52 -0500

csiph-web