In my experience, the queries in Mixxx do block. That's how this assertion was
hit in the first place.
It appears that a table can have multiple simultaneous readers, but only one
writer, and readers are blocked while there's a writer.
I suppose this could be an issue with how sqlite is built on different
platforms, with different options and whatnot, but that would be pretty
unsettling. I'm running Mixxx on Fedora Core 17.
________________________________
From: RJ Ryan <[email protected]>
To: Steven Boswell II <[email protected]>
Cc: "[email protected]" <[email protected]>
Sent: Friday, April 12, 2013 8:57 AM
Subject: Re: [Mixxx-devel] Hello, and some patches
The queries don't block (well, you can configure them to busy-wait for a set
number of seconds at the Qt SQL driver level but we don't) but in general we
don't want blocking because if we block the Qt main thread then the whole GUI
will stall while the library scanner is scanning. Today we just see the queries
fail complaining the database is locked when this problem presents itself.
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Get Mixxx, the #1 Free MP3 DJ Mixing software Today
http://mixxx.org
Mixxx-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mixxx-devel
