Yea -- you can control the timeouts with the driver options and the
defaults might change from platform to platform. Maybe varying timeouts are
why the assertion failures weren't very widespread and are hard to
reproduce on some platforms? (e.g. some of the queries poll for the timeout
and succeed while some timeout and fail causing the assertion)
On Fri, Apr 12, 2013 at 12:09 PM, Steven Boswell II <[email protected]>wrote:
> 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
>
------------------------------------------------------------------------------
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
