Re: [sqlite] sqlite3 hangs on query

On 15/02/2017 23:36, Richard Hipp wrote: On 2/15/17, Richard Hipp wrote: It is an optimization opportunity, not a bug. That optimization is now on trunk. Very cool! Thanks, - Heiner ___ sqlite-users mailing list

Re: [sqlite] sqlite3 hangs on query

On 2/15/17, Richard Hipp wrote: > > It is an optimization opportunity, not a bug. > That optimization is now on trunk. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] sqlite3 hangs on query

On 2/15/17, Simon Slavin wrote: > select * from albums, album_asset, cacheReferences, coreInfo, space limit 1; > > It’s using 100% CPU time (on a multicore CPU). It is still a 5-way join. It will terminate after looking at all 20,318,172,864 possible combinations of

Re: [sqlite] sqlite3 hangs on query

On 2/15/2017 1:53 PM, Jens-Heiner Rechtien wrote: Please try the following with the restored database: The query *select * from albums, album_asset, cacheReferences, coreInfo, space limit 1;* will hang as well. Ah, interesting. space is empty, which is what makes the difference. In the query

Re: [sqlite] sqlite3 hangs on query

On 15 Feb 2017, at 6:53pm, Jens-Heiner Rechtien wrote: > Please try the following with the restored database: > > The query > *select * from albums, album_asset, cacheReferences, coreInfo, space limit 1;* > will hang as well. > > The query > *select * from albums,

Re: [sqlite] sqlite3 hangs on query

Hi SQLite team, sorry for replaying to my own email, the subscription to this list came only just through (got eaten by my SPAM folder), so I had to read your friendly replies via the list archive. @Simon: thanks for pointing out that attachments do not work on the list. I should have known

Re: [sqlite] sqlite3 hangs on query

- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Richard Hipp Gesendet: Dienstag, 14. Februar 2017 17:04 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] sqlite3 hangs on query On 2/14/17, Igor Tandet

Re: [sqlite] sqlite3 hangs on query

On 2/14/17, Igor Tandetnik wrote: > On 2/14/2017 7:33 AM, Jens-Heiner Rechtien wrote: >> please consider the attached dump of a sqlite3 database and the >> following - admittedly nonsensical, don't ask - query over a restored >> version of the database: >> >> *SELECT count(*)

Re: [sqlite] sqlite3 hangs on query

On 2/14/2017 7:33 AM, Jens-Heiner Rechtien wrote: please consider the attached dump of a sqlite3 database and the following - admittedly nonsensical, don't ask - query over a restored version of the database: *SELECT count(*) FROM spacefavorite, album_asset, albums, assetProfileLinks,

Re: [sqlite] sqlite3 hangs on query

Jens-Heiner Rechtien wrote: > SELECT count(*) > FROM spacefavorite, album_asset, albums, assetProfileLinks, > avatarCacheReferences, > cacheReferences, comment, conflicts, coreInfo, coreMD5, errors, flags, > importSource, missingBinariesOnOz, profileRegistration, quota_exceeded, >

Re: [sqlite] sqlite3 hangs on query

On 14 Feb 2017, at 12:33pm, Jens-Heiner Rechtien wrote: > please consider the attached dump of a sqlite3 database and the following - > admittedly nonsensical, don't ask - query over a restored version of the > database Jens, You can’t send attachments to this list. If

[sqlite] sqlite3 hangs on query

Hi SQLite team, please consider the attached dump of a sqlite3 database and the following - admittedly nonsensical, don't ask - query over a restored version of the database: *SELECT count(*) FROM spacefavorite, album_asset, albums, assetProfileLinks, avatarCacheReferences, cacheReferences,

Re: [sqlite] sqlite3 hangs

On 19/09/14 17:40, Bokassa wrote: > Hi all, > I see my query hanging with this stack: > > dybagme->where > #0 0x00332b00ee00 in __fsync_nocancel () from /lib64/libpthread.so.0 > #1 0x0041b418 in full_fsync (fd=6, fullSync=0, dataOnly=0) at > sqlite3.c:27735 ... > The program

[sqlite] sqlite3 hangs

Hi all, I see my query hanging with this stack: dybagme->where #0 0x00332b00ee00 in __fsync_nocancel () from /lib64/libpthread.so.0 #1 0x0041b418 in full_fsync (fd=6, fullSync=0, dataOnly=0) at sqlite3.c:27735 #2 0x0041b54c in unixSync (id=0x2315650, flags=2) at

Re: [sqlite] sqlite3 hangs

On 11/05/2008 03:35 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Michael Muratet wrote: >>> I guess I'm not making my myself clear. I only have one installed >>> version. > > That is not true. If it was true then you wouldn't have ended up with > 3.3.6 being

Re: [sqlite] sqlite3 hangs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Muratet wrote: >> I guess I'm not making my myself clear. I only have one installed >> version. That is not true. If it was true then you wouldn't have ended up with 3.3.6 being reported as a version in places! You may think you only have

Re: [sqlite] sqlite3 hangs

On Nov 4, 2008, at 5:21 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Michael Muratet wrote: >> I built sqlite >> from the aggregate code but my python project hangs. > > There is a specific mailing list for Python with SQLite - see >

Re: [sqlite] sqlite3 hangs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Muratet wrote: > I built sqlite > from the aggregate code but my python project hangs. There is a specific mailing list for Python with SQLite - see http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite > So, I tried to >

[sqlite] sqlite3 hangs

Greetings I have been trying to get sqlite-3.6.4 to work for a python project I'm building on a Dell eight-core running RedHat ES3. I built sqlite from the aggregate code but my python project hangs. So, I tried to use it from the command line and noticed that the version was 3.3.6. It